diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-12-27 16:42:05 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-12-27 16:42:05 +0000 |
| commit | 7fe2d7309ae3b850f3a7c75fc9bb6ec18bea00a1 (patch) | |
| tree | 2b1ee49d74a096bc134b8803a089d87c3a7fa254 /sql | |
| parent | 29f34769478041abe2544111594ee4ed40f1850a (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_12_27_02_world_locales.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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'; |