add permission controls to "storage" objects such as attachments or other stored files

2 files changed, 16 insertions, 3 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` (
diff --git a/install/update.php b/install/update.php
index 791371ec1..bdd687fb3 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1007 );
+define( 'UPDATE_VERSION' , 1008 );
 
 /**
  *
@@ -142,4 +142,13 @@ function update_r1006() {
 	if($r && $r2)
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
-}
\ No newline at end of file
+}
+
+
+function update_r1007() {
+	$r = q("ALTER TABLE `channel` ADD `channel_r_storage` INT UNSIGNED NOT NULL DEFAULT '128', ADD `channel_w_storage` INT UNSIGNED NOT NULL DEFAULT '128', add index ( channel_r_storage ), add index ( channel_w_storage )");
+
+	if($r && $r2)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}