diff options
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r-- | setup/pbs.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 6497ba2..296356d 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -233,12 +233,12 @@ CREATE TABLE IF NOT EXISTS `pbs_preboot` ( `description` varchar(140), `membershipID` int(11), `groupID` int(11) NOT NULL, - `typeID` int(11) NOT NULL, + `preboottypeID` 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`), + UNIQUE KEY `preboottypeID` (`preboottypeID`,`serialnumber`), KEY `membershipID` (`membershipID`), KEY `groupID` (`groupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; @@ -246,7 +246,7 @@ CREATE TABLE IF NOT EXISTS `pbs_preboot` ( 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_3` FOREIGN KEY (`typeID`) REFERENCES `pbs_preboottype` (`preboottypeID`); + ADD CONSTRAINT `pbs_preboot_ibfk_3` FOREIGN KEY (`preboottypeID`) REFERENCES `pbs_preboottype` (`preboottypeID`); CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( @@ -256,13 +256,13 @@ CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( `membershipID` int(11), `groupID` int(11) NOT NULL, `prebootID` int(11) NOT NULL, - `typeID` int(11) NOT NULL, + `preboottypeID` 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`), + UNIQUE KEY `preboottypeID` (`preboottypeID`,`serialnumber`), KEY `membershipID` (`membershipID`), KEY `groupID` (`groupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; @@ -271,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 (`typeID`) REFERENCES `pbs_preboottype` (`preboottypeID`); + ADD CONSTRAINT `pbs_bootiso_ibfk_3` FOREIGN KEY (`preboottypeID`) REFERENCES `pbs_preboottype` (`preboottypeID`); CREATE TABLE IF NOT EXISTS `pbs_client` ( `clientID` int(11) NOT NULL AUTO_INCREMENT, |