summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authorSimon2011-03-06 13:04:27 +0100
committerSimon2011-03-06 13:04:27 +0100
commita0984170d517f55fbd1f348e8e2e14109971c31f (patch)
treef5e9d46370704db65859668abe63d01c7e96b474 /pbs.sql
parentupdate (diff)
parentBootmenu und Bootmenuentries angelegt (diff)
downloadpbs2-a0984170d517f55fbd1f348e8e2e14109971c31f.tar.gz
pbs2-a0984170d517f55fbd1f348e8e2e14109971c31f.tar.xz
pbs2-a0984170d517f55fbd1f348e8e2e14109971c31f.zip
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql18
1 files changed, 16 insertions, 2 deletions
diff --git a/pbs.sql b/pbs.sql
index 8161931..5b26cdd 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -103,15 +103,29 @@ ALTER TABLE `pbs_membership`
CREATE TABLE IF NOT EXISTS `pbs_config` (
`configID` int(11) NOT NULL AUTO_INCREMENT,
- `membershipID` int(11) NOT NULL,
+ `title` varchar(30) NOT NULL,
+ `groupID` int(11) NOT NULL,
`shellscript` text NOT NULL,
PRIMARY KEY (`configID`),
- KEY `membershipID` (`membershipID`)
+ KEY `groupID` (`groupID`)
) 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;
+CREATE TABLE IF NOT EXISTS `pbs_userconfig` (
+ `userconfigID` int(11) NOT NULL AUTO_INCREMENT,
+ `title` varchar(30) NOT NULL,
+ `membershipID` int(11) NOT NULL,
+ `shellscript` text NOT NULL,
+ PRIMARY KEY (`userconfigID`),
+ KEY `membershipID` (`membershipID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+
+ALTER TABLE `pbs_userconfig`
+ ADD CONSTRAINT `pbs_userconfig_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE;
+
+
CREATE TABLE IF NOT EXISTS `pbs_bootos` (
`bootosID` int(11) NOT NULL AUTO_INCREMENT,
`configID` int(11),