diff options
| author | Andrei Karas <akaras@inbox.ru> | 2016-07-08 20:59:06 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2016-07-08 20:59:06 +0300 |
| commit | 2679b2c3be25a87bc890c943a6ea206cc7860113 (patch) | |
| tree | 568a521a186eb46239dbd5c0d84e0633f7b4f0ec /sql-files/main.sql | |
| parent | 3ef0e467e38d19f957feb84a5e45d1a6a2e8944a (diff) | |
| download | serverdata-2679b2c3be25a87bc890c943a6ea206cc7860113.tar.gz serverdata-2679b2c3be25a87bc890c943a6ea206cc7860113.tar.bz2 serverdata-2679b2c3be25a87bc890c943a6ea206cc7860113.tar.xz serverdata-2679b2c3be25a87bc890c943a6ea206cc7860113.zip | |
Update sql files.
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index b70b5e2c..fe25fb10 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, + `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', @@ -567,7 +567,7 @@ 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 NULL, + `lastlogin` DATETIME NULL, `last_ip` VARCHAR(100) NOT NULL DEFAULT '', `birthdate` DATE NULL, `character_slots` TINYINT(3) 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` |