forked from Gitlink/microservices
16 lines
954 B
SQL
16 lines
954 B
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `is_publish` tinyint(1) NULL DEFAULT 0 COMMENT '专区是否发布（0:未发布，1：已发布）' AFTER `sort`;
|
||
UPDATE `ruoyi-gitlink`.zone_detail set is_publish=1;
|
||
|
||
INSERT INTO `ruoyi-gitlink`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
|
||
`is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`,
|
||
`create_by`, `create_time`, `update_by`, `update_time`, `remark`)
|
||
VALUES (2177, '发布/下架专区', 2087, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:zoneDetail:publish', '#', 'admin','2023-06-21 14:21:36', '', NULL, '');
|
||
|
||
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2177);
|
||
|
||
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2177);
|
||
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1; |