r_project_role_permission.sql 388 B

123456
  1. --
  2. -- Constraints for table `r_project_role_permission`
  3. --
  4. ALTER TABLE `r_project_role_permission`
  5. ADD CONSTRAINT `r_project_role_permission_ibfk_1` FOREIGN KEY (`per_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  6. ADD CONSTRAINT `r_project_role_permission_ibfk_2` FOREIGN KEY (`r_id`) REFERENCES `project_roles` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;