· 9 years ago · Dec 16, 2016, 08:05 PM
1DROP TABLE IF EXISTS `dbc_PowerType`;
2CREATE TABLE `dbc_PowerType` (
3 `m_ID` INT NOT NULL DEFAULT '0',
4 `field04` TEXT NOT NULL,
5 `field08` TEXT NOT NULL,
6 `field0C` FLOAT NOT NULL DEFAULT '0',
7 `field10` FLOAT NOT NULL DEFAULT '0',
8 `field14` INT NOT NULL DEFAULT '0',
9 `field16` INT NOT NULL DEFAULT '0',
10 `field18` INT NOT NULL DEFAULT '0',
11 `field1A` INT UNSIGNED NOT NULL DEFAULT '0',
12 `field1B` INT UNSIGNED NOT NULL DEFAULT '0',
13 `field1C` INT UNSIGNED NOT NULL DEFAULT '0',
14 `field1D` INT UNSIGNED NOT NULL DEFAULT '0',
15 `field1E_0` INT UNSIGNED NOT NULL DEFAULT '0',
16 `field1E_1` INT UNSIGNED NOT NULL DEFAULT '0',
17 PRIMARY KEY (`m_ID`)
18) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Export of PowerType.db2';
19
20INSERT INTO `dbc_PowerType` VALUES (1, "MANA", "MANA_COST", 0, 0, 0, 0, 12480, 0, 0, 0, 0, 1, 0);
21INSERT INTO `dbc_PowerType` VALUES (2, "RAGE", "RAGE_COST", -12.5, 0, 1000, 0, 8192, 1, 0, 0, 0, 10, 0);
22INSERT INTO `dbc_PowerType` VALUES (3, "FOCUS", "FOCUS_COST", 10, 10, 100, 0, 9344, 2, 0, 0, 100, 1, 0);
23INSERT INTO `dbc_PowerType` VALUES (4, "ENERGY", "ENERGY_COST", 10, 10, 100, 0, 13440, 3, 0, 0, 100, 1, 0);
24INSERT INTO `dbc_PowerType` VALUES (5, "COMBO_POINTS", "COMBO_POINTS_COST", -0.1, 0, 5, 10000, 186, 4, 0, 0, 0, 1, 0);
25INSERT INTO `dbc_PowerType` VALUES (6, "RUNES", "RUNE_COST", 0.1, 0.1, 6, 0, 9728, 5, 0, 0, 6, 1, 0);
26INSERT INTO `dbc_PowerType` VALUES (7, "RUNIC_POWER", "RUNIC_POWER_COST", -12.5, 0, 1000, 0, 0, 6, 0, 0, 0, 10, 0);
27INSERT INTO `dbc_PowerType` VALUES (8, "SOUL_SHARDS", "SOUL_SHARDS_COST", -0.25, 0, 5, 12000, 8287, 7, 0, 3, 3, 1, 0);
28INSERT INTO `dbc_PowerType` VALUES (9, "LUNAR_POWER", "LUNAR_POWER_COST", -40, 0, 1000, 20000, 34, 8, 0, 0, 0, 10, 0);
29INSERT INTO `dbc_PowerType` VALUES (10, "HOLY_POWER", "HOLY_POWER_COST", -0.1, 0, 3, 10000, 27, 9, 0, 0, 0, 1, 0);
30INSERT INTO `dbc_PowerType` VALUES (12, "ALTERNATE", "ALTERNATE_COST", 0, 0, 0, 0, 128, 10, 0, 0, 0, 1, 0);
31INSERT INTO `dbc_PowerType` VALUES (13, "MAELSTROM", "MAELSTROM_COST", -1, 0, 100, 0, 48, 11, 0, 0, 0, 1, 0);
32INSERT INTO `dbc_PowerType` VALUES (14, "CHI", "CHI_COST", -0.1, 0, 4, 10000, 26, 12, 0, 0, 0, 1, 0);
33INSERT INTO `dbc_PowerType` VALUES (16, "ARCANE_CHARGES", "ARCANE_CHARGES_COST", -0.2, 0, 4, 30000, 58, 16, 0, 0, 0, 1, 0);
34INSERT INTO `dbc_PowerType` VALUES (17, "FURY", "FURY_COST", -1, 0, 100, 10000, 0, 17, 0, 0, 0, 1, 0);
35INSERT INTO `dbc_PowerType` VALUES (18, "PAIN", "PAIN_COST", -10, 0, 1000, 10000, 0, 18, 0, 0, 0, 10, 0);
36INSERT INTO `dbc_PowerType` VALUES (19, "INSANITY", "INSANITY_COST", -100, 0, 10000, 30000, 34, 13, 0, 0, 0, 100, 0);