diff options
| author | Meji <alvaromegias_46@hotmail.com> | 2021-11-20 19:06:14 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-11-20 19:06:14 +0100 |
| commit | 8614690e27df8197586cc702760409293f3f6c3d (patch) | |
| tree | eb95f093b283d9bb728e3e26800240dda462b137 /sql | |
| parent | b1eb4c2b3e0745e0d801bfa4111c692cc3bb00a1 (diff) | |
Core/BattlePets: Implemented battle pet name query packet (#27294)
Co-authored-by: Shauren <shauren.trinity@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_11_20_00_auth.sql | 3 |
2 files changed, 6 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index e054b2e2629..7ffaa62c90d 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -271,6 +271,7 @@ CREATE TABLE `battle_pets` ( `quality` tinyint(3) NOT NULL DEFAULT '0', `flags` smallint(5) NOT NULL DEFAULT '0', `name` varchar(12) NOT NULL, + `nameTimestamp` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2455,7 +2456,8 @@ INSERT INTO `updates` VALUES ('2021_11_10_00_auth.sql','EB3D26EFD3109BC17447B3BAC7573473F5103F65','ARCHIVED','2021-11-10 14:07:05',0), ('2021_11_12_00_auth.sql','012C088794362FE57BAEA0C3BD05356B40289028','ARCHIVED','2021-11-12 12:17:24',0), ('2021_11_17_00_auth.sql','298DA8468B30042B15FA17A90325C72879DF6D8E','ARCHIVED','2021-11-17 13:23:17',0), -('2021_11_19_00_auth.sql','BE4F77E254D76A59DBF28B2CEEA5CAF6777B650E','RELEASED','2021-11-19 00:37:56',0); +('2021_11_19_00_auth.sql','BE4F77E254D76A59DBF28B2CEEA5CAF6777B650E','RELEASED','2021-11-19 00:37:56',0), +('2021_11_20_00_auth.sql','E476B6DAD9C47FC81E1DA5016DC79AB527F1847A','RELEASED','2021-11-20 18:40:53',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2021_11_20_00_auth.sql b/sql/updates/auth/master/2021_11_20_00_auth.sql new file mode 100644 index 00000000000..da75c1e445b --- /dev/null +++ b/sql/updates/auth/master/2021_11_20_00_auth.sql @@ -0,0 +1,3 @@ +ALTER TABLE `battle_pets` ADD `nameTimestamp` bigint(20) NOT NULL DEFAULT '0' AFTER `name`; + +UPDATE `battle_pets` SET `nameTimestamp`=UNIX_TIMESTAMP() WHERE LENGTH(`name`) > 0; |