diff options
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 227aec7..09bbed8 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -294,7 +294,7 @@ ALTER TABLE `pbs_session` ADD CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_session_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE SET NULL, ADD CONSTRAINT `pbs_session_ibfk_3` FOREIGN KEY (`bootisoID`) REFERENCES `pbs_bootiso` (`bootisoID`) ON DELETE SET NULL, - ADD CONSTRAINT `pbs_session_ibfk_4` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE; + ADD CONSTRAINT `pbs_session_ibfk_4` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_session_ibfk_5` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_pool` ( |