aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-12-22 03:33:12 -0800
committerfriendica <info@friendica.com>2012-12-22 03:33:12 -0800
commitf09b9f1e446ff005a19c451efccbd8b3806ef5f9 (patch)
tree2190b0ccfbb1075be7b0031f597fefdef3981688 /install/database.sql
parent8d71fe91f67eeb501efd6fedd17992c12882daeb (diff)
downloadvolse-hubzilla-f09b9f1e446ff005a19c451efccbd8b3806ef5f9.tar.gz
volse-hubzilla-f09b9f1e446ff005a19c451efccbd8b3806ef5f9.tar.bz2
volse-hubzilla-f09b9f1e446ff005a19c451efccbd8b3806ef5f9.zip
add permission controls to "storage" objects such as attachments or other stored files
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 187c3dcf5..5581a27c6 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -159,6 +159,8 @@ CREATE TABLE IF NOT EXISTS `channel` (
`channel_w_photos` tinyint(3) unsigned NOT NULL DEFAULT '128',
`channel_w_chat` tinyint(3) unsigned NOT NULL DEFAULT '128',
`channel_a_delegate` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `channel_r_storage` int(10) unsigned NOT NULL DEFAULT '128',
+ `channel_w_storage` int(10) unsigned NOT NULL DEFAULT '128',
PRIMARY KEY (`channel_id`),
KEY `channel_account_id` (`channel_account_id`),
KEY `channel_primary` (`channel_primary`),
@@ -186,7 +188,9 @@ CREATE TABLE IF NOT EXISTS `channel` (
KEY `channel_guid` (`channel_guid`),
KEY `channel_hash` (`channel_hash`),
KEY `channel_expire_days` (`channel_expire_days`),
- KEY `channel_a_delegate` (`channel_a_delegate`)
+ KEY `channel_a_delegate` (`channel_a_delegate`),
+ KEY `channel_r_storage` (`channel_r_storage`),
+ KEY `channel_w_storage` (`channel_w_storage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `clients` (