14 lines
501 B
MySQL
14 lines
501 B
MySQL
|
alter table crm_expansion_followup
|
||
|
|
add column if not exists source_type varchar(30),
|
||
|
|
add column if not exists source_id bigint;
|
||
|
|
|
||
|
|
alter table crm_opportunity_followup
|
||
|
|
add column if not exists source_type varchar(30),
|
||
|
|
add column if not exists source_id bigint;
|
||
|
|
|
||
|
|
create index if not exists idx_crm_expansion_followup_source
|
||
|
|
on crm_expansion_followup(source_type, source_id);
|
||
|
|
|
||
|
|
create index if not exists idx_crm_opportunity_followup_source
|
||
|
|
on crm_opportunity_followup(source_type, source_id);
|