huahuibao/sql/20260714_goods_use_case.sql

CREATE TABLE `xhGoodsUseCase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mainId` int(11) NOT NULL DEFAULT 0,
  `sjId` int(11) NOT NULL DEFAULT 0,
  `useCaseName` varchar(50) NOT NULL DEFAULT '',
  `inTurn` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `delStatus` tinyint(4) NOT NULL DEFAULT 0,
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`), KEY `mainId` (`mainId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xhGoodsUseCaseRelation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mainId` int(11) NOT NULL DEFAULT 0,
  `goodsId` int(11) NOT NULL DEFAULT 0,
  `useCaseId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`), UNIQUE KEY `goods_use_case` (`goodsId`,`useCaseId`), KEY `mainId` (`mainId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;




ALTER TABLE xhHd
  add COLUMN `homeRule` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上门遵循规则 0遵循总设置 1遵循自定义' after `updateTime`;


ALTER TABLE xhCustom
  add COLUMN `homeRule` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上门遵循规则 0遵循总设置 1遵循自定义' after `updateTime`;