diff options
| author | Tobias Hößl <tobias@hoessl.eu> | 2012-03-09 10:00:12 +0000 |
|---|---|---|
| committer | Tobias Hößl <tobias@hoessl.eu> | 2012-03-09 10:00:12 +0000 |
| commit | 635958e11da2f5a0d587b66968453064c2d41f13 (patch) | |
| tree | 9e9b21d45551772a4aac8a54e3bafa382681ed70 /database.sql | |
| parent | 02a9fd5dc1d1d9e848e2f406f2e13c4cf0ce228b (diff) | |
| parent | 2ce78253aeda8672e12f18f0963f52cd4a35e546 (diff) | |
| download | volse-hubzilla-635958e11da2f5a0d587b66968453064c2d41f13.tar.gz volse-hubzilla-635958e11da2f5a0d587b66968453064c2d41f13.tar.bz2 volse-hubzilla-635958e11da2f5a0d587b66968453064c2d41f13.zip | |
Merge branch 'master' of git://github.com/friendica/friendica
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 8c74ecddf..35c257f02 100755 --- a/database.sql +++ b/database.sql @@ -216,6 +216,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `tag` mediumtext NOT NULL, `attach` mediumtext NOT NULL, `inform` mediumtext NOT NULL, + `file` mediumtext NOT NULL, `location` char(255) NOT NULL, `coord` char(255) NOT NULL, `allow_cid` mediumtext NOT NULL, @@ -262,6 +263,7 @@ CREATE TABLE IF NOT EXISTS `item` ( FULLTEXT KEY `title` (`title`), FULLTEXT KEY `body` (`body`), FULLTEXT KEY `tag` (`tag`), + FULLTEXT KEY `file` (`file`), FULLTEXT KEY `allow_cid` (`allow_cid`), FULLTEXT KEY `allow_gid` (`allow_gid`), FULLTEXT KEY `deny_cid` (`deny_cid`), @@ -752,14 +754,18 @@ CREATE TABLE IF NOT EXISTS `notify` ( `msg` MEDIUMTEXT NOT NULL , `uid` INT NOT NULL , `link` CHAR( 255 ) NOT NULL , +`parent` INT( 11 ) NOT NULL, `seen` TINYINT( 1 ) NOT NULL DEFAULT '0', `verb` CHAR( 255 ) NOT NULL, `otype` CHAR( 16 ) NOT NULL, INDEX ( `hash` ), INDEX ( `type` ), INDEX ( `uid` ), +INDEX ( `link` ), +INDEX ( `parent` ), INDEX ( `seen` ), -INDEX ( `date` ) +INDEX ( `date` ), +INDEX ( `otype` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `item_id` ( |