From 7e9ffbd3b45be78890442683b17742aa5bdccd2c Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 25 七月 2025 17:55:26 +0800
Subject: [PATCH] zjh20250725-3

---
 ltkj-admin/src/main/resources/sql/index.sql |   16 ++++++++++++++++
 1 files changed, 16 insertions(+), 0 deletions(-)

diff --git a/ltkj-admin/src/main/resources/sql/index.sql b/ltkj-admin/src/main/resources/sql/index.sql
index 04eaf6b..fa39d19 100644
--- a/ltkj-admin/src/main/resources/sql/index.sql
+++ b/ltkj-admin/src/main/resources/sql/index.sql
@@ -17,3 +17,19 @@
 
 # 鏌ョ湅鏈�澶х殑杩炴帴鏁�
 SHOW VARIABLES LIKE 'max_connections';
+
+# 涓嶅啀浣跨敤
+#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,
+#       '$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_shanxiqinxatlgcyy_getzhigongpagezd` a

--
Gitblit v1.8.0