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.
16 lines
722 B
16 lines
722 B
-- vorder 新增partner_id 字段
|
|
|
|
ALTER TABLE vorder ADD COLUMN partner_id VARCHAR(32) NULL DEFAULT '' COMMENT '合伙人id';
|
|
create index partner_id on vorder (partner_id);
|
|
|
|
|
|
-- extension_center_statistic_partner 增加合伙人id为联合唯一索引
|
|
|
|
ALTER TABLE extension_center_statistic_partner DROP INDEX partner_id;
|
|
|
|
ALTER TABLE extension_center_statistic_partner DROP INDEX housing_estate_id_time;
|
|
ALTER TABLE extension_center_statistic_partner ADD UNIQUE INDEX housing_estate_id_time (housing_estate_id,time,partner_id);
|
|
|
|
-- consumer 新增partner_id 字段
|
|
ALTER TABLE consumer_info ADD COLUMN partner_id VARCHAR(32) NULL DEFAULT '' COMMENT '合伙人id';
|
|
create index partner_id on consumer_info (partner_id);
|