diff options
| author | michael pereira | 2011-03-21 15:19:23 +0100 |
|---|---|---|
| committer | michael pereira | 2011-03-21 15:19:23 +0100 |
| commit | 7eb49950cff52458fa4a4688099adfc59b6c0437 (patch) | |
| tree | 4fbe067cdd9853dcdadddd04bff726308e93151d /pbs.sql | |
| parent | Preboot und BootISO fertig (diff) | |
| parent | fbgui: serialnumber von bootmedium wird berücksichtigt zur Gruppenfindung (diff) | |
| download | pbs2-7eb49950cff52458fa4a4688099adfc59b6c0437.tar.gz pbs2-7eb49950cff52458fa4a4688099adfc59b6c0437.tar.xz pbs2-7eb49950cff52458fa4a4688099adfc59b6c0437.zip | |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
| -rw-r--r-- | pbs.sql | 36 |
1 files changed, 19 insertions, 17 deletions
@@ -182,7 +182,23 @@ 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, `title` varchar(30) NOT NULL, @@ -198,26 +214,12 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( KEY `groupID` (`groupID`) ) 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`) 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 +329,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; |