資料表清除SQL語句

彻底悟了

	DELETE FROM `characters`;# 刪除人物紀錄 DELETE FROM `character_bank`;# 刪除銀行紀錄 DELETE FROM `character_c1`;# 刪除官階陣營 DELETE FROM `character_buddys`;# 刪除好友紀錄 DELETE FROM `character_buff`;# 刪除技能保留紀錄 DELETE FROM `character_config`;# 刪除快速鍵紀錄 DELETE FROM `character_mail`;# 刪除信件資料 DELETE FROM `character_pets`;# 刪除寵物資料表 DELETE FROM `character_quests`;# 刪除任務紀錄 DELETE FROM `character_skills`;# 刪除人物技能紀錄 DELETE FROM `character_teleport`;# 刪除記憶座標紀錄資料 DELETE FROM `character_other`;# 刪除額外紀錄資料 DELETE FROM `character_items`;# 刪除人物背包資料 DELETE FROM `character_warehouse`;# 刪除倉庫物件清單 DELETE FROM `character_elf_warehouse`;# 刪除精靈倉庫物件清單 DELETE FROM `character_vip`;# 刪除VIP紀錄資料 DELETE FROM `character_shop`;# 刪除託售資訊 DELETE FROM `character_shopinfo`;# 刪除託售物件清單 DELETE FROM `character_item_power`;# 刪除武器防具凹槽記錄 DELETE FROM `clan_data`;# 刪除血盟資料 DELETE FROM `clan_emblem`;# 刪除盟輝圖檔紀錄 DELETE FROM `clan_warehouse`;# 刪除血盟倉庫物件清單 DELETE FROM `other_topc`; DELETE FROM `character_items_time`;# 刪除使用時間限制資料 DELETE FROM `other_chat`;# 刪除對話紀錄 -- ---------------------------- -- 復原拍賣公告內容 -- ---------------------------- INSERT INTO `server_board_auction` VALUES ('262145', '$1242 1$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  1', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262146', '$1242 2$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  2', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262147', '$1242 3$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  3', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262148', '$1242 4$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  4', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262149', '$1242 5$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  5', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262150', '$1242 6$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  6', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262151', '$1242 7$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  7', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262152', '$1242 8$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  8', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262153', '$1242 9$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  9', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262154', '$1242 10$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  10', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262155', '$1242 11$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  11', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262156', '$1242 12$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  12', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262157', '$1242 13$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  13', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262158', '$1242 14$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  14', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262159', '$1242 15$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  15', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262160', '$1242 16$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  16', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262161', '$1242 17$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  17', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262162', '$1242 18$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  18', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262163', '$1242 19$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  19', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262164', '$1242 20$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  20', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262165', '$1242 21$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  21', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262166', '$1242 22$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  22', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262167', '$1242 23$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  23', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262168', '$1242 24$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  24', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262169', '$1242 25$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  25', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262170', '$1242 26$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  26', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262171', '$1242 27$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  27', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262172', '$1242 28$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  28', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262173', '$1242 29$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  29', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262174', '$1242 29$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  30', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262175', '$1242 31$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  31', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262176', '$1242 32$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  32', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262177', '$1242 33$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  33', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262178', '$1242 34$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  34', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262179', '$1242 35$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  35', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262180', '$1242 36$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  36', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262181', '$1242 37$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  37', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262182', '$1242 38$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  38', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262183', '$1242 39$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  39', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262184', '$1242 40$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  40', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262185', '$1242 41$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  41', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262186', '$1242 42$1195', '45', '2010-09-13 21:00:00', '200000000', '$1242  42', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262187', '$1242 43$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  43', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262188', '$1242 44$1195', '120', '2010-09-13 21:00:00', '200000000', '$1242  44', '', '0', '', '0'); INSERT INTO `server_board_auction` VALUES ('262189', '$1242 45$1195', '78', '2010-09-13 21:00:00', '200000000', '$1242  45', '', '0', '', '0'); DELETE FROM `server_castle`; -- ---------------------------- -- 復原小屋數據 -- ---------------------------- INSERT INTO `server_house` VALUES ('262145', '奇岩血盟小屋1', '78', '1', '50527', '1', '0', '2010-09-01 00:00:00', '33368', '33375', '32651', '32654', '33373', '33375', '32655', '32657', '4', '5068', '33374', '32657'); INSERT INTO `server_house` VALUES ('262146', '奇岩血盟小屋2', '45', '2', '50505', '1', '0', '2010-09-01 00:00:00', '33381', '33387', '32653', '32656', '0', '0', '0', '0', '4', '5069', '33384', '32655'); INSERT INTO `server_house` VALUES ('262147', '奇岩血盟小屋3', '120', '3', '50519', '1', '0', '2010-09-01 00:00:00', '33392', '33404', '32650', '32656', '0', '0', '0', '0', '4', '5070', '33395', '32656'); INSERT INTO `server_house` VALUES ('262148', '奇岩血盟小屋4', '45', '4', '50545', '1', '0', '2010-09-01 00:00:00', '33427', '33430', '32656', '32662', '0', '0', '0', '0', '4', '5071', '33428', '32659'); INSERT INTO `server_house` VALUES ('262149', '奇岩血盟小屋5', '78', '5', '50531', '1', '0', '2010-09-01 00:00:00', '33439', '33445', '32665', '32667', '33442', '33445', '32668', '32672', '4', '5072', '33439', '32666'); INSERT INTO `server_house` VALUES ('262150', '奇岩血盟小屋6', '120', '6', '50529', '1', '0', '2010-09-01 00:00:00', '33454', '33466', '32648', '32654', '0', '0', '0', '0', '4', '5073', '33457', '32654'); INSERT INTO `server_house` VALUES ('262151', '奇岩血盟小屋7', '45', '7', '50516', '1', '0', '2010-09-01 00:00:00', '33476', '33479', '32665', '32671', '0', '0', '0', '0', '4', '5074', '33477', '32668'); INSERT INTO `server_house` VALUES ('262152', '奇岩血盟小屋8', '78', '8', '50538', '1', '0', '2010-09-01 00:00:00', '33471', '33477', '32678', '32680', '33474', '33477', '32681', '32685', '4', '5075', '33471', '32679'); INSERT INTO `server_house` VALUES ('262153', '奇岩血盟小屋9', '78', '9', '50518', '1', '0', '2010-09-01 00:00:00', '33453', '33460', '32694', '32697', '33458', '33460', '32698', '32700', '4', '5076', '33459', '32700'); INSERT INTO `server_house` VALUES ('262154', '奇岩血盟小屋10', '120', '10', '50509', '1', '0', '2010-09-01 00:00:00', '33421', '33433', '32685', '32691', '0', '0', '0', '0', '4', '5077', '33424', '32691'); INSERT INTO `server_house` VALUES ('262155', '奇岩血盟小屋11', '78', '11', '50536', '1', '0', '2010-09-01 00:00:00', '33409', '33415', '32674', '32676', '33412', '33415', '32677', '32681', '4', '5078', '33409', '32675'); INSERT INTO `server_house` VALUES ('262156', '奇岩血盟小屋12', '78', '12', '50520', '1', '0', '2010-09-01 00:00:00', '33414', '33421', '32703', '32706', '33419', '33421', '32707', '32709', '4', '5079', '33420', '32709'); INSERT INTO `server_house` VALUES ('262157', '奇岩血盟小屋13', '120', '13', '50543', '1', '0', '2010-09-01 00:00:00', '33372', '33384', '32692', '32698', '0', '0', '0', '0', '4', '5080', '33375', '32698'); INSERT INTO `server_house` VALUES ('262158', '奇岩血盟小屋14', '78', '14', '50526', '1', '0', '2010-09-01 00:00:00', '33362', '33365', '32681', '32687', '0', '0', '0', '0', '4', '5081', '33363', '32684'); INSERT INTO `server_house` VALUES ('262159', '奇岩血盟小屋15', '45', '15', '50512', '1', '0', '2010-09-01 00:00:00', '33360', '33366', '32669', '32671', '33363', '33366', '32672', '32676', '4', '5082', '33360', '32670'); INSERT INTO `server_house` VALUES ('262160', '奇岩血盟小屋16', '78', '16', '50510', '1', '0', '2010-09-01 00:00:00', '33341', '33347', '32660', '32662', '33344', '33347', '32663', '32667', '4', '5083', '33341', '32661'); INSERT INTO `server_house` VALUES ('262161', '奇岩血盟小屋17', '45', '17', '50504', '1', '0', '2010-09-01 00:00:00', '33345', '33348', '32672', '32678', '0', '0', '0', '0', '4', '5084', '33346', '32675'); INSERT INTO `server_house` VALUES ('262162', '奇岩血盟小屋18', '120', '18', '50525', '1', '0', '2010-09-01 00:00:00', '33338', '33350', '32704', '32711', '0', '0', '0', '0', '4', '5085', '33341', '32710'); INSERT INTO `server_house` VALUES ('262163', '奇岩血盟小屋19', '78', '19', '50534', '1', '0', '2010-09-01 00:00:00', '33349', '33356', '32728', '32731', '33354', '33356', '32732', '32734', '4', '5086', '33355', '32734'); INSERT INTO `server_house` VALUES ('262164', '奇岩血盟小屋20', '78', '20', '50540', '1', '0', '2010-09-01 00:00:00', '33366', '33372', '32713', '32715', '33369', '33372', '32716', '32720', '4', '5087', '33366', '32714'); INSERT INTO `server_house` VALUES ('262165', '奇岩血盟小屋21', '45', '21', '50515', '1', '0', '2010-09-01 00:00:00', '33380', '33383', '32712', '32718', '0', '0', '0', '0', '4', '5088', '33381', '32715'); INSERT INTO `server_house` VALUES ('262166', '奇岩血盟小屋22', '120', '22', '50513', '1', '0', '2010-09-01 00:00:00', '33401', '33413', '32733', '32739', '0', '0', '0', '0', '4', '5089', '33404', '32739'); INSERT INTO `server_house` VALUES ('262167', '奇岩血盟小屋23', '78', '23', '50528', '1', '0', '2010-09-01 00:00:00', '33424', '33430', '32717', '32719', '33427', '33430', '32720', '32724', '4', '5090', '33424', '32718'); INSERT INTO `server_house` VALUES ('262168', '奇岩血盟小屋24', '45', '24', '50533', '1', '0', '2010-09-01 00:00:00', '33448', '33451', '32729', '32735', '0', '0', '0', '0', '4', '5091', '33449', '32732'); INSERT INTO `server_house` VALUES ('262169', '奇岩血盟小屋25', '45', '25', '50542', '1', '0', '2010-09-01 00:00:00', '33404', '33407', '32754', '32760', '0', '0', '0', '0', '4', '5092', '33405', '32757'); INSERT INTO `server_house` VALUES ('262170', '奇岩血盟小屋26', '120', '26', '50511', '1', '0', '2010-09-01 00:00:00', '33363', '33375', '32755', '32761', '0', '0', '0', '0', '4', '5093', '33366', '32761'); INSERT INTO `server_house` VALUES ('262171', '奇岩血盟小屋27', '78', '27', '50501', '1', '0', '2010-09-01 00:00:00', '33351', '33357', '32774', '32776', '33354', '33357', '32777', '32781', '4', '5094', '33351', '32775'); INSERT INTO `server_house` VALUES ('262172', '奇岩血盟小屋28', '45', '28', '50503', '1', '0', '2010-09-01 00:00:00', '33355', '33361', '32787', '32790', '0', '0', '0', '0', '4', '5095', '33358', '32789'); INSERT INTO `server_house` VALUES ('262173', '奇岩血盟小屋29', '78', '29', '50508', '1', '0', '2010-09-01 05:00:00', '33366', '33373', '32786', '32789', '33371', '33373', '32790', '32792', '4', '5096', '33372', '32792'); INSERT INTO `server_house` VALUES ('262174', '奇岩血盟小屋30', '45', '30', '50514', '1', '0', '2010-09-01 00:00:00', '33383', '33386', '32773', '32779', '0', '0', '0', '0', '4', '5097', '33384', '32776'); INSERT INTO `server_house` VALUES ('262175', '奇岩血盟小屋31', '78', '31', '50532', '1', '0', '2010-09-01 00:00:00', '33397', '33404', '32788', '32791', '33402', '33404', '32792', '32794', '4', '5098', '33403', '32794'); INSERT INTO `server_house` VALUES ('262176', '奇岩血盟小屋32', '78', '32', '50544', '1', '0', '2010-09-01 00:00:00', '33479', '33486', '32788', '32791', '33484', '33486', '32792', '32794', '4', '5099', '33485', '32794'); INSERT INTO `server_house` VALUES ('262177', '奇岩血盟小屋33', '45', '33', '50524', '1', '0', '2010-09-01 00:00:00', '33498', '33501', '32801', '32807', '0', '0', '0', '0', '4', '5100', '33499', '32804'); INSERT INTO `server_house` VALUES ('262178', '奇岩血盟小屋34', '45', '34', '50535', '1', '0', '2010-09-01 00:00:00', '33379', '33385', '32802', '32805', '0', '0', '0', '0', '4', '5101', '33382', '32804'); INSERT INTO `server_house` VALUES ('262179', '奇岩血盟小屋35', '120', '35', '50521', '1', '0', '2010-09-01 00:00:00', '33373', '33385', '32822', '32829', '0', '0', '0', '0', '4', '5102', '33376', '32828'); INSERT INTO `server_house` VALUES ('262180', '奇岩血盟小屋36', '45', '36', '50517', '1', '0', '2010-09-01 00:00:00', '33398', '33401', '32810', '32816', '0', '0', '0', '0', '4', '5103', '33399', '32813'); INSERT INTO `server_house` VALUES ('262181', '奇岩血盟小屋37', '78', '37', '50537', '1', '0', '2010-09-01 00:00:00', '33397', '33403', '32821', '32823', '33400', '33403', '32824', '32828', '4', '5104', '33397', '32822'); INSERT INTO `server_house` VALUES ('262182', '奇岩血盟小屋38', '78', '38', '50539', '1', '0', '2010-09-01 00:00:00', '33431', '33438', '32838', '32841', '33436', '33438', '32842', '32844', '4', '5105', '33437', '32844'); INSERT INTO `server_house` VALUES ('262183', '奇岩血盟小屋39', '45', '39', '50507', '1', '1', '2010-09-01 00:00:00', '33456', '33462', '32838', '32841', '0', '0', '0', '0', '4', '5106', '33459', '32840'); INSERT INTO `server_house` VALUES ('262184', '奇岩血盟小屋40', '78', '40', '50530', '1', '0', '2010-09-01 00:00:00', '33385', '33392', '32845', '32848', '33390', '33392', '32849', '32851', '4', '5107', '33391', '32851'); INSERT INTO `server_house` VALUES ('262185', '奇岩血盟小屋41', '78', '41', '50502', '1', '0', '2010-09-01 00:00:00', '33399', '33405', '32859', '32861', '33402', '33405', '32862', '32866', '4', '5108', '33399', '32860'); INSERT INTO `server_house` VALUES ('262186', '奇岩血盟小屋42', '45', '42', '50506', '1', '0', '2010-09-01 00:00:00', '33414', '33417', '32850', '32856', '0', '0', '0', '0', '4', '5109', '33415', '32853'); INSERT INTO `server_house` VALUES ('262187', '奇岩血盟小屋43', '120', '43', '50522', '1', '0', '2010-09-01 00:00:00', '33372', '33384', '32867', '32873', '0', '0', '0', '0', '4', '5110', '33375', '32873'); INSERT INTO `server_house` VALUES ('262188', '奇岩血盟小屋44', '120', '44', '50541', '1', '0', '2010-09-01 00:00:00', '33425', '33437', '32865', '32871', '0', '0', '0', '0', '4', '5111', '33428', '32871'); INSERT INTO `server_house` VALUES ('262189', '奇岩血盟小屋45', '78', '45', '50523', '1', '0', '2010-09-01 00:00:00', '33443', '33449', '32869', '32871', '33446', '33449', '32872', '32876', '4', '5112', '33443', '32870'); DELETE FROM `server_town`; -- ---------------------------- -- 復原村莊數據 -- ---------------------------- INSERT INTO `server_town` VALUES ('1', '說話之島村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('2', '銀騎士村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('3', '古魯丁村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('4', '燃柳村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('5', '風木村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('6', '肯特村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('7', '奇岩村莊', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('8', '海音村', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('9', '威頓村', '0', null, '0', '0', '0', '0', '0', '0', null); INSERT INTO `server_town` VALUES ('10', '歐瑞村', '0', null, '0', '0', '0', '0', '0', '0', null);