tmrgo1/migration/update.sql

ALTER TABLE `tmrwatch2`.`tmr` 
ADD COLUMN `gps` varchar(50) NULL AFTER `lastinorout`;


ALTER TABLE `tmrwatch2`.`downloadedplan` 
ADD COLUMN `driverId` bigint NOT NULL DEFAULT 0 COMMENT '驾驶员' ;

ALTER TABLE `tmrwatch2`.`tmr` 
ADD INDEX(`pastureid`, `gps`);












  ALTER TABLE `tmrwatch2`.`pasture` 
  ADD COLUMN `werks` varchar(30) NULL AFTER `isgroups`;

  ALTER TABLE `tmrwatch2`.`bar` 
  ADD COLUMN `AUFNR` varchar(50) NULL COMMENT 'sap牛群订单行号' AFTER `backup2`;

  ALTER TABLE `tmrwatch2`.`bar` 
  ADD COLUMN `class` varchar(50) NULL COMMENT '牛舍类型' AFTER `AUFNR`,
  ADD COLUMN `classcode` varchar(50) NULL COMMENT '牛舍类型编码' AFTER `class`,
  ADD COLUMN `cattle` varchar(50) NULL COMMENT '牛群' AFTER `classcode`,
  ADD COLUMN `cattlecode` varchar(50) NULL COMMENT '牛群编码' AFTER `cattle`;


  ALTER TABLE `tmrwatch2`.`bar` 
  ADD COLUMN `sapCode` varchar(50) NULL AFTER `cattlecode`;



  
  ALTER TABLE `tmrwatch2`.`feed` 
  ADD COLUMN 	`sapMtart` bigint(20) DEFAULT NULL COMMENT 'sap编码',
  ADD COLUMN  `sapGewei` varchar(20) DEFAULT NULL COMMENT 'sap单位',
  ADD COLUMN   `sapLGPRO` varchar(20) DEFAULT NULL COMMENT 'sap牧场编码',
  ADD COLUMN  `sapCHARG` varchar(20) DEFAULT NULL,
  ADD COLUMN  `sapCode` varchar(20) DEFAULT NULL;


  ALTER TABLE `tmrwatch2`.`feed` 
  MODIFY COLUMN `sapCode` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'sap编码' AFTER `sapCHARG`,
  ADD COLUMN `sapMaterialtype` varchar(50) NULL COMMENT 'sap物料类型' AFTER `sapCode`,
  ADD COLUMN `sapGoods` varchar(50) NULL COMMENT 'sap货位' AFTER `sapMaterialtype`;


  ALTER TABLE `tmrwatch2`.`feedtemplet` 
  ADD COLUMN `cattle` varchar(30) NULL COMMENT '牛群类别' AFTER `backup2`;


  CREATE TABLE `saplog` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `pastureId` varchar(20) DEFAULT NULL,
    `request` longtext DEFAULT NULL,
    `response` longtext DEFAULT NULL,
    `status` varchar(20) DEFAULT NULL,
    `msgtext` varchar(255) DEFAULT NULL,
    `url` varchar(255) DEFAULT NULL,
    `createTime` datetime DEFAULT NULL ON UPDATE current_timestamp(),
    `msgtype` int(1) DEFAULT NULL COMMENT '0饲喂  1剩料  2原料  3栏舍  4配方 5栏舍牛头数 6库存',
    `dataDate` varchar(20) DEFAULT NULL COMMENT '数据日期',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2039 DEFAULT CHARSET=utf8mb3;
	
	
	
	CREATE TABLE `dist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `distType` varchar(30) DEFAULT NULL,
  `distName` varchar(50) DEFAULT NULL,
  `distCode` varchar(50) DEFAULT NULL,
  `remark` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=321 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;


CREATE TABLE `cattleorder` (
  `AUFNR` varchar(20) NOT NULL COMMENT '订单号',
  `KTEXT` varchar(50) DEFAULT NULL COMMENT '订单描述',
  `ZNZLX` varchar(50) DEFAULT NULL COMMENT '牛只类型 A-母犊牛 B-母育成牛 C-母青年牛 D-母泌乳牛 E-母干奶牛 F-公牛',
  `AUART` varchar(50) DEFAULT NULL COMMENT '订单类型编码',
  `AUTXT` varchar(50) DEFAULT NULL COMMENT '订单类型名称',
  `BUKRS` varchar(50) DEFAULT NULL COMMENT '公司代码',
  `BUTXT` varchar(50) DEFAULT NULL COMMENT '公司代码名称',
  PRIMARY KEY (`AUFNR`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;













	
	  ALTER TABLE `feedtemplet` 
  ADD COLUMN 
	`volume` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '容积';
	
		  ALTER TABLE `tmr` 
  ADD COLUMN 
	`volume` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '容积';
	
	
			  ALTER TABLE `feedtemplethistory` 
  ADD COLUMN 
	`volume` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '容积';
	
	
		
			  ALTER TABLE `feedtempletdate` 
  ADD COLUMN 
	`volume` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '容积';






ALTER TABLE `tmrwatch2`.`feedtemplethistory` 
ADD COLUMN `userId` varchar(30) NULL COMMENT '修改用户' AFTER `volume`;

ALTER TABLE `tmrwatch2`.`fpdetailhistory` 
ADD COLUMN `userId` varchar(30) NULL COMMENT '修改用户' AFTER `createdate`;

ALTER TABLE `tmrwatch2`.`feedphistory` 
ADD COLUMN `userId` varchar(30) NULL COMMENT '修改用户' AFTER `createdate`;

ALTER TABLE `tmrwatch2`.`lpplandtl1history` 
ADD COLUMN `userId` varchar(30) NULL COMMENT '修改用户' AFTER `createdate`;

ALTER TABLE `tmrwatch2`.`fit_history` 
ADD COLUMN `userId` varchar(30) NULL AFTER `feedgroup`;