implement "moderate" flag on items

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 6826aa6f89641010ffb721018fbc3b82d1858dea..5b7c870df9cb6d3da112cd8e3395ad694a73993f 100755 (executable)
--- a/database.sql
+++ b/database.sql
@@ -222,6 +222,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `deny_gid` mediumtext NOT NULL,
   `private` tinyint(1) NOT NULL DEFAULT '0',
   `pubmail` tinyint(1) NOT NULL DEFAULT '0',
+  `moderated` 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',
@@ -242,6 +243,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `created` (`created`),
   KEY `edited` (`edited`),
   KEY `received` (`received`),
+  KEY `moderated` (`moderated`),
   KEY `visible` (`visible`),
   KEY `starred` (`starred`),
   KEY `bookmark` (`bookmark`),