创建国家表
CREATE TABLE `country` (
`PK` bigint(20) NOT NULL DEFAULT '0',
`activeflag` tinyint(1) DEFAULT NULL,
`isocode` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`PK`),
KEY `ISOCode_34` (`isocode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
导入数据到新表
INSERT INTO country (PK,activeflag,ISOCODE) SELECT PK,activeflag,ISOCODE FROM COUNTRIES;
创建多语言表
CREATE TABLE `countrylp` (
`ITEMPK` bigint(20) NOT NULL DEFAULT '0',
`locale` varchar(20) NOT NULL ,
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`ITEMPK`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
导入数据
INSERT INTO countrylp (`ITEMPK`,`locale`,`name`)
select lp.ITEMPK as ITEMPK,la.isocode as locale,p_name as name from gucci.countrieslp lp, gucci.languages la
where la.pk=lp.langpk;
创建 导入 regions
CREATE TABLE `region` (
`PK` bigint(20) NOT NULL DEFAULT '0',
`activeflag` tinyint(1) DEFAULT NULL,
`isocode` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`countrypk` bigint(20) DEFAULT NULL,
`isocodeshort` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`PK`),
KEY `ISOCode_35` (`isocode`),
KEY `Region_Country_35` (`countrypk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO region (PK,activeflag,isocode,countrypk,isocodeshort) SELECT PK,activeflag,isocode,countrypk,p_isocodeshort FROM regions;
导入多语言
CREATE TABLE `regionlp` (
`ITEMPK` bigint(20) NOT NULL DEFAULT '0',
`locale` varchar(20) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`ITEMPK`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO regionlp (`ITEMPK`,`locale`,`name`)
select lp.ITEMPK as ITEMPK,la.isocode as locale,p_name as name from gucci.regionslp lp, gucci.languages la
where la.pk=lp.langpk;