aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-03-02 00:09:10 -0800
committerfriendica <info@friendica.com>2012-03-02 00:09:10 -0800
commitbe231e346658eb68e518324ba995aaccb7abd055 (patch)
tree12fa14ba29159ec4c8b473c244eba0bbb9b79a7c /database.sql
parentf55ffcd48ce5c0b3254ae1a02fda7b29d875fa09 (diff)
downloadvolse-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-xdatabase.sql2
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`),