📄 db_zh_cn_utf8.mysql3x.sql

📁 网上医院系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
上一页 1 2 3 45
#
# 导出下面的数据库内容 `hos_member_regform_11`
#

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

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

CREATE TABLE hos_member_regform_12 (
  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)
);

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

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

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

CREATE TABLE hos_member_rights (
  id int(12) NOT NULL auto_increment,
  memberid int(50) default NULL,
  secureid int(50) default NULL,
  securetype char(100) default NULL,
  secureset int(20) default NULL,
  PRIMARY KEY  (id)
);

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

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

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

CREATE TABLE hos_member_type (
  membertypeid int(6) NOT NULL auto_increment,
  membertype varchar(100) default NULL,
  memberprop int(1) NOT NULL default '0',
  ifcanreg int(1) default NULL,
  ifchecked int(1) default NULL,
  regxy text,
  regmail text,
  expday int(8) default NULL,
  startcent int(20) default NULL,
  endcent int(20) default NULL,
  PRIMARY KEY  (membertypeid)
);

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

INSERT INTO hos_member_type VALUES (11, '普通用户', 0, 1, 1, '', '{#name#}{#sex#},您好!\r\n\r\n感谢您在本站注册!\r\n\r\n用户名: {#user#}\r\n密码: {#password#}\r\n\r\n网址:http://', 0, 0, 0);
INSERT INTO hos_member_type VALUES (12, '高级用户', 0, 0, 0, '', '{#name#}{#sex#},您好!\r\n\r\n感谢您在本站注册!\r\n\r\n用户名: {#user#}\r\n密码: {#password#}\r\n\r\n网址:http://', 0, 0, 0);
# --------------------------------------------------------

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

CREATE TABLE hos_member_zone (
  catid int(12) NOT NULL auto_increment,
  pid int(12) default NULL,
  cat char(50) default NULL,
  xuhao int(4) default NULL,
  catpath char(255) default NULL,
  PRIMARY KEY  (catid)
);

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

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

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

CREATE TABLE hos_menu (
  menuid int(12) NOT NULL auto_increment,
  pid int(6) default NULL,
  menu varchar(50) default NULL,
  coltype varchar(30) NOT NULL default '',
  url varchar(200) default NULL,
  fold varchar(50) NOT NULL default '',
  pub varchar(50) default NULL,
  ifshow int(1) default NULL,
  moveable int(1) default NULL,
  xuhao int(4) default NULL,
  target varchar(10) default NULL,
  openindex int(1) NOT NULL default '0',
  secure int(1) NOT NULL default '0',
  skin varchar(20) NOT NULL default 'images',
  PRIMARY KEY  (menuid)
);

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

