summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-09-28 17:46:27 +0200
committerBjörn Geiger2011-09-28 17:46:27 +0200
commite4bfe9c7230ae5fcf78095dab008389ef4b6b1f6 (patch)
tree447698c582c8d62bacfdf87743f50213cc5abbd2 /setup
parentRepeat Events getestet und korrigiert (diff)
downloadpoolctrl-e4bfe9c7230ae5fcf78095dab008389ef4b6b1f6.tar.gz
poolctrl-e4bfe9c7230ae5fcf78095dab008389ef4b6b1f6.tar.xz
poolctrl-e4bfe9c7230ae5fcf78095dab008389ef4b6b1f6.zip
verschiedene Korrekturen
Diffstat (limited to 'setup')
-rwxr-xr-xsetup/poolctrl.sql2
-rwxr-xr-xsetup/poolctrl_data.sql8
2 files changed, 6 insertions, 4 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 5f948f7..01314aa 100755
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -15,6 +15,7 @@ CREATE TABLE IF NOT EXISTS `poolctrl_event` (
`pbs_poolID` int(11) NOT NULL,
`pbs_membershipID` int(11) NOT NULL,
`pbs_bootosID` int(11) NOT NULL,
+ `pbs_configID` int(11) DEFAULT NULL,
`pbs_bootmenuID` int(11) NOT NULL,
`pbs_filterID` int(11) NOT NULL,
`repeat` bool NOT NULL DEFAULT false,
@@ -30,6 +31,7 @@ CREATE TABLE IF NOT EXISTS `poolctrl_event` (
KEY `pbs_poolID` (`pbs_poolID`),
KEY `pbs_membershipID` (`pbs_membershipID`),
KEY `pbs_bootosID` (`pbs_bootosID`),
+ KEY `pbs_configID` (`pbs_configID`),
KEY `pbs_bootmenuID` (`pbs_bootmenuID`),
KEY `pbs_filterID` (`pbs_filterID`),
KEY `category` (`category`),
diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
index 079b53d..1f02354 100755
--- a/setup/poolctrl_data.sql
+++ b/setup/poolctrl_data.sql
@@ -57,10 +57,10 @@ INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES
(10, 4, 10);
-- Adding events
-INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `note`, `pbs_bootmenuID`, `pbs_filterID`, `created`) VALUES
-(1, 'Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', '1', 1, 1, 1, 'Systeme I Vorlesung', 1, 1, 1308583320),
-(2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', '1', 1, 1, 1, 'Systeme II Vorlesung', 1, 1, 1308583320),
-(3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', '1', 1, 1, 1, 'Systeme III Vorlesung', 1, 1, 1308583320);
+INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `pbs_configID`, `note`, `pbs_bootmenuID`, `pbs_filterID`, `created`) VALUES
+(1, 'Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', '1', 1, 1, 1, 1, 'Systeme I Vorlesung', 1, 1, 1308583320),
+(2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', '1', 1, 1, 1, 1, 'Systeme II Vorlesung', 1, 1, 1308583320),
+(3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', '1', 1, 1, 1, 1, 'Systeme III Vorlesung', 1, 1, 1308583320);
-- Adding eventreports
INSERT INTO `poolctrl_eventreport` (`reportID`, `result`, `errors`, `type`, `eventID`, `created`) VALUES