Rafa23Alzira Publicado 23 de Enero del 2014 Reportar Compartir Publicado 23 de Enero del 2014 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. kuvanno reacciono a esto 1 Enlace para comentar Compartir en otros sitios Mas opciones de compartir...
kuvanno Publicado 23 de Enero del 2014 Reportar Compartir Publicado 23 de Enero del 2014 Gracias, te agradezco la ayuda, solo una duda, sirven para files 2013? Enlace para comentar Compartir en otros sitios Mas opciones de compartir...
Rafa23Alzira Publicado 23 de Enero del 2014 Author Reportar Compartir Publicado 23 de Enero del 2014 Supongo que si, files 2013 serán de base 2010 creo yo. kuvanno reacciono a esto 1 Enlace para comentar Compartir en otros sitios Mas opciones de compartir...
Mensajes recomendados