📄 db_zh_cn_utf8.mysql3x.sql
字号:
poplocation int(1) default NULL,
popscrollbars varchar(50) default NULL,
popresizable int(1) default NULL,
menuid int(12) NOT NULL default '0',
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `hos_advs_pop`
#
INSERT INTO hos_advs_pop VALUES (1, 'POP', '', 0, 400, 300, 0, 0, 0, 0, 0, 0, 'auto', 0, 1);
# --------------------------------------------------------
#
# 数据表的结构 `hos_advs_right`
#
CREATE TABLE hos_advs_right (
id int(4) NOT NULL auto_increment,
menuid int(12) NOT NULL default '0',
title char(200) default NULL,
width int(10) default NULL,
height int(10) default NULL,
`type` char(20) default NULL,
src char(100) default NULL,
url char(200) default NULL,
target char(100) default NULL,
border int(2) default NULL,
hidden int(1) default NULL,
toppadding int(5) default NULL,
sidepadding int(5) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `hos_advs_right`
#
# --------------------------------------------------------
#
# 数据表的结构 `hos_coltype`
#
CREATE TABLE hos_coltype (
id int(12) NOT NULL auto_increment,
coltype varchar(30) NOT NULL default '',
colname varchar(50) NOT NULL default '',
ifmul int(1) NOT NULL default '0',
moveable int(1) NOT NULL default '0',
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `hos_coltype`
#
INSERT INTO hos_coltype VALUES (1, 'index', '网站首页', 0, 0);
INSERT INTO hos_coltype VALUES (2, 'member', '会员中心', 0, 0);
INSERT INTO hos_coltype VALUES (3, 'url', '自定链接', 1, 1);
INSERT INTO hos_coltype VALUES (4, 'page', '单页频道', 1, 1);
INSERT INTO hos_coltype VALUES (5, 'news', '文章频道', 1, 1);
INSERT INTO hos_coltype VALUES (6, 'cp', '图文频道', 1, 1);
INSERT INTO hos_coltype VALUES (7, 'down', '下载频道', 1, 1);
INSERT INTO hos_coltype VALUES (8, 'form', '自定表单', 1, 1);
INSERT INTO hos_coltype VALUES (9, 'comment', '会员社区', 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `hos_comment`
#
CREATE TABLE hos_comment (
id int(20) NOT NULL auto_increment,
pid int(20) default NULL,
menuid int(20) default NULL,
coltype varchar(30) default NULL,
rid int(20) default NULL,
name varchar(100) default NULL,
title varchar(200) default NULL,
body text,
star int(1) default NULL,
uptime int(11) default NULL,
ip varchar(16) default NULL,
fabu int(1) default NULL,
tuijian int(1) default NULL,
face varchar(10) default NULL,
cl int(10) default NULL,
lastname varchar(50) NOT NULL default '',
picsrc varchar(150) NOT NULL default '',
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `hos_comment`
#
INSERT INTO hos_comment VALUES (1, 0, 3, 'news', 95, 'aaaaa', '祝贺', '祝贺', 0, 1165772714, '192.168.2.201', 1, 0, '1', 1, 'aaaaa', '');
INSERT INTO hos_comment VALUES (2, 0, 0, '4', 0, 'aaaaa', '请问心血管疾病要注意什么', '请问心血管疾病要注意什么', 0, 1165772924, '192.168.2.201', 1, 0, '1', 4, 'aaaaa', '');
INSERT INTO hos_comment VALUES (3, 0, 0, '5', 0, 'aaaaa', '请问无纸化药方有什么好处', '请问无纸化药方有什么好处', 0, 1165773032, '192.168.2.201', 1, 0, '1', 7, 'aaaaa', '');
# --------------------------------------------------------
#
# 数据表的结构 `hos_comment_cat`
#
CREATE TABLE hos_comment_cat (
catid int(12) NOT NULL auto_increment,
cat varchar(50) default NULL,
coltype varchar(30) default NULL,
xuhao int(4) default NULL,
moveable int(1) default NULL,
PRIMARY KEY (catid)
);
#
# 导出下面的数据库内容 `hos_comment_cat`
#
INSERT INTO hos_comment_cat VALUES (1, '文章评论', 'news', 7, 0);
INSERT INTO hos_comment_cat VALUES (2, '图片评论', 'cp', 8, 0);
INSERT INTO hos_comment_cat VALUES (3, '下载评论', 'down', 9, 0);
INSERT INTO hos_comment_cat VALUES (4, '专家答疑', '4', 1, 1);
INSERT INTO hos_comment_cat VALUES (5, '服务咨询', '5', 2, 1);
INSERT INTO hos_comment_cat VALUES (6, '质量投诉', '6', 3, 1);
# --------------------------------------------------------
#
# 数据表的结构 `hos_config`
#
CREATE TABLE hos_config (
xuhao int(3) NOT NULL default '0',
vname varchar(50) NOT NULL default '',
coltype varchar(30) NOT NULL default 'input',
colwidth varchar(3) NOT NULL default '30',
variable varchar(32) NOT NULL default '',
`value` text NOT NULL,
intro text NOT NULL,
PRIMARY KEY (variable)
);
#
# 导出下面的数据库内容 `hos_config`
#
INSERT INTO hos_config VALUES (1, '网站名称', 'input', '30', 'SiteName', '医院网站系统', '用于在网页标题、导航栏处显示');
INSERT INTO hos_config VALUES (2, '网站网址', 'input', '30', 'SiteHttp', 'http://www.abc.com/', '网站的实际访问网址,末尾加“/”');
INSERT INTO hos_config VALUES (3, '服务邮箱', 'input', '30', 'SiteEmail', 'service@mydomain.com', '在发送系统邮件时作为发件人邮件');
INSERT INTO hos_config VALUES (4, '邮件转发方式', 'ownersys', '1', 'ownersys', '0', 'LINUX/UNIX服务器一般可使用内置邮件系统转发邮件；WINDOWS服务器建议使用外部SMTP邮箱转发，并设置以下SMTP邮箱参数');
INSERT INTO hos_config VALUES (6, 'SMTP服务器', 'input', '30', 'owner_m_smtp', 'mail.mydomain.com', '');
INSERT INTO hos_config VALUES (7, 'SMTP邮箱用户', 'input', '30', 'owner_m_user', 'alex@mydomain.com', '');
INSERT INTO hos_config VALUES (8, 'SMTP邮箱密码', 'input', '30', 'owner_m_pass', '123456', '');
INSERT INTO hos_config VALUES (5, 'SMTP转发邮箱', 'input', '30', 'owner_m_mail', 'alex@mydomain.com', '');
INSERT INTO hos_config VALUES (9, 'SMTP身份验证', 'YN', '10', 'owner_m_check', '1', '');
INSERT INTO hos_config VALUES (10, '是否生成并使用静态HTML网页', 'YN', '10', 'CatchOpen', '0', '');
INSERT INTO hos_config VALUES (11, 'HTML静态网页更新时间(秒)', 'input', '8', 'CatchTime', '7200', '超过此时间访问静态页面时自动跳转到动态页面，并重新生成静态页面');
INSERT INTO hos_config VALUES (12, 'INDEX.HTML优先', 'YN', '10', 'IndexOrder', '1', '当主机的index.html优先于index.php时，栏目链接直接指向目录访问静态网页，使网址较简洁，PHP虚拟主机大多支持此设置');
INSERT INTO hos_config VALUES (21, 'DISCUZ论坛URL', 'input', '30', 'DiscuzUrl', 'http://', '请输入您的DISCUZ论坛网址,如:http://www.abc.com/bbs');
INSERT INTO hos_config VALUES (22, 'DISCUZ论坛连接私钥', 'input', '30', 'DiscuzCode', '', 'Discuz论坛后台设置的接口私钥与本处设置务必一致');
INSERT INTO hos_config VALUES (20, 'DISCUZ论坛会员接口是否启用', 'YN', '30', 'DiscuzOpen', '0', '启用Discuz会员接口时,会员注册和登录时将向论坛发送注册和登录信息.请在Discuz论坛后台通行证设置中进行相应接口设置');
INSERT INTO hos_config VALUES (30, '前台图片上传尺寸限制(Byte)', 'input', '30', 'PicSizeLimit', '204800', '前台网站上传图片时单个图片尺寸的限制');
# --------------------------------------------------------
#
# 数据表的结构 `hos_cp_cat`
#
CREATE TABLE hos_cp_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_cp_cat`
#
INSERT INTO hos_cp_cat VALUES (1, 0, 82, '优美环境', 2, '0001:', 1, 0, 0);
INSERT INTO hos_cp_cat VALUES (2, 0, 82, '先进设备', 1, '0002:', 8, 0, 0);
INSERT INTO hos_cp_cat VALUES (3, 0, 4, '重点专科', 3, '0003:', 6, 0, 0);
INSERT INTO hos_cp_cat VALUES (4, 0, 4, '临床科室', 4, '0004:', 5, 0, 0);
INSERT INTO hos_cp_cat VALUES (5, 0, 4, '医技科室', 5, '0005:', 2, 0, 0);
INSERT INTO hos_cp_cat VALUES (6, 0, 112, '外科', 6, '0006:', 4, 0, 0);
INSERT INTO hos_cp_cat VALUES (7, 0, 112, '内科', 7, '0007:', 0, 0, 0);
INSERT INTO hos_cp_cat VALUES (8, 0, 112, '医检', 8, '0008:', 0, 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `hos_cp_con`
#
CREATE TABLE hos_cp_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',
ifbold int(1) default '0',
ifred int(1) 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',
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)
);
#
# 导出下面的数据库内容 `hos_cp_con`
#
INSERT INTO hos_cp_con VALUES (36, 4, 4, '0004:', '大内科', '', '', 1165936043, 3, 3, 0, 1, 0, 0, 'gif', 'cp/html/images/1165936062.jpg', 1165936190, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (17, 4, 5, '0005:', '检验科', '临检/生化/细菌/细胞/免疫', '', 1165738160, 1, 25, 1, 1, 0, 0, 'gif', 'cp/html/images/1165738192.jpg', 1165739138, '', '', '0', '0003:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (35, 4, 3, '0003:', '消化内科', '', '', 1165935726, 6, 10, 1, 1, 0, 0, 'gif', 'cp/html/images/1165935745.jpg', 1165936148, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (16, 4, 5, '0005:', '医学影像科', 'B超/彩超/心电/电生理/脑电/肌电/电子胃镜/纤维肠镜/纤维喉镜/胸腔镜', '', 1165738099, 1, 11, 1, 1, 0, 0, 'gif', 'cp/html/images/1165738156.jpg', 1165937058, '', '', '0', '0003:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (14, 82, 1, '0001:', '挂号收费处', '', '', 1165734913, 1, 3, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165734953.jpg', 1165734913, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (7, 82, 2, '0002:', '全自动血凝仪', '', '', 1165682839, 1, 14, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165682851.jpg', 1165739122, '', '', '0', '0003:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (8, 82, 2, '0002:', '百胜Du8彩超', '', '', 1165682853, 1, 7, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165682869.jpg', 1165739114, '', '', '0', '0003:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (10, 82, 2, '0002:', '意大利百胜彩超', '', '', 1165682931, 1, 3, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165682945.jpg', 1165739107, '', '', '0', '0003:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (11, 82, 2, '0002:', '德国飞漫电动手术床', '', '', 1165682986, 1, 3, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165682994.jpg', 1165739100, '', '', '0', '0002:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (12, 82, 2, '0002:', '图像导引放疗系统', '', '', 1165683024, 1, 3, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165683032.jpg', 1165739088, '', '', '0', '0001:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (13, 82, 2, '0002:', '飞利浦16排螺旋CT', '飞利浦16排螺旋CT介绍', '', 1165683044, 1, 18, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165683053.jpg', 1165739078, '', '', '0', '0002:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (19, 82, 2, '0002:', '德国飞漫电动手术床', '', '', 1165739281, 1, 1, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165739294.jpg', 1165739281, '', '', '0', '0002:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (20, 82, 2, '0002:', '德国飞漫电动手术床', '', '', 1165739281, 1, 1, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165739299.jpg', 1165739281, '', '', '0', '0002:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (22, 112, 6, '0006:', '主任医师李大山', '', '', 1165741503, 1, 6, 0, 1, 0, 0, 'gif', 'yisheng/html/images/1165741571.jpg', 1165916123, '', '', '0', '0002:', 0, '李大山', '主任医师', '胸外科', '每周四下午', '胸外科', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (23, 112, 6, '0006:', '主任医师李大山', '', '', 1165741503, 1, 5, 0, 1, 0, 0, 'gif', 'yisheng/html/images/1165741578.jpg', 1165916590, '', '', '0', '0002:', 0, '李大山', '主任医师,教授', '胸外科', '每周四下午', '胸外科', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (24, 112, 6, '0006:', '主任医师李大山', '', '', 1165741503, 1, 7, 0, 1, 0, 0, 'gif', 'yisheng/html/images/1165741590.jpg', 1165915733, '', '', '0', '0002:', 0, '李二山', '副主任医师', '胸外科', '每周四下午', '世界著名的胸外科专家', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (25, 112, 6, '0006:', '主任医师李大山', '', '', 1165741503, 1, 6, 0, 1, 0, 0, 'gif', 'yisheng/html/images/1165741596.jpg', 1165915728, '', '', '0', '0002:', 0, '李大山', '主任医师,教授', '胸外科', '每周四下午', '世界著名的胸外科专家', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (27, 4, 4, '0004:', '手术室', '请输入科室介绍简单描述', '', 1165743087, 1, 7, 1, 1, 0, 0, 'gif', 'cp/html/images/1165743106.jpg', 1165769830, '', '', '0', '0002:', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (28, 4, 3, '0003:', '心血管科', '请输入科室介绍简单描述', '', 1165768852, 6, 20, 1, 1, 0, 0, 'gif', 'cp/html/images/1165768868.jpg', 1165936157, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (29, 4, 4, '0004:', '小儿科', '请输入科室介绍简单描述', '', 1165768937, 5, 8, 1, 1, 0, 0, 'gif', 'cp/html/images/1165768962.jpg', 1165937034, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (30, 4, 3, '0003:', '口腔科', '请输入科室介绍简单描述', '', 1165769001, 5, 5, 1, 1, 0, 0, 'gif', 'cp/html/images/1165769017.jpg', 1165909574, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (34, 4, 3, '0003:', '整型美容科', '', '', 1165935703, 6, 11, 1, 1, 0, 0, 'gif', 'cp/html/images/1165935723.jpg', 1165935808, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (31, 4, 3, '0003:', '妇产科', '', '', 1165909531, 5, 3, 1, 1, 0, 0, 'gif', 'cp/html/images/1165909542.jpg', 1165909654, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (32, 4, 3, '0003:', '骨外科', '', '', 1165909590, 6, 9, 1, 1, 0, 0, 'gif', 'cp/html/images/1165909601.jpg', 1165935788, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (33, 4, 4, '0004:', '体检科', '', '', 1165909603, 5, 3, 1, 1, 0, 0, 'gif', 'cp/html/images/1165909612.jpg', 1165937019, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO hos_cp_con VALUES (37, 4, 4, '0004:', '普外科', '', '', 1165936065, 3, 2, 0, 1, 0, 0, 'gif', 'cp/html/images/1165936076.jpg', 1165936185, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
# --------------------------------------------------------
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -