diff options
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index e2717cdc5..fe25fb100 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', @@ -825,6 +825,8 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1440688342); -- 2015-08-2 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450241859); -- 2015-12-16--12-57.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450367880); -- 2015-12-17--15-58.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1457638175); -- 2016-03-10--22-18.sql +INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1467934919); -- 2016-07-08--02-42.sql +INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1467935469); -- 2016-07-08--02-51.sql -- -- Table structure for table `storage` |