summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorSebastian Wagner2011-10-05 17:50:18 +0200
committerSebastian Wagner2011-10-05 17:50:18 +0200
commitd5b4cfc31ebd292fde3b98ffbc77290805b3292f (patch)
treebd1236262c913c6b88b217cb397179a947771f7b /setup
parentcategory statistic implemented (diff)
downloadpoolctrl-d5b4cfc31ebd292fde3b98ffbc77290805b3292f.tar.gz
poolctrl-d5b4cfc31ebd292fde3b98ffbc77290805b3292f.tar.xz
poolctrl-d5b4cfc31ebd292fde3b98ffbc77290805b3292f.zip
category color, getCategoryColor(), some db changes
Diffstat (limited to 'setup')
-rwxr-xr-xsetup/poolctrl.sql11
1 files changed, 6 insertions, 5 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 01314aa..c3bf12f 100755
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -61,6 +61,7 @@ CREATE TABLE IF NOT EXISTS `poolctrl_repeatend` (
CREATE TABLE IF NOT EXISTS `poolctrl_eventcategory` (
`eventcategoryID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
+ `color` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
PRIMARY KEY (`eventcategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
@@ -165,11 +166,11 @@ ALTER TABLE `poolctrl_event`
ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start);
-- Adding eventcategories
-INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`) VALUES
-(1, 'Lecture'),
-(2, 'Maintenance'),
-(3, 'Boot'),
-(4, 'Shutdown');
+INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`, `color`) VALUES
+(1, 'Lecture', 'green'),
+(2, 'Maintenance', 'yellow'),
+(3, 'Boot', 'blue'),
+(4, 'Shutdown', 'red');
-- Adding runningtypes
INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES