22 lines
423 B
MySQL
22 lines
423 B
MySQL
|
-- Deploy camper:acsi_option__option_group to pg
|
||
|
|
-- requires: acsi_option
|
||
|
|
|
||
|
|
begin;
|
||
|
|
|
||
|
|
set search_path to camper, public;
|
||
|
|
|
||
|
|
alter table acsi_option
|
||
|
|
add column option_group integer not null default 0
|
||
|
|
;
|
||
|
|
|
||
|
|
alter table acsi_option
|
||
|
|
drop constraint if exists acsi_option_pkey
|
||
|
|
;
|
||
|
|
|
||
|
|
alter table acsi_option
|
||
|
|
add primary key (campsite_type_id, campsite_type_option_id, option_group)
|
||
|
|
, alter column option_group drop default
|
||
|
|
;
|
||
|
|
|
||
|
|
commit;
|