22 lines
493 B
PL/PgSQL
22 lines
493 B
PL/PgSQL
-- Revert camper:campsite_type_cost__-min_nights from pg
|
|
|
|
begin;
|
|
|
|
set search_path to camper, public;
|
|
|
|
alter table campsite_type_cost
|
|
add column if not exists min_nights integer not null default 1 constraint at_least_one_night check(min_nights > 0)
|
|
;
|
|
|
|
update campsite_type_cost
|
|
set min_nights = lower(bookable_nights)
|
|
from campsite_type
|
|
where campsite_type.campsite_type_id = campsite_type_cost.campsite_type_id
|
|
;
|
|
|
|
alter table campsite_type_cost
|
|
alter column min_nights drop default
|
|
;
|
|
|
|
commit;
|