diff options
| author | Fabio Comuni <fabrix.xm@gmail.com> | 2011-10-17 16:37:37 +0200 |
|---|---|---|
| committer | Fabio Comuni <fabrix.xm@gmail.com> | 2011-10-17 16:37:37 +0200 |
| commit | 2116943964e0c10984976f6d38eba044e35f983a (patch) | |
| tree | c351abcd1ccd033c36b472f73d087a8343ee638d /database.sql | |
| parent | 906addf865ccab2c98d5035fc6c1b10d43004dfe (diff) | |
| parent | 1df892ebbce59ac6293eacbe065ebc71826b4d85 (diff) | |
| download | volse-hubzilla-2116943964e0c10984976f6d38eba044e35f983a.tar.gz volse-hubzilla-2116943964e0c10984976f6d38eba044e35f983a.tar.bz2 volse-hubzilla-2116943964e0c10984976f6d38eba044e35f983a.zip | |
Merge remote-tracking branch 'friendika/master'
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 15e2f2cca..c9e239075 100644 --- a/database.sql +++ b/database.sql @@ -96,6 +96,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `info` mediumtext NOT NULL, `profile-id` int(11) NOT NULL DEFAULT '0', `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag', + `bd` date NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `self` (`self`), @@ -193,6 +194,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `object` text NOT NULL, `target-type` char(255) NOT NULL, `target` text NOT NULL, + `postopts` text NOT NULL, `plink` char(255) NOT NULL, `resource-id` char(255) NOT NULL, `event-id` int(10) unsigned NOT NULL, @@ -212,6 +214,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `bookmark` tinyint(1) NOT NULL DEFAULT '0', `unseen` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', + `origin` tinyint(1) NOT NULL DEFAULT '0', `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `guid` (`guid`), @@ -229,6 +232,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `visible` (`visible`), KEY `starred` (`starred`), KEY `deleted` (`deleted`), + KEY `origin` (`origin`), KEY `last-child` (`last-child`), KEY `unseen` (`unseen`), FULLTEXT KEY `title` (`title`), |