Jump to content

Tablas LOG files 2010


Rafa23Alzira
 Share

Recommended Posts

Hola chicos, como hay un hilo abierto que pide estas tablas y se de más gente que las ha estado buscando como hice yo en mi día y tarde mucho en encontrarlas totalmente fixeadas pongo este mini-aporte para el que lo necesite.

-- ------------------------------ 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;-- ------------------------------ 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(200) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00') ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Table structure for `cube`-- ----------------------------DROP TABLE IF EXISTS `cube`;CREATE TABLE `cube` (  `pid` int(11) NOT NULL DEFAULT '0',  `time` time DEFAULT NULL,  `x` int(11) DEFAULT NULL,  `y` int(11) DEFAULT NULL,  `item_vnum` int(11) DEFAULT NULL,  `item_uid` int(11) DEFAULT NULL,  `item_count` int(11) DEFAULT NULL,  `success` int(11) DEFAULT NULL,  PRIMARY KEY (`pid`)) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ 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;-- ------------------------------ 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;-- ------------------------------ 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;-- ------------------------------ Table structure for `goldlog`-- ----------------------------DROP TABLE IF EXISTS `goldlog`;CREATE TABLE `goldlog` (  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  `time` time DEFAULT NULL,  `pid` int(11) DEFAULT NULL,  `what` int(11) DEFAULT NULL,  `how` int(11) DEFAULT NULL,  `hint` int(11) DEFAULT NULL,  PRIMARY KEY (`date`)) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ 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;-- ------------------------------ 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` datetime DEFAULT NULL,  `account_id` int(50) DEFAULT NULL,  `pid` int(30) DEFAULT NULL,  `playtime` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ 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;-- ------------------------------ 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;-- ------------------------------ Table structure for `log`-- ----------------------------DROP TABLE IF EXISTS `log`;CREATE TABLE `log` (  `type` varchar(20) COLLATE big5_bin DEFAULT NULL,  `time` datetime 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;-- ------------------------------ 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;-- ------------------------------ Table structure for `money_log`-- ----------------------------DROP TABLE IF EXISTS `money_log`;CREATE TABLE `money_log` (  `year` int(11) DEFAULT NULL,  `time` time DEFAULT NULL,  `vnum` int(11) DEFAULT '0',  `pid` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ 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;-- ------------------------------ 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;-- ------------------------------ 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;-- ------------------------------ 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;

Un saludo.

Link to comment
Share on other sites

  • Dilong locked this topic
Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...