Changeset 1121 for trunk/install

Timestamp:

Apr 5, 2006, 12:29:35 AM (18 years ago)

Author:

plg

Message:

feature deleted: code for categories link was too complicated for such a
simple fature. Replaced by static association. Links are not persistent
anymore.

modification removed: #image_category.is_storage replaced by
#images.storage_category_id as in branche 1.5..

Location:

trunk/install

Files:

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

trunk/install/phpwebgallery_structure.sql

@@ -43 +43 @@
 
 --
--- Table structure for table `phpwebgallery_categories_link`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_categories_link`;
-CREATE TABLE `phpwebgallery_categories_link` (
-  `source` smallint(5) unsigned NOT NULL default '0',
-  `destination` smallint(5) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`source`,`destination`)
-) TYPE=MyISAM;
-
---
 -- Table structure for table `phpwebgallery_comments`
 --
@@ -139 +128 @@
   `image_id` mediumint(8) unsigned NOT NULL default '0',
   `category_id` smallint(5) unsigned NOT NULL default '0',
-  `is_storage` enum('true','false') default 'false',
   PRIMARY KEY  (`image_id`,`category_id`),
   KEY `image_category_i1` (`image_id`),
@@ -179 +167 @@
   `has_high` enum('true') default NULL,
   `path` varchar(255) NOT NULL default '',
+  `storage_category_id` smallint(5) unsigned default NULL,
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),