From 8ad07bd89eea15ea8ff9e0408616db290a96b131 Mon Sep 17 00:00:00 2001 From: wanglizhong <wlz> Date: 星期四, 01 五月 2025 10:13:54 +0800 Subject: [PATCH] feat:上传客户配置 --- sql/ry_20250417.sql | 29 ++++++++++++++++++++++++++++- 1 files changed, 28 insertions(+), 1 deletions(-) diff --git a/sql/ry_20250417.sql b/sql/ry_20250417.sql index d6ee79f..37e9a96 100644 --- a/sql/ry_20250417.sql +++ b/sql/ry_20250417.sql @@ -701,4 +701,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