aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-06-15 17:28:52 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-06-15 17:28:52 -0700
commit859a2ac8ef1c3ce234b894598be846cbc89cf54a (patch)
tree05993acfb095fa16db4145ad84f4db51f377213c /install/schema_mysql.sql
parent91d92fe6fcbd98e33fb6f76a63e91ebb086aeff0 (diff)
downloadvolse-hubzilla-859a2ac8ef1c3ce234b894598be846cbc89cf54a.tar.gz
volse-hubzilla-859a2ac8ef1c3ce234b894598be846cbc89cf54a.tar.bz2
volse-hubzilla-859a2ac8ef1c3ce234b894598be846cbc89cf54a.zip
DB changes for some channel flags
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 70d142f0c..c68261caf 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -221,6 +221,8 @@ CREATE TABLE IF NOT EXISTS `channel` (
`channel_w_pages` int(10) unsigned NOT NULL DEFAULT '0',
`channel_a_republish` int(10) unsigned NOT NULL DEFAULT '0',
`channel_w_like` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_removed` tinyint(1) NOT NULL DEFAULT '0',
+ `channel_system` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`channel_id`),
UNIQUE KEY `channel_address_unique` (`channel_address`),
KEY `channel_account_id` (`channel_account_id`),
@@ -257,6 +259,8 @@ CREATE TABLE IF NOT EXISTS `channel` (
KEY `channel_a_republish` (`channel_a_republish`),
KEY `channel_dirdate` (`channel_dirdate`),
KEY `channel_w_like` (`channel_w_like`),
+ KEY `channel_removed` (`channel_removed`),
+ KEY `channel_system` (`channel_system`),
KEY `channel_lastpost` (`channel_lastpost`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;