49 lines
1.8 KiB
MySQL
49 lines
1.8 KiB
MySQL
|
-- Deploy camper:booking__payment_fields to pg
|
||
|
|
-- requires: booking
|
||
|
|
-- requires: positive_integer
|
||
|
|
-- requires: nonnegative_integer
|
||
|
|
|
||
|
|
begin;
|
||
|
|
|
||
|
|
set search_path to camper, public;
|
||
|
|
|
||
|
|
alter table booking
|
||
|
|
add column address text
|
||
|
|
, add column postal_code text
|
||
|
|
, add column city text
|
||
|
|
, add column country_code country_code references country
|
||
|
|
, add column email email
|
||
|
|
, add column phone packed_phone_number
|
||
|
|
, add lang_tag text not null default 'und' references language
|
||
|
|
, add zone_preferences text not null default ''
|
||
|
|
, add subtotal_nights nonnegative_integer not null default 0
|
||
|
|
, add number_adults positive_integer not null default 1
|
||
|
|
, add subtotal_adults nonnegative_integer not null default 0
|
||
|
|
, add number_teenagers nonnegative_integer not null default 0
|
||
|
|
, add subtotal_teenagers nonnegative_integer not null default 0
|
||
|
|
, add number_children nonnegative_integer not null default 0
|
||
|
|
, add subtotal_children nonnegative_integer not null default 0
|
||
|
|
, alter column number_dogs type nonnegative_integer
|
||
|
|
, add subtotal_dogs nonnegative_integer not null default 0
|
||
|
|
, add subtotal_tourist_tax nonnegative_integer not null default 0
|
||
|
|
, add total nonnegative_integer not null default 0
|
||
|
|
, add currency_code currency_code not null default 'EUR' references currency
|
||
|
|
;
|
||
|
|
|
||
|
|
alter table booking
|
||
|
|
alter column zone_preferences drop default
|
||
|
|
, alter column subtotal_nights drop default
|
||
|
|
, alter column number_adults drop default
|
||
|
|
, alter column subtotal_adults drop default
|
||
|
|
, alter column number_teenagers drop default
|
||
|
|
, alter column subtotal_teenagers drop default
|
||
|
|
, alter column number_children drop default
|
||
|
|
, alter column subtotal_children drop default
|
||
|
|
, alter column subtotal_dogs drop default
|
||
|
|
, alter column subtotal_tourist_tax drop default
|
||
|
|
, alter column total drop default
|
||
|
|
, alter column currency_code drop default
|
||
|
|
;
|
||
|
|
|
||
|
|
commit;
|