diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_02_08_00_world_335.sql | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_02_08_00_world_335.sql b/sql/updates/world/3.3.5/2020_02_08_00_world_335.sql new file mode 100644 index 00000000000..91819649da0 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_02_08_00_world_335.sql @@ -0,0 +1,50 @@ +-- +ALTER TABLE `npc_text` +CHANGE COLUMN `em0_0` `EmoteDelay0_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability0`, +CHANGE COLUMN `em0_1` `Emote0_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay0_0`, +CHANGE COLUMN `em0_2` `EmoteDelay0_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote0_0`, +CHANGE COLUMN `em0_3` `Emote0_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay0_1`, +CHANGE COLUMN `em0_4` `EmoteDelay0_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote0_1`, +CHANGE COLUMN `em0_5` `Emote0_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay0_2`, +CHANGE COLUMN `em1_0` `EmoteDelay1_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability1`, +CHANGE COLUMN `em1_1` `Emote1_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay1_0`, +CHANGE COLUMN `em1_2` `EmoteDelay1_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote1_0`, +CHANGE COLUMN `em1_3` `Emote1_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay1_1`, +CHANGE COLUMN `em1_4` `EmoteDelay1_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote1_1`, +CHANGE COLUMN `em1_5` `Emote1_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay1_2`, +CHANGE COLUMN `em2_0` `EmoteDelay2_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability2`, +CHANGE COLUMN `em2_1` `Emote2_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay2_0`, +CHANGE COLUMN `em2_2` `EmoteDelay2_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote2_0`, +CHANGE COLUMN `em2_3` `Emote2_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay2_1`, +CHANGE COLUMN `em2_4` `EmoteDelay2_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote2_1`, +CHANGE COLUMN `em2_5` `Emote2_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay2_2`, +CHANGE COLUMN `em3_0` `EmoteDelay3_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability3`, +CHANGE COLUMN `em3_1` `Emote3_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay3_0`, +CHANGE COLUMN `em3_2` `EmoteDelay3_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote3_0`, +CHANGE COLUMN `em3_3` `Emote3_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay3_1`, +CHANGE COLUMN `em3_4` `EmoteDelay3_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote3_1`, +CHANGE COLUMN `em3_5` `Emote3_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay3_2`, +CHANGE COLUMN `em4_0` `EmoteDelay4_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability4`, +CHANGE COLUMN `em4_1` `Emote4_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay4_0`, +CHANGE COLUMN `em4_2` `EmoteDelay4_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote4_0`, +CHANGE COLUMN `em4_3` `Emote4_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay4_1`, +CHANGE COLUMN `em4_4` `EmoteDelay4_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote4_1`, +CHANGE COLUMN `em4_5` `Emote4_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay4_2`, +CHANGE COLUMN `em5_0` `EmoteDelay5_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability5`, +CHANGE COLUMN `em5_1` `Emote5_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay5_0`, +CHANGE COLUMN `em5_2` `EmoteDelay5_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote5_0`, +CHANGE COLUMN `em5_3` `Emote5_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay5_1`, +CHANGE COLUMN `em5_4` `EmoteDelay5_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote5_1`, +CHANGE COLUMN `em5_5` `Emote5_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay5_2`, +CHANGE COLUMN `em6_0` `EmoteDelay6_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability6`, +CHANGE COLUMN `em6_1` `Emote6_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay6_0`, +CHANGE COLUMN `em6_2` `EmoteDelay6_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote6_0`, +CHANGE COLUMN `em6_3` `Emote6_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay6_1`, +CHANGE COLUMN `em6_4` `EmoteDelay6_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote6_1`, +CHANGE COLUMN `em6_5` `Emote6_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay6_2`, +CHANGE COLUMN `em7_0` `EmoteDelay7_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Probability7`, +CHANGE COLUMN `em7_1` `Emote7_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay7_0`, +CHANGE COLUMN `em7_2` `EmoteDelay7_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote7_0`, +CHANGE COLUMN `em7_3` `Emote7_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay7_1`, +CHANGE COLUMN `em7_4` `EmoteDelay7_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `Emote7_1`, +CHANGE COLUMN `em7_5` `Emote7_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay7_2`; |