diff options
| author | friendica <info@friendica.com> | 2012-03-02 00:09:10 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-03-02 00:09:10 -0800 |
| commit | be231e346658eb68e518324ba995aaccb7abd055 (patch) | |
| tree | 12fa14ba29159ec4c8b473c244eba0bbb9b79a7c /database.sql | |
| parent | f55ffcd48ce5c0b3254ae1a02fda7b29d875fa09 (diff) | |
| download | volse-hubzilla-be231e346658eb68e518324ba995aaccb7abd055.tar.gz volse-hubzilla-be231e346658eb68e518324ba995aaccb7abd055.tar.bz2 volse-hubzilla-be231e346658eb68e518324ba995aaccb7abd055.zip | |
item table update for file feature
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 806f75419..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`), |