etrade / zr-etrade · Files

INSERT INTO `uap`.`data_dictionary` (`id`, `code`, `name`, `level`, `system_code`, `description`, `created`, `modified`) VALUES (NULL, 'order_invalid', '允许退货天数设置', NULL, 'ETRADE', '本期设置时间 3', '2023-12-11 11:35:00', '2023-12-11 11:35:06');

ALTER TABLE `dili_etrade`.`order` 
ADD COLUMN `order_status` tinyint NULL COMMENT '单据类型',
ADD COLUMN `relation_id` bigint NULL COMMENT '关联订单id';

ALTER TABLE `dili_etrade`.`order` 
DROP INDEX `code`,
ADD UNIQUE INDEX `code`(`code` ASC, `order_status`) USING BTREE COMMENT '编号';


ALTER TABLE `dili_etrade`.`order_goods` 
ADD COLUMN `relation_id` bigint NULL ,
ADD COLUMN `order_status` tinyint NULL COMMENT '单据类型' ;

ALTER TABLE `dili_etrade`.`order_payment` 
ADD COLUMN `order_status` tinyint NULL COMMENT '单据类型',
ADD COLUMN `relation_id` bigint NULL COMMENT '关联id' ;

ALTER TABLE `dili_etrade`.`order_coupon` 
ADD COLUMN `relation_id` bigint NULL COMMENT '红冲关联id',
ADD COLUMN `order_status` tinyint NULL COMMENT '单据类型';