diff options
| author | friendica <info@friendica.com> | 2012-02-10 13:43:35 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-02-10 13:43:35 -0800 |
| commit | d79c3351ea6692478a490f4225ea1009863dd65f (patch) | |
| tree | 4cc9d5470c70913c0317e49b21601fd80fe7e781 /database.sql | |
| parent | b346f4464c230af4636c61397decd03eadb18e9a (diff) | |
| download | volse-hubzilla-d79c3351ea6692478a490f4225ea1009863dd65f.tar.gz volse-hubzilla-d79c3351ea6692478a490f4225ea1009863dd65f.tar.bz2 volse-hubzilla-d79c3351ea6692478a490f4225ea1009863dd65f.zip | |
db installation sync
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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`), |