diff options
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index e2717cdc5..8466c3a14 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -236,7 +236,7 @@ CREATE TABLE IF NOT EXISTS `char_reg_str_db` ( -- CREATE TABLE IF NOT EXISTS `charlog` ( - `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `time` DATETIME NULL, `char_msg` VARCHAR(255) NOT NULL DEFAULT 'char select', `account_id` INT(11) NOT NULL DEFAULT '0', `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', @@ -511,7 +511,7 @@ CREATE TABLE IF NOT EXISTS `homunculus` ( -- CREATE TABLE IF NOT EXISTS `interlog` ( - `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `time` DATETIME NULL, `log` VARCHAR(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM; @@ -546,8 +546,8 @@ CREATE TABLE IF NOT EXISTS `inventory` ( CREATE TABLE IF NOT EXISTS `ipbanlist` ( `list` VARCHAR(255) NOT NULL DEFAULT '', - `btime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', - `rtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `btime` DATETIME NULL, + `rtime` DATETIME NULL, `reason` VARCHAR(255) NOT NULL DEFAULT '', KEY (`list`) ) ENGINE=MyISAM; @@ -567,9 +567,9 @@ CREATE TABLE IF NOT EXISTS `login` ( `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', `expiration_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', `logincount` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', - `lastlogin` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `lastlogin` DATETIME NULL, `last_ip` VARCHAR(100) NOT NULL DEFAULT '', - `birthdate` DATE NOT NULL DEFAULT '0000-00-00', + `birthdate` DATE NULL, `character_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', `pincode` VARCHAR(4) NOT NULL DEFAULT '', `pincode_change` INT(11) UNSIGNED NOT NULL DEFAULT '0', |