Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cpgu_new=# ALTER TABLE equeue_ticket_order DROP CONSTRAINT equeue_ticket_order_equeue_ticket_order_act_fkey;
- ALTER TABLE
- cpgu_new=# ALTER TABLE equeue_ticket_order
- cpgu_new-# ADD CONSTRAINT equeue_ticket_order_equeue_ticket_order_act_fkey
- cpgu_new-# FOREIGN KEY (equeue_ticket_order_act) REFERENCES equeue_ticket_order_act (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_order_package DROP CONSTRAINT order_id_constraint;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_order_package
- cpgu_new-# ADD CONSTRAINT order_id_constraint
- cpgu_new-# FOREIGN KEY (order_id) REFERENCES cpgu_order (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE email_notification_queue DROP CONSTRAINT email_notification_queue_cpgu_order_fkey;
- ALTER TABLE
- cpgu_new=# ALTER TABLE email_notification_queue
- cpgu_new-# ADD CONSTRAINT email_notification_queue_cpgu_order_fkey
- cpgu_new-# FOREIGN KEY (cpgu_order) REFERENCES cpgu_order (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE control DROP CONSTRAINT control_equeue_ticket_order_act_id_fkey;
- ALTER TABLE
- cpgu_new=# ALTER TABLE control
- cpgu_new-# ADD CONSTRAINT control_equeue_ticket_order_act_id_fkey
- cpgu_new-# FOREIGN KEY (equeue_ticket_order_act_id) REFERENCES equeue_ticket_order_act (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_incoming_order_package DROP CONSTRAINT order_incoming_order_package_order_id_fkey;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_incoming_order_package
- cpgu_new-# ADD CONSTRAINT order_incoming_order_package_order_id_fkey
- cpgu_new-# FOREIGN KEY (order_id) REFERENCES cpgu_order (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_status_history DROP CONSTRAINT fk5c7cea585421d280;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_status_history
- cpgu_new-# ADD CONSTRAINT fk5c7cea585421d280
- cpgu_new-# FOREIGN KEY (cpgu_order) REFERENCES cpgu_order (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_requester DROP CONSTRAINT order_requester_order_id_fkey;
- ALTER TABLE
- cpgu_new=# ALTER TABLE order_requester
- cpgu_new-# ADD CONSTRAINT order_requester_order_id_fkey
- cpgu_new-# FOREIGN KEY (order_id) REFERENCES cpgu_order (id) ON DELETE CASCADE;
- ALTER TABLE
- cpgu_new=# ALTER TABLE cpgu_order DROP CONSTRAINT fkf7975c2af1cb3206;
- ОШИБКА: ограничение "fkf7975c2af1cb3206" в таблице "cpgu_order" не существует
- cpgu_new=# ALTER TABLE cpgu_order
- cpgu_new-# ADD CONSTRAINT fkf7975c2af1cb3206
- cpgu_new-# FOREIGN KEY (cpgu_order_large_fields) REFERENCES cpgu_order_large_fields (id) ON DELETE SET NULL;
- ALTER TABLE
- cpgu_new=# ALTER TABLE equeue_ticket_order_act DROP CONSTRAINT equeue_ticket_order_act_cpgu_order_fkey;
- ALTER TABLE
- cpgu_new=# ALTER TABLE equeue_ticket_order_act
- cpgu_new-# ADD CONSTRAINT equeue_ticket_order_act_cpgu_order_fkey
- cpgu_new-# FOREIGN KEY (cpgu_order) REFERENCES cpgu_order (id) ON DELETE CASCADE;
- ALTER TABLE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement