BD.sql

-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Lun 01 Juin 2015 à 19:20
-- Version du serveur: 5.1.66
-- Version de PHP: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `u842844217_bd1`
--

DELIMITER $$
--
-- Procédures
--
CREATE DEFINER=`u842844217_admin`@`localhost` PROCEDURE `ADD_ARMOR`( IN id INT( 5 ) , IN name VARCHAR( 50 ) , IN typeitem ENUM(  'HELMET',  'CHEST',  'LEGGINGS',  'BOOTS' ) , IN durability INT( 5 ) , IN weight FLOAT, IN normaldefense INT( 3 ) )
BEGIN INSERT INTO ITEM
VALUES (
id , name , typeitem
);

INSERT INTO ARMOR
VALUES (
id , durability , weight , normaldefense
);

END$$

CREATE DEFINER=`u842844217_admin`@`localhost` PROCEDURE `ADD_SHIELD`( IN id INT( 5 ) , IN name VARCHAR( 50 ) , IN typeitem ENUM('SMALLSHIELD','NORMALSHIELD','LARGESHIELD','UNIQUESHIELD','OTHERSHIELD') , IN durability INT( 5 ) , IN weight FLOAT, IN normalreduction INT ( 3 ) )
BEGIN INSERT INTO ITEM
VALUES (
id , name , typeitem
);

INSERT INTO SHIELD
VALUES (
id , durability , weight , normalreduction
);

END$$

CREATE DEFINER=`u842844217_admin`@`localhost` PROCEDURE `ADD_WEAPON`( IN id INT( 5 ) , IN name VARCHAR( 50 ) , IN typeitem ENUM('CATALYST','TALISMAN','FLAME','SHIELD','BOSS','BOW','GREATBOW','CROSSBOW','DAGGER','STRAIGHTSWORD','CURVEDSWORD','KATANA','PIERCINGSWORD','AXE','FISTWEAPON','HAMMER','SPEAR','HALLBERD','WHIP','GREATSWORD','ULTRAGREATSWORD','CURVEDGREATSWORD','GREATAXE','GREATHAMMER') , IN durability INT( 5 ) , IN weight FLOAT, IN normaldamages INT( 4 ) )
BEGIN INSERT INTO ITEM
VALUES (
id , name , typeitem
);

INSERT INTO WEAPON
VALUES (
id , durability , weight , normaldamages
);

END$$

DELIMITER ;

-- --------------------------------------------------------

--
-- Structure de la table `ARMOR`
--

