You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
44 lines
1.7 KiB
44 lines
1.7 KiB
/*==============================================================*/
|
|
/* Table: rel_cleaner_skill */
|
|
/*==============================================================*/
|
|
create table rel_cleaner_skill
|
|
(
|
|
id int not null auto_increment comment 'id',
|
|
user_id varchar(32) not null comment '保洁师id',
|
|
skill_no varchar(32) not null comment '技能编号',
|
|
created_at bigint comment '创建时间',
|
|
creared_by varchar(20) comment '创建人',
|
|
updated_at bigint comment '更新时间',
|
|
updated_by varchar(20) comment '更新人',
|
|
del_flag tinyint default 0 comment '删除标识：0-正常，1-已删除',
|
|
primary key (id)
|
|
);
|
|
|
|
alter table rel_cleaner_skill comment '保洁师技能关系';
|
|
|
|
/*==============================================================*/
|
|
/* Table: refund_process */
|
|
/*==============================================================*/
|
|
alter table refund_process
|
|
add column order_type tinyint(4) default 10 comment '订单类型:10-销售订单，20-赠品订单';
|
|
|
|
/*==============================================================*/
|
|
/* Table: book_detail */
|
|
/*==============================================================*/
|
|
alter table book_detail
|
|
add column big_category_no varchar(32) DEFAULT '' comment '大品类编号',
|
|
add column small_category_no varchar(32) DEFAULT '' comment '小品类编号';
|
|
|
|
|
|
-- 更新退款单订单类型
|
|
UPDATE refund_process r
|
|
LEFT JOIN (
|
|
SELECT
|
|
v.order_no,
|
|
v.order_type
|
|
FROM
|
|
vorder v
|
|
) tmp ON r.order_no = tmp.order_no
|
|
SET r.order_type = tmp.order_type;
|
|
|
|
|