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~ | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/setup/pbs.sql~ b/setup/pbs.sql~ index dcb093f..fa90857 100644 --- a/setup/pbs.sql~ +++ b/setup/pbs.sql~ @@ -124,6 +124,12 @@ CREATE TABLE IF NOT EXISTS `pbs_hometype` ( PRIMARY KEY (`hometypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; +CREATE TABLE IF NOT EXISTS `pbs_preboottype` ( + `preboottypeID` int(11) NOT NULL, + `name` varchar(30) NOT NULL, + PRIMARY KEY (`preboottypeID`) +) 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, @@ -227,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` ( @@ -246,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 ; |