diff options
| -rw-r--r-- | data/sql/updates/pending_db_auth/rev_1478975214169487000.sql | 7 | ||||
| -rw-r--r-- | data/sql/updates/pending_db_characters/rev_1478978518254125000.sql | 5 |
2 files changed, 12 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_auth/rev_1478975214169487000.sql b/data/sql/updates/pending_db_auth/rev_1478975214169487000.sql new file mode 100644 index 0000000000..3f5af211ef --- /dev/null +++ b/data/sql/updates/pending_db_auth/rev_1478975214169487000.sql @@ -0,0 +1,7 @@ +INSERT INTO version_db_auth (`sql_rev`) VALUES ('1478975214169487000'); + +ALTER TABLE `account` + ADD `token_key` VARCHAR(100) NOT NULL DEFAULT '' AFTER `s`, + ADD `reg_mail` VARCHAR(255) NOT NULL DEFAULT '' AFTER `mail`, + ADD `last_attempt_ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1' AFTER `last_ip`, + ADD `lock_country` VARCHAR(2) NOT NULL DEFAULT '00' AFTER `locked`; diff --git a/data/sql/updates/pending_db_characters/rev_1478978518254125000.sql b/data/sql/updates/pending_db_characters/rev_1478978518254125000.sql new file mode 100644 index 0000000000..7bf7549827 --- /dev/null +++ b/data/sql/updates/pending_db_characters/rev_1478978518254125000.sql @@ -0,0 +1,5 @@ +INSERT INTO version_db_characters (`sql_rev`) VALUES ('1478978518254125000'); + +ALTER TABLE `arena_team_member` + CHANGE COLUMN `personalRating` `personalRating` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `seasonWins`, + DROP COLUMN `personal_rating`; |