createvampire.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 'Vampire'
--

CREATE TABLE Vampire (
  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',
  Sex enum('MALE','FEMALE') NOT NULL default 'MALE',
  HairColor smallint(5) unsigned NOT NULL default '400',
  SkinColor smallint(5) unsigned NOT NULL default '410',
  STR smallint(5) unsigned NOT NULL default '20',
  DEX smallint(5) unsigned NOT NULL default '20',
  INTE smallint(5) unsigned NOT NULL default '20',
  HP smallint(5) unsigned NOT NULL default '100',
  CurrentHP smallint(5) unsigned NOT NULL default '100',
  Fame int(10) unsigned NOT NULL default '0',
  Notoriety int(10) unsigned NOT NULL default '0',
  Exp int(10) unsigned NOT NULL default '0',
  GoalExp int(10) unsigned NOT NULL default '250',
  ExpOffset int(10) unsigned NOT NULL default '0',
  Level tinyint(3) unsigned NOT NULL default '1',
  Bonus tinyint(3) unsigned NOT NULL default '0',
  Rank smallint(5) unsigned NOT NULL default '0',
  RankExp int(10) unsigned NOT NULL default '0',
  RankGoalExp int(10) unsigned NOT NULL default '0',
  InMagics char(128) default NULL,
  Gold int(10) unsigned default '0',
  GuildID 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',
  Alignment int(10) NOT NULL default '7500',
  F5 smallint(6) NOT NULL default '-1',
  F6 smallint(6) NOT NULL default '-1',
  F7 smallint(6) NOT NULL default '-1',
  F8 smallint(6) NOT NULL default '-1',
  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',
  Competence tinyint(3) unsigned NOT NULL default '3',
  ResurrectZone int(10) unsigned NOT NULL default '0',
  SilverDamage int(10) unsigned NOT NULL default '0',
  Shape int(10) unsigned NOT NULL default '0',
  CoatColor smallint(5) unsigned NOT NULL default '0',
  CompetenceShape tinyint(3) unsigned NOT NULL default '1',
  RedistributeAttr tinyint(3) unsigned NOT NULL default '0',
  Reward tinyint(3) default '0',
  status int(11) NOT NULL default '0',
  KEY Vampire_m1 (Name),
  KEY Vampire_m2 (GuildID),
  KEY Vampire_m3 (status)
) TYPE=MyISAM;

--
-- Dumping data for table 'Vampire'
--