From a1808ba0ff1ccc2efacb69c1033054dbaab8687f Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 10 七月 2025 17:57:16 +0800
Subject: [PATCH] 2025-07-10
---
ltkj-admin/src/main/resources/sql/index.sql | 40 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 40 insertions(+), 0 deletions(-)
diff --git a/ltkj-admin/src/main/resources/sql/index.sql b/ltkj-admin/src/main/resources/sql/index.sql
index d2f9fac..04663a2 100644
--- a/ltkj-admin/src/main/resources/sql/index.sql
+++ b/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
+);
--
Gitblit v1.8.0