昨天的错了先删除人物装备表和装备表

INSERT INTO w_equipment (id, NAME, equip_type, equip_level, career, durable, attack, defense, crit_rate, store_price) VALUES
('j00001', '九曜戒指', '戒指', 40, '通用', 36, 11, 7, 0, '0:0:73'),
('j00002', '化魔冥戒', '戒指', 39, '幽冥刺客', 33, 13, 5, 0, '0:2:42'),
('j00003', '银魔手链', '戒指', 52, '通用', 50, 16, 14, 0, '0:5:0'),
('j00004', '虚·阎罗陨戒', '戒指', 60, '通用', 47, 15, 11, 0, '0:10:0'),
('j00005', '灵阳戒指', '戒指', 30, '通用', 26, 17, 14, 0, '0:0:85'),
('j00006', '凤羽戒指', '戒指', 50, '通用', 39, 28, 22, 0, '0:6:67'),
('j00007', '凝云戒指', '戒指', 50, '通用', 39, 7, 5, 0, '0:4:77'),
('j00008', '烈炎戒指', '戒指', 30, '通用', 26, 8, 6, 0, '0:2:42'),
('j00009', '魔蛟戒指', '戒指', 35, '通用', 29, 19, 16, 0, '0:5:33'),
('j00010', '彩灵戒指', '戒指', 35, '通用', 29, 19, 16, 0, '0:5:33'),
('j00011', '霜皇戒指', '戒指', 40, '通用', 33, 23, 18, 0, '0:5:33'),
('j00012', '龙鳞戒指', '戒指', 45, '通用', 36, 25, 19, 0, '0:6:67'),
('j00013', '霜皇戒指', '戒指', 40, '通用', 33, 23, 18, 0, '0:5:33'),
('j00014', '幻炀戒指', '戒指', 55, '通用', 44, 15, 11, 0, '0:5:72'),
('k00001', '魔岩冥服', '铠甲', 5, '幽冥刺客', 27, 0, 15, 0, '0:0:9'),
('k00002', '敏捷冥服', '铠甲', 30, '幽冥刺客', 119, 0, 19, 0, '0:2:60'),
('k00003', '七煞星之冥服', '铠甲', 30, '幽冥刺客', 140, 0, 36, 0, '0:2:67'),
('k00004', '幽冥的召唤冥服', '铠甲', 60, '幽冥刺客', 197, 0, 105, 0, '0:35:29'),
('k00005', '轻便衣甲', '铠甲', 20, '翎羽弓魂', 81, 0, 9, 0, '0:0:85'),
('k00006', '枯木衣甲', '铠甲', 10, '翎羽弓魂', 54, 0, 9, 0, '0:0:18'),
('k00007', '黑暗涌动衣甲', '铠甲', 30, '翎羽弓魂', 151, 0, 51, 0, '0:2:71'),
('k00008', '龙王的颤抖衣甲', '铠甲', 40, '翎羽弓魂', 189, 0, 68, 0, '0:5:35'),
('k00009', '轻皮冥面', '铠甲', 5, '幽冥刺客', 22, 0, 3, 0, '0:0:7'),
('k00010', '古朴战甲', '铠甲', 40, '隐龙战士', 135, 0, 29, 0, '0:5:5'),
('k00011', '鲲鹏·九霄的徘徊战甲', '铠甲', 40, '隐龙战士', 221, 0, 106, 0, '0:6:68'),
('k00012', '玄炎·灵犀的守护腰带', '铠甲', 48, '隐龙战士', 106, 0, 56, 0, '0:6:68'),
('k00013', '薄雾法袍', '铠甲', 10, '济世医师', 36, 0, 8, 0, '0:0:18'),
('k00014', '溟·四海之回响法带', '铠甲', 48, '济世医师', 60, 0, 21, 0, '0:5:18'),
('s00001', '圣乾手镯', '手镯', 60, '通用', 47, 13, 8, 0, '0:0:37'),
('s00002', '天罡手镯', '手镯', 25, '通用', 21, 6, 4, 0, '0:0:73'),
('s00003', '冥灵手镯', '手镯', 25, '通用', 21, 6, 4, 0, '0:0:73'),
('s00004', '魔蛟手镯', '手镯', 35, '通用', 29, 9, 6, 0, '0:2:42'),
('s00005', '彩灵手镯', '手镯', 35, '通用', 29, 9, 6, 0, '0:2:42'),
('s00006', '八卦护手', '手镯', 38, '通用', 40, 0, 14, 0, '0:2:8'),
('t00001', '两仪道冠', '头盔', 29, '通用', 64, 11, 21, 0, '0:2:8'),
('t00002', '毁灭头饰', '头盔', 45, '通用', 103, 22, 45, 0, '0:9:86'),
('w00001', '梦璃灵刀', '武器', 30, '隐龙战士', 88, 135, 0, 0, '0:3:17'),
('w00002', '梦璃灵匕', '武器', 30, '幽冥刺客', 88, 113, 0, 0, '0:3:17'),
('w00003', '梦璃灵剑', '武器', 30, '玄灵天师', 88, 135, 0, 0, '0:3:17'),
('w00004', '梦璃灵杖', '武器', 30, '济世医师', 40, 77, 0, 0, '0:3:17'),
('w00005', '梦璃灵弓', '武器', 30, '翎羽弓魂', 88, 158, 0, 0, '0:3:17'),
('w00006', '星宿之离玄剑', '武器', 5, '玄灵天师', 19, 11, 0, 0, '0:0:10'),
('w00007', '星宿之御藏剑', '武器', 10, '玄灵天师', 31, 17, 0, 0, '0:0:23'),
('w00008', '星宿之断魂', '武器', 20, '玄灵天师', 46, 31, 0, 0, '0:1:7'),
('w00009', '星宿之煞元', '武器', 50, '玄灵天师', 103, 82, 0, 0, '0:15:77'),
('w00010', '蝉翼利刃', '武器', 20, '幽冥刺客', 60, 55, 0, 0, '0:1:7'),
('w00011', '寻欢之匕', '武器', 30, '幽冥刺客', 96, 148, 0, 0, '0:3:17'),
('w00012', '修罗·黄泉的凝视', '武器', 40, '幽冥刺客', 132, 307, 0, 0, '0:6:32'),
('w00013', '雷公的毁灭之刺', '武器', 50, '幽冥刺客', 156, 272, 0, 0, '0:15:77'),
('w00014', '烛龙·死亡的翱翔', '武器', 50, '幽冥刺客', 168, 428, 0, 0, '0:15:77'),
('w00015', '地藏·地狱的抚摸', '武器', 60, '幽冥刺客', 208, 576, 0, 0, '0:36:70'),
('w00016', '万语的勿念之刃', '武器', 65, '幽冥刺客', 193, 434, 0, 0, '0:34:95'),
('w00017', '青铜剑', '武器', 50, '玄灵天师', 93, 58, 0, 0, '0:15:77'),
('w00018', '暗红桃木剑', '武器', 5, '玄灵天师', 19, 11, 0, 0, '0:0:10'),
('w00019', '寰宇', '武器', 10, '玄灵天师', 40, 43, 0, 0, '0:0:23'),
('w00020', '噬魔雷光剑', '武器', 30, '玄灵天师', 74, 83, 0, 0, '0:3:17'),
('w00021', '诛仙·通天之法能', '武器', 40, '玄灵天师', 102, 173, 0, 0, '0:6:32'),
('w00022', '极阳·祝融的眼泪', '武器', 50, '玄灵天师', 131, 242, 0, 0, '0:15:77'),
('w00023', '古朴长枪', '武器', 50, '隐龙战士', 125, 45, 0, 0, '0:15:77'),
('w00024', '青云', '武器', 5, '隐龙战士', 29, 67, 0, 0, '0:0:10'),
('w00025', '烈火碎尖枪', '武器', 20, '隐龙战士', 64, 185, 0, 0, '0:1:7'),
('w00026', '修罗·邪神撕裂者', '武器', 40, '隐龙战士', 119, 575, 0, 0, '0:6:32'),
('w00027', '极阳·金乌的威慑', '武器', 50, '隐龙战士', 151, 806, 0, 0, '0:15:77'),
('w00028', '桐木枪', '武器', 60, '隐龙战士', 135, 337, 0, 0, '0:34:28'),
('w00029', '极光·璇玑的坚韧', '武器', 60, '隐龙战士', 139, 1080, 0, 0, '0:36:70'),
('w00030', '风暴之五虎忠魂', '武器', 60, '隐龙战士', 135, 337, 0, 0, '0:34:28'),
('y00001', '毁灭护腰', '腰带', 45, '通用', 52, 12, 22, 0, '0:4:96'),
('y00002', '炽热·火凤之羽腰带', '腰带', 45, '通用', 50, 22, 40, 0, '0:2:17');







