-- ----------------------------
-- Table structure for siger_project_box
-- ----------------------------
DROP TABLE IF EXISTS `siger_project_box`;
CREATE TABLE `siger_project_box` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cid` int NOT NULL DEFAULT '0' COMMENT '客户id',
  `pid` int NOT NULL DEFAULT '0' COMMENT '项目id',
  `boxcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '盒子编号',
  `system` varchar(255) NOT NULL DEFAULT '' COMMENT '适配数控系统',
  `program_version` varchar(255) NOT NULL DEFAULT '' COMMENT '数采程序版本',
  `machineid` int NOT NULL DEFAULT '0' COMMENT '设备id',
  `enableTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '启用时间',
  `mandateType` int NOT NULL DEFAULT '0' COMMENT '授权类型   1=>永久授权  2=>按时间授权  3=》试用',
  `mandate_days` int NOT NULL DEFAULT '0' COMMENT '授权天数',
  `usage_status` int NOT NULL DEFAULT '0' COMMENT '使用状态  0=>离线 1=>待授权 2=>运行 ',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
SET FOREIGN_KEY_CHECKS=1;


2020-09-19

-- ----------------------------
-- Table structure for siger_project_cj_machine
-- ----------------------------
DROP TABLE IF EXISTS `siger_project_cj_machine`;
CREATE TABLE `siger_project_cj_machine` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '长江润发设备关联表',
  `machineId` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '设备id',
  `machineCode` varchar(255) NOT NULL DEFAULT '' COMMENT '设备编号',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '设备名称',
  `mid` int NOT NULL DEFAULT '0' COMMENT '设备id',
  `status` int NOT NULL DEFAULT '1',
  `projectid` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
SET FOREIGN_KEY_CHECKS=1;

