summaryrefslogtreecommitdiffstats
path: root/setup/pbs.sql
diff options
context:
space:
mode:
authormichael pereira2011-04-21 14:03:56 +0200
committermichael pereira2011-04-21 14:03:56 +0200
commit583ccfa017f2a57776d70cf1b80a7dbb1228124c (patch)
treec58419423f503e31ec06b547e6c2ec4fbe554109 /setup/pbs.sql
parentmerges (diff)
downloadpbs2-583ccfa017f2a57776d70cf1b80a7dbb1228124c.tar.gz
pbs2-583ccfa017f2a57776d70cf1b80a7dbb1228124c.tar.xz
pbs2-583ccfa017f2a57776d70cf1b80a7dbb1228124c.zip
updates raus
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r--setup/pbs.sql16
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,