INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`,
                         `is_open`, `remark`, `is_deleted`, `belong_application`, `keep_alive`)
VALUES (1584363919958806529, 0, 'FMS', '柔性线生产Fms', 'FMS', '', 'iconfont saber-shikuang', 5, 0, 0, 1, '', 0, 'CPS', 1),
       (1584366536134955010, 1584363919958806529, 'cps_workorder', '工单', 'cps_workorder', '/fms/work-order/index',
        'iconfont saber-gongdan1', 1, 1, 0, 1, '', 0, 'CPS', 1),
       (1584367046896324609, 1584363919958806529, 'fms_live', '调度实况', 'fms_live', '/fms/live/index',
        'iconfont saber-shikuang1', 2, 1, 0, 1, '', 0, 'CPS', 1),
       (1585097946642714625, 1584363919958806529, 'production_statistics', '生产统计', 'production_statistics',
        '/fms/production-statistics/index',
        '', 3, 1, 0, 2, '', 0, 'CPS', 1),
       (1585098719174791169, 1584363919958806529, 'equipment_analysis', '设备分析', 'equipment_analysis',
        '/fms/equipment-analysis/index',
        '', 4, 1, 0, 1, '', 0, 'CPS', 1);

DROP TABLE IF EXISTS `blade_fms_order`;
CREATE TABLE `blade_fms_order`
(
    `id`                 bigint(20)                                                    NOT NULL COMMENT '主键',
    `code`               varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工单编号',
    `order_code`         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '订单编号',
    `order_type`         int(1)                                                        NULL DEFAULT NULL COMMENT '工单类型  1.来料  2.生产',
    `order_status`       int(11)                                                       NULL DEFAULT NULL COMMENT '工单状态 待发布 0 待加工 1 加工中 2 暂停中 3 暂停 4 已完成 5',
    `assign_num`         int(11)                                                       NULL DEFAULT NULL COMMENT '工单数量',
    `plan_start_time`    datetime(0)                                                   NULL DEFAULT NULL COMMENT '开始时间',
    `plan_end_time`      datetime(0)                                                   NULL DEFAULT NULL COMMENT '结束时间',
    `start_time`         datetime(0)                                                   NULL DEFAULT NULL COMMENT '实际开始时间',
    `end_time`           datetime(0)                                                   NULL DEFAULT NULL COMMENT '实际完成时间',
    `priority`           int(1)                                                        NULL DEFAULT NULL COMMENT '优先级（1，2，3，4）',
    `qualify_num`        int(11)                                                       NULL DEFAULT NULL COMMENT '合格数量',
    `unqualify_num`      int(11)                                                       NULL DEFAULT NULL COMMENT '不合格数量',
    `online_number`      int(11)                                                       NULL DEFAULT NULL COMMENT '上线数量',
    `offline_number`     int(11)                                                       NULL DEFAULT NULL COMMENT '下线数量',
    `product_id`         bigint(20)                                                    NULL DEFAULT NULL COMMENT '产品ID',
    `product_name`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品名称',
    `craft_id`           bigint(20)                                                    NULL DEFAULT NULL COMMENT '工艺路线ID',
    `craft_name`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品路线名称',
    `craft_version_id`   bigint(20)                                                    NULL DEFAULT NULL COMMENT '工艺路线版本',
    `craft_version_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺路线名称',
    `tenant_id`          varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建人',
    `create_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '更新人',
    `update_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '更新时间',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`             tinyint(3)                                                    NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`         bigint(20)                                                    NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`        bigint(20)                                                    NULL DEFAULT NULL,
    `product_code`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品编码',
    `start_up_time`      datetime(0)                                                   NULL DEFAULT NULL COMMENT '工单启动时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `product_id` (`product_id`) USING BTREE,
    INDEX `craft_id` (`craft_id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `blade_fms_order_process`;