INSERT INTO w_chts_equip (cid, eid, is_binding, binding_address, binding_date, equip_type)
VALUES
  ('g000002', 't00001', '1', '五指山', '2020-01-01 00:00:00', '头盔'),
  ('g000007', 'j00011', '1', '宝象国', '2020-08-11 12:31:05', '戒指'),
  ('g000009', 'j00012', '0', '五指山', '2020-03-10 10:22:09', '戒指'),
  ('g000008', 'k00008', '1', '宝象国', '2020-05-09 11:30:15', '铠甲'),
  ('g000003', 'w00005', '1', '宝象国', '2020-01-10 09:01:20', '武器'),
  ('g000008', 'y00002', '1', '五指山', '2020-02-06 01:10:05', '腰带'),
  ('g000009', 'w00022', '0', '宝象国', '2020-06-11 05:01:25', '武器'),
  ('g000007', 'k00002', '1', '宝象国', '2020-08-10 09:01:15', '铠甲'),
  ('g000003', 'k00007', '1', '天宫', '2020-08-11 12:31:35', '铠甲'),
  ('g000008', 't00002', '1', '宝象国', '2020-02-21 12:31:56', '头盔'),
  ('g000004', 'w00025', '0', '火焰山', '2020-10-22 13:20:41', '武器'),
  ('g000008', 'j00003', '1', '宝象国', '2020-02-01 16:35:22', '戒指'),
  ('g000005', 'w00011', '1', '宝象国', '2020-05-07 18:37:05', '武器'),
  ('g000005', 'k00003', '1', '乌鸡国', '2020-09-17 19:49:18', '铠甲'),
  ('g000007', 'j00003', '0', '宝象国', '2020-11-26 22:21:25', '戒指'),
  ('g000006', 'w00008', '0', '乌鸡国', '2020-12-11 12:31:05', '武器'),
  ('g000007', 'w00012', '1', '宝象国', '2020-09-13 12:31:05', '武器'),
  ('g000008', 's00001', '1', '天宫', '2020-02-10 12:31:05', '手镯'),
  ('g000009', 'j00013', '0', '宝象国', '2020-01-13 12:31:05', '戒指'),
  ('g000003', 's00002', '1', '宝象国', '2020-03-21 12:31:05', '手镯'),
  ('g000005', 's00002', '1', '火焰山', '2020-05-01 12:31:05', '手镯'),
  ('g000009', 's00002', '1', '宝象国', '2020-09-11 12:31:05', '手镯'),
  ('g000009', 's00006', '1', '天宫', '2020-09-11 12:31:05', '手镯');