From 7fe2d7309ae3b850f3a7c75fc9bb6ec18bea00a1 Mon Sep 17 00:00:00 2001 From: Nay Date: Thu, 27 Dec 2012 16:42:05 +0000 Subject: DB/Schema: Rename and change types of a few fields in locales_creature_text and locales_npc_text locales_creature_text.textGroup -> locales_creature_text.groupid locales_npc_text.entry -> locales_npc_text.ID --- sql/updates/world/2012_12_27_02_world_locales.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2012_12_27_02_world_locales.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_27_02_world_locales.sql b/sql/updates/world/2012_12_27_02_world_locales.sql new file mode 100644 index 00000000000..5caeb009447 --- /dev/null +++ b/sql/updates/world/2012_12_27_02_world_locales.sql @@ -0,0 +1,4 @@ +ALTER TABLE `locales_creature_text` CHANGE `entry` `entry` mediumint(8) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `locales_creature_text` CHANGE `textGroup` `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `locales_creature_text` CHANGE `id` `id` tinyint(3) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `locales_npc_text` CHANGE `entry` `ID` mediumint(8) unsigned NOT NULL DEFAULT '0'; -- cgit v1.2.3