diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-07-07 23:20:56 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-07 23:20:56 +0200 |
| commit | 37b32403270e0f1156807b0ebad64f6101f68205 (patch) | |
| tree | ec1752a92234636c803ef23c3d339b8970abb0f2 | |
| parent | eb1cd4c90708309a2e3c0e6e7c3e91645f725810 (diff) | |
DB/Misc: Add VerifiedBuild to gossip_menu/gossip_menu_option
| -rw-r--r-- | sql/updates/world/3.3.5/2016_07_07_04_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_07_07_04_world.sql b/sql/updates/world/3.3.5/2016_07_07_04_world.sql new file mode 100644 index 00000000000..0747a024a0a --- /dev/null +++ b/sql/updates/world/3.3.5/2016_07_07_04_world.sql @@ -0,0 +1,4 @@ +-- +ALTER TABLE `gossip_menu` ADD COLUMN `VerifiedBuild` SMALLINT(5) NOT NULL DEFAULT '0'; +ALTER TABLE `gossip_menu_option` ADD COLUMN `VerifiedBuild` SMALLINT(5) NOT NULL DEFAULT '0'; +UPDATE `gossip_menu` SET `VerifiedBuild`=-1 where `entry` >49999; |