diff options
author | Simon | 2011-03-21 12:52:01 +0100 |
---|---|---|
committer | Simon | 2011-03-21 12:52:01 +0100 |
commit | 22ae267c7013d5ea3f74db9a8485ee80ba15e3a1 (patch) | |
tree | 5998aff3ca8717f5e6627077912829bc08774ab6 /pbs.sql | |
parent | FilterEntries-Formular steht (diff) | |
parent | zfproject angepasst (diff) | |
download | pbs2-22ae267c7013d5ea3f74db9a8485ee80ba15e3a1.tar.gz pbs2-22ae267c7013d5ea3f74db9a8485ee80ba15e3a1.tar.xz pbs2-22ae267c7013d5ea3f74db9a8485ee80ba15e3a1.zip |
merge
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -197,7 +197,8 @@ 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; - + + CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( `bootisoID` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, @@ -213,12 +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_client` ( `clientID` int(11) NOT NULL AUTO_INCREMENT, `macadress` varchar(17) NOT NULL, @@ -328,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; |