diff options
| author | plegall <plg@piwigo.org> | 2007-03-27 08:43:10 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2007-03-27 08:43:10 +0000 |
| commit | b86d4ac0b89e167bedbd03805e7c7024da5cef03 (patch) | |
| tree | a5f2b26d17aaac8c83f1d39b132d56df33621d01 /install/phpwebgallery_structure.sql | |
| parent | 04e58f3769b134c10baef750633a613956fd3904 (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
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 6 |
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'; |