diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/6374_world.sql | 4 | ||||
| -rw-r--r-- | sql/world.sql | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/6374_world.sql b/sql/updates/6374_world.sql new file mode 100644 index 00000000000..a1a8fdf5278 --- /dev/null +++ b/sql/updates/6374_world.sql @@ -0,0 +1,4 @@ +ALTER TABLE `creature_template` ADD `questItem5` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem4`; +ALTER TABLE `creature_template` ADD `questItem6` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem5`; +ALTER TABLE `gameobject_template` ADD `questItem5` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem4`; +ALTER TABLE `gameobject_template` ADD `questItem6` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem5`; diff --git a/sql/world.sql b/sql/world.sql index 1c24a339b95..1b9e3d41296 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -565,6 +565,8 @@ CREATE TABLE `creature_template` ( `questItem2` int(11) unsigned NOT NULL default '0', `questItem3` int(11) unsigned NOT NULL default '0', `questItem4` int(11) unsigned NOT NULL default '0', + `questItem5` int(11) unsigned NOT NULL default '0', + `questItem6` int(11) unsigned NOT NULL default '0', `movementId` int(11) unsigned NOT NULL default '0', `RegenHealth` tinyint(3) unsigned NOT NULL default '1', `equipment_id` mediumint(8) unsigned NOT NULL default '0', @@ -1134,6 +1136,8 @@ CREATE TABLE `gameobject_template` ( `questItem2` int(11) unsigned NOT NULL default '0', `questItem3` int(11) unsigned NOT NULL default '0', `questItem4` int(11) unsigned NOT NULL default '0', + `questItem5` int(11) unsigned NOT NULL default '0', + `questItem6` int(11) unsigned NOT NULL default '0', `data0` int(10) unsigned NOT NULL default '0', `data1` int(10) unsigned NOT NULL default '0', `data2` int(10) unsigned NOT NULL default '0', |