From 6722e60ff25655ca00d88d070bdc5e918dd8dd0c Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期三, 23 七月 2025 14:04:17 +0800
Subject: [PATCH] sql记录
---
ltkj-admin/src/main/resources/sql/index.sql | 19 +++++++++++++------
ltkj-admin/src/main/resources/sql/陕健医.sql | 1 +
2 files changed, 14 insertions(+), 6 deletions(-)
diff --git a/ltkj-admin/src/main/resources/sql/index.sql b/ltkj-admin/src/main/resources/sql/index.sql
index e9d0682..fa39d19 100644
--- a/ltkj-admin/src/main/resources/sql/index.sql
+++ b/ltkj-admin/src/main/resources/sql/index.sql
@@ -18,11 +18,18 @@
# 鏌ョ湅鏈�澶х殑杩炴帴鏁�
SHOW VARIABLES LIKE 'max_connections';
-INSERT INTO sys_user(dept_id,user_name,nick_name,phonenumber,sex,password)
-
+# 涓嶅啀浣跨敤
+#INSERT INTO sys_user(dept_id,user_name,nick_name,phonenumber,sex,password)
# 闄曞仴鍖诲悓姝ヨ亴宸�
-SELECT 100 as dept,a.zhigonggh,a.zhigongxm,b.dianhua1,
- CASE WHEN b.xingbie = 1 THEN 0 WHEN b.xingbie = 2 THEN 1 ELSE 2 END,
+#SELECT 100 as dept,a.zhigonggh,a.zhigongxm,b.dianhua1,
+# CASE WHEN b.xingbie = 1 THEN 0 WHEN b.xingbie = 2 THEN 1 ELSE 2 END,
+# '$2a$10$Uxk6FG0EkaGhCGPfMd4qLezLO5RKKCEfwcHA7ppjgGYNgCjTsd5Iy' as pass
+#FROM `ltkj_shanxiqinsqyy_getzhigongpagezd` a JOIN ltkj_shanxiqinsqyy_getlistyishengzd b
+# ON a.zhigongid = b.zhigongid;
+
+# 涓嶅啀鍏宠仈鍖荤敓琛�
+INSERT INTO sys_user(dept_id,user_name,nick_name,password)
+# 闄曞仴鍖诲悓姝ヨ亴宸�
+SELECT 100 as dept,a.zhigonggh,a.zhigongxm,
'$2a$10$Uxk6FG0EkaGhCGPfMd4qLezLO5RKKCEfwcHA7ppjgGYNgCjTsd5Iy' as pass
-FROM `ltkj_shanxiqinsqyy_getzhigongpagezd` a JOIN ltkj_shanxiqinsqyy_getlistyishengzd b
- ON a.zhigongid = b.zhigongid;
+FROM `ltkj_shanxiqinxatlgcyy_getzhigongpagezd` a
diff --git "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
index 1ae5f96..92a606c 100644
--- "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
+++ "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
@@ -66,6 +66,7 @@
TRUNCATE TABLE tj_ask_historys;
TRUNCATE TABLE tj_ask_medical_history;
TRUNCATE TABLE tj_ask_work_log;
+TRUNCATE TABLE dict_user_info;
# 鏌ヨ鍓嶇紑鍊�
SELECT * FROM (
--
Gitblit v1.8.0