db_zh_cn_utf8.sql

网上医院系统

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

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

CREATE TABLE hos_default_rights (
  id int(12) NOT NULL auto_increment,
  membertypeid int(50) default NULL,
  secureid int(50) default NULL,
  securetype char(100) default NULL,
  secureset int(100) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_default_rights VALUES (112, 11, 7, 'func', 0);
INSERT INTO hos_default_rights VALUES (111, 11, 4, 'con', 0);
INSERT INTO hos_default_rights VALUES (110, 11, 3, 'menu', 0);
INSERT INTO hos_default_rights VALUES (109, 11, 2, 'func', 0);
INSERT INTO hos_default_rights VALUES (108, 11, 6, 'func', 0);
INSERT INTO hos_default_rights VALUES (113, 11, 8, 'func', 0);
INSERT INTO hos_default_rights VALUES (130, 12, 30, 'func', 0);
INSERT INTO hos_default_rights VALUES (129, 12, 10, 'func', 0);
INSERT INTO hos_default_rights VALUES (128, 12, 8, 'func', 0);
INSERT INTO hos_default_rights VALUES (127, 12, 7, 'func', 0);
INSERT INTO hos_default_rights VALUES (126, 12, 4, 'con', 0);
INSERT INTO hos_default_rights VALUES (125, 12, 3, 'menu', 0);
INSERT INTO hos_default_rights VALUES (124, 12, 2, 'func', 0);
INSERT INTO hos_default_rights VALUES (123, 12, 6, 'func', 0);
# --------------------------------------------------------

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

CREATE TABLE hos_down_cat (
  catid int(12) NOT NULL auto_increment,
  pid int(12) default NULL,
  menuid int(10) NOT NULL default '3',
  cat char(100) default NULL,
  xuhao int(12) default NULL,
  catpath char(255) default NULL,
  nums int(20) default NULL,
  secure int(1) NOT NULL default '0',
  tj int(1) NOT NULL default '0',
  PRIMARY KEY  (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_down_cat VALUES (3, 0, 5, '下载分类', 3, '0003:', 0, 0, 0);
# --------------------------------------------------------

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

CREATE TABLE hos_down_con (
  id int(12) NOT NULL auto_increment,
  menuid int(10) NOT NULL default '3',
  catid int(12) default NULL,
  catpath varchar(255) default NULL,
  title varchar(255) default NULL,
  memo text NOT NULL,
  body text,
  dtime int(11) default '0',
  xuhao int(5) default '0',
  cl int(20) default NULL,
  tj int(1) default NULL,
  iffb int(1) default '0',
  filesize varchar(30) default NULL,
  url varchar(255) default NULL,
  `type` varchar(30) NOT NULL default '',
  src varchar(150) NOT NULL default '',
  uptime int(11) default '0',
  author varchar(100) default NULL,
  source varchar(100) default NULL,
  memberid varchar(100) default NULL,
  proj varchar(255) NOT NULL default '',
  secure int(11) NOT NULL default '0',
  prop1 varchar(255) NOT NULL default '',
  prop2 varchar(255) NOT NULL default '',
  prop3 varchar(255) NOT NULL default '',
  prop4 varchar(255) NOT NULL default '',
  prop5 varchar(255) NOT NULL default '',
  prop6 varchar(255) NOT NULL default '',
  prop7 varchar(255) NOT NULL default '',
  prop8 varchar(255) NOT NULL default '',
  prop9 varchar(255) NOT NULL default '',
  prop10 varchar(255) NOT NULL default '',
  prop11 varchar(255) NOT NULL default '',
  prop12 varchar(255) NOT NULL default '',
  prop13 varchar(255) NOT NULL default '',
  prop14 varchar(255) NOT NULL default '',
  prop15 varchar(255) NOT NULL default '',
  prop16 varchar(255) NOT NULL default '',
  prop17 varchar(255) NOT NULL default '',
  prop18 varchar(255) NOT NULL default '',
  prop19 varchar(255) NOT NULL default '',
  prop20 varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE hos_form (
  id int(3) NOT NULL auto_increment,
  field_caption varchar(200) NOT NULL default '',
  field_type int(1) NOT NULL default '0',
  field_size int(2) NOT NULL default '0',
  field_name varchar(200) NOT NULL default '',
  field_value varchar(255) NOT NULL default '',
  field_null int(1) NOT NULL default '0',
  value_repeat int(1) NOT NULL default '0',
  field_intro varchar(255) NOT NULL default '',
  use_field int(1) NOT NULL default '0',
  moveable int(1) NOT NULL default '0',
  xuhao int(3) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_form VALUES (1, '留言标题', 1, 35, 'title', '', 1, 1, '', 1, 1, 1);
INSERT INTO hos_form VALUES (2, '留言内容', 2, 34, 'content', '', 1, 1, '', 1, 1, 2);
INSERT INTO hos_form VALUES (3, '您的姓名', 1, 35, 'name', '', 1, 1, '', 1, 1, 3);
INSERT INTO hos_form VALUES (5, '联系电话', 1, 30, 'tel', '', 0, 1, '', 0, 0, 5);
INSERT INTO hos_form VALUES (6, '联系地址', 1, 35, 'address', '', 0, 1, '', 0, 0, 6);
INSERT INTO hos_form VALUES (7, '电子邮件', 1, 35, 'email', '', 1, 1, '', 1, 1, 7);
INSERT INTO hos_form VALUES (8, '网址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 8);
INSERT INTO hos_form VALUES (9, 'QQ号码', 1, 16, 'qq', '', 0, 1, '', 0, 0, 9);
INSERT INTO hos_form VALUES (10, '公司名称', 1, 35, 'company', '', 0, 1, '', 0, 0, 10);
INSERT INTO hos_form VALUES (11, '公司地址', 1, 35, 'company_address', '', 0, 1, '', 0, 0, 11);
INSERT INTO hos_form VALUES (4, '性　　别', 5, 21, 'sex', '男;女', 0, 1, '', 0, 0, 4);
INSERT INTO hos_form VALUES (12, '邮政编码', 1, 6, 'zip', '', 0, 1, '', 0, 0, 12);
INSERT INTO hos_form VALUES (13, '传真号码', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO hos_form VALUES (14, '产品编号', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO hos_form VALUES (15, '产品名称', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO hos_form VALUES (16, '订购数量', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO hos_form VALUES (19, '自定义一', 5, 35, 'custom1', '100;200;300;400;500', 0, 1, '', 0, 0, 17);
INSERT INTO hos_form VALUES (18, '自定义二', 5, 35, 'custom2', '100;200;300;400;500', 0, 1, '', 0, 0, 18);
INSERT INTO hos_form VALUES (17, '自定义三', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO hos_form VALUES (20, '自定义四', 1, 35, 'custom4', '', 0, 1, '', 0, 0, 20);
INSERT INTO hos_form VALUES (21, '自定义五', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO hos_form VALUES (22, '自定义六', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO hos_form VALUES (23, '自定义七', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------

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

CREATE TABLE hos_form_131 (
  id int(3) NOT NULL auto_increment,
  field_caption varchar(200) default NULL,
  field_type int(1) default NULL,
  field_size int(3) default NULL,
  field_name varchar(200) default NULL,
  field_value varchar(255) default NULL,
  field_null int(1) default NULL,
  value_repeat int(1) default NULL,
  field_intro varchar(255) default NULL,
  use_field int(1) default NULL,
  moveable int(1) default NULL,
  xuhao int(3) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_form_131 VALUES (1, '挂号科室', 1, 39, 'title', '', 1, 1, '', 1, 1, 7);
INSERT INTO hos_form_131 VALUES (2, '症状简述', 2, 48, 'content', '', 1, 1, '', 1, 1, 14);
INSERT INTO hos_form_131 VALUES (3, '姓　　名', 1, 18, 'name', '', 1, 1, '请填写真实姓名', 1, 1, 1);
INSERT INTO hos_form_131 VALUES (5, '联系电话', 1, 18, 'tel', '', 1, 1, '请正确填写以便确认', 1, 0, 4);
INSERT INTO hos_form_131 VALUES (6, '通信地址', 1, 39, 'address', '', 1, 1, '', 1, 0, 5);
INSERT INTO hos_form_131 VALUES (7, '电子邮件', 1, 49, 'email', '', 1, 1, '', 1, 1, 11);
INSERT INTO hos_form_131 VALUES (8, '备用字段', 1, 35, 'url', '', 0, 1, '', 0, 0, 33);
INSERT INTO hos_form_131 VALUES (9, 'QQ号码', 1, 16, 'qq', '', 0, 1, '', 0, 0, 15);
INSERT INTO hos_form_131 VALUES (10, '身份证号', 1, 18, 'company', '', 1, 1, '领号需凭身份证', 1, 0, 2);
INSERT INTO hos_form_131 VALUES (11, '预约医生', 1, 39, 'company_address', '', 1, 1, '', 1, 0, 9);
INSERT INTO hos_form_131 VALUES (4, '性　　别', 5, 21, 'sex', '男;女', 1, 1, '', 1, 0, 3);
INSERT INTO hos_form_131 VALUES (12, '邮政编码', 1, 6, 'zip', '', 1, 1, '', 1, 0, 6);
INSERT INTO hos_form_131 VALUES (13, '备用字段', 1, 30, 'fax', '', 0, 1, '', 0, 0, 16);
INSERT INTO hos_form_131 VALUES (14, '备用字段', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 16);
INSERT INTO hos_form_131 VALUES (15, '备用字段', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 17);
INSERT INTO hos_form_131 VALUES (16, '备用字段', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO hos_form_131 VALUES (19, '预约时间', 1, 39, 'custom1', '', 1, 1, '如:2006年12月30日下午', 1, 0, 8);
INSERT INTO hos_form_131 VALUES (18, '初诊复诊', 5, 35, 'custom2', '初诊;复诊', 1, 1, '', 1, 0, 12);
INSERT INTO hos_form_131 VALUES (17, '备用字段', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO hos_form_131 VALUES (20, '备用字段', 5, 35, 'custom4', '是;否', 1, 1, '', 0, 0, 25);
INSERT INTO hos_form_131 VALUES (21, '备用字段', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO hos_form_131 VALUES (22, '备用字段', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO hos_form_131 VALUES (23, '备用字段', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------

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

CREATE TABLE hos_form_feedback (
  id int(12) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  content text NOT NULL,
  name varchar(200) NOT NULL default '',
  sex varchar(10) NOT NULL default '',
  tel varchar(100) NOT NULL default '',
  address varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  qq varchar(20) NOT NULL default '',
  company varchar(255) NOT NULL default '',
  company_address varchar(255) NOT NULL default '',
  zip varchar(6) NOT NULL default '',
  fax varchar(20) NOT NULL default '',
  products_id varchar(100) NOT NULL default '',
  products_name varchar(200) NOT NULL default '',
  products_num varchar(9) NOT NULL default '',
  custom1 text NOT NULL,
  custom2 text NOT NULL,
  custom3 text NOT NULL,
  custom4 text NOT NULL,
  custom5 text NOT NULL,
  custom6 text NOT NULL,
  custom7 text NOT NULL,
  ip varchar(20) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  look int(1) NOT NULL default '0',
  reversion int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO hos_form_feedback VALUES (1, 131, '消化内科', '胃好疼', '王凯凯', '男', '021-29876667', '上海远洋运输公司', '[e-mail]', '', '', '330122196809091616', '李主任', '210000', '', '', '', '', '2006年12月30日下午', '初诊', '', '', '', '', '', '192.168.2.201', 1166024191, 1, 1);
# --------------------------------------------------------

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

CREATE TABLE hos_link (
  id int(12) NOT NULL auto_increment,
  showtype varchar(10) default NULL,
  name varchar(200) default NULL,
  url varchar(200) default NULL,
  xuhao int(5) default NULL,
  `type` varchar(20) default NULL,
  src varchar(20) default NULL,
  cl int(10) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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