?? db_zh_tw_utf8.sql
字號:
popstatus int(1) default NULL,
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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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, '重點?？?#039;, 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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `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 + -