login_db.sql

天之炼狱OpenDE_SQL.tar.gz

DROP TABLE IF EXISTS PCRoomUserInfo;
CREATE TABLE PCRoomUserInfo (
  ID int(10) unsigned NOT NULL default '0',
  PlayerID varchar(10) NOT NULL default '',
  PRIMARY KEY  (ID,PlayerID),
  KEY IDX_PCRoomUserInfo_PlayerID (PlayerID)
) TYPE=MyISAM;

--
-- Table structure for table 'Player'
--

DROP TABLE IF EXISTS 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','WAIT') NOT NULL default 'ALLOW',
  SpecialEventCount int(10) unsigned NOT NULL default '0',
  Number int(10) unsigned 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',
  SuggestCID varchar(30) default '',
  Author tinyint(1) NOT NULL default '2',
  FamilyPayPlayDate datetime NOT NULL default '2002-07-15 00:00:00',
  mailing enum('Y','N') default 'Y',
  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 IDX_FamilyPayPlayDate (FamilyPayPlayDate)
) TYPE=HEAP;

--
-- Table structure for table 'SpeedHackPlayer'
--

DROP TABLE IF EXISTS SpeedHackPlayer;
CREATE TABLE SpeedHackPlayer (
  PlayerID varchar(12) NOT NULL default '',
  IP varchar(15) default NULL,
  Name varchar(20) default NULL,
  WorldID tinyint(5) unsigned NOT NULL default '0',
  ServerGroupID tinyint(5) unsigned NOT NULL default '0',
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Count int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (PlayerID)
) TYPE=MyISAM;

--
-- Table structure for table 'TestClientUser'
--

DROP TABLE IF EXISTS TestClientUser;
CREATE TABLE TestClientUser (
  PlayerID varchar(10) NOT NULL default '',
  IP varchar(13) NOT NULL default '',
  LoginDate datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

--
-- Table structure for table 'UnderworldEvent'
--

DROP TABLE IF EXISTS Underworldvent;
CREATE TABLE UnderworldEvent (
  ID int(10) unsigned NOT NULL auto_increment,
  WorldID tinyint(3) unsigned NOT NULL default '0',
  ServerID tinyint(3) unsigned NOT NULL default '0',
  PlayerID varchar(20) NOT NULL default '',
  CharacterID varchar(20) NOT NULL default '',
  KillTime datetime NOT NULL default '2003-09-23 00:00:00',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table 'VSPMInfo'
--

DROP TABLE IF EXISTS VSPMInfo;
CREATE TABLE VSPMInfo (
  id int(11) default NULL,
  host char(30) default NULL,
  name char(30) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'WorldDBInfo'
--

CREATE TABLE WorldDBInfo (
  WorldID int(10) unsigned NOT NULL default '0',
  Host char(15) NOT NULL default '',
  DB char(15) NOT NULL default '',
  User char(15) NOT NULL default '',
  Password char(20) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table 'WorldDBInfo'
--


INSERT INTO WorldDBInfo VALUES (0,'61.78.53.168','DARKEDEN','elcastle','elca005');
INSERT INTO WorldDBInfo VALUES (1,'61.78.53.167','DARKEDEN','elcastle','elca005');

--
-- Table structure for table 'WorldInfo'
--

CREATE TABLE WorldInfo (
  ID int(10) unsigned NOT NULL default '0',
  Name char(20) NOT NULL default '',
  Stat tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'WorldInfo'
--


INSERT INTO WorldInfo VALUES (1,'炼狱世界1',0);


--
-- Table structure for table 'ZoneGroupInfo'
--

CREATE TABLE ZoneGroupInfo (
  ZoneGroupID smallint(6) NOT NULL default '0',
  ServerID smallint(6) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'ZoneGroupInfo'
--


INSERT INTO ZoneGroupInfo VALUES (1,1);
INSERT INTO ZoneGroupInfo VALUES (2,1);
INSERT INTO ZoneGroupInfo VALUES (3,1);
INSERT INTO ZoneGroupInfo VALUES (4,1);
INSERT INTO ZoneGroupInfo VALUES (5,1);
INSERT INTO ZoneGroupInfo VALUES (6,1);


--
-- Table structure for table 'ZoneInfo'
--

DROP TABLE IF EXISTS ZoneInfo;
CREATE TABLE ZoneInfo (
  ZoneID smallint(5) unsigned not null default '0',
  ZoneGroupID smallint(5) unsigned not null default '0',
  Type enum('NORMAL_FIELD',
	        'NORMAL_DUNGEON',
			'SLAYER_GUILD',
			'RESERVED_SLAYER_GUILD',
			'PC_VAMPIRE_LAIR',
			'NPC_VAMPIRE_LAIR',
			'NPC_HOME',
			'NPC_SHOP',
			'RANDOM_MAP',
			'CASTLE') not null default 'NORMAL_FIELD',
  Level tinyint(3) unsigned not null default '0',
  AccessMode enum('PUBLIC','PRIVATE') not null default 'PUBLIC',
  OwnerId varchar(20) default null,
  MonsterList text,
  EventMonsterList text,
  SResurrectZoneID int(11) not null default '0',
  SResurrectX int(11) not null default '0',
  SResurrectY int(11) not null default '0',
  VResurrectZoneID int(11) not null default '0',
  VResurrectX int(11) not null default '0',
  VResurrectY int(11) not null default '0',
  OResurrectZoneID int(11) not null default '0',
  OResurrectX int(11) not null default '0',
  OResurrectY int(11) not null default '0',
  SmpFileName varchar(40) not null default '',
  SsiFileName varchar(40) not null default '',
  FullName varchar(40) not null default '',
  ShortName varchar(40) not null default '',
  PayPlayZone tinyint(1) unsigned not null default '0',
  PremiumZone tinyint(1) unsigned not null default '0',
  PKZone      tinyint(1) unsigned NOT NULL default 0,
  NoPortalZone tinyint(1) unsigned NOT NULL default 0,

  HolyLand	tinyint(1) unsigned NOT NULL default 0,
  Available	tinyint(1) unsigned NOT NULL default 0,

  OpenLevel tinyint(3) unsigned NOT NULL default 0,

  PRIMARY KEY(ZoneID)

) type=myisam;



################################################################################
# 牢郸胶 积己


################################################################################
# Sequence 积己



################################################################################
# 鼻茄 汲沥 



################################################################################
# 单捞磐 持扁
INSERT INTO ZoneInfo VALUES (11,1,'NORMAL_FIELD',0,'PUBLIC',NULL,'
		 #舅沫       (106,8)(129,8)(130,8)(131,8)(132,8)(133,8)(134,8)(135,8)(136,8)(137,8)
		 #龋喉       (165,3)(167,3)(168,3)(169,3)(170,3)(171,3)(172,3)(173,3)(174,3)(175,3)
         #孤畔飘     (187,15)(188,15)(189,15)(190,15)(191,15)(192,15)(193,15)(194,15)(195,15)(196,15)