Have fun
PHP Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `bootlog`
-- ----------------------------
DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
`time` int(11) DEFAULT NULL,
`hostname` int(11) DEFAULT NULL,
`channel` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of bootlog
-- ----------------------------
-- ----------------------------
-- Table structure for `command_log`
-- ----------------------------
DROP TABLE IF EXISTS `command_log`;
CREATE TABLE `command_log` (
`userid` int(11) DEFAULT NULL,
`server` int(11) DEFAULT NULL,
`ip` text,
`port` int(11) DEFAULT NULL,
`username` varchar(12) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',
`command` varchar(20) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of command_log
-- ----------------------------
-- ----------------------------
-- Table structure for `fish_log`
-- ----------------------------
DROP TABLE IF EXISTS `fish_log`;
CREATE TABLE `fish_log` (
`1` int(11) DEFAULT NULL,
`2` int(11) DEFAULT NULL,
`3` int(11) DEFAULT NULL,
`4` int(11) DEFAULT NULL,
`5` int(11) DEFAULT NULL,
`6` int(11) DEFAULT NULL,
`7` int(11) DEFAULT NULL,
`8` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of fish_log
-- ----------------------------
-- ----------------------------
-- Table structure for `gmhost`
-- ----------------------------
DROP TABLE IF EXISTS `gmhost`;
CREATE TABLE `gmhost` (
`mIP` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`mIP`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
-- ----------------------------
-- Records of gmhost
-- ----------------------------
-- ----------------------------
-- Table structure for `gmlist`
-- ----------------------------
DROP TABLE IF EXISTS `gmlist`;
CREATE TABLE `gmlist` (
`mID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mAccount` varchar(16) NOT NULL DEFAULT '',
`mName` varchar(16) NOT NULL DEFAULT '',
`mContactIP` varchar(16) NOT NULL DEFAULT '',
`mServerIP` varchar(16) NOT NULL DEFAULT 'ALL',
`mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') DEFAULT 'PLAYER',
PRIMARY KEY (`mID`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
-- ----------------------------
-- Records of gmlist
-- ----------------------------
-- ----------------------------
-- Table structure for `hack_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_log`;
CREATE TABLE `hack_log` (
`time` time DEFAULT NULL,
`login` longtext COLLATE big5_bin,
`name` varchar(11) COLLATE big5_bin DEFAULT NULL,
`ip` text CHARACTER SET latin1,
`server` varchar(11) COLLATE big5_bin DEFAULT NULL,
`why` varchar(22) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of hack_log
-- ----------------------------
-- ----------------------------
-- Table structure for `levellog`
-- ----------------------------
DROP TABLE IF EXISTS `levellog`;
CREATE TABLE `levellog` (
`name` varchar(50) COLLATE big5_bin DEFAULT NULL,
`level` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`playtime` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of levellog
-- ----------------------------
-- ----------------------------
-- Table structure for `locale`
-- ----------------------------
DROP TABLE IF EXISTS `locale`;
CREATE TABLE `locale` (
`mKey` varchar(255) NOT NULL DEFAULT '',
`mValue` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`mKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of locale
-- ----------------------------
-- ----------------------------
-- Table structure for `locale_bug`
-- ----------------------------
DROP TABLE IF EXISTS `locale_bug`;
CREATE TABLE `locale_bug` (
`mKey` varchar(255) NOT NULL DEFAULT '',
`mValue` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`mKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of locale_bug
-- ----------------------------
-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`type` varchar(20) COLLATE big5_bin DEFAULT NULL,
`time` time DEFAULT NULL,
`who` int(11) DEFAULT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`what` int(11) DEFAULT NULL,
`how` varchar(20) COLLATE big5_bin DEFAULT NULL,
`hint` varchar(20) COLLATE big5_bin DEFAULT NULL,
`ip` text CHARACTER SET latin1,
`vnum` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of log
-- ----------------------------
-- ----------------------------
-- Table structure for `loginlog2`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog2`;
CREATE TABLE `loginlog2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` text,
`is_gm` int(11) DEFAULT NULL,
`login_time` datetime DEFAULT NULL,
`channel` int(11) DEFAULT NULL,
`account_id` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`client_version` text,
`ip` text,
`logout_time` datetime DEFAULT NULL,
`playtime` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of loginlog2
-- ----------------------------
-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`VALUES` int(11) DEFAULT NULL,
`DELAYED` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`vnum` int(11) DEFAULT '0',
`pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of money_log
-- ----------------------------
-- ----------------------------
-- Table structure for `quest_reward_log`
-- ----------------------------
DROP TABLE IF EXISTS `quest_reward_log`;
CREATE TABLE `quest_reward_log` (
`1` varchar(50) COLLATE big5_bin DEFAULT NULL,
`2` int(11) DEFAULT NULL,
`3` int(11) DEFAULT NULL,
`4` int(11) DEFAULT NULL,
`5` int(11) DEFAULT NULL,
`6` int(11) DEFAULT NULL,
`7` time DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of quest_reward_log
-- ----------------------------
-- ----------------------------
-- Table structure for `refinelog`
-- ----------------------------
DROP TABLE IF EXISTS `refinelog`;
CREATE TABLE `refinelog` (
`Id` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`item_name` varchar(50) COLLATE big5_bin DEFAULT NULL,
`item_id` int(11) DEFAULT NULL,
`step` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`is_success` int(11) DEFAULT NULL,
`setType` varchar(50) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of refinelog
-- ----------------------------
-- ----------------------------
-- Table structure for `shout_log`
-- ----------------------------
DROP TABLE IF EXISTS `shout_log`;
CREATE TABLE `shout_log` (
`1` time DEFAULT NULL,
`2` int(11) DEFAULT NULL,
`3` int(11) DEFAULT NULL,
`4` varchar(50) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of shout_log
-- ----------------------------
-- ----------------------------
-- Table structure for `speed_hack`
-- ----------------------------
DROP TABLE IF EXISTS `speed_hack`;
CREATE TABLE `speed_hack` (
`pid` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`hack_count` varchar(20) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
-- ----------------------------
-- Records of speed_hack
-- ----------------------------