diff options
| author | Mike Macgirvin <mike@macgirvin.com> | 2010-10-05 15:39:32 -0700 |
|---|---|---|
| committer | Mike Macgirvin <mike@macgirvin.com> | 2010-10-05 15:39:32 -0700 |
| commit | 9da61d34184aa31d52c7d5da37508f1ba3770f1a (patch) | |
| tree | c10d1012ccf2b443e722f2b104c005266b55fd55 | |
| parent | 8424f31aad844b49e74e0fb7a7d197284fb67ec9 (diff) | |
| download | volse-hubzilla-9da61d34184aa31d52c7d5da37508f1ba3770f1a.tar.gz volse-hubzilla-9da61d34184aa31d52c7d5da37508f1ba3770f1a.tar.bz2 volse-hubzilla-9da61d34184aa31d52c7d5da37508f1ba3770f1a.zip | |
schema was out of date
| -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, |