Advertisement
Guest User

Untitled

a guest
Apr 25th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. ALTER TABLE isad156_22203121.taxi_schedule
  2.  
  3. ADD CONSTRAINT FK_Control
  4. FOREIGN KEY (Vehicle_plate , Control_desk , Control_centre)
  5. REFERENCES isad156_22203121.control (Vehicle_plate , Control_desk , Control_centre)
  6.  
  7. ON DELETE CASCADE
  8. ON UPDATE CASCADE,
  9.  
  10. ADD CONSTRAINT FK_Call_ID
  11. FOREIGN KEY (Call_ID)
  12. REFERENCES isad156_22203121.taxi_call (Call_ID)
  13.  
  14. ON DELETE CASCADE
  15. ON UPDATE CASCADE,
  16.  
  17. ADD CONSTRAINT FK_Driver_ID
  18. FOREIGN KEY (Driver_ID)
  19. REFERENCES isad156_22203121.driver (driver_ID)
  20.  
  21. ON DELETE CASCADE
  22. ON UPDATE CASCADE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement