huahuibao/sql.sql

========================以下内容请将下面的数据库同步了再操作====================

将 销花宝 花卉宝 花掌柜 花美玲 的公众号和小程序 绑定到同一个开放平台下
将供货商和零售店的公众号和小程序绑定到自我开放平台下 并且更新 xhWxGzh 和 xhWxMini 下的openAppId值 和其它相关信息 二个公众号要补齐
小程序要换业务域名

https涉及的几个域名
api.shop.huahb.com
api.pt.huahb.com
pt.huahb.com
shop.huahb.com

1.补充供货商的wxopen信息 包括appSecret style = 2 其它内容参考开放平台里的数据
2.api.pt.hzghd.com nginx要指向到pt目录 并且开通api.pt.hzghd.com的https
3.api.shop.hzghd.com 指向到ghs目录 并且开通api.shop.hzghd.com的https
4.开通shop.hzghd.com的https
线上将以上hzghd换成wixhb即可

api.shop.theflorist.cn
api.pt.theflorist.cn
pt.theflorist.cn
img.theflorist.cn

wxOpen 平台和公众号 小程序要补好

确认app模块下的hd ghs pt mall里的runtime有没创建成功 web里的assets是否创建成功


=============================================================================


要和供货商确认 要初始化的东西 花材的重量 花材的比例 成本价 加价 大小单位


=============================================================================


nginx配置修改
nginx.conf
```
http {

    client_max_body_size 50m; # 配置nginx上传文件最大限制，默认1m
}
```


=============================================================================

CREATE TABLE xhItem(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '花材名称',
unitNum tinyint not null default 0 comment '每扎多少支',
unitWeight decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎多少公斤',
unitCost decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎成本价，采购价',
unitAddPrice decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎加价',
unit int not null default 0 comment '单位名称ID',
addTime int not null default 0 comment '添加时间',
updateTime int not null default 0 comment '修改时间'
)comment='花材，资材';

create table if not exists xhItemClass(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(50) not null default '' comment '名称',
inTurn int not null default 0 comment '排序，越大越靠前',
addTime int not null default 0 comment '添加时间',
updateTime int not null default 0 comment '修改时间'
)comment='花材分类';

CREATE TABLE xhUnit(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '单位名称',
addTime int not null default 0 comment '添加时间',
updateTime int not null default 0 comment '修改时间'
)COMMENT='花材单位';

create table xhMerchantItemClass(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
merchantId int not null default 0 comment '商家id',
`name` varchar(50) not null default '' comment '名称',
inTurn int not null default 0 comment '排序，越大越靠前',
addTime int not null default 0 comment '添加时间',
updateTime int not null default 0 comment '修改时间'
)comment='商家花材分类';
create table xhMerchantItem(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
merchantId int not null default 0 comment '商家id',
classId int not null default 0 comment '商家花材分类id',
itemId int not null default 0 comment '花材id',
unitCost decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎成本价，采购价',
unitAddPrice decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎加价',
addTime int not null default 0 comment '添加时间',
updateTime int not null default 0 comment '修改时间'
)comment='商家花材';

CREATE TABLE `xhGhsOrder` (
  `id` int(11) NOT NULL AUTO_INCREMENT primary key COMMENT '自增id',
  `orderSn` char(40) NOT NULL DEFAULT '' COMMENT '订单编号',
  `goodsNum` tinyint(4) NOT NULL DEFAULT '0' COMMENT '商品数量',
  `payWay` tinyint(4) NOT NULL DEFAULT '0' COMMENT '支付方式 0微信 1支付宝 2余额',
  `wxPayType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 H5支付 1 小程序支付',
  `payCode` varchar(1000) NOT NULL DEFAULT '' COMMENT '支付返回号',
  `fromType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '来源：0门店 1商城 2朋友圈',
  `store` tinyint(4) NOT NULL DEFAULT '0' COMMENT '门店订单 0不是 1是',
  `capitalId` int(11) NOT NULL DEFAULT '0' COMMENT '流水id',
  `prePrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
  `userId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `merchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商户id',
  `shopId` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `sendType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未确认配送方式 1免配送 2自己送 3别人送；快递送',
  `sendSide` tinyint(4) NOT NULL DEFAULT '0' COMMENT '配送方 0没有 1达达',
  `sendStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '配送状态：0未发货，待接单 1已发货，已接单 2已送达',
  `refund` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1已退款 0正常订单',
  `payStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0待付款 1已付款',
  `printStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未打印 1已打印',
  `remark` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '订单状态 0待付款 1待配送 2配送中 3待通知 4已取消 5已完成',
  `deadline` int(11) NOT NULL DEFAULT '0' COMMENT '订单有效期',
  `payTime` int(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
  addTime int not null default 0 comment '添加时间',
  `updateTime` int not null default 0 comment '修改时间'
) COMMENT='供货商订单';
create table xhGhsOrderItem(
`id` int(11) unsigned NOT NULL AUTO_INCREMENT primary key COMMENT 'id',
`orderId` int(11) NOT NULL DEFAULT '0' COMMENT '订单id',
`userId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
`merchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商户id',
itemId int not null default 0 comment '商家花材id',
`unitPrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎价格',
unitNum int not null default 0 comment '每扎多少支',
`num` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '多少扎'
)comment='供货商订单商品';

ALTER TABLE xhItem ADD cover VARCHAR(500) NOT NULL DEFAULT '' COMMENT '封面图片' AFTER `name`;

ALTER TABLE xhMerchantAccount RENAME TO xhMerchantApply;


== ssh 2021-1-3

DROP TABLE IF EXISTS `xhItemRank`;
CREATE TABLE IF NOT EXISTS `xhItemRank` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `itemId` INT NOT NULL DEFAULT 0 COMMENT '花材id',
  `rank` CHAR(5) NOT NULL DEFAULT 'A' COMMENT '等级 A B C D E',
  `unitCost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎成本价，采购价',
  `unitAddPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎加价',
  `addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `updateTime` INT(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) COMMENT='花材等级价格';
ALTER TABLE xhMerchantItem ADD rank CHAR(5) NOT NULL DEFAULT 'A' COMMENT '花材级别' AFTER `itemId`;
ALTER TABLE xhGhsOrderItem ADD rank CHAR(5) NOT NULL DEFAULT 'A' COMMENT '花材级别' AFTER `itemId`;
ALTER TABLE xhItemRank RENAME TO xhMerchantItemRank;
alter table xhMerchantItemRank add merchantId int not null default 0 comment '' after `id`;
ALTER TABLE xhAdmin ADD identity TINYINT NOT NULL DEFAULT 0 COMMENT '身份 0未知 1花粉 2花店员工' AFTER `mobile`;
ALTER TABLE xhMerchant ADD `style` TINYINT NOT NULL DEFAULT 0 COMMENT '商家类型 0普通 1零售商使用 2供货商使用' AFTER `id`;

==在开发环境 找到 花美玲 将style设置为1 找到 花掌柜 将style设置为2 如果找不到 则去走流程创建
==在线上环境 找到 花卉宝 将style设置为1 找到 销花宝 将style设置为2 如果找不到 则去走流程创建
===注意 xhWxOpen wxMiniBaseId wxBaseId wxGhsBaseId wxGhsMiniBaseId 相关字段的修改
===注意 BaseId GhsBaseId GhsMiniBaseId 表记录的增加

==ssh 20201-1-6

ALTER TABLE xhWxOpen MODIFY wxMiniBaseId INT(11) NOT NULL DEFAULT '0' COMMENT '平台零售商小程序';
ALTER TABLE xhWxOpen MODIFY wx_base_id INT(11) NOT NULL DEFAULT '0' COMMENT '平台零售商公众号';
ALTER TABLE xhWxOpen ADD wxGhsMiniBaseId INT(11) NOT NULL DEFAULT '0' COMMENT '平台供货商小程序' AFTER wx_base_id;
ALTER TABLE xhWxOpen ADD wxGhsBaseId INT(11) NOT NULL DEFAULT '0' COMMENT '平台供货商公众号' AFTER wxGhsMiniBaseId;
DROP TABLE IF EXISTS `xhGhsAdmin`;
CREATE TABLE IF NOT EXISTS `xhGhsAdmin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mobile` varchar(15) DEFAULT NULL COMMENT '手机号',
  `identity` tinyint(4) NOT NULL DEFAULT '0' COMMENT '身份 0未知 1花粉 2花店员工',
  `adminName` varchar(50) NOT NULL DEFAULT '' COMMENT '管理员姓名',
  `nickName` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '头像',
  `password` varchar(500) NOT NULL DEFAULT '' COMMENT '密码',
  `confirmPassword` varchar(500) NOT NULL DEFAULT '' COMMENT '确认密码',
  `sourceType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '来源 0微信 1支付宝 2小程序 3朋友圈 4美团',
  `subscribeTime` int(11) NOT NULL DEFAULT '0' COMMENT '关注时间',
  `hasSubscribe` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否关注过 0没有 1是的',
  `subscribe` tinyint(4) NOT NULL DEFAULT '0' COMMENT '关注平台 0未关注 1关注',
  `unionId` varchar(100) NOT NULL DEFAULT '' COMMENT '微信平台唯一id',
  `miniOpenId` varchar(100) NOT NULL DEFAULT '' COMMENT '小程序openid',
  `openId` varchar(100) NOT NULL DEFAULT '' COMMENT '微信openid',
  `remark` varchar(500) NOT NULL DEFAULT '' COMMENT '员工备注',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别 0未知 1男性 2女性',
  `super` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否超级管理员 0不是 1是，超级员工不可删除',
  `delStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '软删除标识 0未删除 1已删除',
  `accountStatus` tinyint(4) NOT NULL DEFAULT '1' COMMENT '帐号状态 0禁用 1正常',
  `loginTime` int(11) NOT NULL DEFAULT '0' COMMENT '最后登陆时间',
  `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
)COMMENT='供货商管理员表';
drop table if exists `xhGhsShop`;
CREATE TABLE `xhGhsShop` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '门店照片；门店头像',
  `shopName` varchar(100) NOT NULL DEFAULT '' COMMENT '门店名称',
  `merchantName` varchar(100) NOT NULL DEFAULT '' COMMENT '商家名称',
  `merchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商户id',
  `lat` varchar(20) NOT NULL DEFAULT '' COMMENT '纬度',
  `long` varchar(20) NOT NULL DEFAULT '' COMMENT '经度',
  `province` varchar(100) NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(100) NOT NULL DEFAULT '' COMMENT '市',
  `dist` varchar(100) NOT NULL DEFAULT '' COMMENT '区县',
  `address` varchar(500) NOT NULL DEFAULT '' COMMENT '街道地址',
  `floor` varchar(50) NOT NULL DEFAULT '' COMMENT '楼号门牌号',
  `fullAddress` varchar(500) NOT NULL DEFAULT '' COMMENT '完整地址',
  `telephone` varchar(20) NOT NULL DEFAULT '' COMMENT '电话',
  `openTime` varchar(30) NOT NULL DEFAULT '' COMMENT '营业时间',
  `introduction` varchar(800) DEFAULT '' COMMENT '简介',
  `gatheringCode` varchar(500) NOT NULL DEFAULT '' COMMENT '收款的二维码',
  `applyMemberCode` varchar(500) NOT NULL DEFAULT '' COMMENT '注册会员码',
  `totalIncome` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入',
  `default` tinyint(4) NOT NULL DEFAULT '0' COMMENT '默认门店 0不是 1是，默认门店不能删除',
  `delStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除状态 0没有删除 1已删除',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '门店状态 0停用 1正常',
  `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间，时间戳格式',
  `createTime` datetime NOT NULL COMMENT '创建时间',
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) comment='供货商门店';
drop table if exists `xhGhsShopAdmin`;
CREATE TABLE if not exists `xhGhsShopAdmin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminId` int(11) NOT NULL DEFAULT '0' COMMENT '管理员id',
  `merchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `remind` tinyint(4) NOT NULL DEFAULT '0' COMMENT '动态提醒 0不需要 1需要',
  `roleId` int(11) NOT NULL DEFAULT '0' COMMENT '角色id',
  `default` tinyint(4) NOT NULL DEFAULT '0' COMMENT '默认管理的门店 1是 0否',
  `delStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除状态 0正常 1已删除',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0停用 1正常',
  `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) COMMENT='供货商员工';
ALTER TABLE xhGhsAdmin MODIFY `identity` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '身份 0未知 1花店员工 2供货商员工';
ALTER TABLE xhGhsShop CHANGE createTime `addTime` INT NOT NULL DEFAULT 0 COMMENT '添加时间';
ALTER TABLE xhGhsShop MODIFY updateTime INT NOT NULL DEFAULT 0 COMMENT '修改时间';
ALTER TABLE xhGhsShopAdmin ADD updateTime INT NOT NULL DEFAULT 0 COMMENT '修改时间';
ALTER TABLE xhGhsShop DROP COLUMN `createTime`;
CREATE TABLE IF NOT EXISTS `xhGhsCustom`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
ghsId INT NOT NULL DEFAULT 0 COMMENT '供货商id merchantId',
shopId INT NOT NULL DEFAULT 0 COMMENT '零售门店id',
shopName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '门店名称',
`mobile` VARCHAR(15) NOT NULL DEFAULT '0' COMMENT '店长手机号',
isOpen TINYINT NOT NULL DEFAULT 0 COMMENT '是否开店 0没有 1已开',
`addTime` INT NOT NULL DEFAULT 0 COMMENT '添加时间',
`updateTime` INT NOT NULL DEFAULT 0 COMMENT '修改时间'
)COMMENT='供货商客户';

ALTER TABLE xhGhsShop CHANGE `merchantId` ghsId INT NOT NULL DEFAULT 0 COMMENT '供货商id';
ALTER TABLE xhGhsShop CHANGE `merchantName` ghsName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '供货商名称';
ALTER TABLE `xhGhsCustom` ADD debt TINYINT NOT NULL DEFAULT 0 COMMENT '是否允许欠款买花 0不允许 1允许' AFTER `isOpen`;
ALTER TABLE `xhGhsCustom` ADD debtAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '欠款金额' AFTER `debt`;
ALTER TABLE `xhGhsCustom` ADD buyNum INT NOT NULL DEFAULT 0 COMMENT '消费次数' AFTER `debtAmount`;
ALTER TABLE `xhGhsCustom` ADD buyAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '消费总金额' AFTER `buyNum`;
ALTER TABLE xhGhsShopAdmin CHANGE merchantId `ghsId` INT NOT NULL DEFAULT 0 COMMENT '供货商id merchantId';
ALTER TABLE xhApply ADD updateTime INT NOT NULL DEFAULT 0 COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE xhApply ADD `from` TINYINT NOT NULL DEFAULT 0 COMMENT '来源 0花店自己申请 1供货商发起' AFTER `introMerchantId`;

==ssh 2021-1-12
ALTER TABLE `xhApply` ADD introStyle TINYINT NOT NULL DEFAULT 0 COMMENT '介绍的商家类型 同 xhMerchant style' AFTER `introMerchantId`;
ALTER TABLE `xhMerchant` MODIFY `style` TINYINT NOT NULL DEFAULT 0 COMMENT '商家类型 0零售 1 供货';
ALTER TABLE `xhMerchant` ADD `property` TINYINT NOT NULL DEFAULT 0 COMMENT '商家属性 0零售 1 供货' AFTER `style`;
ALTER TABLE `xhMerchant` MODIFY `property` TINYINT NOT NULL DEFAULT 0 COMMENT '平台微信取用类型 0普通 1零售商使用 2供货商使用';
ALTER TABLE `xhApply` ADD adminName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '店长姓名' AFTER adminId;
ALTER TABLE `xhApply` MODIFY `mobile` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '店长手机号' AFTER `adminName`;
=======
===linqhai 2021-01-11

