From 4f25a3ea39e74317fef6266bb7b74107599100c8 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 7 Jul 2016 23:20:56 +0200 Subject: DB/Misc: Add VerifiedBuild to gossip_menu/gossip_menu_option (cherry picked from commit 37b32403270e0f1156807b0ebad64f6101f68205) --- sql/updates/world/master/2017_02_04_33_world_2016_07_07_04_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2017_02_04_33_world_2016_07_07_04_world.sql (limited to 'sql') 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; -- cgit v1.2.3