truncate table ecw_warehouse;
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1, 1, 1, 1, 'ECCBW0001', 'CNG', '广州仓', 'Guangzhou', '500', '广州市白云区鹤边鹤泰二横路明通院内第一栋捷道仓库E&C（可导航明通重型物流集团）（收货时间周一至周六 10:00-19:30）', 'Hebian,Baiyun District, Guangzhou, Guangdong, China.', 115, 130, 149, 360, '林先生', '13560324154/02036383537', '2', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:26:26', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (2, 2, 2, 1, 'ECNBW001', '', 'Alaba', 'Alaba ', '1400', 'Alaba', 'Alaba', 116, 4174, 4179, 4181, 'Jerry ', '07013313537', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:26:36', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (3, 3, 3, 1, 'ECCW002', 'CNY', '义乌仓', 'Yiwu', '220', '浙江省义乌市机场路633号园区一号楼（靠近景三路这栋楼）捷道仓库', 'Yiwu，Zhejiang Province, China', 115, 130, 141, 4173, 'Kevin', '18266918809', '2', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:26:43', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (4, 4, 4, 1, 'ECNW002', '', 'Tradefair', 'Tradefair', '', 'Trade fair', 'Trade fair Lagos Nigeria', 116, 4174, 4179, 4181, 'Anna ', '', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:26:55', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (5, 5, 5, 1, 'ECNW003', '', 'Lagos Island', 'Lagos Island', '100', 'Lagos Island', 'Lagos Island Market，Lagos， Nigeria', 116, 4174, 4179, 4181, 'Shedy Okpara ', '09025168630', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:27:03', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (6, 6, 6, 1, 'ECNW004', '', 'Oshodi', 'Oshodi', '50', 'Oshodi', 'nearby computer village, Ikeja, Lagos, Nigeria ', 116, 4174, 4179, 4181, 'Nkechi ', '09023977762', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:27:14', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (7, 2, 6, 1, '007', '', '007', '007', '', '', '', 116, 4174, 4179, 4181, '', '', '1', '', '', '', 11, 1, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:27:33', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (8, 7, 7, 1, 'ECGW001', '', 'Accra', 'Accra', '', 'Accra', '', 116, 4175, 4183, 4184, 'Henry', '+233540444012', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:27:56', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (10, 8, 8, 1, 'ECNW005', '', 'Onitsha', 'Onitsha', '', 'Onitsha', '', 116, 4174, 4180, 4182, '', '', '1', '1,2,3,4', '', '', 9, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:28:08', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (11, 9, 9, 1, 'ECMW001', '', 'Maputo', 'Maputo', '', 'Maputo', '', 116, 4176, 4185, 4186, '', '', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:31', '115', '2022-09-29 16:28:17', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (12, 10, 10, 1, 'ECKBW001', '', 'Nairobi', 'Nairobi', '', 'Nairobi', '', 116, 4177, 4187, 4188, '', '', '1', '1,2,3,4', '', '', 1, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:28:27', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (13, 11, 11, 1, 'ECNW006', '', 'X', 'X', '', 'X', '', 116, 4174, 4179, 4181, '', '', '1', '1', '', '', 10, 1, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:31:45', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (14, 12, 12, 1, 'ECWD001', '', 'Dubai', 'Dubai', '', '', '', 116, 4178, 4189, 4190, '', '', '1', '1', '', '', 1, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:31:59', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (15, 9, 9, 1, 'ECMW002', '', 'Beira', 'Beira', '', 'Beira', 'Beira', 116, 4176, 4194, 4195, '', '', '1', '1', '', '', 2, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:38:17', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (16, 9, 9, 1, 'ECMW003', '', 'Chimoio', 'Chimoio', '', 'Chimoio', 'Chimoio', 116, 4176, 4196, 4197, '', '', '1', '1', '', '', 3, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:38:28', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (17, 9, 9, 1, 'ECMW004', '', 'Quelimane', 'Quelimane', '', 'Quelimane', 'Quelimane', 116, 4176, 4198, 4199, '', '', '1', '1', '', '', 4, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:38:32', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (18, 9, 9, 1, 'ECMW005', '', 'Nampula', 'Nampula', '', 'Nampula', 'Nampula', 116, 4176, 4200, 4201, '', '', '1', '1', '', '', 5, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:38:36', b'0');
INSERT INTO `ecw_warehouse` (`id`, `pid`, `node_id`, `type`, `number`, `qianzhui`, `title_zh`, `title_en`, `volume`, `address_zh`, `address_en`, `zhou`, `guojia`, `sheng`, `shi`, `head`, `tell`, `trade_type`, `freight`, `img`, `remark`, `sort`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (19, 13, 13, 1, 'ECCW001', '', 'Abidjan', 'Abidjan', '', '', '', 116, 4191, 4192, 4193, '', '', '1', '1', '', '', 1, 0, '115', '2022-09-29 16:22:32', '115', '2022-09-29 16:32:31', b'0');