Changeset 2084 for trunk/install

Timestamp:

Sep 11, 2007, 4:24:51 AM (17 years ago)

Author:

rvelices

Message:

feature 731: permissions at image level

• this is the first version - I wait for feedback before changing help files

Location:

trunk/install

Files:

• db/63-database.php (added)
• phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -199 +199 @@
   `storage_category_id` smallint(5) unsigned default NULL,
   `high_filesize` mediumint(9) unsigned default NULL,
+  `level` tinyint unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),
@@ -329 +330 @@
   `forbidden_categories` text,
   `nb_total_images` mediumint(8) unsigned default NULL,
+  `image_access_type` enum('NOT IN','IN') NOT NULL default 'NOT IN',
+  `image_access_list` text default NULL,
   PRIMARY KEY  (`user_id`)
 ) TYPE=MyISAM;
@@ -390 +393 @@
   `registration_date` datetime NOT NULL default '0000-00-00 00:00:00',
   `enabled_high` enum('true','false') NOT NULL default 'true',
+  `level` tinyint unsigned NOT NULL default '0',
   UNIQUE KEY `user_infos_ui1` (`user_id`)
 ) TYPE=MyISAM;