* Big clean up of converter (world)

* Separated files for run only once and others

--HG--
branch : trunk

2 files changed, 200 insertions, 203 deletions

diff --git a/sql/TBC-WLK converter/TBC-WLK_world.sql b/sql/TBC-WLK converter/TBC-WLK_world.sql
index ff0b1207f6f..d24a65085ee 100644
--- a/sql/TBC-WLK converter/TBC-WLK_world.sql
+++ b/sql/TBC-WLK converter/TBC-WLK_world.sql
@@ -1,136 +1,31 @@
-DROP TABLE IF EXISTS `achievement_reward`;
-CREATE TABLE `achievement_reward` (
-  `entry` mediumint(8) unsigned NOT NULL default '0',
-  `title_A` mediumint(8) unsigned NOT NULL default '0',
-  `title_H` mediumint(8) unsigned NOT NULL default '0',
-  `item` mediumint(8) unsigned NOT NULL default '0',
-  `sender` mediumint(8) unsigned NOT NULL default '0',
-  `subject` varchar(255) default NULL,
-  `text` text,
-  PRIMARY KEY  (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
-
-
-DROP TABLE IF EXISTS `locales_achievement_reward`;
-CREATE TABLE `locales_achievement_reward` (
-  `entry` mediumint(8) unsigned NOT NULL default '0',
-  `subject_loc1` varchar(100) NOT NULL default '',
-  `subject_loc2` varchar(100) NOT NULL default '',
-  `subject_loc3` varchar(100) NOT NULL default '',
-  `subject_loc4` varchar(100) NOT NULL default '',
-  `subject_loc5` varchar(100) NOT NULL default '',
-  `subject_loc6` varchar(100) NOT NULL default '',
-  `subject_loc7` varchar(100) NOT NULL default '',
-  `subject_loc8` varchar(100) NOT NULL default '',
-  `text_loc1` text default NULL,
-  `text_loc2` text default NULL,
-  `text_loc3` text default NULL,
-  `text_loc4` text default NULL,
-  `text_loc5` text default NULL,
-  `text_loc6` text default NULL,
-  `text_loc7` text default NULL,
-  `text_loc8` text default NULL,
-  PRIMARY KEY  (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
-DELETE FROM `battleground_template` WHERE id IN (9,10,11);
+-- battleground
+DELETE FROM `battleground_template` WHERE `id` IN (9,10,11);
 INSERT INTO `battleground_template` VALUES
 (9,0,0,0,0,1367,0,1368,0),
 (10,5,5,10,80,1362,0,1363,0),
 (11,5,5,10,80,1364,0,1365,0);
 
-TRUNCATE `creature_equip_template`;
-alter table `creature_equip_template`
-    drop column `equipinfo1`,
-    drop column `equipinfo2`,
-    drop column `equipinfo3`,
-    drop column `equipslot1`,
-    drop column `equipslot2`,
-    drop column `equipslot3`,
-    change `equipmodel1` `equipentry1` mediumint(8) UNSIGNED default '0' NOT NULL,
-    change `equipmodel2` `equipentry2` mediumint(8) UNSIGNED default '0' NOT NULL,
-    change `equipmodel3` `equipentry3` mediumint(8) UNSIGNED default '0' NOT NULL;
-update `creature_template` set equipment_id = 0;
-	
-ALTER TABLE `item_template`
-    add column `ScalingStatDistribution` smallint(6) DEFAULT '0' NOT NULL after `stat_value10`,
-    add column `ScalingStatValue` smallint(6) DEFAULT '0' NOT NULL after `ScalingStatDistribution`,
-    add column `ItemLimitCategory` smallint(6) DEFAULT '0' NOT NULL after `ArmorDamageModifier`,
-    change `Duration` `Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time' after ArmorDamageModifier,
-    add column `StatsCount` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `ContainerSlots`,
-    CHANGE COLUMN `TotemCategory` `TotemCategory` mediumint(9) NOT NULL default '0';
-
-UPDATE item_template
-    SET maxcount = 0 WHERE maxcount > 32000;
-UPDATE item_template
-    SET stackable = 0 WHERE stackable > 32000;
-ALTER TABLE item_template
-    CHANGE COLUMN maxcount  maxcount  smallint(5) NOT NULL default '-1',
-    CHANGE COLUMN stackable stackable smallint(5) NOT NULL default '1';
-UPDATE item_template
-    SET stackable = -1 WHERE stackable = 0;	
-
-ALTER TABLE `quest_template`
-    add column `PlayersSlain` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `CharTitleId`,
-    add column `BonusTalents` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `PlayersSlain`,
-    CHANGE `RewHonorableKills` `RewHonorableKills` int unsigned NOT NULL default '0';
-
-DROP TABLE IF EXISTS `milling_loot_template`;
-CREATE TABLE `milling_loot_template` (
-  `entry` mediumint(8) unsigned NOT NULL default '0',
-  `item` mediumint(8) unsigned NOT NULL default '0',
-  `ChanceOrQuestChance` float NOT NULL default '100',
-  `groupid` tinyint(3) unsigned NOT NULL default '0',
-  `mincountOrRef` mediumint(9) NOT NULL default '1',
-  `maxcount` tinyint(3) unsigned NOT NULL default '1',
-  `lootcondition` tinyint(3) unsigned NOT NULL default '0',
-  `condition_value1` mediumint(8) unsigned NOT NULL default '0',
-  `condition_value2` mediumint(8) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`,`item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
-
-DROP TABLE IF EXISTS `spell_affect`;
-CREATE TABLE `spell_affect` (
-  `entry` smallint(5) unsigned NOT NULL default '0',
-  `effectId` tinyint(3) unsigned NOT NULL default '0',
-  `SpellClassMask0` int(5) unsigned NOT NULL default '0',
-  `SpellClassMask1` int(5) unsigned NOT NULL default '0',
-  `SpellClassMask2` int(5) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`,`effectId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-ALTER TABLE skill_discovery_template
-   DROP PRIMARY KEY,
-   ADD PRIMARY KEY (`spellId`,`reqSpell`),
-   ADD COLUMN reqClass tinyint(2) unsigned NOT NULL default '0' COMMENT 'class requirement' AFTER reqSpell;
-ALTER TABLE skill_discovery_template
-   DROP `reqClass`,
-   ADD COLUMN `reqSkillValue` smallint(5) unsigned NOT NULL default '0' COMMENT 'skill points requirement' AFTER reqSpell;
-
 -- command
+DELETE FROM `command` WHERE name = 'reload';
 DELETE FROM `command` WHERE `name` = 'modify runicpower';
 INSERT INTO `command` VALUES
 ('modify runicpower',1,'Syntax: .modify runicpower #newrunicpower\r\n\r\nModify the runic power of the selected player. If no player is selected, modify your runic power.');
 
-DELETE FROM `command` WHERE name = 'reload';
-
-
 -- string
-DELETE FROM trinity_string WHERE entry in (345,346);
+DELETE FROM `trinity_string` WHERE `entry` in (345,346);
 INSERT INTO `trinity_string` VALUES
 (345,'Forced customize for player %s will be requested at next login.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (346,'Forced customize for player %s (GUID #%u) will be requested at next login.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 
-DELETE FROM trinity_string WHERE entry in (712,717,718,719);
-INSERT INTO trinity_string VALUES
+DELETE FROM `trinity_string` WHERE entry in (712,717,718,719);
+INSERT INTO `trinity_string` VALUES
 (712,'|cffff0000[BG Queue Announcer]:|r %s -- [%u-%u] A: %u/%u, H: %u/%u|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (717,'|cffff0000[BG Queue Announcer]:|r %s -- [%u-%u] Started!|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (718,'|cffff0000[Arena Queue Announcer]:|r %s -- Joined : %ux%u : %u|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (719,'|cffff0000[Arena Queue Announcer]:|r %s -- Exited : %ux%u : %u|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 
-DELETE FROM trinity_string WHERE entry in (720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736);
-INSERT INTO trinity_string VALUES
+DELETE FROM `trinity_string` WHERE entry in (720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736);
+INSERT INTO `trinity_string` VALUES
 (720,'Your group is too large for this battleground. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (721,'Your group is too large for this arena. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (722,'Your group has members not in your arena team. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
@@ -149,7 +44,7 @@ INSERT INTO trinity_string VALUES
 (735,'You must be in GM mode to teleport to a player in a battleground.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (736,'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 
-DELETE FROM trinity_string WHERE entry in (1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138);
+DELETE FROM `trinity_string` WHERE entry in (1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138);
 
 DELETE FROM `trinity_string` WHERE `entry` IN (173,174);
 INSERT INTO `trinity_string` VALUES
@@ -165,93 +60,6 @@ INSERT INTO `trinity_string` VALUES
 
 -- data
 
-DROP TABLE IF EXISTS `player_classlevelstats`;
-CREATE TABLE `player_classlevelstats` (
-  `class` tinyint(3) unsigned NOT NULL,
-  `level` tinyint(3) unsigned NOT NULL,
-  `basehp` smallint(5) unsigned NOT NULL,
-  `basemana` smallint(5) unsigned NOT NULL,
-  PRIMARY KEY  (`class`,`level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';
-
-DROP TABLE IF EXISTS `player_levelstats`;
-CREATE TABLE `player_levelstats` (
-  `race` tinyint(3) unsigned NOT NULL,
-  `class` tinyint(3) unsigned NOT NULL,
-  `level` tinyint(3) unsigned NOT NULL,
-  `str` tinyint(3) unsigned NOT NULL,
-  `agi` tinyint(3) unsigned NOT NULL,
-  `sta` tinyint(3) unsigned NOT NULL,
-  `inte` tinyint(3) unsigned NOT NULL,
-  `spi` tinyint(3) unsigned NOT NULL,
-  PRIMARY KEY  (`race`,`class`,`level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';
-
-DROP TABLE IF EXISTS `playercreateinfo_spell`;
-CREATE TABLE `playercreateinfo_spell` (
-  `race` tinyint(3) unsigned NOT NULL default '0',
-  `class` tinyint(3) unsigned NOT NULL default '0',
-  `Spell` mediumint(8) unsigned NOT NULL default '0',
-  `Note` varchar(255) default NULL,
-  PRIMARY KEY  (`race`,`class`,`Spell`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `playercreateinfo_action`;
-CREATE TABLE `playercreateinfo_action` (
-  `race` tinyint(3) unsigned NOT NULL default '0',
-  `class` tinyint(3) unsigned NOT NULL default '0',
-  `button` smallint(5) unsigned NOT NULL default '0',
-  `action` smallint(5) unsigned NOT NULL default '0',
-  `type` smallint(5) unsigned NOT NULL default '0',
-  `misc` smallint(5) unsigned NOT NULL default '0',
-  KEY `playercreateinfo_race_class_index` (`race`,`class`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `spell_learn_spell`;
-CREATE TABLE `spell_learn_spell` (
-  `entry` smallint(5) unsigned NOT NULL default '0',
-  `SpellID` smallint(5) unsigned NOT NULL default '0',
-  `Active` tinyint(3) unsigned NOT NULL default '1',
-  PRIMARY KEY  (`entry`,`SpellID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
-
-DROP TABLE IF EXISTS `spell_proc_event`;
-CREATE TABLE `spell_proc_event` (
-  `entry` smallint(5) unsigned NOT NULL default '0',
-  `SchoolMask` tinyint(4) NOT NULL default '0',
-  `SpellFamilyName` smallint(5) unsigned NOT NULL default '0',
-  `SpellFamilyMask0` int(10) unsigned NOT NULL default '0',
-  `SpellFamilyMask1` int(10) unsigned NOT NULL default '0',
-  `SpellFamilyMask2` int(10) unsigned NOT NULL default '0',
-  `procFlags` int(10) unsigned NOT NULL default '0',
-  `procEx` int(10) unsigned NOT NULL default '0',
-  `ppmRate` float NOT NULL default '0',
-  `CustomChance` float NOT NULL default '0',
-  `Cooldown` int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `player_xp_for_level`;
-CREATE TABLE `player_xp_for_level` (
-  `lvl` int(3) unsigned NOT NULL,
-  `xp_for_next_level` int(10) unsigned NOT NULL,
-  PRIMARY KEY  (`lvl`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `spell_loot_template`;
-CREATE TABLE `spell_loot_template` (
-  `entry` mediumint(8) unsigned NOT NULL default '0',
-  `item` mediumint(8) unsigned NOT NULL default '0',
-  `ChanceOrQuestChance` float NOT NULL default '100',
-  `groupid` tinyint(3) unsigned NOT NULL default '0',
-  `mincountOrRef` mediumint(9) NOT NULL default '1',
-  `maxcount` tinyint(3) unsigned NOT NULL default '1',
-  `lootcondition` tinyint(3) unsigned NOT NULL default '0',
-  `condition_value1` mediumint(8) unsigned NOT NULL default '0',
-  `condition_value2` mediumint(8) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`,`item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
-
 INSERT INTO world.player_classlevelstats SELECT * FROM mangos.player_classlevelstats;
 INSERT INTO world.player_levelstats SELECT * FROM mangos.player_levelstats;
 INSERT INTO world.playercreateinfo_spell SELECT * FROM mangos.playercreateinfo_spell;
@@ -261,8 +69,8 @@ INSERT INTO world.player_xp_for_level SELECT * FROM mangos.player_xp_for_level;
 INSERT INTO world.spell_loot_template SELECT * FROM mangos.spell_loot_template;
 
 
-DELETE FROM item_template WHERE entry IN (34648,34649,34650,34651,34652,34653,34655,34656,34657,34658,34659,38145,38147,41751);
-INSERT INTO item_template VALUES
+DELETE FROM `item_template` WHERE entry IN (34648,34649,34650,34651,34652,34653,34655,34656,34657,34658,34659,38145,38147,41751);
+INSERT INTO `item_template` VALUES
 (34648,4,4,-1,'Acherus Knight\'s Greaves',51496,2,32768,1,51,10,8,-1,-1,60,55,0,0,0,0,0,0,0,0,1,0,3,4,10,7,12,3,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,392,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,1,'',0,0,0,0,0,6,0,0,0,0,0,55,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,'',0,0,0,0),
 (34649,4,4,-1,'Acherus Knight\'s Gauntlets',51498,2,32768,1,34,6,10,-1,-1,60,55,0,0,0,0,0,0,0,0,1,0,3,4,15,7,6,32,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,356,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,1,'',0,0,0,0,0,6,0,0,0,0,0,40,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,'',0,0,0,0),
 (34650,4,4,-1,'Acherus Knight\'s Tunic',51494,2,32768,1,69,13,5,-1,-1,60,55,0,0,0,0,0,0,0,0,1,0,3,4,20,7,11,32,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,570,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,1,'',0,0,0,0,0,6,0,0,0,0,0,115,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,'',0,0,0,0),
diff --git a/sql/TBC-WLK converter/TBC-WLK_world_run_only_once.sql b/sql/TBC-WLK converter/TBC-WLK_world_run_only_once.sql
new file mode 100644
index 00000000000..5882d1a0b3c
--- /dev/null
+++ b/sql/TBC-WLK converter/TBC-WLK_world_run_only_once.sql
@@ -0,0 +1,189 @@
+DROP TABLE IF EXISTS `achievement_reward`;

+CREATE TABLE `achievement_reward` (

+  `entry` mediumint(8) unsigned NOT NULL default '0',

+  `title_A` mediumint(8) unsigned NOT NULL default '0',

+  `title_H` mediumint(8) unsigned NOT NULL default '0',

+  `item` mediumint(8) unsigned NOT NULL default '0',

+  `sender` mediumint(8) unsigned NOT NULL default '0',

+  `subject` varchar(255) default NULL,

+  `text` text,

+  PRIMARY KEY  (`entry`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';

+

+

+DROP TABLE IF EXISTS `locales_achievement_reward`;

+CREATE TABLE `locales_achievement_reward` (

+  `entry` mediumint(8) unsigned NOT NULL default '0',

+  `subject_loc1` varchar(100) NOT NULL default '',

+  `subject_loc2` varchar(100) NOT NULL default '',

+  `subject_loc3` varchar(100) NOT NULL default '',

+  `subject_loc4` varchar(100) NOT NULL default '',

+  `subject_loc5` varchar(100) NOT NULL default '',

+  `subject_loc6` varchar(100) NOT NULL default '',

+  `subject_loc7` varchar(100) NOT NULL default '',

+  `subject_loc8` varchar(100) NOT NULL default '',

+  `text_loc1` text default NULL,

+  `text_loc2` text default NULL,

+  `text_loc3` text default NULL,

+  `text_loc4` text default NULL,

+  `text_loc5` text default NULL,

+  `text_loc6` text default NULL,

+  `text_loc7` text default NULL,

+  `text_loc8` text default NULL,

+  PRIMARY KEY  (`entry`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+TRUNCATE `creature_equip_template`;

+ALTER TABLE `creature_equip_template`

+    DROP COLUMN `equipinfo1`,

+    DROP COLUMN `equipinfo2`,

+    DROP COLUMN `equipinfo3`,

+    DROP COLUMN `equipslot1`,

+    DROP COLUMN `equipslot2`,

+    DROP COLUMN `equipslot3`,

+    CHANGE COLUMN `equipmodel1` `equipentry1` mediumint(8) UNSIGNED default '0' NOT NULL,

+    CHANGE COLUMN `equipmodel2` `equipentry2` mediumint(8) UNSIGNED default '0' NOT NULL,

+    CHANGE COLUMN `equipmodel3` `equipentry3` mediumint(8) UNSIGNED default '0' NOT NULL;

+UPDATE `creature_template` set equipment_id = 0;

+

+ALTER TABLE `item_template`

+    ADD COLUMN `ScalingStatDistribution` smallint(6) DEFAULT '0' NOT NULL after `stat_value10`,

+    ADD COLUMN `ScalingStatValue` smallint(6) DEFAULT '0' NOT NULL after `ScalingStatDistribution`,

+    ADD COLUMN `ItemLimitCategory` smallint(6) DEFAULT '0' NOT NULL after `ArmorDamageModifier`,

+    CHANGE COLUMN `Duration` `Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time' after ArmorDamageModifier,

+    ADD COLUMN `StatsCount` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `ContainerSlots`,

+    CHANGE COLUMN `TotemCategory` `TotemCategory` mediumint(9) NOT NULL default '0';

+

+UPDATE `item_template`

+    SET `maxcount`=0 WHERE `maxcount` > 32000;

+UPDATE `item_template`

+    SET `stackable`=0 WHERE `stackable` > 32000;

+ALTER TABLE `item_template`

+    CHANGE COLUMN `maxcount` `maxcount` smallint(5) NOT NULL default '-1',

+    CHANGE COLUMN `stackable` `stackable` smallint(5) NOT NULL default '1';

+UPDATE `item_template`

+    SET `stackable`=-1 WHERE `stackable` = 0;	

+

+ALTER TABLE `quest_template`

+    ADD COLUMN `PlayersSlain` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `CharTitleId`,

+    ADD COLUMN `BonusTalents` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `PlayersSlain`,

+    CHANGE COLUMN `RewHonorableKills` `RewHonorableKills` int unsigned NOT NULL default '0';

+    

+DROP TABLE IF EXISTS `milling_loot_template`;

+CREATE TABLE `milling_loot_template` (

+  `entry` mediumint(8) unsigned NOT NULL default '0',

+  `item` mediumint(8) unsigned NOT NULL default '0',

+  `ChanceOrQuestChance` float NOT NULL default '100',

+  `groupid` tinyint(3) unsigned NOT NULL default '0',

+  `mincountOrRef` mediumint(9) NOT NULL default '1',

+  `maxcount` tinyint(3) unsigned NOT NULL default '1',

+  `lootcondition` tinyint(3) unsigned NOT NULL default '0',

+  `condition_value1` mediumint(8) unsigned NOT NULL default '0',

+  `condition_value2` mediumint(8) unsigned NOT NULL default '0',

+  PRIMARY KEY  (`entry`,`item`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';

+

+DROP TABLE IF EXISTS `spell_affect`;

+CREATE TABLE `spell_affect` (

+  `entry` smallint(5) unsigned NOT NULL default '0',

+  `effectId` tinyint(3) unsigned NOT NULL default '0',

+  `SpellClassMask0` int(5) unsigned NOT NULL default '0',

+  `SpellClassMask1` int(5) unsigned NOT NULL default '0',

+  `SpellClassMask2` int(5) unsigned NOT NULL default '0',

+  PRIMARY KEY  (`entry`,`effectId`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+ALTER TABLE `skill_discovery_template`

+   DROP PRIMARY KEY,

+   ADD PRIMARY KEY (`spellId`,`reqSpell`),

+   ADD COLUMN `reqClass` tinyint(2) unsigned NOT NULL default '0' COMMENT 'class requirement' AFTER reqSpell;

+ALTER TABLE skill_discovery_template

+   DROP COLUMN `reqClass`,

+   ADD COLUMN `reqSkillValue` smallint(5) unsigned NOT NULL default '0' COMMENT 'skill points requirement' AFTER reqSpell;

+   

+DROP TABLE IF EXISTS `player_classlevelstats`;

+CREATE TABLE `player_classlevelstats` (

+  `class` tinyint(3) unsigned NOT NULL,

+  `level` tinyint(3) unsigned NOT NULL,

+  `basehp` smallint(5) unsigned NOT NULL,

+  `basemana` smallint(5) unsigned NOT NULL,

+  PRIMARY KEY  (`class`,`level`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';

+

+DROP TABLE IF EXISTS `player_levelstats`;

+CREATE TABLE `player_levelstats` (

+  `race` tinyint(3) unsigned NOT NULL,

+  `class` tinyint(3) unsigned NOT NULL,

+  `level` tinyint(3) unsigned NOT NULL,

+  `str` tinyint(3) unsigned NOT NULL,

+  `agi` tinyint(3) unsigned NOT NULL,

+  `sta` tinyint(3) unsigned NOT NULL,

+  `inte` tinyint(3) unsigned NOT NULL,

+  `spi` tinyint(3) unsigned NOT NULL,

+  PRIMARY KEY  (`race`,`class`,`level`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';

+

+DROP TABLE IF EXISTS `playercreateinfo_spell`;

+CREATE TABLE `playercreateinfo_spell` (

+  `race` tinyint(3) unsigned NOT NULL default '0',

+  `class` tinyint(3) unsigned NOT NULL default '0',

+  `Spell` mediumint(8) unsigned NOT NULL default '0',

+  `Note` varchar(255) default NULL,

+  PRIMARY KEY  (`race`,`class`,`Spell`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+DROP TABLE IF EXISTS `playercreateinfo_action`;

+CREATE TABLE `playercreateinfo_action` (

+  `race` tinyint(3) unsigned NOT NULL default '0',

+  `class` tinyint(3) unsigned NOT NULL default '0',

+  `button` smallint(5) unsigned NOT NULL default '0',

+  `action` smallint(5) unsigned NOT NULL default '0',

+  `type` smallint(5) unsigned NOT NULL default '0',

+  `misc` smallint(5) unsigned NOT NULL default '0',

+  KEY `playercreateinfo_race_class_index` (`race`,`class`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+DROP TABLE IF EXISTS `spell_learn_spell`;

+CREATE TABLE `spell_learn_spell` (

+  `entry` smallint(5) unsigned NOT NULL default '0',

+  `SpellID` smallint(5) unsigned NOT NULL default '0',

+  `Active` tinyint(3) unsigned NOT NULL default '1',

+  PRIMARY KEY  (`entry`,`SpellID`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';

+

+DROP TABLE IF EXISTS `spell_proc_event`;

+CREATE TABLE `spell_proc_event` (

+  `entry` smallint(5) unsigned NOT NULL default '0',

+  `SchoolMask` tinyint(4) NOT NULL default '0',

+  `SpellFamilyName` smallint(5) unsigned NOT NULL default '0',

+  `SpellFamilyMask0` int(10) unsigned NOT NULL default '0',

+  `SpellFamilyMask1` int(10) unsigned NOT NULL default '0',

+  `SpellFamilyMask2` int(10) unsigned NOT NULL default '0',

+  `procFlags` int(10) unsigned NOT NULL default '0',

+  `procEx` int(10) unsigned NOT NULL default '0',

+  `ppmRate` float NOT NULL default '0',

+  `CustomChance` float NOT NULL default '0',

+  `Cooldown` int(10) unsigned NOT NULL default '0',

+  PRIMARY KEY  (`entry`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+DROP TABLE IF EXISTS `player_xp_for_level`;

+CREATE TABLE `player_xp_for_level` (

+  `lvl` int(3) unsigned NOT NULL,

+  `xp_for_next_level` int(10) unsigned NOT NULL,

+  PRIMARY KEY  (`lvl`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

+

+DROP TABLE IF EXISTS `spell_loot_template`;

+CREATE TABLE `spell_loot_template` (

+  `entry` mediumint(8) unsigned NOT NULL default '0',

+  `item` mediumint(8) unsigned NOT NULL default '0',

+  `ChanceOrQuestChance` float NOT NULL default '100',

+  `groupid` tinyint(3) unsigned NOT NULL default '0',

+  `mincountOrRef` mediumint(9) NOT NULL default '1',

+  `maxcount` tinyint(3) unsigned NOT NULL default '1',

+  `lootcondition` tinyint(3) unsigned NOT NULL default '0',

+  `condition_value1` mediumint(8) unsigned NOT NULL default '0',

+  `condition_value2` mediumint(8) unsigned NOT NULL default '0',

+  PRIMARY KEY  (`entry`,`item`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
\ No newline at end of file