db_zh_cn_utf8.sql

网上医院系统

INSERT INTO hos_link VALUES (3, 'img', '链接一', 'http://www', 0, 'gif', 'link/1165134481.gif', 0);
INSERT INTO hos_link VALUES (4, 'img', '链接一', 'http://www', 0, 'gif', 'link/1165935870.gif', 0);
INSERT INTO hos_link VALUES (5, 'img', '链接一', 'http://www', 0, 'gif', 'link/1165935873.gif', 0);
# --------------------------------------------------------

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

CREATE TABLE hos_logo (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  width int(10) default '0',
  height int(10) default '0',
  `type` varchar(20) default '',
  src varchar(100) default '',
  url varchar(200) default '',
  target varchar(100) default '',
  border int(2) default '0',
  hidden int(1) default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_logo VALUES (1, 1, 0, 0, 'gif', 'images/logo.gif', '', '', 0, 0);
# --------------------------------------------------------

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

CREATE TABLE hos_member (
  memberid int(12) NOT NULL auto_increment,
  membertypeid int(3) default NULL,
  `user` varchar(30) default NULL,
  `password` varchar(50) default NULL,
  company varchar(255) default NULL,
  name varchar(255) default NULL,
  sex varchar(20) default NULL,
  birthday int(8) default NULL,
  zoneid int(10) default NULL,
  catid int(10) default NULL,
  addr varchar(255) default NULL,
  tel varchar(255) default NULL,
  mov varchar(255) default NULL,
  fax varchar(255) default NULL,
  postcode varchar(255) default NULL,
  email varchar(255) default NULL,
  url varchar(255) default NULL,
  passtype varchar(255) default NULL,
  passcode varchar(255) default NULL,
  qq varchar(100) default NULL,
  msn varchar(100) default NULL,
  maillist int(1) default NULL,
  bz text,
  checked int(1) default NULL,
  regtime int(11) default NULL,
  exptime int(11) default NULL,
  account decimal(12,2) default NULL,
  paytotal decimal(12,2) default NULL,
  buytotal decimal(12,2) default NULL,
  cent decimal(12,2) default NULL,
  ip varchar(26) default NULL,
  logincount int(20) default NULL,
  logintime int(11) default NULL,
  loginip varchar(50) default NULL,
  PRIMARY KEY  (memberid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE hos_member_cat (
  catid int(12) NOT NULL auto_increment,
  pid int(12) default NULL,
  cat char(100) default NULL,
  xuhao int(4) default NULL,
  catpath char(255) default NULL,
  nums int(20) default NULL,
  PRIMARY KEY  (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE hos_member_func (
  id int(10) NOT NULL auto_increment,
  pid int(10) default NULL,
  menu char(50) default NULL,
  link char(100) default NULL,
  xuhao int(10) default NULL,
  used int(1) default NULL,
  intro char(255) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_member_func VALUES (13, 0, '用户设置', '', 1, 1, NULL);
INSERT INTO hos_member_func VALUES (1, 13, '修改资料', 'member_modify.php', 6, 1, '');
INSERT INTO hos_member_func VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO hos_member_func VALUES (14, 0, '退出登录', 'logout.php', 4, 1, NULL);
INSERT INTO hos_member_func VALUES (16, 15, '文章发布', 'member_fabu.php', 1, 1, '');
INSERT INTO hos_member_func VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------

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

CREATE TABLE hos_member_func_11 (
  id int(10) NOT NULL auto_increment,
  pid int(10) default NULL,
  menu char(50) default NULL,
  link char(100) default NULL,
  xuhao int(10) default NULL,
  used int(1) default NULL,
  intro char(255) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_member_func_11 VALUES (13, 0, '用户设置', '', 1, 1, NULL);
INSERT INTO hos_member_func_11 VALUES (1, 13, '修改资料', 'member_modify.php', 6, 1, '');
INSERT INTO hos_member_func_11 VALUES (15, 0, '文章管理', '', 1, 0, '');
INSERT INTO hos_member_func_11 VALUES (14, 0, '退出登录', 'logout.php', 4, 1, NULL);
INSERT INTO hos_member_func_11 VALUES (16, 15, '文章发布', 'member_fabu.php', 1, 0, '');
INSERT INTO hos_member_func_11 VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 0, '');
# --------------------------------------------------------

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

CREATE TABLE hos_member_func_12 (
  id int(10) NOT NULL auto_increment,
  pid int(10) default NULL,
  menu char(50) default NULL,
  link char(100) default NULL,
  xuhao int(10) default NULL,
  used int(1) default NULL,
  intro char(255) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_member_func_12 VALUES (13, 0, '用户设置', '', 1, 1, NULL);
INSERT INTO hos_member_func_12 VALUES (1, 13, '修改资料', 'member_modify.php', 6, 1, '');
INSERT INTO hos_member_func_12 VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO hos_member_func_12 VALUES (14, 0, '退出登录', 'logout.php', 4, 1, NULL);
INSERT INTO hos_member_func_12 VALUES (16, 15, '文章发布', 'member_fabu.php', 1, 1, '');
INSERT INTO hos_member_func_12 VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------

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

CREATE TABLE hos_member_notice (
  id int(12) NOT NULL auto_increment,
  membertypeid int(20) default NULL,
  title varchar(255) default NULL,
  body text,
  dtime int(11) default NULL,
  xuhao int(5) default NULL,
  cl int(20) default NULL,
  ifnew int(1) default NULL,
  ifred int(1) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE hos_member_nums (
  id int(12) NOT NULL auto_increment,
  memberid int(50) default NULL,
  secureid int(50) default NULL,
  nums int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE hos_member_regform (
  id int(12) NOT NULL auto_increment,
  formname varchar(200) default NULL,
  formcolname varchar(200) default NULL,
  mustfill int(1) default NULL,
  canrepeat int(1) default NULL,
  moveable int(1) default NULL,
  intro text,
  used int(1) default NULL,
  xuhao int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_member_regform VALUES (1, '用 户 名', 'user', 1, 0, 0, '[5-20位英文或数字]', 1, NULL);
INSERT INTO hos_member_regform VALUES (2, '登录密码', 'password', 1, 1, 0, '[5-20位英文或数字]', 1, NULL);
INSERT INTO hos_member_regform VALUES (3, '重复密码', 'repass', 1, 1, 0, '[5-20位英文或数字]', 1, NULL);
INSERT INTO hos_member_regform VALUES (6, '单位名称', 'company', 0, 1, 1, '', 1, NULL);
INSERT INTO hos_member_regform VALUES (7, '真实姓名', 'name', 1, 1, 1, '', 1, NULL);
INSERT INTO hos_member_regform VALUES (8, '性　　别', 'sex', 1, 1, 1, '', 1, NULL);
INSERT INTO hos_member_regform VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (10, '所在地区', 'zoneid', 1, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (11, '所属行业', 'catid', 1, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (13, '电话号码', 'tel', 0, 1, 1, '', 1, NULL);
INSERT INTO hos_member_regform VALUES (14, '手机号码', 'mov', 0, 1, 1, '', 1, NULL);
INSERT INTO hos_member_regform VALUES (15, '传真号码', 'fax', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (16, '邮政编码', 'postcode', 0, 1, 1, '', 1, NULL);
INSERT INTO hos_member_regform VALUES (17, '电子邮件', 'email', 1, 1, 0, '[请输入正确的电子邮件]', 1, NULL);
INSERT INTO hos_member_regform VALUES (18, '网站网址', 'url', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (19, '证件类型', 'passtype', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (20, '证件号码', 'passcode', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (21, 'QQ号码', 'qq', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (22, 'MSN号码', 'msn', 0, 1, 1, '', 0, NULL);
INSERT INTO hos_member_regform VALUES (24, '备注留言', 'bz', 0, 1, 1, '', 0, NULL);
# --------------------------------------------------------

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

CREATE TABLE hos_member_regform_11 (
  id int(12) NOT NULL auto_increment,
  formname varchar(200) default NULL,
  formcolname varchar(200) default NULL,
  mustfill int(1) default NULL,
  canrepeat int(1) default NULL,
  moveable int(1) default NULL,
  intro text,
  used int(1) default NULL,