character[v1].sql.svn-base

絲路server源碼 Silk Road server source

------------------------
Edited by hitomi2
------------------------

CREATE TABLE `characters` (
  `CharID` int(5) NOT NULL auto_increment,
  `UserID` int(4) NOT NULL default '0',
  `GM` int(1) NOT NULL default '0',
  `CharName` varchar(25) NOT NULL default '',
  `Race` int(1) NOT NULL default '0',
  `CharType` int(6) NOT NULL default '0',
  `Volume` int(3) NOT NULL default '0',
  `Level` int(3) NOT NULL default '0',
  `HighestLvl` int(3) NOT NULL default '0',
  `Experience` varchar(16) NOT NULL default '0000000000000000',
  `Strength` int(4) NOT NULL default '0',
  `Intelligence` int(4) NOT NULL default '0',
  `SP` int(6) NOT NULL default '0',
  `HP` int(6) NOT NULL default '0',
  `MP` int(6) NOT NULL default '0',
  `MinPhyAtk` int(4) NOT NULL default '0',
  `MaxPhyAtk` int(4) NOT NULL default '0',
  `MinMagAtk` int(4) NOT NULL default '0',
  `MaxMagAtk` int(4) NOT NULL default '0',
  `PhyDef` int(4) NOT NULL default '0',
  `MagDef` int(4) NOT NULL default '0',
  `HitRatio` int(6) NOT NULL default '0',
  `ParryRatio` int(6) NOT NULL default '0',
  `XSection` int(6) NOT NULL default '0',
  `YSection` int(6) NOT NULL default '0',
  `XPos` double NOT NULL default '0',
  `YPos` double NOT NULL default '0',
  `Gold` varchar(16) NOT NULL default '0000000000000000',
  `BerserkBar` int(8) NOT NULL default '0',
  `AccountID` varchar(8) NOT NULL default '',
  `WalkSpeed` int(8) NOT NULL default '0',
  `RunSpeed` int(8) NOT NULL default '0',
  `BerserkSpeed` int(8) NOT NULL default '0',
  `AttributePoints` int(8) NOT NULL default '0',
  `Unknown2` varchar(8) NOT NULL default '',
  `NumSkills` int(3) NOT NULL default '0',
  `SkillsLvl1` varchar(8) NOT NULL default '00000000',
  `SkillsLvl2` varchar(8) NOT NULL default '00000000',
  `SkillsLvl3` varchar(8) NOT NULL default '00000000',
  `SkillsLvl4` varchar(8) NOT NULL default '00000000',
  `SkillsLvl5` varchar(8) NOT NULL default '00000000',
  `SkillsLvl6` varchar(8) NOT NULL default '00000000',
  `SkillsLvl7` varchar(8) NOT NULL default '00000000',
  `Mastery1` int(3) NOT NULL default '0',
  `Mastery2` int(3) NOT NULL default '0',
  `Mastery3` int(3) NOT NULL default '0',
  `Mastery4` int(3) NOT NULL default '0',
  `Mastery5` int(3) NOT NULL default '0',
  `Mastery6` int(3) NOT NULL default '0',
  `Mastery7` int(3) NOT NULL default '0',
  `MaxSlots` int(3) NOT NULL default '0',
  `Items` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`CharID`),
  KEY `UserID` (`UserID`)
) TYPE=MyISAM AUTO_INCREMENT=26 ;