summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--application/views/scripts/auth/recoverpassword.phtml (renamed from application/views/scripts/auth/recoverPassword.phtml)0
-rw-r--r--pbs.sql4
2 files changed, 2 insertions, 2 deletions
diff --git a/application/views/scripts/auth/recoverPassword.phtml b/application/views/scripts/auth/recoverpassword.phtml
index e133420..e133420 100644
--- a/application/views/scripts/auth/recoverPassword.phtml
+++ b/application/views/scripts/auth/recoverpassword.phtml
diff --git a/pbs.sql b/pbs.sql
index f762115..f220008 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -142,7 +142,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` (
ALTER TABLE `pbs_bootos`
ADD CONSTRAINT `pbs_bootos_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`),
ADD CONSTRAINT `pbs_bootos_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
- ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`);
+ ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;
CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
`bootmenuID` int(11) NOT NULL AUTO_INCREMENT,
@@ -194,7 +194,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_bootiso`
- ADD CONSTRAINT `pbs_bootiso_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`),
+ ADD CONSTRAINT `pbs_bootiso_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_bootiso_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_client` (