aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-05-25 22:10:01 -0700
committerzotlabs <mike@macgirvin.com>2017-05-25 22:10:01 -0700
commit57edfa7ae80c91d6d73cf009dd02931e4d21f4aa (patch)
treefef77b7d3b01ab111f7972ca4ede94175df944d8
parentb4da2d35bf8084da812be0716917a0f88cf68f91 (diff)
downloadvolse-hubzilla-57edfa7ae80c91d6d73cf009dd02931e4d21f4aa.tar.gz
volse-hubzilla-57edfa7ae80c91d6d73cf009dd02931e4d21f4aa.tar.bz2
volse-hubzilla-57edfa7ae80c91d6d73cf009dd02931e4d21f4aa.zip
put back obsolete permission fields in abook and channel schema files so we can restore the old data without choking when upgrading the table type
-rw-r--r--install/schema_mysql.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index ec70aa33b..183fcd56d 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -18,6 +18,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
`abook_account` int(10) unsigned NOT NULL DEFAULT '0',
`abook_channel` int(10) unsigned NOT NULL DEFAULT '0',
`abook_xchan` char(191) NOT NULL DEFAULT '',
+ `abook_my_perms` int(11) NOT NULL DEFAULT '0',
+ `abook_their_perms` int(11) NOT NULL DEFAULT '0',
`abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT '99',
`abook_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`abook_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -264,6 +266,24 @@ CREATE TABLE IF NOT EXISTS `channel` (
`channel_allow_gid` mediumtext NOT NULL,
`channel_deny_cid` mediumtext NOT NULL,
`channel_deny_gid` mediumtext NOT NULL,
+ `channel_r_stream` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_r_profile` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_r_photos` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_r_abook` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_stream` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_wall` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_comment` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_mail` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_photos` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_chat` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_r_storage` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_w_storage` int(10) unsigned NOT NULL DEFAULT '0',
+ `channel_r_pages` int(10) unsigned NOT NULL DEFAULT '0',
+ `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',
`channel_moved` char(191) NOT NULL DEFAULT '',