Untitled

-- MySQL dump 9.11
--
-- Host: localhost    Database: l2jdb
-- ------------------------------------------------------
-- Server version	4.0.23-nt

--
-- Table structure for table `npc`
--

DROP TABLE IF EXISTS npc;
CREATE TABLE npc (
  id decimal(11,0) NOT NULL default '0',
  name varchar(40) default NULL,
  class varchar(40) default NULL,
  collision_radius decimal(5,2) default NULL,
  collision_height decimal(5,2) default NULL,
  level decimal(2,0) default NULL,
  sex varchar(6) default NULL,
  type varchar(20) default NULL,
  attackrange decimal(3,0) default NULL,
  hp decimal(7,0) default NULL,
  mp decimal(4,0) default NULL,
  exp decimal(6,0) default NULL,
  sp decimal(6,0) default NULL,
  patk decimal(5,0) default NULL,
  pdef decimal(3,0) default NULL,
  matk decimal(5,0) default NULL,
  mdef decimal(3,0) default NULL,
  atkspd decimal(3,0) default NULL,
  aggro decimal(6,0) default NULL,
  matkspd decimal(3,0) default NULL,
  rhand decimal(4,0) default NULL,
  lhand decimal(3,0) default NULL,
  armor decimal(1,0) default NULL,
  walkspd decimal(3,0) default NULL,
  runspd decimal(3,0) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `npc`
--

INSERT INTO `npc` VALUES (1,'Gremlin','gremlin',10.00,15.00,1,'male','L2Monster',40,64,70,29,2,4,41,3,32,253,0,253,0,0,0,20,