-- ----------------------------
-- Table structure for siger_project_outsourced_maintenance
-- ----------------------------
CREATE TABLE `siger_project_outsourced_maintenance`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NULL DEFAULT NULL,
  `status` int(11) NULL DEFAULT NULL,
  `creator` int(11) NULL DEFAULT NULL,
  `editor` int(11) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `edit_time` bigint(22) NULL DEFAULT 0,
  `order_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '委托单号',
  `machine_id` int(11) NULL DEFAULT NULL COMMENT '设备Id',
  `supplier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '供应商',
  `price` double(11, 2) NULL DEFAULT 0.00 COMMENT '设备Id',
  `repair_time` bigint(22) NULL DEFAULT 0 COMMENT '维修时间',
  `process_id` int(11) NULL DEFAULT 0 COMMENT '审批流程',
  `state` int(11) NULL DEFAULT NULL COMMENT '审核状态0-未审核1-审核中2-已审核3-未通过',
  `current_level` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------
-- 新增 字段 :应急维护，计划维护推送时间间隔按项目区分
-- 家伟
-- 日期20210111
-- ----------------------------

ALTER TABLE siger_project_repair_report ADD COLUMN repeat_time int(11) DEFAULT 5 COMMENT '应急维护推送间隔';
ALTER TABLE siger_project_plan_report ADD COLUMN repeat_time int(11) DEFAULT 5 COMMENT '计划维护推送间隔';
