Home Verkennen Help
Registreren Inloggen
shizhongqi
/
huahuibao_document
1
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: 478b66f625
Aftakkingen Labels
huahuibao_docum...
/
server
/
数据表恢复.md

数据表恢复.md 31 KB
Geschiedenis Ruwe

新建的表

CREATE TABLE `xhOrderClear` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `orderId` INT(11) NOT NULL DEFAULT '0' COMMENT '订单id',
  `orderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `clearId` INT(11) NOT NULL DEFAULT '0' COMMENT '结账单id',
  `clearSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '结账单编号',
  `amount` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账金额',
  `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0待结账，1已结账',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id_clear_id` (`clearId`,`orderId`),
  KEY `order_status` (`orderId`,`status`)
) ENGINE=INNODB AUTO_INCREMENT=447 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单结账关系表，批发店的订单和结账单';


CREATE TABLE `xhPicText` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mainId` int(11) NOT NULL DEFAULT '0' COMMENT '中央id',
`title` varchar(60) NOT NULL DEFAULT '' COMMENT '标题',
`delStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除状态 0未删除 1已删除',
`content` JSON,

`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=0 DEFAULT CHARSET=utf8 COMMENT='图文内容表';


CREATE TABLE `xhOrderCgClear` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `orderId` INT(11) NOT NULL DEFAULT '0' COMMENT '订单id',
  `orderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `cgId` INT(11) NOT NULL DEFAULT '0' COMMENT '采购单id',
  `cgSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '采购单编号',
  `clearId` INT(11) NOT NULL DEFAULT '0' COMMENT '结账单id',
  `clearSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '结账单编号',
  `amount` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账金额',
  `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0待结账，1已结账',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id_clear_id` (`clearId`,`orderId`),
  KEY `order_status` (`orderId`,`status`)
) ENGINE=INNODB AUTO_INCREMENT=447 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单采购单结账单关系表';


