lachang/data/sql_log.md

数据库更新记录

小程序二期上线需要执行的sql

ALTER TABLE `yoshop_order_goods` ADD COLUMN `goods_sku_no` varchar(100)  NOT NULL DEFAULT '' COMMENT '商品sku编码';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `provider_settlement_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '供应商结算开始时间';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `commission_settlement_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分佣结算开始时间';
ALTER TABLE `yoshop_order_goods` ADD COLUMN `commission_settlement_status` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分佣结算状态，0：待结算，1：已结算';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `auto_receipt_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '自动收货最晚时间';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `refund_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '申请退款截止时间';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `sign_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '签收时间';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `is_export` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否导出excel状态 0未导出 1已导出';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `export_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '第一次导出的时间';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `frozen_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '冻结状态 0未冻结  1已冻结';
ALTER TABLE `yoshop_order_goods` ADD COLUMN `receipt_status` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '收货状态(10未收货 20已收货)';
ALTER TABLE `yoshop_order_goods` ADD COLUMN `receipt_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收货时间';
ALTER TABLE `yoshop_order_goods` ADD COLUMN `delivery_status` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '发货状态(10未发货 20已发货)';
ALTER TABLE `yoshop_order_goods` ADD COLUMN `delivery_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间';

ALTER TABLE `yoshop_order_goods` ADD COLUMN `has_refund_act` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否发生退货 0未退货 1已退货';
ALTER TABLE `yoshop_order_goods` ADD COLUMN `has_refund_full` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否全额退款 0否 1是';

alter table yoshop_order_goods alter column finance_clearing_status set default 1;
alter table yoshop_user alter column bind_shop_id set default 0;

ALTER TABLE `yoshop_shops` ADD COLUMN province_id int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '省份ID';
ALTER TABLE `yoshop_shops` ADD COLUMN city_id int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '城市ID';
ALTER TABLE `yoshop_shops` ADD COLUMN region_id int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '区域ID';
ALTER TABLE `yoshop_shops` ADD COLUMN `detail` varchar(255)  NOT NULL DEFAULT '' COMMENT '详细地址';
ALTER TABLE `yoshop_shops` ADD COLUMN staff_percent  int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店员分佣比例';
ALTER TABLE `yoshop_shops` ADD COLUMN manager_percent int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店长分佣比例';
ALTER TABLE `yoshop_shops` ADD COLUMN boss_percent int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '老板分佣比例';

数据库更新记录

10.26上线需要执行的sql

INSERT INTO `yoshop_store_setting`(`key`, `describe`, `values`, `store_id`, `create_time`, `update_time`) VALUES ('brand_culture', '品牌文化', '', 10001, 1632725645, 1632725645);

ALTER TABLE `yoshop_comment` 
ADD COLUMN `is_public` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否公开评论 默认0 0-否 1-是' AFTER `is_picture`;

ALTER TABLE `yoshop_comment` 
ADD COLUMN `praise_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞数' AFTER `sort`;

ALTER TABLE `yoshop_comment` 
ADD COLUMN `reply_content` text COMMENT '平台回复内容' AFTER `praise_num`;

DROP TABLE IF EXISTS `yoshop_comment_praise`;
CREATE TABLE `yoshop_comment_praise`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `comment_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评价ID',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `comment_id`(`comment_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10001 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品评价点赞表' ROW_FORMAT = Dynamic;

数据库更新记录

10.21 zhangs

ALTER TABLE `yoshop_goods` 
ADD COLUMN `alarm_stock_total` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存预警值' AFTER `stock_total`;
ALTER TABLE `yoshop_goods_sku` 
ADD COLUMN `alarm_stock_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存预警值' AFTER `stock_num`;
ALTER TABLE `yoshop_goods_sku` 
ADD COLUMN `goods_gross_weight` double UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品毛重量(Kg)' AFTER `goods_weight`;
INSERT INTO `yoshop_store_setting`(`key`, `describe`, `values`, `store_id`, `create_time`, `update_time`) VALUES ('brand_culture', '品牌文化', '{}', 10001, 1632725645, 1632725645);

10.24 zq开票记录

DROP TABLE IF EXISTS `yoshop_receipt`;
CREATE TABLE `yoshop_receipt` (
`receipt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
`order_no` varchar(255) NOT NULL DEFAULT '' COMMENT '订单号',
`pay_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金额',
`receipt_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '发票类型,10:增值税电子普通发票',
`headup_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '发票抬头类型，10:个人或事业单位,20:企业',
`headup` varchar(255) NOT NULL DEFAULT '' COMMENT '发票抬头',
`email` varchar(255) NOT NULL DEFAULT '' COMMENT '电子邮箱',
`tax_no` varchar(255) NOT NULL DEFAULT '' COMMENT '税号',
`account_bank` varchar(255) NOT NULL DEFAULT '' COMMENT '开户行',
`account_no` varchar(255) NOT NULL DEFAULT '' COMMENT '银行账号',
`receipt_no` varchar(255) NOT NULL DEFAULT '' COMMENT '发票号',
`status` int(4) unsigned NOT NULL DEFAULT '10' COMMENT '开票状态，10:待开票,20:已开票',
`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`receipt_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;