CREATE TABLE IF NOT EXISTS `ARMOR` (
  `ID_ITEM` int(5) NOT NULL,
  `DURABILITY` int(4) NOT NULL,
  `WEIGHT` float NOT NULL,
  `NORMAL_DEFENSE` int(3) NOT NULL,
  KEY `ID_ITEM` (`ID_ITEM`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `ARMOR`
--

INSERT INTO `ARMOR` (`ID_ITEM`, `DURABILITY`, `WEIGHT`, `NORMAL_DEFENSE`) VALUES
(1, 150, 2.5, 17),
(2, 150, 2.2, 14),
(3, 600, 8, 26),
(4, 500, 3.5, 15),
(5, 200, 1.2, 6),
(6, 200, 1.2, 6),
(7, 200, 1.2, 6),
(8, 500, 4.5, 16),
(9, 150, 0.6, 6),
(10, 80, 1.4, 6),
(11, 300, 10, 21),
(12, 450, 4.2, 14),
(13, 250, 3, 14),
(14, 600, 6, 27),
(15, 550, 5, 21),
(16, 200, 0.7, 5),
(17, 600, 5.1, 22),
(18, 200, 1.2, 9),
(19, 400, 4.5, 22),
(20, 300, 3, 12),
(21, 500, 4.8, 15),
(22, 150, 0.4, 5),
(23, 300, 3, 12),
(24, 800, 3, 16),
(25, 150, 4.2, 25),
(26, 300, 3.8, 18),
(27, 150, 0.8, 6),
(28, 450, 4.7, 17),
(29, 500, 5.1, 16),
(30, 450, 4.5, 15),
(31, 600, 6.3, 27),
(32, 400, 1.4, 11),
(33, 700, 6.5, 39),
(34, 450, 6.5, 25),
(35, 800, 7.2, 41),
(36, 900, 7.5, 36),
(37, 600, 4.2, 18),
(38, 500, 4.5, 18),
(39, 500, 5.1, 18),
(40, 250, 4.1, 17),
(41, 200, 3, 10),
(42, 250, 1.1, 8),
(43, 250, 2.6, 10),
(44, 350, 4.5, 14),
(45, 400, 4.2, 14),
(46, 200, 0.9, 8),
(47, 150, 0.8, 7),
(48, 400, 1.5, 12),
(49, 400, 2.5, 12),
(50, 700, 5.5, 32),
(51, 150, 0.6, 3),
(52, 500, 5, 22),
(53, 250, 1.2, 7),
(54, 250, 2.5, 13),
(55, 350, 1.2, 8),
(56, 200, 0.9, 9),
(57, 600, 4.8, 21),
(58, 300, 3.9, 20),
(59, 700, 6.8, 40),
(60, 300, 2, 12),
(61, 200, 0.9, 8),
(62, 250, 3.5, 14),
(63, 500, 5.4, 16),
(64, 800, 6.8, 35),
(65, 400, 1.1, 8),
(66, 250, 1.2, 9),
(67, 400, 1.4, 9),
(68, 250, 1.1, 9),
(69, 400, 5, 18),
(70, 400, 2.7, 21),
(71, 800, 17.6, 91),
(72, 500, 14, 42),
(73, 200, 2.3, 20),
(74, 700, 17.6, 106),
(75, 600, 12, 52),
(76, 200, 2.3, 23),
(77, 250, 4, 41),
(78, 400, 6, 32),
(79, 300, 10.1, 53),
(80, 500, 12.9, 59),
(81, 150, 1.6, 9),
(82, 700, 12, 70),
(83, 80, 3.1, 20),
(84, 200, 2.3, 20),
(85, 150, 2, 19),
(86, 250, 6.4, 34),
(87, 250, 4.7, 24),
(88, 400, 10.9, 37),
(89, 350, 4, 22),
(90, 250, 6.6, 24),
(91, 250, 2.8, 21),
(92, 200, 7.8, 26),
(93, 900, 19.5, 92),
(94, 250, 5.9, 26),
(95, 800, 17, 86),
(96, 450, 13, 50),
(97, 700, 16.4, 91),
(98, 400, 3.5, 31),
(99, 600, 16.4, 72),
(100, 500, 11.7, 48),
(101, 450, 11.7, 39),
(102, 500, 13.3, 41),
(103, 450, 12.3, 45),
(104, 150, 3, 23),
(105, 300, 9.8, 45),
(106, 150, 10.9, 59),
(107, 400, 3.9, 32),
(108, 500, 12.5, 40),
(109, 300, 4.5, 27),
(110, 300, 6, 30),
(111, 400, 11.7, 57),
(112, 200, 3.1, 23),
(113, 600, 10.9, 48),
(114, 200, 1.8, 13),
(115, 250, 3.1, 23),
(116, 550, 13, 57),
(117, 600, 15.6, 68),
(118, 400, 3.9, 23),
(119, 450, 10.9, 37),
(120, 250, 10.5, 45),
(121, 350, 9, 35),
(122, 500, 13.3, 47),
(123, 600, 10.5, 42),
(124, 150, 1, 14),
(125, 400, 3.5, 23),
(126, 250, 4, 33),
(127, 400, 3.9, 32),
(128, 400, 2.3, 18),
(129, 250, 1.7, 14),
(130, 400, 2.1, 14),
(131, 250, 1.6, 12),
(132, 350, 0.7, 5),
(133, 400, 1.6, 12),
(134, 800, 10.4, 54),
(135, 500, 8.3, 25),
(136, 200, 1.4, 12),
(137, 700, 10.4, 61),
(138, 600, 5.5, 25),
(139, 200, 1.4, 13),
(140, 500, 7.6, 35),
(141, 150, 0.9, 6),
(142, 700, 4, 29),
(143, 80, 0.5, 3),
(144, 150, 1.2, 11),
(145, 200, 1.4, 12),
(146, 250, 2.8, 15),
(147, 250, 2.8, 12),
(148, 300, 3.6, 12),
(149, 400, 3.5, 17),
(150, 350, 4.3, 17),
(151, 900, 11.5, 54),
(152, 250, 3.5, 13),
(153, 800, 10.4, 54),
(154, 450, 7, 27),
(155, 700, 9.7, 54),
(156, 400, 1.2, 12),
(157, 600, 9.7, 41),
(158, 250, 6.2, 26),
(159, 500, 3, 11),
(160, 300, 3, 17),
(161, 500, 5, 21),
(162, 600, 4.6, 20),
(163, 450, 3.7, 18),
(164, 500, 7.8, 24),
(165, 450, 1.5, 6),
(166, 150, 1.2, 9),
(167, 300, 5.8, 27),
(168, 150, 6.4, 37),
(169, 400, 0.8, 7),
(170, 500, 7.4, 24),
(171, 300, 1.5, 10),
(172, 400, 6.9, 34),
(173, 200, 1.8, 14),
(174, 600, 5.4, 24),
(175, 400, 2.8, 15),
(176, 200, 1, 8),
(177, 400, 1.8, 11),
(178, 250, 1.8, 13),
(179, 550, 6, 26),
(180, 600, 9.2, 40),
(181, 450, 3.5, 17),
(182, 150, 0.6, 8),
(183, 400, 4, 32),
(184, 250, 2.5, 17),
(185, 400, 2.1, 14),
(186, 300, 6, 32),
(187, 250, 1.6, 12),
(188, 800, 10.4, 54),
(189, 500, 8.3, 25),
(190, 200, 1.4, 12),
(191, 700, 10.4, 61),
(192, 600, 6.5, 28),
(193, 200, 1.4, 13),
(194, 500, 7.6, 35),
(195, 150, 4, 22),
(196, 700, 7, 40),
(197, 80, 1.8, 12),
(198, 150, 2.5, 14),
(199, 200, 1.4, 12),
(200, 250, 5, 27),
(201, 250, 6.2, 26),
(202, 500, 6.9, 28),
(203, 600, 5.5, 23),
(204, 250, 2.8, 12),
(205, 400, 6.4, 22),
(206, 350, 5.3, 21),
(207, 350, 2, 14),
(208, 250, 1.4, 13),
(209, 250, 1.3, 12),
(210, 200, 1.5, 13),
(211, 400, 1.6, 12),
(212, 900, 11.5, 54),
(213, 250, 3.5, 13),
(214, 800, 10.4, 54),
(215, 450, 8, 31),
(216, 700, 9.7, 54),
(217, 400, 3, 23),
(218, 600, 9.7, 41),
(219, 450, 6.9, 23),
(220, 500, 7.8, 24),
(221, 450, 4, 15),
(222, 300, 5.8, 27),
(223, 150, 6.4, 37),
(224, 400, 3.5, 29),
(225, 500, 7.4, 24),
(226, 300, 3.2, 19),
(227, 300, 4.6, 18),
(228, 400, 6.9, 34),
(229, 200, 1.8, 14),
(230, 600, 6.4, 26),
(231, 500, 4, 14),
(232, 150, 2.5, 13),
(233, 400, 2.8, 16),
(234, 200, 1, 8),
(235, 250, 3, 12),
(236, 550, 7, 30),
(237, 600, 9.2, 40),
(238, 450, 6.4, 22),
(239, 150, 3, 15),
(240, 400, 2.8, 15);

--
-- Déclencheurs `ARMOR`
--
DROP TRIGGER IF EXISTS `SUPPR_ARMOR`;
DELIMITER //
CREATE TRIGGER `SUPPR_ARMOR` BEFORE DELETE ON `ARMOR`
 FOR EACH ROW DELETE FROM ITEM WHERE ID=OLD.ID_ITEM
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Structure de la table `DOUBLE_BOSS`
--

CREATE TABLE IF NOT EXISTS `DOUBLE_BOSS` (
  `ID_ENEMY` int(5) NOT NULL,
  `LIFE_SECOND_BOSS` int(5) NOT NULL,
  `LIFE_SUPER_BOSS_1` int(5) NOT NULL DEFAULT '0',
  `LIFE_SUPER_BOSS_2` int(5) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `DOUBLE_BOSS`
--

INSERT INTO `DOUBLE_BOSS` (`ID_ENEMY`, `LIFE_SECOND_BOSS`, `LIFE_SUPER_BOSS_1`, `LIFE_SUPER_BOSS_2`) VALUES
(173, 480, 0, 0),
(174, 1642, 4094, 2981);

-- --------------------------------------------------------

--
-- Structure de la table `ENEMY`
--

CREATE TABLE IF NOT EXISTS `ENEMY` (
  `ID` int(5) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LIFE` int(6) DEFAULT NULL,
  `BOSS` tinyint(1) NOT NULL DEFAULT '0',
  `DEATH_AMOUNT` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_BOSS` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1043 ;

--
-- Contenu de la table `ENEMY`
--

INSERT INTO `ENEMY` (`ID`, `NAME`, `LIFE`, `BOSS`, `DEATH_AMOUNT`) VALUES
(1, 'Hollow', 69, 0, 2),
(2, 'Undead Soldier', 102, 0, 1),
(3, 'Undead Soldier', 85, 0, 0),
(4, 'Armored Hollow', 75, 0, 3),
(5, 'Small Undead Rat', 80, 0, 0),
(6, 'Skeleton', 184, 0, 0),
(7, 'Giant Skeleton', 268, 0, 0),
(8, 'Black Knight', 497, 0, 0),
(9, 'Havel the Rock', 1034, 0, 0),
(10, 'Undead Attack Dog', 100, 0, 0),
(11, 'Hollow', 53, 0, 0),
(12, 'Undead Assassin', 138, 0, 0),
(13, 'Hollow', 63, 0, 1),
(14, 'Undead Soldier', 102, 0, 0),
(15, 'Small Undead Rat', 96, 0, 0),
(16, 'Black Knight', 532, 0, 0),
(17, 'Armored Tusk', 307, 0, 0),
(18, 'Channeler', 186, 0, 0),
(19, 'Prowling Demon', 1506, 0, 0),
(20, 'Heavy Knight', 372, 0, 0),
(21, 'Small Undead Rat', 112, 0, 0),
(22, 'Large Undead Rat', 140, 0, 0),
(23, 'Giant Undead Rat', 692, 0, 0),
(24, 'Undead Attack Dog', 100, 0, 0),
(25, 'Hollow', 74, 0, 0),
(26, 'Channeler', 186, 0, 0),
(27, 'Butcher', 672, 0, 0),
(28, 'Slime', 143, 0, 0),
(29, 'Basilisk', 116, 0, 0),
(30, 'Crystal Golem', 408, 0, 0),
(31, 'Golden Crystal Golem', 816, 0, 0),
(32, 'Hydra', 2520, 0, 0),
(33, 'Black Knight', 603, 0, 0),
(34, 'Giant Stone Knight', 190, 0, 0),
(35, 'Demonic Foliage', 193, 0, 0),
(36, 'Tree Lizard', 169, 0, 0),
(37, 'Great Feline', 1465, 0, 0),
(38, 'Possessed Tree', 180, 0, 0),
(39, 'Frog-Ray', 162, 0, 0),
(40, 'Mushroom Parent', 2376, 0, 0),
(41, 'Mushroom Child', 633, 0, 0),
(42, 'Bandit', 908, 0, 0),
(43, 'Cleric', 767, 0, 0),
(44, 'Hunter', 767, 0, 0),
(45, 'Knight', 849, 0, 0),
(46, 'Sorcerer', 719, 0, 0),
(47, 'Thief', 767, 0, 0),
(48, 'Infested Barbarian', 883, 0, 0),
(49, 'Infested Ghoul', 365, 0, 0),
(50, 'Blowdart Sniper', 93, 0, 0),
(51, 'Flaming Attack Dog', 124, 0, 0),
(52, 'Parasitic Wall Hugger', 593, 0, 0),
(53, 'Cragspider', 167, 0, 0),
(54, 'Giant Mosquito', 50, 0, 0),
(55, 'Giant Leech', 124, 0, 0),
(56, 'Ghost (Male)', 231, 0, 0),
(57, 'Ghost (Female)', 290, 0, 0),
(58, 'Darkwraith', 525, 0, 0),
(59, 'Mass of Souls', 2059, 0, 0),
(60, 'Drake', 1152, 0, 0),
(61, 'Undead Dragon', 3480, 0, 0),
(62, 'Mimic', 992, 0, 0),
(63, 'Serpent Soldier', 430, 0, 0),
(64, 'Serpent Mage', 290, 0, 0),
(65, 'Heavy Knight', 620, 0, 0),
(66, 'Prowling Demon', 1506, 0, 0),
(67, 'Prowling Demon', 2510, 0, 0),
(68, 'Giant', 1726, 0, 0),
(69, 'Balder Knight', 380, 0, 0),
(70, 'Undead Prince Ricard', 719, 0, 0),
(71, 'Gargoyle', 1119, 0, 0),
(72, 'Sentinel', 535, 0, 0),
(73, 'Royal Sentinel', 755, 0, 0),
(74, 'Painting Guardian', 230, 0, 0),
(75, 'Bat Wing Demon', 419, 0, 0),
(76, 'Silver Knight', 464, 0, 0),
(77, 'Mimic', 1041, 0, 0),
(78, 'Prowling Demon', 2635, 0, 0),
(79, 'Balder Knight', 767, 0, 0),
(80, 'Berenike Knight', 821, 0, 0),
(81, 'Pike Soldier', 821, 0, 0),
(82, 'Sorcerer', 719, 0, 0),
(83, 'Armored Tusk', 640, 0, 0),
(84, 'Undead Swordsman Crystal Soldier', 212, 0, 0),
(85, 'Undead Archer Crystal Soldier', 155, 0, 0),
(86, 'Channeler', 387, 0, 0),
(87, 'Crystal General', 742, 0, 0),
(88, 'Serpent Soldier', 537, 0, 0),
(89, 'Serpent Mage', 362, 0, 0),
(90, 'Pisaca', 350, 0, 0),
(91, 'Older Sister Pisaca', 800, 0, 0),
(92, 'Younger Sister Pisaca', 650, 0, 0),
(93, 'Mimic', 1240, 0, 0),
(94, 'Crystal Golem', 680, 0, 0),
(95, 'Golden Crystal Golem', 1360, 0, 0),
(96, 'Crystal Butterfly', 1255, 0, 0),
(97, 'Man Eater Shell', 740, 0, 0),
(98, 'Necromancer', 411, 0, 0),
(99, 'Swordsman Skeleton', 196, 0, 0),
(100, 'Archer Skeleton', 154, 0, 0),
(101, 'Skeleton Wheel', 134, 0, 0),
(102, 'Black Knight', 710, 0, 0),
(103, 'Prowling Demon', 2133, 0, 0),
(104, 'Giant Skeleton Archer', 262, 0, 0),
(105, 'Giant Skeleton', 286, 0, 0),
(106, 'Bone Tower', 291, 0, 0),
(107, 'Skeleton Beast', 446, 0, 0),
(108, 'Black Knight', 887, 0, 0),
(109, 'Pinwheel Servant', 506, 0, 0),
(110, 'Skeleton Baby', 36, 0, 0),
(111, 'Minor Capra Demon', 589, 0, 0),
(112, 'Minor Taurus Demon', 900, 0, 0),
(113, 'Burrowing Rockworm', 616, 0, 0),
(114, 'Demonic Statue', 196, 0, 0),
(115, 'Chaos Bug', 79, 0, 0),
(116, 'Hollow', 132, 0, 0),
(117, 'Engorged Zombie', 330, 0, 0),
(118, 'Crow Demon', 930, 0, 0),
(119, 'Snow Rat', 237, 0, 0),
(120, 'Phalanx', 335, 0, 0),
(121, 'Undead Dragon', 3956, 0, 0),
(122, 'Skeleton Wheel', 196, 0, 0),
(123, 'Heavy Knight', 686, 0, 0),
(124, 'Basilisk', 193, 0, 0),
(125, 'Mushroom Parent', 2483, 0, 0),
(126, 'Hydra', 3863, 0, 0),
(127, 'Man Eater Shell', 865, 0, 0),
(128, 'Egg Carrier', 128, 0, 0),
(129, 'Vile Maggot', 68, 0, 0),
(130, 'Mushroom Child', 662, 0, 0),
(131, 'Bounding Demon', 1407, 0, 0),
(132, 'Demonic Statue', 205, 0, 0),
(133, 'Chaos Eater', 650, 0, 0),
(134, 'Daughter of Chaos', 698, 0, 0),
(135, 'Prowling Demon', 3137, 0, 0),
(136, 'Chaos Bug', 79, 0, 0),
(137, 'Red-Eyed Chaos Bug', 79, 0, 0),
(138, 'Black Knight', 958, 0, 0),
(139, 'Lesser Sanctuary Guardian', 2030, 0, 0),
(140, 'Scarecrow', 320, 0, 0),
(141, 'Stone Guardian', 560, 0, 0),
(142, 'Undead Attack Dog', 210, 0, 0),
(143, 'Bloathead', 380, 0, 0),
(144, 'Bloathead Sorcerer', 300, 0, 0),
(145, 'Chained Prisoner', 1280, 0, 0),
(146, 'Small Humanity Phantom', 200, 0, 0),
(147, 'Medium Humanity Phantom', 400, 0, 0),
(148, 'Large Humanity Phantom', 700, 0, 0),
(149, 'Asylum Demon', 813, 1, 1),
(150, 'Bed of Chaos', 1, 1, 0),
(151, 'Black Dragon Kalameet', 5400, 1, 0),
(152, 'Capra Demon', 1176, 1, 0),
(153, 'Ceaseless Discharge', 4200, 1, 0),
(154, 'Centipede Demon', 3434, 1, 0),
(155, 'Chaos Witch Quelaag', 3139, 1, 0),
(156, 'Crossbreed Priscilla', 2300, 1, 0),
(157, 'Dark Sun Gwyndolin', 2011, 1, 0),
(158, 'Demon Firesage', 5448, 1, 0),
(159, 'Four Kings', 9504, 1, 0),
(160, 'Gaping Dragon', 4660, 1, 0),
(161, 'Gravelord Nito', 4317, 1, 0),
(162, 'Gwyn, Lord of Cinder', 4185, 1, 0),
(163, 'Iron Golem', 2880, 1, 0),
(164, 'Knight Artorias', 3750, 1, 0),
(165, 'Manus, Father of the Abyss', 6666, 1, 0),
(166, 'Moonlight Butterfly', 1506, 1, 0),
(167, 'Pinwheel', 1326, 1, 0),
(168, 'Sanctuary Guardian', 2560, 1, 0),
(169, 'Seath the Scaleless', 5525, 1, 0),
(170, 'Sif, the Great Grey Wolf', 3432, 1, 0),
(171, 'Stray Demon', 5250, 1, 0),
(172, 'Taurus Demon', 1215, 1, 0),
(173, 'Bell Gargoyles', 1000, 1, 1),
(174, 'Smough & Ornstein', 2645, 1, 0);

--
-- Déclencheurs `ENEMY`
--
DROP TRIGGER IF EXISTS `SUPPR_ENEMY`;
DELIMITER //
CREATE TRIGGER `SUPPR_ENEMY` BEFORE DELETE ON `ENEMY`
 FOR EACH ROW DELETE FROM IS_LOCATED WHERE OLD.ID=ID_ENEMY
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Structure de la table `IS_LOCATED`
--

CREATE TABLE IF NOT EXISTS `IS_LOCATED` (
  `ID_ENEMY` int(5) DEFAULT NULL,
  `ID_LOCATION` int(3) DEFAULT NULL,
  KEY `ID_ENEMY` (`ID_ENEMY`),
  KEY `ID_LOCATION` (`ID_LOCATION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `IS_LOCATED`
--

INSERT INTO `IS_LOCATED` (`ID_ENEMY`, `ID_LOCATION`) VALUES
(1, 1),
(2, 1),
(3, 2),
(4, 2),
(5, 2),
(6, 2),
(7, 2),
(3, 3),
(4, 3),
(8, 3),
(9, 3),
(10, 3),
(11, 3),
(12, 3),
(13, 4),
(14, 4),
(15, 4),
(16, 4),
(17, 4),
(18, 4),
(19, 4),
(20, 4),
(21, 5),
(22, 5),
(23, 5),
(24, 5),
(25, 5),
(26, 5),
(27, 5),
(28, 5),
(29, 5),
(30, 21),
(31, 21),
(32, 21),
(33, 21),
(34, 20),
(35, 20),
(36, 20),
(37, 20),
(38, 20),
(39, 20),
(40, 20),
(41, 20),
(42, 20),
(43, 20),
(44, 20),
(45, 20),
(46, 20),
(47, 20),
(48, 6),
(49, 6),
(50, 6),
(51, 6),
(52, 6),
(53, 6),
(54, 6),
(55, 6),
(13, 23),
(56, 23),
(57, 23),
(58, 23),
(59, 23),
(60, 22),
(61, 22),
(62, 10),
(63, 10),
(64, 10),
(65, 10),
(66, 10),
(67, 10),
(68, 10),
(69, 10),
(70, 10),
(71, 11),
(72, 11),
(73, 11),
(74, 11),
(75, 11),
(76, 11),
(77, 11),
(78, 11),
(79, 11),
(80, 11),
(81, 11),
(82, 11),
(83, 25),
(84, 25),
(85, 25),
(86, 25),
(87, 25),
(88, 25),
(89, 25),
(90, 25),
(91, 25),
(92, 25),
(93, 25),
(94, 25),
(95, 25),
(96, 26),
(97, 26),
(94, 26),
(95, 26),
(98, 27),
(99, 27),
(100, 27),
(101, 27),
(102, 27),
(103, 27),
(104, 28),
(105, 28),
(106, 28),
(107, 28),
(108, 28),
(109, 28),
(110, 28),
(111, 29),
(112, 29),
(113, 29),
(114, 29),
(115, 29),
(116, 12),
(117, 12),
(118, 12),
(119, 12),
(120, 12),
(121, 12),
(122, 12),
(123, 12),
(124, 9),
(124, 8),
(125, 9),
(125, 8),
(126, 9),
(127, 9),
(128, 7),
(129, 7),
(130, 8),
(131, 30),
(132, 30),
(133, 30),
(134, 30),
(135, 30),
(136, 30),
(137, 30),
(138, 32),
(139, 13),
(140, 15),
(141, 15),
(142, 15),
(143, 16),
(144, 16),
(145, 16),
(146, 19),
(147, 19),
(148, 19),
(143, 19),
(144, 19),
(149, 1),
(150, 30),
(151, 15),
(152, 3),
(153, 29),
(154, 29),
(155, 7),
(156, 12),
(157, 11),
(158, 29),
(159, 24),
(160, 5),
(161, 28),
(162, 32),
(163, 10),
(164, 15),
(165, 19),
(166, 20),
(167, 27),
(168, 13),
(169, 26),
(171, 1),
(170, 20),
(172, 3),
(173, 4),
(174, 11),
(173, 4),
(174, 11);

--
-- Déclencheurs `IS_LOCATED`
--
DROP TRIGGER IF EXISTS `AJ_BOSS`;
DELIMITER //
CREATE TRIGGER `AJ_BOSS` BEFORE INSERT ON `IS_LOCATED`
 FOR EACH ROW BEGIN
	IF ((SELECT BOSS FROM ENEMY WHERE ID=NEW.ID_ENEMY)=1) THEN
		UPDATE LOCATION L, IS_LOCATED SET BOSSES_NBR=(BOSSES_NBR+1) WHERE L.ID=NEW.ID_LOCATION;
        END IF;
END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `RET_BOSS`;
DELIMITER //
CREATE TRIGGER `RET_BOSS` BEFORE DELETE ON `IS_LOCATED`
 FOR EACH ROW BEGIN
	IF ((SELECT BOSS FROM ENEMY WHERE ID=OLD.ID_ENEMY)=1) THEN
		UPDATE LOCATION L, IS_LOCATED SET BOSSES_NBR=(BOSSES_NBR-1) WHERE L.ID=OLD.ID_LOCATION;
        END IF;
END
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Structure de la table `ITEM`
--

CREATE TABLE IF NOT EXISTS `ITEM` (
  `ID` int(5) NOT NULL DEFAULT '0',
  `NAME` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `TYPE` enum('RING','MIRACLE','SORCERY','PYROMANCY','SET','HELMET','CHEST','LEGGINGS','GAUNTLETS','MULTIPLAYER ITEM','CONSUMABLE','BONFIRE ITEM','AMMO','EMBER','ORE','KEY','CATALYST','TALISMAN','FLAME','SMALLSHIELD','NORMALSHIELD','LARGESHIELD','UNIQUESHIELD','OTHERSHIELD','BOSS','BOW','GREATBOW','CROSSBOW','DAGGER','STRAIGHTSWORD','CURVEDSWORD','KATANA','THRUSTINGSWORD','AXE','FISTWEAPON','HAMMER','SPEAR','HALBERD','WHIP','GREATSWORD','ULTRAGREATSWORD','CURVEDGREATSWORD','GREATAXE','GREATHAMMER') COLLATE utf8_unicode_ci NOT NULL,
  `DROP_AMOUNT` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_WEAPON` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `ITEM`
--

INSERT INTO `ITEM` (`ID`, `NAME`, `TYPE`, `DROP_AMOUNT`) VALUES
(1, 'Bloated Head', 'HELMET', 0),
(2, 'Bloated Sorcerer Head', 'HELMET', 0),
(3, 'Fang Boar Helm', 'HELMET', 0),
(4, 'Gargoyle Helm', 'HELMET', 0),
(5, 'Mask of the Child', 'HELMET', 0),
(6, 'Mask of the Father', 'HELMET', 0),
(7, 'Mask of the Mother', 'HELMET', 0),
(8, 'Royal Helm', 'HELMET', 0),
(9, 'Sack', 'HELMET', 0),
(10, 'Sunlight Maggot', 'HELMET', 0),
(11, 'Symbol of Avarice', 'HELMET', 0),
(12, 'Balder Helm', 'HELMET', 1),
(13, 'Big Hat', 'HELMET', 3),
(14, 'Black Iron Helm', 'HELMET', 3),
(15, 'Black Knight Helm', 'HELMET', 0),
(16, 'Black Sorcerer Hat', 'HELMET', 0),
(17, 'Brass Helm', 'HELMET', 0),
(18, 'Brigand Hood', 'HELMET', 0),
(19, 'Catarina Helm', 'HELMET', 0),
(20, 'Chain Helm', 'HELMET', 0),
(21, 'Cleric Helm', 'HELMET', 0),
(22, 'Crown of Dusk', 'HELMET', 0),
(23, 'Crown of the Dark Sun', 'HELMET', 0),
(24, 'Crown of the Great Lord', 'HELMET', 0),
(25, 'Crystalline Helm', 'HELMET', 0),
(26, 'Dark Mask', 'HELMET', 0),
(27, 'Dingy Hood', 'HELMET', 0),
(28, 'Eastern Helm', 'HELMET', 0),
(29, 'Elite Cleric Helm', 'HELMET', 0),
(30, 'Elite Knight Helm', 'HELMET', 0),
(31, 'Giant Helm', 'HELMET', 0),
(32, 'Gold-Hemmed Black Hood', 'HELMET', 0),
(33, 'Golem Helm', 'HELMET', 0),
(34, 'Gough`s Helm', 'HELMET', 0),
(35, 'Guardian Helm', 'HELMET', 0),
(36, 'Havel`s Helm', 'HELMET', 0),
(37, 'Helm of Artorias', 'HELMET', 0),
(38, 'Helm of Favor', 'HELMET', 0),
(39, 'Helm of The Wise', 'HELMET', 0),
(40, 'Helm of Thorns', 'HELMET', 0),
(41, 'Hollow Soldier Helm', 'HELMET', 0),
(42, 'Hollow Thief`s Hood', 'HELMET', 0),
(43, 'Hollow Warrior Helm', 'HELMET', 0),
(44, 'Iron Helm', 'HELMET', 0),
(45, 'Knight Helm', 'HELMET', 0),
(46, 'Mage Smith Hat', 'HELMET', 0),
(47, 'Maiden Hood', 'HELMET', 0),
(48, 'Mask of the Sealer', 'HELMET', 0),
(49, 'Mask of Velka', 'HELMET', 0),
(50, 'Ornstein`s Helm', 'HELMET', 0),
(51, 'Painting Guardian Hood', 'HELMET', 0),
(52, 'Paladin Helm', 'HELMET', 0),
(53, 'Pharis`s Hat', 'HELMET', 0),
(54, 'Porcelain Mask', 'HELMET', 0),
(55, 'Priest`s Hat', 'HELMET', 0),
(56, 'Shadow Mask', 'HELMET', 0),
(57, 'Silver Knight Helm', 'HELMET', 0),
(58, 'Six-Eyed Helm of the Channelers', 'HELMET', 0),
(59, 'Smough`s Helm', 'HELMET', 0),
(60, 'Snickering Top Hat', 'HELMET', 0),
(61, 'Sorcerer Hat', 'HELMET', 0),
(62, 'Standard Helm', 'HELMET', 0),
(63, 'Steel Helm', 'HELMET', 0),
(64, 'Stone Helm', 'HELMET', 0),
(65, 'Tattered Cloth Hood', 'HELMET', 0),
(66, 'Thief Mask', 'HELMET', 0),
(67, 'Wanderer Hood', 'HELMET', 0),
(68, 'Witch Hat', 'HELMET', 0),
(69, 'Xanthous Crown', 'HELMET', 0),
(70, 'Moonlight Robe', 'CHEST', 0),
(71, 'Mage Smith Coat', 'CHEST', 0),
(72, 'Maiden Robe', 'CHEST', 0),
(73, 'Lord`s Blade Robe', 'CHEST', 0),
(74, 'Leather Armor', 'CHEST', 0),
(75, 'Knight Armor', 'CHEST', 0),
(76, 'Holy Robe', 'CHEST', 0),
(77, 'Hollow Warrior Armor', 'CHEST', 0),
(78, 'Hollow Thief`s Leather Armor', 'CHEST', 0),
(79, 'Hollow Soldier Armor', 'CHEST', 0),
(80, 'Havel`s Armor', 'CHEST', 0),
(81, 'Hard Leather Armor', 'CHEST', 0),
(82, 'Guardian Armor', 'CHEST', 0),
(83, 'Gough`s Armor', 'CHEST', 0),
(84, 'Golem Armor', 'CHEST', 0),
(85, 'Gold-Hemmed Black Cloak', 'CHEST', 0),
(86, 'Giant Armor', 'CHEST', 0),
(87, 'Embraced Armor of Favor', 'CHEST', 0),
(88, 'Elite Knight Armor', 'CHEST', 0),
(89, 'Elite Cleric Armor', 'CHEST', 0),
(90, 'Eastern Armor', 'CHEST', 0),
(91, 'Dingy Robe', 'CHEST', 0),
(92, 'Dark Armor', 'CHEST', 0),
(93, 'Crystalline Armor', 'CHEST', 0),
(94, 'Crimson Robe', 'CHEST', 0),
(95, 'Cleric Armor', 'CHEST', 0),
(96, 'Chester`s Long Coat', 'CHEST', 0),
(97, 'Chain Armor', 'CHEST', 0),
(98, 'Catarina Armor', 'CHEST', 0),
(99, 'Brigand Armor', 'CHEST', 0),
(100, 'Brass Armor', 'CHEST', 0),
(101, 'Black Sorcerer Cloak', 'CHEST', 0),
(102, 'Black Leather Armor', 'CHEST', 0),
(103, 'Black Knight Armor', 'CHEST', 0),
(104, 'Black Iron Armor', 'CHEST', 0),
(105, 'Black Cleric Robe', 'CHEST', 0),
(106, 'Balder Armor', 'CHEST', 0),
(107, 'Armor of Thorns', 'CHEST', 0),
(108, 'Armor of the Sun', 'CHEST', 1),
(109, 'Armor of the Glorious', 'CHEST', 0),
(110, 'Armor of Artorias', 'CHEST', 1),
(111, 'Antiquated Dress', 'CHEST', 0),
(112, 'Ornstein`s Armor', 'CHEST', 0),
(113, 'Painting Guardian Robe', 'CHEST', 0),
(114, 'Paladin Armor', 'CHEST', 0),
(115, 'Robe of the Channelers', 'CHEST', 0),
(116, 'Robe of the Great Lord', 'CHEST', 0),
(117, 'Sage Robe', 'CHEST', 0),
(118, 'Shadow Garb', 'CHEST', 0),
(119, 'Silver Knight Armor', 'CHEST', 0),
(120, 'Smough`s Armor', 'CHEST', 0),
(121, 'Sorcerer Cloak', 'CHEST', 0),
(122, 'Steel Armor', 'CHEST', 0),
(123, 'Stone Armor', 'CHEST', 0),
(124, 'Tattered Cloth Robe', 'CHEST', 0),
(125, 'Wanderer Coat', 'CHEST', 0),
(126, 'Witch Cloak', 'CHEST', 0),
(127, 'Xanthous Overcoat', 'CHEST', 0),
(128, 'Ornstein`s Gauntlets', 'GAUNTLETS', 0),
(129, 'Moonlight Gloves', 'GAUNTLETS', 0),
(130, 'Maiden Gloves', 'GAUNTLETS', 0),
(131, 'Mage Smith Gauntlets', 'GAUNTLETS', 0),
(132, 'Lord`s Blade Gloves', 'GAUNTLETS', 0),
(133, 'Leather Gloves', 'GAUNTLETS', 0),
(134, 'Knight Gauntlets', 'GAUNTLETS', 0),
(135, 'Leather Gauntlets', 'GAUNTLETS', 0),
(136, 'Iron Bracelet', 'GAUNTLETS', 0),
(137, 'Havel`s Gauntlets', 'GAUNTLETS', 0),
(138, 'Hard Leather Gauntlets', 'GAUNTLETS', 0),
(139, 'Guardian Gauntlets', 'GAUNTLETS', 0),
(140, 'Gough`s Gauntlets', 'GAUNTLETS', 0),
(141, 'Golem Gauntlets', 'GAUNTLETS', 0),
(142, 'Gold-Hemmed Black Gloves', 'GAUNTLETS', 0),
(143, 'Giant Gauntlets', 'GAUNTLETS', 0),
(144, 'Gauntlets of Thorns', 'GAUNTLETS', 0),
(145, 'Gauntlets of the Vanquisher', 'GAUNTLETS', 0),
(146, 'Gauntlets of the Channelers', 'GAUNTLETS', 0),
(147, 'Gauntlets of Favor', 'GAUNTLETS', 0),
(148, 'Gauntlets of Artorias', 'GAUNTLETS', 0),
(149, 'Elite Knight Gauntlets', 'GAUNTLETS', 0),
(150, 'Elite Cleric Gauntlets', 'GAUNTLETS', 0),
(151, 'Eastern Gauntlets', 'GAUNTLETS', 0),
(152, 'Dingy Gloves', 'GAUNTLETS', 0),
(153, 'Dark Gauntlets', 'GAUNTLETS', 0),
(154, 'Crystalline Gauntlets', 'GAUNTLETS', 0),
(155, 'Crimson Gloves', 'GAUNTLETS', 0),
(156, 'Cleric Gauntlets', 'GAUNTLETS', 0),
(157, 'Chester`s Gloves', 'GAUNTLETS', 0),
(158, 'Catarina Gauntlets', 'GAUNTLETS', 0),
(159, 'Brigand Gauntlets', 'GAUNTLETS', 0),
(160, 'Brass Gauntlets', 'GAUNTLETS', 0),
(161, 'Bracelet of the Great Lord', 'GAUNTLETS', 0),
(162, 'Black Sorcerer Gauntlets', 'GAUNTLETS', 0),
(163, 'Black Manchette', 'GAUNTLETS', 0),
(164, 'Black Leather Gloves', 'GAUNTLETS', 0),
(165, 'Black Knight Gauntlets', 'GAUNTLETS', 0),
(166, 'Black Iron Gauntlets', 'GAUNTLETS', 0),
(167, 'Balder Gauntlets', 'GAUNTLETS', 0),
(168, 'Antiquated Gloves', 'GAUNTLETS', 0),
(169, 'Painting Guardian Gloves', 'GAUNTLETS', 0),
(170, 'Paladin Gauntlets', 'GAUNTLETS', 0),
(171, 'Shadow Gauntlets', 'GAUNTLETS', 0),
(172, 'Silver Knight Gauntlets', 'GAUNTLETS', 0),
(173, 'Smough`s Gauntlets', 'GAUNTLETS', 0),
(174, 'Sorcerer Gauntlets', 'GAUNTLETS', 0),
(175, 'Steel Gauntlets', 'GAUNTLETS', 0),
(176, 'Stone Gauntlets', 'GAUNTLETS', 0),
(177, 'Tattered Cloth Manchette', 'GAUNTLETS', 0),
(178, 'Traveling Gloves', 'GAUNTLETS', 0),
(179, 'Traveling Gloves', 'GAUNTLETS', 0),
(180, 'Wanderer Manchette', 'GAUNTLETS', 0),
(181, 'Witch Gloves', 'GAUNTLETS', 0),
(182, 'Xanthous Gloves', 'GAUNTLETS', 0),
(183, 'Sorcerer Boots', 'LEGGINGS', 0),
(184, 'Smough`s Leggings', 'LEGGINGS', 0),
(185, 'Silver Knight Leggings', 'LEGGINGS', 0),
(186, 'Shadow Leggings', 'LEGGINGS', 0),
(187, 'Paladin Leggings', 'LEGGINGS', 0),
(188, 'Painting Guardian Waistcloth', 'LEGGINGS', 0),
(189, 'Ornstein`s Leggings', 'LEGGINGS', 0),
(190, 'Moonlight Waistcloth', 'LEGGINGS', 0),
(191, 'Maiden Skirt', 'LEGGINGS', 0),
(192, 'Mage Smith Boots', 'LEGGINGS', 0),
(193, 'Lord`s Blade Waistcloth', 'LEGGINGS', 0),
(194, 'Leggings of Thorns', 'LEGGINGS', 0),
(195, 'Leggings of Favor', 'LEGGINGS', 0),
(196, 'Leather Boots', 'LEGGINGS', 0),
(197, 'Leggings of Artorias', 'LEGGINGS', 0),
(198, 'Knight Leggings', 'LEGGINGS', 0),
(199, 'Iron Leggings', 'LEGGINGS', 0),
(200, 'Holy Trousers', 'LEGGINGS', 0),
(201, 'Hollow Warrior Waistcloth', 'LEGGINGS', 0),
(202, 'Hollow Thief`s Tights', 'LEGGINGS', 0),
(203, 'Hollow Soldier Waistcloth', 'LEGGINGS', 0),
(204, 'Heavy Boots', 'LEGGINGS', 0),
(205, 'Havel`s Leggings', 'LEGGINGS', 0),
(206, 'Hard Leather Boots', 'LEGGINGS', 0),
(207, 'Guardian Leggings', 'LEGGINGS', 0),
(208, 'Golem Leggings', 'LEGGINGS', 0),
(209, 'Gough`s Leggings', 'LEGGINGS', 0),
(210, 'Gold-Hemmed Black Skirt', 'LEGGINGS', 0),
(211, 'Giant Leggings', 'LEGGINGS', 0),
(212, 'Elite Knight Leggings', 'LEGGINGS', 0),
(213, 'Elite Cleric Leggings', 'LEGGINGS', 0),
(214, 'Eastern Leggings', 'LEGGINGS', 0),
(215, 'Dark Leggings', 'LEGGINGS', 0),
(216, 'Crimson Waistcloth', 'LEGGINGS', 0),
(217, 'Crystalline Leggings', 'LEGGINGS', 0),
(218, 'Cleric Leggings', 'LEGGINGS', 0),
(219, 'Chester`s Trousers', 'LEGGINGS', 0),
(220, 'Chain Leggings', 'LEGGINGS', 0),
(221, 'Catarina Leggings', 'LEGGINGS', 0),
(222, 'Brigand Trousers', 'LEGGINGS', 0),
(223, 'Brass Leggings', 'LEGGINGS', 0),
(224, 'Boots of the Explorer', 'LEGGINGS', 0),
(225, 'Blood-Stained Skirt', 'LEGGINGS', 0),
(226, 'Black Tights', 'LEGGINGS', 0),
(227, 'Black Sorcerer Boots', 'LEGGINGS', 1),
(228, 'Black Leather Boots', 'LEGGINGS', 0),
(229, 'Black Knight Leggings', 'LEGGINGS', 0),
(230, 'Black Iron Leggings', 'LEGGINGS', 0),
(231, 'Balder Leggings', 'LEGGINGS', 0),
(232, 'Antiquated Skirt', 'LEGGINGS', 0),
(233, 'Anklet of the Great Lord', 'LEGGINGS', 1),
(234, 'Steel Leggings', 'LEGGINGS', 0),
(235, 'Stone Leggings', 'LEGGINGS', 0),
(236, 'Traveling Boots', 'LEGGINGS', 0),
(237, 'Waistcloth of the Channelers', 'LEGGINGS', 0),
(238, 'Wanderer Boots', 'LEGGINGS', 0),
(239, 'Witch Skirt', 'LEGGINGS', 0),
(240, 'Xanthous Waistcloth', 'LEGGINGS', 0),
(241, 'Bellowing Dragoncrest Ring', 'RING', 3),
(242, 'Bloodbite Ring', 'RING', 2),
(243, 'Blue Tearstone Ring', 'RING', 3),
(244, 'Calamity Ring', 'RING', 1),
(245, 'Cat Covenant Ring', 'RING', 0),
(246, 'Cloranthy Ring', 'RING', 0),
(247, 'Covenant Of Artorias', 'RING', 0),
(248, 'Covetous Gold Serpent Ring', 'RING', 0),
(249, 'Covetous Silver Serpent Ring', 'RING', 0),
(250, 'Cursebite Ring', 'RING', 0),
(251, 'Darkmoon Blade Covenant Ring', 'RING', 0),
(252, 'Darkmoon Seance Ring', 'RING', 0),
(253, 'Dark Wood Grain Ring', 'RING', 0),
(254, 'Dusk Crown Ring', 'RING', 0),
(255, 'East Wood Grain Ring', 'RING', 0),
(256, 'Flame Stoneplate Ring', 'RING', 0),
(257, 'Havel''s Ring', 'RING', 0),
(258, 'Hawk Ring', 'RING', 0),
(259, 'Hornet Ring', 'RING', 0),
(260, 'Leo Ring', 'RING', 0),
(261, 'Lingering Dragoncrest Ring', 'RING', 0),
(262, 'Old Witch''s Ring', 'RING', 0),
(263, 'Orange Charred Ring', 'RING', 1),
(264, 'Poisonbite Ring', 'RING', 0),
(265, 'Rare Ring of Sacrifice', 'RING', 0),
(266, 'Red Tearstone Ring', 'RING', 0),
(267, 'Ring of Favor and Protection', 'RING', 0),
(268, 'Ring of Fog', 'RING', 1),
(269, 'Ring of Sacrifice', 'RING', 0),
(270, 'Ring of Steel Protection', 'RING', 4),
(271, 'Ring of the Evil Eye', 'RING', 2),
(272, 'Ring of the Sun''s Firstborn', 'RING', 0),
(273, 'Ring of the Sun Princess', 'RING', 0),
(274, 'Rusted Iron Ring', 'RING', 0),
(275, 'Slumbering Dragoncrest Ring', 'RING', 0),
(276, 'Speckled Stoneplate Ring', 'RING', 0),
(277, 'Spell Stoneplate Ring', 'RING', 0),
(278, 'Thunder Stoneplate Ring', 'RING', 0),
(279, 'Tiny Being''s Ring', 'RING', 0),
(280, 'White Seance Ring', 'RING', 0),
(281, 'Wolf Ring', 'RING', 0),
(282, 'Black Separation Crystal', 'MULTIPLAYER ITEM', 0),
(283, 'Orange Guidance Soapstone', 'MULTIPLAYER ITEM', 0),
(284, 'Purple Coward''s Crystal', 'MULTIPLAYER ITEM', 0),
(285, 'Red Sign Soapstone', 'MULTIPLAYER ITEM', 0),
(286, 'White Sign Soapstone', 'MULTIPLAYER ITEM', 0),
(287, 'Black Eye Orb', 'MULTIPLAYER ITEM', 1),
(288, 'Blue Eye Orb', 'MULTIPLAYER ITEM', 1),
(289, 'Red Eye Orb', 'MULTIPLAYER ITEM', 0),
(290, 'Cracked Red Eye Orb', 'MULTIPLAYER ITEM', 0),
(291, 'Dragon Eye', 'MULTIPLAYER ITEM', 0),
(292, 'Dragon Head Stone', 'MULTIPLAYER ITEM', 0),
(293, 'Dragon Torso Stone', 'MULTIPLAYER ITEM', 0),
(294, 'Eye of Death', 'MULTIPLAYER ITEM', 0),
(295, 'Souvenir of Reprisal', 'MULTIPLAYER ITEM', 0),
(296, 'Sunlight Medal', 'MULTIPLAYER ITEM', 0),
(297, 'Hello Carving', 'MULTIPLAYER ITEM', 0),
(298, 'Very Good! Carving', 'MULTIPLAYER ITEM', 0),
(299, 'Thank You Carving', 'MULTIPLAYER ITEM', 0),
(300, 'I''m Sorry Carving', 'MULTIPLAYER ITEM', 0),
(301, 'Help Me! Carving', 'MULTIPLAYER ITEM', 0),
(302, 'Book of the Guilty', 'MULTIPLAYER ITEM', 0),
(303, 'Dried Finger', 'MULTIPLAYER ITEM', 0),
(304, 'Indictment', 'MULTIPLAYER ITEM', 0),
(305, 'Servant Roster', 'MULTIPLAYER ITEM', 0),
(306, 'Annex Key', 'KEY', 0),
(307, 'Archive Tower Cell Key', 'KEY', 3),
(308, 'Archive Tower Giant Cell Key', 'KEY', 0),
(309, 'Archive Tower Giant Door Key', 'KEY', 0),
(310, 'Archive Prison Extra Key', 'KEY', 0),
(311, 'Basement Key', 'KEY', 0),
(312, 'Big Pilgrim´s Key', 'KEY', 0),
(313, 'Blighttown Key', 'KEY', 0),
(314, 'Broken Pendant', 'KEY', 0),
(315, 'Cage Key', 'KEY', 0),
(316, 'Crest Key', 'KEY', 0),
(317, 'Crest of Artorias', 'KEY', 0),
(318, 'Dungeon Cell Key', 'KEY', 0),
(319, 'Key to New Londo Ruins', 'KEY', 0),
(320, 'Key to the Depths', 'KEY', 0),
(321, 'Key to the Seal', 'KEY', 0),
(322, 'Master Key', 'KEY', 0),
(323, 'Mystery Key', 'KEY', 0),
(324, 'Peculiar Doll', 'KEY', 0),
(325, 'Residence Key', 'KEY', 0),
(326, 'Undead Asylum F2 East Key', 'KEY', 0),
(327, 'Undead Asylum F2 West Key', 'KEY', 0),
(328, 'Sewer Chamber Key', 'KEY', 0),
(329, 'Watchtower Basement Key', 'KEY', 0),
(330, 'Armor Smithbox', 'BONFIRE ITEM', 0),
(331, 'Bottomless Box', 'BONFIRE ITEM', 0),
(332, 'Lordvessel', 'BONFIRE ITEM', 1),
(333, 'Repairbox', 'BONFIRE ITEM', 0),
(334, 'Rite of Kindling', 'BONFIRE ITEM', 0),
(335, 'Weapon Smithbox', 'BONFIRE ITEM', 0),
(336, 'Wooden Arrow', 'AMMO', 0),
(337, 'Standard Arrow', 'AMMO', 0),
(338, 'Large Arrow', 'AMMO', 0),
(339, 'Feather Arrow', 'AMMO', 0),
(340, 'Fire Arrow', 'AMMO', 0),
(341, 'Poison Arrow', 'AMMO', 0),
(342, 'Moonlight Arrow', 'AMMO', 0),
(343, 'Dragonslayer Arrow', 'AMMO', 0),
(344, 'Gough''s Great Arrow', 'AMMO', 0),
(345, 'Wood Bolt', 'AMMO', 0),
(346, 'Standard Bolt', 'AMMO', 0),
(347, 'Heavy Bolt', 'AMMO', 1),
(348, 'Lightning Bolt', 'AMMO', 0),
(349, 'Sniper Bolt', 'AMMO', 0),
(350, 'Estus Flask', 'CONSUMABLE', 0),
(351, 'Elizabeth''s Mushroom', 'CONSUMABLE', 0),
(352, 'Bloodred Moss Clump', 'CONSUMABLE', 0),
(353, 'Purple Moss Clump', 'CONSUMABLE', 0),
(354, 'Blooming Purple Moss Clump', 'CONSUMABLE', 0),
(355, 'Divine Blessing', 'CONSUMABLE', 0),
(356, 'Egg Vermifuge', 'CONSUMABLE', 0),
(357, 'Green Blossom', 'CONSUMABLE', 0),
(358, 'Purging Stone', 'CONSUMABLE', 0),
(359, 'Firebomb', 'CONSUMABLE', 0),
(360, 'Black Firebomb', 'CONSUMABLE', 0),
(361, 'Dung pie', 'CONSUMABLE', 0),
(362, 'Throwing Knife', 'CONSUMABLE', 0),
(363, 'Poison Throwing Knife', 'CONSUMABLE', 0),
(364, 'Charcoal Pine Resin', 'CONSUMABLE', 0),
(365, 'Gold Pine Resin', 'CONSUMABLE', 0),
(366, 'Rotten Pine Resin', 'CONSUMABLE', 0),
(367, 'Fire Keeper Soul', 'CONSUMABLE', 0),
(368, 'Soul of a Lost Undead', 'CONSUMABLE', 0),
(369, 'Large Soul of a Lost Undead', 'CONSUMABLE', 0),
(370, 'Soul of a Nameless Soldier', 'CONSUMABLE', 0),
(371, 'Large Soul of a Nameless Soldier', 'CONSUMABLE', 0),
(372, 'Soul of a Proud Knight', 'CONSUMABLE', 0),
(373, 'Large Soul of a Proud Knight', 'CONSUMABLE', 0),
(374, 'Soul of a Brave Warrior', 'CONSUMABLE', 0),
(375, 'Large Soul of a Brave Warrior', 'CONSUMABLE', 0),
(376, 'Soul of a Hero', 'CONSUMABLE', 0),
(377, 'Soul of a Great Hero', 'CONSUMABLE', 0),
(378, 'Soul of the Moonlight Butterfly', 'CONSUMABLE', 0),
(379, 'Soul of Quelaag', 'CONSUMABLE', 0),
(380, 'Core of an Iron Golem', 'CONSUMABLE', 0),
(381, 'Soul of Ornstein', 'CONSUMABLE', 0),
(382, 'Soul of Smough', 'CONSUMABLE', 0),
(383, 'Soul of Priscilla', 'CONSUMABLE', 0),
(384, 'Guardian Soul', 'CONSUMABLE', 0),
(385, 'Soul of Sif', 'CONSUMABLE', 0),
(386, 'Soul of Gwyndolin', 'CONSUMABLE', 0),
(387, 'Soul of Artorias', 'CONSUMABLE', 0),
(388, 'Soul of Manus', 'CONSUMABLE', 0),
(389, 'Soul of Gwyn, Lord of Cinder', 'CONSUMABLE', 0),
(390, 'Alluring Skull', 'CONSUMABLE', 0),
(391, 'Binoculars', 'CONSUMABLE', 1),
(392, 'Copper Coin', 'CONSUMABLE', 0),
(393, 'Darksign', 'CONSUMABLE', 0),
(394, 'Gold Coin', 'CONSUMABLE', 0),
(395, 'Humanity', 'CONSUMABLE', 0),
(396, 'Homeward Bone', 'CONSUMABLE', 0),
(397, 'Lloyd''s Talisman', 'CONSUMABLE', 0),
(398, 'Pendant', 'CONSUMABLE', 0),
(399, 'Prism Stone', 'CONSUMABLE', 0),
(400, 'Repair Powder', 'CONSUMABLE', 0),
(401, 'Rubbish', 'CONSUMABLE', 0),
(402, 'Silver Coin', 'CONSUMABLE', 0),
(403, 'Silver Pendant', 'CONSUMABLE', 0),
(404, 'Transient Curse', 'CONSUMABLE', 0),
(405, 'Twin Humanities', 'CONSUMABLE', 0),
(406, 'Acid Surge', 'PYROMANCY', 0),
(407, 'Black Flame', 'PYROMANCY', 0),
(408, 'Chaos Fire Whip', 'PYROMANCY', 1),
(409, 'Chaos Storm', 'PYROMANCY', 0),
(410, 'Combustion', 'PYROMANCY', 0),
(411, 'Fire Orb', 'PYROMANCY', 0),
(412, 'Fire Surge', 'PYROMANCY', 0),
(413, 'Fire Tempest', 'PYROMANCY', 0),
(414, 'Fire Whip', 'PYROMANCY', 0),
(415, 'Fireball', 'PYROMANCY', 0),
(416, 'Firestorm', 'PYROMANCY', 0),
(417, 'Flash Sweat', 'PYROMANCY', 0),
(418, 'Great Chaos Fireball', 'PYROMANCY', 0),
(419, 'Great Combustion', 'PYROMANCY', 0),
(420, 'Great Fireball', 'PYROMANCY', 0),
(421, 'Iron Flesh', 'PYROMANCY', 0),
(422, 'Poison Mist', 'PYROMANCY', 0),
(423, 'Power Within', 'PYROMANCY', 0),
(424, 'Toxic Mist', 'PYROMANCY', 0),
(425, 'Undead Rapport', 'PYROMANCY', 0),
(426, 'Aural Decoy', 'SORCERY', 0),
(427, 'Cast Light', 'SORCERY', 0),
(428, 'Chameleon', 'SORCERY', 0),
(429, 'Crystal Magic Weapon', 'SORCERY', 0),
(430, 'Crystal Soul Spear', 'SORCERY', 1),
(431, 'Dark Bead', 'SORCERY', 0),
(432, 'Dark Fog', 'SORCERY', 0),
(433, 'Dark Orb', 'SORCERY', 0),
(434, 'Fall Control', 'SORCERY', 0),
(435, 'Great Heavy Soul Arrow', 'SORCERY', 0),
(436, 'Great Magic Weapon', 'SORCERY', 0),
(437, 'Great Soul Arrow', 'SORCERY', 0),
(438, 'Heavy Soul Arrow', 'SORCERY', 0),
(439, 'Hidden Body', 'SORCERY', 0),
(440, 'Hidden Weapon', 'SORCERY', 0),
(441, 'Homing Crystal Soulmass', 'SORCERY', 0),
(442, 'Homing Soulmass', 'SORCERY', 0),
(443, 'Hush', 'SORCERY', 0),
(444, 'Magic Shield', 'SORCERY', 0),
(445, 'Magic Weapon', 'SORCERY', 0),
(446, 'Pursuers', 'SORCERY', 0),
(447, 'Remedy', 'SORCERY', 0),
(448, 'Repair', 'SORCERY', 0),
(449, 'Resist Curse', 'SORCERY', 0),
(450, 'Soul Arrow', 'SORCERY', 0),
(451, 'Soul Spear', 'SORCERY', 0),
(452, 'Strong Magic Shield', 'SORCERY', 0),
(453, 'White Dragon Breath', 'SORCERY', 0),
(454, 'Bountiful Sunlight', 'MIRACLE', 1),
(455, 'Darkmoon Blade', 'MIRACLE', 2),
(456, 'Emit Force', 'MIRACLE', 1),
(457, 'Force', 'MIRACLE', 0),
(458, 'Gravelord Greatsword Dance', 'MIRACLE', 1),
(459, 'Gravelord Sword Dance', 'MIRACLE', 0),
(460, 'Great Heal Excerpt', 'MIRACLE', 0),
(461, 'Great Heal', 'MIRACLE', 0),
(462, 'Great Lightning Spear', 'MIRACLE', 0),
(463, 'Great Magic Barrier', 'MIRACLE', 0),
(464, 'Heal', 'MIRACLE', 0),
(465, 'Homeward', 'MIRACLE', 0),
(466, 'Karmic Justice', 'MIRACLE', 0),
(467, 'Lightning Spear', 'MIRACLE', 0),
(468, 'Magic Barrier', 'MIRACLE', 0),
(469, 'Replenishment', 'MIRACLE', 0),
(470, 'Seek Guidance', 'MIRACLE', 0),
(471, 'Soothing Sunlight', 'MIRACLE', 0),
(472, 'Sunlight Blade', 'MIRACLE', 0),
(473, 'Sunlight Spear', 'MIRACLE', 0),
(474, 'Tranquil Walk of Peace', 'MIRACLE', 0),
(475, 'Vow of Silence', 'MIRACLE', 0),
(476, 'Wrath of the Gods', 'MIRACLE', 0),
(477, 'Fist', 'FISTWEAPON', 0),
(478, 'Caestus', 'FISTWEAPON', 0),
(479, 'Claw', 'FISTWEAPON', 0),
(480, 'Dark Hand', 'FISTWEAPON', 1),
(481, 'Dragon Bone Fist', 'FISTWEAPON', 0),
(482, 'Blacksmith Giant Hammer', 'HAMMER', 0),
(483, 'Blacksmith Hammer', 'HAMMER', 1),
(484, 'Club', 'HAMMER', 0),
(485, 'Hammer of Vamos', 'HAMMER', 0),
(486, 'Mace', 'HAMMER', 0),
(487, 'Morning Star', 'HAMMER', 0),
(488, 'Pickaxe', 'HAMMER', 0),
(489, 'Reinforced Club', 'HAMMER', 0),
(490, 'Warpick', 'HAMMER', 0),
(491, 'Demon''s Great Hammer', 'GREATHAMMER', 2),
(492, 'Dragon Tooth', 'GREATHAMMER', 0),
(493, 'Grant', 'GREATHAMMER', 0),
(494, 'Great Club', 'GREATHAMMER', 0),
(495, 'Large Club', 'GREATHAMMER', 0),
(496, 'Smough''s Hammer', 'GREATHAMMER', 0),
(497, 'Battle Axe', 'AXE', 0),
(498, 'Butcher Knife', 'AXE', 0),
(499, 'Crescent Axe', 'AXE', 1),
(500, 'Gargoyle Tail Axe', 'AXE', 0),
(501, 'Golem Axe', 'AXE', 0),
(502, 'Hand Axe', 'AXE', 0),
(503, 'Black Knight Greataxe', 'GREATAXE', 0),
(504, 'Demon''s Greataxe', 'GREATAXE', 3),
(505, 'Dragon King Greataxe', 'GREATAXE', 1),
(506, 'Greataxe', 'GREATAXE', 0),
(507, 'Stone Greataxe', 'GREATAXE', 0),
(508, 'Bandit''s Knife', 'DAGGER', 0),
(509, 'Dagger', 'DAGGER', 2),
(510, 'Dark Silver Tracer', 'DAGGER', 1),
(511, 'Ghost Blade', 'DAGGER', 0),
(512, 'Parrying Dagger', 'DAGGER', 1),
(513, 'Priscilla''s Dagger', 'DAGGER', 0),
(514, 'Estoc', 'THRUSTINGSWORD', 0),
(515, 'Mail Breaker', 'THRUSTINGSWORD', 0),
(516, 'Rapier', 'THRUSTINGSWORD', 1),
(517, 'Ricard''s Rapier', 'THRUSTINGSWORD', 0),
(518, 'Velka''s Rapier', 'THRUSTINGSWORD', 0),
(519, 'Astora''s Straight Sword', 'STRAIGHTSWORD', 0),
(520, 'Balder Side Sword', 'STRAIGHTSWORD', 1),
(521, 'Barbed Straight Sword', 'STRAIGHTSWORD', 0),
(522, 'Broad Sword', 'STRAIGHTSWORD', 0),
(523, 'Broken Straight Sword', 'STRAIGHTSWORD', 0),
(524, 'Crystal Straight Sword', 'STRAIGHTSWORD', 0),
(525, 'Dark Sword', 'STRAIGHTSWORD', 0),
(526, 'Drake Sword', 'STRAIGHTSWORD', 0),
(527, 'Longsword', 'STRAIGHTSWORD', 0),
(528, 'Shortsword', 'STRAIGHTSWORD', 0),
(529, 'Silver Knight Straight Sword', 'STRAIGHTSWORD', 0),
(530, 'Straight Sword Hilt', 'STRAIGHTSWORD', 0),
(531, 'Sunlight Straight Sword', 'STRAIGHTSWORD', 0),
(532, 'Abyss Greatsword', 'GREATSWORD', 0),
(533, 'Bastard Sword', 'GREATSWORD', 0),
(534, 'Black Knight Sword', 'GREATSWORD', 1),
(535, 'Claymore', 'GREATSWORD', 0),
(536, 'Crystal Greatsword', 'GREATSWORD', 0),
(537, 'Flamberge', 'GREATSWORD', 0),
(538, 'Great Lord Greatsword', 'GREATSWORD', 0),
(539, 'Greatsword of Artorias', 'GREATSWORD', 0),
(540, 'Cursed Greatsword of Artorias', 'GREATSWORD', 0),
(541, 'Man Serpent Greatsword', 'GREATSWORD', 0),
(542, 'Moonlight Greatsword', 'GREATSWORD', 0),
(543, 'Obsidian Greatsword', 'GREATSWORD', 0),
(544, 'Stone Greatsword', 'GREATSWORD', 0),
(545, 'Black Knight Greatsword', 'ULTRAGREATSWORD', 0),
(546, 'Demon Great Machete', 'ULTRAGREATSWORD', 0),
(547, 'Dragon Greatsword', 'ULTRAGREATSWORD', 1),
(548, 'Greatsword', 'ULTRAGREATSWORD', 0),
(549, 'Zweihander', 'ULTRAGREATSWORD', 0),
(550, 'Chaos Blade', 'KATANA', 0),
(551, 'Iaito', 'KATANA', 0),
(552, 'Uchigatana', 'KATANA', 1),
(553, 'Washing Pole', 'KATANA', 0),
(554, 'Falchion', 'CURVEDSWORD', 0),
(555, 'Gold Tracer', 'CURVEDSWORD', 0),
(556, 'Jagged Ghost Blade', 'CURVEDSWORD', 1),
(557, 'Painting Guardian Sword', 'CURVEDSWORD', 0),
(558, 'Quelaag''s Furysword', 'CURVEDSWORD', 0),
(559, 'Scimitar', 'CURVEDSWORD', 0),
(560, 'Shotel', 'CURVEDSWORD', 0),
(561, 'Gravelord Sword', 'CURVEDGREATSWORD', 1),
(562, 'Murakumo', 'CURVEDGREATSWORD', 1),
(563, 'Server', 'CURVEDGREATSWORD', 0),
(564, 'Channeler''s Trident', 'SPEAR', 0),
(565, 'Demon''s Spear', 'SPEAR', 2),
(566, 'Dragon Slayer Spear', 'SPEAR', 0),
(567, 'Four-Pronged Plow', 'SPEAR', 0),
(568, 'Moonlight Butterfly Horn', 'SPEAR', 0),
(569, 'Partizan', 'SPEAR', 0),
(570, 'Pike', 'SPEAR', 0),
(571, 'Silver Knight Spear', 'SPEAR', 0),
(572, 'Spear', 'SPEAR', 0),
(573, 'Winged Spear', 'SPEAR', 0),
(574, 'Black Knight Halberd', 'HALBERD', 0),
(575, 'Gargoyle''s Halberd', 'HALBERD', 0),
(576, 'Giant''s Halberd', 'HALBERD', 1),
(577, 'Great Scythe', 'HALBERD', 0),
(578, 'Halberd', 'HALBERD', 0),
(579, 'Lifehunt Scythe', 'HALBERD', 0),
(580, 'Lucerne', 'HALBERD', 0),
(581, 'Scythe', 'HALBERD', 0),
(582, 'Titanite Catch Pole', 'HALBERD', 0),
(583, 'Black Bow of Pharis', 'BOW', 0),
(584, 'Composite Bow', 'BOW', 3),
(585, 'Darkmoon Bow', 'BOW', 1),
(586, 'Long Bow', 'BOW', 0),
(587, 'Short Bow', 'BOW', 0),
(588, 'Avelyn', 'CROSSBOW', 0),
(589, 'Heavy Crossbow', 'CROSSBOW', 0),
(590, 'Light Crossbow', 'CROSSBOW', 2),
(591, 'Sniper Crossbow', 'CROSSBOW', 0),
(592, 'DragonSlayer Greatbow', 'GREATBOW', 1),
(593, 'Gough''s Greatbow', 'GREATBOW', 1),
(594, 'Guardian Tail', 'WHIP', 0),
(595, 'Notched Whip', 'WHIP', 0),
(596, 'Whip', 'WHIP', 1),
(597, 'Beatrice''s Catalyst', 'CATALYST', 0),
(598, 'Demon''s Catalyst', 'CATALYST', 1),
(599, 'Izalith Catalyst', 'CATALYST', 0),
(600, 'Logan''s Catalyst', 'CATALYST', 0),
(601, 'Manus Catalyst', 'CATALYST', 1),
(602, 'Oolacile Catalyst', 'CATALYST', 0),
(603, 'Oolacile Ivory Catalyst', 'CATALYST', 2),
(604, 'Sorcerer''s Catalyst', 'CATALYST', 0),
(605, 'Tin Banishment Catalyst', 'CATALYST', 0),
(606, 'Tin Crystallization Catalyst', 'CATALYST', 0),
(607, 'Tin Darkmoon Catalyst', 'CATALYST', 0),
(608, 'Canvas Talisman', 'TALISMAN', 2),
(609, 'Darkmoon Talisman', 'TALISMAN', 0),
(610, 'Ivory Talisman', 'TALISMAN', 0),
(611, 'Sunlight Talisman', 'TALISMAN', 0),
(612, 'Talisman', 'TALISMAN', 0),
(613, 'Thorolund Talisman', 'TALISMAN', 0),
(614, 'Velka''s Talisman', 'TALISMAN', 0),
(615, 'Ascended Pyromancy Flame', 'FLAME', 1),
(616, 'Pyromancy Flame', 'FLAME', 3),
(617, 'Large Ember', 'EMBER', 0),
(618, 'Very Large Ember', 'EMBER', 0),
(619, 'Divine Ember', 'EMBER', 0),
(620, 'Large Divine Ember', 'EMBER', 0),
(621, 'Dark Ember', 'EMBER', 0),
(622, 'Enchanted Ember', 'EMBER', 0),
(623, 'Large Magic Ember', 'EMBER', 0),
(624, 'Crystal Ember', 'EMBER', 1),
(625, 'Chaos Flame Ember', 'EMBER', 0),
(626, 'Large Flame Ember', 'EMBER', 0),
(627, 'Titanite Shard', 'ORE', 0),
(628, 'Large Titanite Shard', 'ORE', 0),
(629, 'Titanite Chunk', 'ORE', 0),
(630, 'Titanite Slab', 'ORE', 0),
(631, 'Green Titanite Shard', 'ORE', 0),
(632, 'Blue Titanite Chunk', 'ORE', 0),
(633, 'Blue Titanite Slab', 'ORE', 0),
(634, 'White Titanite Chunk', 'ORE', 0),
(635, 'White Titanite Slab', 'ORE', 0),
(636, 'Red Titanite Chunk', 'ORE', 0),
(637, 'Red Titanite Slab', 'ORE', 0),
(638, 'Twinkling Titanite', 'ORE', 0),
(639, 'Demon Titanite', 'ORE', 1),
(640, 'Dragon Scale', 'ORE', 0),
(641, 'Buckler', 'SMALLSHIELD', 0),
(642, 'Caduceus Round Shield', 'SMALLSHIELD', 1),
(643, 'Cracked Round Shield', 'SMALLSHIELD', 1),
(644, 'Effigy Shield', 'SMALLSHIELD', 2),
(645, 'Leather Shield', 'SMALLSHIELD', 2),
(646, 'Plank Shield', 'SMALLSHIELD', 0),
(647, 'Red and white round shield', 'SMALLSHIELD', 0),
(648, 'Small Leather Shield', 'SMALLSHIELD', 0),
(649, 'Target Shield', 'SMALLSHIELD', 0),
(650, 'Warrior''s Round Shield', 'SMALLSHIELD', 0),
(651, 'Balder Shield', 'NORMALSHIELD', 0),
(652, 'Black Knight Shield', 'NORMALSHIELD', 0),
(653, 'Bloodshield', 'NORMALSHIELD', 0),
(654, 'Caduceus Kite Shield', 'NORMALSHIELD', 0),
(655, 'Crest Shield', 'NORMALSHIELD', 1),
(656, 'Dragon Crest Shield', 'NORMALSHIELD', 0),
(657, 'East-West Shield', 'NORMALSHIELD', 0),
(658, 'Gargoyle''s Shield', 'NORMALSHIELD', 0),
(659, 'Grass Crest Shield', 'NORMALSHIELD', 0),
(660, 'Heater Shield', 'NORMALSHIELD', 0),
(661, 'Hollow Soldier Shield', 'NORMALSHIELD', 0),
(662, 'Iron Round Shield', 'NORMALSHIELD', 0),
(663, 'Knight Shield', 'NORMALSHIELD', 0),
(664, 'Large Leather Shield', 'NORMALSHIELD', 0),
(665, 'Sanctus', 'NORMALSHIELD', 0),
(666, 'Silver Knight Shield', 'NORMALSHIELD', 0),
(667, 'Spider Shield', 'NORMALSHIELD', 0),
(668, 'Sunlight Shield', 'NORMALSHIELD', 0),
(669, 'Tower Kite Shield', 'NORMALSHIELD', 0),
(670, 'Wooden Shield', 'NORMALSHIELD', 0),
(671, 'Black Iron Greatshield', 'LARGESHIELD', 1),
(672, 'Bonewheel Shield', 'LARGESHIELD', 0),
(673, 'Cleansing Greatshield', 'LARGESHIELD', 0),
(674, 'Eagle Shield', 'LARGESHIELD', 1),
(675, 'Giant Shield', 'LARGESHIELD', 0),
(676, 'Greatshield of Artorias', 'LARGESHIELD', 2),
(677, 'Havel''s Greatshield', 'LARGESHIELD', 0),
(678, 'Stone Greatshield', 'LARGESHIELD', 0),
(679, 'Tower Shield', 'LARGESHIELD', 0),
(680, 'Crystal Ring Shield', 'UNIQUESHIELD', 0),
(681, 'Crystal Shield', 'UNIQUESHIELD', 0),
(682, 'Spiked Shield', 'UNIQUESHIELD', 0),
(683, 'Pierce Shield', 'UNIQUESHIELD', 0),
(684, 'Dark Hand', 'OTHERSHIELD', 1);

-- --------------------------------------------------------

--
-- Structure de la table `LOCATION`
--

CREATE TABLE IF NOT EXISTS `LOCATION` (
  `ID` int(3) NOT NULL DEFAULT '0',
  `NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BOSSES_NBR` int(2) DEFAULT NULL,
  `DLC` tinyint(1) NOT NULL DEFAULT '0',
  `DEATH_AMOUNT` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_LOCATION` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `LOCATION`
--

INSERT INTO `LOCATION` (`ID`, `NAME`, `BOSSES_NBR`, `DLC`, `DEATH_AMOUNT`) VALUES
(1, 'Northern Undead Asylum', 2, 0, 12),
(2, 'Firelink Shrine', 0, 0, 14),
(3, 'Undead Burg', 2, 0, 1),
(4, 'Undead Parish', 1, 0, 3),
(5, 'The Depths', 1, 0, 2),
(6, 'Blighttown', 0, 0, 1),
(7, 'Quelaag''s Domain', 1, 0, 0),
(8, 'The Great Hollow', 0, 0, 0),
(9, 'Ash Lake', 0, 0, 0),
(10, 'Sen''s Fortress', 1, 0, 0),
(11, 'Anor Londo', 2, 0, 0),
(12, 'Painted World Of Ariamis', 1, 0, 0),
(13, 'Sanctuary Garden', 1, 1, 0),
(14, 'Oolacile Sanctuary', 0, 1, 0),
(15, 'Royal Wood', 2, 1, 0),
(16, 'Oolacile Township', 0, 1, 1),
(17, 'Battle of Stoicism', 0, 1, 0),
(18, 'Battle of Stoicism Gazebo', 0, 1, 0),
(19, 'Chasm of the Abyss', 1, 1, 1),
(20, 'Darkroot Garden', 2, 0, 0),
(21, 'Darkroot Basin', 0, 0, 0),
(22, 'Valley of Drakes', 0, 0, 0),
(23, 'New Londo Ruins', 0, 0, 0),
(24, 'The Abyss', 1, 0, 0),
(25, 'The Duke''s Archives', 0, 0, 0),
(26, 'Crystal Cave', 1, 0, 0),
(27, 'The Catacombs', 1, 0, 0),
(28, 'Tomb of the Giants', 1, 0, 0),
(29, 'Demon Ruins', 3, 0, 0),
(30, 'Lost Izalith', 1, 0, 0),
(31, 'Firelink Altar', 0, 0, 0),
(32, 'Kiln of the First Flame', 1, 0, 0);

--
-- Déclencheurs `LOCATION`
--
DROP TRIGGER IF EXISTS `SUPPR_LOCATION`;
DELIMITER //
CREATE TRIGGER `SUPPR_LOCATION` BEFORE DELETE ON `LOCATION`
 FOR EACH ROW DELETE FROM IS_LOCATED WHERE OLD.ID=ID_LOCATION
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Doublure de structure pour la vue `LOCATION_DEATHS`
--
CREATE TABLE IF NOT EXISTS `LOCATION_DEATHS` (
`ID` int(11)
,`NAME` varchar(50)
,`BOSSES_NBR` int(11)
,`DLC` tinyint(4)
,`DEATH_AMOUNT` int(11)
,`TOTAL` decimal(33,0)
);
-- --------------------------------------------------------

--
-- Structure de la table `SHIELD`
--

CREATE TABLE IF NOT EXISTS `SHIELD` (
  `ID_ITEM` int(5) DEFAULT NULL,
  `DURABILITY` int(4) DEFAULT NULL,
  `WEIGHT` float DEFAULT NULL,
  `NORMAL_REDUCTION` float DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `SHIELD`
--

INSERT INTO `SHIELD` (`ID_ITEM`, `DURABILITY`, `WEIGHT`, `NORMAL_REDUCTION`) VALUES
(641, 140, 1.5, 75),
(642, 180, 1, 85),
(643, 60, 1, 65),
(644, 180, 3, 90),
(645, 200, 1, 85),
(646, 120, 1.5, 75),
(647, 180, 1, 85),
(648, 200, 0.5, 80),
(649, 150, 2, 78),
(650, 180, 1, 85),
(651, 220, 4, 100),
(652, 250, 6, 100),
(653, 240, 3, 100),
(654, 250, 3, 100),
(655, 300, 3, 100),
(656, 300, 3, 100),
(657, 160, 1, 88),
(658, 300, 4, 85),
(659, 200, 3, 95),
(660, 250, 2, 100),
(661, 250, 3.5, 100),
(662, 280, 5, 100),
(663, 200, 5.5, 100),
(664, 200, 1.5, 91),
(665, 410, 3, 95),
(666, 250, 5, 100),
(667, 230, 3, 100),
(668, 280, 4, 100),
(669, 250, 3, 100),
(670, 160, 1.5, 93),
(671, 230, 16, 100),
(672, 200, 12, 90),
(673, 300, 14.5, 80),
(674, 300, 6, 95),
(675, 300, 18, 100),
(676, 600, 16, 100),
(677, 500, 26, 100),
(678, 400, 20, 100),
(679, 300, 13, 100),
(680, 120, 3, 70),
(681, 250, 5, 100),
(682, 160, 3, 90),
(683, 180, 3.5, 95),
(684, 999, 0.5, 80);

--
-- Déclencheurs `SHIELD`
--
DROP TRIGGER IF EXISTS `SUPPR_SHIELD`;
DELIMITER //
CREATE TRIGGER `SUPPR_SHIELD` BEFORE DELETE ON `SHIELD`
 FOR EACH ROW DELETE FROM ITEM WHERE ID=OLD.ID_ITEM
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Structure de la table `WEAPON`
--

CREATE TABLE IF NOT EXISTS `WEAPON` (
  `ID_ITEM` int(5) NOT NULL,
  `DURABILITY` int(4) DEFAULT NULL,
  `WEIGHT` float DEFAULT NULL,
  `NORMAL_DAMAGES` int(4) DEFAULT NULL,
  KEY `ID_ITEM` (`ID_ITEM`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `WEAPON`
--

INSERT INTO `WEAPON` (`ID_ITEM`, `DURABILITY`, `WEIGHT`, `NORMAL_DAMAGES`) VALUES
(477, 5, 0, 20),
(478, 300, 0.5, 66),
(479, 150, 1, 72),
(480, 999, 0.5, 200),
(481, 999, 8, 90),
(482, 250, 6, 120),
(483, 250, 5, 87),
(484, 250, 3, 87),
(485, 250, 5, 115),
(486, 250, 4, 91),
(487, 200, 4, 83),
(488, 250, 4, 89),
(489, 100, 4, 97),
(490, 220, 3.5, 91),
(491, 600, 22, 138),
(492, 999, 18, 290),
(493, 600, 24, 130),
(494, 250, 12, 135),
(495, 250, 11, 120),
(496, 600, 28, 300),
(497, 250, 4, 95),
(498, 250, 10, 90),
(499, 180, 7, 115),
(500, 150, 5, 93),
(501, 600, 16, 170),
(502, 250, 2, 80),
(503, 300, 16, 229),
(504, 600, 22, 114),
(505, 400, 24, 380),
(506, 230, 14, 140),
(507, 700, 24, 190),
(508, 200, 1, 56),
(509, 200, 0.5, 56),
(510, 120, 1, 75),
(511, 100, 0.5, 110),
(512, 200, 0.5, 54),
(513, 100, 1, 80),
(514, 150, 3, 75),
(515, 200, 0.5, 57),
(516, 150, 1.5, 73),
(517, 100, 2, 70),
(518, 130, 2, 62),
(519, 160, 3, 80),
(520, 120, 3, 80),
(521, 160, 3, 80),
(522, 200, 3, 82),
(523, 200, 2, 40),
(524, 60, 6, 150),
(525, 200, 6, 82),
(526, 360, 6, 200),
(527, 200, 3, 80),
(528, 200, 2, 78),
(529, 300, 6, 175),
(530, 200, 1, 20),
(531, 240, 4, 82),
(532, 300, 9, 160),
(533, 200, 6, 105),
(534, 300, 8, 220),
(535, 200, 6, 103),
(536, 60, 8, 190),
(537, 160, 6, 100),
(538, 400, 8, 256),
(539, 400, 10, 120),
(540, 400, 10, 178),
(541, 300, 10, 110),
(542, 300, 6, 0),
(543, 350, 8, 320),
(544, 800, 18, 148),
(545, 300, 14, 220),
(546, 600, 18, 133),
(547, 400, 24, 390),
(548, 200, 12, 130),
(549, 200, 10, 130),
(550, 120, 6, 144),
(551, 80, 5, 88),
(552, 80, 5, 90),
(553, 60, 8, 90),
(554, 160, 2.5, 82),
(555, 240, 2, 130),
(556, 100, 1.5, 155),
(557, 100, 1.5, 76),
(558, 600, 3.5, 60),
(559, 160, 1.5, 80),
(560, 120, 2.5, 82),
(561, 600, 10, 265),
(562, 180, 12, 113),
(563, 140, 10, 107),
(564, 240, 6, 70),
(565, 400, 4, 100),
(566, 300, 10, 95),
(567, 300, 5.5, 75),
(568, 160, 4, 0),
(569, 160, 4.5, 80),
(570, 180, 10, 86),
(571, 300, 6, 163),
(572, 180, 3.5, 80),
(573, 140, 4.5, 86),
(574, 300, 14, 245),
(575, 200, 6, 115),
(576, 300, 16, 140),
(577, 130, 5, 100),
(578, 200, 6, 110),
(579, 100, 6, 180),
(580, 200, 5.5, 110),
(581, 130, 5, 110),
(582, 600, 6, 125),
(583, 100, 1, 34),
(584, 100, 1, 55),
(585, 400, 1, 85),
(586, 100, 1, 36),
(587, 100, 0.5, 31),
(588, 150, 6, 38),
(589, 150, 5, 55),
(590, 150, 3, 50),
(591, 150, 8, 52),
(592, 100, 10, 90),
(593, 100, 13, 85),
(594, 250, 5, 84),
(595, 200, 2, 76),
(596, 200, 1.5, 80),
(597, 90, 2, 40),
(598, 300, 4, 110),
(599, 300, 2, 40),
(600, 90, 2, 46),
(601, 200, 5, 190),
(602, 55, 2, 40),
(603, 30, 0.5, 24),
(604, 90, 2, 40),
(605, 160, 3, 145),
(606, 90, 2.5, 240),
(607, 60, 1, 44),
(608, 50, 0.3, 14),
(609, 50, 0.3, 14),
(610, 50, 0.3, 14),
(611, 50, 0.3, 14),
(612, 50, 0.3, 14),
(613, 50, 0.3, 14),
(614, 50, 0.3, 14),
(615, 30, 0, 0),
(616, 30, 0, 0);

--
-- Déclencheurs `WEAPON`
--
DROP TRIGGER IF EXISTS `SUPPR_WEAPON`;
DELIMITER //
CREATE TRIGGER `SUPPR_WEAPON` BEFORE DELETE ON `WEAPON`
 FOR EACH ROW DELETE FROM ITEM WHERE ID=OLD.ID_ITEM
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Structure de la vue `LOCATION_DEATHS`
--
DROP TABLE IF EXISTS `LOCATION_DEATHS`;

CREATE ALGORITHM=UNDEFINED DEFINER=`u842844217_admin`@`localhost` SQL SECURITY DEFINER VIEW `LOCATION_DEATHS` AS select distinct `L`.`ID` AS `ID`,`L`.`NAME` AS `NAME`,`L`.`BOSSES_NBR` AS `BOSSES_NBR`,`L`.`DLC` AS `DLC`,`L`.`DEATH_AMOUNT` AS `DEATH_AMOUNT`,((select sum(`E2`.`DEATH_AMOUNT`) from ((`LOCATION` `L2` join `ENEMY` `E2`) join `IS_LOCATED` `I2`) where ((`L2`.`ID` = `I2`.`ID_LOCATION`) and (`I2`.`ID_ENEMY` = `E2`.`ID`) and (`L2`.`ID` = `L`.`ID`))) + `L`.`DEATH_AMOUNT`) AS `TOTAL` from ((`LOCATION` `L` join `IS_LOCATED`) join `ENEMY` `E`) where ((`L`.`ID` = `IS_LOCATED`.`ID_LOCATION`) and (`IS_LOCATED`.`ID_ENEMY` = `E`.`ID`)) union select distinct `L`.`ID` AS `ID`,`L`.`NAME` AS `NAME`,`L`.`BOSSES_NBR` AS `BOSSES_NBR`,`L`.`DLC` AS `DLC`,`L`.`DEATH_AMOUNT` AS `DEATH_AMOUNT`,`L`.`DEATH_AMOUNT` AS `TOTAL` from ((`LOCATION` `L` join `IS_LOCATED`) join `ENEMY` `E`) where (not(`L`.`ID` in (select `L1`.`ID` from ((`LOCATION` `L1` join `ENEMY` `E1`) join `IS_LOCATED` `I1`) where ((`L1`.`ID` = `I1`.`ID_LOCATION`) and (`E1`.`ID` = `I1`.`ID_ENEMY`)))));

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;