From cc2624d08e422c36a4f93cc15d0ca0f0b7b4951a Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期一, 17 一月 2022 15:46:28 +0800 Subject: [PATCH] update 优化加载字典缓存数据 --- script/sql/ry_20210908.sql | 14 +++++++------- 1 files changed, 7 insertions(+), 7 deletions(-) diff --git a/script/sql/ry_20210908.sql b/script/sql/ry_20210908.sql index 4df76f6..e7012e7 100644 --- a/script/sql/ry_20210908.sql +++ b/script/sql/ry_20210908.sql @@ -14,7 +14,7 @@ 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 '鍒涘缓鏃堕棿', + create_time datetime comment '鍒涘缓鏃堕棿', update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', primary key (dept_id) @@ -82,7 +82,7 @@ status char(1) not null comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', create_by varchar(64) default '' comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', - update_by varchar(64) default '' comment '鏇存柊鑰�', + update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (post_id) @@ -600,7 +600,7 @@ gen_path varchar(200) default '/' comment '鐢熸垚璺緞锛堜笉濉粯璁ら」鐩矾寰勶級', options varchar(1000) comment '鍏跺畠鐢熸垚閫夐」', create_by varchar(64) default '' comment '鍒涘缓鑰�', - create_time datetime comment '鍒涘缓鏃堕棿', + create_time datetime comment '鍒涘缓鏃堕棿', update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', @@ -632,7 +632,7 @@ dict_type varchar(200) default '' comment '瀛楀吀绫诲瀷', sort int comment '鎺掑簭', create_by varchar(64) default '' comment '鍒涘缓鑰�', - create_time datetime comment '鍒涘缓鏃堕棿', + create_time datetime comment '鍒涘缓鏃堕棿', update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', primary key (column_id) @@ -644,10 +644,10 @@ drop table if exists sys_oss; create table sys_oss ( oss_id bigint(20) not null auto_increment comment '瀵硅薄瀛樺偍涓婚敭', - file_name varchar(64) not null default '' comment '鏂囦欢鍚�', - original_name varchar(64) not null default '' comment '鍘熷悕', + file_name varchar(255) not null default '' comment '鏂囦欢鍚�', + original_name varchar(255) not null default '' comment '鍘熷悕', file_suffix varchar(10) not null default '' comment '鏂囦欢鍚庣紑鍚�', - url varchar(200) not null comment 'URL鍦板潃', + url varchar(500) not null comment 'URL鍦板潃', create_time datetime default null comment '鍒涘缓鏃堕棿', create_by varchar(64) default '' comment '涓婁紶浜�', update_time datetime default null comment '鏇存柊鏃堕棿', -- Gitblit v1.9.3