createplayer.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 'Player'
--

CREATE TABLE Player (
  PlayerID varchar(10) NOT NULL default '',
  Password varchar(16) NOT NULL default '',
  Name varchar(20) NOT NULL default '',
  Sex enum('MALE','FEMALE') default NULL,
  SSN varchar(20) NOT NULL default '',
  Telephone varchar(15) default NULL,
  Cellular varchar(15) default NULL,
  ZipCode varchar(7) default NULL,
  Address varchar(100) default NULL,
  Nation tinyint(3) unsigned default NULL,
  Email varchar(50) default NULL,
  Homepage varchar(50) default NULL,
  Profile varchar(255) default NULL,
  Pub enum('PRIVATE','PUBLIC') NOT NULL default 'PRIVATE',
  CurrentWorldID tinyint(3) unsigned NOT NULL default '1',
  CurrentServerGroupID tinyint(3) unsigned NOT NULL default '0',
  LogOn enum('LOGOFF','LOGON','GAME') NOT NULL default 'LOGOFF',
  Access enum('ALLOW','DENY') NOT NULL default 'ALLOW',
  SpecialEventCount int(10) unsigned NOT NULL default '0',
  Number int(11) NOT NULL default '0',
  IYear int(10) unsigned NOT NULL default '0',
  IMonth int(10) unsigned NOT NULL default '0',
  IDay int(10) unsigned NOT NULL default '0',
  Event varchar(5) NOT NULL default '',
  LoginIP varchar(15) default '255.255.255.255',
  LastSlot tinyint(1) default '0',
  creation_date date default NULL,
  CurrentLoginServerID tinyint(3) unsigned NOT NULL default '0',
  PayType tinyint(1) unsigned NOT NULL default '1',
  PayPlayDate datetime NOT NULL default '2002-07-15 00:00:00',
  PayPlayHours int(10) unsigned NOT NULL default '0',
  PayPlayFlag int(10) unsigned NOT NULL default '0',
  LastLoginDate date NOT NULL default '2002-07-01',
  LastLogoutDate datetime NOT NULL default '0000-00-00 00:00:00',
  BillingUserKey int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (PlayerID),
  KEY IDX_Player_PlayerID_Password (PlayerID,Password),
  KEY IDX_Player_Number (Number),
  KEY IDX_CurrentServerGroupID (CurrentServerGroupID),
  KEY IDX_CurrentWorldID (CurrentWorldID),
  KEY IDX_LogOn (LogOn),
  KEY IDX_SSN (SSN),
  KEY Player_m10 (Access)
) TYPE=MyISAM;

--
-- Dumping data for table 'Player'
--