projects.sql 337 B

1234567
  1. --
  2. -- Constraints for table `projects`
  3. --
  4. ALTER TABLE `projects`
  5. ADD CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `users` (`id`),
  6. ADD CONSTRAINT `projects_ibfk_2` FOREIGN KEY (`p_id`) REFERENCES `projects` (`id`) ON UPDATE CASCADE,
  7. ADD CONSTRAINT `projects_ibfk_3` FOREIGN KEY (`s_id`) REFERENCES `statuses` (`id`);