diff options
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 ; |