Code:
/*
MySQL Backup
Source Host: localhost
Source Server Version: 4.1.16-nt
Source Database: l2jdb
Date: 2005.12.17 03:38:26
*/
SET FOREIGN_KEY_CHECKS=0;
use l2jdb;
#----------------------------
# Table structure for accounts
#----------------------------
CREATE TABLE `accounts` (
`login` varchar(45) NOT NULL default '',
`password` varchar(45) default NULL,
`lastactive` decimal(20,0) default NULL,
`access_level` decimal(11,0) default NULL,
`lastIP` varchar(20) default NULL,
PRIMARY KEY (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table accounts
#----------------------------
insert into accounts values
('killerboy', 'sZZfbAz/M/+F9I02SbsQRUFdmGg=', '1134786564703', '0', '192.168.0.135');
#----------------------------
# Table structure for armor
#----------------------------
CREATE TABLE `armor` (
`item_id` int(11) NOT NULL default '0',
`name` varchar(70) default NULL,
`bodypart` varchar(15) NOT NULL default '',
`crystallizable` varchar(5) NOT NULL default '',
`armor_type` varchar(5) NOT NULL default '',
`weight` int(5) NOT NULL default '0',
`material` varchar(15) NOT NULL default '',
`crystal_type` varchar(4) NOT NULL default '',
`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) default NULL,
`sellable` varchar(5) default NULL,
PRIMARY KEY (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#----------------------------
# 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'),