From a76a497d924a16b8b07b126408db21655aac3bd6 Mon Sep 17 00:00:00 2001 From: friendica Date: Mon, 23 Jan 2012 20:56:11 -0800 Subject: implement "moderate" flag on items --- database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 6826aa6f8..5b7c870df 100755 --- 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`), -- cgit v1.2.3