Index: branches/5.1.x/core/install/install_schema.sql =================================================================== diff -u -N -r13444 -r13470 --- branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13444) +++ branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13470) @@ -366,16 +366,21 @@ KEY Cached (Cached) ); -CREATE TABLE StdDestinations ( - DestId int(11) NOT NULL auto_increment, - DestType int(11) NOT NULL default '0', - DestParentId int(11) default NULL, - DestName varchar(255) NOT NULL default '', - DestAbbr char(3) NOT NULL default '', - DestAbbr2 char(2) default NULL, - PRIMARY KEY (DestId), - KEY DestType (DestType), - KEY DestParentId (DestParentId) +CREATE TABLE CountryStates ( + CountryStateId int(11) NOT NULL AUTO_INCREMENT, + `Type` int(11) NOT NULL DEFAULT '1', + StateCountryId int(11) DEFAULT NULL, + l1_Name varchar(255) NOT NULL, + l2_Name varchar(255) NOT NULL, + l3_Name varchar(255) NOT NULL, + l4_Name varchar(255) NOT NULL, + l5_Name varchar(255) NOT NULL, + IsoCode char(3) NOT NULL DEFAULT '', + ShortIsoCode char(2) DEFAULT NULL, + PRIMARY KEY (CountryStateId), + KEY `Type` (`Type`), + KEY StateCountryId (StateCountryId), + KEY l1_Name (l1_Name(5)) ); CREATE TABLE Category (