From a76a497d924a16b8b07b126408db21655aac3bd6 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
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

