From f09b9f1e446ff005a19c451efccbd8b3806ef5f9 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Sat, 22 Dec 2012 03:33:12 -0800
Subject: add permission controls to "storage" objects such as attachments or
 other stored files

---
 install/database.sql | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'install/database.sql')

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` (
-- 
cgit v1.2.3

