diff options
| author | Kinzcool <kinzzcool@hotmail.com> | 2014-12-26 16:54:37 -0500 |
|---|---|---|
| committer | Kinzcool <kinzzcool@hotmail.com> | 2014-12-26 16:54:37 -0500 |
| commit | f05c68b4324a254c3bc51d2ac63d4f4194751b52 (patch) | |
| tree | eb93c06d4412be5b7a5df61444f244d6810a0fed | |
| parent | 49b4f170571675773c6e3bccc2b8488f78e7eb1f (diff) | |
DB/Quests: Accommodated quest_greeting table for gameobject entities
| -rw-r--r-- | sql/updates/world/2014_12_26_06_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2014_12_26_06_world.sql b/sql/updates/world/2014_12_26_06_world.sql new file mode 100644 index 00000000000..d6336016ddb --- /dev/null +++ b/sql/updates/world/2014_12_26_06_world.sql @@ -0,0 +1,4 @@ +RENAME TABLE `quest_creature_greeting` TO `quest_greeting`; +ALTER TABLE `quest_greeting` + CHANGE `CreatureID` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + ADD `Type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `ID`; |