From 46fa404d83317496cb7f7b36b62da7335d746da3 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 04 三月 2022 20:32:12 +0800
Subject: [PATCH] update 增加 mysql 字段格式化处理 防止关键字问题

---
 ruoyi-admin/src/main/resources/application.yml |   60 +++++++++++++++++++++++++++++++++++++++++++++---------------
 1 files changed, 45 insertions(+), 15 deletions(-)

diff --git a/ruoyi-admin/src/main/resources/application.yml b/ruoyi-admin/src/main/resources/application.yml
index ae361f4..b4bca39 100644
--- a/ruoyi-admin/src/main/resources/application.yml
+++ b/ruoyi-admin/src/main/resources/application.yml
@@ -5,7 +5,7 @@
   # 鐗堟湰
   version: ${ruoyi-vue-plus.version}
   # 鐗堟潈骞翠唤
-  copyrightYear: 2021
+  copyrightYear: 2022
   # 瀹炰緥婕旂ず寮�鍏�
   demoEnabled: true
   # 鑾峰彇ip鍦板潃寮�鍏�
@@ -79,6 +79,10 @@
   thymeleaf:
     # 灏嗙郴缁熸ā鏉挎斁缃埌鏈�鍓嶉潰 鍚﹀垯浼氫笌 springboot-admin 椤甸潰鍐茬獊
     template-resolver-order: 1
+  mvc:
+    pathmatch:
+      # 閫傞厤 boot 2.6 璺敱涓� springfox 鍏煎
+      matching-strategy: ANT_PATH_MATCHER
   jackson:
     # 鏃ユ湡鏍煎紡鍖�
     date-format: yyyy-MM-dd HH:mm:ss
@@ -91,24 +95,46 @@
       # 鍏佽瀵硅薄蹇界暐json涓笉瀛樺湪鐨勫睘鎬�
       fail_on_unknown_properties: false
 
-# token閰嶇疆
-token:
-  # 浠ょ墝鑷畾涔夋爣璇�
-  header: Authorization
-  # 浠ょ墝瀵嗛挜
-  secret: abcdefghijklmnopqrstuvwxyz
-  # 浠ょ墝鏈夋晥鏈燂紙榛樿30鍒嗛挓锛�
-  expireTime: 30
+# Sa-Token閰嶇疆
+sa-token:
+  # token鍚嶇О (鍚屾椂涔熸槸cookie鍚嶇О)
+  token-name: Authorization
+  # token鏈夋晥鏈� 璁句负涓�澶� (蹇呭畾杩囨湡) 鍗曚綅: 绉�
+  timeout: 86400
+  # token涓存椂鏈夋晥鏈� (鎸囧畾鏃堕棿鏃犳搷浣滃氨杩囨湡) 鍗曚綅: 绉�
+  activity-timeout: 1800
+  # 鏄惁鍏佽鍚屼竴璐﹀彿骞跺彂鐧诲綍 (涓簍rue鏃跺厑璁镐竴璧风櫥褰�, 涓篺alse鏃舵柊鐧诲綍鎸ゆ帀鏃х櫥褰�)
+  is-concurrent: true
+  # 鍦ㄥ浜虹櫥褰曞悓涓�璐﹀彿鏃讹紝鏄惁鍏辩敤涓�涓猼oken (涓簍rue鏃舵墍鏈夌櫥褰曞叡鐢ㄤ竴涓猼oken, 涓篺alse鏃舵瘡娆＄櫥褰曟柊寤轰竴涓猼oken)
+  is-share: false
+  # 鏄惁灏濊瘯浠庤姹備綋閲岃鍙杢oken
+  is-read-body: false
+  # 鏄惁灏濊瘯浠巋eader閲岃鍙杢oken
+  is-read-head: true
+  # 鏄惁灏濊瘯浠巆ookie閲岃鍙杢oken
+  is-read-cookie: false
+  # token鍓嶇紑
+  token-prefix: "Bearer"
+  # token椋庢牸
+  token-style: uuid
+  # jwt绉橀挜
+  jwt-secret-key: abcdefghijklmnopqrstuvwxyz
+  # 鏄惁杈撳嚭鎿嶄綔鏃ュ織
+  is-log: true
 
 # security閰嶇疆
 security:
-  # 鐧诲嚭璺緞
-  logout-url: /logout
-  # 鍖垮悕璺緞
-  anonymous:
+  # 鎺掗櫎璺緞
+  excludes:
     - /login
+    - /logout
     - /register
     - /captchaImage
+    # 闈欐�佽祫婧�
+    - /*.html
+    - /**/*.html
+    - /**/*.css
+    - /**/*.js
     # swagger 鏂囨。閰嶇疆
     - /doc.html
     - /swagger-resources/**
@@ -116,8 +142,6 @@
     - /*/api-docs
     # druid 鐩戞帶閰嶇疆
     - /druid/**
-  # 鐢ㄦ埛鏀捐
-  permit-all:
     # actuator 鐩戞帶閰嶇疆
     - /actuator
     - /actuator/**
@@ -186,6 +210,8 @@
       updateStrategy: NOT_NULL
       # 瀛楁楠岃瘉绛栫暐涔� select,鍦� select 鐨勬椂鍊欑殑瀛楁楠岃瘉绛栫暐鏃� wrapper 鏍规嵁鍐呴儴 entity 鐢熸垚鐨� where 鏉′欢
       where-strategy: NOT_NULL
+      # 瀵� mysql 鐨勫瓧娈靛仛鏍煎紡鍖� 闃叉鍑虹幇绯荤粺鍏抽敭瀛�
+      column-format: "`%s`"
 
 # Swagger閰嶇疆
 swagger:
@@ -217,6 +243,10 @@
   enable: true
   # 鏄惁寮�鍚敓浜х幆澧冧繚鎶ょ瓥鐣�
   production: @knife4j.production@
+  basic:
+    enable: true
+    username: ruoyi
+    password: 123456
   # 鍓嶇Ui鐨勪釜鎬у寲閰嶇疆灞炴��
   setting:
     # 榛樿璇█

--
Gitblit v1.9.3