3 INSERT INTO config.upgrade_log (version) VALUES ('0119'); -- miker
5 CREATE TABLE action.reservation_transit_copy (
6 reservation INT REFERENCES booking.reservation (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
7 ) INHERITS (action.transit_copy);
8 ALTER TABLE action.reservation_transit_copy ADD PRIMARY KEY (id);
9 ALTER TABLE action.reservation_transit_copy ADD CONSTRAINT artc_tc_fkey FOREIGN KEY (target_copy) REFERENCES booking.resource (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
10 CREATE INDEX active_reservation_transit_dest_idx ON "action".reservation_transit_copy (dest);
11 CREATE INDEX active_reservation_transit_source_idx ON "action".reservation_transit_copy (source);
12 CREATE INDEX active_reservation_transit_cp_idx ON "action".reservation_transit_copy (target_copy);