Advertisement
Guest User

Untitled

a guest
Sep 12th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. cpgu_new=# ALTER TABLE equeue_ticket_order DROP CONSTRAINT equeue_ticket_order_equeue_ticket_order_act_fkey;
  2. ALTER TABLE
  3. cpgu_new=# ALTER TABLE equeue_ticket_order
  4. cpgu_new-# ADD CONSTRAINT equeue_ticket_order_equeue_ticket_order_act_fkey
  5. cpgu_new-# FOREIGN KEY (equeue_ticket_order_act) REFERENCES equeue_ticket_order_act (id) ON DELETE CASCADE;
  6. ALTER TABLE
  7.  
  8. cpgu_new=# ALTER TABLE order_order_package DROP CONSTRAINT order_id_constraint;
  9. ALTER TABLE
  10. cpgu_new=# ALTER TABLE order_order_package
  11. cpgu_new-# ADD CONSTRAINT order_id_constraint
  12. cpgu_new-# FOREIGN KEY (order_id) REFERENCES cpgu_order (id) ON DELETE CASCADE;
  13. ALTER TABLE
  14.  
  15. cpgu_new=# ALTER TABLE email_notification_queue DROP CONSTRAINT email_notification_queue_cpgu_order_fkey;
  16. ALTER TABLE
  17. cpgu_new=# ALTER TABLE email_notification_queue
  18. cpgu_new-# ADD CONSTRAINT email_notification_queue_cpgu_order_fkey
  19. cpgu_new-# FOREIGN KEY (cpgu_order) REFERENCES cpgu_order (id) ON DELETE CASCADE;
  20. ALTER TABLE
  21.  
  22. cpgu_new=# ALTER TABLE control DROP CONSTRAINT control_equeue_ticket_order_act_id_fkey;
  23. ALTER TABLE
  24. cpgu_new=# ALTER TABLE control
  25. cpgu_new-# ADD CONSTRAINT control_equeue_ticket_order_act_id_fkey
  26. cpgu_new-# FOREIGN KEY (equeue_ticket_order_act_id) REFERENCES equeue_ticket_order_act (id) ON DELETE CASCADE;
  27. ALTER TABLE
  28.  
  29. cpgu_new=# ALTER TABLE order_incoming_order_package DROP CONSTRAINT order_incoming_order_package_order_id_fkey;
  30. ALTER TABLE
  31. cpgu_new=# ALTER TABLE order_incoming_order_package
  32. cpgu_new-# ADD CONSTRAINT order_incoming_order_package_order_id_fkey
  33. cpgu_new-# FOREIGN KEY (order_id) REFERENCES cpgu_order (id) ON DELETE CASCADE;
  34. ALTER TABLE
  35.  
  36.  
  37. cpgu_new=# ALTER TABLE order_status_history DROP CONSTRAINT fk5c7cea585421d280;
  38. ALTER TABLE
  39. cpgu_new=# ALTER TABLE order_status_history
  40. cpgu_new-# ADD CONSTRAINT fk5c7cea585421d280
  41. cpgu_new-# FOREIGN KEY (cpgu_order) REFERENCES cpgu_order (id) ON DELETE CASCADE;
  42. ALTER TABLE
  43.  
  44. cpgu_new=# ALTER TABLE order_requester DROP CONSTRAINT order_requester_order_id_fkey;
  45. ALTER TABLE
  46. cpgu_new=# ALTER TABLE order_requester
  47. cpgu_new-# ADD CONSTRAINT order_requester_order_id_fkey
  48. cpgu_new-# FOREIGN KEY (order_id) REFERENCES cpgu_order (id) ON DELETE CASCADE;
  49. ALTER TABLE
  50.  
  51. cpgu_new=# ALTER TABLE cpgu_order DROP CONSTRAINT fkf7975c2af1cb3206;
  52. ОШИБКА:  ограничение "fkf7975c2af1cb3206" в таблице "cpgu_order" не существует
  53. cpgu_new=# ALTER TABLE cpgu_order
  54. cpgu_new-# ADD CONSTRAINT fkf7975c2af1cb3206
  55. cpgu_new-# FOREIGN KEY (cpgu_order_large_fields) REFERENCES cpgu_order_large_fields (id) ON DELETE SET NULL;
  56. ALTER TABLE
  57.  
  58. cpgu_new=# ALTER TABLE equeue_ticket_order_act DROP CONSTRAINT equeue_ticket_order_act_cpgu_order_fkey;
  59. ALTER TABLE
  60. cpgu_new=# ALTER TABLE equeue_ticket_order_act
  61. cpgu_new-# ADD CONSTRAINT equeue_ticket_order_act_cpgu_order_fkey
  62. cpgu_new-# FOREIGN KEY (cpgu_order) REFERENCES cpgu_order (id) ON DELETE CASCADE;
  63. ALTER TABLE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement