30 lines
1.7 KiB
SQL
30 lines
1.7 KiB
SQL
INSERT INTO `report-library`.`ts_config` (`id`, `config_key`, `config_value`) VALUES ('AVWQEDW2', 'SET_GRAY', '0');
|
|
UPDATE `report-library`.`ts_menu` SET `DEL_FLAG` = 0, `NAME` = '基础设置', `PARENT_ID` = 'AVL9YSB7ZF', `PARENT_IDS` = 'null6f6fafb4a7,3HPUHGTHWX,AEHJB8YNJ3,', `HREF` = '/basemes/setting', `ICON` = '', `IS_SHOW` = 1, `PERMISSION` = NULL, `REMARKS` = '', `SORT` = '5', `EXT_INFO` = NULL, `ICONHREF` = '', `ICONCLICK` = NULL, `ICONCLICKHREF` = NULL, `IS_URL` = '0', `IS_BUTTON` = '0' WHERE `ID` = '49QS25EHCD';
|
|
INSERT INTO `report-library`.`tr_role_menu` (`ROLE_ID`, `MENU_ID`) VALUES ('35LLRCAQ8D', '49QS25EHCD');
|
|
|
|
ALTER TABLE `report-library`.`ts_report_content`
|
|
ADD INDEX `REPORT_CONTENT_REPORT_ID_INDEX`(`report_id`) USING BTREE;
|
|
|
|
ALTER TABLE `report-library`.`tt_report_manage`
|
|
ADD INDEX `REPORT_MANAGER_CREATEUSERID_INDEX`(`createUserId`) USING BTREE;
|
|
|
|
ALTER TABLE `report-library`.`tt_report_manage`
|
|
ADD COLUMN `consultingProject` varchar(1000) NULL COMMENT '咨询项目' AFTER `privacyLevel`;
|
|
|
|
ALTER TABLE `report-library`.`tt_report_manage_act`
|
|
ADD COLUMN `consultingProject` varchar(1000) NULL COMMENT '咨询项目' AFTER `privacyLevel`;
|
|
|
|
ALTER TABLE `report-library`.`ts_report_user_rating`
|
|
ADD INDEX `RATING_REPORT_ID`(`report_id`) USING BTREE;
|
|
|
|
ALTER TABLE `report-library`.`bus_process_name`
|
|
ADD INDEX `PROCESS_NAME_DATA_ID`(`DATA_ID`) USING BTREE;
|
|
|
|
ALTER TABLE `report-library`.`report_log_book`
|
|
ADD INDEX `LOG_BOOK_REPORT_ID`(`report_id`) USING BTREE;
|
|
|
|
ALTER TABLE `report-library`.`report_log_book`
|
|
ADD INDEX `LOG_BOOK_TYPE`(`type`) USING BTREE;
|
|
|
|
ALTER TABLE `report-library`.`ts_report_file`
|
|
ADD INDEX `FILE_REPROT_FILE`(`report_id`) USING BTREE; |