From d454df54d13b78ff15ac06abf098824a5cfe3dbb Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 5 Jul 2015 01:18:57 +0200 Subject: Core/DataStores: Moved SkillTiers to database - it no longer exists in dbc form --- sql/updates/world/2015_07_05_00_world.sql | 61 +++++++++++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100644 sql/updates/world/2015_07_05_00_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3