createousters.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: localhost    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.53-log

--
-- Table structure for table 'Ousters'
--

DROP TABLE IF EXISTS Ousters;

CREATE TABLE Ousters (
  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')		default NULL,
  Sex				enum('MALE','FEMALE')			NOT NULL default 'MALE',
  STR				smallint(5) unsigned			NOT NULL default '15',
  DEX				smallint(5) unsigned			NOT NULL default '15',
  INTE				smallint(5) unsigned			NOT NULL default '15',
  HP				smallint(5) unsigned			NOT NULL default '100',
  CurrentHP			smallint(5) unsigned			NOT NULL default '100',
  MP				smallint(5) unsigned			NOT NULL default '100',
  CurrentMP			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 '125',
  ExpOffset			int(10) unsigned				NOT NULL default '0',
  Level				tinyint(3) unsigned				NOT NULL default '1',
  Bonus				smallint(5) unsigned			NOT NULL default '0',
  SkillBonus		smallint(5) 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',
  Gold				int(10) unsigned				default '0',
  GuildID			int(10) unsigned				NOT NULL default '66',
  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 '13',
  Alignment			int(10)							NOT NULL default '7500',
  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',
  CoatType			tinyint(3) unsigned				NOT NULL default '0',
  ArmType			tinyint(3) unsigned				NOT NULL default '0',
  CoatColor			smallint(5) unsigned			NOT NULL default '0',
  HairColor			smallint(5) unsigned			NOT NULL default '400',
  ArmColor			smallint(5) unsigned			NOT NULL default '0',
  BootsColor		smallint(5) unsigned			NOT NULL default '0',
  CompetenceShape	tinyint(3) unsigned				NOT NULL default '1',

  PRIMARY KEY  (Name),
  KEY IDX_Ousters1 (PlayerID),
  KEY IDX_Ousters2 (Slot),
  KEY Ousters_m1 (GuildID)
) TYPE=HEAP;