• Home
• com.github.rexsheng
• springboot-faster-system
• 1.1.6
• source code
• 1.1.6.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.patch.1.1.6.sql Maven / Gradle / Ivy

ALTER TABLE `sys_user` ADD COLUMN `account_expired_time`  datetime DEFAULT NULL COMMENT '账号过期时间' AFTER `last_password_time`;
ALTER TABLE `sys_user` ADD COLUMN `account_locked_time`  datetime DEFAULT NULL COMMENT '账号锁定截止时间' AFTER `account_expired_time`;
ALTER TABLE `sys_user` ADD COLUMN `password_expired_time`  datetime DEFAULT NULL COMMENT '密码过期时间' AFTER `account_locked_time`;

INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('55', 'system:user:expire', '设置有效期', '1', NULL, NULL, NULL, '2', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('56', 'system:user:lock', '锁定', '1', NULL, NULL, NULL, '2', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('57', 'system:user:offline', '下线', '1', NULL, NULL, NULL, '2', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);

insert into ACT_GE_SCHEMA_LOG
values ('1100', CURRENT_TIMESTAMP, '7.22.0');

alter table ACT_RU_TASK add column TASK_STATE_ varchar(64);

alter table ACT_HI_TASKINST add column TASK_STATE_ varchar(64);

alter table ACT_RU_JOB add column BATCH_ID_ varchar(64);
alter table ACT_HI_JOB_LOG add column BATCH_ID_ varchar(64);

alter table ACT_HI_PROCINST add RESTARTED_PROC_INST_ID_ varchar(64);
create index ACT_IDX_HI_PRO_RST_PRO_INST_ID on ACT_HI_PROCINST(RESTARTED_PROC_INST_ID_);