語系與翻譯

Opencart 更新和譒譯國家、地區資料

• Opencart註冊表格優化2 - 更新和譒譯國家、地區資料

  REPLACE 要注意資料與 schema 順序

國家

-- 部分國家語系翻譯

REPLACE INTO `country` VALUES ('242', 'Republic of South Sudan', 'SS', 'SSD', '', '0', '0');
REPLACE INTO `country` VALUES ('241', 'Republic of Serbia', 'RS', 'SRB', '', '0', '0');
REPLACE INTO `country` VALUES ('240', 'Montenegro', 'ME', 'MNE', '', '0', '0');
REPLACE INTO `country` VALUES ('206', '台灣', 'TW', 'TWN', '', '0', '1');
REPLACE INTO `country` VALUES ('125', '中國澳門(Macau, China)', 'MO', 'MAC', '', '0', '1');
REPLACE INTO `country` VALUES ('107', '日本国', 'JP', 'JPN', '', '0', '1');
REPLACE INTO `country` VALUES ('96', '中國香港(Hong Kong, China)', 'HK', 'HKG', '', '0', '1');
REPLACE INTO `country` VALUES ('44', '中华人民共和国', 'CN', 'CHN', '', '0', '1');

-- 只顯示十四個國家 AND 兩個行政特區

UPDATE `country` SET `status` = 0;
UPDATE `country` SET `status` = 1 WHERE `country_id` IN(32, 36, 100, 116, 129, 146, 168, 188, 209, 230);
UPDATE `country` SET `status` = 1 WHERE `country_id` IN(44, 107, 113, 206);
UPDATE `country` SET `status` = 1 WHERE `country_id` IN(96, 125);

-- 語系

地區

ALTER TABLE `zone` MODIFY `name` varchar(128) AFTER `code`;

