aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKinzcool <kinzzcool@hotmail.com>2014-04-27 18:13:55 -0400
committerKinzcool <kinzzcool@hotmail.com>2014-04-27 18:13:55 -0400
commitc536305e3a3c4f41e94d14fae73ba7a2d8d13be2 (patch)
treecfbaa50362191e8a8edb11f7c360643730e3d688 /sql
parenta1e8cad70351ead7e98707587a4fb68e79a364c8 (diff)
Core: Droped `faction_H` field -- only one faction table is necessary
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_04_27_10_world_creature_template.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_27_10_world_creature_template.sql b/sql/updates/world/2014_04_27_10_world_creature_template.sql
new file mode 100644
index 00000000000..f251bdd51aa
--- /dev/null
+++ b/sql/updates/world/2014_04_27_10_world_creature_template.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `creature_template` DROP `faction_H`;
+ALTER TABLE `creature_template` CHANGE `faction_A` `faction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0';