huahuibao_document/任务小笔记/26年/07-01：生日变更与优化/SQL.md

xhSms 从

CREATE TABLE `xhSms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `merchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `userId` int(11) NOT NULL DEFAULT '0' COMMENT '收信人',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '通知类型',
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '内容',
  `addTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='短信发送记录';

变更为

CREATE TABLE `xhSms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mainId` bigint(11) NOT NULL DEFAULT '0' COMMENT '中央id',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店',
  `userId` int(11) NOT NULL DEFAULT '0' COMMENT '收信人',
  `mobile` varchar(15) NOT NULL DEFAULT '' COMMENT '手机号',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0通知类型, 1营销类型',
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '内容',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `m_s_idx` (`mainId`, `shopId`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短信发送记录';