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/updates/auth | |
| parent | b1eb4c2b3e0745e0d801bfa4111c692cc3bb00a1 (diff) | |
Core/BattlePets: Implemented battle pet name query packet (#27294)
Co-authored-by: Shauren <shauren.trinity@gmail.com>
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2021_11_20_00_auth.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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; |