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/add_wechat_token_fields.sql |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/sql/add_wechat_token_fields.sql b/sql/add_wechat_token_fields.sql
new file mode 100644
index 0000000..5c3c7dc
--- /dev/null
+++ b/sql/add_wechat_token_fields.sql
@@ -0,0 +1,9 @@
+-- 寰俊鐧诲綍token瀛樺偍瀛楁
+-- 鍦╯ys_user琛ㄦ柊澧炲瓨鍌ㄥ井淇ccess_token涓庤繃鏈熸椂闂寸殑瀛楁
+
+ALTER TABLE `sys_user`
+  ADD COLUMN `wechat_access_token` VARCHAR(1024) NULL COMMENT '寰俊AccessToken锛堢綉椤垫巿鏉冩垨鏈�杩戣幏鍙栵級' AFTER `wechat_nickname`,
+  ADD COLUMN `wechat_token_expires_at` DATETIME NULL COMMENT '寰俊AccessToken杩囨湡鏃堕棿' AFTER `wechat_access_token`;
+
+-- 绱㈠紩鍙�夛紙濡傞渶鎸塼oken鏌ヨ鎴栨竻鐞嗭級
+-- CREATE INDEX `idx_wechat_token_expire` ON `sys_user` (`wechat_token_expires_at`);

--
Gitblit v1.9.1