DELETE FROM `characters`;# 刪除人物紀錄

DELETE FROM `character_bank`;# 刪除銀行紀錄

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`;# 刪除對話紀錄
ALTER TABLE `other_chat` AUTO_INCREMENT=1;

DELETE FROM `other_cn_shop`;# 刪除元寶購買紀錄
ALTER TABLE `other_cn_shop` AUTO_INCREMENT=1;

DELETE FROM `other_enchant`;# 刪除強化紀錄

DELETE FROM `other_gmcommand`;# 刪除GM指令使用紀錄
ALTER TABLE `other_gmcommand` AUTO_INCREMENT=1;

DELETE FROM `other_pcbuy`;# 刪除買入個人商店物品紀錄
ALTER TABLE `other_pcbuy` AUTO_INCREMENT=1;

DELETE FROM `other_pcsell`;# 刪除賣出物品給個人商店紀錄
ALTER TABLE `other_pcsell` AUTO_INCREMENT=1;

DELETE FROM `other_pctrade`;# 個人物品交易紀錄
ALTER TABLE `other_pctrade` AUTO_INCREMENT=1;

DELETE FROM `other_shifting`;# 刪除裝備移轉紀錄資料
ALTER TABLE `other_shifting` AUTO_INCREMENT=1;

DELETE FROM `other_timeuser`;# 刪除線上人數紀錄
ALTER TABLE `other_timeuser` AUTO_INCREMENT=1;

DELETE FROM `server_board`;# 刪除佈告欄資料

DELETE FROM `character_gambling`;# 刪除奇岩賭場紀錄

DELETE FROM `spawnlist_furniture`;# 刪除血盟小屋家具紀錄

DELETE FROM `server_board_auction`;
-- ----------------------------
-- 復原拍賣公告內容
-- ----------------------------
INSERT INTO `server_board_auction` VALUES ('262145', '$1242 1$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  1', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262146', '$1242 2$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  2', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262147', '$1242 3$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  3', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262148', '$1242 4$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  4', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262149', '$1242 5$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  5', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262150', '$1242 6$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  6', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262151', '$1242 7$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  7', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262152', '$1242 8$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  8', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262153', '$1242 9$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  9', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262154', '$1242 10$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  10', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262155', '$1242 11$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  11', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262156', '$1242 12$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  12', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262157', '$1242 13$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  13', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262158', '$1242 14$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  14', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262159', '$1242 15$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  15', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262160', '$1242 16$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  16', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262161', '$1242 17$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  17', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262162', '$1242 18$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  18', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262163', '$1242 19$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  19', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262164', '$1242 20$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  20', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262165', '$1242 21$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  21', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262166', '$1242 22$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  22', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262167', '$1242 23$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  23', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262168', '$1242 24$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  24', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262169', '$1242 25$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  25', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262170', '$1242 26$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  26', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262171', '$1242 27$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  27', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262172', '$1242 28$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  28', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262173', '$1242 29$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  29', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262175', '$1242 31$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  31', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262176', '$1242 32$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  32', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262177', '$1242 33$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  33', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262178', '$1242 34$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  34', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262179', '$1242 35$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  35', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262180', '$1242 36$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  36', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262181', '$1242 37$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  37', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262182', '$1242 38$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  38', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262184', '$1242 40$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  40', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262185', '$1242 41$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  41', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262186', '$1242 42$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  42', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262187', '$1242 43$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  43', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262188', '$1242 44$1195', '120', '2010-09-13 21:00:00', '100000', '$1242  44', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262189', '$1242 45$1195', '78', '2010-09-13 21:00:00', '100000', '$1242  45', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327681', '$1513 1$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  1', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327682', '$1513 2$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  2', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327683', '$1513 3$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  3', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327684', '$1513 4$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  4', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327685', '$1513 5$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  5', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327686', '$1513 6$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  6', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327687', '$1513 7$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  7', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327688', '$1513 8$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  8', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327689', '$1513 9$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  9', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327690', '$1513 10$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  10', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('327691', '$1513 11$1195', '0', '2010-09-13 21:00:00', '100000', '$1513  11', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('524289', '$381 1$1195', '48', '2010-09-13 21:00:00', '100000', '$381  1', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('524290', '$381 2$1195', '71', '2010-09-13 21:00:00', '100000', '$381  2', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('524291', '$381 3$1195', '48', '2010-09-13 21:00:00', '100000', '$381  3', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('524292', '$381 4$1195', '48', '2010-09-13 21:00:00', '100000', '$381  4', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('524293', '$381 5$1195', '82', '2010-09-13 21:00:00', '100000', '$381  5', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('524294', '$381 6$1195', '40', '2010-09-13 21:00:00', '100000', '$381  6', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262174', '$1242 29$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  30', '', '0', '', '0');
INSERT INTO `server_board_auction` VALUES ('262183', '$1242 39$1195', '45', '2010-09-13 21:00:00', '100000', '$1242  39', '', '0', '', '0');

DELETE FROM `server_castle`;
-- ----------------------------
-- 復原城堡數據
-- ----------------------------
INSERT INTO `server_castle` VALUES ('1', '肯特城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('2', '妖魔城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('3', '風木城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('4', '奇巖城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('5', '海音城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('6', '侏儒城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('7', '亞丁城', '2008-09-15 00:00:00', '0', '0');
INSERT INTO `server_castle` VALUES ('8', '狄亞得要塞', '2008-09-15 00:00:00', '0', '0');

DELETE FROM `server_house`;
-- ----------------------------
-- 復原小屋數據
-- ----------------------------
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');
INSERT INTO `server_house` VALUES ('327681', '海音血盟小屋1', '0', '1', '50620', '1', '0', '2010-09-01 00:00:00', '33599', '33601', '33213', '33214', '33602', '33610', '33213', '33218', '4', '5113', '33609', '33217');
INSERT INTO `server_house` VALUES ('327682', '海音血盟小屋2', '0', '2', '50623', '1', '0', '2010-09-01 00:00:00', '33627', '33632', '33206', '33209', '0', '0', '0', '0', '4', '5114', '33630', '33209');
INSERT INTO `server_house` VALUES ('327683', '海音血盟小屋3', '0', '3', '50619', '1', '0', '2010-09-01 00:00:00', '33626', '33627', '33225', '33227', '33628', '33632', '33221', '33230', '4', '5115', '33628', '33226');
INSERT INTO `server_house` VALUES ('327684', '海音血盟小屋4', '0', '4', '50621', '1', '0', '2010-09-01 00:00:00', '33628', '33636', '33241', '33244', '33632', '33635', '33245', '33250', '4', '5116', '33633', '33248');
INSERT INTO `server_house` VALUES ('327685', '海音血盟小屋5', '0', '5', '50622', '1', '0', '2010-09-01 00:00:00', '33616', '33621', '33262', '33265', '0', '0', '0', '0', '4', '5117', '33619', '33265');
INSERT INTO `server_house` VALUES ('327686', '海音血盟小屋6', '0', '6', '50624', '1', '0', '2010-09-01 00:00:00', '33570', '33580', '33228', '33232', '33574', '33576', '33233', '33234', '4', '5118', '33575', '33233');
INSERT INTO `server_house` VALUES ('327687', '海音血盟小屋7', '0', '7', '50617', '1', '0', '2010-09-01 00:00:00', '33583', '33588', '33305', '33314', '33587', '33588', '33315', '33316', '4', '5119', '33584', '33306');
INSERT INTO `server_house` VALUES ('327688', '海音血盟小屋8', '0', '8', '50614', '1', '0', '2010-09-01 00:00:00', '33577', '33578', '33337', '33337', '33579', '33588', '33335', '33339', '4', '5120', '33581', '33338');
INSERT INTO `server_house` VALUES ('327689', '海音血盟小屋9', '0', '9', '50618', '1', '0', '2010-09-01 00:00:00', '33615', '33623', '33374', '33377', '33619', '33622', '33378', '33383', '4', '5121', '33620', '33381');
INSERT INTO `server_house` VALUES ('327690', '海音血盟小屋10', '0', '10', '50616', '1', '0', '2010-09-01 00:00:00', '33624', '33625', '33397', '33399', '33626', '33630', '33393', '33403', '4', '5122', '33625', '33398');
INSERT INTO `server_house` VALUES ('327691', '海音血盟小屋11', '0', '11', '50615', '1', '0', '2010-09-01 21:00:00', '33621', '33622', '33444', '33444', '33622', '33632', '33442', '33446', '4', '5123', '33625', '33445');
INSERT INTO `server_house` VALUES ('458753', '亞丁血盟小屋1', '51', '1', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458754', '亞丁血盟小屋2', '24', '2', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458755', '亞丁血盟小屋3', '24', '3', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458756', '亞丁血盟小屋4', '56', '4', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458757', '亞丁血盟小屋5', '24', '5', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458758', '亞丁血盟小屋6', '63', '6', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458759', '亞丁血盟小屋7', '24', '7', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458760', '亞丁血盟小屋8', '63', '8', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458761', '亞丁血盟小屋9', '24', '9', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458762', '亞丁血盟小屋10', '24', '10', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458763', '亞丁血盟小屋11', '24', '11', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458764', '亞丁血盟小屋12', '24', '12', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458765', '亞丁血盟小屋13', '24', '13', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458766', '亞丁血盟小屋14', '63', '14', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458767', '亞丁血盟小屋15', '24', '15', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458768', '亞丁血盟小屋16', '56', '16', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458769', '亞丁血盟小屋17', '63', '17', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458770', '亞丁血盟小屋18', '24', '18', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458771', '亞丁血盟小屋19', '32', '19', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458772', '亞丁血盟小屋20', '64', '20', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458773', '亞丁血盟小屋21', '24', '21', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458774', '亞丁血盟小屋22', '20', '22', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458775', '亞丁血盟小屋23', '24', '23', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458776', '亞丁血盟小屋24', '56', '24', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458777', '亞丁血盟小屋25', '24', '25', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458778', '亞丁血盟小屋26', '20', '26', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458779', '亞丁血盟小屋27', '42', '27', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458780', '亞丁血盟小屋28', '15', '28', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458781', '亞丁血盟小屋29', '24', '29', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458782', '亞丁血盟小屋30', '24', '30', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458783', '亞丁血盟小屋31', '42', '31', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458784', '亞丁血盟小屋32', '48', '32', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458785', '亞丁血盟小屋33', '24', '33', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458786', '亞丁血盟小屋34', '15', '34', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458787', '亞丁血盟小屋35', '24', '35', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458788', '亞丁血盟小屋36', '24', '36', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458789', '亞丁血盟小屋37', '64', '37', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458790', '亞丁血盟小屋38', '15', '38', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458791', '亞丁血盟小屋39', '15', '39', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458792', '亞丁血盟小屋40', '24', '40', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458793', '亞丁血盟小屋41', '24', '41', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458794', '亞丁血盟小屋42', '29', '42', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458795', '亞丁血盟小屋43', '24', '43', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458796', '亞丁血盟小屋44', '15', '44', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458797', '亞丁血盟小屋45', '56', '45', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458798', '亞丁血盟小屋46', '15', '46', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458799', '亞丁血盟小屋47', '24', '47', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458800', '亞丁血盟小屋48', '24', '48', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458801', '亞丁血盟小屋49', '24', '49', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458802', '亞丁血盟小屋50', '48', '50', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458803', '亞丁血盟小屋51', '24', '51', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458804', '亞丁血盟小屋52', '24', '52', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458805', '亞丁血盟小屋53', '54', '53', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458806', '亞丁血盟小屋54', '24', '54', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458807', '亞丁血盟小屋55', '63', '55', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458808', '亞丁血盟小屋56', '63', '56', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458809', '亞丁血盟小屋57', '42', '57', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458810', '亞丁血盟小屋58', '24', '58', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458811', '亞丁血盟小屋59', '24', '59', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458812', '亞丁血盟小屋60', '63', '60', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458813', '亞丁血盟小屋61', '24', '61', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458814', '亞丁血盟小屋62', '21', '62', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458815', '亞丁血盟小屋63', '63', '63', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458816', '亞丁血盟小屋64', '24', '64', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458817', '亞丁血盟小屋65', '24', '65', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458818', '亞丁血盟小屋66', '48', '66', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('458819', '亞丁血盟小屋67', '24', '67', '0', '1', '0', '2010-09-01 00:00:00', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0');
INSERT INTO `server_house` VALUES ('524289', '古魯丁血盟小屋1', '48', '1', '50626', '1', '0', '2010-03-01 00:00:00', '32559', '32566', '32669', '32676', '0', '0', '0', '0', '4', '0', '32564', '32675');
INSERT INTO `server_house` VALUES ('524290', '古魯丁血盟小屋2', '71', '2', '50627', '1', '0', '2010-09-01 00:00:00', '32548', '32556', '32705', '32716', '32547', '32547', '32710', '32716', '4', '0', '32549', '32707');
INSERT INTO `server_house` VALUES ('524291', '古魯丁血盟小屋3', '48', '3', '50628', '1', '0', '2010-09-01 00:00:00', '32537', '32544', '32781', '32791', '0', '0', '0', '0', '4', '0', '32538', '32782');
INSERT INTO `server_house` VALUES ('524292', '古魯丁血盟小屋4', '48', '4', '50629', '1', '0', '2010-09-01 00:00:00', '32550', '32560', '32780', '32787', '0', '0', '0', '0', '4', '0', '32558', '32786');
INSERT INTO `server_house` VALUES ('524293', '古魯丁血盟小屋5', '82', '5', '50630', '1', '0', '2010-09-01 00:00:00', '32535', '32543', '32807', '32818', '32534', '32534', '32812', '32818', '4', '0', '32536', '32809');
INSERT INTO `server_house` VALUES ('524294', '古魯丁血盟小屋6', '40', '6', '50631', '1', '0', '2010-09-01 00:00:00', '32553', '32560', '32814', '32821', '0', '0', '0', '0', '4', '0', '32554', '32819');

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);



