diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/database.sql b/database.sql index 78c7d27c2..1f1f4d1d4 100644 --- a/database.sql +++ b/database.sql @@ -53,6 +53,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `self` tinyint(1) NOT NULL DEFAULT '0', `rel` tinyint(1) NOT NULL DEFAULT '0', + `duplex` tinyint(1) NOT NULL DEFAULT '0', `network` char(255) NOT NULL, `name` char(255) NOT NULL, `photo` text NOT NULL, @@ -76,6 +77,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `term-date` datetime NOT NULL DEFAUL '0000-00-00 00:00:00', `priority` tinyint(3) NOT NULL, `blocked` tinyint(1) NOT NULL DEFAULT '1', `readonly` tinyint(1) NOT NULL DEFAULT '0', @@ -131,6 +133,7 @@ CREATE TABLE IF NOT EXISTS `intro` ( `uid` int(10) unsigned NOT NULL, `contact-id` int(11) NOT NULL, `knowyou` tinyint(1) NOT NULL, + `duplex` tinyint(1) NOT NULL DEFAULT '0', `note` text NOT NULL, `hash` char(255) NOT NULL, `datetime` datetime NOT NULL, @@ -166,9 +169,10 @@ CREATE TABLE IF NOT EXISTS `item` ( `author-avatar` char(255) NOT NULL, `title` char(255) NOT NULL, `body` text NOT NULL, + `verb` char(255) NOT NULL, + `object-type` char(255) NOT NULL, + `object` text NOT NULL, `resource-id` char(255) NOT NULL, - `like` mediumtext NOT NULL, - `dislike` mediumtext NOT NULL, `tag` mediumtext NOT NULL, `location` char(255) NOT NULL, `coord` char(255) NOT NULL, |