ming-can-api/database/migrations/20260814_create_capacity_load.sql

CREATE TABLE IF NOT EXISTS `fa_capacity_load` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(100) NOT NULL COMMENT '名称',
    `capacity` VARCHAR(100) NOT NULL COMMENT '产能',
    `percentage` DECIMAL(5,2) UNSIGNED NOT NULL COMMENT '百分比',
    `weigh` INT NOT NULL DEFAULT 0 COMMENT '排序',
    `createtime` BIGINT NULL DEFAULT NULL COMMENT '创建时间',
    `updatetime` BIGINT NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产能负载';

INSERT IGNORE INTO `fa_auth_rule`
(`type`, `pid`, `name`, `title`, `icon`, `url`, `condition`, `remark`, `ismenu`, `menutype`, `extend`, `py`, `pinyin`, `createtime`, `updatetime`, `weigh`, `status`)
VALUES
('file', 0, 'capacity_load', '产能负载', 'fa fa-bar-chart', '', '', '', 1, NULL, '', 'cnfz', 'channengfuza', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 'normal');

SET @capacity_load_pid = (SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'capacity_load' LIMIT 1);

INSERT IGNORE INTO `fa_auth_rule`
(`type`, `pid`, `name`, `title`, `icon`, `url`, `condition`, `remark`, `ismenu`, `menutype`, `extend`, `py`, `pinyin`, `createtime`, `updatetime`, `weigh`, `status`)
VALUES
('file', @capacity_load_pid, 'capacity_load/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 'normal'),
('file', @capacity_load_pid, 'capacity_load/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 'normal'),
('file', @capacity_load_pid, 'capacity_load/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 'normal'),
('file', @capacity_load_pid, 'capacity_load/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 'normal'),
('file', @capacity_load_pid, 'capacity_load/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 'normal');

SET @capacity_load_rules = (
    SELECT GROUP_CONCAT(`id` ORDER BY `id` SEPARATOR ',')
    FROM `fa_auth_rule`
    WHERE `name` IN ('capacity_load', 'capacity_load/index', 'capacity_load/add', 'capacity_load/edit', 'capacity_load/del', 'capacity_load/multi')
);
UPDATE `fa_auth_group`
SET `rules` = CONCAT_WS(',', NULLIF(CONVERT(`rules` USING utf8mb4), ''), CONVERT(@capacity_load_rules USING utf8mb4))
WHERE `id` = 2
  AND FIND_IN_SET(
      CONVERT(@capacity_load_pid USING utf8mb4) COLLATE utf8mb4_unicode_ci,
      CONVERT(`rules` USING utf8mb4) COLLATE utf8mb4_unicode_ci
  ) = 0;