diff options
| author | Meji <alvaromegias_46@hotmail.com> | 2021-10-16 00:48:54 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-16 00:48:54 +0200 |
| commit | 82b3a409db4dfe689c84234f3ae427369325bf0b (patch) | |
| tree | 3659688b099e811a4d263e647384508ed7bc3684 /sql/updates/auth | |
| parent | 518c86f9acd87d6597b2e236cfc3a773ee700fd3 (diff) | |
Core/BattlePets: Store declined names (#27025)
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2021_10_15_01_auth.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2021_10_15_01_auth.sql b/sql/updates/auth/master/2021_10_15_01_auth.sql new file mode 100644 index 00000000000..53dafc768eb --- /dev/null +++ b/sql/updates/auth/master/2021_10_15_01_auth.sql @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `battle_pet_declinedname`; +CREATE TABLE `battle_pet_declinedname` ( + `guid` bigint(20) NOT NULL, + `genitive` varchar(12) NOT NULL DEFAULT '', + `dative` varchar(12) NOT NULL DEFAULT '', + `accusative` varchar(12) NOT NULL DEFAULT '', + `instrumental` varchar(12) NOT NULL DEFAULT '', + `prepositional` varchar(12) NOT NULL DEFAULT '', + PRIMARY KEY (`guid`), + CONSTRAINT fk_battle_pet__battle_pet_declinedname FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE=InnoDB DEFAULT CHARSET=utf8; |