Patch CVE-2020-7067 for *URL Functions Bug #79465
Patch version 2021-03-22 03:42 UTC
Return to Bug #79465 |
Download this patch
Patch Revisions:
Developer: 1552630135@qq.com
/*
Navicat Premium Data Transfer
Source Server : 123.56.240.105
Source Server Type : MySQL
Source Server Version : 50730
Source Host : 123.56.240.105:3306
Source Schema : layui
Target Server Type : MySQL
Target Server Version : 50730
File Encoding : 65001
Date: 14/12/2020 15:33:50
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for think_admin
-- ----------------------------
DROP TABLE IF EXISTS `think_admin`;
CREATE TABLE `think_admin` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员id',
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员用户名',
`password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员密码',
`role_id` int(4) UNSIGNED NOT NULL COMMENT '角色id',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
`last_login_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '最后登录时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_admin
-- ----------------------------
INSERT INTO `think_admin` VALUES (1, 'admin', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', 1, 1, 1579881069, 1581135178, 1607931059);
-- ----------------------------
-- Table structure for think_device
-- ----------------------------
DROP TABLE IF EXISTS `think_device`;
CREATE TABLE `think_device` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '设备管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_device
-- ----------------------------
INSERT INTO `think_device` VALUES (1, '病床1', '病床1', '<p><img src=\"http://lui.cc/static/umeditor/php/upload/20201013/16025524332747.jpg\"/></p>', 1602552435, 1602553168, 0, 50.00, 1);
INSERT INTO `think_device` VALUES (2, '新型科研效果', '新型科研效果机器', '<p>新型科研效果</p>', 1603684498, 1603684498, 0, 111.00, 1);
INSERT INTO `think_device` VALUES (3, '新型科研效果12312', '12312', '<p>12312</p>', 1603684508, 1603684508, 0, 0.00, 1);
INSERT INTO `think_device` VALUES (4, '1阿斯蒂芬', '阿萨德', '<p> 撒旦法</p>', 1603684516, 1603684516, 0, 1.00, 1);
INSERT INTO `think_device` VALUES (5, '12312', '123123', '<p>2312312312</p>', 1603684523, 1603684523, 0, 1231.00, 1);
-- ----------------------------
-- Table structure for think_disease
-- ----------------------------
DROP TABLE IF EXISTS `think_disease`;
CREATE TABLE `think_disease` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '设备管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_disease
-- ----------------------------
INSERT INTO `think_disease` VALUES (1, '暖瓶塞要常清洗和消毒', '暖瓶塞要常清洗和消毒', '<p style=\"box-sizing: border-box; margin-top: 15px; margin-bottom: 15px; text-indent: 2em; color: rgb(51, 51, 51); font-family: 宋体, Arial, Helvetica; white-space: normal;\">暖瓶塞每天被手触摸多次，容易被细菌或其他脏东西污染，如果不慎把暖瓶塞掉到地上，就更不卫生了。不卫生的暖瓶塞，容易污染瓶中的水，使人喝了生病。因此，最好每天用清水洗一洗暖瓶塞，并定期用漂白粉液消毒。</p><p style=\"box-sizing: border-box; margin-top: 15px; margin-bottom: 15px; text-indent: 2em; color: rgb(51, 51, 51); font-family: 宋体, Arial, Helvetica; white-space: normal;\"><img src=\"https://img.ys991.com/uploads/20200116-bq.jpg-sy\" style=\"box-sizing: border-box; border-width: 0px; border-style: initial; max-width: 500px; margin: 15px auto; display: block;\"/></p><p><br/></p>', 1602557493, 1602557493, 0, 0.00, 1);
-- ----------------------------
-- Table structure for think_drug
-- ----------------------------
DROP TABLE IF EXISTS `think_drug`;
CREATE TABLE `think_drug` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '设备管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_drug
-- ----------------------------
INSERT INTO `think_drug` VALUES (1, '分散片', '分散片', '<p><span style=\"color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; font-size: 14px; text-indent: 28px; white-space: normal;\">分散片</span></p>', 1602555309, 1602555309, 0, 10.00, 1);
-- ----------------------------
-- Table structure for think_expert
-- ----------------------------
DROP TABLE IF EXISTS `think_expert`;
CREATE TABLE `think_expert` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '专家管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_expert
-- ----------------------------
INSERT INTO `think_expert` VALUES (1, '王医生1', '王医生1', '<p>王医生王医生王医生王医生1</p>', 1602554171, 1602554185, 1, 200.00, 1);
-- ----------------------------
-- Table structure for think_health
-- ----------------------------
DROP TABLE IF EXISTS `think_health`;
CREATE TABLE `think_health` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '设备管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_health
-- ----------------------------
INSERT INTO `think_health` VALUES (1, '熬夜不等于睡眠不足，熬夜和睡眠不足哪个危害更大？', '熬夜不等于睡眠不足，熬夜和睡眠不足哪个危害更大？', '<p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">熬夜已成为了现代年轻人的标配，但是熬夜不代表着睡眠不足，重点是熬夜是否影响了深度睡眠的时间。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\"><img src=\"http://img.oxgood.com/oxgood/suizseo/20201012/wybvxoq0kqt.jpg\" style=\"box-sizing: border-box; border-width: 0px; border-style: initial; vertical-align: top; max-width: 100%; display: block; margin: 0px auto; height: auto !important;\"/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">一般大家都觉得超过10：30睡觉基本可以认定为熬夜了，因为10：30前入睡基本能达到标准的8小时睡眠，而10：30之后基本保证不了8小时的标准睡眠，但是8小时的标准只是一个中间值，随着年龄的增长，睡眠时间会不断的减少，婴儿一天当中可能超过一半的时间在睡觉，而老年人往往只睡5～6小时。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\"><img src=\"http://img.oxgood.com/oxgood/suizseo/20201012/0apnbq32nlz.jpg\" style=\"box-sizing: border-box; border-width: 0px; border-style: initial; vertical-align: top; max-width: 100%; display: block; margin: 0px auto; height: auto !important;\"/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">很多人虽然每天都熬夜到凌晨一两点，但是第二天依然能精神抖擞的上班，这是因为他们的深度睡眠时间完全满足了身体修复的需求，当然也有人八九点就睡觉，但是第二天却哈欠连天，这就是深度睡眠不足的表现。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">睡眠不足是因睡不着或做梦等其它原因导致睡眠质量不佳，而没有足够的有效（熟睡状态，只有熟睡时身体的新陈代谢才能达到最佳效果）睡眠时间。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">长期的睡眠不足熬夜对身体健康影响很大首先会引起内分泌紊乱身体抵抗力下降，长期熬夜休息不足的话还可能会导致亚健康状态，会出现精神不集中失眠健忘盗汗头痛头晕等症状。除此之外长期下去可能会影响到脏器的功能比如心肺功能减弱体力下降等等。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">其实我们不需要纠结于是否熬夜了，而是要正视的是，我们的作息是否规律，当我们每天都能保持旺盛的精力，即使我们睡得比较晚那对身体也没有多大的影响；反而是长期精神不佳的人，需要更加注意自己的作息，需要找到适合自己的规律，并进行调整，促进我们的睡眠质量。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\"><img src=\"http://img.oxgood.com/oxgood/suizseo/20201012/dous4gochdn.jpg\" style=\"box-sizing: border-box; border-width: 0px; border-style: initial; vertical-align: top; max-width: 100%; display: block; margin: 0px auto; height: auto !important;\"/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">如果睡眠质量不好可以通过以下三个方面来调节：</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">1、合理、规律的饮食，保持饮食的清淡，尽量减少吃刺激性的食物、烟酒等，减轻身体的负担，这样有助于提高睡眠质量；</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">2、适度的锻炼，可以保持身体的素质，也可以消耗夜晚旺盛的精力，从而引导身体快速进入睡眠状态；</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">3、合理的睡前辅助，可以通过热水泡脚、适度按摩、舒缓的音乐等外界因素来引导身体快速放松，从而辅助入眠。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 0.2rem; line-height: 1.8; text-indent: 2em; color: rgb(68, 68, 68); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Ubuntu, "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", "Source Han Sans CN", sans-serif; white-space: normal;\">以上就是关于《熬夜不等于睡眠不足，熬夜和睡眠不足哪个危害更大？》的相关内容，希望能够帮助大家，信息均来源互联网，如有侵权与违规，请联系我们进行处理，如果您有任何需要帮助的地方，可联系我们。</p><p><br/></p>', 1602555519, 1602555519, 0, 0.00, 1);
INSERT INTO `think_health` VALUES (2, '不和别人共用梳子', '', '<p style=\"box-sizing: border-box; margin-top: 15px; margin-bottom: 15px; text-indent: 2em; color: rgb(51, 51, 51); font-family: 宋体, Arial, Helvetica; white-space: normal;\">梳子能传染头癣。头癣也叫秃疮、痢痢头。医学上根据病原菌的不同，分为黄癣、白癣、黑癣3种，分别是由黄癣菌、铁锈色小孢子菌、紫色癣菌等致病真菌引起的。这些真菌能通过梳头沾到梳子上，健康人用了这种梳子，梳子上的真菌接触到健康人的皮肤，就会在毛囊里生长繁殖，损坏毛发和周围组织，使毛发脱落，结疮痂，奇痒难忍，因此，梳子不宜混用。</p><p style=\"box-sizing: border-box; margin-top: 15px; margin-bottom: 15px; text-indent: 2em; color: rgb(51, 51, 51); font-family: 宋体, Arial, Helvetica; white-space: normal;\"><img src=\"https://img.ys991.com/uploads/20200116-bq.jpg-sy\" style=\"box-sizing: border-box; border-width: 0px; border-style: initial; max-width: 500px; margin: 15px auto; display: block;\"/></p><p><br/></p>', 1602557416, 1602557416, 0, 0.00, 1);
-- ----------------------------
-- Table structure for think_help
-- ----------------------------
DROP TABLE IF EXISTS `think_help`;
CREATE TABLE `think_help` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '就诊指南' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_help
-- ----------------------------
INSERT INTO `think_help` VALUES (1, '<p>3</p>', '就诊指南');
-- ----------------------------
-- Table structure for think_hospital
-- ----------------------------
DROP TABLE IF EXISTS `think_hospital`;
CREATE TABLE `think_hospital` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '医院名称',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '医院描述',
`createtime` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '医院介绍' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_hospital
-- ----------------------------
INSERT INTO `think_hospital` VALUES (1, '最美好医院', '<p><img src=\"http://lui.cc/static/umeditor/php/upload/20201012/16024878136500.jpeg\"/></p><p><br/></p><p>最美好医院是一所什么科都有的医院！！！请放心使用</p>', 1111111111);
-- ----------------------------
-- Table structure for think_login_log
-- ----------------------------
DROP TABLE IF EXISTS `think_login_log`;
CREATE TABLE `think_login_log` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '日志id',
`login_username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录管理员用户名',
`login_status` tinyint(1) UNSIGNED NOT NULL COMMENT '登录状态：1 登录成功 0 登录失败',
`login_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录时间',
`login_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录ip',
`login_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`login_client_os` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录客户端操作系统',
`login_client_browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录客户端浏览器',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员登录日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_login_log
-- ----------------------------
INSERT INTO `think_login_log` VALUES (1, 'admin', 1, 1602481168, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome85.0.4183.121');
INSERT INTO `think_login_log` VALUES (2, 'admin', 1, 1602552155, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome85.0.4183.121');
INSERT INTO `think_login_log` VALUES (3, 'admin', 1, 1602568071, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome85.0.4183.121');
INSERT INTO `think_login_log` VALUES (4, 'admin', 1, 1602653891, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome86.0.4240.75');
INSERT INTO `think_login_log` VALUES (5, 'admin', 1, 1603158756, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome86.0.4240.75');
INSERT INTO `think_login_log` VALUES (6, 'admin', 1, 1603416018, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome86.0.4240.111');
INSERT INTO `think_login_log` VALUES (7, 'admin', 1, 1603682445, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome86.0.4240.111');
INSERT INTO `think_login_log` VALUES (8, 'admin', 1, 1604303159, '127.0.0.1', '本机地址', 'Windows10.0', 'Chrome86.0.4240.111');
INSERT INTO `think_login_log` VALUES (9, 'admin', 1, 1604635659, '221.218.178.175', '北京市朝阳区联通', 'Windows10.0', 'Chrome86.0.4240.183');
INSERT INTO `think_login_log` VALUES (10, 'admin', 1, 1604635695, '221.218.178.175', '北京市朝阳区联通', 'Windows10.0', 'Chrome86.0.4240.183');
INSERT INTO `think_login_log` VALUES (11, 'admin', 1, 1604639308, '61.178.141.242', '甘肃省金昌市电信', 'Windows10.0', 'IE11.0');
INSERT INTO `think_login_log` VALUES (12, 'admin', 1, 1605176752, '117.157.108.218', '甘肃省移动', 'Windows10.0', 'IE11.0');
INSERT INTO `think_login_log` VALUES (13, 'admin', 1, 1606197957, '124.64.62.47', '北京市联通', 'Windows10.0', 'Chrome86.0.4240.198');
INSERT INTO `think_login_log` VALUES (14, 'admin', 1, 1606197994, '124.64.62.47', '北京市联通', 'Windows10.0', 'Chrome87.0.4280.66');
INSERT INTO `think_login_log` VALUES (15, 'admin', 1, 1607657077, '114.245.147.1', '北京市联通', 'Windows10.0', 'Chrome87.0.4280.88');
INSERT INTO `think_login_log` VALUES (16, 'admin', 1, 1607931059, '114.245.147.1', '北京市联通', 'Windows10.0', 'Chrome87.0.4280.88');
-- ----------------------------
-- Table structure for think_node
-- ----------------------------
DROP TABLE IF EXISTS `think_node`;
CREATE TABLE `think_node` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '节点id',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '节点名称',
`path` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '节点路径',
`pid` int(11) UNSIGNED NOT NULL COMMENT '所属节点id',
`sort` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
`is_menu` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否是菜单项 1 不是 2 是',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态：1 启用 0 禁用',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限节点表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_node
-- ----------------------------
INSERT INTO `think_node` VALUES (1, '后台主页', '#', 0, 0, 'iconfont zspicon-shouye_shouye', 2, 0, 1580472462, 1580614379);
INSERT INTO `think_node` VALUES (2, '后台首页', 'index/home', 1, 0, 'iconfont zspicon-shouye_shouye', 1, 1, 1580472462, 1581130960);
INSERT INTO `think_node` VALUES (3, '修改密码', 'index/editPassword', 1, 0, 'iconfont zspicon-xiugaimima', 1, 1, 1580472462, 1581130888);
INSERT INTO `think_node` VALUES (4, '权限管理', '#', 0, 0, 'iconfont zspicon-quanxian-copy-copy', 2, 1, 1580472462, 1580550491);
INSERT INTO `think_node` VALUES (5, '角色管理', 'role/index', 4, 0, 'iconfont zspicon-jiaoseguanli1', 2, 1, 1580486519, 1580550514);
INSERT INTO `think_node` VALUES (6, '添加角色', 'role/add', 5, 0, '', 1, 1, 1580486586, 1580486586);
INSERT INTO `think_node` VALUES (7, '编辑角色', 'role/edit', 5, 0, '', 1, 1, 1580486613, 1580784774);
INSERT INTO `think_node` VALUES (8, '删除角色', 'role/del', 5, 0, '', 1, 1, 1580486637, 1580784782);
INSERT INTO `think_node` VALUES (9, '角色授权', 'role/auth', 5, 0, '', 1, 1, 1580486773, 1580486773);
INSERT INTO `think_node` VALUES (10, '节点管理', 'node/index', 4, 0, 'iconfont zspicon-quanxian', 2, 1, 1580487561, 1580552841);
INSERT INTO `think_node` VALUES (11, '添加节点', 'node/add', 10, 0, '', 1, 1, 1580487581, 1580487581);
INSERT INTO `think_node` VALUES (12, '编辑节点', 'node/edit', 10, 0, '', 1, 1, 1580487606, 1580487606);
INSERT INTO `think_node` VALUES (13, '删除节点', 'node/del', 10, 0, '', 1, 1, 1580487622, 1580487622);
INSERT INTO `think_node` VALUES (14, '管理员管理', 'admin/index', 4, 0, 'iconfont zspicon-guanliyuan', 2, 1, 1580524112, 1580552858);
INSERT INTO `think_node` VALUES (15, '添加管理员', 'admin/add', 14, 0, '', 1, 1, 1580524130, 1580524130);
INSERT INTO `think_node` VALUES (16, '编辑管理员', 'admin/edit', 14, 0, '', 1, 1, 1580524144, 1580524144);
INSERT INTO `think_node` VALUES (17, '删除管理员', 'admin/del', 14, 0, '', 1, 1, 1580524188, 1580524188);
INSERT INTO `think_node` VALUES (18, '日志管理', '#', 0, 0, 'iconfont zspicon-wenzhang2', 2, 1, 1580536346, 1580553039);
INSERT INTO `think_node` VALUES (19, '登录日志', 'loginlog/index', 18, 0, 'iconfont zspicon-rizhi', 2, 1, 1580536578, 1580826890);
INSERT INTO `think_node` VALUES (23, '医院管理', '#', 0, 0, 'iconfont zspicon-process', 2, 1, 1602481258, 1602481258);
INSERT INTO `think_node` VALUES (24, '医院介绍', 'hospital/index', 23, 0, 'iconfont zspicon-chanpinku', 2, 1, 1602481453, 1602482152);
INSERT INTO `think_node` VALUES (25, '设备管理', '#', 0, 0, 'iconfont zspicon-houqiweihuweihuweihuguanli', 2, 1, 1602481577, 1602481577);
INSERT INTO `think_node` VALUES (26, '医院设备', 'device/index', 25, 0, 'iconfont zspicon-houqiweihuweihuweihuguanli', 2, 1, 1602481679, 1602483176);
INSERT INTO `think_node` VALUES (27, '添加设备', 'device/add', 26, 0, '', 1, 1, 1602481705, 1602481705);
INSERT INTO `think_node` VALUES (28, '编辑设备', 'device/edit', 26, 0, '', 1, 1, 1602481732, 1602481732);
INSERT INTO `think_node` VALUES (29, '删除设备', 'device/del', 26, 0, '', 1, 1, 1602481750, 1602481750);
INSERT INTO `think_node` VALUES (30, '科室管理', '#', 0, 0, 'iconfont zspicon-permission', 2, 1, 1602481862, 1602481862);
INSERT INTO `think_node` VALUES (31, '科室', 'section/index', 30, 0, 'iconfont zspicon-permission', 2, 1, 1602481910, 1602483183);
INSERT INTO `think_node` VALUES (32, '添加科室', 'section/add', 31, 0, '', 1, 1, 1602481940, 1602481940);
INSERT INTO `think_node` VALUES (33, '编辑科室', 'section/edit', 31, 0, NULL, 1, 1, 1602481940, 1602481940);
INSERT INTO `think_node` VALUES (34, '删除科室', 'section/del', 31, 0, NULL, 1, 1, 1602481940, 1602481940);
INSERT INTO `think_node` VALUES (35, '医疗特点介绍', 'traits/index', 23, 0, 'iconfont zspicon-gexinghua', 2, 1, 1602482142, 1602482189);
INSERT INTO `think_node` VALUES (36, '就诊指南', 'help/index', 23, 0, 'iconfont zspicon-help1', 2, 1, 1602483158, 1602483158);
INSERT INTO `think_node` VALUES (37, '专家管理', '#', 0, 0, 'iconfont zspicon-yonghuzhongxin', 2, 1, 1602483335, 1602483335);
INSERT INTO `think_node` VALUES (38, '专家', 'expert/index', 37, 0, 'iconfont zspicon-yonghuzhongxin', 2, 1, 1602483353, 1602483353);
INSERT INTO `think_node` VALUES (39, '添加专家', 'expert/add', 38, 0, NULL, 1, 1, 1602483353, 1602483353);
INSERT INTO `think_node` VALUES (40, '编辑专家', 'expert/edit', 38, 0, NULL, 1, 1, 1602483353, 1602483353);
INSERT INTO `think_node` VALUES (41, '删除专家', 'expert/del', 38, 0, NULL, 1, 1, 1602483353, 1602483353);
INSERT INTO `think_node` VALUES (42, '药品管理', '#', 0, 0, 'iconfont zspicon-fuwu4', 2, 1, 1602484285, 1602484285);
INSERT INTO `think_node` VALUES (43, '药品', 'drug/index', 42, 0, 'iconfont zspicon-fuwu4', 2, 1, 1602484359, 1602484359);
INSERT INTO `think_node` VALUES (44, '添加药品', 'drug/add', 43, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (45, '编辑药品', 'drug/edit', 43, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (46, '删除药品', 'drug/del', 43, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (47, '项目管理', '#', 0, 0, 'iconfont zspicon-file', 2, 1, 1602484610, 1602484610);
INSERT INTO `think_node` VALUES (48, '项目', 'project/index', 47, 0, 'iconfont zspicon-file', 2, 1, 1602484652, 1602484652);
INSERT INTO `think_node` VALUES (49, '添加项目', 'project/add', 48, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (50, '编辑项目', 'project/edit', 48, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (51, '删除项目', 'project/del', 48, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (52, '知识管理', '#', 0, 0, 'iconfont zspicon-xueyuan1', 2, 1, 1602484915, 1602484915);
INSERT INTO `think_node` VALUES (53, '健康知识', 'health/index', 52, 0, 'iconfont zspicon-xueyuan1', 2, 1, 1602484963, 1602484963);
INSERT INTO `think_node` VALUES (54, '添加健康知识', 'health/add', 53, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (55, '编辑健康知识', 'health/edit', 53, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (56, '删除健康知识', 'health/del', 53, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (57, '疾病预防', 'disease/index', 52, 0, 'iconfont zspicon-xueyuan1', 2, 1, 1602485161, 1602485161);
INSERT INTO `think_node` VALUES (58, '添加疾病预防', 'disease/add', 57, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (59, '编辑疾病预防', 'disease/edit', 57, 0, NULL, 1, 1, 0, NULL);
INSERT INTO `think_node` VALUES (60, '删除疾病预防', 'disease/del', 57, 0, NULL, 1, 1, 0, NULL);
-- ----------------------------
-- Table structure for think_position
-- ----------------------------
DROP TABLE IF EXISTS `think_position`;
CREATE TABLE `think_position` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`floor` int(4) NULL DEFAULT NULL,
`div` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 235 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_position
-- ----------------------------
INSERT INTO `think_position` VALUES (1, 4, 'a', '434DR拍片室');
INSERT INTO `think_position` VALUES (2, 4, 'b', '设备');
INSERT INTO `think_position` VALUES (3, 4, 'c', '436妇科门诊检查室');
INSERT INTO `think_position` VALUES (4, 4, 'd', '438心电图检查室1');
INSERT INTO `think_position` VALUES (5, 4, 'e', '440心电图检查室2');
INSERT INTO `think_position` VALUES (6, 4, 'f', '442/444彩超检查室1/2');
INSERT INTO `think_position` VALUES (7, 4, 'g', '抽血');
INSERT INTO `think_position` VALUES (8, 4, 'h', '446健康管理中心办公室');
INSERT INTO `think_position` VALUES (9, 4, 'i', '448检查室3/4');
INSERT INTO `think_position` VALUES (10, 4, 'j', '452取材室');
INSERT INTO `think_position` VALUES (11, 4, 'k', '454标本室');
INSERT INTO `think_position` VALUES (12, 4, 'l', '456技术室');
INSERT INTO `think_position` VALUES (13, 4, 'm', '458病理接诊室');
INSERT INTO `think_position` VALUES (14, 4, 'n', '460医生办公室');
INSERT INTO `think_position` VALUES (15, 4, 'o', '462诊断室');
INSERT INTO `think_position` VALUES (16, 4, 'p', '楼梯间');
INSERT INTO `think_position` VALUES (17, 4, 'q', '441更衣室');
INSERT INTO `think_position` VALUES (18, 4, 'r', '443肺功能室');
INSERT INTO `think_position` VALUES (19, 4, 's', '445/447/449检查室1/检查室2/物理检查室');
INSERT INTO `think_position` VALUES (20, 4, 't', '451备品间');
INSERT INTO `think_position` VALUES (21, 4, 'u', '电梯');
INSERT INTO `think_position` VALUES (22, 4, 'v', '卫生间');
INSERT INTO `think_position` VALUES (23, 4, 'w', '楼梯间');
INSERT INTO `think_position` VALUES (24, 4, 'x', '432财务主任室');
INSERT INTO `think_position` VALUES (25, 4, 'y', '430财务室');
INSERT INTO `think_position` VALUES (26, 4, 'z', '428财务室');
INSERT INTO `think_position` VALUES (27, 4, 'aa', '426财务室');
INSERT INTO `think_position` VALUES (28, 4, 'ab', '410党员之家职工之家');
INSERT INTO `think_position` VALUES (29, 4, 'ac', '408康复治疗师(男)');
INSERT INTO `think_position` VALUES (30, 4, 'ad', '406康复治疗师(女)');
INSERT INTO `think_position` VALUES (31, 4, 'ae', '404门诊4康复医学科门诊');
INSERT INTO `think_position` VALUES (32, 4, 'af', '402护理专科门诊');
INSERT INTO `think_position` VALUES (33, 4, 'ag', '楼梯间');
INSERT INTO `think_position` VALUES (34, 4, 'ah', '401/403远程/门诊会诊中心');
INSERT INTO `think_position` VALUES (35, 4, 'ai', '405');
INSERT INTO `think_position` VALUES (36, 4, 'aj', '407后勤保障部主任');
INSERT INTO `think_position` VALUES (37, 4, 'ak', '409中医门诊3');
INSERT INTO `think_position` VALUES (38, 4, 'al', '411');
INSERT INTO `think_position` VALUES (39, 4, 'am', '413专家门诊3');
INSERT INTO `think_position` VALUES (40, 4, 'an', '415知名专家工作室');
INSERT INTO `think_position` VALUES (41, 4, 'ao', '417知名专家工作室');
INSERT INTO `think_position` VALUES (42, 4, 'ap', '419医务部');
INSERT INTO `think_position` VALUES (43, 4, 'aq', '421病案复印室');
INSERT INTO `think_position` VALUES (44, 4, 'ar', '423医院感染管理科');
INSERT INTO `think_position` VALUES (45, 4, 'as', '425门诊部主任');
INSERT INTO `think_position` VALUES (46, 4, 'at', '427质量管理控制科');
INSERT INTO `think_position` VALUES (47, 4, 'au', '暂无');
INSERT INTO `think_position` VALUES (48, 4, 'av', '楼梯间');
INSERT INTO `think_position` VALUES (49, 4, 'aw', '424医务部主任');
INSERT INTO `think_position` VALUES (50, 4, 'ax', '422质量管理控制科主任');
INSERT INTO `think_position` VALUES (51, 4, 'ay', '420医院管理科主任');
INSERT INTO `think_position` VALUES (52, 4, 'az', '418科研教学科主任');
INSERT INTO `think_position` VALUES (53, 4, 'ba', '416科研教学科');
INSERT INTO `think_position` VALUES (54, 4, 'bb', '412/414公共卫生科');
INSERT INTO `think_position` VALUES (55, 4, 'bc', '431治疗室');
INSERT INTO `think_position` VALUES (56, 4, 'bd', '433医保办公室');
INSERT INTO `think_position` VALUES (57, 4, 'be', '435健康管理中心主任');
INSERT INTO `think_position` VALUES (58, 4, 'bf', '437临床营养门诊计划生育协会之家');
INSERT INTO `think_position` VALUES (59, 4, 'bg', '439医生办公室');
INSERT INTO `think_position` VALUES (60, 4, 'bh', '卫生间');
INSERT INTO `think_position` VALUES (61, 4, 'bi', '电梯');
INSERT INTO `think_position` VALUES (62, 4, 'bj', '453检查室5');
INSERT INTO `think_position` VALUES (63, 4, 'bk', '楼梯间');
INSERT INTO `think_position` VALUES (64, 4, 'bl', '卫生间');
INSERT INTO `think_position` VALUES (65, 4, 'bm', '463病理资料室');
INSERT INTO `think_position` VALUES (66, 4, 'bn', '463备品间');
INSERT INTO `think_position` VALUES (67, 4, 'bo', '459免疫组化室');
INSERT INTO `think_position` VALUES (68, 4, 'bp', '457细胞室');
INSERT INTO `think_position` VALUES (69, 4, 'bq', '455病理科主任');
INSERT INTO `think_position` VALUES (70, 3, 'a', '女更衣室');
INSERT INTO `think_position` VALUES (71, 3, 'b', '主任办公室');
INSERT INTO `think_position` VALUES (72, 3, 'c', '楼梯间');
INSERT INTO `think_position` VALUES (73, 3, 'd', '男更衣室');
INSERT INTO `think_position` VALUES (74, 3, 'e', '试剂库');
INSERT INTO `think_position` VALUES (75, 3, 'f', '办公室');
INSERT INTO `think_position` VALUES (76, 3, 'g', 'HIT实验室');
INSERT INTO `think_position` VALUES (77, 3, 'h', '结核病实验室');
INSERT INTO `think_position` VALUES (78, 3, 'i', '微生物室');
INSERT INTO `think_position` VALUES (79, 3, 'j', '楼梯间');
INSERT INTO `think_position` VALUES (80, 3, 'k', '卫生间');
INSERT INTO `think_position` VALUES (81, 3, 'l', '消毒室');
INSERT INTO `think_position` VALUES (82, 3, 'm', 'PCR实验室');
INSERT INTO `think_position` VALUES (83, 3, 'n', '标本接收');
INSERT INTO `think_position` VALUES (84, 3, 'o', NULL);
INSERT INTO `think_position` VALUES (85, 3, 'p', '电梯');
INSERT INTO `think_position` VALUES (86, 3, 'q', '卫生间');
INSERT INTO `think_position` VALUES (87, 3, 'r', '楼梯间');
INSERT INTO `think_position` VALUES (88, 3, 's', '334印象科主任');
INSERT INTO `think_position` VALUES (89, 3, 't', '330阅片室（报告审核）/332阅片室(报告书写)');
INSERT INTO `think_position` VALUES (90, 3, 'u', '卫生间');
INSERT INTO `think_position` VALUES (91, 3, 'v', '电梯');
INSERT INTO `think_position` VALUES (92, 3, 'w', '329更衣室');
INSERT INTO `think_position` VALUES (93, 3, 'x', '327更衣室');
INSERT INTO `think_position` VALUES (94, 3, 'y', '318眼科检查室1');
INSERT INTO `think_position` VALUES (95, 3, 'aa', '318眼科检查室2');
INSERT INTO `think_position` VALUES (96, 3, 'ab', '329皮肤科门诊');
INSERT INTO `think_position` VALUES (97, 3, 'ac', '322');
INSERT INTO `think_position` VALUES (98, 3, 'ad', '324耳鼻咽喉头颅外科处置室');
INSERT INTO `think_position` VALUES (99, 3, 'ae', '326耳鼻咽喉头颅外科1耳鼻咽喉头颅外科专家门诊');
INSERT INTO `think_position` VALUES (100, 3, 'af', '328鼻内窥镜室');
INSERT INTO `think_position` VALUES (101, 3, 'ag', '楼梯间');
INSERT INTO `think_position` VALUES (102, 3, 'ah', '体检测听室多颅稳态检查室');
INSERT INTO `think_position` VALUES (103, 3, 'ai', '323测听室');
INSERT INTO `think_position` VALUES (104, 3, 'aj', '321耳鼻头颅外科2肝癌门诊');
INSERT INTO `think_position` VALUES (105, 3, 'ak', '317/319皮肤科治疗室');
INSERT INTO `think_position` VALUES (106, 3, 'al', '综合验光师室');
INSERT INTO `think_position` VALUES (107, 3, 'am', '313眼科处置室');
INSERT INTO `think_position` VALUES (108, 3, 'an', '311眼科专家门诊');
INSERT INTO `think_position` VALUES (109, 3, 'ao', '楼梯间');
INSERT INTO `think_position` VALUES (110, 3, 'ap', '302口腔特诊室');
INSERT INTO `think_position` VALUES (111, 3, 'aq', '304口腔数字影像室');
INSERT INTO `think_position` VALUES (112, 3, 'ar', '306口腔技工室');
INSERT INTO `think_position` VALUES (113, 3, 'as', '308口腔科主任医师办公室');
INSERT INTO `think_position` VALUES (114, 3, 'at', '310口腔科主任');
INSERT INTO `think_position` VALUES (115, 3, 'au', '312口腔综合室5/314口腔体检室');
INSERT INTO `think_position` VALUES (116, 3, 'av', '316更衣室');
INSERT INTO `think_position` VALUES (117, 3, 'aw', '301备品间');
INSERT INTO `think_position` VALUES (118, 3, 'ax', '303/305/307/309/口腔综合室1/2/3/4');
INSERT INTO `think_position` VALUES (119, 1, 'a', '中药房');
INSERT INTO `think_position` VALUES (120, 1, 'b', '直梯');
INSERT INTO `think_position` VALUES (121, 1, 'c', '挂号/收费');
INSERT INTO `think_position` VALUES (122, 1, 'd', '楼梯间');
INSERT INTO `think_position` VALUES (123, 1, 'e', '卫生间');
INSERT INTO `think_position` VALUES (124, 1, 'f', '配电箱');
INSERT INTO `think_position` VALUES (125, 1, 'g', '设备5');
INSERT INTO `think_position` VALUES (126, 1, 'h', '129DR口腔CT室');
INSERT INTO `think_position` VALUES (127, 1, 'i', '设备2/3');
INSERT INTO `think_position` VALUES (128, 1, 'j', '127胃肠造彩像');
INSERT INTO `think_position` VALUES (129, 1, 'k', '楼梯间');
INSERT INTO `think_position` VALUES (130, 1, 'l', '直梯');
INSERT INTO `think_position` VALUES (131, 1, 'm', '118640层CT室');
INSERT INTO `think_position` VALUES (132, 1, 'n', '设备1');
INSERT INTO `think_position` VALUES (133, 1, 'o', '120/122');
INSERT INTO `think_position` VALUES (134, 1, 'p', '设备4');
INSERT INTO `think_position` VALUES (135, 1, 'q', '124乳腺检查室');
INSERT INTO `think_position` VALUES (136, 1, 'r', '直梯');
INSERT INTO `think_position` VALUES (137, 1, 's', '西药房');
INSERT INTO `think_position` VALUES (138, 1, 't', '直梯');
INSERT INTO `think_position` VALUES (139, 1, 'u', '挂号/收费');
INSERT INTO `think_position` VALUES (140, 1, 'v', '卫生间');
INSERT INTO `think_position` VALUES (141, 1, 'w', '电梯');
INSERT INTO `think_position` VALUES (142, 1, 'x', '131楼诊室');
INSERT INTO `think_position` VALUES (143, 1, 'y', '设备室');
INSERT INTO `think_position` VALUES (144, 1, 'z', '1333T核磁共振室');
INSERT INTO `think_position` VALUES (145, 1, 'aa', '卫生间');
INSERT INTO `think_position` VALUES (146, 1, 'ab', '楼梯间');
INSERT INTO `think_position` VALUES (147, 1, 'ac', '直梯');
INSERT INTO `think_position` VALUES (148, 1, 'ad', '136备品间');
INSERT INTO `think_position` VALUES (149, 1, 'ae', '134维修室');
INSERT INTO `think_position` VALUES (150, 1, 'af', '132候诊室');
INSERT INTO `think_position` VALUES (151, 1, 'ag', '130值班室');
INSERT INTO `think_position` VALUES (152, 1, 'ah', '128层CT室');
INSERT INTO `think_position` VALUES (153, 1, 'ai', '设备6');
INSERT INTO `think_position` VALUES (154, 1, 'aj', '126更衣室');
INSERT INTO `think_position` VALUES (155, 1, 'ak', '卫生间');
INSERT INTO `think_position` VALUES (156, 1, 'al', '112/113/114便民药店');
INSERT INTO `think_position` VALUES (157, 1, 'am', '楼梯间');
INSERT INTO `think_position` VALUES (158, 1, 'an', '直梯');
INSERT INTO `think_position` VALUES (159, 1, 'ao', '123收发室');
INSERT INTO `think_position` VALUES (160, 1, 'ap', '121慢性病门诊便民门诊');
INSERT INTO `think_position` VALUES (161, 1, 'aq', '119母婴室');
INSERT INTO `think_position` VALUES (162, 1, 'ar', '117党员之家职工之家');
INSERT INTO `think_position` VALUES (163, 1, 'as', '115儿科专家门诊');
INSERT INTO `think_position` VALUES (164, 1, 'at', '113儿童门诊');
INSERT INTO `think_position` VALUES (165, 1, 'au', '111儿童保健门诊');
INSERT INTO `think_position` VALUES (166, 1, 'av', '109备品间');
INSERT INTO `think_position` VALUES (167, 1, 'aw', '107急诊外科诊室');
INSERT INTO `think_position` VALUES (168, 1, 'ax', '105急诊内科室');
INSERT INTO `think_position` VALUES (169, 1, 'ay', '103抢救室一');
INSERT INTO `think_position` VALUES (170, 1, 'az', '101警务室');
INSERT INTO `think_position` VALUES (171, 1, 'ba', '卫生间');
INSERT INTO `think_position` VALUES (172, 1, 'bb', '106门诊换药室');
INSERT INTO `think_position` VALUES (173, 1, 'bc', '104急诊手术室');
INSERT INTO `think_position` VALUES (174, 1, 'bd', '102护理站');
INSERT INTO `think_position` VALUES (175, 1, 'be', '楼梯间');
INSERT INTO `think_position` VALUES (176, 2, 'a', '楼梯间');
INSERT INTO `think_position` VALUES (177, 2, 'b', '卫生间');
INSERT INTO `think_position` VALUES (178, 2, 'c', '247备品间');
INSERT INTO `think_position` VALUES (179, 2, 'd', '243/245心里1/2');
INSERT INTO `think_position` VALUES (180, 2, 'e', '233/235/237/239/241彩超1/2/3/4/5');
INSERT INTO `think_position` VALUES (181, 2, 'f', '231印象科副主任');
INSERT INTO `think_position` VALUES (182, 2, 'g', '楼梯间');
INSERT INTO `think_position` VALUES (183, 2, 'h', NULL);
INSERT INTO `think_position` VALUES (184, 2, 'i', '224彩超6');
INSERT INTO `think_position` VALUES (185, 2, 'j', '226/228/230护理实训室');
INSERT INTO `think_position` VALUES (186, 2, 'k', '232值班室');
INSERT INTO `think_position` VALUES (187, 2, 'l', '楼梯间');
INSERT INTO `think_position` VALUES (188, 2, 'm', '卫生间');
INSERT INTO `think_position` VALUES (189, 2, 'n', '253门诊手术室');
INSERT INTO `think_position` VALUES (190, 2, 'o', '251影像科副主任');
INSERT INTO `think_position` VALUES (191, 2, 'p', '249妇科门诊宫颈疾病专科门诊');
INSERT INTO `think_position` VALUES (192, 2, 'q', '246吸氧室/肺血液检查室');
INSERT INTO `think_position` VALUES (193, 2, 'r', '244胎检室');
INSERT INTO `think_position` VALUES (194, 2, 's', '242产科门诊再生育服务查询门诊');
INSERT INTO `think_position` VALUES (195, 2, 't', '240妇产科专家门诊高危妊娠门诊不孕不育门诊');
INSERT INTO `think_position` VALUES (196, 2, 'u', '238肌电图室闹电图室');
INSERT INTO `think_position` VALUES (197, 2, 'v', '236疼痛门诊治疗室');
INSERT INTO `think_position` VALUES (198, 2, 'w', '234疼痛科门诊');
INSERT INTO `think_position` VALUES (199, 2, 'x', '卫生间');
INSERT INTO `think_position` VALUES (200, 2, 'y', '电梯');
INSERT INTO `think_position` VALUES (201, 2, 'z', '210呼吸与危重症医学科一/二');
INSERT INTO `think_position` VALUES (202, 2, 'aa', '212骨科门诊');
INSERT INTO `think_position` VALUES (203, 2, 'ab', '214专家门诊2');
INSERT INTO `think_position` VALUES (204, 2, 'ac', '216普外二科门诊');
INSERT INTO `think_position` VALUES (205, 2, 'ad', '218职业病门诊');
INSERT INTO `think_position` VALUES (206, 2, 'ae', '220意外一科门诊');
INSERT INTO `think_position` VALUES (207, 2, 'af', '222肝癌门诊感染性疾病科');
INSERT INTO `think_position` VALUES (208, 2, 'ag', '楼梯间');
INSERT INTO `think_position` VALUES (209, 2, 'ah', '229神经外科门诊心里咨询门诊');
INSERT INTO `think_position` VALUES (210, 2, 'ag', '227新店检查室');
INSERT INTO `think_position` VALUES (211, 2, 'aj', '225心血管内科门诊');
INSERT INTO `think_position` VALUES (212, 2, 'ak', '223专家门诊1');
INSERT INTO `think_position` VALUES (213, 2, 'al', '221中医门诊2中医泌尿男科门诊');
INSERT INTO `think_position` VALUES (214, 2, 'am', '219内分泌门诊血液风湿免疫门诊肾病门诊');
INSERT INTO `think_position` VALUES (215, 2, 'an', '217消化内科门诊');
INSERT INTO `think_position` VALUES (216, 2, 'ao', '215神经内科门诊');
INSERT INTO `think_position` VALUES (217, 2, 'ap', '213中医门诊1 中医儿科门诊');
INSERT INTO `think_position` VALUES (218, 2, 'aq', '楼梯间');
INSERT INTO `think_position` VALUES (219, 2, 'ar', '202医生办公室');
INSERT INTO `think_position` VALUES (220, 2, 'as', '204病房9-14');
INSERT INTO `think_position` VALUES (221, 2, 'at', '206病房3-8');
INSERT INTO `think_position` VALUES (222, 2, 'av', '卫生间');
INSERT INTO `think_position` VALUES (223, 2, 'aw', '201急诊科主任');
INSERT INTO `think_position` VALUES (224, 2, 'ax', '203病区15-16');
INSERT INTO `think_position` VALUES (225, 2, 'ay', '205护士值班室');
INSERT INTO `think_position` VALUES (226, 2, 'az', '207病房1-2');
INSERT INTO `think_position` VALUES (227, 2, 'ba', '209发热输液室');
INSERT INTO `think_position` VALUES (228, 2, 'bb', '211急诊输液室');
INSERT INTO `think_position` VALUES (229, 5, 'a', NULL);
INSERT INTO `think_position` VALUES (230, 5, 'b', '楼梯间');
INSERT INTO `think_position` VALUES (231, 5, 'c', '534学术报告厅');
INSERT INTO `think_position` VALUES (232, 5, 'd', '536计算机培训教室');
INSERT INTO `think_position` VALUES (233, 5, 'e', '538信息科主任');
INSERT INTO `think_position` VALUES (234, 5, 'f', '540信息科工作区');
-- ----------------------------
-- Table structure for think_project
-- ----------------------------
DROP TABLE IF EXISTS `think_project`;
CREATE TABLE `think_project` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '设备管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_project
-- ----------------------------
INSERT INTO `think_project` VALUES (1, '河北济康医院项目', '河北济康医院项目', '<p><span style=\"color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; white-space: normal;\">河北济康</span><span style=\"color: rgb(247, 49, 49); font-family: Arial, sans-serif; font-size: 13px; white-space: normal;\">医院项目</span></p>', 1602555341, 1602555341, 0, 100.00, 1);
-- ----------------------------
-- Table structure for think_role
-- ----------------------------
DROP TABLE IF EXISTS `think_role`;
CREATE TABLE `think_role` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色id',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
`rules` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色拥有的权限节点',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态：1 启用 0 禁用',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_role
-- ----------------------------
INSERT INTO `think_role` VALUES (1, '超级管理员', '#', 1, 1579881069, 1578035821);
-- ----------------------------
-- Table structure for think_section
-- ----------------------------
DROP TABLE IF EXISTS `think_section`;
CREATE TABLE `think_section` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
`create_time` int(11) NULL DEFAULT NULL,
`update_time` int(11) NULL DEFAULT NULL,
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '金额',
`status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用 1启用 0禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '设备管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_section
-- ----------------------------
INSERT INTO `think_section` VALUES (1, '内科', '内科', '<p><span style=\"color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 14px; text-align: justify; white-space: normal;\">内科</span></p>', 1602553916, 1602553916, 0, 100.00, 1);
INSERT INTO `think_section` VALUES (2, '李医生', '李医生', '<p>李医生</p>', 1602554112, 1602554112, 0, 100.00, 1);
-- ----------------------------
-- Table structure for think_traits
-- ----------------------------
DROP TABLE IF EXISTS `think_traits`;
CREATE TABLE `think_traits` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '描述',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '医疗特点介绍' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of think_traits
-- ----------------------------
INSERT INTO `think_traits` VALUES (1, '<p><img src=\"http://lui.cc/static/umeditor/php/upload/20201012/16024886321325.jpeg\"/>4</p>');
SET FOREIGN_KEY_CHECKS = 1;
|
Copyright © 2001-2024 The PHP Group