diff options
| author | Shin <borzifrancesco@gmail.com> | 2016-11-15 21:54:45 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-11-15 21:54:45 +0100 |
| commit | 1ec1d165548d4fd4554ea469a70196c331bf3442 (patch) | |
| tree | c347d0e2eedcb1f9b3763200ef2ac43148c1b1b6 | |
| parent | d5ab3622777b5de4563e45e91eccb6e3429c3f7d (diff) | |
DB/Misc: minor structure improvements
- Affects #https://github.com/azerothcore/azerothcore-wotlk/issues/236
| -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`; |