ALTER TABLE `xhItem` ADD COLUMN `pyName`  varchar(50) NOT NULL DEFAULT '' COMMENT '花材名称的拼音首字母' AFTER `name`;
ALTER TABLE `xhMerchantItemClass`
ADD COLUMN `adminId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作人ID' AFTER `inTurn`,
ADD INDEX `idx_merchantId` (`merchantId`) USING BTREE ;
RENAME  TABLE xhMerchantItemClass to xhGhsItemClass;
RENAME  TABLE xhMerchantItem to xhGhsItem;
RENAME  TABLE xhMerchantItemRank to xhGhsItemRank;

ALTER TABLE `xhGhsItemClass`
CHANGE COLUMN `merchantId` `ghsId`  int(11) NOT NULL DEFAULT 0 COMMENT '商家id' AFTER `id`,
DROP INDEX `idx_merchantId` ,
ADD INDEX `idx_ghsId` (`ghsId`) USING BTREE ;

ALTER TABLE `xhGhsItem`
CHANGE COLUMN `merchantId` `ghsId`  int(11) NOT NULL DEFAULT 0 COMMENT '商家id' AFTER `id`,
ADD INDEX `idx_ghsId` (`ghsId`) USING BTREE ;

ALTER TABLE `xhGhsItem`
ADD INDEX `idx_itemId` (`itemId`) USING BTREE ,
ADD INDEX `idx_classId` (`classId`) USING BTREE ;

CREATE TABLE `xhGhsItemInfo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ghsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供货商ID',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `stock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '库存，多少扎,可以出现负库存',
  `rank` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'B' COMMENT '花材等级 A、B、C、D',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '每扎的价格(对应等级价格)',
  `actualSold` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际销售量',
  `viewNum` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
  `delStatus` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '删除标识 0未删除 1删除',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后操作人',
  `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `updateTime` int(11) NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='供货商的商品表，对应各个门店';


CREATE TABLE `xhGhsCheckOrder` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ghsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供货商ID',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `orderStatus` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '盘点订单状态： 1草稿，2完成',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `itemNumBundle` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(扎)(盈亏）',
  `itemNumPiece` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(支)(盈亏）',
  `totalItemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品总价格(盈亏）',
  `remark` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
  `addTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_orderNum` (`orderSn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='盘点订单表';

CREATE TABLE `xhGhsCheckOrderItem` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemNum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '盘点花材数量',
  `itemStock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '当时的库存',
  `profitLossNum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '盈亏数，正数盈，负数亏',
  `itemInfo` text COLLATE utf8mb4_unicode_ci COMMENT '花材信息json{"itemName":"","itemCover":"","itemRank":""}',
  `itemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  PRIMARY KEY (`id`),
  KEY `idx_orderNum` (`orderSn`) USING BTREE,
  KEY `idx_goodsItemId` (`itemId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='盘点订单详情表';

CREATE TABLE `xhGhsPurchaseOrder` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ghsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供货商ID',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `orderStatus` tinyint(2) NOT NULL DEFAULT '0' COMMENT '订单状态：1待确认，2待配送，3配送中，4已完成',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '采购人ID',
  `gysId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供应商ID',
  `itemNumBundle` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(扎)',
  `itemNumPiece` int(11) DEFAULT NULL COMMENT '合计多少商品(支)',
  `totalGoodsPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品总价格',
  `packingCharge` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '打包费',
  `shortHaulCharge` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '短途运费',
  `lineHaulCharge` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '长途运费',
  `pickCharge` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提货费',
  `localHaulCharge` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '本地运费',
  `orderPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单总价',
  `entryTime` int(11) NOT NULL DEFAULT '0' COMMENT '入库时间',
  `addTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_orderNum` (`orderSn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='采购订单表';


CREATE TABLE `xhGhsPurchaseOrderItem` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '采购订单号',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemNum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '花材数量',
  `itemInfo` text COLLATE utf8mb4_unicode_ci COMMENT '花材信息json{"itemName":"","itemCover":"","itemRank":""}   ',
  `itemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '采购价',
  PRIMARY KEY (`id`),
  KEY `idx_orderNum` (`orderSn`) USING BTREE,
  KEY `idx_goodsItemId` (`itemId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='采购订单详情表';

CREATE TABLE `xhGhsSellOrder` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ghsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供货商ID',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `orderStatus` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '订单状态： 1待确认，2下单成功，2出库中，3已完成，4取消下单',
  `distributionMode` tinyint(2) NOT NULL DEFAULT '0' COMMENT '配送方式: 1 门店自取，2本地送，3快递',
  `shipStatus` tinyint(2) NOT NULL DEFAULT '0' COMMENT '订单物流状态：1待确认，2待配送，3发货，4配送中，5配送中-已接单，6配送中-骑手送货中，7配送中-配送完成',
  `shipType` tinyint(2) NOT NULL COMMENT '快递公司: 1达达，2顺丰同城3闪送，4美团',
  `shipSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '快递单号',
  `payMethod` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付方式： alipay,wxpay,defer(延期)，cash(现金收款)，',
  `payNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付订单号',
  `payStatus` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态：1待支付，2支付成功,3支付失败',
  `payTime` int(11) NOT NULL DEFAULT '0' COMMENT '支付时间',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '采购人ID',
  `retailShopId` int(11) NOT NULL DEFAULT '0' COMMENT '零售门店ID',
  `userId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '客户D',
  `itemNumBundle` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(扎)',
  `itemNumPiece` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(支)',
  `totalItemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品总价格',
  `orderPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单总价',
  `shipPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '运费',
  `address` text COLLATE utf8mb4_unicode_ci COMMENT '收货地址 json',
  `addTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_orderNum` (`orderSn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='销售订单表';


CREATE TABLE `xhGhsSellOrderItem` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemNum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '花材数量',
  `itemInfo` text COLLATE utf8mb4_unicode_ci COMMENT '花材信息json{"itemName":"","itemCover":"","itemRank":""}',
  `itemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  PRIMARY KEY (`id`),
  KEY `idx_orderNum` (`orderSn`) USING BTREE,
  KEY `idx_goodsItemId` (`itemId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='销售订单详情表';

CREATE TABLE `xhGhsStockOrder` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ghsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '出库的供货商ID',
  `outShopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '出库的门店ID',
  `inShopId` int(11) NOT NULL DEFAULT '0' COMMENT '入库的门店ID',
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `orderStatus` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '订单状态： 1待出库，2已出库（待入库） 3已入库, 4取消出库，5取消入库',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `itemNumBundle` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(扎)',
  `itemNumPiece` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(支)',
  `totalItemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品总价格',
  `remark` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
  `addTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_orderNum` (`orderSn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='出库入库订单表';

CREATE TABLE `xhGhsStockOrderItem` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemNum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '出库花材数量',
  `itemStock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '当时的库存',
  `itemInfo` text COLLATE utf8mb4_unicode_ci COMMENT '花材信息json{"itemName":"","itemCover":"","itemRank":""}',
  `itemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  PRIMARY KEY (`id`),
  KEY `idx_orderNum` (`orderSn`) USING BTREE,
  KEY `idx_goodsItemId` (`itemId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='出库入库订单详情表';

===员工相关 ssh 2021-1-13

CREATE TABLE `xhGhsAdminLog` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ip` BIGINT(20) NOT NULL DEFAULT '0' COMMENT 'ip地址',
  `ghsId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `content` VARCHAR(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作内容',
  `adminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id；管理员id',
  `addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) COMMENT='员工操作日志';
CREATE TABLE `xhGhsAdminRole` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `roleName` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '角色名称',
  `ghsId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '成员数',
  `addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `delStatus` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '删除状态 0未删除 1已删除',
  `auth` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '权限id列表，存在*表示有所有权限',
  PRIMARY KEY (`id`)
) COMMENT='管理员角色';
CREATE TABLE `xhGhsAdminRoleAuth` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `roleId` INT(11) NOT NULL DEFAULT '0' COMMENT '角色id',
  `endId` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '业务端id',
  `ghsId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `auth` VARCHAR(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '权限',
  `addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) COMMENT='员工角色权限';
ALTER TABLE `xhWxOpen` CHANGE `wx_mini_base_id` `wxMiniBaseId` INT(11) NOT NULL DEFAULT '0' COMMENT '平台零售商小程序';
ALTER TABLE `xhWxOpen` CHANGE `wx_base_id` `wxBaseId` INT(11) NOT NULL DEFAULT '0' COMMENT '平台零售商公众号';

== 平台 ssh 2021-1-13

ALTER TABLE `xhWxBase` ADD `openAppId` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '开放平台帐号' AFTER merchantId;
ALTER TABLE `xhWxMiniBase` ADD `openAppId` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '开放平台帐号' AFTER merchantId;
ALTER TABLE `xhWxBase` DROP COLUMN `merchantId`;
ALTER TABLE `xhWxMiniBase` DROP COLUMN `merchantId`;
=======
== linqh 2021-01-13
ALTER TABLE `xhGhsItem`
ADD COLUMN `unitWeight`  float(10,2) NOT NULL DEFAULT 0 COMMENT '每扎重量(斤)' AFTER `rank`,
ADD COLUMN `stockWarning`  decimal(10,2) NOT NULL DEFAULT 0 COMMENT '库存预警' AFTER `unitWeight`;

========
== ssh 2021-1-13 删掉二个表
DROP TABLE IF EXISTS `xhGhsOrder`;
DROP TABLE IF EXISTS `xhGhsOrderItem`;
drop table if exists `xhGhsSellOrder`;
drop table if exists `xhGhsSellOrderItem`;
CREATE TABLE `xhGhsOrder` (
  `id` int(11) NOT NULL AUTO_INCREMENT primary key COMMENT '自增id',
  `orderSn` char(40) NOT NULL DEFAULT '' COMMENT '订单编号',
  `goodsNum` tinyint(4) NOT NULL DEFAULT '0' COMMENT '商品数量',
  `payWay` tinyint(4) NOT NULL DEFAULT '0' COMMENT '支付方式 0微信 1支付宝 2余额',
  `wxPayType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 H5支付 1 小程序支付',
  `payCode` varchar(1000) NOT NULL DEFAULT '' COMMENT '支付返回号',
  `fromType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '来源：0门店 1商城 2朋友圈',
  `store` tinyint(4) NOT NULL DEFAULT '0' COMMENT '门店订单 0不是 1是',
  `capitalId` int(11) NOT NULL DEFAULT '0' COMMENT '流水id',
  `prePrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
  `adminId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `ghsId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `sendType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未确认配送方式 1免配送 2自己送 3别人送；快递送',
  `sendSide` tinyint(4) NOT NULL DEFAULT '0' COMMENT '配送方 0没有 1达达',
  `sendStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '配送状态：0未发货，待接单 1已发货，已接单 2已送达',
  `refund` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1已退款 0正常订单',
  `payStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0待付款 1已付款',
  `printStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未打印 1已打印',
  `remark` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '订单状态 0待付款 1待配送 2配送中 3待通知 4已取消 5已完成',
  `deadline` int(11) NOT NULL DEFAULT '0' COMMENT '订单有效期',
  `payTime` int(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
  addTime int not null default 0 comment '添加时间',
  `updateTime` int not null default 0 comment '修改时间'
) COMMENT='供货商订单';
create table xhGhsOrderItem(
`id` int(11) unsigned NOT NULL AUTO_INCREMENT primary key COMMENT 'id',
`orderId` int(11) NOT NULL DEFAULT '0' COMMENT '订单id',
`adminId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
`ghsId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
itemId int not null default 0 comment '商家花材id',
`unitPrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎价格',
unitNum int not null default 0 comment '每扎多少支',
`num` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '多少扎'
)comment='供货商订单商品';
CREATE TABLE `xhGhsOrderExpress` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `orderId` INT(11) NOT NULL DEFAULT '0' COMMENT '订单id',
  `ghsId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `sideId` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '配送方id',
  `distance` DECIMAL(6,1) NOT NULL DEFAULT '0.0' COMMENT '距离',
  `cost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '运费',
  `tip` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '小费',
  `sendTime` INT(11) NOT NULL DEFAULT '0' COMMENT '要求配送时间',
  `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0待接单 1已接单 2已完成 3已取消',
  `addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) COMMENT='第三方配送';
CREATE TABLE `xhGhsStatOrderCount` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '月份',
  `riseNum` INT(11) NOT NULL DEFAULT '0' COMMENT '增加数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `ghsId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  PRIMARY KEY (`id`),
  KEY `ghs` (`ghsId`,`time`)
) COMMENT='供货商月订单量，包括未付款';
ALTER TABLE xhGhsAdmin ADD currentShopId INT NOT NULL DEFAULT 0 COMMENT '当前管理的门店' AFTER `openId`;
ALTER TABLE xhAdmin ADD currentShopId INT NOT NULL DEFAULT 0 COMMENT '当前管理的门店' AFTER `openId`;

====
==linqh 2021-01-16
ALTER TABLE `xhGhsPurchaseOrder`
CHANGE COLUMN `totalGoodsPrice` `totalItemPrice`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品总价格' AFTER `itemNumPiece`;


====
==ssh 2021-01-17
ALTER TABLE xhGhsShop AUTO_INCREMENT=35816;
ALTER TABLE xhGhsCustom CHANGE `shopId` `retailShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售门店id';
ALTER TABLE xhItem MODIFY unitNum TINYINT(4) NOT NULL DEFAULT '0' COMMENT '每扎多少支，每包多少支，每箱多少块，每扎多少条';
ALTER TABLE `xhGhsShopAdmin` ADD `super` TINYINT NOT NULL DEFAULT 0 COMMENT '是否店长或超级管理员0不是1是' AFTER `roleId`;
ALTER TABLE `xhShopAdmin` ADD `super` TINYINT NOT NULL DEFAULT 0 COMMENT '是否店长或超级管理员0不是1是' AFTER `roleId`;
ALTER TABLE `xhGhsShop` ADD adminId INT NOT NULL DEFAULT 0 COMMENT '店长id' AFTER `ghsId`;
ALTER TABLE `xhShop` ADD adminId INT NOT NULL DEFAULT 0 COMMENT '店长id' AFTER `merchantId`;
ALTER TABLE xhGhsOrder MODIFY `sendSide` TINYINT NOT NULL DEFAULT 0 COMMENT '配送方 0未选择 1达达2顺丰同城3闪送4美团';
ALTER TABLE xhOrder MODIFY `sendSide` TINYINT NOT NULL DEFAULT 0 COMMENT '配送方 0未选择 1达达2顺丰同城3闪送4美团';
ALTER TABLE xhGhsOrder ADD `receiveProvince` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '收货地址 省' AFTER `shopId`;
ALTER TABLE xhGhsOrder ADD `receiveCity` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '收货地址 市' AFTER `receiveProvince`;
ALTER TABLE xhGhsOrder ADD `receiveDist` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '收货地址 区县市' AFTER `receiveCity`;
ALTER TABLE xhGhsOrder ADD `receiveAddress` VARCHAR(300) NOT NULL DEFAULT '' COMMENT '收货地址 详细街道地址' AFTER `receiveDist`;
ALTER TABLE xhGhsOrder ADD `receiveFloor` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '收货地址 楼号门牌号' AFTER `receiveAddress`;
ALTER TABLE xhGhsOrder ADD `receiveFullAddress` VARCHAR(400) NOT NULL DEFAULT '' COMMENT '完整收货地址' AFTER `receiveFloor`;
ALTER TABLE xhGhsOrder ADD `receiveLong` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '收货的经度' AFTER `receiveFullAddress`;
ALTER TABLE xhGhsOrder ADD `receiveLat` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '收货的纬度' AFTER `receiveLong`;
ALTER TABLE `xhGhsOrder` ADD sendTime INT NOT NULL DEFAULT 0 COMMENT '配送时间' AFTER `sendSide`;
ALTER TABLE `xhGhsOrder` ADD `sendCost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '运费' AFTER `sendTime`;
ALTER TABLE `xhGhsOrder` ADD `sendTip` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '运费里增加的小费' AFTER `sendCost`;
ALTER TABLE `xhGhsOrder` ADD `sendNum` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '配送编号，方便寻找订单对应的花束' AFTER `sendTip`;
ALTER TABLE xhGhsOrderItem ADD itemInfoId INT NOT NULL DEFAULT 0 COMMENT '商家商品id' AFTER `itemId`;
INSERT INTO xhUnit VALUES(NULL,'扎',1610881951,1610881951);
INSERT INTO xhUnit VALUES(NULL,'支',1610881951,1610881951);
ALTER TABLE xhGhsOrderItem ADD smallUnit SMALLINT NOT NULL DEFAULT 2 COMMENT '小单位，支，个，条' AFTER `itemInfoId`;
ALTER TABLE xhGhsOrderItem ADD bigUnit SMALLINT NOT NULL DEFAULT 1 COMMENT '大单位，扎，箱，包' AFTER `smallUnit`;
ALTER TABLE xhGhsOrderItem ADD smallUnitName CHAR(5) NOT NULL DEFAULT '支' COMMENT '小单位中文名' AFTER `smallUnit`;
ALTER TABLE xhGhsOrderItem ADD bigUnitName CHAR(5) NOT NULL DEFAULT '扎' COMMENT '大单位中文名' AFTER `bigUnit`;
ALTER TABLE `xhGhsOrderItem` DROP COLUMN `smallUnitName`;
ALTER TABLE `xhGhsOrderItem` DROP COLUMN `bigUnitName`;
ALTER TABLE xhGhsOrderItem DROP COLUMN `ghsId`;
ALTER TABLE xhGhsOrderItem DROP COLUMN `adminId`;
CREATE TABLE `xhPurchase` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ghsId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '供货商ID',
  `ghsShopId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '供货商门店ID',
  `shopId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '门店ID',
  `status` TINYINT(2) NOT NULL DEFAULT '0' COMMENT '订单状态 1待付款，待确认，2待配送，3配送中，4已完成',
  `debt` TINYINT NOT NULL DEFAULT 0 COMMENT '欠款 1是 0没有，已结清',
  `addTime` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updateTime` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) COMMENT='采购单';
CREATE TABLE `xhPurchaseItem` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `orderId` INT NOT NULL DEFAULT 0 COMMENT '采购单id',
  `itemId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '花材ID',
  `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '花材数量',
  `unitPrice` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '采购总价',
  `price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '采购总价',
  PRIMARY KEY (`id`)
) COMMENT='采购单详情';
ALTER TABLE `xhPurchase` ADD getType TINYINT NOT NULL DEFAULT 1 COMMENT '取货方式 1配送 2自取' AFTER `shopId`;
ALTER TABLE `xhPurchase` ADD sendTime INT NOT NULL DEFAULT 0 COMMENT '配送时间' AFTER `getType`;
ALTER TABLE `xhPurchase` ADD sendCost DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '运费' AFTER `sendTime`;
ALTER TABLE `xhPurchase` ADD `itemPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '花材总金额' AFTER `shopId`;
ALTER TABLE `xhPurchase` ADD `prePrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前' AFTER `itemPrice`;
ALTER TABLE `xhPurchase` ADD `actPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后' AFTER `prePrice`;
ALTER TABLE `xhPurchase` ADD remark VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '备注' AFTER `debt`;


=======
== lqh 2021-1-17
CREATE TABLE `xhGhsStockRecord` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ghsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供货商ID',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
  `recordType` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1 采购，2出库，3入库，4盘点 5销售（开单）',
  `orderSn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单号',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemNum` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '花材数量',
  `oldStock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '原库存',
  `newStock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '新库存',
  `addTime` int(11) unsigned NOT NULL DEFAULT '0',
  `updateTime` int(11) unsigned NOT NULL DEFAULT '0',
  `extend` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '扩展字段',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='供货商库存流水记录表';

ALTER TABLE `xhItem`
ADD COLUMN `bigUnit`  smallint(6) NOT NULL DEFAULT 0 COMMENT '大单位' AFTER `unit`,
ADD COLUMN `smallUnit`  smallint(6) NOT NULL DEFAULT 0 COMMENT '小单位' AFTER `bigUnit`;

=====
== ssh 2021-1-18
ALTER TABLE xhGhsOrder MODIFY `adminId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户id，对应表xhGhsAdmin id字段';
ALTER TABLE xhGhsOrder ADD staffId INT NOT NULL DEFAULT 0 COMMENT '员工id，对应表xhGhsAdmin id字段' AFTER adminId;
ALTER TABLE xhGhsOrder MODIFY `adminId` INT NOT NULL DEFAULT 0 COMMENT '员工id，对应xhGhsAdmin id字段';
ALTER TABLE xhGhsOrder CHANGE `staffId` `userId` INT NOT NULL DEFAULT 0 COMMENT '客户id，对应xhGhsAdmin id字段';
ALTER TABLE xhGhsOrder ADD `customId` INT NOT NULL DEFAULT 0 COMMENT '客户id 对应xhCustom id字段' AFTER `userId`;
ALTER TABLE xhGhsOrder ADD customAdminId INT NOT NULL DEFAULT 0 COMMENT '客户员工id' AFTER customId;
ALTER TABLE `xhGhsOrderItem` CHANGE `itemInfoId` `productId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家商品id';
CREATE TABLE xhSupplier(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
upId INT NOT NULL DEFAULT 0 COMMENT '上游商家id，供应商id，merchantId',
merchantId INT NOT NULL DEFAULT 0 COMMENT '商家id',
`addTime` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
`updateTime` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后修改时间'
)COMMENT='供应商关系';
ALTER TABLE `xhSupplier` ADD upName VARCHAR(30) NOT NULL DEFAULT '' COMMENT '上游供应商名称' AFTER `upId`,ADD debtAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '欠款金额' AFTER `upName`,
ADD expendAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '消费金额' AFTER `debtAmount`,ADD expendNum INT NOT NULL DEFAULT 0 COMMENT '消费次数' AFTER `expendAmount`;
ALTER TABLE `xhSupplier` ADD py VARCHAR(20) NOT NULL DEFAULT '' COMMENT '' AFTER `upName`;
ALTER TABLE `xhItem` CHANGE `pyName` `py` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '花材名称的拼音首字母';
ALTER TABLE `xhGhsOrderItem` ADD orderSn CHAR(40) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `orderId`;
ALTER TABLE xhSupplier MODIFY `py` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '名称拼音首字母';
ALTER TABLE xhSupplier ADD upShopId INT NOT NULL DEFAULT 0 COMMENT '上游供货商门店id' AFTER `py`;
ALTER TABLE `xhPurchaseItem` ADD orderSn CHAR(40) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER orderId;
=======
===
==linqh 21-01-18
ALTER TABLE `xhGhsPurchaseOrder`
CHANGE COLUMN `orderStatus` `status`  tinyint(2) NOT NULL DEFAULT 0 COMMENT '订单状态：1待确认，2待配送，3配送中，4已完成' AFTER `orderSn`,
CHANGE COLUMN `itemNumBundle` `bigNum`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(大单位 -扎)' AFTER `gysId`,
CHANGE COLUMN `itemNumPiece` `smallNum`  int(11) NULL DEFAULT 0 COMMENT '合计多少商品(小单位-支)' AFTER `bigNum`,
CHANGE COLUMN `totalItemPrice` `totalPrice`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品总价格' AFTER `smallNum`,
CHANGE COLUMN `shortHaulCharge` `shortCharge`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '短途运费' AFTER `packingCharge`,
CHANGE COLUMN `lineHaulCharge` `longCharge`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '长途运费' AFTER `shortCharge`,
CHANGE COLUMN `localHaulCharge` `localCharge`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '本地运费' AFTER `pickCharge`;

ALTER TABLE `xhGhsPurchaseOrder`
CHANGE COLUMN `gysId` `supplierId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '供应商ID' AFTER `adminId`;
ALTER TABLE `xhGhsPurchaseOrder`
CHANGE COLUMN `ghsId` `merchantId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '供货商ID' AFTER `id`;

RENAME  TABLE xhGhsItemInfo to xhGhsProduct;
ALTER TABLE `xhGhsPurchaseOrderItem`
ADD COLUMN `productId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '门店的产品ID' AFTER `orderSn`;

ALTER TABLE `xhGhsItem`
CHANGE COLUMN `ghsId` `merchantId`  int(11) NOT NULL DEFAULT 0 COMMENT '商家id' AFTER `id`,
DROP INDEX `idx_ghsId` ,
ADD INDEX `idx_merchantId` (`merchantId`) USING BTREE ;

ALTER TABLE `xhGhsItemClass`
CHANGE COLUMN `ghsId` `merchantId`  int(11) NOT NULL DEFAULT 0 COMMENT '商家id' AFTER `id`,
DROP INDEX `idx_ghsId` ,
ADD INDEX `idx_merchantId` (`merchantId`) USING BTREE ;

ALTER TABLE `xhGhsStockRecord`
CHANGE COLUMN `ghsId` `merchantId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '供货商ID' AFTER `id`;

ALTER TABLE `xhGhsProduct`
CHANGE COLUMN `ghsId` `merchantId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '供货商ID' AFTER `id`;

======
== ssh 2021-1-19
drop table if exists `xhGhsOrderSn`;
CREATE TABLE if not exists  xhGhsOrderSn(
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
)AUTO_INCREMENT=26316718 COMMENT='供货商订单号';
DROP TABLE IF EXISTS `xhGhsPurchaseSn`;
CREATE TABLE IF NOT EXISTS  xhGhsPurchaseSn(
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
)AUTO_INCREMENT=26316718 COMMENT='供货商采购单号';
DROP TABLE IF EXISTS `xhPurchaseSn`;
CREATE TABLE IF NOT EXISTS  xhPurchaseSn(
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
)AUTO_INCREMENT=26316718 COMMENT='零售商采购单号';
DROP TABLE IF EXISTS `xhGhsCheckSn`;
CREATE TABLE IF NOT EXISTS  xhGhsCheckSn(
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
)AUTO_INCREMENT=26316718 COMMENT='供货商盘点单号';
DROP TABLE IF EXISTS `xhOrderSn`;
CREATE TABLE IF NOT EXISTS  xhOrderSn(
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
)AUTO_INCREMENT=26315618 COMMENT='零售商订单号';
ALTER TABLE `xhPurchase` ADD orderSn CHAR(40) NOT NULL DEFAULT '' COMMENT '订单号' AFTER `id`;
ALTER TABLE `xhPurchaseItem` DROP COLUMN `orderId`;
ALTER TABLE `xhGhsShop` CHANGE `ghsName` `merchantName` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '供货商名称';
ALTER TABLE `xhGhsShop` CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsShopAdmin` CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsAdminLog`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsAdminRole`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsAdminRoleAuth`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsCustom`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsCheckOrder`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsOrderExpress`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsStatOrderCount`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhGhsStockOrder`  CHANGE `ghsId` `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商id';
ALTER TABLE `xhPurchaseItem` CHANGE `itemId` `productId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '产品ID';
ALTER TABLE `xhPurchaseItem` CHANGE `unitPrice` `bigPrice` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '采购大单位价，每扎每包价';
ALTER TABLE `xhPurchaseItem` ADD `ratio` TINYINT NOT NULL DEFAULT 0 COMMENT '大小单位转换比例，1扎多少支，1包多少支，1箱多少块 0表示只有一个单位' AFTER `num`;
ALTER TABLE xhPurchaseItem MODIFY `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '花材数量，支持小数点';
ALTER TABLE xhPurchaseItem MODIFY `bigPrice` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '大单位价，每扎价、每包价、每箱价';
ALTER TABLE xhPurchaseItem MODIFY `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '大单位数量，支持小数点';
ALTER TABLE `xhGhsOrderItem` CHANGE `unitPrice` `bigPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位价格，每扎价格，每包价格，每箱价格';
ALTER TABLE `xhGhsOrderItem` CHANGE `unitNum` `ratio` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '大小单位转换比例，1扎多少支，1包多少支，1箱多少块 0表示只有一个单位';
ALTER TABLE `xhGhsOrderItem` MODIFY `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '大单位数量，支持小数点';
ALTER TABLE `xhGhsOrderItem` CHANGE `bigPrice` `price` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位价格，每扎价格，每包价格，每箱价格'
ALTER TABLE `xhGhsOrderItem` CHANGE `bigUnit` `unit` SMALLINT(6) NOT NULL DEFAULT '1' COMMENT '大单位，扎，箱，包';
ALTER TABLE `xhPurchaseItem` CHANGE `price` `totalPrice` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '采购总价';
ALTER TABLE `xhPurchaseItem` CHANGE `bigPrice` `price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '大单位价，每扎价、每包价、每箱价';
ALTER  TABLE xhPurchaseItem MODIFY `totalPrice` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价';
ALTER TABLE xhGhsOrderItem ADD totalPrice DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总价' AFTER `price`;
ALTER TABLE xhGhsOrderItem DROP COLUMN `orderId`;
ALTER TABLE `xhGhsOrder` CHANGE `goodsNum` `num` SMALLINT(4) NOT NULL DEFAULT '0' COMMENT '数量，大单位数量，多少扎，多少箱';
ALTER TABLE `xhGhsOrder` ADD smallNum SMALLINT NOT NULL DEFAULT 0 COMMENT '小单位数量，多少支，多少块' AFTER `num`;

===
==linqh  21-01-19
ALTER TABLE `xhGhsPurchaseOrder`
CHANGE COLUMN `bigNum` `num`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(大单位 -扎)' AFTER `supplierId`,
CHANGE COLUMN `totalPrice` `price`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品总价格' AFTER `smallNum`;

=====
== ssh 2021-01-20
ALTER TABLE `xhGhsOrder` MODIFY `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '订单状态 1待付款 2待配送 3配送中 4待通知 5已取消 6已完成';
ALTER TABLE xhGhsOrder MODIFY `sendType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1未确认 2免配送，自取 3自己送 4别人送，快递送';
ALTER TABLE `xhGhsOrder` DROP COLUMN `userId`;
ALTER TABLE xhGhsOrder CHANGE `ghsId` `merchantId` INT NOT NULL DEFAULT 0 COMMENT '商家id';
ALTER TABLE `xhGhsCustom` CHANGE `retailId` `downId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户商id，下游商家id';
ALTER TABLE `xhGhsCustom` CHANGE `retailShopId` `downShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户门店id，下游门店id';
ALTER TABLE `xhGhsCustom` CHANGE `shopName` `name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '客户名称，纯彩花艺 集美店';
ALTER TABLE `xhGhsOrder` MODIFY `sendStatus` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '配送状态 1未发货，待接单 2已发货，已接单 3已送达';
ALTER TABLE `xhGhsOrder` MODIFY `sendSide` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '配送方 1未选择 2达达 3顺丰同城 4闪送 5美团';
ALTER TABLE `xhGhsOrder` MODIFY `refund` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1正常订单 2已退款';
ALTER TABLE `xhGhsOrder` MODIFY `payStatus` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1待付款 2已付款';
ALTER TABLE `xhGhsOrder` MODIFY `printStatus` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1未打印 2已打印';
ALTER TABLE xhGhsOrder MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款 2待配送 3配送中 4待通知 5已取消 6已完成';
ALTER TABLE xhGhsOrderItem MODIFY `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '总数量';
ALTER TABLE xhGhsOrderItem ADD `smallNum` SMALLINT NOT NULL DEFAULT '0' COMMENT '小单位，支，个，条' AFTER `num`;
ALTER TABLE xhGhsOrderItem ADD `bigNum` SMALLINT NOT NULL DEFAULT '0' COMMENT '大单位，扎，包，箱' AFTER `num`;
ALTER TABLE `xhGhsOrderItem` DROP COLUMN `totalPrice`;
ALTER TABLE `xhGhsOrderItem` MODIFY `price` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总价格';
ALTER TABLE `xhGhsOrderItem` CHANGE `unit` `bigUnit` SMALLINT(6) NOT NULL DEFAULT '1' COMMENT '大单位，扎，箱，包';
ALTER TABLE xhGhsOrderItem MODIFY `ratio` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '大小单位转换比例，1扎多少支，1包多少支' AFTER `smallNum`;
ALTER TABLE xhGhsCustom ADD address VARCHAR(800) NOT NULL DEFAULT '' COMMENT '客户地址' AFTER `mobile`;
ALTER TABLE `xhGhsOrder` DROP COLUMN `addTime`;
ALTER TABLE `xhGhsOrder` DROP COLUMN `updateTime`;
ALTER TABLE `xhGhsOrder` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `payTime`;
ALTER TABLE `xhGhsOrder` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
=======

=====
==linqh
ALTER TABLE `xhGhsPurchaseOrder`
CHANGE COLUMN `num` `bigNum`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(大单位 -扎)' AFTER `supplierId`;

ALTER TABLE `xhGhsPurchaseOrder`
MODIFY COLUMN `addTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `entryTime`,
MODIFY COLUMN `updateTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `addTime`,
AUTO_INCREMENT=30;

ALTER TABLE `xhGhsPurchaseOrder`
MODIFY COLUMN `entryTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间' AFTER `orderPrice`;

=====
== ssh 2021-1-21
ALTER TABLE xhGhsOrder DROP COLUMN `payTime`;
ALTER TABLE xhGhsOrder ADD `payTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '付款时间' AFTER `deadline`;
ALTER TABLE xhGhsOrder DROP COLUMN `deadline`;
ALTER TABLE xhGhsOrder ADD `deadline` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '订单有效时间' AFTER `status`;
ALTER TABLE xhGhsOrder DROP COLUMN `sendTime`;
ALTER TABLE xhGhsOrder ADD `sendTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '配送时间' AFTER `sendSide`;
ALTER TABLE xhGhsOrder MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsOrderItem MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsPurchaseOrder MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsPurchaseOrderItem MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsCheckOrder MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsCheckOrderItem MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhPurchase MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsStockOrder MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE xhGhsStockOrderItem MODIFY `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号';
ALTER TABLE `xhGhsOrder` ADD outTime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '出库时间' AFTER `payTime`;
CREATE TABLE `xhGhsOrderSend` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号',
`actionId` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '动作id',
`option` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '动作的选项',
`finishTime` INT(11) NOT NULL DEFAULT '0' COMMENT '完成时间',
`inTurn` INT(11) NOT NULL DEFAULT '0' COMMENT '排序',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`)
) COMMENT='供货商发货管理';
ALTER TABLE xhGhsOrder ADD `totalFlow` TINYINT(4) NOT NULL DEFAULT '5' COMMENT '总流程数' AFTER `printStatus`;
ALTER TABLE xhGhsOrder ADD `currentFlow` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '完成流程数，当前流程数' AFTER `totalFlow`;

