From ec2bd151a3220b34eb7e33d43d25908b45ff349c Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期一, 24 二月 2025 17:59:08 +0800
Subject: [PATCH] sql记录

---
 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