diff options
| author | Michael Neves | 2012-01-26 13:56:13 +0100 |
|---|---|---|
| committer | Michael Neves | 2012-01-26 13:56:13 +0100 |
| commit | fa2e467aa085e76c8482996b30e13874de383b7b (patch) | |
| tree | 6f33bcfc3f43b98e2bbe65f42bcc20de87fd3ac6 /setup/pbs.sql | |
| parent | adjusted Preboot in pbs.sql and pbs_newdata.sql (diff) | |
| download | pbs2-fa2e467aa085e76c8482996b30e13874de383b7b.tar.gz pbs2-fa2e467aa085e76c8482996b30e13874de383b7b.tar.xz pbs2-fa2e467aa085e76c8482996b30e13874de383b7b.zip | |
adjusted Bootiso in pbs.sql and pbs_newdata.sql
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 886d8a3..6497ba2 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -233,16 +233,20 @@ CREATE TABLE IF NOT EXISTS `pbs_preboot` ( `description` varchar(140), `membershipID` int(11), `groupID` int(11) NOT NULL, + `typeID` int(11) NOT NULL, + `serialnumber` varchar(30) NOT NULL, `source` varchar(140), `created` VARCHAR(14) NOT NULL, PRIMARY KEY (`prebootID`), + UNIQUE KEY `typeID` (`typeID`,`serialnumber`), 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; + ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE, + ADD CONSTRAINT `pbs_preboot_ibfk_3` FOREIGN KEY (`typeID`) REFERENCES `pbs_preboottype` (`preboottypeID`); CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( @@ -252,11 +256,13 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( `membershipID` int(11), `groupID` int(11) NOT NULL, `prebootID` int(11) NOT NULL, - `serialnumber` varchar(30) NOT NULL UNIQUE, + `typeID` int(11) NOT NULL, + `serialnumber` varchar(30) NOT NULL, `created` VARCHAR(14) NOT NULL, `expires` VARCHAR(14), `public` int(11) NOT NULL, PRIMARY KEY (`bootisoID`), + UNIQUE KEY `typeID` (`typeID`,`serialnumber`), KEY `membershipID` (`membershipID`), KEY `groupID` (`groupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; @@ -265,7 +271,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( 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; + ADD CONSTRAINT `pbs_bootiso_ibfk_3` FOREIGN KEY (`typeID`) REFERENCES `pbs_preboottype` (`preboottypeID`); CREATE TABLE IF NOT EXISTS `pbs_client` ( `clientID` int(11) NOT NULL AUTO_INCREMENT, |