Faith - Runes SQL

-- We guess potions are runes...

-- ----------------------------
-- Table structure for runes_data
-- ----------------------------
DROP TABLE IF EXISTS `runes_data`;
CREATE TABLE `runes_data` (
  `runeId` SMALLINT(5) NOT NULL DEFAULT '-1',
  `statId` CHAR(4) NOT NULL,
  `power` SMALLINT(2) NOT NULL DEFAULT '-1',
  `weight` FLOAT(4,2) NOT NULL DEFAULT '-1.00',
  `name` VARCHAR(25) NOT NULL DEFAULT '',
  UNIQUE KEY `runeId` (`runeId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of runes_data
-- ----------------------------
INSERT INTO `runes_data` VALUES ('1519', '76', '1', '1.00', 'Rune Fo');
INSERT INTO `runes_data` VALUES ('1521', '7c', '1', '3.00', 'Rune Sa');
INSERT INTO `runes_data` VALUES ('1522', '7e', '1', '1.00', 'Rune Ine');
INSERT INTO `runes_data` VALUES ('1523', '7d', '3', '0.75', 'Rune Vi');
INSERT INTO `runes_data` VALUES ('1524', '77', '1', '1.00', 'Rune Age');
INSERT INTO `runes_data` VALUES ('1525', '7b', '1', '1.00', 'Rune Cha');
INSERT INTO `runes_data` VALUES ('1545', '77', '3', '3.00', 'Rune Pa Fo');
INSERT INTO `runes_data` VALUES ('1546', '7c', '3', '9.00', 'Rune Pa Sa');
INSERT INTO `runes_data` VALUES ('1547', '7e', '3', '3.00', 'Rune Pa Ine');
INSERT INTO `runes_data` VALUES ('1548', '7d', '10', '2.25', 'Rune Pa Vi');
INSERT INTO `runes_data` VALUES ('1549', '77', '3', '3.00', 'Rune Pa Age');
INSERT INTO `runes_data` VALUES ('1550', '7b', '3', '3.00', 'Rune Pa Cha');
INSERT INTO `runes_data` VALUES ('1551', '76', '10', '10.00', 'Rune Ra Fo');
INSERT INTO `runes_data` VALUES ('1552', '7c', '10', '30.00', 'Rune Ra Sa');
INSERT INTO `runes_data` VALUES ('1553', '7e', '10', '10.00', 'Rune Ra Ine');
INSERT INTO `runes_data` VALUES ('1554', '7d', '30', '6.75', 'Rune Ra Vi');
INSERT INTO `runes_data` VALUES ('1555', '77', '10', '10.00', 'Rune Ra Age');
INSERT INTO `runes_data` VALUES ('1556', '7b', '10', '10.00', 'Rune Ra Cha');
INSERT INTO `runes_data` VALUES ('1557', '6f', '1', '100.00', 'Rune Ga Pa');
INSERT INTO `runes_data` VALUES ('1558', '80', '1', '90.00', 'Rune Ga Pme');
INSERT INTO `runes_data` VALUES ('7433', '73', '1', '30.00', 'Rune Cri');
INSERT INTO `runes_data` VALUES ('7434', 'b2', '1', '20.00', 'Rune So');
INSERT INTO `runes_data` VALUES ('7435', '70', '1', '20.00', 'Rune Do');
INSERT INTO `runes_data` VALUES ('7436', '8a', '1', '2.00', 'Rune Do Per');
INSERT INTO `runes_data` VALUES ('7437', 'dc', '1', '30.00', 'Rune Do Ren');
INSERT INTO `runes_data` VALUES ('7438', '75', '1', '51.00', 'Rune Po');
INSERT INTO `runes_data` VALUES ('7442', 'b6', '1', '30.00', 'Rune Invo');
INSERT INTO `runes_data` VALUES ('7443', '9e', '10', '2.50', 'Rune Pod');
INSERT INTO `runes_data` VALUES ('7444', '9e', '30', '7.50', 'Rune Pa Pod');
INSERT INTO `runes_data` VALUES ('7445', '9e', '100', '25.00', 'Rune Ra Pod');
INSERT INTO `runes_data` VALUES ('7446', 'e1', '1', '15.00', 'Rune Pi');
INSERT INTO `runes_data` VALUES ('7447', 'e2', '1', '2.00', 'Rune Pi Per');
INSERT INTO `runes_data` VALUES ('7448', 'ae', '10', '1.00', 'Rune Ini');
INSERT INTO `runes_data` VALUES ('7449', 'ae', '30', '3.00', 'Rune Pa Ini');
INSERT INTO `runes_data` VALUES ('7450', 'ae', '100', '10.00', 'Rune Ra Ini');
INSERT INTO `runes_data` VALUES ('7451', 'b0', '1', '3.00', 'Rune Prospe');
INSERT INTO `runes_data` VALUES ('7452', 'f3', '1', '2.00', 'Rune Ré Feu');
INSERT INTO `runes_data` VALUES ('7453', 'f2', '1', '2.00', 'Rune Ré Air');
INSERT INTO `runes_data` VALUES ('7454', 'f1', '1', '2.00', 'Rune Ré Eau');
INSERT INTO `runes_data` VALUES ('7455', 'f0', '1', '2.00', 'Rune Ré Terre');
INSERT INTO `runes_data` VALUES ('7456', 'f4', '1', '2.00', 'Rune Ré Neutre');
INSERT INTO `runes_data` VALUES ('7457', 'd5', '1', '6.00', 'Rune Ré Per Feu');
INSERT INTO `runes_data` VALUES ('7458', 'd4', '1', '6.00', 'Rune Ré Per Air');
INSERT INTO `runes_data` VALUES ('7459', 'd2', '1', '6.00', 'Rune Ré Per Terre');
INSERT INTO `runes_data` VALUES ('7460', 'd6', '1', '6.00', 'Rune Ré Per Neutre');
INSERT INTO `runes_data` VALUES ('7508', '3dc', '1', '0.00', 'Rune de Signature');
INSERT INTO `runes_data` VALUES ('7560', 'd3', '1', '5.00', 'Rune Ré Per Eau');
INSERT INTO `runes_data` VALUES ('8379', '7d', '1', '1.00', 'Rune Vie');
INSERT INTO `runes_data` VALUES ('10613', 'e2', '1', '45.00', 'Rune Pa Pi');
INSERT INTO `runes_data` VALUES ('10615', 'e2', '3', '6.00', 'Rune Pa Pi Per');
INSERT INTO `runes_data` VALUES ('10616', 'e2', '10', '20.00', 'Rune Ra Pi Per');
INSERT INTO `runes_data` VALUES ('10618', '8a', '3', '6.00', 'Rune Pa Do Per');
INSERT INTO `runes_data` VALUES ('10619', '8a', '10', '20.00', 'Rune Ra Do Per');
INSERT INTO `runes_data` VALUES ('10662', 'b0', '3', '9.00', 'Rune Pa Prospe');
INSERT INTO `runes_data` VALUES ('1333', '63', '-1', '-1.00', 'Potion d\'Etincelle');
INSERT INTO `runes_data` VALUES ('1335', '60', '-1', '-1.00', 'Potion de Crachin');
INSERT INTO `runes_data` VALUES ('1337', '62', '-1', '-1.00', 'Potion de Courant d\'Air');
INSERT INTO `runes_data` VALUES ('1338', '61', '-1', '-1.00', 'Potion de Secousse');
INSERT INTO `runes_data` VALUES ('1340', '61', '-1', '-1.00', 'Potion d\'Eboulement');
INSERT INTO `runes_data` VALUES ('1341', '60', '-1', '-1.00', 'Potion d\'Averse');
INSERT INTO `runes_data` VALUES ('1342', '62', '-1', '-1.00', 'Potion de Rafale');
INSERT INTO `runes_data` VALUES ('1343', '63', '-1', '-1.00', 'Potion de Flambée');
INSERT INTO `runes_data` VALUES ('1345', '63', '-1', '-1.00', 'Potion d\'Incendie');
INSERT INTO `runes_data` VALUES ('1346', '60', '-1', '-1.00', 'Potion de Tsunami');
INSERT INTO `runes_data` VALUES ('1347', '62', '-1', '-1.00', 'Potion d\'Ouragan');
INSERT INTO `runes_data` VALUES ('1348', '61', '-1', '-1.00', 'Potion de Séisme');
INSERT INTO `runes_data` VALUES ('10057', '31b', '1', '5.00', 'Rune de chasse');