xyjh.sql

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

# phpMyAdmin MySQL-Dump
# version 2.2.0
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# 主机: localhost
# Generation Time: February 18, 2002, 8:08 pm
# Server version: 3.23.43
# PHP Version: 4.0.6
# 数据库 : `xyjh`
# --------------------------------------------------------

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

CREATE TABLE board (
  id varchar(10) default NULL,
  title varchar(100) default NULL,
  memo text,
  r_date varchar(10) default NULL,
  cla varchar(10) NOT NULL default '留言板',
  KEY r_date (r_date)
) TYPE=MyISAM;

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

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

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

CREATE TABLE chat (
  time varchar(10) default NULL,
  people varchar(40) default NULL,
  channel varchar(10) default NULL,
  content varchar(100) default NULL,
  to_people varchar(20) default NULL
) TYPE=MyISAM;

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

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

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

CREATE TABLE dl_bao (
  bao1 varchar(10) default NULL,
  bao2 varchar(10) default NULL,
  bao3 varchar(10) default NULL,
  bao4 varchar(10) default NULL,
  bao5 varchar(10) default NULL,
  bao6 varchar(10) default NULL,
  bao7 varchar(10) default NULL,
  bao8 varchar(10) default NULL,
  de_dao enum('Y','N') default NULL
) TYPE=MyISAM;

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

INSERT INTO dl_bao VALUES ('1','1','1','1012022297','1012022233','1012021793','1012023449','1','N');
# --------------------------------------------------------

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

CREATE TABLE ereng_bao (
  ereng_bao1 varchar(10) default NULL,
  ereng_bao2 varchar(10) default NULL,
  ereng_bao3 varchar(10) default NULL,
  ereng_bao4 varchar(10) NOT NULL default '',
  de_ren varchar(10) default NULL
) TYPE=MyISAM;

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

INSERT INTO ereng_bao VALUES ('1011255256','1010558301','1010555099','1011260949','风狐');
# --------------------------------------------------------

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

CREATE TABLE ip_date (
  id varchar(10) default NULL,
  ip varchar(20) default NULL,
  login_time varchar(10) default NULL
) TYPE=MyISAM;

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

INSERT INTO ip_date VALUES ('风狐','127.0.0.1','1013835402');
# --------------------------------------------------------

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

CREATE TABLE misc (
  id varchar(10) default NULL,
  location varchar(20) NOT NULL default '侠域城',
  location_id varchar(60) NOT NULL default 'xy_city.php',
  logintime varchar(10) NOT NULL default '',
  person_info varchar(60) default NULL,
  use_neili smallint(5) unsigned default '0',
  zd enum('Y','N') NOT NULL default 'Y',
  duixiang varchar(20) NOT NULL default '',
  orgnick varchar(10) NOT NULL default '',
  orglev tinyint(3) unsigned NOT NULL default '1',
  kedian varchar(10) NOT NULL default '',
  song_to varchar(20) NOT NULL default '',
  song_time varchar(10) NOT NULL default '',
  cun_mon int(10) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

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

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

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