| | |
| | | public class SysOssConfig extends BaseEntity { |
| | | |
| | | /** |
| | | * 主建 |
| | | * 主键 |
| | | */ |
| | | @TableId(value = "oss_config_id") |
| | | private Long ossConfigId; |
| | |
| | | public class SysOssConfigBo extends BaseEntity { |
| | | |
| | | /** |
| | | * 主建 |
| | | * 主键 |
| | | */ |
| | | @NotNull(message = "主建不能为空", groups = {EditGroup.class}) |
| | | @NotNull(message = "主键不能为空", groups = {EditGroup.class}) |
| | | private Long ossConfigId; |
| | | |
| | | /** |
| | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 主建 |
| | | * 主键 |
| | | */ |
| | | private Long ossConfigId; |
| | | |
| | |
| | | alter table sys_oss_config add constraint pk_sys_oss_config primary key (oss_config_id); |
| | | |
| | | comment on table sys_oss_config is '对象存储配置表'; |
| | | comment on column sys_oss_config.oss_config_id is '主建'; |
| | | comment on column sys_oss_config.oss_config_id is '主键'; |
| | | comment on column sys_oss_config.tenant_id is '租户编码'; |
| | | comment on column sys_oss_config.config_key is '配置key'; |
| | | comment on column sys_oss_config.access_key is 'accesskey'; |
| | |
| | | alter table sys_client add constraint pk_sys_client primary key (id); |
| | | |
| | | comment on table sys_client is '系统授权表'; |
| | | comment on column sys_client.id is '主建'; |
| | | comment on column sys_client.id is '主键'; |
| | | comment on column sys_client.client_id is '客户端id'; |
| | | comment on column sys_client.client_key is '客户端key'; |
| | | comment on column sys_client.client_secret is '客户端秘钥'; |
| | |
| | | ); |
| | | |
| | | comment on table sys_oss_config is '对象存储配置表'; |
| | | comment on column sys_oss_config.oss_config_id is '主建'; |
| | | comment on column sys_oss_config.oss_config_id is '主键'; |
| | | comment on column sys_oss_config.tenant_id is '租户编码'; |
| | | comment on column sys_oss_config.config_key is '配置key'; |
| | | comment on column sys_oss_config.access_key is 'accessKey'; |
| | |
| | | ); |
| | | |
| | | comment on table sys_client is '系统授权表'; |
| | | comment on column sys_client.id is '主建'; |
| | | comment on column sys_client.id is '主键'; |
| | | comment on column sys_client.client_id is '客户端id'; |
| | | comment on column sys_client.client_key is '客户端key'; |
| | | comment on column sys_client.client_secret is '客户端秘钥'; |
| | |
| | | -- OSS对象存储动态配置表 |
| | | -- ---------------------------- |
| | | create table sys_oss_config ( |
| | | oss_config_id bigint(20) not null comment '主建', |
| | | oss_config_id bigint(20) not null comment '主键', |
| | | tenant_id varchar(20) default '000000'comment '租户编号', |
| | | config_key varchar(20) not null default '' comment '配置key', |
| | | access_key varchar(255) default '' comment 'accessKey', |
| | |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'主建', |
| | | 'MS_Description', N'主键', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'sys_oss_config', |
| | | 'COLUMN', N'oss_config_id' |
| | |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'主建', |
| | | 'MS_Description', N'主键', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'sys_client', |
| | | 'COLUMN', N'id' |
| | |
| | | alter table sys_client add constraint pk_sys_client primary key (id); |
| | | |
| | | comment on table sys_client is '系统授权表'; |
| | | comment on column sys_client.id is '主建'; |
| | | comment on column sys_client.id is '主键'; |
| | | comment on column sys_client.client_id is '客户端id'; |
| | | comment on column sys_client.client_key is '客户端key'; |
| | | comment on column sys_client.client_secret is '客户端秘钥'; |
| | |
| | | ); |
| | | |
| | | comment on table sys_client is '系统授权表'; |
| | | comment on column sys_client.id is '主建'; |
| | | comment on column sys_client.id is '主键'; |
| | | comment on column sys_client.client_id is '客户端id'; |
| | | comment on column sys_client.client_key is '客户端key'; |
| | | comment on column sys_client.client_secret is '客户端秘钥'; |
| | |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'主建', |
| | | 'MS_Description', N'主键', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'sys_client', |
| | | 'COLUMN', N'id' |