CREATE TABLE IF NOT EXISTS `t_general_screen_content` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`partner_id` int NOT NULL COMMENT '合作商ID',
|
`screen_title` varchar(20) NOT NULL COMMENT '大屏名称',
|
`overview_title` varchar(20) NOT NULL COMMENT '数据概览标题',
|
`utilization_title` varchar(20) NOT NULL COMMENT '充电利用率标题',
|
`income_title` varchar(20) NOT NULL COMMENT '电站收入分析标题',
|
`battery_safety_title` varchar(20) NOT NULL COMMENT '电池安全检测标题',
|
`charging_power_title` varchar(20) NOT NULL COMMENT '充电功率曲线标题',
|
`charge_status_title` varchar(20) NOT NULL COMMENT '充电情况标题',
|
`pile_status_title` varchar(20) NOT NULL COMMENT '桩情况标题',
|
`power_status_title` varchar(20) NOT NULL COMMENT '功率情况标题',
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `uk_general_screen_partner` (`partner_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通用大屏内容设置';
|
|
SET @content_setting_id := (
|
SELECT menu_id FROM sys_menu WHERE menu_name = '内容设置' ORDER BY menu_id LIMIT 1
|
);
|
|
INSERT INTO sys_menu
|
(menu_name, parent_id, order_num, path, component, is_frame, is_cache,
|
menu_type, visible, status, perms, icon, create_by, create_time, remark)
|
SELECT '通用大屏内容设置', @content_setting_id, 6, '/contentSetting/generalScreen',
|
'contentSetting/generalScreen', 1, 0, 'C', '0', '0',
|
'/generalScreenContentSetting', '#', 'admin', NOW(), '通用大屏标题设置'
|
WHERE @content_setting_id IS NOT NULL
|
AND NOT EXISTS (
|
SELECT 1 FROM sys_menu WHERE perms = '/generalScreenContentSetting'
|
);
|
|
INSERT IGNORE INTO sys_role_menu (role_id, menu_id)
|
SELECT 1, menu_id FROM sys_menu WHERE perms = '/generalScreenContentSetting';
|
