X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=ff339929ea99b96d8f7cbed521896517d6d35ab5;hb=2f5a34ad1791f01cacb3b86c11501f0e11c67df4;hp=432ce76938d4e9f254a3091fc31402ed7e523fa4;hpb=d49895a8a10442e1a585732e94230ac51e92396d;p=friendica.git

diff --git a/database.sql b/database.sql
index 432ce76938..ff339929ea 100644
--- a/database.sql
+++ b/database.sql
@@ -206,6 +206,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `pubmail` tinyint(1) NOT NULL DEFAULT '0',
   `visible` tinyint(1) NOT NULL DEFAULT '0',
   `starred` tinyint(1) NOT NULL DEFAULT '0',
+  `bookmark` tinyint(1) NOT NULL DEFAULT '0',
   `unseen` tinyint(1) NOT NULL DEFAULT '1',
   `deleted` tinyint(1) NOT NULL DEFAULT '0',
   `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
@@ -613,3 +614,11 @@ CREATE TABLE IF NOT EXISTS `deliverq` (
 `item` INT NOT NULL ,
 `contact` INT NOT NULL
 ) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS `search` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`uid` INT NOT NULL ,
+`term` CHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+INDEX ( `uid` ),
+INDEX ( `term` )
+) ENGINE = MyISAM DEFAULT CHARSET=utf8;