/*
Navicat Premium Data Transfer
Target Server Type : MySQL
Target Server Version : 80024
File Encoding : 65001
Date: 09/12/2022 22:41:31
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for easy_tz_language
-- ----------------------------
DROP TABLE IF EXISTS `easy_tz_language`;
CREATE TABLE `easy_tz_language` (
`id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
`tz_id` int(0) NOT NULL COMMENT '时区id',
`display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '时区显示名称',
`language_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言类型（en:英语，zh:中文）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 201 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of easy_tz_language
-- ----------------------------
INSERT INTO `easy_tz_language` VALUES (1, 1, '(UTC+01:00) 卡萨布兰卡', 'zh');
INSERT INTO `easy_tz_language` VALUES (2, 1, '(UTC+01:00) Casablanca', 'en');
INSERT INTO `easy_tz_language` VALUES (3, 2, '(UTC+01:00) 都柏林，爱丁堡，伦敦，里斯本', 'zh');
INSERT INTO `easy_tz_language` VALUES (4, 2, '(UTC+01:00) Dublin,Edinburgh,Lisbon,London', 'en');
INSERT INTO `easy_tz_language` VALUES (5, 3, '(UTC+01:00) 中非西部', 'zh');
INSERT INTO `easy_tz_language` VALUES (6, 3, '(UTC+01:00) West Central Africa', 'en');
INSERT INTO `easy_tz_language` VALUES (7, 4, '(UTC+02:00) 阿姆斯特丹，柏林，伯尔尼，罗马，斯德哥尔摩，维也纳', 'zh');
INSERT INTO `easy_tz_language` VALUES (8, 4, '(UTC+02:00) Amsterdam,Berlin,Bern,Rome,Stockholm,Vienna', 'en');
INSERT INTO `easy_tz_language` VALUES (9, 5, '(UTC+02:00) 贝尔格莱德，布拉迪斯拉发，布达佩斯，卢布尔雅那，布拉格', 'zh');
INSERT INTO `easy_tz_language` VALUES (10, 5, '(UTC+02:00) Belgrade,Bratislava,Budapest,Ljubljana,Prague', 'en');
INSERT INTO `easy_tz_language` VALUES (11, 6, '(UTC+02:00) 布鲁塞尔，哥本哈根，马德里，巴黎', 'zh');
INSERT INTO `easy_tz_language` VALUES (12, 6, '(UTC+02:00) Brussels,Copenhagen,Madrid,Paris', 'en');
INSERT INTO `easy_tz_language` VALUES (13, 7, '(UTC+02:00) 开罗', 'zh');
INSERT INTO `easy_tz_language` VALUES (14, 7, '(UTC+02:00) Cairo', 'en');
INSERT INTO `easy_tz_language` VALUES (15, 8, '(UTC+02:00) 哈拉雷，比勒陀利亚', 'zh');
INSERT INTO `easy_tz_language` VALUES (16, 8, '(UTC+02:00) Harare,Pretoria', 'en');
INSERT INTO `easy_tz_language` VALUES (17, 9, '(UTC+02:00) 萨拉热窝，斯科普里，华沙，萨格勒布', 'zh');
INSERT INTO `easy_tz_language` VALUES (18, 9, '(UTC+02:00) Sarajevo,Skopje,Warsaw,Zagreb', 'en');
INSERT INTO `easy_tz_language` VALUES (19, 10, '(UTC+02:00) 温得和克', 'zh');
INSERT INTO `easy_tz_language` VALUES (20, 10, '(UTC+02:00) Windhoek', 'en');
INSERT INTO `easy_tz_language` VALUES (21, 11, '(UTC+03:00) 雅典，布加勒斯特', 'zh');
INSERT INTO `easy_tz_language` VALUES (22, 11, '(UTC+03:00) Athens,Bucharest', 'en');
INSERT INTO `easy_tz_language` VALUES (23, 12, '(UTC+03:00) 巴格达', 'zh');
INSERT INTO `easy_tz_language` VALUES (24, 12, '(UTC+03:00) Baghdad', 'en');
INSERT INTO `easy_tz_language` VALUES (25, 13, '(UTC+03:00) 贝鲁特', 'zh');
INSERT INTO `easy_tz_language` VALUES (26, 13, '(UTC+03:00) Beirut', 'en');
INSERT INTO `easy_tz_language` VALUES (27, 14, '(UTC+03:00) 大马士革', 'zh');
INSERT INTO `easy_tz_language` VALUES (28, 14, '(UTC+03:00) Damascus', 'en');
INSERT INTO `easy_tz_language` VALUES (29, 15, '(UTC+03:00) 东欧', 'zh');
INSERT INTO `easy_tz_language` VALUES (30, 15, '(UTC+03:00) Eastern Europe', 'en');
INSERT INTO `easy_tz_language` VALUES (31, 16, '(UTC+03:00) 赫尔辛基，基辅，里加，索非亚，塔林，维尔纽斯', 'zh');
INSERT INTO `easy_tz_language` VALUES (32, 16, '(UTC+03:00) Helsinki,Kyiv,Riga,Sofia,Tallinn,Vilnius', 'en');
INSERT INTO `easy_tz_language` VALUES (33, 17, '(UTC+03:00) 伊斯坦布尔', 'zh');
INSERT INTO `easy_tz_language` VALUES (34, 17, '(UTC+03:00) Istanbul', 'en');
INSERT INTO `easy_tz_language` VALUES (35, 18, '(UTC+03:00) 耶路撒冷', 'zh');
INSERT INTO `easy_tz_language` VALUES (36, 18, '(UTC+03:00) Jerusalem ', 'en');
INSERT INTO `easy_tz_language` VALUES (37, 19, '(UTC+03:00) 科威特，利雅得', 'zh');
INSERT INTO `easy_tz_language` VALUES (38, 19, '(UTC+03:00) Kuwait,Riyadh', 'en');
INSERT INTO `easy_tz_language` VALUES (39, 20, '(UTC+03:00) 明斯克', 'zh');
INSERT INTO `easy_tz_language` VALUES (40, 20, '(UTC+03:00) Minsk', 'en');
INSERT INTO `easy_tz_language` VALUES (41, 21, '(UTC+03:00) 莫斯科，圣彼得堡,伏尔加格勒(RTZ 2)', 'zh');
INSERT INTO `easy_tz_language` VALUES (42, 21, '(UTC+03:00) Moscow,St.Petersburg,Volgograd(RTZ 2)', 'en');
INSERT INTO `easy_tz_language` VALUES (43, 22, '(UTC+03:00) 内罗毕', 'zh');
INSERT INTO `easy_tz_language` VALUES (44, 22, '(UTC+03:00) Nairobi', 'en');
INSERT INTO `easy_tz_language` VALUES (45, 23, '(UTC+03:30) 德黑兰', 'zh');
INSERT INTO `easy_tz_language` VALUES (46, 23, '(UTC+03:30) Tehran', 'en');
INSERT INTO `easy_tz_language` VALUES (47, 24, '(UTC+04:00) 阿布扎比，马斯喀特', 'zh');
INSERT INTO `easy_tz_language` VALUES (48, 24, '(UTC+04:00) Abu Dhabi,Muscat', 'en');
INSERT INTO `easy_tz_language` VALUES (49, 25, '(UTC+04:00) 巴库', 'zh');
INSERT INTO `easy_tz_language` VALUES (50, 25, '(UTC+04:00) Baku', 'en');
INSERT INTO `easy_tz_language` VALUES (51, 26, '(UTC+04:00) 路易港', 'zh');
INSERT INTO `easy_tz_language` VALUES (52, 26, '(UTC+04:00) Port Louis', 'en');
INSERT INTO `easy_tz_language` VALUES (53, 27, '(UTC+04:00) 第比利斯', 'zh');
INSERT INTO `easy_tz_language` VALUES (54, 27, '(UTC+04:00) Tbilisi', 'en');
INSERT INTO `easy_tz_language` VALUES (55, 28, '(UTC+04:00) 埃里温', 'zh');
INSERT INTO `easy_tz_language` VALUES (56, 28, '(UTC+04:00) Yerevan', 'en');
INSERT INTO `easy_tz_language` VALUES (57, 29, '(UTC+04:30) 喀布尔', 'zh');
INSERT INTO `easy_tz_language` VALUES (58, 29, '(UTC+04:30) Kabul', 'en');
INSERT INTO `easy_tz_language` VALUES (59, 30, '(UTC+05:00) 阿什哈巴德，塔什干', 'zh');
INSERT INTO `easy_tz_language` VALUES (60, 30, '(UTC+05:00) Ashgabat，Tashkent', 'en');
INSERT INTO `easy_tz_language` VALUES (61, 31, '(UTC+05:00) 叶卡捷琳堡(RTZ 4)', 'zh');
INSERT INTO `easy_tz_language` VALUES (62, 31, '(UTC+05:00) Ekaterinburg(RTZ 4)', 'en');
INSERT INTO `easy_tz_language` VALUES (63, 32, '(UTC+05:00) 伊斯兰堡，卡拉奇', 'zh');
INSERT INTO `easy_tz_language` VALUES (64, 32, '(UTC+05:00) Islamabad Karachi ', 'en');
INSERT INTO `easy_tz_language` VALUES (65, 33, '(UTC+05:30) 钦奈，加尔各答，孟买，新德里', 'zh');
INSERT INTO `easy_tz_language` VALUES (66, 33, '(UTC+05:30) Chennai,Kolkata,Mumbai,New Delhi', 'en');
INSERT INTO `easy_tz_language` VALUES (67, 34, '(UTC+05:45) 加德满都', 'zh');
INSERT INTO `easy_tz_language` VALUES (68, 34, '(UTC+05:45) Kathmandu', 'en');
INSERT INTO `easy_tz_language` VALUES (69, 35, '(UTC+06:00) 达卡', 'zh');
INSERT INTO `easy_tz_language` VALUES (70, 35, '(UTC+06:00) Dhaka', 'en');
INSERT INTO `easy_tz_language` VALUES (71, 36, '(UTC+06:30) 仰光', 'zh');
INSERT INTO `easy_tz_language` VALUES (72, 36, '(UTC+06:30) Yangon (Rangoon)', 'en');
INSERT INTO `easy_tz_language` VALUES (73, 37, '(UTC+07:00) 曼谷，河内，雅加达', 'zh');
INSERT INTO `easy_tz_language` VALUES (74, 37, '(UTC+07:00) Bangkok,Hanoi,Jakarta', 'en');
INSERT INTO `easy_tz_language` VALUES (75, 38, '(UTC+07:00) 克拉斯诺亚尔斯克(RTZ 6)', 'zh');
INSERT INTO `easy_tz_language` VALUES (76, 38, '(UTC+07:00) Krasnoyarsk(RTZ 6)', 'en');
INSERT INTO `easy_tz_language` VALUES (77, 39, '(UTC+07:00) 新西伯利亚(RTZ 5)', 'zh');
INSERT INTO `easy_tz_l
