createslayer.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: 61.78.53.167    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'Slayer'
--

CREATE TABLE Slayer (
  Race enum('SLAYER','VAMPIRE') NOT NULL default 'SLAYER',
  Name char(10) NOT NULL default '',
  PlayerID char(10) NOT NULL default '',
  Slot enum('SLOT1','SLOT2','SLOT3') NOT NULL default 'SLOT1',
  ServerGroupID tinyint(3) unsigned NOT NULL default '0',
  Active enum('ACTIVE','INACTIVE') NOT NULL default 'ACTIVE',
  Competence tinyint(3) unsigned NOT NULL default '3',
  Sex enum('MALE','FEMALE') default NULL,
  HairStyle enum('HAIR_STYLE1','HAIR_STYLE2','HAIR_STYLE3') default NULL,
  HairColor smallint(6) NOT NULL default '400',
  SkinColor smallint(6) NOT NULL default '410',
  Phone char(7) NOT NULL default '',
  STR tinyint(3) unsigned NOT NULL default '0',
  STRExp int(10) unsigned NOT NULL default '0',
  STRGoalExp int(10) unsigned NOT NULL default '10',
  DEX tinyint(3) unsigned NOT NULL default '0',
  DEXExp int(10) unsigned NOT NULL default '0',
  DEXGoalExp int(10) unsigned NOT NULL default '10',
  INTE tinyint(3) unsigned NOT NULL default '0',
  INTExp int(10) unsigned NOT NULL default '0',
  INTGoalExp int(10) unsigned NOT NULL default '10',
  HP smallint(5) unsigned NOT NULL default '0',
  CurrentHP smallint(5) unsigned NOT NULL default '0',
  MP smallint(5) unsigned NOT NULL default '0',
  CurrentMP smallint(5) unsigned NOT NULL default '0',
  Fame int(10) unsigned NOT NULL default '0',
  Notoriety int(10) unsigned NOT NULL default '0',
  Gold int(10) unsigned NOT NULL default '2000',
  GuildID int(10) unsigned NOT NULL default '99',
  InMagics char(128) NOT NULL default '',
  BladeLevel tinyint(3) unsigned NOT NULL default '0',
  BladeExp int(10) unsigned NOT NULL default '0',
  BladeGoalExp int(10) unsigned NOT NULL default '50',
  SwordLevel tinyint(3) unsigned NOT NULL default '0',
  SwordExp int(10) unsigned NOT NULL default '1',
  SwordGoalExp int(10) unsigned NOT NULL default '50',
  GunLevel tinyint(3) unsigned NOT NULL default '0',
  GunExp int(10) unsigned NOT NULL default '0',
  GunGoalExp int(10) unsigned NOT NULL default '40',
  EnchantLevel tinyint(3) unsigned NOT NULL default '0',
  EnchantExp int(10) unsigned NOT NULL default '0',
  EnchantGoalExp int(10) unsigned NOT NULL default '30',
  HealLevel tinyint(3) unsigned NOT NULL default '0',
  HealExp int(10) unsigned NOT NULL default '0',
  HealGoalExp int(10) unsigned NOT NULL default '30',
  ETCLevel tinyint(3) unsigned NOT NULL default '0',
  ETCExp int(10) unsigned NOT NULL default '0',
  ETCGoalExp int(10) unsigned NOT NULL default '1000000',
  Rank smallint(5) unsigned NOT NULL default '0',
  RankExp int(10) unsigned NOT NULL default '0',
  RankGoalExp int(10) unsigned NOT NULL default '0',
  ZoneID smallint(5) unsigned NOT NULL default '0',
  XCoord tinyint(3) unsigned NOT NULL default '0',
  YCoord tinyint(3) unsigned NOT NULL default '0',
  Sight tinyint(3) unsigned NOT NULL default '0',
  GunBonusExp tinyint(3) unsigned NOT NULL default '0',
  RifleBonusExp tinyint(3) unsigned NOT NULL default '0',
  Alignment int(10) NOT NULL default '7500',
  F9 smallint(6) NOT NULL default '-1',
  F10 smallint(6) NOT NULL default '-1',
  F11 smallint(6) NOT NULL default '-1',
  F12 smallint(6) NOT NULL default '-1',
  StashGold int(10) unsigned NOT NULL default '0',
  StashNum tinyint(3) unsigned NOT NULL default '0',
  ResurrectZone int(10) unsigned NOT NULL default '0',
  Shape int(10) unsigned NOT NULL default '0',
  HelmetColor smallint(5) unsigned NOT NULL default '0',
  JacketColor smallint(5) unsigned NOT NULL default '0',
  PantsColor smallint(5) unsigned NOT NULL default '0',
  WeaponColor smallint(5) unsigned NOT NULL default '0',
  ShieldColor smallint(5) unsigned NOT NULL default '0',
  CompetenceShape tinyint(3) unsigned NOT NULL default '1',
  Reward tinyint(3) default '0',
  creation_date date default NULL,
  status int(11) NOT NULL default '0',
  KEY Slayer_m1 (Name),
  KEY Slayer_m2 (GuildID),
  KEY Slayer_m3 (status)
) TYPE=MyISAM;

--
-- Dumping data for table 'Slayer'
--