From 65705a16c148d06e1b7f029edd98756dbef24489 Mon Sep 17 00:00:00 2001 From: teacher Date: Mon, 1 Feb 2010 18:52:42 +0100 Subject: Updated world.sql and characters.sql. Removed commented code form realm.sql and set account.expansion field default value to 2 (wotlk) (thx Aokromes). Properly set default values for some world DB fields. Properly set some world DB fields to allow Database import in strict mode (by Brian). Updated world_script_full with recent committed npc script. Renamed a couple of files with proper revision number. Note: no DB data will changed nor harmed by this commit. --HG-- branch : trunk --- sql/updates/7229_world_creature_template.sql | 1 - sql/updates/7229_world_scriptname.sql | 1 + sql/updates/7245_world_command.sql | 8 -------- sql/updates/7246_world_command.sql | 8 ++++++++ sql/updates/7279_realmd_account.sql | 1 + sql/updates/7279_world_creature_template.sql | 2 ++ sql/updates/7279_world_gameobject_template.sql | 1 + sql/updates/7279_world_item_template.sql | 11 +++++++++++ sql/updates/7279_world_pool_creature.sql | 2 ++ sql/updates/7279_world_pool_gameobject.sql | 1 + sql/updates/7279_world_pool_pool.sql | 1 + sql/updates/7279_world_pool_template.sql | 2 ++ sql/updates/7279_world_quest_template.sql | 2 ++ 13 files changed, 32 insertions(+), 9 deletions(-) delete mode 100644 sql/updates/7229_world_creature_template.sql create mode 100644 sql/updates/7229_world_scriptname.sql delete mode 100644 sql/updates/7245_world_command.sql create mode 100644 sql/updates/7246_world_command.sql create mode 100644 sql/updates/7279_realmd_account.sql create mode 100644 sql/updates/7279_world_creature_template.sql create mode 100644 sql/updates/7279_world_gameobject_template.sql create mode 100644 sql/updates/7279_world_item_template.sql create mode 100644 sql/updates/7279_world_pool_creature.sql create mode 100644 sql/updates/7279_world_pool_gameobject.sql create mode 100644 sql/updates/7279_world_pool_pool.sql create mode 100644 sql/updates/7279_world_pool_template.sql create mode 100644 sql/updates/7279_world_quest_template.sql (limited to 'sql/updates') diff --git a/sql/updates/7229_world_creature_template.sql b/sql/updates/7229_world_creature_template.sql deleted file mode 100644 index c52d7091bff..00000000000 --- a/sql/updates/7229_world_creature_template.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_erekem_guard' WHERE `entry`=29395; diff --git a/sql/updates/7229_world_scriptname.sql b/sql/updates/7229_world_scriptname.sql new file mode 100644 index 00000000000..c52d7091bff --- /dev/null +++ b/sql/updates/7229_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='mob_erekem_guard' WHERE `entry`=29395; diff --git a/sql/updates/7245_world_command.sql b/sql/updates/7245_world_command.sql deleted file mode 100644 index 7fc9a2ed371..00000000000 --- a/sql/updates/7245_world_command.sql +++ /dev/null @@ -1,8 +0,0 @@ --- delete unused command loadscripts -DELETE FROM `command` WHERE `name` = 'loadscripts'; --- Change the default scurity level for some commands -UPDATE `command` SET `security`=2 WHERE `name` IN ('playall','npc setlink','reload creature_linked_respawn'); -- DB devs command -UPDATE `command` SET `security`=1 WHERE `name` IN ('freeze','listfreeze','unfreeze'); -- Players can be anoying when talking a mod -UPDATE `command` SET `security`=1 WHERE `name` IN ('gmannounce','gmnameannounce','gmnotify'); -- even mods needs to notify things when a higher range staft is not online -UPDATE `command` SET `security`=1 WHERE `name` IN ('ticket assign','ticket close','ticket comment','ticket unassign'); -- Dirty work for slaves -UPDATE `command` SET `security`=1 WHERE `name`='account addon'; -- Server admins uses addon to close northrend diff --git a/sql/updates/7246_world_command.sql b/sql/updates/7246_world_command.sql new file mode 100644 index 00000000000..7fc9a2ed371 --- /dev/null +++ b/sql/updates/7246_world_command.sql @@ -0,0 +1,8 @@ +-- delete unused command loadscripts +DELETE FROM `command` WHERE `name` = 'loadscripts'; +-- Change the default scurity level for some commands +UPDATE `command` SET `security`=2 WHERE `name` IN ('playall','npc setlink','reload creature_linked_respawn'); -- DB devs command +UPDATE `command` SET `security`=1 WHERE `name` IN ('freeze','listfreeze','unfreeze'); -- Players can be anoying when talking a mod +UPDATE `command` SET `security`=1 WHERE `name` IN ('gmannounce','gmnameannounce','gmnotify'); -- even mods needs to notify things when a higher range staft is not online +UPDATE `command` SET `security`=1 WHERE `name` IN ('ticket assign','ticket close','ticket comment','ticket unassign'); -- Dirty work for slaves +UPDATE `command` SET `security`=1 WHERE `name`='account addon'; -- Server admins uses addon to close northrend diff --git a/sql/updates/7279_realmd_account.sql b/sql/updates/7279_realmd_account.sql new file mode 100644 index 00000000000..c8981d44afd --- /dev/null +++ b/sql/updates/7279_realmd_account.sql @@ -0,0 +1 @@ +ALTER TABLE `account` CHANGE COLUMN `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2'; diff --git a/sql/updates/7279_world_creature_template.sql b/sql/updates/7279_world_creature_template.sql new file mode 100644 index 00000000000..c866a69c5e9 --- /dev/null +++ b/sql/updates/7279_world_creature_template.sql @@ -0,0 +1,2 @@ +ALTER TABLE `creature_template` CHANGE COLUMN `Health_mod` `Health_mod` float NOT NULL DEFAULT '1'; +ALTER TABLE `creature_template` CHANGE COLUMN `Mana_mod` `Mana_mod` float NOT NULL DEFAULT '1'; diff --git a/sql/updates/7279_world_gameobject_template.sql b/sql/updates/7279_world_gameobject_template.sql new file mode 100644 index 00000000000..34581fcf272 --- /dev/null +++ b/sql/updates/7279_world_gameobject_template.sql @@ -0,0 +1 @@ +ALTER TABLE `gameobject_template` CHANGE COLUMN `data6` `data6` INT(11) SIGNED NOT NULL DEFAULT '-1' diff --git a/sql/updates/7279_world_item_template.sql b/sql/updates/7279_world_item_template.sql new file mode 100644 index 00000000000..335f1036d88 --- /dev/null +++ b/sql/updates/7279_world_item_template.sql @@ -0,0 +1,11 @@ +ALTER TABLE `item_template` CHANGE COLUMN `AllowableClass` `AllowableClass` int(11) NOT NULL DEFAULT '-1'; +ALTER TABLE `item_template` CHANGE COLUMN `AllowableRace` `AllowableRace` int(11) NOT NULL DEFAULT '-1'; +ALTER TABLE `item_template` CHANGE COLUMN `Flags` `Flags` bigint(20) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `BuyPrice` `BuyPrice` bigint(20) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `maxcount` `maxcount` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `spellid_1` `spellid_1` mediumint(8) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `spellid_2` `spellid_2` mediumint(8) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `spellid_3` `spellid_3` mediumint(8) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `spellid_4` `spellid_4` mediumint(8) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `spellid_5` `spellid_5` mediumint(8) NOT NULL DEFAULT '0'; +ALTER TABLE `item_template` CHANGE COLUMN `RandomProperty` `RandomProperty` mediumint(8) NOT NULL DEFAULT '0'; diff --git a/sql/updates/7279_world_pool_creature.sql b/sql/updates/7279_world_pool_creature.sql new file mode 100644 index 00000000000..e087ad088ac --- /dev/null +++ b/sql/updates/7279_world_pool_creature.sql @@ -0,0 +1,2 @@ +ALTER TABLE `pool_creature` CHANGE COLUMN `comment` `comment` varchar(255) DEFAULT NULL; +ALTER TABLE `pool_creature` CHANGE COLUMN `description` `description` varchar(255) DEFAULT NULL; diff --git a/sql/updates/7279_world_pool_gameobject.sql b/sql/updates/7279_world_pool_gameobject.sql new file mode 100644 index 00000000000..c24a4a8f964 --- /dev/null +++ b/sql/updates/7279_world_pool_gameobject.sql @@ -0,0 +1 @@ +ALTER TABLE `pool_gameobject` CHANGE COLUMN `description` `description` varchar(255) DEFAULT NULL; diff --git a/sql/updates/7279_world_pool_pool.sql b/sql/updates/7279_world_pool_pool.sql new file mode 100644 index 00000000000..ab96f4c6f2a --- /dev/null +++ b/sql/updates/7279_world_pool_pool.sql @@ -0,0 +1 @@ +ALTER TABLE `pool_pool` CHANGE COLUMN `description` `description` varchar(255) DEFAULT NULL; diff --git a/sql/updates/7279_world_pool_template.sql b/sql/updates/7279_world_pool_template.sql new file mode 100644 index 00000000000..2ce997b9379 --- /dev/null +++ b/sql/updates/7279_world_pool_template.sql @@ -0,0 +1,2 @@ +ALTER TABLE `pool_template` CHANGE COLUMN `description` `description` varchar(255) DEFAULT NULL; +ALTER TABLE `pool_template` CHANGE COLUMN `comment` `comment` varchar(255) DEFAULT NULL; diff --git a/sql/updates/7279_world_quest_template.sql b/sql/updates/7279_world_quest_template.sql new file mode 100644 index 00000000000..ea687b5eb15 --- /dev/null +++ b/sql/updates/7279_world_quest_template.sql @@ -0,0 +1,2 @@ +ALTER TABLE `quest_template` CHANGE COLUMN `QuestLevel` `QuestLevel` smallint(3) NOT NULL default '1'; +ALTER TABLE `quest_template` CHANGE COLUMN `RewSpellCast` `RewSpellCast` int(11) NOT NULL DEFAULT '0'; -- cgit v1.2.3