diff options
author | michael pereira | 2011-04-21 14:03:56 +0200 |
---|---|---|
committer | michael pereira | 2011-04-21 14:03:56 +0200 |
commit | 583ccfa017f2a57776d70cf1b80a7dbb1228124c (patch) | |
tree | c58419423f503e31ec06b547e6c2ec4fbe554109 /setup/pbs.sql | |
parent | merges (diff) | |
download | pbs2-583ccfa017f2a57776d70cf1b80a7dbb1228124c.tar.gz pbs2-583ccfa017f2a57776d70cf1b80a7dbb1228124c.tar.xz pbs2-583ccfa017f2a57776d70cf1b80a7dbb1228124c.zip |
updates raus
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r-- | setup/pbs.sql | 16 |
1 files changed, 9 insertions, 7 deletions
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, |