From 2a9583fd376451ca77a0400af7f3a02d1b80e7f5 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期二, 24 六月 2025 18:04:34 +0800
Subject: [PATCH] 2025-06-24

---
 ltkj-admin/src/main/resources/sql/index.sql |    9 +++++++++
 1 files changed, 9 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..e9d0682 100644
--- a/ltkj-admin/src/main/resources/sql/index.sql
+++ b/ltkj-admin/src/main/resources/sql/index.sql
@@ -17,3 +17,12 @@
 
 # 鏌ョ湅鏈�澶х殑杩炴帴鏁�
 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;

--
Gitblit v1.8.0