xyjh.sql

This a free web game, animportantnote of this, "xia domain" for free software, follow the "general p

# 导出下面的数据库内容 `org_wuqi`
#

# --------------------------------------------------------

#
# 数据表的结构 `other_info`
#

CREATE TABLE other_info (
  time varchar(10) default NULL,
  content text
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `other_info`
#

# --------------------------------------------------------

#
# 数据表的结构 `renwu_member`
#

CREATE TABLE renwu_member (
  id varchar(10) default NULL,
  pw varchar(16) default NULL,
  name varchar(10) default NULL,
  exp int(10) unsigned default NULL,
  hp mediumint(8) unsigned default NULL,
  hpnow mediumint(8) unsigned default NULL,
  en smallint(5) unsigned default NULL,
  ennow mediumint(8) unsigned default NULL,
  po smallint(5) unsigned default NULL,
  ponow mediumint(8) unsigned default NULL,
  sex enum('侠客','侠女') default NULL,
  cha enum('勇猛','和平','胆小','冷酷','激情') default NULL,
  pos smallint(6) default NULL,
  str tinyint(3) unsigned default NULL,
  zhi tinyint(3) unsigned default NULL,
  con tinyint(3) unsigned default NULL,
  spe tinyint(3) unsigned default NULL,
  pur tinyint(3) unsigned default NULL,
  col tinyint(3) unsigned default NULL,
  yun tinyint(3) unsigned default NULL,
  icon varchar(10) default NULL,
  org varchar(20) default NULL,
  time varchar(10) default NULL,
  mon mediumint(8) unsigned default NULL,
  nick varchar(10) default NULL,
  UNIQUE KEY id (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `renwu_member`
#
# --------------------------------------------------------

#
# 数据表的结构 `renwu_wugong`
#

CREATE TABLE renwu_wugong (
  id varchar(10) default NULL,
  wugongid varchar(10) default NULL,
  wugongexp smallint(5) unsigned default NULL,
  used enum('N','Y') NOT NULL default 'N',
  cla varchar(10) default NULL,
  KEY id (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `renwu_wugong`
#

# --------------------------------------------------------

#
# 数据表的结构 `renwu_wupin`
#

CREATE TABLE renwu_wupin (
  id_num int(10) unsigned NOT NULL auto_increment,
  id varchar(10) default NULL,
  wupinid varchar(10) default NULL,
  sk smallint(5) unsigned default NULL,
  used enum('Y','N') default NULL,
  cla varchar(10) default NULL,
  PRIMARY KEY  (id_num)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `renwu_wupin`
#

# --------------------------------------------------------

#
# 数据表的结构 `renwu_wuqi`
#

CREATE TABLE renwu_wuqi (
  id_num int(10) unsigned NOT NULL auto_increment,
  id varchar(10) default NULL,
  wuqiid varchar(10) default NULL,
  sk tinyint(3) unsigned default NULL,
  used enum('Y','N') default NULL,
  cla varchar(10) default NULL,
  PRIMARY KEY  (id_num),
  KEY id (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `renwu_wuqi`
#

# --------------------------------------------------------

#
# 数据表的结构 `renwu_zawu`
#

CREATE TABLE renwu_zawu (
  id_num int(10) unsigned NOT NULL auto_increment,
  id varchar(10) default NULL,
  wupinid varchar(10) default NULL,
  cla varchar(10) default NULL,
  PRIMARY KEY  (id_num)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `renwu_zawu`
#

# --------------------------------------------------------

#
# 数据表的结构 `resource`
#