From d79c3351ea6692478a490f4225ea1009863dd65f Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Fri, 10 Feb 2012 13:43:35 -0800
Subject: db installation sync

---
 database.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 8abaa5a93..0b03149e9 100755
--- a/database.sql
+++ b/database.sql
@@ -226,6 +226,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `pubmail` tinyint(1) NOT NULL DEFAULT '0',
   `moderated` tinyint(1) NOT NULL DEFAULT '0',
   `visible` tinyint(1) NOT NULL DEFAULT '0',
+  `spam` 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',
@@ -247,6 +248,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `received` (`received`),
   KEY `moderated` (`moderated`),
   KEY `visible` (`visible`),
+  KEY `spam` (`spam`),
   KEY `starred` (`starred`),
   KEY `bookmark` (`bookmark`),
   KEY `deleted` (`deleted`),
-- 
cgit v1.2.3

