rendered paste body/*
MySQL Backup
Source Host: localhost
Source Server Version: 3.23.47-nt
Source Database: l2jdb
Date: 2005.09.03 19:43:10
*/
use l2jdb;
#----------------------------
# Table structure for armor
#----------------------------
create table armor (
item_id int(11) not null default '0',
name varchar(70),
bodypart varchar(15) not null,
crystallizable varchar(5) not null,
armor_type varchar(5) not null,
weight int(5) not null default '0',
material varchar(15) not null,
crystal_type varchar(4) not null,
avoid_modify int(1) not null default '0',
durability int(3) not null default '0',
p_def int(3) not null default '0',
m_def int(2) not null default '0',
mp_bonus int(3) not null default '0',
price int(11) not null default '0',
crystal_count int(4),
sellable varchar(5),
primary key (item_id))
type=MyISAM comment="";
#----------------------------
# Records for table armor
#----------------------------
insert into armor values
(21, 'Shirt', 'chest', 'false', 'light', 4830, 'cloth', 'none', 0, 90, 36, 0, 0, 147, 0, 'true'),
(22, 'Leather Shirt', 'chest', 'false', 'light', 4830, 'leather', 'none', 0, 90, 43, 0, 0, 2430, 0, 'true'),
(23, 'Wooden Breastplate', 'chest', 'false', 'light', 4820, 'wood', 'none', 0, 90, 47, 0, 0, 7960, 0, 'true'),
(24, 'Bone Breastplate', 'chest', 'false', 'light', 4770, 'bone', 'none', 0, 85, 50, 0, 0, 20300, 0, 'true'),
(25, 'Piece Bone Breastplate', 'chest', 'false', 'heavy', 8970, 'bone', 'none', 0, 85, 62, 0, 0, 31800, 0, 'true'),
(26, 'Bronze Breastplate', 'chest', 'false', 'heavy', 8920, 'bronze', 'none', 0, 90, 68, 0, 0, 49200, 0, 'true'),
(27, 'Hard Leather Shirt', 'chest', 'false', 'light', 4720, 'leather', 'none', 0, 90, 53, 0, 0, 36900, 0, 'true'),
(28, 'Pants', 'legs', 'false', 'light', 1740, 'cloth', 'none', 0, 90, 22, 0, 0, 92, 0, 'true'),
(29, 'Leather Pants', 'legs', 'false', 'light', 1730, 'leather', 'none', 0, 90, 27, 0, 0, 1520, 0, 'true'),
(30, 'Hard Leather Pants', 'legs', 'false', 'light', 1700, 'leather', 'none', 0, 90, 29, 0, 0, 4970, 0, 'true'),
(31, 'Bone Gaiters', 'legs', 'false', 'light', 1680, 'bone', 'none', 0, 85, 32, 0, 0, 12700, 0, 'true'),
(32, 'Piece Bone Gaiters', 'legs', 'false', 'heavy', 4020, 'bone', 'none', 0, 85, 39, 0, 0, 19900, 0, 'true'),
(33, 'Hard Leather Gaiters', 'legs', 'false', 'light', 1610, 'leather', 'none', 0, 90, 33, 0, 0, 23000, 0, 'true'),
(34, 'Bronze Gaiters', 'legs', 'false', 'heavy', 3960, 'bronze', 'none', 0, 90, 43, 0, 0, 30700, 0, 'true'),
(35, 'Cloth Shoes', 'feet', 'false', 'none', 1320, 'cloth', 'none', 0, 90, 9, 0, 0, 37, 0, 'true'),
(36, 'Leather Sandals', 'feet', 'false', 'none', 1320, 'leather', 'none', 0, 90, 9, 0, 0, 37, 0, 'true'),
(37, 'Leather Shoes', 'feet', 'false', 'none', 1320, 'leather', 'none', 0, 90, 13, 0, 0, 2650, 0, 'true'),
(38, 'Low Boots', 'feet', 'false', 'none', 1320, 'leather', 'none', 0, 90, 15, 0, 0, 6770, 0, 'true'),
(39, 'Boots', 'feet', 'false', 'none', 1310, 'cloth', 'none', 0, 90, 17, 0, 0, 12300, 0, 'true'),
(40, 'Leather Boots', 'feet', 'true', 'none', 1300, 'leather', 'd', 0, 90, 19, 0, 0, 20900, 38, 'true'),
(41, 'Cloth Cap', 'head', 'false', 'none', 660, 'cloth', 'none', 0, 90, 13, 0, 0, 55, 0, 'true'),
(42, 'Leather Cap', 'head', 'false', 'none', 660, 'leather', 'none', 0, 90, 16, 0, 0, 911, 0, 'true'),
(43, 'Wooden Helmet', 'head', 'false', 'none', 660, 'wood', 'none', 0, 90, 19, 0, 0, 3980, 0, 'true'),
(44, 'Leather Helmet', 'head', 'false', 'none', 650, 'leather', 'none', 0, 90, 23, 0, 0, 10200, 0, 'true'),
(45, 'Bone Helmet', 'head', 'true', 'none', 640, 'bone', 'd', 0, 90, 29, 0, 0, 31300, 56, 'true'),
(46, 'Bronze Helmet', 'head', 'true', 'none', 630, 'bronze', 'd', 0, 90, 33, 0, 0, 50000, 90, 'true'),
(47, 'Helmet', 'head', 'true', 'none', 640, 'fine_steel', 'd', 0, 90, 37, 0, 0, 76200, 138, 'true'),
(48, 'Short Gloves', 'gloves', 'false', 'none', 660, 'cloth', 'none', 0, 90, 9, 0, 0, 37, 0, 'true'),
(49, 'Gloves', 'gloves', 'false', 'none', 660, 'cloth', 'none', 0, 90, 13, 0, 0, 2650, 0, 'true'),
(50, 'Leather Gloves', 'gloves', 'false', 'none', 650, 'leather', 'none', 0, 90, 15, 0, 0, 6770, 0, 'true'),
(51, 'Bracer', 'gloves', 'false', 'none', 650, 'leather', 'none', 0, 90, 17, 0, 0, 12300, 0, 'true'),
(52, 'Hemp Cloak', 'back', 'false', 'none', 260, 'cloth', 'none', 0, 90, 2, 0, 0, 37, 0, 'true'),
(53, 'Cotton Cloak', 'back', 'false', 'none', 250, 'cloth', 'none', 0, 90, 3, 0, 0, 607, 0, 'true'),
(54, 'Silk Cloak', 'back', 'false', 'none', 250, 'cloth', 'none', 0, 90, 4, 0, 0, 2650, 0, 'true'),
(55, 'Cotton Undergarment', 'underwear', 'false', 'none', 170, 'cotton', 'none', 0, 90, 4, 0, 0, 18, 0, 'true'),
(56, 'Wool Undergarment', 'underwear', 'false', 'none', 170, 'wood', 'none', 0, 90, 5, 0, 0, 304, 0, 'true'),
(58, 'Mithril Breastplate', 'chest', 'true', 'heavy', 8670, 'mithril', 'd', 0, 95, 95, 0, 0, 183000, 332, 'true'),
(59, 'Mithril Gaiters', 'legs', 'true', 'heavy', 3830, 'mithril', 'd', 0, 95, 61, 0, 0, 127000, 230, 'true'),
(60, 'Composite Armor', 'CHEST', 'true', 'heavy', 10980, 'fine_steel', 'c', 0, 90, 224, 0, 0, 1440000, 576, 'true'),
(61, 'Mithril Gloves', 'gloves', 'true', 'none', 630, 'mithril', 'd', 0, 90, 29, 0, 0, 97800, 177, 'true'),
(62, 'Mithril Boots', 'feet', 'true', 'none', 1230, 'leather', 'c', 0, 90, 32, 0, 0, 45900, 83, 'true'),
(63, 'Gauntlets', 'gloves', 'true', 'none', 640, 'cloth', 'd', 0, 90, 24, 0, 0, 50800, 92, 'true'),
(64, 'Composite Boots', 'feet', 'true', 'none', 1220, 'fine_steel', 'c', 0, 90, 36, 0, 0, 245000, 98, 'true'),
(112, 'Apprentice`s Earring', 'rear,lear', 'false', 'none', 150, 'silver', 'none', 0, 95, 0, 11, 0, 49, 0, 'true'),
(113, 'Mystic`s Earring', 'rear,lear', 'false', 'none', 150, 'silver', 'none', 0, 95, 0, 13, 0, 811, 0, 'true'),
(114, 'Earring of Strength', 'rear,lear', 'false', 'none', 150, 'gold', 'none', 0, 95, 0, 16, 0, 3510, 0, 'true'),
(115, 'Earring of Wisdom', 'rear,lear', 'false', 'none', 150, 'gold', 'none', 0, 95, 0, 16, 0, 3510, 0, 'true'),
(116, 'Magic Ring', 'rfinger,lfinger', 'false', 'none', 150, 'gold', 'none', 0, 95, 0, 7, 0, 33, 0, 'true'),
(117, 'Ring of Mana', 'rfinger,lfinger', 'true', 'none', 150, 'silver', 'b', 0, 95, 0, 34, 0, 404000, 53, 'true'),
(118, 'Necklace of Magic', 'neck', 'false', 'none', 150, 'silver', 'none', 0, 95, 0, 15, 0, 66, 0, 'true'),
(119, 'Sage`s Necklace', 'neck', 'true', 'none', 150, 'adamantaite', 'c', 0, 95, 0, 64, 0, 565000, 226, 'true'),
(347, 'Ring Mail Breastplate', 'chest', 'true', 'heavy', 8820, 'steel', 'd', 0, 90, 77, 0, 0, 83500, 151, 'true'),
(348, 'Scale Mail', 'chest', 'true', 'heavy', 8720, 'steel', 'd', 0, 90, 87, 0, 0, 133000, 241, 'true'),
(349, 'Compound Scale Mail', 'chest', 'true', 'heavy', 8620, 'fine_steel', 'd', 0, 98, 95, 0, 0, 183000, 332, 'true'),
(350, 'Dwarven Scale Mail', 'chest', 'true', 'heavy', 8540, 'fine_steel', 'd', 0, 98, 95, 0, 0, 183000, 332, 'true'),
(351, 'Blast Plate', 'chest', 'true', 'heavy', 8420, 'fine_steel', 'd', 0, 90, 97, 0, 0, 203000, 369, 'true'),
(352, 'Brigandine Armor', 'chest', 'true', 'heavy', 8320, 'fine_steel', 'd', 0, 90, 108, 0, 0, 299000, 543, 'true'),
(353, 'Half Plate Armor', 'chest', 'true', 'heavy', 8220, 'fine_steel', 'd', 0, 90, 111, 0, 0, 391000, 710, 'true'),
(354, 'Chain Mail Shirt', 'chest', 'true', 'heavy'
<.....>
('12760', 'undead_merc_cleric_move', 'a_royal_guardA_MHuman', '7.00', '24.00', '75', 'male', 'L2Monster', '40', '16667', '5000', '40', '21', '30', '20', '43', '10', '0', '0', '1000', '1667', '1000', '1429', '253', '0', '253', '0', '0', '0', '80', '120', null, null, 0),
('12761', 'undead_merc_wizard_move', 'a_royal_guardA_MHuman', '7.00', '24.00', '75', 'male', 'L2Monster', '40', '16667', '5000', '40', '21', '30', '20', '43', '10', '0', '0', '1000', '1667', '1000', '1429', '253', '0', '253', '0', '0', '0', '80', '120', null, null, 0),
('12762', 'dawn_hero_sword_move', 'a_guard_MHuman', '8.00', '24.00', '75', 'male', 'L2Monster', '40', '16667', '5000', '40', '21', '30', '20', '43', '10', '0', '0', '1000', '1667', '1000', '1429', '253', '0', '253', '0', '0', '0', '80', '120', null, null, 0),
('12763', 'dawn_hero_wizard_move', 'a_royal_guardA_MHuman', '7.00', '24.00', '75', 'male', 'L2Monster', '40', '16667', '5000', '40', '21', '30', '20', '43', '10', '0', '0', '1000', '1667', '1000', '1429', '253', '0', '253', '0', '0', '0', '80', '120', null, null, 0);
#----------------------------
# Table structure for npcskills
#----------------------------
create table npcskills (
npcid int(11) not null default '0',
skillid int(11) not null default '0',
level int(11) not null default '0',
primary key (npcid, skillid, level))
type=MyISAM comment="";
#----------------------------
# Records for table npcskills
#----------------------------
insert into npcskills values
(2, 4058, 1),
(4, 4005, 1),
(5, 4005, 1),
(7, 4006, 1),
(7, 4059, 1),
(13, 4006, 1),
(15, 4002, 1),
(15, 4007, 1),
(16, 4001, 1),
(16, 4003, 1),
(18, 4006, 1),
(18, 4059, 1),
(19, 4006, 1),
(20, 4002, 1),
(20, 4007, 1),
(21, 4058, 1),
(22, 4004, 1),
(22, 4007, 1),
(23, 4058, 1),
(24, 4007, 1),
(25, 4007, 1),
(26, 4002, 1),
(26, 4007, 1),
(28, 4057, 1),
(29, 4002, 1),
(29, 4007, 1),
(31, 4060, 1),
(32, 4008, 1),
(32, 4057, 1),
(33, 4007, 1),
(34, 4008, 1),
(34, 4057, 1),
(35, 4004, 1),
(35, 4007, 1),
(36, 4015, 1),
(36, 4038, 1),
(37, 4039, 1),
(38, 4008, 1),
(38, 4035, 1),
(