INSERT INTO hos_menu VALUES (1, 0, '网站首页', 'index', '', '', 'menu', 1, 0, 1, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (3, 0, '新闻动态', 'news', 'http://', 'news', 'menu', 1, 0, 3, '_self', 1, 0, 'default');
INSERT INTO hos_menu VALUES (4, 0, '就医指南', 'cp', NULL, 'cp', 'menu', 1, 0, 6, '_self', 1, 0, 'default');
INSERT INTO hos_menu VALUES (5, 0, '资源下载', 'down', NULL, 'down', 'btmenu', 0, 0, 5, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (2, 0, '用户中心', 'member', '', '', 'menu', 1, 0, 10, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (62, 0, '联系方式', 'page', 'http://', 'contacts', 'btmenu', 1, 0, 1, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (7, 0, '互动咨询', 'comment', '', '', 'menu', 1, 0, 11, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (75, 0, '全站搜索', 'page', 'http://', 'search', 'btmenu', 1, 0, 3, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (74, 0, '友情链接', 'page', 'http://', 'link', 'btmenu', 1, 0, 2, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (76, 0, '医院概况', 'page', 'http://', 'intro', 'menu', 1, 0, 2, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (80, 76, '医院领导', 'page', 'http://', 'xxld', 'smenu', 1, 0, 2, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (81, 76, '机构设置', 'page', 'http://', 'jgsz', 'smenu', 1, 0, 3, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (82, 0, '设备环境', 'cp', 'http://', 'xyfm', 'menu', 1, 0, 4, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (104, 1, '医院简介', 'url', 'page/intro/', '', 'smenu', 1, 0, 1, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (139, 4, '科室介绍', 'url', '../../cp/main/index.php', '', 'smenu', 1, 0, 1, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (112, 0, '名医荟萃', 'cp', 'http://', 'yisheng', 'menu', 1, 0, 5, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (105, 76, '医院介绍', 'url', '../../page/intro/index.php', '', 'smenu', 1, 0, 1, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (90, 0, '医疗保健', 'news', 'http://', 'jiaoan', 'menu', 1, 0, 7, '_self', 1, 0, 'default');
INSERT INTO hos_menu VALUES (124, 76, '科室介绍', 'url', '../../cp/main/index.php', '', 'smenu', 1, 0, 4, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (125, 76, '名医荟萃', 'url', '../../yisheng/class/', '', 'smenu', 1, 0, 5, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (131, 4, '网上挂号', 'form', 'http://', 'guahao', 'smenu', 1, 0, 3, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (130, 1, '先进设备', 'url', 'xyfm/class/?2.html', '', 'smenu', 1, 0, 10, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (129, 1, '名医荟萃', 'url', 'yisheng/class/', '', 'smenu', 1, 0, 9, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (128, 1, '科室介绍', 'url', 'cp/main/', '', 'smenu', 1, 0, 8, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (127, 1, '医院领导', 'url', 'page/xxld/', '', 'smenu', 1, 0, 7, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (126, 76, '设备环境', 'url', '../../xyfm/class/', '', 'smenu', 1, 0, 6, '_self', 0, 0, 'default');
INSERT INTO hos_menu VALUES (137, 4, '就诊流程', 'page', 'http://', 'liucheng', 'smenu', 1, 0, 2, '_self', 0, 0, 'default');
# --------------------------------------------------------

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

CREATE TABLE hos_news_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)
);

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

INSERT INTO hos_news_cat VALUES (1, 0, 3, '最新公告', 1, '0001:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (2, 0, 3, '医药新闻', 3, '0002:', 0, 0, 0);
INSERT INTO hos_news_cat VALUES (3, 0, 3, '媒体报道', 4, '0003:', 0, 0, 0);
INSERT INTO hos_news_cat VALUES (4, 0, 90, '家庭保健', 4, '0004:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (5, 0, 90, '药品常识', 8, '0005:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (6, 0, 90, '饮食保健', 6, '0006:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (7, 0, 90, '病人护理', 7, '0007:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (72, 66, 90, '体检科', 6, '0066:0072:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (71, 66, 90, '口腔科', 5, '0066:0071:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (57, 0, 3, '医院动态', 2, '0057:', 0, 0, 0);
INSERT INTO hos_news_cat VALUES (65, 0, 90, '疾病防治', 9, '0065:', 4, 0, 0);
INSERT INTO hos_news_cat VALUES (66, 0, 90, '医学知识', 10, '0066:', 34, 0, 0);
INSERT INTO hos_news_cat VALUES (67, 66, 90, '内科', 1, '0066:0067:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (68, 66, 90, '外科', 2, '0066:0068:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (70, 66, 90, '妇产科', 4, '0066:0070:', 5, 0, 0);
INSERT INTO hos_news_cat VALUES (69, 66, 90, '小儿科', 3, '0066:0069:', 5, 0, 0);
# --------------------------------------------------------

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

CREATE TABLE hos_news_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,
  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',
  ifbold int(1) default '0',
  ifred varchar(20) default '0',
  `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',
  memo text NOT NULL,
  PRIMARY KEY  (id)
);

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

INSERT INTO hos_news_con VALUES (158, 90, 69, '0066:0069:', '新生儿溶血病的症状', '', 1165935106, 1, 1, 0, 1, 0, '0', '', '', 1165935106, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (104, 90, 4, '0004:', '婴幼儿头发生长及常见问题', '', 1165743818, 1, 1, 0, 1, 0, '0', '', '', 1165743818, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (105, 90, 6, '0006:', '在外吃小龙虾必注意几个问题', '', 1165743853, 1, 1, 0, 1, 0, '0', '', '', 1165743853, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (106, 90, 7, '0007:', '怎样护理骨折病人', '', 1165743861, 1, 1, 0, 1, 0, '0', '', '', 1165743861, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (107, 90, 5, '0005:', '缓释胶囊是啥意思', '', 1165743886, 1, 1, 0, 1, 0, '0', '', '', 1165743886, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (108, 90, 5, '0005:', '购药看说明，不花冤枉钱', '', 1165743900, 1, 1, 0, 1, 0, '0', '', '', 1165743900, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (109, 90, 4, '0004:', '紧张可能使得女子身高变矮', '', 1165743998, 1, 1, 0, 1, 0, '0', '', '', 1165743998, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (110, 90, 4, '0004:', '每天吃10种食物赶走胆固醇', '', 1165744008, 1, 1, 0, 1, 0, '0', '', '', 1165744008, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (111, 90, 4, '0004:', '中小学生常见6种疾病早预防', '', 1165744055, 1, 2, 0, 1, 0, '0', '', '', 1165744055, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (112, 90, 4, '0004:', '不必担心孩子的自言自语', '', 1165746754, 1, 11, 0, 1, 0, '0', '', '', 1165746754, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (113, 90, 6, '0006:', '改善考前过度焦虑小策略', '', 1165746773, 1, 1, 0, 1, 0, '0', '', '', 1165746773, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (114, 90, 6, '0006:', '夏季，苦味食物别乱吃', '', 1165746781, 1, 1, 0, 1, 0, '0', '', '', 1165746781, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (115, 90, 6, '0006:', '十七种家常杀手小菜', '', 1165746858, 1, 1, 0, 1, 0, '0', '', '', 1165746858, 'SystemMaster', '', '0', '', 0, '');
INSERT INTO hos_news_con VALUES (116, 90, 6, '0006:', '饮食健康常用知识', '', 1165746873, 1, 1, 0, 1, 0, '
上一页 1 2 3 45
💿 文件大小 3635 K
👤 上传用户 xhaibo
📂 所属分类医药行业
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -