?? db_zh_tw_utf8.sql

?? 網上醫院系統
?? SQL
?? 第 1 頁 / 共 5 頁
字號:
上一頁 1 2 3 45
  xuhao int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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
上一頁 1 2 3 45
?? 文件大小 3635 K
?? 上傳用戶 xhaibo
?? 所屬分類醫藥行業
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? db_zh_tw_utf8.sql

?? 快捷鍵說明
