御剑江湖新区SQL清除开区数据语句

那爱

御剑江湖新区SQL清除开区数据语句
acc_db清除开区数据:
TRUNCATE TABLE acc_handle;
TRUNCATE TABLE acc_linelog;
TRUNCATE TABLE account;
TRUNCATE TABLE admin_log;
TRUNCATE TABLE admin_message;
TRUNCATE TABLE admin_role;
TRUNCATE TABLE plugins;
TRUNCATE TABLE ser_consumelog_table;
TRUNCATE TABLE ser_loginlog;
TRUNCATE TABLE ser_supplyvaslog_table;
TRUNCATE TABLE ser_vasticketlog;
TRUNCATE TABLE sessions;
TRUNCATE TABLE sessions_data;
TRUNCATE TABLE sk_adpaylog;
TRUNCATE TABLE sk_generalize;
TRUNCATE TABLE sk_newcard;
TRUNCATE TABLE sk_paylog;
TRUNCATE TABLE sk_tool_account;
TRUNCATE TABLE sk_tpcard2;
TRUNCATE TABLE sk_vas_table;
TRUNCATE TABLE template;

wangpudb清除开区数据:
TRUNCATE TABLE logtmp;
TRUNCATE TABLE ser_playernum;
TRUNCATE TABLE wb_compensationdata;
TRUNCATE TABLE wb_compensationmsg;
TRUNCATE TABLE wb_deluser;
TRUNCATE TABLE wb_dotadata;
TRUNCATE TABLE wb_dynanpc;
TRUNCATE TABLE wb_eudemon;
alter table wb_eudemon AUTO_INCREMENT=2000000000;
TRUNCATE TABLE wb_friend;
TRUNCATE TABLE wb_gift_user;
TRUNCATE TABLE wb_instanceusetime;
TRUNCATE TABLE wb_item;
TRUNCATE TABLE wb_key;
TRUNCATE TABLE wb_leaveword;
TRUNCATE TABLE wb_magic;
TRUNCATE TABLE wb_onlinegift;
TRUNCATE TABLE wb_petegg;
TRUNCATE TABLE wb_syndicate;
TRUNCATE TABLE wb_taskdetail;
TRUNCATE TABLE wb_topheros;
TRUNCATE TABLE wb_tutor;
TRUNCATE TABLE wb_user;
alter table wb_user AUTO_INCREMENT=1000000;
TRUNCATE TABLE wb_userstatus;
TRUNCATE TABLE wb_vas_asaleitem;
TRUNCATE TABLE wb_autofight;
TRUNCATE TABLE wb_specilline_info;
TRUNCATE TABLE wb_synattr;
TRUNCATE TABLE wb_title;
TRUNCATE TABLE wb_userwargame;
TRUNCATE TABLE wb_vaslv;


yjjhpt清除开区数据:
TRUNCATE TABLE yjjhpt_additemlog;
TRUNCATE TABLE yjjhpt_adminuser;
TRUNCATE TABLE yjjhpt_admloginlog;
TRUNCATE TABLE yjjhpt_gamedaylog;
TRUNCATE TABLE yjjhpt_gamegood;
TRUNCATE TABLE yjjhpt_hourlog;
TRUNCATE TABLE yjjhpt_levellog;
TRUNCATE TABLE yjjhpt_linelog;
TRUNCATE TABLE yjjhpt_losslog;
TRUNCATE TABLE yjjhpt_minlog;
TRUNCATE TABLE yjjhpt_reglog;
TRUNCATE TABLE yjjhpt_session;
TRUNCATE TABLE yjjhpt_sysupdate;
TRUNCATE TABLE yjjhpt_user;
TRUNCATE TABLE yjjhpt_useracc;
TRUNCATE TABLE yjjhpt_userask;
TRUNCATE TABLE yjjhpt_userczlog;
TRUNCATE TABLE yjjhpt_userdaylog;
TRUNCATE TABLE yjjhpt_userrole;
TRUNCATE TABLE yjjhpt_userxflog;

drop table userdata;
CREATE TABLE IF NOT EXISTS `userdata` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `userid` int(4) NOT NULL,
  `account_id` int(4) NOT NULL,
  `name` varchar(18) NOT NULL,
  `intime` datetime DEFAULT NULL,
  `outtime` datetime DEFAULT NULL,
  `online` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `userid` (`userid`),
  UNIQUE KEY `account_id` (`account_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;