Fehler in SQL Dateien korrigiert

1 files changed, 17 insertions, 17 deletions

diff --git a/pbs.sql b/pbs.sql
index bf8503b..1eec4bf 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -182,6 +182,21 @@ ALTER TABLE `pbs_bootmenuentries`
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL,
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_4` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_5` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON UPDATE CASCADE;
+
+CREATE TABLE IF NOT EXISTS `pbs_preboot` (
+  `prebootID` int(11) NOT NULL AUTO_INCREMENT,
+  `title` varchar(30) NOT NULL,  
+  `membershipID` int(11),
+  `groupID` int(11) NOT NULL,
+  `path_preboot` varchar(30) NOT NULL, 
+  PRIMARY KEY (`prebootID`),
+  KEY `membershipID` (`membershipID`),
+  KEY `groupID` (`groupID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+
+ALTER TABLE `pbs_preboot`
+  ADD CONSTRAINT `pbs_preboot_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
+  ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
   
 CREATE TABLE IF NOT EXISTS `pbs_bootiso` (
   `bootisoID` int(11) NOT NULL AUTO_INCREMENT,
@@ -202,22 +217,7 @@ ALTER TABLE `pbs_bootiso`
   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,
   ADD CONSTRAINT `pbs_bootiso_ibfk_3` FOREIGN KEY (`prebootID`) REFERENCES `pbs_preboot` (`prebootID`) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS `pbs_preboot` (
-  `prebootID` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(30) NOT NULL,  
-  `membershipID` int(11),
-  `groupID` int(11) NOT NULL,
-  `path_preboot` varchar(30) NOT NULL, 
-  PRIMARY KEY (`prebootID`),
-  KEY `membershipID` (`membershipID`),
-  KEY `groupID` (`groupID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-ALTER TABLE `pbs_preboot`
-  ADD CONSTRAINT `pbs_preboot_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
-  ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
-  
+ 
 CREATE TABLE IF NOT EXISTS `pbs_client` (
   `clientID` int(11) NOT NULL AUTO_INCREMENT,
   `macadress` varchar(17) NOT NULL,
@@ -327,7 +327,7 @@ CREATE TABLE IF NOT EXISTS `pbs_filterentries` (
   `filterID` int(11) NOT NULL,
   `filtertypeID` int(11) NOT NULL,
   `filtervalue` varchar(140) NOT NULL,
-  `filtervalue2` varchar(140) NOT NULL 
+  `filtervalue2` varchar(140) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 ALTER TABLE  `pbs_filterentries` CHANGE  `filtervalue2`  `filtervalue2` VARCHAR( 140 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
 ALTER TABLE `pbs_filterentries` ADD `filterentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;