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

11 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/7229_world_creature_template.sql b/sql/updates/7229_world_scriptname.sql
index c52d7091bff..c52d7091bff 100644
--- a/sql/updates/7229_world_creature_template.sql
+++ b/sql/updates/7229_world_scriptname.sql
diff --git a/sql/updates/7245_world_command.sql b/sql/updates/7246_world_command.sql
index 7fc9a2ed371..7fc9a2ed371 100644
--- a/sql/updates/7245_world_command.sql
+++ b/sql/updates/7246_world_command.sql
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';