0616-1

zhaowenxuan

2025-06-16 47ff4d8018d550a23ca81a964c226ec173326942

 ltkj-admin/src/main/resources/sql/index.sql

@@ -2,3 +2,43 @@
UPDATE ltkjpeisTest.tj_project a
    JOIN ltkjpeisTest.tj_project_beifen b ON b.pro_id = a.pro_id
    SET a.pro_default = b.pro_default,a.pro_scope = b.pro_scope,a.result_type = b.result_type;



# 查看数据库占用内存大小
SELECT table_schema AS 'Database',
       SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)'
FROM information_schema.tables
WHERE table_schema = 'ltkjpeis10'
GROUP BY table_schema;

# 查看设置中预设的数据库内存大小
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

# 查看最大的连接数
SHOW VARIABLES LIKE 'max_connections';

CREATE TABLE tj_report_special_project (
                                           id BIGINT PRIMARY KEY NOT NULL,
                                           pro_id BIGINT NOT NULL UNIQUE,
                                           template_key TINYINT(2) NOT NULL COMMENT '模板判断编号 根据编号走不同的生成模板类型',
                                           params TEXT NULL COMMENT '需要额外传递的参数'
) COMMENT '报告特殊项目';


-- 凌云数据
INSERT INTO tj_report_special_project VALUES(1623853479200546816,1862852701533012001,1,'{"dy":"4.0","xy":"4.0","title":"阳性参考值：","dystr":"DOB值：         ≥      ${dy}                HP-阳性","xystr":"                <      ${xy}                  正常","en":"DOB"}');


-- 县医院数据
INSERT INTO tj_report_special_project VALUES(1623853479200546817,1870371396991955967,1,'{"dy":"100","xy":"100","title":"参考值(DPM)：","dystr":"DPM值：         ≥      ${dy}                阳性","xystr":"                <      ${xy}                  阴性","en":"DPM"}');


SELECT * FROM tj_report_special_project;

-- 用户公告关联表
CREATE TABLE sys_notice_user (
                                 id BIGINT PRIMARY KEY NOT NULL,
                                 notice_id BIGINT NOT NULL,
                                 user_id BIGINT NOT NULL
);