aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2007-03-27 08:43:10 +0000
committerplegall <plg@piwigo.org>2007-03-27 08:43:10 +0000
commitb86d4ac0b89e167bedbd03805e7c7024da5cef03 (patch)
treea5f2b26d17aaac8c83f1d39b132d56df33621d01
parent04e58f3769b134c10baef750633a613956fd3904 (diff)
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>. git-svn-id: http://piwigo.org/svn/trunk@1925 68402e56-0260-453c-a942-63ccdbb3a9ee
-rw-r--r--install/phpwebgallery_structure.sql6
1 files 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';