login_db.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'AcT'
--

DROP TABLE IF EXISTS AcT;
CREATE TABLE AcT (
  Date date NOT NULL default '0000-00-00',
  PlayerID char(10) NOT NULL default '',
  SSN char(20) NOT NULL default '',
  cnt bigint(21) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table 'ClientVersion'
--

DROP TABLE IF EXISTS ClientVersion;
CREATE TABLE ClientVersion (
  Version int(10) unsigned NOT NULL default '0',
  GuildMarkVersion int(10) unsigned NOT NULL default '0',
  LastGuildMarkVersion int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table 'GameServerGroupInfo'
--

DROP TABLE IF EXISTS GameServerGroupInfo;
CREATE TABLE GameServerGroupInfo (
  GroupID int(10) unsigned NOT NULL default '0',
  WorldID int(10) unsigned NOT NULL default '0',
  GroupName char(20) NOT NULL default '',
  Stat tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table 'GameServerInfo'
--

DROP TABLE IF EXISTS GameServerInfo;
CREATE TABLE GameServerInfo (
  ServerID int(10) unsigned NOT NULL default '0',
  Nickname varchar(20) NOT NULL default '',
  IP varchar(15) NOT NULL default '',
  TCPPort int(10) unsigned NOT NULL default '0',
  UDPPort int(10) unsigned NOT NULL default '0',
  WorldID int(10) unsigned NOT NULL default '0',
  GroupID int(10) unsigned NOT NULL default '0',
  Stat tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (Nickname)
) TYPE=MyISAM;

--
-- Table structure for table 'GoodsListInfo'
--

DROP TABLE IF EXISTS GoodsListInfo;
CREATE TABLE GoodsListInfo (
  GoodsID int(10) unsigned NOT NULL auto_increment,
  Name varchar(30) NOT NULL default '',
  Description text NOT NULL,
  Pay enum('FREE','PAY') NOT NULL default 'FREE',
  Limited enum('LIMITED','UNLIMITED') NOT NULL default 'LIMITED',
  Hour int(10) unsigned NOT NULL default '0',
  Race enum('SLAYER','VAMPIRE','OUSTERS','COMMON') NOT NULL default 'COMMON',
  Sex enum('MALE','FEMALE','COMMON') NOT NULL default 'COMMON',
  Kind enum('ITEM','ARMOR','WEAPON','ACCESSORY','UNIQUE','SET','RICECAKE','DYE','FIRECRACKER','ETC','RARE') NOT NULL default 'ITEM',
  ItemClass smallint(10) NOT NULL default '0',
  ItemType tinyint(3) unsigned NOT NULL default '0',
  OptionType varchar(10) NOT NULL default '',
  Num tinyint(3) unsigned NOT NULL default '1',
  Img varchar(30) NOT NULL default '',
  ShowWeb tinyint(3) NOT NULL default '1',
  Recom tinyint(3) NOT NULL default '0',
  HotCount int(10) unsigned NOT NULL default '0',
  RegistDate datetime NOT NULL default '2003-05-05 00:00:00',
  Price int(10) unsigned NOT NULL default '0',
  GroupItem tinyint(3) NOT NULL default '0',
  NewGoods tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (GoodsID)
) TYPE=MyISAM;

--
-- Table structure for table 'GoodsListObject'
--

DROP TABLE IF EXISTS GoodsListObject;
CREATE TABLE GoodsListObject (
  BuyID varchar(16) NOT NULL default '',
  ID bigint(20) unsigned NOT NULL auto_increment,
  World tinyint(3) unsigned NOT NULL default '0',
  PlayerID varchar(10) NOT NULL default '',
  Name varchar(10) NOT NULL default '',
  GoodsID int(10) unsigned NOT NULL default '0',
  Num tinyint(3) unsigned NOT NULL default '0',
  Status enum('NOT','GET') NOT NULL default 'NOT',
  PRIMARY KEY  (ID),
  KEY IDX_BuyID (BuyID),
  KEY IDX_PlayerID (PlayerID),
  KEY IDX_Name (Name)
) TYPE=MyISAM;

--
-- Table structure for table 'GroupListInfo'
--

DROP TABLE IF EXISTS GroupListInfo;
CREATE TABLE GroupListInfo (
  GroupID int(10) unsigned NOT NULL default '0',
  Num tinyint(3) unsigned NOT NULL default '0',
  G1 int(10) unsigned NOT NULL default '0',
  G2 int(10) unsigned NOT NULL default '0',
  G3 int(10) unsigned NOT NULL default '0',
  G4 int(10) unsigned NOT NULL default '0',
  G5 int(10) unsigned NOT NULL default '0',
  G6 int(10) unsigned NOT NULL default '0',
  G7 int(10) unsigned NOT NULL default '0',
  G8 int(10) unsigned NOT NULL default '0',
  G9 int(10) unsigned NOT NULL default '0',
  G10 int(10) unsigned NOT NULL default '0',
  G11 int(10) unsigned NOT NULL default '0',
  G12 int(10) unsigned NOT NULL default '0',
  G13 int(10) unsigned NOT NULL default '0',
  G14 int(10) unsigned NOT NULL default '0',
  G15 int(10) unsigned NOT NULL default '0',
  G16 int(10) unsigned NOT NULL default '0',
  G17 int(10) unsigned NOT NULL default '0',
  G18 int(10) unsigned NOT NULL default '0',
  G19 int(10) unsigned NOT NULL default '0',
  G20 int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (GroupID)
) TYPE=MyISAM;

--
-- Table structure for table 'LogoutPlayerData'
--
DROP TABLE IF EXISTS LogoutPlayerdata;
CREATE TABLE LogoutPlayerData (
  PlayerID varchar(10) NOT NULL default '',
  SSN varchar(20) NOT NULL default '',
  ZipCode varchar(7) NOT NULL default '',
  Date date NOT NULL default '0000-00-00',
  Time time NOT NULL default '00:00:00',
  IP varchar(15) NOT NULL default '',
  KEY IDX_LogoutPlayerData2 (PlayerID),
  KEY IDX_DATE (Date)
) TYPE=MyISAM;

--
-- Table structure for table 'PCRoomIPInfo'
--
DROP TABLE IF EXISTS PCRoomIPInfo;
CREATE TABLE PCRoomIPInfo (
  ID int(10) unsigned NOT NULL default '0',
  IP varchar(15) NOT NULL default '255.255.255.255',
  PRIMARY KEY  (ID,IP),
  KEY IDX_PCRoomIPInfo_ID (ID),
  KEY IDX_PCRoomIPInfo_IP (IP)
) TYPE=MyISAM;

--
-- Table structure for table 'PCRoomInfo'
--

DROP TABLE IF EXISTS PCRoomInfo;
CREATE TABLE PCRoomInfo (
  ID int(10) unsigned NOT NULL auto_increment,
  Account varchar(20) NOT NULL default '',
  Name varchar(20) NOT NULL default '',
  Password varchar(16) NOT NULL default '',
  Sname varchar(30) NOT NULL default '',
  Regist_NO varchar(30) NOT NULL default '',
  Ssno varchar(14) NOT NULL default '',
  Email varchar(30) NOT NULL default '',
  ZipCode2 varchar(7) default NULL,
  Address2 varchar(100) default NULL,
  Line varchar(20) default NULL,
  Kind varchar(20) default NULL,
  Kind2 varchar(20) default NULL,
  T_admin varchar(30) default NULL,
  Telephone varchar(15) default NULL,
  Cellular varchar(15) default NULL,
  ZipCode varchar(7) default NULL,
  Address varchar(100) default NULL,
  PayType tinyint(1) unsigned NOT NULL default '1',
  PayStartDate datetime NOT NULL default '2002-07-12 00:00:00',
  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',
  UserLimit tinyint(3) unsigned NOT NULL default '0',
  UserMax tinyint(3) unsigned NOT NULL default '0',
  PayIPType tinyint(1) unsigned NOT NULL default '0',
  PCAmount smallint(5) unsigned NOT NULL default '0',
  AgencyID varchar(20) NOT NULL default '',
  Author tinyint(2) NOT NULL default '2',
  creation_date datetime NOT NULL default '0000-00-00 00:00:00',
  RegionType tinyint(2) NOT NULL default '1',
  AgencyType enum('Y','N') NOT NULL default 'N',
  PayTimeType enum('TIME','FIX') NOT NULL default 'TIME',
  PRIMARY KEY  (ID),
  UNIQUE KEY Account (Account),
  KEY IDX_PCRoomInfo_Name (Name)
) TYPE=MyISAM;

--
-- Table structure for table 'PCRoomLottoObject'
--

DROP TABLE IF EXISTS PCRoomLottoObject;
CREATE TABLE PCRoomLottoObject (
  ID int(10) unsigned NOT NULL auto_increment,
  PCRoomID int(10) unsigned NOT NULL default '0',
  PlayerID varchar(30) NOT NULL default '',
  DimensionID int(10) unsigned NOT NULL default '0',
  WorldID int(10) unsigned NOT NULL default '0',
  Name varchar(10) NOT NULL default '',
  Race tinyint(3) unsigned NOT NULL default '0',
  Amount tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY IDX_PCROOMID (PCRoomID),
  KEY IDX_PLAYERID (PlayerID),
  KEY IDX_DIMENSIONID (DimensionID),
  KEY IDX_WORLDID (WorldID),
  KEY IDX_NAME (Name)
) TYPE=MyISAM;

--
-- Table structure for table 'PCRoomPayList'
--

DROP TABLE IF EXISTS PCRoomPayList;
CREATE TABLE PCRoomPayList (
  PCRoomID int(10) unsigned NOT NULL default '0',
  Year int(10) unsigned NOT NULL default '0',
  Month int(10) unsigned NOT NULL default '0',
  PayPlayMinute int(10) unsigned NOT NULL default '0',
  KEY PCRoomPayList_IDX1 (PCRoomID),
  KEY PCRoomPayList_IDX2 (Year),
  KEY PCRoomPayList_IDX3 (Month)
) TYPE=MyISAM;

--
-- Table structure for table 'PCRoomUserInfo'
--