1.优化定时任务表 2.客户配置

liding

2 天以前 c5a0fd76859064ec9efdaa0b4c585cf86da70e02

1.优化定时任务表 2.客户配置

 main-business/src/main/resources/db/migration/postgresql/V20250614134700__create_table_inspection_task.sql

@@ -3,13 +3,13 @@
(
    id            BIGSERIAL PRIMARY KEY,       -- ä»»åŠ¡ID (主键，自增长)
    task_name     VARCHAR(255),                -- ä»»åŠ¡åç§°
    inspector_id  BIGINT,                      -- å·¡æ£€äººå‘˜id
    inspector_id  VARCHAR(255),                      -- å·¡æ£€äººå‘˜id
    inspector     VARCHAR(100),                -- å·¡æ£€äººå‘˜
    port          TEXT,                        -- å·¡æ£€åœ°ç‚¹
    remarks       TEXT,                        -- å¤‡æ³¨è¯´æ˜Ž
    registrant_id BIGINT,                      -- ç™»è®°äººå‘˜id
    registrant    VARCHAR(100),                -- ç™»è®°äººå‘˜
    frequency_type     VARCHAR(100),           -- é¢‘次
    inspection_location     VARCHAR(255),           -- å·¡æ£€åœ°ç‚¹è¯¦ç»†æè¿°

    deleted       INT NOT NULL DEFAULT 0,      -- è½¯åˆ é™¤æ ‡å¿—：0=未删除，1=已删除
    create_by     VARCHAR(255),                -- åˆ›å»ºäººç”¨æˆ·å
@@ -29,13 +29,13 @@
COMMENT
ON COLUMN inspection_task.inspector IS '执行巡检的人员姓名';
COMMENT
ON COLUMN inspection_task.port IS '巡检地点详细描述';
COMMENT
ON COLUMN inspection_task.remarks IS '任务附加说明或特殊情况记录';
COMMENT
ON COLUMN inspection_task.registrant IS '任务登记人姓名';
COMMENT
ON COLUMN inspection_task.frequency_type IS '频次';
COMMENT
ON COLUMN inspection_task.inspection_location IS '巡检地点详细描述';

COMMENT
ON COLUMN inspection_task.deleted IS '软删除标志，0=未删除，1=已删除';

 ruoyi-admin/src/main/resources/application-zd.yml.example

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,76 @@
# æ•°æ®æºé…ç½®
spring:
    datasource:
        type: com.alibaba.druid.pool.DruidDataSource
#        driverClassName: com.mysql.cj.jdbc.Driver     # mysql驱动
        driverClassName: org.postgresql.Driver
        druid:
            # ä¸»åº“数据源
            master:
#                mysql
#                url: jdbc:mysql://124.220.0.228:3300/ruoyi-java?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
#                pg
                url: jdbc:postgresql://127.0.0.1:5432/zd_java
                username: postgres
                password: ZDadmin123!
            # ä»Žåº“数据源
            slave:
                # ä»Žæ•°æ®æºå¼€å…³/默认关闭
                enabled: false
                url:
                username:
                password:
            # åˆå§‹è¿žæŽ¥æ•°
            initialSize: 5
            # æœ€å°è¿žæŽ¥æ± æ•°é‡
            minIdle: 10
            # æœ€å¤§è¿žæŽ¥æ± æ•°é‡
            maxActive: 20
            # é…ç½®èŽ·å–连接等待超时的时间
            maxWait: 60000
            # é…ç½®è¿žæŽ¥è¶…时时间
            connectTimeout: 30000
            # é…ç½®ç½‘络超时时间
            socketTimeout: 60000
            # é…ç½®é—´éš”多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
            timeBetweenEvictionRunsMillis: 60000
            # é…ç½®ä¸€ä¸ªè¿žæŽ¥åœ¨æ± ä¸­æœ€å°ç”Ÿå­˜çš„时间，单位是毫秒
            minEvictableIdleTimeMillis: 300000
            # é…ç½®ä¸€ä¸ªè¿žæŽ¥åœ¨æ± ä¸­æœ€å¤§ç”Ÿå­˜çš„时间，单位是毫秒
            maxEvictableIdleTimeMillis: 900000
            # é…ç½®æ£€æµ‹è¿žæŽ¥æ˜¯å¦æœ‰æ•ˆ
            validationQuery: SELECT VERSION()
            testWhileIdle: true
            testOnBorrow: false
            testOnReturn: false
            webStatFilter: 
                enabled: true
            statViewServlet:
                enabled: true
                # è®¾ç½®ç™½åå•ï¼Œä¸å¡«åˆ™å…è®¸æ‰€æœ‰è®¿é—®
                allow:
                url-pattern: /druid/*
                # æŽ§åˆ¶å°ç®¡ç†ç”¨æˆ·åå’Œå¯†ç 
                login-username: ruoyi
                login-password: 123456
            filter:
                stat:
                    enabled: true
                    # æ…¢SQL记录
                    log-slow-sql: true
                    slow-sql-millis: 1000
                    merge-sql: true
                wall:
                    config:
                        multi-statement-allow: true

# å®¢æˆ·æœåŠ¡å™¨ minio
minio:
    endpoint: 127.0.0.1
    port: 9000
    secure: false
    accessKey: admin
    secretKey: Admin123456@
    preview-expiry: 24 # é¢„览地址默认24小时
    default-bucket: zd-file #  é»˜è®¤å­˜å‚¨æ¡¶