32 lines
1.6 KiB
SQL
32 lines
1.6 KiB
SQL
alter table product_sources drop constraint if exists product_sources_source_check;
|
|
alter table product_sources add constraint product_sources_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table source_snapshots drop constraint if exists source_snapshots_source_check;
|
|
alter table source_snapshots add constraint source_snapshots_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table product_source_specs drop constraint if exists product_source_specs_source_check;
|
|
alter table product_source_specs add constraint product_source_specs_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table product_images drop constraint if exists product_images_source_check;
|
|
alter table product_images add constraint product_images_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table source_ratings drop constraint if exists source_ratings_source_check;
|
|
alter table source_ratings add constraint source_ratings_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table crawl_jobs drop constraint if exists crawl_jobs_source_check;
|
|
alter table crawl_jobs add constraint crawl_jobs_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table source_pauses drop constraint if exists source_pauses_source_check;
|
|
alter table source_pauses add constraint source_pauses_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|
|
|
|
alter table source_daily_budgets drop constraint if exists source_daily_budgets_source_check;
|
|
alter table source_daily_budgets add constraint source_daily_budgets_source_check
|
|
check (source in ('yandex_market', 'mvideo'));
|