Changeset 1925

Timestamp:

Mar 27, 2007, 10:43:10 AM (17 years ago)

Author:

plg

Message:

Complement to trunk r1924: modification on index names reported in SQL
database structure installation file.

Modification: somes indexes were renamed to comply with PWG indexes naming
rules, ie <table_name>_[u for unique]i<index number in table>.

File:

• trunk/install/phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -158 +158 @@
   `category_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`image_id`,`category_id`),
-  KEY `image_category` (`category_id`)
+  KEY `image_category_i1` (`category_id`)
 ) TYPE=MyISAM;
 
@@ -403 +403 @@
   `last_send` datetime default NULL,
   PRIMARY KEY  (`user_id`),
-  UNIQUE KEY `uidx_check_key` (`check_key`)
+  UNIQUE KEY `user_mail_notification_ui1` (`check_key`)
 ) TYPE=MyISAM;
 
@@ -453 +453 @@
   `comment` varchar(255) default NULL,
   PRIMARY KEY  (`id`),
-  UNIQUE KEY `name` (`name`)
+  UNIQUE KEY `ws_access_ui1` (`name`)
 ) TYPE=MyISAM COMMENT='Access for Web Services';