From 583ccfa017f2a57776d70cf1b80a7dbb1228124c Mon Sep 17 00:00:00 2001 From: michael pereira Date: Thu, 21 Apr 2011 14:03:56 +0200 Subject: updates raus --- setup/pbs.sql | 16 +++++++++------- 1 file changed, 9 insertions(+), 7 deletions(-) (limited to 'setup/pbs.sql') diff --git a/setup/pbs.sql b/setup/pbs.sql index 491bfc3..0084a34 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -120,19 +120,23 @@ ALTER TABLE `pbs_membership` CREATE TABLE IF NOT EXISTS `pbs_config` ( `configID` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, + `description` varchar(140), `groupID` int(11), `membershipID` int(11), `visible` tinyint(1) DEFAULT '0', `created` VARCHAR(14) NOT NULL, + `bootosID` int(11) NOT NULL, PRIMARY KEY (`configID`), KEY `groupID` (`groupID`), - KEY `membershipID` (`membershipID`) + KEY `membershipID` (`membershipID`), + KEY `bootosID` (`bootosID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; ALTER TABLE `pbs_config` ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE, - ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; - + ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE, + ADD CONSTRAINT `pbs_config_ibfk_3` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE; + CREATE TABLE IF NOT EXISTS `pbs_hometype` ( `hometypeID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, @@ -165,9 +169,6 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` ( `source` varchar(140), `share` varchar(30), `shortname` varchar(30), - `path_init` varchar(140), - `path_kernel` varchar(140), - `path_config` varchar(140), `defaultkcl` varchar(255), `created` VARCHAR(14) NOT NULL, `expires` VARCHAR(14), @@ -221,9 +222,9 @@ ALTER TABLE `pbs_bootmenuentries` CREATE TABLE IF NOT EXISTS `pbs_preboot` ( `prebootID` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, + `description` varchar(140), `membershipID` int(11), `groupID` int(11) NOT NULL, - `path_preboot` varchar(140) NOT NULL, `source` varchar(140), `created` VARCHAR(14) NOT NULL, PRIMARY KEY (`prebootID`), @@ -239,6 +240,7 @@ ALTER TABLE `pbs_preboot` CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( `bootisoID` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, + `description` varchar(140), `membershipID` int(11), `groupID` int(11) NOT NULL, `prebootID` int(11) NOT NULL, -- cgit v1.2.3-55-g7522