aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index c1344e6df..36a0d3f04 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -588,6 +588,10 @@ CREATE TABLE IF NOT EXISTS `item` (
`item_deleted` tinyint(1) NOT NULL DEFAULT '0',
`item_type` int(11) NOT NULL DEFAULT '0',
`item_hidden` tinyint(1) NOT NULL DEFAULT '0',
+ `item_unpublished` tinyint(1) NOT NULL DEFAULT '0',
+ `item_delayed` tinyint(1) NOT NULL DEFAULT '0',
+ `item_pending_remove` tinyint(1) NOT NULL DEFAULT '0',
+ `item_blocked` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `parent` (`parent`),
@@ -636,6 +640,10 @@ CREATE TABLE IF NOT EXISTS `item` (
KEY `item_type` (`item_type`),
KEY `item_hidden` (`item_hidden`),
KEY `item_consensus` (`item_consensus`),
+ KEY `item_unpublished` (`item_unpublished`),
+ KEY `item_delayed` (`item_delayed`),
+ KEY `item_pending_remove` (`item_pending_remove`),
+ KEY `item_blocked` (`item_blocked`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `body` (`body`),
FULLTEXT KEY `allow_cid` (`allow_cid`),