From af8cab142a6b15c06e131a8474574dd5b00df982 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期四, 04 十二月 2025 22:09:58 +0800
Subject: [PATCH] feat: 改造微信accesstoken存放在系统配置表中
---
sql/ry_20250417.sql | 32 ++++++++++++++++++++++++++++++--
1 files changed, 30 insertions(+), 2 deletions(-)
diff --git a/sql/ry_20250417.sql b/sql/ry_20250417.sql
index d6ee79f..20e843f 100644
--- a/sql/ry_20250417.sql
+++ b/sql/ry_20250417.sql
@@ -186,7 +186,8 @@
insert into sys_menu values('501', '鐧诲綍鏃ュ織', '108', '2', 'logininfor', 'monitor/logininfor/index', '', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, '鐧诲綍鏃ュ織鑿滃崟');
-- 鏂板鏈嶅姟鍗曡彍鍗�
insert into sys_menu values('2000', '鏈嶅姟鍗曠鐞�', '1', '10', 'serviceOrder', 'system/serviceOrder/index', '', 'serviceOrder', 1, 0, 'C', '0', '0', 'system:serviceOrder:list', 'service-order', 'admin', sysdate(), '', null, '鏈嶅姟鍗曠鐞嗚彍鍗�');
-
+--鏂板璁㈠崟璇︽儏
+insert into sys_menu values('2001', '鏈嶅姟鍗曠鐞�', '1', '10', 'serviceOrder', 'system/order/detail', '', 'serviceOrder', 1, 0, 'C', '0', '0', 'system:serviceOrder:detail', 'service-order', 'admin', sysdate(), '', null, '璁㈠崟璇︽儏');
-- 鐢ㄦ埛绠＄悊鎸夐挳
insert into sys_menu values('1000', '鐢ㄦ埛鏌ヨ', '100', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1001', '鐢ㄦ埛鏂板', '100', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
@@ -701,4 +702,31 @@
update_by varchar(64) default '' comment '鏇存柊鑰�',
update_time datetime comment '鏇存柊鏃堕棿',
primary key (column_id)
-) engine=innodb auto_increment=1 comment = '浠ｇ爜鐢熸垚涓氬姟琛ㄥ瓧娈�';
\ No newline at end of file
+) engine=innodb auto_increment=1 comment = '浠ｇ爜鐢熸垚涓氬姟琛ㄥ瓧娈�';
+
+
+-- ----------------------------
+-- 20銆佸鎴峰簲鐢ㄩ厤缃〃
+-- ----------------------------
+drop table if exists sys_client_app;
+create table sys_client_app (
+ app_id bigint(20) not null auto_increment comment '搴旂敤ID',
+ client_name varchar(50) not null comment '瀹㈡埛鍚嶇О',
+ app_key varchar(64) not null comment '搴旂敤鏍囪瘑',
+ security_key varchar(64) not null comment '瀹夊叏瀵嗛挜',
+ valid_start_time datetime comment '鏈夋晥鏈熷紑濮嬫椂闂�',
+ valid_end_time datetime comment '鏈夋晥鏈熺粨鏉熸椂闂�',
+ status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (app_id),
+ unique (app_key)
+) engine=innodb auto_increment=100 comment = '瀹㈡埛搴旂敤閰嶇疆琛�';
+
+-- ----------------------------
+-- 鍒濆鍖�-瀹㈡埛搴旂敤閰嶇疆琛ㄦ暟鎹�
+-- ----------------------------
\ No newline at end of file
--
Gitblit v1.9.1