-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 01, 2005 at 01:11 AM
-- Server version: 4.0.18
-- PHP Version: 4.3.4
-- 
-- Database: `l2jdata`
-- 

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

-- 
-- Table structure for table `npc_info`
-- 

CREATE TABLE npc_info (
  objectID int(11) NOT NULL default '0',
  npcID int(11) NOT NULL default '0',
  attackable int(11) default NULL,
  x int(11) default NULL,
  y int(11) default NULL,
  z int(11) default NULL,
  heading int(11) default NULL,
  unknown1 int(11) default NULL,
  magicalAttack int(11) default NULL,
  physicalAttack int(11) default NULL,
  runSpeed int(11) default NULL,
  walkSpeed int(11) default NULL,
  swimRunSpeed int(11) default NULL,
  swimWalkSpeed int(11) default NULL,
  flRunSpeed int(11) default NULL,
  flWalkSpeed int(11) default NULL,
  flyRunSpeed int(11) default NULL,
  flyWalkSpeed int(11) default NULL,
  movementMultiplier decimal(16,15) default NULL,
  attackSpeedMultiplier decimal(16,15) default NULL,
  collisionHeight decimal(16,15) default NULL,
  collisionRadius decimal(16,15) default NULL,
  rightHandItem int(11) default NULL,
  unknown2 int(11) default NULL,
  leftHandItem int(11) default NULL,
  nameVisible int(11) default NULL,
  isRunning int(11) default NULL,
  isInCombat int(11) default NULL,
  isDead int(11) default NULL,
  isSummoned int(11) default NULL,
  name varchar(20) default NULL,
  title varchar(20) default NULL,
  unknown3 int(11) default NULL,
  unknown4 int(11) default NULL,
  unknown5 int(11) default NULL,
  unknown6 int(11) default NULL,
  unknown7 int(11) default NULL,
  unknown8 int(11) default NULL,
  unknown9 int(11) default NULL,
  unknown10 int(11) default NULL,
  unknown11 int(11) default NULL,
  PRIMARY KEY  (objectID,npcID)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `npchtmlmessage`
-- 

CREATE TABLE npchtmlmessage (
  MessageID int(11) NOT NULL default '0',
  Html text NOT NULL,
  PRIMARY KEY  (Html(200)),
  FULLTEXT KEY Html (Html)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `status_update`
-- 

CREATE TABLE status_update (
  objectID int(11) NOT NULL default '0',
  LEVEL int(11) default NULL,
  EXP int(11) default NULL,
  STR int(11) default NULL,
  DEX int(11) default NULL,
  CON int(11) default NULL,
  _INT int(11) default NULL,
  WIT int(11) default NULL,
  MEN int(11) default NULL,
  CUR_HP int(11) default NULL,
  MAX_HP int(11) default NULL,
  CUR_MP int(11) default NULL,
  MAX_MP int(11) default NULL,
  SP int(11) default NULL,
  CUR_LOAD int(11) default NULL,
  MAX_LOAD int(11) default NULL,
  P_ATK int(11) default NULL,
  ATK_SPD int(11) default NULL,
  P_DEF int(11) default NULL,
  EVASION int(11) default NULL,
  ACCURACY int(11) default NULL,
  CRITICAL int(11) default NULL,
  M_ATK int(11) default NULL,
  CAST_SPD int(11) default NULL,
  M_DEF int(11) default NULL,
  PVP_FLAG int(11) default NULL,
  KARMA int(11) default NULL,
  PRIMARY KEY  (objectID)
) TYPE=MyISAM;