Changeset 1925


Ignore:
Timestamp:
03/27/07 10:43:10 (13 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/install/phpwebgallery_structure.sql

    r1904 r1925  
    158158  `category_id` smallint(5) unsigned NOT NULL default '0', 
    159159  PRIMARY KEY  (`image_id`,`category_id`), 
    160   KEY `image_category` (`category_id`) 
     160  KEY `image_category_i1` (`category_id`) 
    161161) TYPE=MyISAM; 
    162162 
     
    403403  `last_send` datetime default NULL, 
    404404  PRIMARY KEY  (`user_id`), 
    405   UNIQUE KEY `uidx_check_key` (`check_key`) 
     405  UNIQUE KEY `user_mail_notification_ui1` (`check_key`) 
    406406) TYPE=MyISAM; 
    407407 
     
    453453  `comment` varchar(255) default NULL, 
    454454  PRIMARY KEY  (`id`), 
    455   UNIQUE KEY `name` (`name`) 
     455  UNIQUE KEY `ws_access_ui1` (`name`) 
    456456) TYPE=MyISAM COMMENT='Access for Web Services'; 
    457457 
Note: See TracChangeset for help on using the changeset viewer.