1、database
1.1、创建之前删除旧DB
drop database if exists turbor
;
1.2、创建新DB
CREATE DATABASE /!32312 IF NOT EXISTS/turbor
/*!40100 DEFAULT CHARACTER SET utf8 */;
1.3、使用新DB
USE turbor
;
2、user
2.1、创建之前删除旧user
DROP USER if exists tff@’%’;
2.2、创建新user
create user ‘tff’@’%’ IDENTIFIED BY ‘tff2020’;
2.3、给新user赋权、指定密码、指定可远程访问
GRANT ALL ON turbor
.* TO tff
@%
;
2.4、刷新MySQL的系统权限相关表
flush privileges;
3、禁用外键约束
SET FOREIGN_KEY_CHECKS=0;
4、table
4.1、创建之前删除旧user
DROP TABLE IF EXISTS c_patient_preoperative_check
;
4.2、创建新user
CREATE TABLE c_patient_preoperative_check
(
ID
int NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
patient_id
int NOT NULL COMMENT ‘患者id’,
doctor_id
varchar(20) DEFAULT NULL COMMENT ‘医生id’,
is_skipped
int DEFAULT ‘0’ COMMENT ‘是否跳过了术前核对。0未跳过,1跳过了’,
create_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
creater
varchar(20) NOT NULL COMMENT ‘创建人’,
PRIMARY KEY (ID
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=‘患者对应的术前核对信息。\r\n主要记录是否跳过了手术核对信息’;