diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-07-07 23:20:56 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-05 00:57:16 +0100 |
| commit | 4f25a3ea39e74317fef6266bb7b74107599100c8 (patch) | |
| tree | d6729ae04e3af01a28643d10164f4111602a1991 | |
| parent | caf744ad024c1c7b9c115673ac5fc59286085006 (diff) | |
DB/Misc: Add VerifiedBuild to gossip_menu/gossip_menu_option
(cherry picked from commit 37b32403270e0f1156807b0ebad64f6101f68205)
| -rw-r--r-- | sql/updates/world/master/2017_02_04_33_world_2016_07_07_04_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_04_33_world_2016_07_07_04_world.sql b/sql/updates/world/master/2017_02_04_33_world_2016_07_07_04_world.sql new file mode 100644 index 00000000000..0747a024a0a --- /dev/null +++ b/sql/updates/world/master/2017_02_04_33_world_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; |