REPLACE INTO `zone` VALUES ('684', '44', 'AN', '安徽省', '1');
REPLACE INTO `zone` VALUES ('685', '44', 'BE', '北京市', '1');
REPLACE INTO `zone` VALUES ('686', '44', 'CH', '重庆市', '1');
REPLACE INTO `zone` VALUES ('687', '44', 'FU', '福建省', '1');
REPLACE INTO `zone` VALUES ('688', '44', 'GA', '甘肃省', '1');
REPLACE INTO `zone` VALUES ('689', '44', 'GU', '广东省', '1');
REPLACE INTO `zone` VALUES ('690', '44', 'GX', '广西壮族自治区', '1');
REPLACE INTO `zone` VALUES ('691', '44', 'GZ', '贵州省', '1');
REPLACE INTO `zone` VALUES ('692', '44', 'HA', '海南省', '1');
REPLACE INTO `zone` VALUES ('693', '44', 'HB', '河北省', '1');
REPLACE INTO `zone` VALUES ('694', '44', 'HL', '黑龙江省', '1');
REPLACE INTO `zone` VALUES ('695', '44', 'HE', '河南省', '1');
REPLACE INTO `zone` VALUES ('696', '44', 'HK', '香港', '0');
REPLACE INTO `zone` VALUES ('697', '44', 'HU', '湖北省', '1');
REPLACE INTO `zone` VALUES ('698', '44', 'HN', '湖南省', '1');
REPLACE INTO `zone` VALUES ('699', '44', 'IM', '内蒙古自治区', '1');
REPLACE INTO `zone` VALUES ('700', '44', 'JI', '江苏省', '1');
REPLACE INTO `zone` VALUES ('701', '44', 'JX', '江西省', '1');
REPLACE INTO `zone` VALUES ('702', '44', 'JL', '吉林省', '1');
REPLACE INTO `zone` VALUES ('703', '44', 'LI', '辽宁省', '1');
REPLACE INTO `zone` VALUES ('704', '44', 'MA', '澳门', '0');
REPLACE INTO `zone` VALUES ('705', '44', 'NI', '宁夏回族自治区', '1');
REPLACE INTO `zone` VALUES ('706', '44', 'SH', '陕西省', '1');
REPLACE INTO `zone` VALUES ('707', '44', 'SA', '山东省', '1');
REPLACE INTO `zone` VALUES ('708', '44', 'SG', '上海市', '1');
REPLACE INTO `zone` VALUES ('709', '44', 'SX', '山西省', '1');
REPLACE INTO `zone` VALUES ('710', '44', 'SI', '四川省', '1');
REPLACE INTO `zone` VALUES ('711', '44', 'TI', '天津市', '1');
REPLACE INTO `zone` VALUES ('712', '44', 'XI', '新疆维吾尔自治区', '1');
REPLACE INTO `zone` VALUES ('713', '44', 'YU', '云南省', '1');
REPLACE INTO `zone` VALUES ('714', '44', 'ZH', '浙江省', '1');
REPLACE INTO `zone` VALUES ('1410', '96', 'HCW', '港島中西區(Central and Western, Hong Kong Island)', '1');
REPLACE INTO `zone` VALUES ('1411', '96', 'HEA', '港島東區(Eastern, Hong Kong Island)', '1');
REPLACE INTO `zone` VALUES ('1412', '96', 'HSO', '港島南區(Southern, Hong Kong Island)', '1');
REPLACE INTO `zone` VALUES ('1413', '96', 'HWC', '港島灣仔區(Wan Chai, Hong Kong Island)', '1');
REPLACE INTO `zone` VALUES ('1414', '96', 'KKC', '九龍九龍城區(Kowloon City, Kowloon)', '1');
REPLACE INTO `zone` VALUES ('1415', '96', 'KKT', '九龍觀塘區(Kwun Tong, Kowloon)', '1');
REPLACE INTO `zone` VALUES ('1416', '96', 'KSS', '九龍深水埗區(Sham Shui Po, Kowloon)', '1');
REPLACE INTO `zone` VALUES ('1417', '96', 'KWT', '九龍黃大仙區(Wong Tai Sin, Kowloon)', '1');
REPLACE INTO `zone` VALUES ('1418', '96', 'KYT', '九龍油尖旺區(Yau Tsim Mong, Kowloon)', '1');
REPLACE INTO `zone` VALUES ('1419', '96', 'NIS', '新界離島區(Islands, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1420', '96', 'NKT', '新界葵青區(Kwai Tsing, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1421', '96', 'NNO', '新界北區(North, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1422', '96', 'NSK', '新界西貢區(Sai Kung, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1423', '96', 'NST', '新界沙田區(Sha Tin, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1424', '96', 'NTP', '新界大埔區(Tai Po, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1425', '96', 'NTW', '新界荃灣區(Tsuen Wan, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1426', '96', 'NTM', '新界屯門區(Tuen Mun, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1427', '96', 'NYL', '新界元朗區(Yuen Long, New Territories)', '1');
REPLACE INTO `zone` VALUES ('1657', '107', 'AI', '愛知県', '1');
REPLACE INTO `zone` VALUES ('1658', '107', 'AK', '秋田県', '1');
REPLACE INTO `zone` VALUES ('1659', '107', 'AO', '青森県', '1');
REPLACE INTO `zone` VALUES ('1660', '107', 'CH', '千葉県', '1');
REPLACE INTO `zone` VALUES ('1661', '107', 'EH', '愛媛県', '1');
REPLACE INTO `zone` VALUES ('1662', '107', 'FK', '福井県', '1');
REPLACE INTO `zone` VALUES ('1663', '107', 'FU', '福岡県', '1');
REPLACE INTO `zone` VALUES ('1664', '107', 'FS', '福島県', '1');
REPLACE INTO `zone` VALUES ('1665', '107', 'GI', '岐阜県', '1');
REPLACE INTO `zone` VALUES ('1666', '107', 'GU', '群馬県', '1');
REPLACE INTO `zone` VALUES ('1667', '107', 'HI', '広島県', '1');
REPLACE INTO `zone` VALUES ('1668', '107', 'HO', '北海道', '1');
REPLACE INTO `zone` VALUES ('1669', '107', 'HY', '兵庫県', '1');
REPLACE INTO `zone` VALUES ('1670', '107', 'IB', '茨城県', '1');
REPLACE INTO `zone` VALUES ('1671', '107', 'IS', '石川県', '1');
REPLACE INTO `zone` VALUES ('1672', '107', 'IW', '岩手県', '1');
REPLACE INTO `zone` VALUES ('1673', '107', 'KA', '香川県', '1');
REPLACE INTO `zone` VALUES ('1674', '107', 'KG', '鹿児島県', '1');
REPLACE INTO `zone` VALUES ('1675', '107', 'KN', '神奈川県', '1');
REPLACE INTO `zone` VALUES ('1676', '107', 'KO', '高知県', '1');
REPLACE INTO `zone` VALUES ('1677', '107', 'KU', '熊本県', '1');
REPLACE INTO `zone` VALUES ('1678', '107', 'KY', '京都府', '1');
REPLACE INTO `zone` VALUES ('1679', '107', 'MI', '三重県', '1');
REPLACE INTO `zone` VALUES ('1680', '107', 'MY', '宮城県', '1');
REPLACE INTO `zone` VALUES ('1681', '107', 'MZ', '宮崎県', '1');
REPLACE INTO `zone` VALUES ('1682', '107', 'NA', '長野県', '1');
REPLACE INTO `zone` VALUES ('1683', '107', 'NG', '長崎県', '1');
REPLACE INTO `zone` VALUES ('1684', '107', 'NR', '奈良県', '1');
REPLACE INTO `zone` VALUES ('1685', '107', 'NI', '新潟県', '1');
REPLACE INTO `zone` VALUES ('1686', '107', 'OI', '大分県', '1');
REPLACE INTO `zone` VALUES ('1687', '107', 'OK', '岡山県', '1');
REPLACE INTO `zone` VALUES ('1688', '107', 'ON', '沖縄県', '1');
REPLACE INTO `zone` VALUES ('1689', '107', 'OS', '大阪府', '1');
REPLACE INTO `zone` VALUES ('1690', '107', 'SA', '佐賀県', '1');
REPLACE INTO `zone` VALUES ('1691', '107', 'SI', '埼玉県', '1');
REPLACE INTO `zone` VALUES ('1692', '107', 'SH', '滋賀県', '1');
REPLACE INTO `zone` VALUES ('1693', '107', 'SM', '島根県', '1');
REPLACE INTO `zone` VALUES ('1694', '107', 'SZ', '静岡県', '1');
REPLACE INTO `zone` VALUES ('1695', '107', 'TO', '栃木県', '1');
REPLACE INTO `zone` VALUES ('1696', '107', 'TS', '徳島県', '1');
REPLACE INTO `zone` VALUES ('1697', '107', 'TK', '東京都', '1');
REPLACE INTO `zone` VALUES ('1698', '107', 'TT', '鳥取県', '1');
REPLACE INTO `zone` VALUES ('1699', '107', 'TY', '富山県', '1');
REPLACE INTO `zone` VALUES ('1700', '107', 'WA', '和歌山県', '1');
REPLACE INTO `zone` VALUES ('1701', '107', 'YA', '山形県', '1');
REPLACE INTO `zone` VALUES ('1702', '107', 'YM', '山口県', '1');
REPLACE INTO `zone` VALUES ('1703', '107', 'YN', '山梨県', '1');
REPLACE INTO `zone` VALUES ('1933', '125', 'OLF', '澳門半島花地瑪堂區(Our Lady of Fatima Parish)', '1');
REPLACE INTO `zone` VALUES ('1934', '125', 'ANT', '澳門半島聖安多尼堂區(St. Anthony Parish)', '1');
REPLACE INTO `zone` VALUES ('1935', '125', 'LAZ', '澳門半島望德堂區(St. Lazarus Parish)', '1');
REPLACE INTO `zone` VALUES ('1936', '125', 'CAT', '澳門半島大堂區(Cathedral Parish)', '1');
REPLACE INTO `zone` VALUES ('1937', '125', 'LAW', '澳門半島風順堂區(St. Lawrence Parish)', '1');
REPLACE INTO `zone` VALUES ('3135', '206', 'TW-CHA', '彰化縣', '1');
REPLACE INTO `zone` VALUES ('3136', '206', 'TW-CYQ', '嘉義縣', '1');
REPLACE INTO `zone` VALUES ('3137', '206', 'TW-HSZ', '新竹市', '1');
REPLACE INTO `zone` VALUES ('3138', '206', 'TW-HUA', '花蓮縣', '1');
REPLACE INTO `zone` VALUES ('3139', '206', 'TW-ILA', '宜蘭縣', '1');
REPLACE INTO `zone` VALUES ('3140', '206', 'KH', 'Kao-hsiung county', '0');
REPLACE INTO `zone` VALUES ('3141', '206', 'KM', '金門縣', '1');
REPLACE INTO `zone` VALUES ('3142', '206', 'LC', '連江縣', '1');
REPLACE INTO `zone` VALUES ('3143', '206', 'TW-MIA', '苗栗縣', '1');
REPLACE INTO `zone` VALUES ('3144', '206', 'TW-NAN', '南投縣', '1');
REPLACE INTO `zone` VALUES ('3145', '206', 'TW-PEN', '澎湖縣', '1');
REPLACE INTO `zone` VALUES ('3146', '206', 'TW-PIF', '屏東縣', '1');
REPLACE INTO `zone` VALUES ('3147', '206', 'TG', 'T\'ai-chung', '0');
REPLACE INTO `zone` VALUES ('3148', '206', 'TW-TNN', '台南市', '1');
REPLACE INTO `zone` VALUES ('3149', '206', 'TW-TPQ', '新北市', '1');
REPLACE INTO `zone` VALUES ('3150', '206', 'TW-TTT', '台東縣', '1');
REPLACE INTO `zone` VALUES ('3151', '206', 'TW-TAO', '桃園縣', '1');
REPLACE INTO `zone` VALUES ('3152', '206', 'TW-YUN', '雲林縣', '1');
REPLACE INTO `zone` VALUES ('3153', '206', 'TW-CYI', '嘉義市', '1');
REPLACE INTO `zone` VALUES ('3154', '206', 'TW-KEE', '基隆市', '1');
REPLACE INTO `zone` VALUES ('3155', '206', 'TW-HSQ', '新竹縣', '1');
REPLACE INTO `zone` VALUES ('3156', '206', 'TW-TXG', '台中市', '1');
REPLACE INTO `zone` VALUES ('3157', '206', 'TN', 'T\'ai-nan', '0');
REPLACE INTO `zone` VALUES ('3158', '206', 'TW-KHH', '高雄市', '1');
REPLACE INTO `zone` VALUES ('3159', '206', 'TW-TPE', '台北市', '1');
REPLACE INTO `zone` VALUES ('3970', '44', 'QH', '青海省', '1');
REPLACE INTO `zone` VALUES ('3971', '44', 'TB', '西藏自治區', '1');
REPLACE INTO `zone` VALUES ('3972', '125', 'TP', '氹仔(Taipa)', '1');
REPLACE INTO `zone` VALUES ('3973', '125', 'CO', '路環(Coloane)', '1');
REPLACE INTO `zone` VALUES ('3974', '125', 'CT', '路氹城(Cotai)', '1');
REPLACE INTO `zone` VALUES ('3975', '240', 'ME-01', 'Andrijevica', '1');
REPLACE INTO `zone` VALUES ('3976', '240', 'ME-02', 'Bar', '1');
REPLACE INTO `zone` VALUES ('3977', '240', 'ME-03', 'Berane', '1');
REPLACE INTO `zone` VALUES ('3978', '240', 'ME-04', 'Bijelo Polje', '1');
REPLACE INTO `zone` VALUES ('3979', '240', 'ME-05', 'Budva', '1');
REPLACE INTO `zone` VALUES ('3980', '240', 'ME-06', 'Cetinje', '1');
REPLACE INTO `zone` VALUES ('3981', '240', 'ME-07', 'Danilovgrad', '1');
REPLACE INTO `zone` VALUES ('3982', '240', 'ME-08', 'Herceg-Novi', '1');
REPLACE INTO `zone` VALUES ('3983', '240', 'ME-09', 'Kolašin', '1');
REPLACE INTO `zone` VALUES ('3984', '240', 'ME-10', 'Kotor', '1');
REPLACE INTO `zone` VALUES ('3985', '240', 'ME-11', 'Mojkovac', '1');
REPLACE INTO `zone` VALUES ('3986', '240', 'ME-12', 'Nikšić', '1');
REPLACE INTO `zone` VALUES ('3987', '240', 'ME-13', 'Plav', '1');
REPLACE INTO `zone` VALUES ('3988', '240', 'ME-14', 'Pljevlja', '1');
REPLACE INTO `zone` VALUES ('3989', '240', 'ME-15', 'Plužine', '1');
REPLACE INTO `zone` VALUES ('3990', '240', 'ME-16', 'Podgorica', '1');
REPLACE INTO `zone` VALUES ('3991', '240', 'ME-17', 'Rožaje', '1');
REPLACE INTO `zone` VALUES ('3992', '240', 'ME-18', 'Šavnik', '1');
REPLACE INTO `zone` VALUES ('3993', '240', 'ME-19', 'Tivat', '1');
REPLACE INTO `zone` VALUES ('3994', '240', 'ME-20', 'Ulcinj', '1');
REPLACE INTO `zone` VALUES ('3995', '240', 'ME-21', 'Žabljak', '1');
REPLACE INTO `zone` VALUES ('3998', '241', 'RS-00', 'Beograd', '1');
REPLACE INTO `zone` VALUES ('3999', '241', 'RS-14', 'Borski okrug', '1');
REPLACE INTO `zone` VALUES ('4000', '241', 'RS-11', 'Braničevski okrug', '1');
REPLACE INTO `zone` VALUES ('4001', '241', 'RS-23', 'Jablanički okrug', '1');
REPLACE INTO `zone` VALUES ('4002', '241', 'RS-06', 'Južnobački okrug', '1');
REPLACE INTO `zone` VALUES ('4003', '241', 'RS-04', 'Južnobanatski okrug', '1');
REPLACE INTO `zone` VALUES ('4004', '241', 'RS-09', 'Kolubarski okrug', '1');
REPLACE INTO `zone` VALUES ('4005', '241', 'RS-25', 'Kosovski okrug', '1');
REPLACE INTO `zone` VALUES ('4006', '241', 'RS-28', 'Kosovsko-Mitrovački okrug', '1');
REPLACE INTO `zone` VALUES ('4007', '241', 'RS-29', 'Kosovsko-Pomoravski okrug', '1');
REPLACE INTO `zone` VALUES ('4008', '241', 'RS-08', 'Mačvanski okrug', '1');
REPLACE INTO `zone` VALUES ('4009', '241', 'RS-17', 'Moravički okrug', '1');
REPLACE INTO `zone` VALUES ('4010', '241', 'RS-20', 'Nišavski okrug', '1');
REPLACE INTO `zone` VALUES ('4011', '241', 'RS-24', 'Pčinjski okrug', '1');
REPLACE INTO `zone` VALUES ('4012', '241', 'RS-26', 'Pećki okrug', '1');
REPLACE INTO `zone` VALUES ('4013', '241', 'RS-22', 'Pirotski okrug', '1');
REPLACE INTO `zone` VALUES ('4014', '241', 'RS-10', 'Podunavski okrug', '1');
REPLACE INTO `zone` VALUES ('4015', '241', 'RS-13', 'Pomoravski okrug', '1');
REPLACE INTO `zone` VALUES ('4016', '241', 'RS-27', 'Prizrenski okrug', '1');
REPLACE INTO `zone` VALUES ('4017', '241', 'RS-19', 'Rasinski okrug', '1');
REPLACE INTO `zone` VALUES ('4018', '241', 'RS-18', 'Raški okrug', '1');
REPLACE INTO `zone` VALUES ('4019', '241', 'RS-01', 'Severnobački okrug', '1');
REPLACE INTO `zone` VALUES ('4020', '241', 'RS-03', 'Severnobanatski okrug', '1');
REPLACE INTO `zone` VALUES ('4021', '241', 'RS-02', 'Srednjebanatski okrug', '1');
REPLACE INTO `zone` VALUES ('4022', '241', 'RS-07', 'Sremski okrug', '1');
REPLACE INTO `zone` VALUES ('4023', '241', 'RS-12', 'Šumadijski okrug', '1');
REPLACE INTO `zone` VALUES ('4024', '241', 'RS-21', 'Toplički okrug', '1');
REPLACE INTO `zone` VALUES ('4025', '241', 'RS-15', 'Zaječarski okrug', '1');
REPLACE INTO `zone` VALUES ('4026', '241', 'RS-05', 'Zapadnobački okrug', '1');
REPLACE INTO `zone` VALUES ('4027', '241', 'RS-16', 'Zlatiborski okrug', '1');
REPLACE INTO `zone` VALUES ('4028', '242', 'SS-EC', 'Central Equatoria', '1');
REPLACE INTO `zone` VALUES ('4029', '242', 'SS-EE', 'Eastern Equatoria', '1');
REPLACE INTO `zone` VALUES ('4030', '242', 'SS-JG', 'Jonglei', '1');
REPLACE INTO `zone` VALUES ('4031', '242', 'SS-LK', 'Lakes', '1');
REPLACE INTO `zone` VALUES ('4032', '242', 'SS-BN', 'Northern Bahr el-Ghazal', '1');
REPLACE INTO `zone` VALUES ('4033', '242', 'SS-UY', 'Unity', '1');
REPLACE INTO `zone` VALUES ('4034', '242', 'SS-NU', 'Upper Nile', '1');
REPLACE INTO `zone` VALUES ('4035', '242', 'SS-WR', 'Warrap', '1');
REPLACE INTO `zone` VALUES ('4036', '242', 'SS-BW', 'Western Bahr el-Ghazal', '1');
REPLACE INTO `zone` VALUES ('4037', '242', 'SS-EW', 'Western Equatoria', '1');