| 1234567891011121314151617181920 |
- USE teachcloud_db;
- ALTER TABLE `basic_operation_log`
- DROP COLUMN `user_name`,
- DROP COLUMN `return_value`,
- DROP COLUMN `run_time`,
- DROP COLUMN `method`,
- DROP COLUMN `clazz_name`,
- DROP COLUMN `system_type`,
- DROP COLUMN `operation_unit`,
- DROP COLUMN `customized_operation_type`,
- DROP COLUMN `level`,
- DROP COLUMN `org_id`,
- ADD COLUMN `function_name` VARCHAR(100) NULL COMMENT '操作名称' AFTER `operation_type`,
- CHANGE COLUMN `privilege_id` `privilege_id` BIGINT NULL DEFAULT NULL COMMENT '权限菜单id' AFTER `school_id`,
- CHANGE COLUMN `detail` `detail` MEDIUMTEXT CHARACTER SET 'utf8mb4' NULL COMMENT '日志详情' AFTER `url`,
- CHANGE COLUMN `operation_type` `operation_type` VARCHAR(32) CHARACTER SET 'utf8mb4' NULL DEFAULT NULL COMMENT '操作类型（OTHER(“其它”),SELECT(\"查询\"),EDIT(\"新增或更新\"),DELETE(\"删除\")）' ,
- DROP INDEX `operation_log_idx` ,
- ADD INDEX `operation_log_idx` USING BTREE (`school_id`, `privilege_id`, `user_id`, `create_time`) VISIBLE;
- ;
|