CREATE TABLE `blade_fms_order_process`
(
    `id`                bigint(20)                                                    NOT NULL COMMENT '主键',
    `order_id`          bigint(50)                                                    NULL DEFAULT NULL COMMENT '所属工单ID',
    `process_name`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工单工序名称',
    `process_code`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工单工序编号',
    `process_status`    int(11)                                                       NULL DEFAULT NULL COMMENT '工单工序状态',
    `work_station_id`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工单派发工位ID列表',
    `work_station_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工单派发工位名字列表',
    `process_type`      int(11)                                                       NULL DEFAULT NULL COMMENT '工序工种',
    `process_type_name` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工序工种名称',
    `sort`              int(11)                                                       NULL DEFAULT NULL COMMENT '顺序',
    `program_id`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '程序ID',
    `program_name`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序名称',
    `qualify_num`       int(11)                                                       NULL DEFAULT NULL COMMENT '合格数量',
    `unqualify_num`     int(11)                                                       NULL DEFAULT NULL COMMENT '不合格数量',
    `online_number`     int(11)                                                       NULL DEFAULT NULL COMMENT '上线数量',
    `offline_number`    int(11)                                                       NULL DEFAULT NULL COMMENT '下线数量',
    `standard_time`     int(11)                                                       NULL DEFAULT NULL COMMENT '标准工时',
    `prepare_time`      int(11)                                                       NULL DEFAULT NULL COMMENT '准备工时',
    `disassembly_time`  int(11)                                                       NULL DEFAULT NULL COMMENT '拆卸工时',
    `transport_time`    int(11)                                                       NULL DEFAULT NULL COMMENT '运输工时',
    `tenant_id`         varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`       bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建人',
    `create_time`       datetime(0)                                                   NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`       bigint(20)                                                    NULL DEFAULT NULL COMMENT '更新人',
    `update_time`       datetime(0)                                                   NULL DEFAULT NULL COMMENT '更新时间',
    `remark`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`            tinyint(3)                                                    NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`       bigint(20)                                                    NULL DEFAULT NULL,
    `input_num`         int(11)                                                       NULL DEFAULT NULL COMMENT '投产数量',
    `start_Time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '实际开始时间',
    `end_time`          datetime(0)                                                   NULL DEFAULT NULL COMMENT '实际完成时间',
    `distributed_num`   int(11)                                                       NULL DEFAULT NULL COMMENT '待派发数量',
    `part_number`       varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '零件号',
    `cur_tray_code`     varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '当前托盘号',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `order_id` (`order_id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `blade_fms_order_process_fixture`;
CREATE TABLE `blade_fms_order_process_fixture`
(
    `id`                 bigint(20)                                                    NOT NULL COMMENT '主键',
    `order_process_id`   bigint(20)                                                    NULL DEFAULT NULL COMMENT '工单工序ID',
    `fixture_id`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '夹具ID',
    `fixture_code`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '夹具编号',
    `fixture_name`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '夹具名称',
    `tray_code`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '托盘号',
    `fixture_group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '夹具组名称',
    `tenant_id`          varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建人',
    `create_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '更新人',
    `update_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '更新时间',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`             int(11)                                                       NULL DEFAULT NULL COMMENT '记录状态',
    `is_deleted`         bigint(255)                                                   NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`        bigint(20)                                                    NULL DEFAULT NULL,
    `order_id`           bigint(20)                                                    NULL DEFAULT NULL COMMENT '工单id',
    `tray_id`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '托盘id',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `blade_fms_order_process_tool`;
CREATE TABLE `blade_fms_order_process_tool`
(
    `id`                 bigint(20)                                                    NOT NULL COMMENT '主键',
    `order_process_id`   bigint(20)                                                    NULL DEFAULT NULL COMMENT '工单工序ID',
    `tool_id`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具ID',
    `tool_code`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具编号',
    `tool_model_name`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具型号名称',
    `tool_category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具类型名称',
    `tenant_id`          varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建人',
    `create_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`        bigint(20)                                                    NULL DEFAULT NULL COMMENT '更新人',
    `update_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '更新时间',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`             int(11)                                                       NULL DEFAULT NULL COMMENT '记录状态',
    `is_deleted`         int(11)                                                       NULL DEFAULT NULL COMMENT '1	删除标识',
    `create_dept`        bigint(20)                                                    NULL DEFAULT NULL,
    PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `blade_fms_work_station_record`;
CREATE TABLE `blade_fms_work_station_record`
(
    `id`                bigint(20)                                                    NOT NULL COMMENT '主键',
    `order_id`          bigint(20)                                                    NULL DEFAULT NULL COMMENT '工单ID',
    `order_process_id`  bigint(20)                                                    NULL DEFAULT NULL COMMENT '工单工序ID',
    `work_station_id`   bigint(20)                                                    NULL DEFAULT NULL COMMENT '开工工位ID',
    `work_station_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工位名称',
    `start_time`        datetime(0)                                                   NULL DEFAULT NULL COMMENT '开工时间',
    `end_time`          datetime(0)                                                   NULL DEFAULT NULL COMMENT '结束时间',
    `qualify_num`       int(11)                                                       NULL DEFAULT NULL COMMENT '报工合格数量',
    `unqualify_num`     int(11)                                                       NULL DEFAULT NULL COMMENT '报工不合格数量',
    `work_time`         int(11)                                                       NULL DEFAULT NULL COMMENT '报工工时',
    `tray_code`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '托盘号',
    `part_code`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '零件号',
    `create_user`       bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建人',
    `create_time`       datetime(0)                                                   NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`       bigint(20)                                                    NULL DEFAULT NULL COMMENT '更新人',
    `update_time`       datetime(0)                                                   NULL DEFAULT NULL COMMENT '更新时间',
    `remark`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`            int(11)                                                       NULL DEFAULT NULL COMMENT '记录状态',
    `is_deleted`        int(11)                                                       NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`       bigint(20)                                                    NULL DEFAULT NULL,
    `record_status`     tinyint(4)                                                    NULL DEFAULT NULL COMMENT '1-加工中 2-完成',
    `work_bench_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作台编号',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `order_id` (`order_id`) USING BTREE,
    INDEX `order_process_id` (`order_process_id`) USING BTREE,
    INDEX `work_station_Id` (`work_station_id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `blade_fms_abnormal`;
CREATE TABLE `blade_fms_abnormal`
(
    `id`           bigint(20)                                                   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `status`       tinyint(3) UNSIGNED                                          NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`   tinyint(3) UNSIGNED                                          NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除',
    `create_user`  bigint(20)                                                   NULL DEFAULT NULL COMMENT '创建人',
    `create_dept`  bigint(20)                                                   NULL DEFAULT NULL COMMENT '创建部门',
    `create_time`  datetime(0)                                                  NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`  bigint(20)                                                   NULL DEFAULT NULL COMMENT '更新人',
    `update_time`  datetime(0)                                                  NULL DEFAULT NULL COMMENT '更新时间',
    `tenant_id`    varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户',
    `report_state` tinyint(4)                                                   NULL DEFAULT NULL COMMENT '提报状态 1-待提报,2-已取消,3-已提报',
    `content`      text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci        NULL COMMENT '内容',
    `type`         tinyint(4)                                                   NULL DEFAULT NULL COMMENT '异常类型',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `blade_fms_instruction_record`;
CREATE TABLE `blade_fms_instruction_record`
(
    `id`              bigint(20)                                                    NOT NULL AUTO_INCREMENT COMMENT '主键',
    `status`          tinyint(3) UNSIGNED                                           NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`      int(11) UNSIGNED                                              NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除',
    `create_user`     bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建人',
    `create_dept`     bigint(20)                                                    NULL DEFAULT NULL COMMENT '创建部门',
    `create_time`     datetime(0)                                                   NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`     bigint(20)                                                    NULL DEFAULT NULL COMMENT '更新人',
    `update_time`     datetime(0)                                                   NULL DEFAULT NULL COMMENT '更新时间',
    `tenant_id`       varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '所属租户',
    `order_code`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工单号',
    `process_code`    varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '工序号',
    `state`           tinyint(4)                                                    NULL DEFAULT NULL COMMENT '状态 0-已生成,1-执行中,2-执行完成,3-执行异常',
    `start_position`  varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '起始位置 起始设备编号',
    `start_bench`     varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '起始工作台编号',
    `end_position`    varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '目标位置 目标设备编号',
    `end_bench`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '目标工作台编号',
    `tray_code`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '托盘编号',
    `program_no`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '程序号',
    `program_offset`  varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '程序偏移',
    `signal_state`    tinyint(4)                                                    NULL DEFAULT NULL COMMENT '信号状态 1-动作执行,2-数据传递',
    `abnormal_reason` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '异常原因',
    `log`             text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         NULL COMMENT '产生日志',
    `last_load`       tinyint(1)                                                    NULL DEFAULT NULL COMMENT '是否装卸站末件',
    `change_model`    tinyint(4)                                                    NULL DEFAULT NULL COMMENT '停止标记(0：未停止，1：已停止)',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT = '指令记录表'
  ROW_FORMAT = Dynamic;


INSERT INTO `blade_scope_api` (`id`, `menu_id`, `resource_code`, `scope_name`, `scope_path`, `scope_type`, `remark`,
                               `http_method`, `create_user`, `create_dept`, `create_time`, `update_user`, `update_time`,
                               `status`, `is_deleted`)
VALUES (1589806703919927297, 1584366536134955010, 'fms_order_process.detail', '工单工序信息详情',
        '/blade-fms/order/process/get/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:27:10', 1123598821738675201, '2022-11-08 10:27:10', 1, 0),
       (1589806703928315905, 1584366536134955010, 'fms_order_process.list', '工单工序信息列表', '/blade-fms/order/process/list',
        NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-11-08 10:27:10', 1123598821738675201,
        '2022-11-08 10:27:10', 1, 0),
       (1589806703932510210, 1584366536134955010, 'fms_order_process.remove', '工单工序信息删除',
        '/blade-fms/order/process/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:27:10', 1123598821738675201, '2022-11-08 10:27:10', 1, 0),
       (1589806703936704513, 1584366536134955010, 'fms_order_process.update', '工单工序信息修改',
        '/blade-fms/order/process/update', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:27:10', 1123598821738675201, '2022-11-08 10:27:10', 1, 0),
       (1589806703940898818, 1584366536134955010, 'fms_order_process.workstation_list', '根据工单ID获取每道工序的工位列表数据',
        '/blade-fms/order/process/workstation-list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:27:10', 1123598821738675201, '2022-11-08 10:27:10', 1, 0),
       (1589806649947623425, 1584366536134955010, 'fms_order.count', '工单基础状态信息统计值', '/blade-fms/order/count', NULL,
        NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649951817729, 1584366536134955010, 'fms_order.detail', '工单基础状态信息详情', '/blade-fms/order/get/*', NULL,
        NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649951817730, 1584366536134955010, 'fms_order.get_fms_online', '获取柔性线当前运行状态',
        '/blade-fms/order/fms-running-status', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:26:57', 1123598821738675201, '2022-11-08 10:26:57', 1, 0),
       (1589806649951817731, 1584366536134955010, 'fms_order.get_production_craft', '根据产品ID查询工艺路线列表数据',
        '/blade-fms/order/get-production-craft/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:26:57', 1123598821738675201, '2022-11-08 10:26:57', 1, 0),
       (1589806649951817732, 1584366536134955010, 'fms_order.list_craft', '获取所有的工艺路线列表', '/blade-fms/order/list-craft',
        NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649951817733, 1584366536134955010, 'fms_order.order_statistics', '查看工单统计信息',
        '/blade-fms/order/statistics', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:26:57', 1123598821738675201, '2022-11-08 10:26:57', 1, 0),
       (1589806649956012033, 1584366536134955010, 'fms_order.page', '工单基础状态信息分页', '/blade-fms/order/page', NULL, NULL,
        'GET', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649956012034, 1584366536134955010, 'fms_order.pause', '工单暂停', '/blade-fms/order/pause', NULL, NULL,
        'POST', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649956012035, 1584366536134955010, 'fms_order.production_statistics', '查看产量统计信息',
        '/blade-fms/order/production-statistics', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:26:57', 1123598821738675201, '2022-11-08 10:26:57', 1, 0),
       (1589806649956012036, 1584366536134955010, 'fms_order.publish', '工单发布', '/blade-fms/order/publish', NULL, NULL,
        'POST', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649956012037, 1584366536134955010, 'fms_order.remove', '工单基础状态信息删除', '/blade-fms/order/remove', NULL,
        NULL, 'DELETE', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649956012038, 1584366536134955010, 'fms_order.save', '保存工单基础信息', '/blade-fms/order/save', NULL, NULL,
        'POST', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649960206337, 1584366536134955010, 'fms_order.save_workstation', '保存指派工位信息',
        '/blade-fms/order/save-workstation', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:26:57', 1123598821738675201, '2022-11-08 10:26:57', 1, 0),
       (1589806649960206338, 1584366536134955010, 'fms_order.shut_down_order', '停止计划工单（产线）',
        '/blade-fms/order/shut-down-order', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201,
        '2022-11-08 10:26:57', 1123598821738675201, '2022-11-08 10:26:57', 1, 0),
       (1589806649960206339, 1584366536134955010, 'fms_order.start', '工单启动', '/blade-fms/order/start', NULL, NULL,
        'POST', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0),
       (1589806649960206340, 1584366536134955010, 'fms_order.switch_state', '手自动切换', '/blade-fms/order/switch', NULL,
        NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-11-08 10:26:57', 1123598821738675201,
        '2022-11-08 10:26:57', 1, 0);
INSERT INTO blade_param (id, param_name, param_key, param_value, remark, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1564441155800182785, '是否自动', 'system.automatic', 'false', NULL, NULL, NULL, '2022-08-30 10:33:32', 1123598821738675201, '2023-01-05 15:31:38', 1, 0);