CREATE TABLE `xhPicText` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mainId` int(11) NOT NULL DEFAULT '0' COMMENT '中央id',
`title` varchar(60) NOT NULL DEFAULT '' COMMENT '标题',
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类别 1商品说明(花束等) 2花材说明 3花束分类 4花束分类商品单独设置其它说明',
`content` JSON,
`delStatus` tinyint(4) 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`),
KEY `mainId_type_idx` (`mainId`, `type`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='图文内容表';



CREATE TABLE `xhPicTextGoods` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mainId` int(11) NOT NULL DEFAULT '0' COMMENT '中央id',
`title` varchar(60) NOT NULL DEFAULT '' COMMENT '标题',
`goodsId` int(11) unsigned NOT NULL COMMENT '商品表自增Id',
`content` JSON,
`delStatus` tinyint(4) 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`),
KEY `mainId_goodsId_idx` (`mainId`, `goodsId`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='商品-图文内容表';



CREATE TABLE `xhOrderForward` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `orderId` INT(11) NOT NULL DEFAULT '0' COMMENT '原单id',
  `orderSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '原单编号',
  `shOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '售后付款单id',
  `shOrderSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '售后付款单编号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sh_order` (`orderId`,`shOrderId`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='原单与付款单关系表;



CREATE TABLE `xhPicTextShow` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mainId` int(11) NOT NULL DEFAULT '0' COMMENT '中央id',
`picTextId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '图文内容表自增Id',
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类别: 1购买须知 2售后说明 等等，后继请补充',
PRIMARY KEY (`id`),
KEY `mainId_type_ptId_idx` (`mainId`, `type`, `picTextId`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='图文内容展示表';

字段更新sql

ALTER TABLE xhHdRefundSn ADD orderId INT NOT NULL DEFAULT 0 COMMENT '对应订单id' AFTER `id`;
alter table xhHdRefundSn drop column `orderId`;
ALTER TABLE xhGoodsCategory DROP COLUMN `delStatus`;
ALTER TABLE xhGoodsCategory DROP COLUMN `flowerNum`;
ALTER TABLE xhGoods DROP COLUMN `inTurn`;
ALTER TABLE xhShop ADD home TINYINT NOT NULL DEFAULT 1 COMMENT '1默认送货上门 0没有送货上门' AFTER `rechargeWeal`;
ALTER TABLE xhShop ADD homeAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '送货上门需满足最少金额，0表示没有要求' AFTER `home`;
ALTER TABLE xhGhsCustom ADD home TINYINT NOT NULL DEFAULT 1 COMMENT '1默认送货上门 0没有送货上门' AFTER `printSeatSn`;
ALTER TABLE xhGhsCustom ADD homeAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '送货上门需满足最少金额，0表示没有要求' AFTER `home`;
ALTER TABLE xhGhs ADD home TINYINT NOT NULL DEFAULT 1 COMMENT '1默认送货上门 0没有送货上门' AFTER `customWlName`;
ALTER TABLE xhGhs ADD homeAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '送货上门需满足最少金额，0表示没有要求' AFTER `home`;
ALTER TABLE xhShop MODIFY homeAmount INT NOT NULL DEFAULT 0 COMMENT '送货上门最低消费金额或数量';
ALTER TABLE xhGhs MODIFY homeAmount INT NOT NULL DEFAULT 0 COMMENT '送货上门最低消费金额或数量';
ALTER TABLE xhGhsCustom MODIFY homeAmount INT NOT NULL DEFAULT 0 COMMENT '送货上门最低消费金额或数量';
ALTER TABLE xhShop ADD homeType TINYINT NOT NULL DEFAULT 0 COMMENT '最低消费类型0金额，1数量' AFTER `homeAmount`;
ALTER TABLE xhGhs ADD homeType TINYINT NOT NULL DEFAULT 0 COMMENT '最低消费类型0金额，1数量' AFTER `homeAmount`;
ALTER TABLE xhGhsCustom ADD homeType TINYINT NOT NULL DEFAULT 0 COMMENT '最低消费类型0金额，1数量' AFTER `homeAmount`;
ALTER TABLE xhClear ADD `remark` VARCHAR(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注' AFTER `payTime`;
ALTER TABLE xhGhs MODIFY `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商商家id';
ALTER TABLE xhGhs MODIFY `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商门店id';
ALTER TABLE xhGhs MODIFY `mainId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商中央id';
ALTER TABLE xhGhs MODIFY `ownSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售店（客户）商家id';
ALTER TABLE xhGhs MODIFY `ownShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售店（客户）门店id';
ALTER TABLE xhGhs MODIFY `ownMainId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售店（客户）中央id';
ALTER TABLE xhGhsCustom MODIFY `ownSjId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商商家id';
ALTER TABLE xhGhsCustom MODIFY `ownShopId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商门店id';
ALTER TABLE xhGhsCustom MODIFY `ownMainId` INT(11) NOT NULL DEFAULT '0' COMMENT '供货商中央id';
ALTER TABLE xhGhsCustom MODIFY `ownPtStyle` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '所属平台';
ALTER TABLE xhGhsCustom MODIFY `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售商家id';
ALTER TABLE xhGhsCustom MODIFY `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售门店id';
ALTER TABLE xhGhsCustom MODIFY `mainId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售店mainId';
ALTER TABLE xhCustom MODIFY `userId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id，客户id';
ALTER TABLE xhCustom MODIFY `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售店商家id';
ALTER TABLE xhCustom MODIFY `shopId` INT(11) NOT NULL DEFAULT '0' COMMENT '零售店门店id';
ALTER TABLE xhHd MODIFY `userId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id，客户id';
ALTER TABLE xhHd MODIFY `sjId` int(11) NOT NULL DEFAULT '0' COMMENT '零售店商家id';
ALTER TABLE xhHd MODIFY `shopId` int(11) NOT NULL DEFAULT '0' COMMENT '零售店门店id';
alter table xhHd modify `userId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id';
ALTER TABLE xhCustom MODIFY `userId` INT(11) NOT NULL DEFAULT '0' COMMENT '用户id';
alter table xhHd modify `balance` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '余额' after `memberName`;
ALTER TABLE xhRefundItem ADD refundOptionId SMALLINT NOT NULL DEFAULT 0 COMMENT '退货原因选项id' AFTER `xhWasteNum`;
ALTER TABLE xhRefundItem ADD refundOptionName VARCHAR(50) NOT NULL DEFAULT '' COMMENT '退货原因' AFTER `refundOptionId`;
ALTER TABLE xhRefundItem modify refundOptionName VARCHAR(50) NOT NULL DEFAULT '未选择' COMMENT '退货原因';
ALTER TABLE xhRefundItem MODIFY refundOptionName VARCHAR(50) NOT NULL DEFAULT '未选' COMMENT '退货原因';
ALTER TABLE xhRecharge ADD style TINYINT NOT NULL DEFAULT 0 COMMENT '0正常充值，1用于销账的充值' AFTER `returnCode`;
ALTER TABLE xhSettle MODIFY `purchaseIds` VARCHAR(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '结算的采购单id，用逗号分隔，弃用字段，后面可以drop';
ALTER TABLE xhSettle MODIFY `saleIds` VARCHAR(2000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '结算的销售单id，用逗号分隔';
alter table xhGhs drop index ghs;
alter table xhGhs add unique ghs (`shopId`, `ownShopId`);
alter table xhGhs add index idx_main_id (`mainId`);
ALTER TABLE xhExpend ADD COLUMN delStaffId int NOT NULL DEFAULT 0 COMMENT '删除员工id' AFTER staffName;
ALTER TABLE xhExpend ADD COLUMN delStaffName varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '删除员工名称' AFTER delStaffId;
alter table xhExpend drop index main_addTime;
alter table xhExpend add index  search_idx (`mainId`,`addTime`,`delStaffId`);
alter table xhExpend drop index search_idx;
ALTER TABLE xhExpend ADD COLUMN delStatus tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除状态：0 未删除，1 删除' AFTER delStaffName;
alter table xhExpend add index  search_idx (`mainId`,`addTime`,`delStatus`);
alter table xhGhsOrder add `fhWlSn` char(15) NOT NULL DEFAULT '' COMMENT '物流商家的编号，对应微信里的delivery_id，如顺丰 SF，圆通 YTO' after `fhType`;
ALTER TABLE xhGhsOrder modify `fhWl` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流商家名称';
ALTER TABLE xhGhsOrder MODIFY `fhWlNo` char(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流单号';
ALTER TABLE xhGhsOrder ADD `fhWlStatus` tinyint not null default 0 comment '0没有叫物流 1已叫物流 2已取消' after `fhWlNo`;
ALTER TABLE xhCg ADD `fhWlSn` CHAR(15) NOT NULL DEFAULT '' COMMENT '物流商家的编号，对应微信里的delivery_id，如顺丰 SF，圆通 YTO' AFTER `fhType`;
ALTER TABLE xhCg MODIFY `fhWl` CHAR(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流商家名称';
ALTER TABLE xhCg MODIFY `fhWlNo` CHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流单号';
ALTER TABLE xhCg ADD `fhWlStatus` TINYINT NOT NULL DEFAULT 0 COMMENT '0没有叫物流 1已叫物流 2已取消' AFTER `fhWlNo`;
ALTER TABLE xhGhsOrder MODIFY `fhWl` CHAR(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流商家名称';
ALTER TABLE xhGhsOrder MODIFY `fhWlNo` CHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流单号';
ALTER TABLE xhCg MODIFY `fhWl` CHAR(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流商家名称';
ALTER TABLE xhCg MODIFY `fhWlNo` CHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物流单号';
ALTER TABLE xhShopYeChange ADD clearId INT NOT NULL DEFAULT 0 COMMENT '结账单id，零售端是settleId，批发是clearId' AFTER `mainId`;
ALTER TABLE xhShopYeChange ADD clearAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额,零售端是settleId，批发是clearId' AFTER `clearId`;
ALTER TABLE xhShopYeChange ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `clearAmount`;
ALTER TABLE xhShopYeChange ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhRecharge ADD clearId INT NOT NULL DEFAULT 0 COMMENT '结账单id，零售端是settleId，批发是clearId' AFTER `mainId`;
ALTER TABLE xhRecharge ADD clearAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额,零售端是settleId，批发是clearId' AFTER `clearId`;
ALTER TABLE xhRecharge ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `clearAmount`;
ALTER TABLE xhRecharge ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhSettle DROP COLUMN `customShopId`;
ALTER TABLE xhSettle DROP COLUMN `customShopAdminId`;
ALTER TABLE xhSettle DROP COLUMN `customShopAdminName`;
ALTER TABLE xhSettle CHANGE `hdShopAdminId` staffId INT(11) NOT NULL DEFAULT '0' COMMENT '花店员工id';
ALTER TABLE xhSettle CHANGE `hdShopAdminName` staffName VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '花店员工名称';
ALTER TABLE xhSettle ADD customUserId INT NOT NULL DEFAULT 0 COMMENT '客户的userId' AFTER `customAddress`;
ALTER TABLE xhSettle CHANGE `staffId` hdShopAdminId int(11) NOT NULL DEFAULT '0' COMMENT '花店员工id';
ALTER TABLE xhSettle CHANGE `staffName` hdShopAdminName varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '花店员工名称';
ALTER TABLE xhSettle drop column `customUserId`;
ALTER TABLE xhSettle CHANGE `hdShopAdminId` hdStaffId INT(11) NOT NULL DEFAULT '0' COMMENT '花店员工id';
ALTER TABLE xhSettle CHANGE `hdShopAdminName` hdStaffName VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '花店员工名称';
ALTER TABLE xhSettle ADD customUserId INT NOT NULL DEFAULT 0 COMMENT '客户的userId' AFTER `customAddress`;
ALTER TABLE xhSettle modify `sjId` int(11) NOT NULL DEFAULT '0' COMMENT '商家id' after `mainId`;
ALTER TABLE xhSettle DROP COLUMN `hdShopName`;
ALTER TABLE xhRecharge ADD userId INT NOT NULL DEFAULT 0 COMMENT '客户的userId' AFTER `customName`;
ALTER TABLE xhSettle drop column `hdAvatar`;
ALTER TABLE xhSettle DROP COLUMN `hdAddress`;
ALTER TABLE xhSettle DROP COLUMN `customAvatar`;
ALTER TABLE xhSettle DROP COLUMN `customAddress`;
alter table xhSettle modify `customUserId` int(11) NOT NULL DEFAULT '0' COMMENT '客户的userId' after `customId`;
ALTER TABLE xhSettle ADD `payStatus` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0待付款 1已付款' AFTER `status`;
ALTER TABLE xhSettle ADD INDEX custom_id_status(customId,`status`);
ALTER TABLE xhSettle drop column `changePrice`;
ALTER TABLE xhRecharge DROP COLUMN `modPrice`;
ALTER TABLE xhRecharge ADD payRequest TINYINT NOT NULL DEFAULT 0 COMMENT '0没有唤起过第三方支付，1唤起过聚合支付，2唤起过收银台' AFTER `payWay`;
ALTER TABLE xhRecharge drop column `payRequest`;
ALTER TABLE xhRecharge ADD payRequest TINYINT NOT NULL DEFAULT 0 COMMENT '0没有唤起过第三方支付，1唤起过聚合支付，2唤起过收银台。主要针对拉卡拉支付' AFTER `payWay`;
ALTER TABLE xhRecharge ADD side TINYINT NOT NULL DEFAULT 0 COMMENT '0花店端操作，1客户端操作' AFTER `onlinePay`;
ALTER TABLE xhRecharge drop column side;
ALTER TABLE xhRecharge CHANGE `clearId` settleId INT(11) NOT NULL DEFAULT '0' COMMENT '结账单id';
ALTER TABLE xhRecharge CHANGE `clearAmount` settleAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额';
ALTER TABLE xhBalanceChange ADD clearId INT NOT NULL DEFAULT 0 COMMENT '结账单id' AFTER `mainId`;
ALTER TABLE xhBalanceChange ADD clearAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额' AFTER `clearId`;
ALTER TABLE xhBalanceChange ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `clearAmount`;
ALTER TABLE xhBalanceChange ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhShopYeChange DROP COLUMN clearId;
ALTER TABLE xhShopYeChange DROP COLUMN clearAmount;
ALTER TABLE xhShopYeChange DROP COLUMN orderId;
ALTER TABLE xhShopYeChange drop column orderAmount;
ALTER TABLE xhBalanceChange DROP COLUMN clearId;
ALTER TABLE xhBalanceChange DROP COLUMN clearAmount;
ALTER TABLE xhBalanceChange DROP COLUMN orderId;
ALTER TABLE xhBalanceChange DROP COLUMN orderAmount;
ALTER TABLE xhRecharge DROP COLUMN orderId;
ALTER TABLE xhRecharge DROP COLUMN orderAmount;
ALTER TABLE xhBalanceChange ADD settleId INT NOT NULL DEFAULT 0 COMMENT '结账单id' AFTER `mainId`;
ALTER TABLE xhBalanceChange drop column settleId;
ALTER TABLE xhBalanceChange ADD settleId INT NOT NULL DEFAULT 0 COMMENT '结账单id' AFTER `mainId`;
ALTER TABLE xhBalanceChange ADD settleAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额' AFTER `settleId`;
ALTER TABLE xhBalanceChange ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `settleAmount`;
ALTER TABLE xhBalanceChange ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhRecharge ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `settleAmount`;
ALTER TABLE xhRecharge ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhBalanceChange DROP COLUMN settleId;
ALTER TABLE xhBalanceChange DROP COLUMN settleAmount;
ALTER TABLE xhBalanceChange DROP COLUMN orderId;
ALTER TABLE xhBalanceChange DROP COLUMN orderAmount;
ALTER TABLE xhRecharge DROP COLUMN settleId;
ALTER TABLE xhRecharge DROP COLUMN settleAmount;
ALTER TABLE xhRecharge DROP COLUMN orderId;
ALTER TABLE xhRecharge drop column orderAmount;
ALTER TABLE xhBalanceChange ADD settleId INT NOT NULL DEFAULT 0 COMMENT '结账单id' AFTER `mainId`;
ALTER TABLE xhBalanceChange ADD settleAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额' AFTER `settleId`;
ALTER TABLE xhBalanceChange ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `settleAmount`;
ALTER TABLE xhBalanceChange ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhRecharge ADD settleId INT NOT NULL DEFAULT 0 COMMENT '结账单id' AFTER `mainId`;
ALTER TABLE xhRecharge ADD settleAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '结账单金额' AFTER `settleId`;
ALTER TABLE xhRecharge ADD orderId INT NOT NULL DEFAULT 0 COMMENT '订单id' AFTER `settleAmount`;
ALTER TABLE xhRecharge ADD orderAmount DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '订单消掉的欠款金额' AFTER `orderId`;
ALTER TABLE xhOrder ADD `settleTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '结账时间' AFTER `settleId`;
ALTER TABLE xhShop MODIFY `overAllowDebt` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '线下开单是否允许超过授权额度，0不允许 1允许，默认不允许';
ALTER TABLE xhStaff MODIFY `kdAmount` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '业绩，累计开单金额';
ALTER TABLE xhBalanceChange ADD `settleSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '结账单编号' AFTER `settleId`;
ALTER TABLE xhBalanceChange ADD `orderSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `orderId`;
ALTER TABLE xhRecharge ADD `settleSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '结账单编号' AFTER `settleId`;
ALTER TABLE xhBalanceChange drop column `orderSn`;
ALTER TABLE xhRecharge ADD `orderInSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `orderId`;
ALTER TABLE xhBalanceChange ADD `orderInSn` CHAR(40) NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `orderId`;
ALTER TABLE xhRecharge drop column `orderInSn`;
ALTER TABLE xhBalanceChange DROP COLUMN `orderInSn`;
ALTER TABLE xhRecharge ADD `orderNo` CHAR(40) NOT NULL DEFAULT '' COMMENT '对应订单编号，避免冲突，不要用orderSn' AFTER `orderId`;
ALTER TABLE xhBalanceChange ADD `orderNo` CHAR(40) NOT NULL DEFAULT '' COMMENT '对应订单编号，避免冲突，不要用orderSn' AFTER `orderId`;
ALTER TABLE xhBalanceChange DROP COLUMN `settleSn`;
ALTER TABLE xhRecharge drop column `settleSn`;
ALTER TABLE xhBalanceChange ADD `settleNo` CHAR(40) NOT NULL DEFAULT '' COMMENT '结账单编号，避免冲突，不用settleSn' AFTER `settleId`;
ALTER TABLE xhRecharge ADD `settleNo` CHAR(40) NOT NULL DEFAULT '' COMMENT '结账单编号，避免冲突，不用settleSn' AFTER `settleId`;
ALTER TABLE xhSettle MODIFY `customUserId` INT(11) NOT NULL DEFAULT '0' COMMENT '客户的userId' AFTER `customId`;
ALTER TABLE xhSettle MODIFY `sjId` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id' AFTER `mainId`;
ALTER TABLE xhSettle ADD rechargeId INT  NOT NULL DEFAULT 0 COMMENT '结账资金来源的充值id，没有充值id就是余额' AFTER `hdStaffName`;
ALTER TABLE xhSettle ADD rechargeSn CHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号' AFTER `rechargeId`;
ALTER TABLE xhSettle drop column rechargeSn;
ALTER TABLE xhSettle ADD rechargeSn CHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充值订单编号' AFTER `rechargeId`;
ALTER TABLE xhSettle drop column rechargeId;
ALTER TABLE xhSettle DROP COLUMN rechargeSn;
ALTER TABLE xhSettle ADD rechargeId INT  NOT NULL DEFAULT 0 COMMENT '结账资金来源的充值id，没有充值id就是余额' AFTER `orderSn`;
ALTER TABLE xhSettle ADD rechargeSn CHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充值订单编号' AFTER `rechargeId`;
ALTER TABLE `xhGoods` MODIFY COLUMN `stockSet` tinyint(4) NOT NULL DEFAULT '0' COMMENT '库存状态：0充足  1自定义';
ALTER TABLE xhGoods ADD COLUMN priceType tinyint(4) NOT NULL DEFAULT '0' COMMENT '价格类型：0无价格 1有价格' AFTER price;
ALTER TABLE `huahuibao`.`xhGhsNotify` ADD INDEX `idx_staffId` (`staffId`);
ALTER TABLE `huahuibao`.`xhGhsItem` ADD INDEX `idx_itemId_mainId` (`itemId`, `mainId`);
ALTER TABLE `xhGoods` MODIFY COLUMN `stockSet` tinyint(4) NOT NULL DEFAULT '0' COMMENT '库存状态：0充足  1自定义';
ALTER TABLE xhShop MODIFY `allowDebtAmount` DECIMAL(15,2) NOT NULL DEFAULT '0' COMMENT '允许欠款金额';
ALTER TABLE xhOrder MODIFY `settleTime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '最后次结账时间' AFTER `payTime`;
ALTER TABLE xhRecharge MODIFY `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0待付款 1已付款 2已取消';
alter table xhRecharge add index `custom_status`(`customId`,`status`);
ALTER TABLE xhRecharge ADD INDEX `main_custom_status`(`mainId`,`customId`,`status`);
ALTER TABLE xhGoods ADD COLUMN inTurn int NOT NULL DEFAULT '0' COMMENT '排序序号' AFTER status;
ALTER TABLE xhRecharge DROP COLUMN `orderId`;
ALTER TABLE xhRecharge DROP COLUMN `orderNo`;
ALTER TABLE xhRecharge DROP COLUMN `orderAmount`;
ALTER TABLE xhBalanceChange DROP COLUMN `orderId`;
ALTER TABLE xhBalanceChange DROP COLUMN `orderNo`;
ALTER TABLE xhBalanceChange DROP COLUMN `orderAmount`;
ALTER TABLE xhOrder DROP COLUMN `settleId`;
ALTER TABLE xhSettle drop column `purchaseIds`;
ALTER TABLE xhSettle drop column `saleIds`;
ALTER TABLE `xhGoods` DROP `inTurn`;
ALTER TABLE xhOrder ADD `forward` TINYINT NOT NULL DEFAULT 0 COMMENT '0 正向订单，1负值订单' AFTER `orderType`;
ALTER TABLE xhOrderItem ADD `forward` TINYINT NOT NULL DEFAULT 0 COMMENT '0 正向订单，1负值订单' AFTER `mainId`;
ALTER TABLE xhOrder ADD `forwardStock` TINYINT NOT NULL DEFAULT 0 COMMENT '如果负值，库存的变化方式，0 退回来，1不退回' AFTER `forward`;
ALTER TABLE xhOrderItem ADD `forwardStock` TINYINT NOT NULL DEFAULT 0 COMMENT '如果负值，库存的变化方式，0 退回来，1不退回' AFTER `forward`;
ALTER TABLE `xhPicText` CHANGE `type` `type` TINYINT(4);
ALTER TABLE `xhPicText` ADD `categoryId` INT;
ALTER TABLE `xhPicText` MODIFY COLUMN `categoryId` INT(10) UNSIGNED NOT NULL COMMENT '分类表自增Id' AFTER `title`;
ALTER TABLE `xhPicText` DROP `categoryId`;
ALTER TABLE `xhPicText` CHANGE `type` `type` TINYINT(4);
ALTER TABLE xhCategory ADD COLUMN picTextId int(11) unsigned NOT NULL DEFAULT '0' COMMENT '图文内容表自增Id' AFTER delStatus;
ALTER TABLE xhMain ADD refundLimit TINYINT NOT NULL DEFAULT 0 COMMENT '售后时间限制，0不受限，30，表示下单后30天不能售后，只能走开负数订单方式售后' AFTER `rate`;
ALTER TABLE xhMain drop column `refundLimit`;
ALTER TABLE xhMain ADD refundLimit SMALLINT NOT NULL DEFAULT 90 COMMENT '售后时间限制，90，表示下单90天后不能再售后，只能走开负数订单方式售后' AFTER `rate`;
ALTER TABLE xhOrder MODIFY `forwardStock` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '负数订单的，0退货并退款，1只退款';
ALTER TABLE xhOrder MODIFY `orderType` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1花束订单 2花材订单 3花束和花材都有';
ALTER TABLE xhGhsItem MODIFY `property` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '属性 0花束 1花材，前端开发也会使用';
ALTER TABLE xhOrderGoods ADD `forward` TINYINT NOT NULL DEFAULT 0 COMMENT '0 正向订单，1负数订单' AFTER `mainId`;
ALTER TABLE xhOrderGoods ADD `forwardStock` TINYINT NOT NULL DEFAULT 0 COMMENT '负数订单时，0退货并退款，1只退款' AFTER `forward`;
ALTER TABLE xhBalanceChange ADD `shOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '售后付款单id' AFTER `mainId`;
ALTER TABLE xhBalanceChange ADD `shOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '后付款单编号' AFTER `shOrderId`;
ALTER TABLE xhRecharge ADD `shOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '售后付款单id' AFTER `mainId`;
ALTER TABLE xhRecharge ADD `shOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '后付款单编号' AFTER `shOrderId`;
ALTER TABLE xhOrder MODIFY `forward` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0 常规订单，1售后付款单';
ALTER TABLE xhOrder MODIFY `forwardStock` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '售后付款单 0货退回来，1货不退回';
ALTER TABLE xhOrderItem MODIFY `forward` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0 常规订单，1售后付款单';
ALTER TABLE xhOrderItem MODIFY `forwardStock` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '售后付款单 0货退回来，1货不退回';
ALTER TABLE xhOrderGoods MODIFY `forward` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0 常规订单，1售后付款单';
ALTER TABLE xhOrderGoods MODIFY `forwardStock` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '售后付款单 0货退回来，1货不退回';
ALTER TABLE xhOrder ADD hasForward TINYINT NOT NULL DEFAULT 0 COMMENT '0本单没有相应的售后付款单，1本单有' AFTER `mainId`;
ALTER TABLE xhOrder modify hasForward TINYINT NOT NULL DEFAULT 0 COMMENT '0本单没有相应的售后付款单，1本单有' AFTER `orderType`;
ALTER TABLE `huahuibao`.`xhGhsCgOrder` ADD INDEX `idx_mainId_entryTime` (`mainId`, `entryTime`);
ALTER TABLE `huahuibao`.`xhGhsNotify` ADD INDEX `idx_staffId_addTime` (`staffId`, `addTime`);
ALTER TABLE xhBalanceChange MODIFY `shOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后付款单编号';
ALTER TABLE xhRecharge MODIFY `shOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后付款单编号';
ALTER TABLE xhBalanceChange MODIFY `shOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后付款单编号';
ALTER TABLE xhRecharge MODIFY `shOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后付款单编号';
ALTER TABLE xhBalanceChange ADD `refundOrderId` INT(11) NOT NULL DEFAULT '0' COMMENT '售后对应的订单ID，注意这里的售后，不是售后付款单，是capitalType=59' AFTER `settleAmount`;
ALTER TABLE xhBalanceChange ADD `refundOrderSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后对应的订单号，注意这里的售后，不是售后付款单，是capitalType=59' AFTER `refundOrderId`;
ALTER TABLE xhBalanceChange ADD `refundId` INT(11) NOT NULL DEFAULT '0' COMMENT '售后订单ID，注意这里的售后，不是售后付款单，是capitalType=59' AFTER `settleAmount`;
ALTER TABLE xhBalanceChange ADD `refundSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后订单号，注意这里的售后，不是售后付款单，是capitalType=59' AFTER `refundId`;
ALTER TABLE xhBalanceChange DROP COLUMN `refundId`;
ALTER TABLE xhBalanceChange CHANGE `refundSn` `relateSn` CHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '关联订单编号' AFTER `relateId`;
ALTER TABLE xhOrder ADD `repeat` TINYINT NOT NULL DEFAULT 0 COMMENT '0不是重复订单，1重复订单，收款码收进来的，要剔除' AFTER `orderType`;
alter table xhRecharge add `refundOrderId` int(11) NOT NULL DEFAULT '0' COMMENT '售后对应的订单ID，注意这里的售后，不是售后付款单，是capitalType=59' after `settleAmount`;
ALTER TABLE xhRecharge ADD `refundOrderSn` char(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '售后对应的订单号，注意这里的售后，不是售后付款单，是capitalType=59' after `refundOrderId`;
ALTER TABLE `xhGoodsCategory` ADD `delStatus` TINYINT(4);
ALTER TABLE `xhGoodsCategory` MODIFY COLUMN `delStatus` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '删除状态 0正常  1删除' AFTER `setItemNum`;
ALTER TABLE xhShopExt ADD COLUMN purchaseGuide int(11) unsigned NOT NULL DEFAULT '0' COMMENT '购买须知 -- 对应的是图文内容表自增Id' AFTER losingItem;
ALTER TABLE xhShopExt ADD COLUMN afterSale int(11) unsigned NOT NULL DEFAULT '0' COMMENT '售后说明 -- 对应的是图文内容表自增Id' AFTER purchaseGuide;

INSERT INTO xhGhs (id, live, location, customId, avatar, name, py, mobile, province, city, dist, address, floor, fullAddress, showAddress, lat, long, sjId, shopId, mainId, ownSjId, ownShopId, ownMainId, ownPtStyle, debt, debtNum, debtAmount, giveLevel, giveDiscount, balance, expendAmount, expendNum, black, new, sendNewGift, hasCg, showStock, customWlId, customWlName, home, homeAmount, homeType, isHd, salt, inTurn, delStatus, passStatus, recentExpend, addTime, updateTime) VALUES

(908, 1, 0, 0, '', '花仙子', 'hxz', '18259179840', '福建省', '厦门市', '集美区', '集美学村', '222', '厦门市集美学村222', '', '', '', 12986, 36547, 661, 13161, 36728, 812, 1, 1, 0, 0.00, 1, 1.00, 0.00, 0.00, 0, 1, 1, 0, 0, 0, 0, '', 1, 0, 0, 1, '42sdl0ws', 100, 0, 1, '0000-00-00 00:00:00', '2025-08-06 22:57:53', '2025-08-06 22:57:53'),
(907, 1, 0, 0, '', '花田', 'ht', '17187822032', '云南省', '昆明市', '官渡区', '肖家营', '', '昆明市肖家营', '', '', '', 13160, 36727, 812, 12987, 36548, 661, 1, 1, 0, 0.00, 1, 1.00, 0.00, 0.00, 0, 1, 1, 0, 0, 0, 0, '', 1, 0, 0, 1, 'cnfar8vr', 100, 0, 1, '0000-00-00 00:00:00', '2025-08-06 22:56:58', '2025-08-06 22:56:58');