xyjh.sql

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

INSERT INTO npc_member VALUES ('shuis_3','水手',58100,350,'','','',300,300,'侠客','和平',400,28,28,28,28,28,18,18,'11','海滩4','1011326730',50,'渔民','一名经常出海的水手。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('haoou_3','海鸥',100,140,'','','',120,120,'侠客','和平','',13,11,11,12,11,12,8,'haiou','海滩4','1011326229','','动物','一只海鸥。','','','','','','','','');
INSERT INTO npc_member VALUES ('haoou_4','海鸥',100,140,'','','',120,120,'侠客','和平','',13,11,11,12,11,12,8,'haiou','海滩5','1011326229','','动物','一只海鸥。','','','','','','','','');
INSERT INTO npc_member VALUES ('haoou_5','海鸥',100,140,'','','',120,120,'侠客','和平','',13,11,11,12,11,12,8,'haiou','海滩5','1011326229','','动物','一只海鸥。','','','','','','','','');
INSERT INTO npc_member VALUES ('haogui_3','海龟',100,140,'','','',120,120,'侠客','和平','',13,11,11,12,11,12,8,'haigui','海滩7','1011326229','','动物','一只海龟。','','','','','','','','');
INSERT INTO npc_member VALUES ('haogui_4','海龟',100,140,'','','',120,120,'侠客','和平','',13,11,11,12,11,12,8,'haigui','海滩8','1011326229','','动物','一只海龟。','','','','','','','','');
INSERT INTO npc_member VALUES ('yum_3','渔民',78100,350,'','','',300,300,'侠客','和平',-400,28,28,28,28,28,18,18,'11','海滩7','1011326730',50,'渔民','一名海里面生活的渔民。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('yum_4','渔民',98100,350,'','','',300,300,'侠客','和平',-400,28,28,28,28,28,18,18,'11','海滩5','1011326730',50,'渔民','一名海里面生活的渔民。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('yum_5','渔民',38100,350,'','','',300,300,'侠客','和平',-400,28,28,28,28,28,18,18,'11','海滩6','1011326730',50,'渔民','一名海里面生活的渔民。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('yum_6','渔民',78100,350,'','','',300,300,'侠客','和平',-400,28,28,28,28,28,18,18,'11','海滩7','1011326730',50,'渔民','一名海里面生活的渔民。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('yum_7','渔民',98100,350,'','','',300,300,'侠客','和平',-400,28,28,28,28,28,18,18,'11','海滩5','1011326730',50,'渔民','一名海里面生活的渔民。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('yum_8','渔民',38100,350,'','','',300,300,'侠客','和平',-400,28,28,28,28,28,18,18,'11','海滩6','1011326730',50,'渔民','一名海里面生活的渔民。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
INSERT INTO npc_member VALUES ('shuis_4','水手',58100,350,'','','',300,300,'侠客','和平',400,28,28,28,28,28,18,18,'11','渔场','1011326730',50,'渔民','一名经常出海的水手。','cao_mao','chou_pao','','cao_xie','','hssm_shou','','');
# --------------------------------------------------------

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

CREATE TABLE org (
  orgname varchar(20) default NULL,
  orgpos smallint(6) default NULL,
  orgmon mediumint(8) unsigned default NULL,
  orgp varchar(10) default NULL,
  orginfo varchar(60) default NULL,
  orgem varchar(20) default NULL,
  orgbin tinyint(3) unsigned default NULL,
  orgjiang tinyint(3) unsigned default NULL,
  orggao tinyint(3) unsigned default NULL,
  orgopen enum('Y','N') default NULL,
  orglocation varchar(20) NOT NULL default '侠域城',
  UNIQUE KEY orgname (orgname)
) TYPE=MyISAM;

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

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

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

CREATE TABLE org_research (
  org_name varchar(20) default NULL,
  wp_name varchar(20) default NULL,
  wp_des text,
  wp_cla varchar(10) default NULL,
  id_time varchar(10) NOT NULL default '',
  use_mon int(10) unsigned NOT NULL default '0',
  UNIQUE KEY id_time (id_time)
) TYPE=MyISAM;

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

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

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

CREATE TABLE org_research_wg (
  org_name varchar(20) default NULL,
  wg_name varchar(20) default NULL,
  wg_des text,
  wg_z1 varchar(20) default NULL,
  wg_z2 varchar(20) default NULL,
  wg_z3 varchar(20) default NULL,
  wg_z4 varchar(20) default NULL,
  wg_z5 varchar(20) default NULL,
  wg_cla varchar(10) default NULL,
  id_time varchar(10) NOT NULL default '',
  use_mon int(10) unsigned NOT NULL default '0',
  pos smallint(5) unsigned NOT NULL default '0',
  UNIQUE KEY id_time (id_time)
) TYPE=MyISAM;

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

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

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

CREATE TABLE org_research_wp (
  org_name varchar(20) default NULL,
  wp_name varchar(20) default NULL,
  wp_des text,
  wp_cla varchar(10) default NULL,
  id_time varchar(10) NOT NULL default '',
  use_mon int(10) unsigned NOT NULL default '0',
  UNIQUE KEY id_time (id_time)
) TYPE=MyISAM;

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

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

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

CREATE TABLE org_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,
  cla varchar(10) default NULL,
  PRIMARY KEY  (id_num)
) TYPE=MyISAM;

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

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

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

CREATE TABLE org_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,
  cla varchar(10) default NULL,
  PRIMARY KEY  (id_num),
  KEY id (id)
) TYPE=MyISAM;

#