Core/DataStores: Moved SkillTiers to database - it no longer exists in dbc form

1 files changed, 61 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_05_00_world.sql b/sql/updates/world/2015_07_05_00_world.sql
new file mode 100644
index 00000000000..197e7c8ac23
--- /dev/null
+++ b/sql/updates/world/2015_07_05_00_world.sql
@@ -0,0 +1,61 @@
+--
+-- Table structure for table `skill_tiers`
+--
+
+DROP TABLE IF EXISTS `skill_tiers`;
+CREATE TABLE `skill_tiers` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value4` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value5` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value6` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value7` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value8` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value9` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value10` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value11` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value12` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value13` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value14` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value15` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value16` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `skill_tiers` (`ID`,`Value1`,`Value2`,`Value3`,`Value4`,`Value5`,`Value6`,`Value7`,`Value8`,`Value9`,`Value10`,`Value11`,`Value12`,`Value13`,`Value14`,`Value15`,`Value16`) VALUES
+(2,75,150,225,300,375,450,525,600,700,800,900,1000,0,0,0,0),
+(21,300,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(22,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(23,75,150,225,300,375,450,525,600,700,750,825,900,0,0,0,0),
+(24,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(41,75,150,225,300,375,450,525,600,700,800,900,1000,1100,1200,1300,1400),
+(61,75,150,225,300,375,450,525,600,700,750,825,900,0,0,0,0),
+(62,75,150,225,300,375,450,525,600,700,800,900,1000,1100,1200,1300,1400),
+(63,75,150,225,300,375,450,525,600,700,750,825,900,0,0,0,0),
+(81,75,150,225,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(121,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(122,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(123,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(124,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(125,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(126,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(127,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(141,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(142,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(143,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(161,75,150,225,300,375,450,525,600,700,800,900,1000,1100,1200,1300,1400),
+(181,300,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(182,300,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(221,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(222,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(223,75,150,225,300,375,0,0,0,0,0,0,0,0,0,0,0),
+(224,75,150,225,300,375,450,525,600,700,750,825,900,0,0,0,0),
+(230,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(233,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(234,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(235,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(236,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(237,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(295,30,0,0,300,375,450,525,600,700,800,900,1000,0,0,0,0);