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';