db fix

1 files changed, 34 insertions, 33 deletions

diff --git a/setup/pbs.sql b/setup/pbs.sql
index 0084a34..ad1a41f 100644
--- a/setup/pbs.sql
+++ b/setup/pbs.sql
@@ -116,8 +116,37 @@ ALTER TABLE `pbs_membership`
   ADD CONSTRAINT `pbs_membership_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_membership_ibfk_2` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_membership_ibfk_3` FOREIGN KEY (`roleID`) REFERENCES `pbs_role` (`roleID`) ON DELETE CASCADE;
+  
+CREATE TABLE IF NOT EXISTS `pbs_hometype` (
+  `hometypeID` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(30) NOT NULL,
+  PRIMARY KEY (`hometypeID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
+
+CREATE TABLE IF NOT EXISTS `pbs_bootos` (
+  `bootosID` int(11) NOT NULL AUTO_INCREMENT,
+  `groupID` int(11) NOT NULL,
+  `membershipID` int(11),
+  `title` varchar(30) NOT NULL,
+  `description` varchar(140),
+  `distro` varchar(30),
+  `distroversion` varchar(30),
+  `source` varchar(140),
+  `share` varchar(30),
+  `shortname` varchar(30),
+  `defaultkcl` varchar(255),
+  `created` VARCHAR(14) NOT NULL,
+  `expires` VARCHAR(14),
+  `public` int(11) NOT NULL DEFAULT '-1',
+  PRIMARY KEY (`bootosID`),
+  KEY `groupID` (`groupID`),
+  KEY `membershipID` (`membershipID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+ALTER TABLE `pbs_bootos`
+  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`) ON DELETE SET NULL;
 
-CREATE TABLE IF NOT EXISTS `pbs_config` (
+ CREATE TABLE IF NOT EXISTS `pbs_config` (
   `configID` int(11) NOT NULL AUTO_INCREMENT,
   `title` varchar(30) NOT NULL,
   `description` varchar(140),
@@ -135,15 +164,10 @@ CREATE TABLE IF NOT EXISTS `pbs_config` (
 ALTER TABLE `pbs_config`
   ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
-  ADD CONSTRAINT `pbs_config_ibfk_3` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_config_ibfk_3` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE; 
   
-CREATE TABLE IF NOT EXISTS `pbs_hometype` (
-  `hometypeID` int(11) NOT NULL AUTO_INCREMENT,
-  `name` varchar(30) NOT NULL,
-  PRIMARY KEY (`hometypeID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
   
-CREATE TABLE IF NOT EXISTS `pbs_bootosuser` (
+ CREATE TABLE IF NOT EXISTS `pbs_bootosuser` (
   `bootosuserID` int(11) NOT NULL AUTO_INCREMENT,
   `configID` int(11) NOT NULL,
   `login` varchar(30) NOT NULL,
@@ -156,31 +180,8 @@ CREATE TABLE IF NOT EXISTS `pbs_bootosuser` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_bootosuser`
-  ADD CONSTRAINT `pbs_bootosuser_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS `pbs_bootos` (
-  `bootosID` int(11) NOT NULL AUTO_INCREMENT,
-  `groupID` int(11) NOT NULL,
-  `membershipID` int(11),
-  `title` varchar(30) NOT NULL,
-  `description` varchar(140),
-  `distro` varchar(30),
-  `distroversion` varchar(30),
-  `source` varchar(140),
-  `share` varchar(30),
-  `shortname` varchar(30),
-  `defaultkcl` varchar(255),
-  `created` VARCHAR(14) NOT NULL,
-  `expires` VARCHAR(14),
-  `public` int(11) NOT NULL DEFAULT '-1',
-  PRIMARY KEY (`bootosID`),
-  KEY `groupID` (`groupID`),
-  KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-ALTER TABLE `pbs_bootos`
-  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`) ON DELETE SET NULL;
-
+  ADD CONSTRAINT `pbs_bootosuser_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE CASCADE; 
+  
 CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
   `bootmenuID` int(11) NOT NULL AUTO_INCREMENT,
   `membershipID` int(11),