diff options
Diffstat (limited to 'sql/updates/auth/master')
| -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; |