truncate table ecw_dock;
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (4, '黄埔', 'huangpu', 99, 'pc', 130, '中国', 'China', 149, '广东省', 'Guangdong', 360, '广州市', 'Guangzhou', '2', '1', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (5, 'APAPA', 'apapa', 99, 'pc', 4174, '尼日利亚', 'Nigeria', 4179, '拉各斯（尼日利亚）', 'Lagso', 4181, '拉各斯（尼日利亚）', 'Lagos', '2', '2', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (6, '南沙', '南沙', 99, 'pc', 130, '中国', 'China', 149, '广东省', 'Guangdong', 360, '广州市', 'Guangzhou', '2', '3', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (7, 'ONNE', 'ONNE', 99, 'pc', 4174, '尼日利亚', 'Nigeria', 4180, '奥尼查（尼日利亚）', 'Onitsha', 4182, '奥尼查（尼日利亚）', 'Onitsha', '2', '4', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (8, 'Tema', 'Tema', 99, 'pc', 4175, '加纳', 'Ghana', 4183, '首都', 'Acrra', 4184, '阿克拉（加纳）', 'Accra', '2', '5', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (9, '宁波', 'ningbo', 99, 'pc', 130, '中国', 'China', 141, '浙江省', 'Zhejiang', 4173, '义乌市', 'Yiwu', '2', '6', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (10, 'TINCAN', 'TINCAN', 99, 'pc', 4174, '尼日利亚', 'Nigeria', 4179, '拉各斯（尼日利亚）', 'Lagso', 4181, '拉各斯（尼日利亚）', 'Lagos', '2', '7', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (11, '蛇口', 'shekou', 99, 'pc', 130, '中国', 'China', 149, '广东省', 'Guangdong', 360, '广州市', 'Guangzhou', '2', '8', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');
INSERT INTO `ecw_dock` (`id`, `title_zh`, `title_en`, `sort`, `source`, `country_id`, `country_zh`, `country_en`, `province_id`, `province_zh`, `province_en`, `city_id`, `city_zh`, `city_en`, `port_type`, `number`, `type`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (12, '上海', 'Shanghai', 99, 'pc', 130, '中国', 'China', 149, '广东省', 'Guangdong', 360, '广州市', 'Guangzhou', '2', '9', '1', 0, '1', '2022-10-11 09:33:45', '1', '2022-10-11 10:39:43', b'0');


-- INSERT into ecw_dock(id,title_zh,title_en,sort,source,country_id, country_zh, country_en, province_id, province_zh, province_en,
-- city_id, city_zh, city_en, number, type,port_type,creator,updater) SELECT id, title_zh, title_en, sort,source,country_id, country_zh, country_en, province_id, province_zh,province_en,city_id, city_zh, city_en, number, type,2,1,1 from jidedao_old.ecw_dock;
-- 
-- update ecw_dock set zhou=115 where zhou=1;
-- update ecw_dock set zhou=116 where zhou=3;
-- 
-- update ecw_dock set country_id=130 where country_id=8;
-- update ecw_dock set country_id=4174 where country_id=16;
-- update ecw_dock set country_id=4175 where country_id=21;
-- update ecw_dock set country_id=4176 where country_id=26;
-- update ecw_dock set country_id=4177 where country_id=29;
-- update ecw_dock set country_id=4178 where country_id=33;
-- update ecw_dock set country_id=4191 where country_id=44;
-- 
-- update ecw_dock set province_id=149 where province_id=9;
-- update ecw_dock set province_id=141 where province_id=12;
-- update ecw_dock set province_id=4179 where province_id=17;
-- update ecw_dock set province_id=4180 where province_id=24;
-- update ecw_dock set province_id=4183 where province_id=22;
-- update ecw_dock set province_id=4185 where province_id=27;  
-- update ecw_dock set province_id=4194 where province_id=36;   
-- update ecw_dock set province_id=4196 where province_id=37;  
-- update ecw_dock set province_id=4198 where province_id=38;   
-- update ecw_dock set province_id=4200 where province_id=39;  
-- update ecw_dock set province_id=4187 where province_id=30;  
-- update ecw_dock set province_id=4189 where province_id=34;  
-- update ecw_dock set province_id=4192 where province_id=45;  
-- 
-- update ecw_dock set city_id=4173 where city_id=14;
-- update ecw_dock set city_id=360 where city_id=10;
-- update ecw_dock set city_id=4181 where city_id=18; 
-- update ecw_dock set city_id=4184 where city_id=23;
-- update ecw_dock set city_id=4182 where city_id=25;
-- update ecw_dock set city_id=4186 where city_id=28;
-- update ecw_dock set city_id=4188 where city_id=31;
-- update ecw_dock set city_id=4190 where city_id=35;
-- update ecw_dock set city_id=4195 where city_id=40;
-- update ecw_dock set city_id=4197 where city_id=41;
-- update ecw_dock set city_id=4199 where city_id=42;
-- update ecw_dock set city_id=4201 where city_id=43;
-- update ecw_dock set city_id=4193 where city_id=46;