=====
==linqh 20210122

ALTER TABLE `xhGhsCheckOrder`
CHANGE COLUMN `orderStatus` `status`  tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '盘点订单状态： 1草稿，2完成' AFTER `orderSn`,
CHANGE COLUMN `itemNumBundle` `bigNum`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(扎)(盈亏）' AFTER `adminId`,
CHANGE COLUMN `itemNumPiece` `smallNum`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(支)(盈亏）' AFTER `bigNum`,
CHANGE COLUMN `totalItemPrice` `price`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品总价格(盈亏）' AFTER `smallNum`,
MODIFY COLUMN `addTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `remark`,
MODIFY COLUMN `updateTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `addTime`;

ALTER TABLE `xhGhsCheckOrderItem`
ADD COLUMN `productId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id' AFTER `orderSn`;

ALTER TABLE `xhGhsStockRecord`
MODIFY COLUMN `addTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `newStock`,
MODIFY COLUMN `updateTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `addTime`;

====
==linqh 20210123
RENAME TABLE  xhGhsStockOrder TO  xhGhsStockOutOrder
ALTER TABLE `xhGhsStockOutOrder`
CHANGE COLUMN `orderStatus` `status`  tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单状态： 1待出库，2已出库  3取消出库' AFTER `orderSn`,
CHANGE COLUMN `itemNumBundle` `bigNum`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(扎)' AFTER `adminId`,
CHANGE COLUMN `itemNumPiece` `smallNum`  int(11) NOT NULL DEFAULT 0 COMMENT '合计多少商品(支)' AFTER `bigNum`,
CHANGE COLUMN `totalItemPrice` `price`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品总价格' AFTER `smallNum`,
MODIFY COLUMN `addTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `remark`,
MODIFY COLUMN `updateTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `addTime`,
COMMENT='出库订单表';

RENAME TABLE  xhGhsStockOrderItem TO  xhGhsStockOutOrderItem

ALTER TABLE `xhGhsStockOutOrder`
ADD COLUMN `inOrderSn`  char(20) NOT NULL DEFAULT '' COMMENT '对应的入库订单号，订单完成的时候写入' AFTER `orderSn`;

CREATE TABLE `xhGhsStockInOrder` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `merchantId` int(11) NOT NULL DEFAULT '0' COMMENT '供货商id',
  `outShopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '出库的门店ID',
  `inShopId` int(11) NOT NULL DEFAULT '0' COMMENT '入库的门店ID',
  `orderSn` char(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '入库订单编号',
  `outOrderSn` char(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '对应的出库订单号',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '订单状态： 1待入库，2已入库  3取消入库',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `bigNum` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(扎)',
  `smallNum` int(11) NOT NULL DEFAULT '0' COMMENT '合计多少商品(支)',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品总价格',
  `remark` 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`),
  UNIQUE KEY `uni_orderNum` (`orderSn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='入库订单表';

CREATE TABLE `xhGhsStockInOrderItem` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `orderSn` char(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemNum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '出库花材数量',
  `itemStock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '当时的库存',
  `itemInfo` text COLLATE utf8mb4_unicode_ci COMMENT '花材信息json{"itemName":"","itemCover":"","itemRank":""}',
  `itemPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  PRIMARY KEY (`id`),
  KEY `idx_orderNum` (`orderSn`) USING BTREE,
  KEY `idx_goodsItemId` (`itemId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='出库入库订单详情表';


CREATE TABLE `xhGhsStockInSn` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26316726 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='入库订单号';

CREATE TABLE `xhGhsStockOutSn` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26316726 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='出库订单号';

ALTER TABLE `xhGhsStockInOrderItem`
ADD COLUMN `productId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID' AFTER `orderSn`;

ALTER TABLE `xhGhsStockOutOrderItem`
ADD COLUMN `productId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID' AFTER `orderSn`;

ALTER TABLE `xhGhsStockOutOrder`
ADD COLUMN `outTime`  timestamp NULL DEFAULT NULL COMMENT '出库时间' AFTER `remark`;


=====
== ssh 2021-1-24
ALTER TABLE `xhGhsOrderSend` MODIFY `finishTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '完成时间';
ALTER TABLE xhGhsOrderSend ADD `status` TINYINT NOT NULL DEFAULT 0 COMMENT '0待完成 1已完成' AFTER `finishTime`;
ALTER TABLE `xhGhsOrderSend` ADD actionName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '动作名称' AFTER `actionId`;
ALTER TABLE `xhAdmin` ADD payPassword VARCHAR(500) NOT NULL DEFAULT '' COMMENT '支付密码' AFTER `confirmPassword`;
ALTER TABLE `xhSupplier` DROP COLUMN `addTime`;
ALTER TABLE `xhSupplier` DROP COLUMN `updateTime`;
ALTER TABLE `xhSupplier` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `merchantId`;
ALTER TABLE `xhSupplier` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE xhPurchase ADD merchantId INT NOT NULL DEFAULT 0 COMMENT '商家id' AFTER `shopId`;
ALTER TABLE `xhPurchase` CHANGE `ghsId` `upId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '供货商id，上游id';
ALTER TABLE `xhPurchase` CHANGE `ghsShopId` `upShopId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '供货商门店id，上游门店id';

=====
== linqh 2021-01-24
ALTER TABLE `xhGhsProduct`
MODIFY COLUMN `addTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `adminId`,
MODIFY COLUMN `updateTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `addTime`;


====
==linqh 2021-01-25
ALTER TABLE `xhGhsPurchaseOrderItem`
ADD COLUMN `itemStock`  decimal(10,2) NOT NULL DEFAULT 0 COMMENT '当时的库存' AFTER `itemId`;

=====
== ssh 2021-01-25
ALTER TABLE `xhPurchase` ADD `supplierId` INT NOT NULL DEFAULT 0 COMMENT '供货商id' AFTER `shopId`;
ALTER TABLE `xhPurchase` DROP COLUMN `addTime`;
ALTER TABLE `xhPurchase` DROP COLUMN `updateTime`;
ALTER TABLE `xhPurchase` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `remark`;
ALTER TABLE `xhPurchase` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE `xhPurchase` ADD bigNum SMALLINT NOT NULL DEFAULT 0 COMMENT '大单位数量' AFTER `sendCost`;
ALTER TABLE `xhPurchase` ADD smallNum SMALLINT NOT NULL DEFAULT 0 COMMENT '小单位数量' AFTER `bigNum`;
ALTER TABLE `xhPurchase` ADD adminId INT NOT NULL DEFAULT 0 COMMENT '采购员' AFTER `smallNum`;
ALTER TABLE xhPurchase ADD kindNum SMALLINT NOT NULL DEFAULT 0 COMMENT '多少种' AFTER `sendCost`;
ALTER TABLE xhSupplier ADD debt TINYINT NOT NULL DEFAULT 1 COMMENT '1没有欠款 2有欠款' AFTER `upShopId`;
ALTER TABLE `xhSupplier` ADD debtNum SMALLINT NOT NULL DEFAULT 0 COMMENT '欠款订单数，欠款笔数' AFTER `debt`;
ALTER TABLE xhSupplier CHANGE `upName` `name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '供货商名称';
ALTER TABLE xhPurchase MODIFY `debt` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '欠款 0未知 1是 2没有';
DROP TABLE IF EXISTS `xhPurchaseClear`;
CREATE TABLE IF NOT EXISTS xhPurchaseClear(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `prePrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
orderSn CHAR(20) NOT NULL DEFAULT '' COMMENT '订单号',
merchantId INT NOT NULL DEFAULT 0 COMMENT '商家id',
purchaseIds TEXT NOT NULL COMMENT '结算的采购单id，json串',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
)COMMENT='采购单结算';
DROP TABLE IF EXISTS `xhPurchaseClearSn`;
CREATE TABLE IF NOT EXISTS `xhPurchaseClearSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=28356251 COMMENT='结算订单号';
ALTER TABLE xhGhsOrder MODIFY `fromType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '来源：1门店 2商城 3朋友圈';


========
== ssh 20210126
ALTER TABLE `xhWxBase` ADD `wxPayMerchantId` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '微信支付商户id' AFTER `wxRefreshToken`;
ALTER TABLE `xhWxBase` ADD `wxPayKey` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '微信支付密钥' AFTER `wxPayMerchantId`;

相应的值需要补充

=========
==shsish 20210127
ALTER TABLE `xhApply` ADD `style` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '商家类型 1零售 2供货' AFTER `merchantId`;
ALTER TABLE `xhMerchant` MODIFY `style` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '商家类型 1零售 2供货';
ALTER TABLE `xhMerchantApply` RENAME TO `xhApplyInfo`;
ALTER TABLE `xhApplyInfo` rename to `xhApplyExtend`;
ALTER TABLE `xhApplyExtend` CHANGE `subjectTitles` `subject` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '商事主体名称';
ALTER TABLE `xhApplyExtend` CHANGE `businessLicense` `license` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '营业执照';
ALTER TABLE `xhApplyExtend` ADD `licenseNo` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '营业执照号码' AFTER `license`;
ALTER TABLE `xhApplyExtend` DROP INDEX `businessLicense`;
ALTER TABLE `xhApplyExtend` DROP INDEX `bankCardNo`;
ALTER TABLE `xhApplyExtend` DROP INDEX `email`;
ALTER TABLE `xhApplyExtend` COMMENT '申请拓展信息';
ALTER TABLE `xhApply` COMMENT '申请表';
ALTER TABLE `xhApply` CHANGE `introMerchantId` `introSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '引荐商家';
ALTER TABLE `xhApply` CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '新商家id，0表示还没审核通过';
ALTER TABLE `xhApply` DROP COLUMN `addTime`;
ALTER TABLE `xhApply` DROP COLUMN `updateTime`;
ALTER TABLE `xhApply` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `status`;
ALTER TABLE `xhApply` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE `xhApply` DROP INDEX `mobile`;
ALTER TABLE `xhGhsOrder` ADD `modPrice` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0不能修改价格 1可以修改' AFTER `capitalId`;
ALTER TABLE `xhApplyExtend` DROP COLUMN `createTime`;
ALTER TABLE `xhApplyExtend` DROP COLUMN `updateTime`;
ALTER TABLE `xhApplyExtend` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `email`;
ALTER TABLE `xhApplyExtend` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;

=============
==ssh 20210128
还有余额和成长值的客户要导给国兰

===================
== ssh 20210128
ALTER TABLE `xhMerchant` MODIFY `manageStyle` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '经营类型，0零售 1花艺培训学校 2批发商（此字段应弃用）';
ALTER TABLE `xhApply` ADD main TINYINT NOT NULL DEFAULT 1 COMMENT '零售店的主营业务 1零售 2花艺培训' AFTER `style`;
ALTER TABLE `xhApply` ADD nickName VARCHAR(30) NOT NULL DEFAULT '' COMMENT '店长昵称' AFTER `adminName`;
ALTER TABLE `xhUnionUser` DROP COLUMN `createTime`;
ALTER TABLE `xhUnionUser` DROP COLUMN `updateTime`;
ALTER TABLE `xhUnionUser` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `mobile`;
ALTER TABLE `xhUnionUser` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;

ALTER TABLE `xhApply` MODIFY `from` TINYINT NOT NULL DEFAULT 1 COMMENT '来源平台 1零售平台 2供货商平台';
ALTER TABLE `xhApplyExtend` ADD applyId INT NOT NULL DEFAULT 0 COMMENT '申请id' AFTER `id`;
ALTER TABLE `xhApply` MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1审核中 2审核通过，试用中 3审核未通过 4已付费，使用中 5试用到期失效';
UPDATE `xhApply` SET `status`=1;
ALTER TABLE `xhMerchant` DROP COLUMN `setDeadline`;
ALTER TABLE `xhMerchant` DROP COLUMN `deadline`;
ALTER TABLE `xhMerchant` ADD `deadline` DATETIME NOT NULL DEFAULT '00000-00-00 00:00:00' COMMENT '帐号过期时间' AFTER setId;
UPDATE `xhMerchant` SET deadline='2022-07-09 12:00:00';

nginx增加
"~^http://ghs.huahb.com" http://ghs.huahb.com;
"~^https://ghs.huahb.com" https://ghs.huahb.com;
增加ghs.huahb.com的nginx配置 增加api.ghs.huahb.com的nginx配置 增加二者的https访问


======
==linqh 2021-1-28
ALTER TABLE `xhGhsItem`
MODIFY COLUMN `addTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `unitAddPrice`,
MODIFY COLUMN `updateTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;

==========
== ssh 20210129
ALTER TABLE `xhOrder` CHANGE `userId` `adminId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户id，员工id';
UPDATE `xhOrder` SET adminId=0;
ALTER TABLE `xhOrder` CHANGE `adminId` `customId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户id';
ALTER TABLE xhOrderGoods CHANGE `userId` `customId` INT NOT NULL DEFAULT 0 COMMENT '客户id';
DROP TABLE IF EXISTS `xhCustom`;
CREATE TABLE IF NOT EXISTS `xhCustom`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '客户名称',
adminId INT NOT NULL DEFAULT 0 COMMENT 'adminId',
merchantId INT NOT NULL DEFAULT 0 COMMENT '商家id',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
) AUTO_INCREMENT=12563516 COMMENT='零售客户表';
DROP TABLE IF EXISTS `xhCustom`;
CREATE TABLE `xhCustom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '客户名称',
  `adminId` int(11) NOT NULL DEFAULT '0' COMMENT 'adminId',
  `sjId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `totalExpend` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计消费',
  `totalIncome` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入',
  `totalRecharge` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计充值',
  `totalBuyNum` int(11) NOT NULL DEFAULT '0' COMMENT '消费次数',
  `getCouponNum` int(11) NOT NULL DEFAULT '0' COMMENT '已领卷次数',
  `balance` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `integral` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `growth` int(11) NOT NULL DEFAULT '0' COMMENT '成长值',
  `discount` float(3,2) NOT NULL DEFAULT '1.00' COMMENT '折扣',
  `inviteNum` int(11) NOT NULL DEFAULT '0' COMMENT '邀请新人数量',
  `member` smallint(6) NOT NULL DEFAULT '0' COMMENT '会员等级 0普遍客户 大于等于1 会员',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) COMMENT='客户表';
ALTER TABLE `xhCustom` ADD `mobile` VARCHAR(15) NOT NULL DEFAULT '0' COMMENT '手机号' AFTER `name`;
ALTER TABLE xhCustom ADD `visitTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '最后一次访问时间' AFTER `member`;

======
==linqh 2021-1-31

ALTER TABLE `xhGhsProduct`
ADD COLUMN `priceLabel`  tinyint(2) UNSIGNED NOT NULL DEFAULT 1 COMMENT '价格标识（price）: 1 自动调价，2改价' AFTER `price`;

======
==linqh 2021-2-2
ALTER TABLE `xhGhsStockRecord`
MODIFY COLUMN `itemNum`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '花材数量' AFTER `itemId`;

CREATE TABLE `xhExpressLocal` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `deliveryId` varchar(20) NOT NULL DEFAULT '' COMMENT '快递ID',
  `deliveryName` varchar(50) NOT NULL DEFAULT '' COMMENT '快递名称',
  `appKey` varchar(100) NOT NULL DEFAULT '' COMMENT 'app key',
  `appSecret` varchar(200) NOT NULL DEFAULT '' COMMENT 'appSecret',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '状态：1启用，2关闭',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_deliveryId` (`deliveryId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='即时配送快递公司信息';

=========
== ssh 2021-2-2



===========
== ssh 20201-2-4
ALTER TABLE `xhGhsCustom` ADD isDebt TINYINT NOT NULL DEFAULT 0 COMMENT '是否有欠款 0没有 1有' AFTER debt;
ALTER TABLE xhGhsOrder ADD debt TINYINT NOT NULL DEFAULT 0 COMMENT '0没有欠款 1有欠款' AFTER `refund`;
CREATE TABLE `xhGhsOrderClear` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `prePrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
  `orderSn` CHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `orderIds` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'id的json串',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) COMMENT='清算订单';
CREATE TABLE `xhGhsOrderClearSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=12358276 COMMENT='清算订单号';
DROP TABLE IF EXISTS `xhExpress`;
ALTER TABLE xhExpressLocal RENAME TO xhExpress;
ALTER TABLE xhOrderExpress CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id';
ALTER TABLE xhGhsOrderExpress CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id';
ALTER TABLE xhOrderExpress CHANGE `sideId` `expressId` INT(11) NOT NULL DEFAULT '0' COMMENT '配送方id';
ALTER TABLE xhGhsOrderExpress CHANGE `sideId` `expressId` INT(11) NOT NULL DEFAULT '0' COMMENT '配送方id';

===============
== ssh 2021-2-18
ALTER TABLE `xhItem` MODIFY `unitNum` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '大小单位转换比例，每扎多少支';
ALTER TABLE `xhItem` MODIFY `unitWeight` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位重量，每扎多少公斤';
ALTER TABLE `xhItem` MODIFY `unitCost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位采购价，每扎成本价，采购价';
ALTER TABLE `xhItem` MODIFY `unitAddPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位加价，每扎加价';
ALTER TABLE `xhGhsItem` MODIFY `unitWeight` FLOAT(10,2) NOT NULL DEFAULT '0.00' COMMENT '大单位重量，每扎重量(斤)';
ALTER TABLE `xhGhsItem` MODIFY `unitCost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位采购价，每扎成本价，采购价';
ALTER TABLE `xhGhsItem` MODIFY `unitAddPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位加价，每扎加价';
ALTER TABLE xhItem ADD alias VARCHAR(50) NOT NULL DEFAULT '' COMMENT '花材别名' AFTER `name`;

TRUNCATE `xhItem`;
ALTER TABLE xhItem AUTO_INCREMENT=1000;

请直接将xhItem xhItemClass xhUnit 表和数据迁移到线上

ALTER TABLE xhItemClass ADD `group` TINYINT NOT NULL DEFAULT 0 COMMENT ' 所属分组，0默认平台的分类' AFTER `name`;
ALTER TABLE xhItem ADD classId INT NOT NULL DEFAULT 0 COMMENT '平台分类id' AFTER `cover`;
ALTER TABLE `xhItem`
MODIFY COLUMN `addTime`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
MODIFY COLUMN `updateTime`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间';
ALTER TABLE xhOrderGoods ADD orderSn CHAR(20) NOT NULL DEFAULT '' COMMENT '' AFTER `orderId`;
ALTER TABLE xhOrder ADD packingFee DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '包装费' AFTER `anonymity`;
ALTER TABLE xhOrder ADD orderType TINYINT NOT NULL DEFAULT 1 COMMENT '1成品订单 2花材订单' AFTER `goodsNum`;
DROP TABLE IF EXISTS `xhOrderItem`;
CREATE TABLE IF NOT EXISTS `xhOrderItem`(
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `orderSn` CHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `itemId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家花材id',
  `productId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家商品id',
  `smallUnit` SMALLINT(6) NOT NULL DEFAULT '2' COMMENT '小单位，支，个，条',
  `bigUnit` SMALLINT(6) NOT NULL DEFAULT '1' COMMENT '大单位，扎，箱，包',
  `price` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总价格',
  `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '总数量',
  `bigNum` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '大单位数量，扎，包，箱',
  `smallNum` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '小单位数量，支，个，条',
  `ratio` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '大小单位转换比例，1扎多少支，1包多少支'
)COMMENT='零售订单的花材';
DROP TABLE IF EXISTS `xhRecharge`;
CREATE TABLE IF NOT EXISTS `xhRecharge`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '支付方式 0微信 1支付宝 2余额',
`payCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回号',
sjId INT NOT NULL DEFAULT 0 COMMENT '商家id',
sjStyle TINYINT NOT NULL DEFAULT 1 COMMENT '商家类型 1零售 2供货',
shopId INT NOT NULL DEFAULT 0 COMMENT '门店id',
`amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
`totalRecharge` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '门店累计充值'
)COMMENT='门店充值记录';
DROP TABLE IF EXISTS `xhRechargeSn`;
CREATE TABLE IF NOT EXISTS `xhRechargeSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=18213721 COMMENT='充值订单号';
ALTER TABLE xhRecharge ADD orderSn CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `id`;
ALTER TABLE `xhRecharge` ADD `modPrice` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0不能修改价格 1可以修改' AFTER `orderSn`;
ALTER TABLE `xhRecharge` ADD `deadline` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '订单有效时间' AFTER `modPrice`;
ALTER TABLE xhRecharge ADD payStatus TINYINT NOT NULL DEFAULT 1 COMMENT '1待付款 2已付款' AFTER `totalRecharge`;
DROP TABLE `xhGhsShopAdmin`;
DROP TABLE `xhGhsShop`;
ALTER TABLE `xhShop` MODIFY `createTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间';
ALTER TABLE xhShop ADD balance DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额' AFTER `adminId`;
ALTER TABLE xhShop ADD fixBalance DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '只能向推荐人消费的余额，指定余额' AFTER `balance`;
ALTER TABLE xhMerchant ADD parentId INT NOT NULL DEFAULT 0 COMMENT '父id' AFTER `adminId`;
ALTER TABLE `xhRecharge` ADD INDEX `orderSn` (`orderSn`);
DROP TABLE IF EXISTS `xhRechargeRecord`;
CREATE TABLE IF NOT EXISTS `xhRechargeRecord`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
sjId INT NOT NULL DEFAULT 0 COMMENT '商家id',
shopId INT NOT NULL DEFAULT 0 COMMENT '门店id',
`amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
`totalRecharge` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
`remark` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '备注',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
)COMMENT='充值记录';
ALTER TABLE `xhShop` DROP COLUMN `createTime`;
ALTER TABLE `xhShop` DROP COLUMN `addTime`;
ALTER TABLE `xhShop` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `status`;
ALTER TABLE xhRechargeRecord RENAME TO xhRechargeLog;
ALTER TABLE xhShop ADD totalRecharge DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计充值' AFTER `fixBalance`;
ALTER TABLE xhRecharge ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `payStatus`;
ALTER TABLE xhRecharge ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE xhRecharge ADD remark VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '' AFTER `payStatus`;
DROP TABLE IF EXISTS `xhRechargeLog`;
ALTER TABLE xhMerchantCapital RENAME TO xhSjCapital;
DROP TABLE IF EXISTS `xhWithdraw`;
DROP TABLE IF EXISTS `xhCash`;
CREATE TABLE IF NOT EXISTS `xhCash`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
sjId INT NOT NULL DEFAULT 0 COMMENT '商家id',
shopId INT NOT NULL DEFAULT 0 COMMENT '',
amount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '提现金额',
balance DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '当前余额',
`status` TINYINT NOT NULL DEFAULT 1 COMMENT '1待处理 2处理中 3已完成',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
)COMMENT='提现订单';
ALTER TABLE `xhCash` ADD `event` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '事项' AFTER `shopId`;
ALTER TABLE xhMerchant DROP COLUMN `addTime`;
ALTER TABLE xhMerchant DROP COLUMN `createTime`;
ALTER TABLE xhMerchant ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `status`;
ALTER TABLE xhShopAdmin DROP COLUMN `addTime`;
ALTER TABLE xhShopAdmin ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `status`;
ALTER TABLE xhShopAdmin ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE xhMerchantAsset DROP COLUMN `createTime`;
ALTER TABLE xhMerchantAsset ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `remainSmsNum`;
ALTER TABLE xhApplyExtend ADD certType TINYINT NOT NULL DEFAULT 1 COMMENT '证件类型 1营业执照 2身份证号 3手机号' AFTER licenseNo;
ALTER TABLE xhMerchant RENAME TO xhSj;
ALTER TABLE xhMerchantAsset RENAME TO xhSjAsset;
ALTER TABLE xhMerchantExtend RENAME TO xhSjExtend;
ALTER TABLE xhMerchantInit RENAME TO xhSjInit;
ALTER TABLE xhMerchantRemark RENAME TO xhSjRemark;
ALTER TABLE xhGhsCustom CHANGE downId `customSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户对应的商家id';
ALTER TABLE xhGhsCustom CHANGE `downShopId` `customShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户对应的门店id';
ALTER TABLE xhGhsCustom CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的商家id';
ALTER TABLE xhGhsCustom DROP COLUMN `addTime`;
ALTER TABLE xhGhsCustom DROP COLUMN `updateTime`;
ALTER TABLE xhGhsCustom ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `buyAmount`;
ALTER TABLE xhGhsCustom ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;

DROP TABLE IF EXISTS `xhUserOldData`;
DROP TABLE IF EXISTS `xhUserPast`;
CREATE TABLE IF NOT EXISTS `xhUserPast` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `userName` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `mobile` VARCHAR(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `integral` INT(11) NOT NULL DEFAULT '0' COMMENT '积分数',
  `balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1未同步 2已同步',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) COMMENT='客户历史';
ALTER TABLE xhUserPast CHANGE `integral` growth INT(11) NOT NULL DEFAULT '0' COMMENT '成长值';

===
==linqh 2021-2-24
ALTER TABLE `xhExpress`
ADD COLUMN `shopNo`  varchar(100) NOT NULL DEFAULT '' COMMENT '门店' AFTER `appSecret`;

========
== ssh 2021-2-25
需要琦海配好线上的wss以及确认HTTP_ORIGIN限制问题

ALTER TABLE xhApply ADD `licenseNo` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '营业执照号码' AFTER `name`;
ALTER TABLE xhApply ADD `certType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '证件类型 1营业执照 2身份证号 3手机号' AFTER `licenseNo`;
ALTER TABLE xhApplyExtend DROP COLUMN `certType`;
ALTER TABLE xhWxOpen ADD `style` TINYINT NOT NULL DEFAULT 1 COMMENT '平台类型 1零售 2供货' AFTER `appSecret`;
ALTER TABLE xhAdmin ADD recentShop VARCHAR(500) NOT NULL DEFAULT '' COMMENT '最近访问的店铺' AFTER `currentShopId`;
ALTER TABLE xhGhsAdmin ADD recentShop VARCHAR(500) NOT NULL DEFAULT '' COMMENT '最近访问的店铺' AFTER `currentShopId`;
ALTER TABLE xhApply MODIFY `certType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '证件类型 1营业执照 2身份证号';
ALTER TABLE xhApply MODIFY `licenseNo` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '营业执照号，身份证号';
ALTER TABLE xhApplyExtend MODIFY `licenseNo` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '营业执照号，身份证号';
ALTER TABLE xhApplyExtend MODIFY `license` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '营业执照，身份证照';
ALTER TABLE xhApply MODIFY `introStyle` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '商家类型 同 xhSj的style字段';
ALTER TABLE xhApply ADD introSjName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '商家名称' AFTER `introStyle`;
ALTER TABLE xhApply ADD introShopId INT NOT NULL DEFAULT 0 COMMENT '引荐商家的门店' AFTER `introSjName`;
ALTER TABLE xhApply ADD customId INT NOT NULL DEFAULT 0 COMMENT '客户id' AFTER `introShopId`;
ALTER TABLE xhApply ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id' AFTER `customId`;

需要哪些供货商要跟纯彩花艺收集好并且导入

ALTER TABLE xhGhsCustom ADD `py` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '拼音首字母' AFTER `name`;
ALTER TABLE xhCustom ADD `py` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '拼音首字母' AFTER `name`;
ALTER TABLE xhGhsOrder ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id' AFTER `adminId`;
ALTER TABLE xhGhsOrder MODIFY `adminId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id';
DROP TABLE IF EXISTS xhAdmin;
DROP TABLE IF EXISTS xhAdminRole;
DROP TABLE IF EXISTS xhAdminRoleAuth;
DROP TABLE IF EXISTS xhAdminLog;
ALTER TABLE xhGhsAdmin RENAME TO xhAdmin;
ALTER TABLE xhGhsAdminRole RENAME TO xhAdminRole;
ALTER TABLE xhGhsAdminRoleAuth RENAME TO xhAdminRoleAuth;
ALTER TABLE xhGhsAdminLog RENAME TO xhAdminLog;
ALTER TABLE `xhAdmin` MODIFY `identity` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '身份 0未知 1客户(跳转到最近访问店铺) 2员工';

=======linqh 21-03-01
ALTER TABLE xhItem RENAME TO xhPtItem;
ALTER TABLE xhItemClass RENAME TO xhPtItemClass;

CREATE TABLE `xhItem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sjId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `classId` int(11) NOT NULL DEFAULT '0' COMMENT '商家花材分类id',
  `itemId` int(11) NOT NULL DEFAULT '0' COMMENT '平台花材id',
  `rank` char(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A' COMMENT '花材级别',
  `unitWeight` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '大单位重量，每扎重量(斤)',
  `stockWarning` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '库存预警',
  `unitCost` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '大单位采购价，每扎成本价，采购价',
  `unitAddPrice` decimal(9,2) NOT NULL DEFAULT '0.00' 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 `idx_itemId` (`itemId`) USING BTREE,
  KEY `idx_classId` (`classId`) USING BTREE,
  KEY `idx_sjId` (`sjId`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='花店花材';

CREATE TABLE `xhItemClass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sjId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '' COMMENT '名称',
  `inTurn` int(11) NOT NULL DEFAULT '0' COMMENT '排序，越大越靠前',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `updateTime` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `idx_sjId` (`sjId`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='花店花材分类';

CREATE TABLE `xhProduct` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sjId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID',
  `shopId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID',
  `itemId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `stock` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '库存，多少扎,可以出现负库存',
  `rank` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'B' COMMENT '花材等级 A、B、C、D',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '每扎的价格(对应等级价格)',
  `priceLabel` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '价格标识（price）: 1 自动调价，2改价',
  `actualSold` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际销售量',
  `viewNum` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
  `delStatus` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '删除标识 0未删除 1删除',
  `adminId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后操作人',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='花店的商品表，对应各个门店';


=======
==== ssh 2021-03-02
ALTER TABLE xhGhsOrderItem ADD unitPrice DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '单价，大单位价格' AFTER `price`;
ALTER TABLE `xhGhsOrderItem` ADD `rank` CHAR(5) NOT NULL DEFAULT 'A' COMMENT '花材级别' AFTER `bigUnit`;
ALTER TABLE `xhGhsOrderItem` ADD `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '花材名称' AFTER `id`;
ALTER TABLE `xhGhsOrderItem` ADD cover VARCHAR(500) NOT NULL DEFAULT '' COMMENT '花材封面' AFTER `name`;
ALTER TABLE xhGhsOrderItem ADD INDEX orderSn(`orderSn`);
ALTER TABLE xhGhsOrder CHANGE `num` bigNum SMALLINT NOT NULL DEFAULT 0 COMMENT '大单位数量';
ALTER TABLE xhGhsOrder ADD hasItem TINYINT NOT NULL DEFAULT 1 COMMENT '1订单有花材 2没有花材' AFTER `smallNum`;

=====
==linqh 2021-03-02
ALTER TABLE `xhItem`
ADD COLUMN `inTurn`  int(11) NOT NULL DEFAULT 0 COMMENT '排序，数字越大越靠前' AFTER `unitAddPrice`;

=====
== ssh 2021-3-4
ALTER TABLE xhOrder DROP COLUMN `addTime`;
ALTER TABLE xhOrder ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `createTime`;
ALTER TABLE xhGhsOrder MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款 2待配送 3配送中 4已完成 5已取消 6已退款';
ALTER TABLE `xhOrder` MODIFY `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '订单状态 1待付款 2待配送 3配送中 4已完成 5已取消 6已退款';
ALTER TABLE xhOrderSend ADD orderSn CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `id`;

确认国兰全部订单已经配送完成后 请将国兰订单全部置为已完成或已取消状态 其中付款的已完成 未付款的已取消

========
== ssh 2021-3-5
ALTER TABLE `xhTrainClass` DROP COLUMN `createTime`;
ALTER TABLE `xhTrainClass` DROP COLUMN `addTime`;
ALTER TABLE `xhTrainClass` DROP COLUMN `modTime`;
ALTER TABLE `xhTrainClass` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `sort`;
ALTER TABLE `xhTrainClass` CHANGE `sort` `inTrun` INT(11) NOT NULL DEFAULT '0' COMMENT '排序';
ALTER TABLE `xhTrainClass` CHANGE `merchantId` `sjId` INT NOT NULL DEFAULT 0 COMMENT '商家id';
ALTER TABLE `xhTrainCourse` CHANGE `merchantId` `sjId` INT NOT NULL DEFAULT 0 COMMENT '商家id';
DROP TABLE IF EXISTS `xhTrainCoursePraise`;
ALTER TABLE `xhTrainTeacher` DROP COLUMN `addTime`;
ALTER TABLE `xhTrainTeacher` DROP COLUMN `modTime`;
ALTER TABLE `xhTrainTeacher` CHANGE `createTime` `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间';
ALTER TABLE xhTrainUserCourse RENAME TO xhPxUserCourse;
ALTER TABLE xhTrainTeacher RENAME TO xhPxTeacher;
ALTER TABLE xhTrainCourse RENAME TO xhPxCourse;
ALTER TABLE xhTrainClass RENAME TO xhPxClass;
ALTER TABLE `xhOrder` MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款 2待配送 3配送中 4已完成 5已取消 6已退款';
ALTER TABLE xhPxTeacher CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id';
ALTER TABLE xhPxUserCourse CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id';
ALTER TABLE `xhAdmin` ADD `style` TINYINT NOT NULL DEFAULT 1 COMMENT '类型 1花店的 2供货商的' AFTER `identity`;
RENAME TABLE `xhStaff` TO `xhPtAdmin`;
RENAME TABLE `xhWxBase` TO `xhWxGzh`;
RENAME TABLE `xhWxMiniBase` TO `xhWxMini`;
ALTER TABLE xhWxOpen DROP COLUMN `appIdCreated`;
ALTER TABLE xhAdmin MODIFY `identity` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '用户身份 1客户 2员工';
ALTER TABLE `xhShop` ADD `txBalance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '可提现余额' AFTER `balance`;
ALTER TABLE xhCash MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1处理中 2已完成';
ALTER TABLE xhGhsOrderClear CHANGE `orderIds` `orderStr` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单id的json串';
ALTER TABLE xhGhsOrderClear CHANGE `orderStr` `orderText` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单id的json文本串';
ALTER TABLE xhGhsOrderClear ADD customId INT NOT NULL DEFAULT 0 COMMENT '客户id' AFTER `sjId`;
ALTER TABLE xhGhsOrderClear ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id' AFTER `customId`;
ALTER TABLE xhGhsOrderClear ADD clearType TINYINT NOT NULL DEFAULT 1 COMMENT '清算方式 1花店发起清算 2供货商发起清算' AFTER `shopAdminId`;
ALTER TABLE `xhGhsOrder` MODIFY `debt` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0正常订单 1欠款';
ALTER TABLE `xhGhsOrder` ADD clearId INT NOT NULL DEFAULT 0 COMMENT '欠款清算id' AFTER `debt`;
CREATE TABLE `xhGhsStatYj` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '时间戳',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT NOT NULL DEFAULT 0 COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`sjId`,`time`)
) COMMENT='员工每天开单业绩';
CREATE TABLE `xhGhsStatYjMonth` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '月份',
  `year` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '年',
  `month` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '月份',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT NOT NULL DEFAULT 0 COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`sjId`,`year`,`month`)
) COMMENT='员工每月开单业绩';
ALTER TABLE `xhGhsStatYj` ADD totalAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额' AFTER `amount`;
ALTER TABLE `xhGhsStatYj` ADD `num` INT NOT NULL DEFAULT 0 COMMENT '开单数量' AFTER `totalAmount`;
ALTER TABLE `xhGhsStatYj` ADD `totalNum` INT NOT NULL DEFAULT 0 COMMENT '总数量' AFTER `num`;
ALTER TABLE `xhGhsStatYjMonth` ADD totalAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额' AFTER `amount`;
ALTER TABLE `xhGhsStatYjMonth` ADD `num` INT NOT NULL DEFAULT 0 COMMENT '开单数量' AFTER `totalAmount`;
ALTER TABLE `xhGhsStatYjMonth` ADD `totalNum` INT NOT NULL DEFAULT 0 COMMENT '总数量' AFTER `num`;
CREATE TABLE `xhStatYj` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '时间戳',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `totalAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '开单数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`sjId`,`time`)
) COMMENT='员工每天开单业绩';
CREATE TABLE `xhStatYjMonth` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '月份',
  `year` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '年',
  `month` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '月份',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `totalAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '开单数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`sjId`,`year`,`month`)
) COMMENT='员工每月开单业绩';
ALTER TABLE xhShopAdmin ADD adminName VARCHAR(80) NOT NULL DEFAULT '' COMMENT '员工名称' AFTER `adminId`;
ALTER TABLE xhGhsOrderExpress ADD `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER orderId;
ALTER TABLE xhOrderExpress ADD `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER orderId;
ALTER TABLE xhGhsOrderExpress MODIFY `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1待接单 2已接单 3已完成 4已取消';
ALTER TABLE xhOrderExpress MODIFY `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1待接单 2已接单 3已完成 4已取消';
ALTER TABLE `xhGhsOrder` CHANGE `sendSide` `expressId` SMALLINT NOT NULL DEFAULT 0 COMMENT '配送方id';
ALTER TABLE `xhOrder` CHANGE `sendSide` `expressId` SMALLINT NOT NULL DEFAULT 0 COMMENT '配送方id';
ALTER TABLE `xhGhsOrderExpress` ADD expressName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '配送方名称' AFTER `expressId`;
ALTER TABLE `xhOrderExpress` ADD expressName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '配送方名称' AFTER `expressId`;
DROP TABLE IF EXISTS `xhPxUserCourse`;
ALTER TABLE xhPxClass CHANGE `inTrun` `inTurn` INT NOT NULL DEFAULT 100 COMMENT '排序';
ALTER TABLE xhPxClass ADD `num` INT NOT NULL DEFAULT 0 COMMENT '学生数量' AFTER `sjId`;
ALTER TABLE xhPxClass ADD delStatus TINYINT NOT NULL DEFAULT 0 COMMENT '删除状态 0正常 1已删' AFTER `inTurn`;
CREATE TABLE `xhPxOrder` (
  `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `orderSn` CHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号',
  `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '支付方式',
  `payReturnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回号',
  `capitalId` INT(11) NOT NULL DEFAULT '0' COMMENT '流水id',
  `prePrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `customId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户id 对应xhCustom id字段',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `remark` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款 2已付款，已确认',
  `payTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '付款时间',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) COMMENT='培训开班订单';
ALTER TABLE `xhPxTeacher` CHANGE `teacherName` `name` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '名称';
ALTER TABLE xhPxTeacher CHANGE `rank` inTurn INT NOT NULL DEFAULT 100 COMMENT '排序';
ALTER TABLE xhStudent RENAME TO xhPxStudent;
ALTER TABLE xhPxOrder CHANGE `payReturnCode` `returnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回数据';
ALTER TABLE xhPxOrder ADD `mobile` VARCHAR(15) NOT NULL DEFAULT '' COMMENT '手机号' AFTER `orderSn`;
ALTER TABLE xhPxOrder ADD `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '学生姓名' AFTER `mobile`;
ALTER TABLE xhAdmin MODIFY `mobile` VARCHAR(15) NOT NULL DEFAULT '' COMMENT '手机号';
ALTER TABLE xhPxOrder RENAME TO xhPxApply;
CREATE TABLE `xhPxApplySn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=13613582 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='培训报名订单号';
ALTER TABLE xhPxApply ADD classId INT NOT NULL DEFAULT 0 COMMENT '培训班id' AFTER `capitalId`;
ALTER TABLE xhPxApply ADD className VARCHAR(50) NOT NULL DEFAULT '' COMMENT '培训班名称' AFTER `classId`;
ALTER TABLE xhPxApply ADD classCover VARCHAR(500) NOT NULL DEFAULT '' COMMENT '培训班封面';
ALTER TABLE xhPxClass ADD cover VARCHAR(500) NOT NULL DEFAULT '' COMMENT '封面' AFTER `name`;
ALTER TABLE xhPxClass MODIFY `name` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '名称';
ALTER TABLE xhPxApply DROP COLUMN `classCover`;
ALTER TABLE xhPxApply ADD classCover VARCHAR(500) NOT NULL DEFAULT '' COMMENT '培训班封面' AFTER `className`;
ALTER TABLE `xhActOrder` CHANGE `payCode` `returnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回数据';
ALTER TABLE `xhGhsOrder` CHANGE `payCode` `returnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回数据';
ALTER TABLE `xhOrder` CHANGE `payCode` `returnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回数据';
ALTER TABLE xhPxApply ADD applyTime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '报名时间' AFTER payTime;
ALTER TABLE xhShop ADD totalStudent INT NOT NULL DEFAULT 0 COMMENT '总学员数' AFTER `totalRecharge`;
CREATE TABLE `xhStatStudent` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '时间戳',
  `riseNum` INT(11) NOT NULL DEFAULT '0' COMMENT '增加数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  PRIMARY KEY (`id`),
  KEY `sjId` (`time`,`shopId`)
) COMMENT='每天新增学员数';
CREATE TABLE `xhStatStudentMonth` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '月份',
  `year` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '年',
  `month` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '月份',
  `riseNum` INT(11) NOT NULL DEFAULT '0' COMMENT '增加数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  PRIMARY KEY (`id`),
  KEY `sjId` (`year`,`month`,`shopId`)
) COMMENT='每月新增学员数';
DROP TABLE IF EXISTS `xhUserCapital`;
CREATE TABLE `xhCustomCapital` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `alipayId` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '支付宝用户id',
  `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `relateId` INT(11) NOT NULL DEFAULT '0' COMMENT '关联id；订单id',
  `capitalType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '流水订单的类型 参考configDict capitalType',
  `operateId` INT(11) NOT NULL DEFAULT '0' COMMENT '操作人id adminId 等',
  `balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `io` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '收支类型0支出 1收入',
  `totalIncome` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入',
  `totalExpend` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计支出',
  `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '资金收支方式0微信1支付宝2余额3现金，具体请查看配置文件configDict payWay',
  `event` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '事项，说明，类型的具体解释',
  `userName` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '用户名',
  `remark` VARCHAR(500) 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`)
) COMMENT='客户收支';
CREATE TABLE `xhShopCapital` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `relateId` INT(11) NOT NULL DEFAULT '0' COMMENT '关联id；订单id',
  `capitalType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '流水类型',
  `balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `affectBalance` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '是否影响商家的可提现余额 0不影响 1影响，如支付宝支付，提现',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '本次流水金额',
  `io` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '收支类型 0支出 1收入',
  `totalIncome` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入变化',
  `totalExpend` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计支出变化',
  `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '付款方式；支付方式',
  `sourceType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '来源',
  `fromType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '来源 0门店 1商城 2朋友圈 3..',
  `usageId` INT(11) NOT NULL DEFAULT '0' COMMENT '用途id',
  `categoryId` INT(11) NOT NULL DEFAULT '0' COMMENT '分类id',
  `event` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '事项，说明，类型的具体解释',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '0表示商家所有门店',
  `userId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `userName` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '用户名',
  `alipayId` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '支付宝的uid',
  `operateId` INT(11) NOT NULL DEFAULT '0' COMMENT '操作人 adminId userId merchantId',
  `remark` VARCHAR(500) 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`)
) COMMENT='门店收支';
ALTER TABLE `xhSjCapital` DROP COLUMN `shopId`;
ALTER TABLE `xhSjCapital` CHANGE merchantId `sjId` INT NOT NULL DEFAULT 0 COMMENT '商家id';
CREATE TABLE `xhGhsCustomCapital` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `alipayId` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝用户id',
  `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `relateId` INT(11) NOT NULL DEFAULT '0' COMMENT '关联id；订单id',
  `capitalType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '流水订单的类型 参考configDict capitalType',
  `operateId` INT(11) NOT NULL DEFAULT '0' COMMENT '操作人id adminId 等',
  `balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `io` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '收支类型0支出 1收入',
  `totalIncome` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计收入',
  `totalExpend` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计支出',
  `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '资金收支方式0微信1支付宝2余额3现金，具体请查看配置文件configDict payWay',
  `event` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '事项，说明，类型的具体解释',
  `userName` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `remark` VARCHAR(500) 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`)
) COMMENT='客户收支';
ALTER TABLE xhOrder MODIFY `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '支付方式';
ALTER TABLE xhGhsOrder MODIFY `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '支付方式';

线上的bucket需要提醒琦海设置

ALTER TABLE xhGhsOrder ADD customName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '客户名称' AFTER `customId`;
ALTER TABLE xhGhsOrder ADD customNamePy VARCHAR(20) NOT NULL DEFAULT '' COMMENT '客户名称拼音首字母' AFTER `customName`;
ALTER TABLE xhGhsOrder ADD customAvatar VARCHAR(800) NOT NULL DEFAULT '' COMMENT '客户头像' AFTER `customNamePy`;
ALTER TABLE xhGhsOrder ADD customMobile CHAR(15) NOT NULL DEFAULT '' COMMENT '客户手机号' AFTER `customAvatar`;
ALTER TABLE xhGhsCustom ADD `province` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '省' AFTER `debtAmount`;
ALTER TABLE xhGhsCustom ADD `city` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '市' AFTER `province`;
ALTER TABLE xhGhsCustom ADD `dist` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '区县' AFTER `city`;
ALTER TABLE xhGhsCustom ADD `floor` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '楼号门牌号' AFTER `province`;
ALTER TABLE xhGhsCustom ADD `fullAddress` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '完整地址' AFTER `floor`;
ALTER TABLE xhGhsCustom ADD `lat` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '纬度' AFTER `fullAddress`;
ALTER TABLE xhGhsCustom ADD `long` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '经度' AFTER `lat`;

ALTER TABLE xhShop ADD `totalOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '总订单数；包括付款和未付款的' AFTER `default`;
ALTER TABLE xhShop ADD `payOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '付款订单数' AFTER `totalOrder`;
ALTER TABLE xhShop ADD `finishOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '完成订单数' AFTER `payOrder`;
ALTER TABLE xhShop ADD `unPayOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '待付款订单数' AFTER `finishOrder`;
ALTER TABLE xhShop ADD `unSendOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '待配送订单数' AFTER `unPayOrder`;
ALTER TABLE xhShop ADD `sendingOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '配送中订单数' AFTER `unSendOrder`;
ALTER TABLE xhShop ADD `cancelOrder` INT(11) NOT NULL DEFAULT '0' COMMENT '已取消订单数' AFTER `sendingOrder`;

ALTER TABLE xhWxOpen MODIFY `style` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '平台类型 1花店 2供货商 3花店商城';
ALTER TABLE xhWxOpen DROP COLUMN `wxGhsMiniBaseId`;
ALTER TABLE xhWxOpen DROP COLUMN `wxGhsBaseId`;

ALTER TABLE `xhGhsOrder` CHANGE `receiveProvince` `province` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 省';
ALTER TABLE `xhGhsOrder` CHANGE `receiveCity` `city` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 市';
ALTER TABLE `xhGhsOrder` CHANGE `receiveDist` `dist` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 区县市';
ALTER TABLE `xhGhsOrder` CHANGE `receiveAddress` `address` VARCHAR(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 详细街道地址';
ALTER TABLE `xhGhsOrder` CHANGE `receiveFloor` `floor` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 楼号门牌号';
ALTER TABLE `xhGhsOrder` CHANGE `receiveFullAddress` `fullAddress` VARCHAR(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '完整收货地址';
ALTER TABLE `xhGhsOrder` CHANGE `receiveLong` `long` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货的经度';
ALTER TABLE `xhGhsOrder` CHANGE `receiveLat` `lat` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货的纬度';
ALTER TABLE `xhOrder` CHANGE `receiveProvince` `province` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 省';
ALTER TABLE `xhOrder` CHANGE `receiveCity` `city` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 市';
ALTER TABLE `xhOrder` CHANGE `receiveDist` `dist` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 区县市';
ALTER TABLE `xhOrder` CHANGE `receiveAddress` `address` VARCHAR(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 详细街道地址';
ALTER TABLE `xhOrder` CHANGE `receiveFloor` `floor` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址 楼号门牌号';
ALTER TABLE `xhOrder` CHANGE `receiveFullAddress` `fullAddress` VARCHAR(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '完整收货地址';
ALTER TABLE `xhOrder` CHANGE `receiveLong` `long` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货的经度';
ALTER TABLE `xhOrder` CHANGE `receiveLat` `lat` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货的纬度';

ALTER TABLE xhWxGzh ADD `auth` TINYINT NOT NULL DEFAULT 2 COMMENT '1已授权 2未授权' AFTER `openAppId`;
ALTER TABLE xhWxMini CHANGE miniAuth `auth` TINYINT NOT NULL DEFAULT 1 COMMENT '1未授权 2已授权';
ALTER TABLE xhWxGzh MODIFY `auth` TINYINT NOT NULL DEFAULT 1 COMMENT '1未授权 2已授权';

TRUNCATE `xhUser`;
TRUNCATE `xhUserAlipay`;
TRUNCATE `xhUserAsset`;
TRUNCATE `xhUserMerge`;
TRUNCATE `xhUserPast`;
TRUNCATE `xhUserTag`;
TRUNCATE `xhUserTagClass`;
TRUNCATE `xhUserUpgrade`;
ALTER TABLE xhUser DROP COLUMN `merchantId`;
ALTER TABLE xhCustom CHANGE `adminId` `userId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id';
ALTER TABLE xhCustom ADD UNIQUE INDEX custom(`sjId`,`userId`);
ALTER TABLE xhShop ADD `cashAccount` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '支付宝提现帐号' AFTER `cancelOrder`;
ALTER TABLE xhShop ADD `cashName` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '支付宝提现姓名' AFTER `cashAccount`;
ALTER TABLE xhShopAdmin ADD avatar VARCHAR(800) NOT NULL DEFAULT '' COMMENT '头像' AFTER `adminId`;

确认三个公众号的模板消息已经导入完整

ALTER TABLE xhRenew CHANGE `payCode` `returnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回数据';
DROP TABLE IF EXISTS `xhRenewSn`;
CREATE TABLE IF NOT EXISTS `xhRenewSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=18623508 COMMENT='续费订单号';
ALTER TABLE xhOrder DROP COLUMN `createTime`;
ALTER TABLE xhAdmin ADD INDEX `admin`(`mobile`,`style`);
ALTER TABLE xhApply ADD avatar VARCHAR(800) NOT NULL DEFAULT '' COMMENT '商家头像' AFTER `id`;
ALTER TABLE xhApply MODIFY `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '商家名称';

=====
==linqh 2021-03-26

CREATE TABLE `xhSjExpress` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sjId` int(10) unsigned NOT NULL DEFAULT '0',
  `sourceId` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '快递的方的商户ID',
  `label` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '快递标识（自定义，可以扩展其他快递方）',
  `adminId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商户快递配置表';

CREATE TABLE `xhShopExpress` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shopId` int(10) unsigned NOT NULL DEFAULT '0',
  `sjId` int(10) unsigned NOT NULL DEFAULT '0',
  `shopNo` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '快递的方的门店ID',
  `label` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '快递标识（自定义，可以扩展其他快递方）',
  `adminId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='门店快递配置表';
=======
ALTER TABLE xhGhsPurchaseOrder ADD `prePrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前' AFTER `price`;
ALTER TABLE xhGhsPurchaseOrder ADD `actPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后，包括运费' AFTER `prePrice`;
ALTER TABLE xhGhsPurchaseOrder ADD kind TINYINT NOT NULL DEFAULT 0 COMMENT '多少种花材' AFTER `smallNum`;
ALTER TABLE xhGhsPurchaseOrder ADD debt TINYINT NOT NULL DEFAULT 0 COMMENT '是否欠款 0正常 1欠款' AFTER `actPrice`;
ALTER TABLE xhGhsPurchaseOrder MODIFY `status` TINYINT NOT NULL DEFAULT 1 COMMENT '订单状态 1待付款 2待发货 3配送中 4已签收 5已入库 6已取消';
ALTER TABLE xhSjExtend RENAME TO xhSjExt;
ALTER TABLE xhApplyExtend RENAME TO xhApplyExt;

==========
==ssh 2021-03-27
ALTER TABLE `xhStatYj` DROP INDEX `yj`;
ALTER TABLE `xhStatYj` ADD UNIQUE INDEX `yj`(`shopId`,`time`);
ALTER TABLE `xhStatYjMonth` DROP INDEX `yj`;
ALTER TABLE `xhStatYjMonth` ADD UNIQUE INDEX `yj`(`shopId`,`time`);
ALTER TABLE `xhGhsStatYj` DROP INDEX `yj`;
ALTER TABLE `xhGhsStatYj` ADD UNIQUE INDEX `yj`(`shopId`,`time`);
ALTER TABLE `xhGhsStatYjMonth` DROP INDEX `yj`;
ALTER TABLE `xhGhsStatYjMonth` ADD UNIQUE INDEX `yj`(`shopId`,`time`);

DROP TABLE IF EXISTS `xhStatYj`;
CREATE TABLE IF NOT EXISTS `xhStatYj` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '时间戳',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `totalAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '开单数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`shopId`,`shopAdminId`,`time`)
) COMMENT='员工每天开单业绩';
DROP TABLE IF EXISTS `xhStatYjMonth`;
CREATE TABLE IF NOT EXISTS `xhStatYjMonth` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '月份',
  `year` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '年',
  `month` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '月份',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `totalAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '开单数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`shopId`,`shopAdminId`,`time`)
)COMMENT='员工每月开单业绩';
DROP TABLE IF EXISTS `xhGhsStatYj`;
CREATE TABLE IF NOT EXISTS `xhGhsStatYj` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '时间戳',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `totalAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '开单数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yj` (`shopId`,`shopAdminId`,`time`)
)COMMENT='员工每天开单业绩';
DROP TABLE IF EXISTS `xhGhsStatYjMonth`;
CREATE TABLE IF NOT EXISTS `xhGhsStatYjMonth` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `time` INT(11) NOT NULL DEFAULT '0' COMMENT '月份',
  `year` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '年',
  `month` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '月份',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '开单金额',
  `totalAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
  `num` INT(11) NOT NULL DEFAULT '0' COMMENT '开单数量',
  `totalNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`)
) COMMENT='员工每月开单业绩';
ALTER TABLE xhRecharge ADD `status` TINYINT NOT NULL DEFAULT 1 COMMENT '1待充值 2已充值' AFTER `payStatus`;
ALTER TABLE xhRecharge CHANGE `payCode` `returnCode` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '支付返回数据';
ALTER TABLE xhShopAdmin DROP COLUMN `default`;
ALTER TABLE xhShopAdmin ADD mobile CHAR(15) NOT NULL DEFAULT '' COMMENT '手机号' AFTER `adminName`;
ALTER TABLE xhShopAdmin AUTO_INCREMENT=125631;
ALTER TABLE xhSupplier RENAME TO xhGhs;
ALTER TABLE xhGhs ADD avatar VARCHAR(800) NOT NULL DEFAULT '' COMMENT '头像' AFTER `id`;
ALTER TABLE xhGhs CHANGE `upId` `ghsSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的商家id';
ALTER TABLE xhGhs CHANGE `upShopId` `ghsShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的门店id';
ALTER TABLE xhGhs MODIFY `ghsShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的门店id' AFTER ghsSjId;
ALTER TABLE xhGhs ADD shopId INT NOT NULL DEFAULT 0 COMMENT '门店id' AFTER `ghsShopId`;
ALTER TABLE xhGhs ADD sjId INT NOT NULL DEFAULT 0 COMMENT '商家id' AFTER `ghsShopId`;
ALTER TABLE xhGhs DROP COLUMN `merchantId`;
ALTER TABLE `xhGhs` MODIFY `name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '供货商名称' AFTER `avatar`;
ALTER TABLE `xhGhs` MODIFY `py` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '名称拼音首字母' AFTER `name`;
ALTER TABLE `xhGhs` ADD mobile CHAR(15) NOT NULL DEFAULT '' COMMENT '手机号' AFTER `py`;
DROP TABLE IF EXISTS `xhGhs`;
CREATE TABLE IF NOT EXISTS `xhGhs` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `avatar` VARCHAR(800) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '头像',
  `name` VARCHAR(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '供货商名称',
  `py` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称拼音首字母',
  `mobile` CHAR(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `province` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '省',
  `city` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '市',
  `dist` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '区县',
  `address` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '街道地址',
  `floor` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '楼号门牌号',
  `fullAddress` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '完整地址',
    `lat` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '纬度',
  `long` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '经度',
  `ghsSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的商家id',
  `ghsShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的门店id',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `debt` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1没有欠款 2有欠款',
  `debtNum` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '欠款订单数，欠款笔数',
  `debtAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '欠款金额',
  `expendAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '消费金额',
  `expendNum` INT(11) NOT NULL DEFAULT '0' COMMENT '消费次数',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=125861 COMMENT='供应商关系';
ALTER TABLE `xhSj` DROP COLUMN `shopName`;
ALTER TABLE `xhSj` CHANGE `shopProvince` `province` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '省';
ALTER TABLE `xhSj` CHANGE `shopCity` `city` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '市';
ALTER TABLE `xhSj` CHANGE  `shopDist` `dist` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '区县';
ALTER TABLE `xhSj` CHANGE  `shopAddress` `address` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '详细街道地址';
ALTER TABLE `xhSj` CHANGE  `shopLat` `lat` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '商店的纬度';
ALTER TABLE `xhSj` CHANGE  `shopLong` `long` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '商店的经度';
ALTER TABLE `xhSj` CHANGE  `shopPrecision` `precision` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '商店的精度';
ALTER TABLE `xhSj` CHANGE  `shopPhotoList` `photoList` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '店面门牌照片 json';
ALTER TABLE `xhSj` ADD fullAddress VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '完整地址' AFTER `address`;
ALTER TABLE `xhSj` DROP COLUMN `property`;
ALTER TABLE `xhSj` MODIFY `style` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '商家类型 1花店 2供货商 3昆明供货商';
ALTER TABLE `xhSj` CHANGE `merchantName` `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '商家名称';

========
==linqh
ALTER TABLE `xhGhsOrderExpress`
MODIFY COLUMN `distance`  decimal(10,1) NOT NULL DEFAULT 0.0 COMMENT '距离' AFTER `expressName`;

ALTER TABLE `xhGhsOrderExpress`
ADD COLUMN `dmName`  varchar(200) NOT NULL DEFAULT '' COMMENT '骑手名' AFTER `sendTime`,
ADD COLUMN `dmMobile`  varchar(30) NOT NULL DEFAULT '' COMMENT '骑手手机号' AFTER `dbName`;

============
==shish
ALTER TABLE `xhGhsItemClass` ADD num SMALLINT NOT NULL DEFAULT 0 COMMENT '花材数量' AFTER `name`;
ALTER TABLE `xhGhsItemClass` DROP COLUMN `addTime`;
ALTER TABLE `xhGhsItemClass` DROP COLUMN `updateTime`;
ALTER TABLE `xhGhsItemClass` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER adminId;
ALTER TABLE `xhGhsItemClass` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `addTime`;
ALTER TABLE `xhItemClass` ADD num SMALLINT NOT NULL DEFAULT 0 COMMENT '花材数量' AFTER `name`;
ALTER TABLE `xhItemClass` DROP COLUMN `addTime`;
ALTER TABLE `xhItemClass` DROP COLUMN `updateTime`;
ALTER TABLE `xhItemClass` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER adminId;
ALTER TABLE `xhItemClass` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `addTime`;

所有小程序 基础库最低版本 设置为2.1.1

ALTER TABLE `xhGhsItem` ADD inTurn INT NOT NULL DEFAULT 100 COMMENT '排序' AFTER `unitAddPrice`;

ALTER TABLE `xhItem` CHANGE `unitWeight` `weight` FLOAT(10,2) NOT NULL DEFAULT '0.00' COMMENT '每扎(大单位)重量(公斤)';
ALTER TABLE `xhItem` CHANGE `unitCost` `cost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎(大单位)成本价';
ALTER TABLE `xhItem` CHANGE `unitAddPrice` `addPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎(大单位)加价';
ALTER TABLE `xhGhsItem` CHANGE `unitWeight` `weight` FLOAT(10,2) NOT NULL DEFAULT '0.00' COMMENT '每扎(大单位)重量(公斤)';
ALTER TABLE `xhGhsItem` CHANGE `unitCost` `cost` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎(大单位)成本价';
ALTER TABLE `xhGhsItem` CHANGE `unitAddPrice` `addPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '每扎(大单位)加价';


=======linqh 2021-04-01
===

ALTER TABLE `xhPtItem`
CHANGE COLUMN `unitWeight` `weight`  decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '大单位重量，每扎多少公斤' AFTER `unitNum`,
CHANGE COLUMN `unitCost` `cost`  decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '大单位采购价，每扎成本价，采购价' AFTER `weight`,
CHANGE COLUMN `unitAddPrice` `addPrice`  decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '大单位加价，每扎加价' AFTER `cost`;

ALTER TABLE `xhPtItem`
CHANGE COLUMN `unitNum` `ratio`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '大小单位转换比例，每扎多少支' AFTER `classId`;

ALTER TABLE `xhPtItem`
MODIFY COLUMN `ratio`  tinyint(4) NOT NULL DEFAULT 1 COMMENT '大小单位转换比例，每扎多少支' AFTER `classId`;

=====linqh 2021-04-06
==
ALTER TABLE `xhGhsProduct`
ADD COLUMN `cost`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '成本价' AFTER `adminId`,
ADD COLUMN `addPrice`  decimal(9,1) NOT NULL DEFAULT 0 COMMENT '每扎加价' AFTER `cost`;

ALTER TABLE `xhGhsProduct`
MODIFY COLUMN `addPrice`  decimal(9,2) NOT NULL DEFAULT 0.0 COMMENT '每扎加价' AFTER `cost`,
ADD COLUMN `name`  varchar(50) NOT NULL DEFAULT '' COMMENT '花材名称' AFTER `id`,
ADD COLUMN `cover`  varchar(500) NOT NULL DEFAULT '' COMMENT '花材图片' AFTER `name`,
ADD COLUMN `stockWarning`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '库存预警' AFTER `addPrice`;

=======

=====shish 2021-4-7
UPDATE `xhPtItem` SET ratio = 1 WHERE ratio=0;
ALTER TABLE xhGhsCustom ADD `growth` INT(11) NOT NULL DEFAULT '0' COMMENT '成长值' AFTER `dist`;
ALTER TABLE xhGhsCustom ADD `visitTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次访问时间';
ALTER TABLE xhCustom MODIFY `visitTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次访问时间';
ALTER TABLE `xhItem` MODIFY `stockWarning` MEDIUMINT NOT NULL DEFAULT 0 COMMENT '库存预警，大单位数量';
ALTER TABLE `xhGhsItem` MODIFY `stockWarning` MEDIUMINT NOT NULL DEFAULT 0 COMMENT '库存预警，大单位数量';
ALTER TABLE xhPtItem ADD `stockWarning` MEDIUMINT NOT NULL DEFAULT 0 COMMENT '库存预警，大单位数量' AFTER `weight`;
UPDATE xhPtItem SET stockWarning=5;
ALTER TABLE xhGhsCustom CHANGE  buyAmount `totalExpend` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计消费';
ALTER TABLE xhGhsCustom CHANGE `totalExpend` buyAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计消费';
ALTER TABLE xhCustom CHANGE `totalExpend` `buyAmount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计消费';
ALTER TABLE xhCustom ADD buyNum INT NOT NULL DEFAULT 0 COMMENT '消费次数' AFTER `buyAmount`;
ALTER TABLE xhGhsCustom ADD rechargeAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计充值' AFTER `buyAmount`;
ALTER TABLE xhCustom ADD rechargeAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计充值' AFTER `buyNum`;
ALTER TABLE xhCustom DROP COLUMN totalRecharge;
ALTER TABLE xhCustom CHANGE `rechargeAmount` `recharge` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计充值';
ALTER TABLE xhGhsCustom CHANGE `rechargeAmount` `recharge` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计充值';
ALTER TABLE xhGhsOrder ADD shopAdminName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '员工名称' AFTER `shopAdminId`;

=============linqh 2021-04-07
=====
ALTER TABLE `xhItem`
MODIFY COLUMN `weight`  decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '每扎(大单位)重量(公斤)' AFTER `rank`,
ADD COLUMN `name`  varchar(50) NOT NULL DEFAULT '' COMMENT '花材名称' AFTER `rank`,
ADD COLUMN `alias`  varchar(50) NOT NULL DEFAULT '' COMMENT '别名' AFTER `name`,
ADD COLUMN `py`  varchar(20) NOT NULL DEFAULT '' COMMENT '拼音' AFTER `alias`,
ADD COLUMN `cover`  varchar(500) NOT NULL DEFAULT '' COMMENT '图片' AFTER `py`,
ADD COLUMN `ratio`  tinyint(4) NOT NULL DEFAULT 1 COMMENT '比例' AFTER `cover`,
ADD COLUMN `bigUnit`  smallint(6) NULL DEFAULT 0 COMMENT '大单位' AFTER `addPrice`,
ADD COLUMN `smallUnit`  smallint(6) NULL DEFAULT 0 COMMENT '小单位' AFTER `bigUnit`;

ALTER TABLE `xhGhsItem`
MODIFY COLUMN `weight`  decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '每扎(大单位)重量(公斤)' AFTER `rank`,
ADD COLUMN `name`  varchar(50) NOT NULL DEFAULT '' COMMENT '花材名称' AFTER `rank`,
ADD COLUMN `alias`  varchar(50) NOT NULL DEFAULT '' COMMENT '别名' AFTER `name`,
ADD COLUMN `py`  varchar(20) NOT NULL DEFAULT '' COMMENT '拼音' AFTER `alias`,
ADD COLUMN `cover`  varchar(500) NOT NULL DEFAULT '' COMMENT '图片' AFTER `py`,
ADD COLUMN `ratio`  tinyint(4) NOT NULL DEFAULT 1 COMMENT '比例' AFTER `cover`,
ADD COLUMN `bigUnit`  smallint(6) NULL DEFAULT 0 COMMENT '大单位' AFTER `addPrice`,
ADD COLUMN `smallUnit`  smallint(6) NULL DEFAULT 0 COMMENT '小单位' AFTER `bigUnit`;


ALTER TABLE `xhGhsProduct`
MODIFY COLUMN `stockWarning`  mediumint(9) NOT NULL DEFAULT 0 COMMENT '库存预警' AFTER `addPrice`,
ADD COLUMN `weight`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '大单位重量 公斤' AFTER `stockWarning`,
ADD COLUMN `alias`  varchar(50) NOT NULL DEFAULT '' COMMENT '别名' AFTER `weight`,
ADD COLUMN `py`  varchar(20) NOT NULL DEFAULT '' COMMENT '拼音' AFTER `alias`,
ADD COLUMN `ratio`  tinyint(4) NOT NULL DEFAULT 1 COMMENT '比例' AFTER `py`,
ADD COLUMN `bigUnit`  smallint(6) NOT NULL DEFAULT 0 COMMENT '大单位' AFTER `ratio`,
ADD COLUMN `smallUnit`  smallint(6) NOT NULL DEFAULT 0 COMMENT '小单位' AFTER `bigUnit`;


====== shish 2021-4-9
ALTER TABLE xhCustom DROP COLUMN `totalBuyNum`;
ALTER TABLE `xhUser` ADD recentShop VARCHAR(800) NOT NULL DEFAULT '' COMMENT '最近访问的店铺' AFTER `visitTime`;
ALTER TABLE xhPurchaseClear ADD `deadline` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '订单失效时间' AFTER `purchaseIds`;
ALTER TABLE xhPurchaseClear ADD changePrice TINYINT NOT NULL DEFAULT 1 COMMENT '1可以修改价格 2不能修改价格，微信发起支付后不能修改' AFTER `deadline`;
ALTER TABLE xhPtItemClass ADD `num` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '花材数量' AFTER `group`;
ALTER TABLE `xhPtItem` ADD inTurn MEDIUMINT NOT NULL DEFAULT 100 COMMENT '排序' AFTER `smallUnit`;
ALTER TABLE xhPtItemClass DROP COLUMN `addTime`;
ALTER TABLE xhPtItemClass DROP COLUMN `updateTime`;
ALTER TABLE xhPtItemClass ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `inTurn`;
ALTER TABLE xhPtItemClass ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
ALTER TABLE xhAdmin CHANGE `confirmPassword` `payPassword` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '支付密码';

========
==linqh 2021-4-9
ALTER TABLE `xhGoods`
ADD COLUMN `py`  varchar(20) NOT NULL DEFAULT '' COMMENT '拼音' AFTER `shortUrl`;

ALTER TABLE `xhGhsOrder`
ADD COLUMN `weight`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '花材总重量(公斤)' AFTER `status`;

CREATE TABLE `xhGoodsItem` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goodsId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '成品ID',
  `productId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '花材ID',
  `itemId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '平台花材ID',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='成品对应的花材';


=====linqh 2021-4-11
==
ALTER TABLE `xhPtItem`
MODIFY COLUMN `bigUnit`  varchar(20) NOT NULL DEFAULT '' COMMENT '大单位名称' AFTER `unit`,
MODIFY COLUMN `smallUnit`  varchar(20) NOT NULL DEFAULT '' COMMENT '小单位' AFTER `bigUnit`,
ADD COLUMN `bigUnitId`  smallint(6) NOT NULL DEFAULT 1 COMMENT '大单位ID' AFTER `smallUnit`,
ADD COLUMN `smallUnitId`  smallint(6) NOT NULL DEFAULT 2 COMMENT '小单位ID' AFTER `bigUnitId`;

ALTER TABLE `xhGhsItem`
MODIFY COLUMN `bigUnit`  varchar(20) NOT NULL DEFAULT '' COMMENT '大单位名称' AFTER `addPrice`,
MODIFY COLUMN `smallUnit`  varchar(20) NOT NULL DEFAULT '' COMMENT '小单位' AFTER `bigUnit`,
ADD COLUMN `bigUnitId`  smallint(6) NOT NULL DEFAULT 1 COMMENT '大单位ID' AFTER `smallUnit`,
ADD COLUMN `smallUnitId`  smallint(6) NOT NULL DEFAULT 2 COMMENT '小单位ID' AFTER `bigUnitId`;

ALTER TABLE `xhGhsProduct`
MODIFY COLUMN `bigUnit`  varchar(20) NOT NULL DEFAULT '' COMMENT '大单位名称' AFTER `ratio`,
MODIFY COLUMN `smallUnit`  varchar(20) NOT NULL DEFAULT '' COMMENT '小单位' AFTER `bigUnit`,
ADD COLUMN `bigUnitId`  smallint(6) NOT NULL DEFAULT 1 COMMENT '大单位ID' AFTER `smallUnit`,
ADD COLUMN `smallUnitId`  smallint(6) NOT NULL DEFAULT 2 COMMENT '小单位ID' AFTER `bigUnitId`;

====shish 2021-4-11
ALTER TABLE `xhPurchase` ADD deadline DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '有效期' AFTER `debt`;
ALTER TABLE xhPurchase ADD changePrice TINYINT NOT NULL DEFAULT 1 COMMENT '1可以修改价格 2不能修改' AFTER `orderSn`;
ALTER TABLE xhGhsProduct ADD classId INT NOT NULL DEFAULT 0 COMMENT '分类id' AFTER `merchantId`;

========linqh 2021-4-12
ALTER TABLE `xhGhsProduct`
ADD COLUMN `inTurn`  int(10) NOT NULL DEFAULT 100 COMMENT '排序' AFTER `smallUnitId`;

====shish 2021-4-13
ALTER TABLE xhPurchase DROP COLUMN `sendTime`;
ALTER TABLE xhPurchase ADD `sendTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'  COMMENT '实际配送时间' AFTER `getType`;
ALTER TABLE xhPurchase ADD `sendTimeWant` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'  COMMENT '客户要求的发货时间' AFTER `sendTime`;
ALTER TABLE xhGhsOrder DROP COLUMN `sendTime`;
ALTER TABLE xhGhsOrder ADD `sendTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'  COMMENT '实际配送时间' AFTER `expressId`;
ALTER TABLE xhGhsOrder ADD `sendTimeWant` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'  COMMENT '客户要求的发货时间' AFTER `sendTime`;
ALTER TABLE xhOrderExpress DROP COLUMN `sendTime`;
ALTER TABLE xhOrderExpress ADD `sendTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'  COMMENT '实际配送时间' AFTER `tip`;
ALTER TABLE xhOrderExpress ADD `sendTimeWant` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'  COMMENT '客户要求的发货时间' AFTER `sendTime`;
ALTER TABLE xhApply CHANGE `avatar` `logo` VARCHAR(800) NOT NULL DEFAULT '' COMMENT '商家头像';
ALTER TABLE xhAdmin DROP COLUMN `identity`;

国兰原有的商品拼音需要补回去


ALTER TABLE xhShopAdmin ADD VARCHAR(500) NOT NULL DEFAULT '' COMMENT '添加员工时的备注' AFTER `super`;
ALTER TABLE xhShopAdmin ADD founder TINYINT NOT NULL DEFAULT 1 COMMENT '创始人 1不是 2是' AFTER `super`;
ALTER TABLE xhShop ADD `totalPurchase` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '累计采购' AFTER `totalPurchaseOrder`;

======linqh 2021-04-14
==
ALTER TABLE `xhShop`
ADD COLUMN `freezeBalance`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '提现时被冻结的余额' AFTER `balance`,
ADD COLUMN `totalExpend`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '总支出' AFTER `totalIncome`,
ADD COLUMN `totalView`  int(11) NOT NULL DEFAULT 0 COMMENT '累计访问次数' AFTER `status`,
ADD COLUMN `totalUser`  int(11) NOT NULL DEFAULT 0 COMMENT '总用户；总客户数' AFTER `totalView`,
ADD COLUMN `totalPurchaseOrder`  int(11) NOT NULL DEFAULT 0 COMMENT '总采购订单' AFTER `totalUser`;

=======linqh 2021-4-15
===
ALTER TABLE `xhStatIncome`
ADD COLUMN `totalAmount`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '总收入金额' AFTER `amount`;
ALTER TABLE `xhStatIncomeMonth`
ADD COLUMN `totalAmount`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '总收入' AFTER `amount`;

==============linqh 2021-04-16
======
ALTER TABLE `xhStatUser`
ADD COLUMN `shopId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '门店ID' AFTER `merchantId`,
ADD INDEX `idx_shopId` (`shopId`) ;

ALTER TABLE `xhStatUserMonth`
ADD COLUMN `shopId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '门店ID' AFTER `merchantId`,
ADD INDEX `idx_shopId` (`shopId`) ;


======shish 2021-4-17
ALTER TABLE xhStatIncomeMonth DROP INDEX `income`;
ALTER TABLE xhStatIncome DROP INDEX `income`;
ALTER TABLE xhAdmin ADD apply TINYINT NOT NULL DEFAULT 1 COMMENT '是否已申请开店 1没有 2有' AFTER `super`;
ALTER TABLE xhAdmin MODIFY `apply` TINYINT NOT NULL DEFAULT 1 COMMENT '申请开店 1没有 2有申请，待审核 3有申请，已审核通过';
ALTER TABLE `xhAdmin` CHANGE `apply` `openShop` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '申请开店 1没有 2有申请，待审核 3有申请，已审核通过';
ALTER TABLE `xhShop` CHANGE `payOrder` `totalOrderNum` INT(11) NOT NULL DEFAULT '0' COMMENT '总订单，只包括已付款订单，暂不考虑退款订单';
ALTER TABLE xhSjAsset CHANGE `payOrder` `totalOrderNum` INT(11) NOT NULL DEFAULT '0' COMMENT '付款的总订单数，不考虑退款';
TRUNCATE `xhStatIncome`;
TRUNCATE `xhStatIncomeMonth`;
TRUNCATE `xhStatOrder`;
TRUNCATE `xhStatOrderMonth`;
ALTER TABLE xhStatIncome ADD UNIQUE INDEX shop(`shopId`,`time`);
ALTER TABLE xhStatIncomeMonth ADD UNIQUE INDEX shop(`shopId`,`time`);
ALTER TABLE xhStatOrder DROP INDEX `merchant`;
ALTER TABLE xhStatOrderMonth DROP INDEX `merchant`;
ALTER TABLE xhStatOrder ADD UNIQUE INDEX shop(`shopId`,`time`);
ALTER TABLE xhStatOrderMonth ADD UNIQUE INDEX shop(`shopId`,`time`);
TRUNCATE `xhStatOut`;
TRUNCATE `xhStatOutMonth`;
ALTER TABLE xhStatOut ADD UNIQUE INDEX shop(`shopId`,`time`);
ALTER TABLE xhStatOutMonth ADD UNIQUE INDEX shop(`shopId`,`time`);
TRUNCATE `xhStatStudent`;
TRUNCATE `xhStatStudentMonth`;
ALTER TABLE xhStatStudent ADD UNIQUE INDEX shop(`shopId`,`time`);
ALTER TABLE xhStatStudentMonth ADD UNIQUE INDEX shop(`shopId`,`time`);
ALTER TABLE `xhAdmin` CHANGE `nickName` `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '名称';
ALTER TABLE `xhAdmin` DROP COLUMN `adminName`;
ALTER TABLE `xhShopAdmin` CHANGE `adminName` `name` VARCHAR(80) NOT NULL DEFAULT '' COMMENT '姓名';
ALTER TABLE `xhPtAdmin` CHANGE `adminName` `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '管理员姓名';
ALTER TABLE xhApply DROP COLUMN `nickName`;
ALTER TABLE `xhUser` CHANGE `nickName` `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '名称';
ALTER TABLE `xhUser` DROP COLUMN `userName`;
ALTER TABLE `xhUser` DROP COLUMN `realName`;
ALTER TABLE `xhStatView` ADD shopId INT NOT NULL DEFAULT 0 COMMENT '' AFTER `merchantId`;
ALTER TABLE `xhStatViewMonth` ADD shopId INT NOT NULL DEFAULT 0 COMMENT '' AFTER `merchantId`;
ALTER TABLE `xhStatVisit` ADD shopId INT NOT NULL DEFAULT 0 COMMENT '' AFTER `merchantId`;
ALTER TABLE `xhStatVisitMonth` ADD shopId INT NOT NULL DEFAULT 0 COMMENT '' AFTER `merchantId`;
ALTER TABLE xhShop ADD totalItem INT NOT NULL DEFAULT 0 COMMENT '总花材数' AFTER `totalExpend`;

============linqh  2021-4-20
===
ALTER TABLE `xhShop`
ADD COLUMN `mayGathering`  decimal(9,2) NOT NULL DEFAULT 0 COMMENT '应收款' AFTER `totalPurchase`;

ALTER TABLE `xhGhsPurchaseOrder`
ADD INDEX `idx_shopId` (`shopId`) ,
ADD INDEX `idx_addTime` (`addTime`) ;

====shish 20210422
ALTER TABLE `xhSj` ADD parentShopId INT NOT NULL DEFAULT 0 COMMENT '父级门店' AFTER parentId;
ALTER TABLE `xhSj` MODIFY `parentId` INT(11) NOT NULL DEFAULT '0' COMMENT '父级商家id，介绍人';
ALTER TABLE `xhShop` ADD mobile VARCHAR(15) NOT NULL DEFAULT '' COMMENT '手机号' AFTER `totalStudent`;
ALTER TABLE xhGhsCustom MODIFY `isOpen` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '已开店 0没有 1有';
ALTER TABLE `xhGhsCustom` ADD UNIQUE INDEX `custom`(`sjId`,`customSjId`,`customShopId`);
ALTER TABLE `xhGhs` ADD UNIQUE INDEX `ghs`(`sjId`,`ghsSjId`,`ghsShopId`);
ALTER TABLE xhStatOrderCount DROP INDEX `merchant`;
ALTER TABLE `xhStatOrderCount` ADD UNIQUE INDEX `shop`(`shopId`,`time`);
ALTER TABLE `xhAd` DROP INDEX `merchantId`;
ALTER TABLE `xhAd` MODIFY `type` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '广告类型 0商城首页广告图';
CREATE TABLE `xhShopAd` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `adName` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '广告名称',
  `delStatus` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0正常 1删除',
  `inTurn` INT(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `adImg` VARCHAR(800) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '广告图',
  `viewTimes` INT(11) NOT NULL DEFAULT '0' COMMENT '点击次数',
  `merchantId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `style` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0 url 1商品id',
  `url` VARCHAR(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链接',
  `goodsId` INT(11) NOT NULL DEFAULT '0' COMMENT '商品id',
  `startTime` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endTime` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '结束时间；值4102416000(2100-01-01 00:00:00)表示永不过期情况',
  `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '启用状态 0 未启用 1 启用',
  `addTime` INT(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `multiple` (`merchantId`,`status`,`startTime`,`endTime`)
)COMMENT='门店图片';
ALTER TABLE xhShopAd RENAME TO xhShopImg;
ALTER TABLE `xhCategory` MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态 0停用1启用';
ALTER TABLE xhGoods MODIFY `py` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '拼音' AFTER goodsName;
ALTER TABLE xhGoodsCategory ADD py VARCHAR(50) NOT NULL DEFAULT '' COMMENT '拼音' AFTER `goodsName`;
ALTER TABLE `xhShop` ADD rechargeNum INT NOT NULL DEFAULT 0 COMMENT '充值续期数量' AFTER `mayGathering`;
DROP TABLE IF EXISTS `xhRenewLog`;
CREATE TABLE IF NOT EXISTS `xhRenewLog`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`event` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '事项',
`type` TINYINT NOT NULL DEFAULT 1 COMMENT '1付费订单 2充值花款续期',
`beforeDeadline` INT(11) NOT NULL DEFAULT '0' COMMENT '之前到期时间',
`deadline` INT(11) NOT NULL DEFAULT '0' COMMENT '续费后到期时间',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
)COMMENT='续期记录表';
ALTER TABLE `xhSj` ADD beforeDeadline DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '上次到期时间' AFTER `setId`;
ALTER TABLE `xhRenewLog` DROP COLUMN `deadline`;
ALTER TABLE `xhRenewLog` DROP COLUMN `beforeDeadline`;
ALTER TABLE `xhRenewLog` ADD deadline DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '到期时间' AFTER `type`;
ALTER TABLE `xhRenewLog` ADD beforeDeadline DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '上次到期时间' AFTER `deadline`;
ALTER TABLE `xhRenew` DROP COLUMN `deadline`;
ALTER TABLE `xhRenew` DROP COLUMN `beforeDeadline`;
ALTER TABLE `xhRenew` ADD deadline DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '到期时间' AFTER `setId`;
ALTER TABLE `xhRenew` ADD beforeDeadline DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '上次到期时间' AFTER `deadline`;
ALTER TABLE xhSjExt ADD rechargeRenew TINYINT NOT NULL DEFAULT 1 COMMENT '参与充值续期活动 1没有 2有' AFTER `rrkdKey`;
DROP TABLE IF EXISTS `xhShopImg`;
ALTER TABLE xhShop ADD img VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '图片' AFTER `adminId`;
ALTER TABLE xhPurchase DROP COLUMN `upId`;
ALTER TABLE xhPurchase DROP COLUMN `upShopId`;
ALTER TABLE xhPurchase MODIFY `status` TINYINT(2) NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款，待确认，2待配送，3配送中，4已完成';
ALTER TABLE xhPurchase ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id' AFTER `merchantId`;
ALTER TABLE xhPurchase ADD shopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '员工姓名' AFTER shopAdminId;
ALTER TABLE xhGhsPurchaseOrder ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id' AFTER `merchantId`;
ALTER TABLE xhGhsPurchaseOrder ADD shopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '员工姓名' AFTER shopAdminId;

执行命令将原有的商品拼音补齐 yii goods/py

===============linqh  2021-04-25
=====
ALTER TABLE `xhGhsPurchaseOrder`
ADD COLUMN `supplierInfo`  varchar(500) NOT NULL DEFAULT '' COMMENT '供应商信息' AFTER `supplierId`;


==== shish 20210426
ALTER TABLE xhGhsPurchaseOrder CHANGE `supplierId` `ghsId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '供货商ID';
ALTER TABLE xhGhsPurchaseOrder CHANGE `supplierInfo` `ghsInfo` VARCHAR(5000) NOT NULL DEFAULT '' COMMENT '供应商信息';
ALTER TABLE xhPurchase CHANGE `supplierId` `ghsId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '供货商ID';
ALTER TABLE xhPurchase ADD `ghsInfo` VARCHAR(2000) NOT NULL DEFAULT '' COMMENT '供应商信息' AFTER `ghsId`;
ALTER TABLE xhGhsCustom CHANGE `sjId` `ownSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '所有者商家id';
ALTER TABLE xhGhsCustom CHANGE `customSjId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户商家id';
ALTER TABLE xhGhsCustom CHANGE `customShopId` `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户门店id';
ALTER TABLE `xhGhs` CHANGE `sjId` `ownSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '所有者商家id';
ALTER TABLE `xhGhs` CHANGE `shopId` `ownShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '所有者门店id';
ALTER TABLE `xhGhs` CHANGE `ghsSjId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商商家id';
ALTER TABLE `xhGhs` CHANGE `ghsShopId` `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商门店id';
ALTER TABLE `xhGhs` DROP COLUMN `ownShopId`;
ALTER TABLE `xhPurchase` MODIFY `shopId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '门店ID' AFTER `merchantId`;
ALTER TABLE `xhGhsPurchaseOrder` MODIFY `shopId` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '门店ID' AFTER `merchantId`;


=============linqh 2021-4-27
===
ALTER TABLE `xhPurchaseItem`
CHANGE COLUMN `num` `itemNum`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '大单位数量，支持小数点' AFTER `productId`,
MODIFY COLUMN `price`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '单价' AFTER `ratio`,
ADD COLUMN `itemId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '花材ID' AFTER `productId`,
ADD COLUMN `itemInfo`  text NOT NULL COMMENT '花材信息json' AFTER `itemNum`;

======= shish 20210428
ALTER TABLE xhGhsOrder ADD cgId INT NOT NULL DEFAULT 0 COMMENT '采购单id' AFTER `id`;
ALTER TABLE `xhGhsOrder` CHANGE `cgId` `hdOrderId` INT NOT NULL DEFAULT 0 COMMENT '花店订单id';
ALTER TABLE `xhPurchase` ADD ghsOrderId INT NOT NULL DEFAULT 0 COMMENT '供货商订单id' AFTER `orderSn`;
ALTER TABLE `xhPurchase` ADD payWay TINYINT NOT NULL DEFAULT 0 COMMENT '支付方式，选项查看dict文件' AFTER `orderSn`;
ALTER TABLE `xhGhs` ADD customId INT NOT NULL DEFAULT 0 COMMENT 'a是b的供货商，则b是a客户，即客户id' AFTER `id`;
ALTER TABLE `xhGhsCustom` ADD ghsId INT NOT NULL DEFAULT 0 COMMENT 'a是b的客户，则b是a的供货商，即供货商id' AFTER `id`;
ALTER TABLE `xhGhs` DROP COLUMN `customId`;
ALTER TABLE `xhGhsCustom` DROP COLUMN `ghsId`;
ALTER TABLE xhPurchaseClear ADD `status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态 1待付款 2已付款 3已取消，已失效' AFTER `changePrice`;
ALTER TABLE xhPurchaseClear ADD shopId INT NOT NULL DEFAULT 0 COMMENT '门店id' AFTER `merchantId`;
ALTER TABLE xhPurchaseClear CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id';
ALTER TABLE xhPurchaseClear ADD ghsId INT NOT NULL DEFAULT 0 COMMENT '供货商id' AFTER `orderSn`;
ALTER TABLE `xhPurchase` ADD clearId INT NOT NULL DEFAULT 0 COMMENT '欠款结算id' AFTER `payWay`;
ALTER TABLE xhApply ADD hasLicense TINYINT NOT NULL DEFAULT 1 COMMENT '提供证件 1有 2没有' AFTER `name`;
ALTER TABLE xhShopAdmin ADD kdAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '业绩，累计开单金额' AFTER `merchantId`;
ALTER TABLE `xhOrder` ADD `shopAdminName` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '员工名称' AFTER `actPrice`
ALTER TABLE `xhOrder` ADD `shopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '员工id' AFTER `actPrice`;
ALTER TABLE xhAdmin DROP INDEX `admin`;
ALTER TABLE `xhAdmin` ADD UNIQUE INDEX `admin`(`mobile`,`style`);
ALTER TABLE xhAdmin DROP INDEX `admin`;
ALTER TABLE `xhAdmin` ADD INDEX `admin`(`mobile`,`style`);
ALTER TABLE `xhGoodsCategory` ADD cName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '分类名称' AFTER `cId`;

./yii goods/category 补商品的分类名称补回

ALTER TABLE `xhOrder` ADD customName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '客户名称' AFTER `customId`;
DROP TABLE IF EXISTS `xhGhsOrderClear`;
DROP TABLE IF EXISTS `xhGhsOrderClearSn`;
ALTER TABLE `xhPurchaseClear` RENAME TO `xhClear`;
ALTER TABLE `xhPurchaseClearSn` RENAME TO `xhClearSn`;
ALTER TABLE xhClear ADD orderIds VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '销售单id，json串' AFTER `shopId`;
ALTER TABLE `xhClear` MODIFY `purchaseIds` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '采购单id，json串';
ALTER TABLE `xhClear` CHANGE `orderIds` `saleOrderIds` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '销售单id，json串';


DROP TABLE IF EXISTS `xhGhsOrderClear`;
CREATE TABLE `xhGhsOrderClear` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `prePrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
  `orderSn` CHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `orderIds` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'id的json串',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) COMMENT='清算订单';
DROP TABLE IF EXISTS `xhGhsOrderClearSn`;
CREATE TABLE `xhGhsOrderClearSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=12568276 COMMENT='清算订单号';
ALTER TABLE xhGhsOrderClear CHANGE `orderIds` `orderStr` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单id的json串';
ALTER TABLE xhGhsOrderClear CHANGE `orderStr` `orderText` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单id的json文本串';
ALTER TABLE xhGhsOrderClear ADD customId INT NOT NULL DEFAULT 0 COMMENT '客户id' AFTER `sjId`;
ALTER TABLE xhGhsOrderClear ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id' AFTER `customId`;
ALTER TABLE xhGhsOrderClear ADD clearType TINYINT NOT NULL DEFAULT 1 COMMENT '清算方式 1花店发起清算 2供货商发起清算' AFTER `shopAdminId`;

DROP TABLE IF EXISTS `xhPurchaseClear`;
CREATE TABLE IF NOT EXISTS xhPurchaseClear(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `prePrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '应付款，原价，未修改价格，打折前',
  `actPrice` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '实际付款，实价，修改后价格，打折后',
orderSn CHAR(20) NOT NULL DEFAULT '' COMMENT '订单号',
merchantId INT NOT NULL DEFAULT 0 COMMENT '商家id',
purchaseIds TEXT NOT NULL COMMENT '结算的采购单id，json串',
`addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
)COMMENT='采购单结算';
DROP TABLE IF EXISTS `xhPurchaseClearSn`;
CREATE TABLE IF NOT EXISTS `xhPurchaseClearSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=28586254 COMMENT='结算订单号';
ALTER TABLE xhPurchaseClear ADD `deadline` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '订单失效时间' AFTER `purchaseIds`;
ALTER TABLE xhPurchaseClear ADD changePrice TINYINT NOT NULL DEFAULT 1 COMMENT '1可以修改价格 2不能修改价格，微信发起支付后不能修改' AFTER `deadline`;
ALTER TABLE xhPurchaseClear ADD `status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态 1待付款 2已付款 3已取消，已失效' AFTER `changePrice`;
ALTER TABLE xhPurchaseClear ADD shopId INT NOT NULL DEFAULT 0 COMMENT '门店id' AFTER `merchantId`;
ALTER TABLE xhPurchaseClear CHANGE `merchantId` `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id';
ALTER TABLE xhPurchaseClear ADD ghsId INT NOT NULL DEFAULT 0 COMMENT '供货商id' AFTER `orderSn`;
ALTER TABLE xhGhsCustom ADD debtNum INT NOT NULL DEFAULT 0 COMMENT '欠款笔数' AFTER `debtAmount`;
ALTER TABLE xhShopAdmin ADD lastLogin TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登陆时间' AFTER `status`;
ALTER TABLE `xhPurchase` ADD ghsShopAdminId INT NOT NULL DEFAULT 0 COMMENT '' AFTER `shopId`;
ALTER TABLE `xhPurchase` ADD ghsShopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '员工姓名' AFTER `ghsShopAdminId`;

-------- ruidian 20210505
ALTER TABLE `xhGoods`
MODIFY COLUMN `stock` int(11) NOT NULL DEFAULT -10000 COMMENT '库存 -100000充足，正常不会超卖太多' AFTER `shopImg`;

=======linqh 2021-05-07
===
ALTER TABLE `xhGhsItemClass`
ADD COLUMN `isDefault`  tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否默认分类 1是0否' AFTER `adminId`;


-------shish 20210706
ALTER TABLE xhGhs DROP INDEX `ghs`;
ALTER TABLE xhGhs ADD ownShopId INT NOT NULL DEFAULT 0 COMMENT '所有者门店id' AFTER `ownSjId`;
ALTER TABLE xhGhsCustom DROP INDEX `custom`;
ALTER TABLE xhGhsCustom ADD ownShopId INT NOT NULL DEFAULT 0 COMMENT '所有者门店id' AFTER `ownSjId`;
ALTER TABLE xhCustom DROP INDEX `custom`;
ALTER TABLE xhCustom ADD shopId INT NOT NULL DEFAULT 0 COMMENT '门店id' AFTER `sjId`;
TRUNCATE `xhCustom`;
TRUNCATE `xhGhsCustom`;
TRUNCATE `xhGhs`;
ALTER TABLE `xhCustom` ADD UNIQUE INDEX `custom`(`shopId`);
ALTER TABLE `xhGhsCustom` ADD UNIQUE INDEX `custom`(`ownShopId`,`shopId`);
ALTER TABLE `xhGhs` ADD UNIQUE INDEX `ghs`(`ownShopId`,`shopId`);
ALTER TABLE `xhGhs` ADD customId INT NOT NULL DEFAULT 0 COMMENT 'a是b的供应商，则b是a的客户，即customId' AFTER `id`;
ALTER TABLE `xhGhsCustom` ADD ghsId INT NOT NULL DEFAULT 0 COMMENT 'a是b的客户，则b是a的供货商，即ghsId' AFTER `id`;
ALTER TABLE xhPurchase MODIFY `ghsOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商订单id' AFTER `id`;
ALTER TABLE `xhPurchase` CHANGE `ghsOrderId` `saleOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的销售单id';
ALTER TABLE xhGhsOrder CHANGE `hdOrderId` `purchaseOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '花店采购单id';
ALTER TABLE `xhPurchase` CHANGE `saleOrderId` `saleId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商的销售单id';
ALTER TABLE xhGhsOrder CHANGE `purchaseOrderId` `purchaseId` INT(11) NOT NULL DEFAULT '0' COMMENT '花店采购单id';
ALTER TABLE `xhGhsOrder` CHANGE `customAdminId` `customShopAdminId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户员工id';
ALTER TABLE `xhGhsOrder` ADD customShopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '客户员工名称' AFTER `customShopAdminId`;
ALTER TABLE xhGhsOrder MODIFY `customId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户id 对应xhGhsCustom id字段';
ALTER TABLE xhPurchase ADD customId INT NOT NULL DEFAULT 0 COMMENT '客户id，冗余字段' AFTER `changePrice`;
ALTER TABLE xhGhsOrder ADD ghsId INT NOT NULL DEFAULT 0 COMMENT '供货商id，冗余字段' AFTER `shopAdminName`;
ALTER TABLE xhPurchase ADD ghsName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '供货商名称' AFTER `customId`;
ALTER TABLE xhPurchase ADD ghsAvatar VARCHAR(500) NOT NULL DEFAULT '' COMMENT '供货商头像' AFTER `ghsName`;
ALTER TABLE xhPurchase DROP COLUMN `ghsInfo`;
ALTER TABLE xhPurchase MODIFY ghsName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '供货商名称' AFTER `ghsId`;
ALTER TABLE xhPurchase MODIFY ghsAvatar VARCHAR(500) NOT NULL DEFAULT '' COMMENT '供货商头像' AFTER `ghsName`;
DROP TABLE IF EXISTS `xhClear`;
DROP TABLE IF EXISTS `xhClearSn`;
ALTER TABLE xhCustom DROP INDEX `custom`;
ALTER TABLE xhCustom ADD UNIQUE INDEX custom(`shopId`,`userId`);

=======linqh
==
ALTER TABLE `xhPurchaseItem`
ADD COLUMN `ghsProductId`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '供货商的productId' AFTER `itemInfo`;

------shish 20210509
ALTER TABLE xhPurchaseClear MODIFY `purchaseIds` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '结算的采购单id，json串';
ALTER TABLE xhPurchaseClear ADD saleIds  VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '结算的销售单id，json串' AFTER `purchaseIds`;
ALTER TABLE xhPurchaseClear ADD customId INT NOT NULL DEFAULT 0 COMMENT '客户id' AFTER `orderSn`;
ALTER TABLE xhPurchaseClear ADD customShopAdminId INT NOT NULL DEFAULT 0 COMMENT '客户员工id' AFTER `customId`;
ALTER TABLE xhPurchaseClear ADD customShopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '客户员工名称' AFTER `customShopAdminId`;
ALTER TABLE xhPurchaseClear ADD ghsShopAdminId INT NOT NULL DEFAULT 0 COMMENT '供货商员工id' AFTER `sjId`;
ALTER TABLE xhPurchaseClear ADD ghsShopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '供货商员工名称' AFTER `ghsShopAdminId`;
ALTER TABLE xhPurchaseClear ADD `type` TINYINT NOT NULL DEFAULT 1 COMMENT '1客户清算 2供货商清算' AFTER `id`;
ALTER TABLE `xhGhs` MODIFY `name` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '供货商名称';
ALTER TABLE xhGhsCustom MODIFY `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '客户名称';
ALTER TABLE xhRenew CHANGE userId shopAdminId INT NOT NULL DEFAULT 0 COMMENT '员工id';
ALTER TABLE xhRenew DROP COLUMN `addTime`;
ALTER TABLE xhRenew ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `status`;
ALTER TABLE xhRenew ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `addTime`;
ALTER TABLE xhRenew ADD shopAdminName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '员工名称' AFTER shopAdminId;
ALTER TABLE xhGhsCustom MODIFY `city` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '市' AFTER `province`;
ALTER TABLE xhGhsCustom MODIFY `dist` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '区县' AFTER `city`;
ALTER TABLE xhGhsCustom MODIFY `fullAddress` VARCHAR(800) NOT NULL DEFAULT '' COMMENT '完整地址' AFTER `dist`;
ALTER TABLE xhGhsCustom MODIFY `address` VARCHAR(800) NOT NULL DEFAULT '' COMMENT '客户地址' AFTER `dist`;
ALTER TABLE xhGhsCustom MODIFY `fullAddress` VARCHAR(900) NOT NULL DEFAULT '' COMMENT '完整地址' AFTER `floor`;
ALTER TABLE xhGhsCustom ADD showAddress VARCHAR(900) NOT NULL DEFAULT '' COMMENT '地图接口显示的完整地址' AFTER `fullAddress`;
ALTER TABLE xhOrder ADD showAddress VARCHAR(900) NOT NULL DEFAULT '' COMMENT '地图接口显示的完整地址' AFTER `fullAddress`;
ALTER TABLE xhGhsOrder ADD showAddress VARCHAR(900) NOT NULL DEFAULT '' COMMENT '地图接口显示的完整地址' AFTER `fullAddress`;
ALTER TABLE xhShop ADD showAddress VARCHAR(900) NOT NULL DEFAULT '' COMMENT '地图接口显示的完整地址' AFTER `fullAddress`;
ALTER TABLE xhGhs ADD showAddress VARCHAR(900) NOT NULL DEFAULT '' COMMENT '地图接口显示的完整地址' AFTER `fullAddress`;
ALTER TABLE xhPurchase ADD ghsInfo VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '供货商信息' AFTER `ghsId`;
ALTER TABLE xhPurchase DROP COLUMN `ghsInfo`;
ALTER TABLE xhPurchase ADD ghsMobile CHAR(15) NOT NULL DEFAULT '' COMMENT '供货商手机号' AFTER `ghsAvatar`;
ALTER TABLE xhPurchase ADD ghsFullAddress VARCHAR(800) NOT NULL DEFAULT '' COMMENT '供货商地址' AFTER `ghsMobile`;
ALTER TABLE xhApply ADD showAddress VARCHAR(900) NOT NULL DEFAULT '' COMMENT '地图接口显示的完整地址' AFTER `fullAddress`;
ALTER TABLE xhUser MODIFY id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id';
ALTER TABLE xhCustom MODIFY id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id';
TRUNCATE xhUser;
TRUNCATE xhCustom;
ALTER TABLE xhUser AUTO_INCREMENT=958260;
ALTER TABLE xhCustom AUTO_INCREMENT=980361;

------
ws nginx配置 需要分别配置供货商 零售端 商城的域名
ws 定时监控脚本


-----shish 20210512
ALTER TABLE xhPurchaseClear RENAME TO xhClear;
ALTER TABLE xhPurchaseClearSn RENAME TO xhClearSn;
DROP TABLE IF EXISTS `xhGhsOrderClear`;
DROP TABLE IF EXISTS `xhGhsOrderClearSn`;
ALTER TABLE xhCoupon MODIFY `deadline` INT(11) NOT NULL DEFAULT '0' COMMENT '过期时间，永不过期用数值4102416000表示即2100-01-01 00:00:00，不另外建字段，方便查询';
DROP TABLE IF EXISTS `xhShopCoupon`;
CREATE TABLE IF NOT EXISTS `xhShopCoupon` (
  `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT NOT NULL DEFAULT 0 COMMENT '门店id',
  `name` VARCHAR(20) NOT NULL DEFAULT '优惠券' COMMENT '优惠券名称',
  `amount` INT(11) NOT NULL DEFAULT '0' COMMENT '代金卷金额',
  `miniCost` INT(11) NOT NULL DEFAULT '0' COMMENT '最低消费金额，0表示任何情况下可用',
  `beginTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '开始时间',
  `endTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间，永不过期用数值2100-01-01 00:00:00表示，方便查询',
  `orderId` INT(11) NOT NULL DEFAULT '0' COMMENT '使用优惠券的订单id',
  `capitalType` TINYINT NOT NULL DEFAULT 0 COMMENT '流水类型',
  `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '状态 0未使用 1使用 2过期',
  `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间'
) COMMENT='门店优惠券，代金劵';
ALTER TABLE xhGhsOrder ADD orderType TINYINT NOT NULL DEFAULT 1 COMMENT '1供货商开单生成 2零售采购生成' AFTER `orderSn`;
ALTER TABLE xhPurchase ADD orderType TINYINT NOT NULL DEFAULT 1 COMMENT '1供货商开单生成 2零售采购生成' AFTER `orderSn`;


-----linqh 2021.05-12
ALTER TABLE `xhTMessage`
CHANGE COLUMN `merchantId` `ptStyle`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '平台类型： 1花店，2供货商，3商城' AFTER `id`,
DROP INDEX `merchantId`,
ADD INDEX `idx_ptStyle` (`ptStyle`) ;


-----shish 20210514
ALTER TABLE xhPurchase MODIFY `status` TINYINT(2) NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款，待确认，2待配送，3配送中，4已完成 5已取消';
ALTER TABLE xhPurchase ADD INDEX expire(`status`,`deadline`);
ALTER TABLE xhGhsOrder MODIFY `sendNum` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '配送编号，方便寻找订单对应的花材' AFTER `orderSn`;
ALTER TABLE xhGhsOrder MODIFY `sendNum` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '配送编号，方便寻找订单对应的花材' AFTER `id`;
ALTER TABLE xhShop ADD cgUnPay INT NOT NULL DEFAULT 0 COMMENT '采购待付款订单数' AFTER `totalPurchase`;
ALTER TABLE xhShop ADD cgUnSend INT NOT NULL DEFAULT 0 COMMENT '采购待配送订单数' AFTER `cgUnPay`;
ALTER TABLE xhShop ADD cgSending INT NOT NULL DEFAULT 0 COMMENT '采购配送中订单数' AFTER `cgUnSend`;
ALTER TABLE xhShop ADD cgFinish INT NOT NULL DEFAULT 0 COMMENT '采购完成订单数' AFTER `cgSending`;
ALTER TABLE xhShop ADD cgCancel INT NOT NULL DEFAULT 0 COMMENT '采购取消订单数' AFTER `cgFinish`;
ALTER TABLE xhShopCoupon MODIFY `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '状态 1未使用 2使用 3过期';
ALTER TABLE xhShopAdmin ADD remark VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '' AFTER `lastLogin`;

-----linqh 2021.5.14  监控ws定时任务
*/1 * * * * sh /root/new_monitor_shell/ws_monitor.sh >> /dev/null 2>&1


-----shish 2021
#采购单到期脚本
*/1 * * * * /usr/local/nginx/html/huahuibao/yii purchase/expire-order
#优惠券过期脚本
*/2 * * * * /usr/local/nginx/html/huahuibao/yii shop-coupon/expire

阿里云 线上 bucket 需要独立出来 不再跟测试环境混在一起使用

-----shish 20210516
ALTER TABLE `xhSetMeal` ADD `style` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '商家类型 1花店 2供货商 3昆明供货商' AFTER `id`;
ALTER TABLE `xhSetMeal` DROP COLUMN `createTime`;
ALTER TABLE `xhSetMeal` DROP COLUMN `updateTime`;
ALTER TABLE `xhSetMeal` ADD `addTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' AFTER `num`;
ALTER TABLE `xhSetMeal` ADD `updateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间' AFTER `addTime`;
TRUNCATE `xhSetMeal`;
INSERT INTO xhSetMeal(id,`style`,`name`,price,num) VALUES(NULL,1,'基础版',1980,0),(NULL,2,'基础版',2980,0);
ALTER TABLE `xhSetMeal` RENAME TO `xhSet`;
ALTER TABLE xhRenew MODIFY `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1 待付款 2已付款';


drop table if exists `xhShopYeChange`;
CREATE TABLE if not exists `xhShopYeChange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `relateId` int(11) NOT NULL DEFAULT '0' COMMENT '关联订单id',
  `capitalType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '流水类型',
  `amount` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '变动金额',
  `balance` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `txBalance` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '可提现余额',
  `io` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型 0减少 1增加',
  `payWay` tinyint(4) NOT NULL DEFAULT '0' COMMENT '支付方式',
  `fromType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '来源 0门店 1商城 2朋友圈 3..',
  `event` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '事项',
  `sjId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `remark` varchar(500) 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`)
) COMMENT='门店余额变化记录';
ALTER TABLE xhShopYeChange MODIFY `balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '当前余额';
ALTER TABLE xhShopYeChange MODIFY `txBalance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '当前可提现余额';
ALTER TABLE xhCash MODIFY `event` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '说明';
ALTER TABLE xhCash ADD sjName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '商家名称' AFTER `shopId`;
ALTER TABLE xhCash ADD shopName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '门店名称' AFTER `sjName`;
ALTER TABLE xhCash ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '申请提现的员工' AFTER `shopId`;
ALTER TABLE xhCash ADD shopAdminId INT NOT NULL DEFAULT 0 COMMENT '申请提现的员工' AFTER `shopId`;
ALTER TABLE xhCash ADD cashName VARCHAR(100) NOT NULL DEFAULT '' COMMENT '姓名' AFTER `shopName`;
ALTER TABLE xhCash ADD cashAccount VARCHAR(100) NOT NULL DEFAULT '' COMMENT '帐号' AFTER `cashName`;
ALTER TABLE xhCash ADD thirdOrderSn VARCHAR(200) NOT NULL DEFAULT '' COMMENT '第三方流水号' AFTER `cashAccount`;
CREATE TABLE `xhCashSn` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=12123500 COMMENT='提现申请订单号';
ALTER TABLE xhCash ADD orderSn CHAR(30) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `id`;
ALTER TABLE xhPurchase ADD couponId INT NOT NULL DEFAULT 0 COMMENT '优惠券id' AFTER `clearId`;
ALTER TABLE xhShopCoupon ADD take TINYINT NOT NULL DEFAULT 1 COMMENT '1未占用 2占用' AFTER `capitalType`;
ALTER TABLE xhPurchase ADD discountAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '优惠金额' AFTER `couponId`;
ALTER TABLE xhPurchase ADD `discountType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '优惠类型 1使用平台优惠' AFTER `discountAmount`;
ALTER TABLE xhGhsOrder ADD couponId INT NOT NULL DEFAULT 0 COMMENT '优惠券id' AFTER `shopId`;
ALTER TABLE xhGhsOrder ADD discountAmount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '优惠金额' AFTER `couponId`;
ALTER TABLE xhGhsOrder ADD `discountType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '优惠类型 1使用平台优惠' AFTER `discountAmount`;
ALTER TABLE xhOrder MODIFY `discountType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '优惠类型 1使用平台优惠。类型放在dict.php里';
ALTER TABLE xhGhsOrder MODIFY `discountType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '优惠类型 1使用平台优惠。类型放在dict.php里';
ALTER TABLE xhPurchase MODIFY `discountType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '优惠类型 1使用平台优惠。类型放在dict.php里';

ALTER TABLE xhOrder MODIFY `discountType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '优惠类型 1没有优惠 2使用平台优惠。类型放在dict.php里';
ALTER TABLE xhGhsOrder MODIFY `discountType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '优惠类型 1没有优惠 2使用平台优惠。类型放在dict.php里';
ALTER TABLE xhPurchase MODIFY `discountType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '优惠类型 1没有优惠 2使用平台优惠。类型放在dict.php里';

--------linqh 2021.5.17
ALTER TABLE `xhGhsStockRecord`
ADD COLUMN `productId`  int(11) NOT NULL DEFAULT 0 AFTER `orderSn`;

---shish 20210518
ALTER TABLE xhGhsOrder ADD customPrice DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '客户实际付款金额' AFTER `actPrice`;
ALTER TABLE xhShopYeChange MODIFY `fromType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '来源 1门店 2商城 3朋友圈 请查看dict.php文件';
ALTER TABLE xhOrder MODIFY `fromType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '来源 1门店 2商城 3朋友圈 请查看dict.php文件';
ALTER TABLE xhOrder MODIFY `store` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '门店订单，作废字段。';
ALTER TABLE xhOrder MODIFY `sourceType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '来源，作废字段';
ALTER TABLE xhShopYeChange ADD tx TINYINT NOT NULL DEFAULT 1 COMMENT '本条变动的余额 1不可提现 2可提现' AFTER `txBalance`;
ALTER TABLE xhClear ADD payWay TINYINT NOT NULL DEFAULT 0 COMMENT '支付方式 请查看dict.php' AFTER `type`;

----linqh  2021.5.18
ALTER TABLE `xhGhsStockOutOrderItem`
MODIFY COLUMN `itemStock`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '当时的库存(变更前）' AFTER `itemNum`,
ADD COLUMN `newStock`  decimal(10,2) NOT NULL DEFAULT 0 COMMENT '变更后的库存' AFTER `itemPrice`;

-----shish 20210519
DROP TABLE IF EXISTS `xhPtAsset`;
CREATE TABLE IF NOT EXISTS `xhPtAsset`(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '自增id',
amount DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '金额'
)COMMENT='平台资产';
DROP TABLE IF EXISTS `xhPtYeChange`;
CREATE TABLE IF EXISTS `xhPtYeChange` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `style` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '平台类型 1花店 2供货商',
  `relateId` INT(11) NOT NULL DEFAULT '0' COMMENT '关联订单id',
  `capitalType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '流水类型',
  `amount` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '变动金额',
  `balance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '当前余额',
  `txBalance` DECIMAL(9,2) NOT NULL DEFAULT '0.00' COMMENT '当前可提现余额',
  `tx` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '本条变动的余额 1不可提现 2可提现',
  `io` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '类型 0减少 1增加',
  `payWay` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '支付方式',
  `fromType` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '来源 1门店 2商城 3朋友圈 请查看dict.php文件',
  `event` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '事项',
  `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
  `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `remark` VARCHAR(500) 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`)
) COMMENT='平台余额变化记录';
ALTER TABLE `xhPtYeChange` ADD INDEX `search`(`style`,`sjId`,`shopId`);
ALTER TABLE `xhPtAsset` ADD `name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '资产名称' AFTER `id`;
ALTER TABLE xhShop ADD sjStyle TINYINT NOT NULL DEFAULT 1 COMMENT '商家类型 1花店 2供货商 3昆明供货商' AFTER `merchantId`;
ALTER TABLE xhShop CHANGE sjStyle ptStyle TINYINT NOT NULL DEFAULT 1 COMMENT '所属平台 1花店 2供货商 请查看dict.php';
INSERT INTO xhPtAsset VALUES(1,'零售平台余额',0.00),(2,'供货商平台余额',0.00),(3,'零售平台可提现余额',0.00),(4,'供货商平台可提现余额',0.00);
ALTER TABLE xhPtYeChange MODIFY `tx` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '本条变动的余额 1不可提现 2可提现 请查看dict.php yeTx';
ALTER TABLE xhShopYeChange MODIFY `tx` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '本条变动的余额 1不可提现 2可提现 请查看dict.php yeTx';