ALTER TABLE pms_purchase_order_receipt ADD receiver_id BIGINT(20) NULL COMMENT '签收人id';

CREATE TABLE `sys_ship_upgrade_package` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识每条记录',
  `version` varchar(32) DEFAULT NULL COMMENT '版本号',
  `frontend_path` varchar(255) DEFAULT NULL COMMENT '前端地址',
  `backend_path` varchar(255) DEFAULT NULL COMMENT '后端地址',
  `release_date` datetime DEFAULT NULL COMMENT '发版日期',
  `remark` text COMMENT '备注',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除 1是0否',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='船端升级包管理表';

INSERT INTO sys_dict_data
(dict_code, value, label, label_en, tag_type, status, sort, remark, create_time, update_time)
VALUES('purchase_req_state', '14', '待报价', 'To Be Quoted', NULL, 1, 0, '', '2026-04-08 00:00:00', '2026-04-08 00:00:00');
ALTER TABLE `pms_purchase_request`                                                                                                                                                
    ADD COLUMN `product_code` varchar(100) NULL COMMENT '设备编码' AFTER `expected_date`,                                                                                           
    ADD COLUMN `model` varchar(200) NULL COMMENT '设备型号' AFTER `product_code`,                                                                                                   
    ADD COLUMN `serial_number` varchar(100) NULL COMMENT '设备序列号' AFTER `model`;
	
UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'counter', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '1', `update_by` = '1', `create_time` = '2025-08-06 14:15:02', `update_time` = '2026-04-17 14:10:32', `level` = 2, `parent_id` = 1079, `route_url` = 'counter', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 7, `is_cache` = 1, `is_frame` = 1, `component` = '/pms/maintenance/counter/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'counter', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1080;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'jobOrderHistory', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '1', `update_by` = '1', `create_time` = '2025-08-06 14:17:10', `update_time` = '2026-04-17 14:09:24', `level` = 2, `parent_id` = 1079, `route_url` = 'jobOrderHistory', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 4, `is_cache` = 1, `is_frame` = 1, `component` = '/pms/maintenance/jobOrderHistory/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'jobOrderHistory', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1082;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'jobOrderList', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '1', `update_by` = '1', `create_time` = '2025-08-14 17:25:32', `update_time` = '2026-04-17 14:09:17', `level` = 2, `parent_id` = 1079, `route_url` = 'jobOrderList', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 3, `is_cache` = 1, `is_frame` = 1, `component` = '/pms/maintenance/jobOrderList/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'jobOrderList', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1090;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'jobPlan', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '139', `update_by` = '1', `create_time` = '2025-08-20 13:21:49', `update_time` = '2026-04-17 14:09:10', `level` = 2, `parent_id` = 1079, `route_url` = 'jobPlan', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 2, `is_cache` = 0, `is_frame` = 1, `component` = '/pms/maintenance/jobPlan/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'PMS_jobPlan', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1094;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'unPlannedJob', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '139', `update_by` = '1', `create_time` = '2025-09-01 11:15:11', `update_time` = '2026-04-17 14:09:31', `level` = 2, `parent_id` = 1079, `route_url` = '/unPlannedJob', `icon` = NULL, `is_visible` = '1', `status` = '0', `order_num` = 5, `is_cache` = 0, `is_frame` = 1, `component` = '/pms/maintenance/unPlannedJob/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'unPlannedJob', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1102;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'defectList', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '1', `update_by` = '1', `create_time` = '2025-09-15 15:55:38', `update_time` = '2026-04-17 14:09:36', `level` = 2, `parent_id` = 1079, `route_url` = '/defectList', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 6, `is_cache` = 1, `is_frame` = 1, `component` = '/pms/maintenance/defect/defectList/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'defectList', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1110;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'vesselEquipmentDetails', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '1', `update_by` = '1', `create_time` = '2025-09-16 10:08:44', `update_time` = '2026-04-17 14:09:03', `level` = 2, `parent_id` = 1079, `route_url` = 'vesselEquipmentDetails', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 1, `is_cache` = 1, `is_frame` = 1, `component` = '/maintenance/vesselEquipmentDetails/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'PMS_vesselEquipmentDetails', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1112;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'smsHistory', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '139', `update_by` = '1', `create_time` = '2025-11-10 14:37:42', `update_time` = '2026-04-17 14:11:42', `level` = 2, `parent_id` = 1172, `route_url` = 'smsHistory', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 2, `is_cache` = 1, `is_frame` = 1, `component` = '/sms/smsFileHistory/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'smsHistory', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1168;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'smsPlan', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '139', `update_by` = '1', `create_time` = '2025-11-10 14:38:14', `update_time` = '2026-04-17 14:11:46', `level` = 2, `parent_id` = 1172, `route_url` = 'smsPlan', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 1, `is_cache` = 1, `is_frame` = 1, `component` = '/sms/smsPlan/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'smsPlan', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1169;

UPDATE `seacon_ship_vessel`.`sys_menu` SET `menu_code` = '', `menu_name` = 'jobPlanApproveList', `permission_code` = '', `permission_name` = '', `required_permission` = 2, `menu_type` = 1, `open_type` = 1, `url` = NULL, `create_by` = '1', `update_by` = '1', `create_time` = '2026-01-23 10:15:38', `update_time` = '2026-04-17 14:11:09', `level` = 2, `parent_id` = 1079, `route_url` = 'jobPlanApproveList', `icon` = NULL, `is_visible` = '0', `status` = '0', `order_num` = 8, `is_cache` = 1, `is_frame` = 1, `component` = '/maintenance/jobPlanApproveList/index', `query` = NULL, `always_show` = b'0', `active_menu` = NULL, `affix` = b'0', `route_name` = 'maintenance_jobPlanApproveList', `frame_src` = NULL, `is_root` = b'1', `redirect` = NULL, `belong_ship_type` = 0, `is_deleted` = 0 WHERE `id` = 1207;

INSERT INTO `seacon_ship_vessel`.`oper_dashboard` (`id`, `model_name`, `model_name_en`, `icon_name`, `status`, `model_type`, `component_name`, `priority`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`) VALUES (37, '申请单', 'Requisitions', 'icon-tianxiebaogao', 1, 2, 'PurchaseRequisitions', 30, '2026-04-16 16:21:13', 1, '2026-04-16 16:21:13', 1, 0);

INSERT INTO `seacon_ship_vessel`.`oper_dashboard` (`id`, `model_name`, `model_name_en`, `icon_name`, `status`, `model_type`, `component_name`, `priority`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`) VALUES (38, '签收单', 'GRN', 'icon-tianxiebaogao', 1, 2, 'PurchaseGrn', 31, '2026-04-16 16:21:45', 1, '2026-04-16 16:21:45', 1, 0);

CREATE TABLE `sys_ship_upgrade_sql` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `package_id` bigint(20) DEFAULT NULL COMMENT '包id',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `sql_statement` varchar(2000) DEFAULT NULL COMMENT 'sql语句，多条分号分割',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否逻辑删除0否1是',
  PRIMARY KEY (`id`),
  KEY `idx_package` (`package_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='船端升级sql文件';