diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_10_16_00_auth.sql | 1 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 5ca1ccfac57..27a1bac8a77 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -265,6 +265,7 @@ CREATE TABLE `battle_pets` ( `battlenetAccountId` int(10) NOT NULL, `species` int(10) NOT NULL, `breed` smallint(5) NOT NULL, + `displayId` int(11) NOT NULL DEFAULT '0', `level` smallint(5) NOT NULL DEFAULT '1', `exp` smallint(5) NOT NULL DEFAULT '0', `health` int(10) NOT NULL DEFAULT '1', @@ -2458,7 +2459,8 @@ INSERT INTO `updates` VALUES ('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','ARCHIVED','2021-10-07 10:32:05',0), ('2021_10_13_00_auth.sql','220E63385CACCBCEC36C57717DE369F2FCABCAAF','ARCHIVED','2021-10-13 21:15:05',0), ('2021_10_15_00_auth.sql','C8AA212AB2BB2DB5B3C2C9622A3874475AEFBD7B','ARCHIVED','2021-10-15 10:11:47',0), -('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','RELEASED','2021-10-16 00:15:25',0); +('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','RELEASED','2021-10-16 00:15:25',0), +('2021_10_16_00_auth.sql','FDC45C7BEFBAFC9BCE6C77377B026A59AE52EE21','RELEASED','2021-10-16 11:24:39',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2021_10_16_00_auth.sql b/sql/updates/auth/master/2021_10_16_00_auth.sql new file mode 100644 index 00000000000..c0dfb9a29a1 --- /dev/null +++ b/sql/updates/auth/master/2021_10_16_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `battle_pets` ADD `displayId` int(11) NOT NULL DEFAULT '0' AFTER `breed`; |