diff options
Diffstat (limited to 'sql-files/logs.sql')
| -rw-r--r-- | sql-files/logs.sql | 92 |
1 files changed, 46 insertions, 46 deletions
diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 6edf385a2..e17241a62 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -42,10 +42,10 @@ -- CREATE TABLE IF NOT EXISTS `atcommandlog` ( - `atcommand_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `atcommand_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, `atcommand_date` DATETIME NULL, - `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', - `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `account_id` INT UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT UNSIGNED NOT NULL DEFAULT '0', `char_name` VARCHAR(25) NOT NULL DEFAULT '', `map` VARCHAR(11) NOT NULL DEFAULT '', `command` VARCHAR(255) NOT NULL DEFAULT '', @@ -59,10 +59,10 @@ CREATE TABLE IF NOT EXISTS `atcommandlog` ( -- CREATE TABLE IF NOT EXISTS `branchlog` ( - `branch_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `branch_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, `branch_date` DATETIME NULL, - `account_id` INT(11) NOT NULL DEFAULT '0', - `char_id` INT(11) NOT NULL DEFAULT '0', + `account_id` INT NOT NULL DEFAULT '0', + `char_id` INT NOT NULL DEFAULT '0', `char_name` VARCHAR(25) NOT NULL DEFAULT '', `map` VARCHAR(11) NOT NULL DEFAULT '', PRIMARY KEY(`branch_id`), @@ -75,15 +75,15 @@ CREATE TABLE IF NOT EXISTS `branchlog` ( -- CREATE TABLE IF NOT EXISTS `chatlog` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT NOT NULL AUTO_INCREMENT, `time` DATETIME NULL, `type` ENUM('O','W','P','G','M','C') NOT NULL DEFAULT 'O', - `type_id` INT(11) NOT NULL DEFAULT '0', - `src_charid` INT(11) NOT NULL DEFAULT '0', - `src_accountid` INT(11) NOT NULL DEFAULT '0', + `type_id` INT NOT NULL DEFAULT '0', + `src_charid` INT NOT NULL DEFAULT '0', + `src_accountid` INT NOT NULL DEFAULT '0', `src_map` VARCHAR(11) NOT NULL DEFAULT '', - `src_map_x` SMALLINT(4) NOT NULL DEFAULT '0', - `src_map_y` SMALLINT(4) NOT NULL DEFAULT '0', + `src_map_x` SMALLINT NOT NULL DEFAULT '0', + `src_map_y` SMALLINT NOT NULL DEFAULT '0', `dst_charname` VARCHAR(25) NOT NULL DEFAULT '', `message` VARCHAR(150) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -99,7 +99,7 @@ CREATE TABLE IF NOT EXISTS `loginlog` ( `time` DATETIME NULL, `ip` VARCHAR(15) NOT NULL DEFAULT '', `user` VARCHAR(23) NOT NULL DEFAULT '', - `rcode` TINYINT(4) NOT NULL DEFAULT '0', + `rcode` TINYINT NOT NULL DEFAULT '0', `log` VARCHAR(255) NOT NULL DEFAULT '', INDEX (`ip`) ) ENGINE=MyISAM; @@ -109,12 +109,12 @@ CREATE TABLE IF NOT EXISTS `loginlog` ( -- CREATE TABLE IF NOT EXISTS `mvplog` ( - `mvp_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `mvp_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, `mvp_date` DATETIME NULL, - `kill_char_id` INT(11) NOT NULL DEFAULT '0', - `monster_id` SMALLINT(6) NOT NULL DEFAULT '0', - `prize` INT(11) NOT NULL DEFAULT '0', - `mvpexp` MEDIUMINT(9) NOT NULL DEFAULT '0', + `kill_char_id` INT NOT NULL DEFAULT '0', + `monster_id` SMALLINT NOT NULL DEFAULT '0', + `prize` INT NOT NULL DEFAULT '0', + `mvpexp` MEDIUMINT NOT NULL DEFAULT '0', `map` VARCHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`mvp_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; @@ -124,10 +124,10 @@ CREATE TABLE IF NOT EXISTS `mvplog` ( -- CREATE TABLE IF NOT EXISTS `npclog` ( - `npc_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `npc_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, `npc_date` DATETIME NULL, - `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', - `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `account_id` INT UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT UNSIGNED NOT NULL DEFAULT '0', `char_name` VARCHAR(25) NOT NULL DEFAULT '', `map` VARCHAR(11) NOT NULL DEFAULT '', `mes` VARCHAR(255) NOT NULL DEFAULT '', @@ -141,28 +141,28 @@ CREATE TABLE IF NOT EXISTS `npclog` ( -- CREATE TABLE IF NOT EXISTS `picklog` ( - `id` INT(11) NOT NULL AUTO_INCREMENT, + `id` INT NOT NULL AUTO_INCREMENT, `time` DATETIME NULL, - `char_id` INT(11) NOT NULL DEFAULT '0', - `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2') NOT NULL DEFAULT 'P', - `nameid` INT(11) NOT NULL DEFAULT '0', - `amount` INT(11) NOT NULL DEFAULT '1', - `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', - `card0` INT(11) NOT NULL DEFAULT '0', - `card1` INT(11) NOT NULL DEFAULT '0', - `card2` INT(11) NOT NULL DEFAULT '0', - `card3` INT(11) NOT NULL DEFAULT '0', - `opt_idx0` smallint(5) unsigned NOT NULL default '0', - `opt_val0` smallint(5) unsigned NOT NULL default '0', - `opt_idx1` smallint(5) unsigned NOT NULL default '0', - `opt_val1` smallint(5) unsigned NOT NULL default '0', - `opt_idx2` smallint(5) unsigned NOT NULL default '0', - `opt_val2` smallint(5) unsigned NOT NULL default '0', - `opt_idx3` smallint(5) unsigned NOT NULL default '0', - `opt_val3` smallint(5) unsigned NOT NULL default '0', - `opt_idx4` smallint(5) unsigned NOT NULL default '0', - `opt_val4` smallint(5) unsigned NOT NULL default '0', - `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT NOT NULL DEFAULT '0', + `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2','3') NOT NULL DEFAULT 'P', + `nameid` INT NOT NULL DEFAULT '0', + `amount` INT NOT NULL DEFAULT '1', + `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0', + `card0` INT NOT NULL DEFAULT '0', + `card1` INT NOT NULL DEFAULT '0', + `card2` INT NOT NULL DEFAULT '0', + `card3` INT NOT NULL DEFAULT '0', + `opt_idx0` SMALLINT unsigned NOT NULL default '0', + `opt_val0` SMALLINT unsigned NOT NULL default '0', + `opt_idx1` SMALLINT unsigned NOT NULL default '0', + `opt_val1` SMALLINT unsigned NOT NULL default '0', + `opt_idx2` SMALLINT unsigned NOT NULL default '0', + `opt_val2` SMALLINT unsigned NOT NULL default '0', + `opt_idx3` SMALLINT unsigned NOT NULL default '0', + `opt_val3` SMALLINT unsigned NOT NULL default '0', + `opt_idx4` SMALLINT unsigned NOT NULL default '0', + `opt_val4` SMALLINT unsigned NOT NULL default '0', + `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0', `map` VARCHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`id`), INDEX (`type`) @@ -173,12 +173,12 @@ CREATE TABLE IF NOT EXISTS `picklog` ( -- CREATE TABLE IF NOT EXISTS `zenylog` ( - `id` INT(11) NOT NULL AUTO_INCREMENT, + `id` INT NOT NULL AUTO_INCREMENT, `time` DATETIME NULL, - `char_id` INT(11) NOT NULL DEFAULT '0', - `src_id` INT(11) NOT NULL DEFAULT '0', + `char_id` INT NOT NULL DEFAULT '0', + `src_id` INT NOT NULL DEFAULT '0', `type` ENUM('T','V','P','M','S','N','D','C','A','E','I','B','K') NOT NULL DEFAULT 'S', - `amount` INT(11) NOT NULL DEFAULT '0', + `amount` INT NOT NULL DEFAULT '0', `map` VARCHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`id`), INDEX (`type`) |