From b86d4ac0b89e167bedbd03805e7c7024da5cef03 Mon Sep 17 00:00:00 2001 From: plegall Date: Tue, 27 Mar 2007 08:43:10 +0000 Subject: 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 _[u for unique]i. git-svn-id: http://piwigo.org/svn/trunk@1925 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/phpwebgallery_structure.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 32257e36a..651154cae 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -157,7 +157,7 @@ CREATE TABLE `phpwebgallery_image_category` ( `image_id` mediumint(8) unsigned NOT NULL default '0', `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; -- @@ -402,7 +402,7 @@ CREATE TABLE `phpwebgallery_user_mail_notification` ( `enabled` enum('true','false') NOT NULL default 'false', `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; -- @@ -452,6 +452,6 @@ CREATE TABLE `phpwebgallery_ws_access` ( `limit` smallint(5) unsigned default NULL, `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'; -- cgit v1.2.3