diff options
author | Andrei Karas <akaras@inbox.ru> | 2016-07-06 20:48:56 +0300 |
---|---|---|
committer | Andrei Karas <akaras@inbox.ru> | 2016-07-07 22:43:51 +0300 |
commit | 4816852807bdb8607ef1b1c5683f6ace588bdee5 (patch) | |
tree | c0a18b118a3896bb6c9426b8e882fb8dbbbb63d2 /sql-files/main.sql | |
parent | 92c936ff852fb5880f74506c31767509cbf4074a (diff) | |
download | serverdata-4816852807bdb8607ef1b1c5683f6ace588bdee5.tar.gz serverdata-4816852807bdb8607ef1b1c5683f6ace588bdee5.tar.bz2 serverdata-4816852807bdb8607ef1b1c5683f6ace588bdee5.tar.xz serverdata-4816852807bdb8607ef1b1c5683f6ace588bdee5.zip |
Add basic ci tests and .gitlab-ci.yml
Also add configs for ci.
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 e2717cdc..b70b5e2c 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 NOT 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', |