From e1ab1cb79068c4c46aa547cefc24da9c83cf1dd0 Mon Sep 17 00:00:00 2001
From: Sebastian Wagner
Date: Tue, 2 Aug 2011 17:06:59 +0200
Subject: some database changes, actions in eventform implemented, testevents
 are now displayed in the calendar

---
 setup/poolctrl.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'setup/poolctrl.sql')

diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index a6dfbe0..e395ac6 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -7,7 +7,7 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 CREATE TABLE IF NOT EXISTS `poolctrl_event` (
   `eventID` int(11) NOT NULL AUTO_INCREMENT,
   `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
-  `action` varchar(30) COLLATE utf8_unicode_ci,
+  `action` int(11) NOT NULL DEFAULT '1',
   `start` timestamp COLLATE utf8_unicode_ci NOT NULL DEFAULT CURRENT_TIMESTAMP(),
   `end` timestamp COLLATE utf8_unicode_ci NOT NULL,
   `participants` int(4) NOT NULL DEFAULT 50 CHECK (participants > 0),
@@ -227,6 +227,6 @@ ALTER TABLE `poolctrl_event`
 --  ADD CONSTRAINT `poolctrl_event_bootmenuidC` FOREIGN KEY (`pbs_bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
 --  ADD CONSTRAINT `poolctrl_event_filteridC` FOREIGN KEY (`pbs_filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE,
   ADD CONSTRAINT `poolctrl_event_categoryC` FOREIGN KEY (`category`) REFERENCES `poolctrl_eventcategory` (`eventcategoryID`) ON DELETE CASCADE,
-  ADD CONSTRAINT `poolctrl_event_actionC` FOREIGN KEY (`action`) REFERENCES `poolctrl_eventaction` (`title`) ON DELETE CASCADE,
+  ADD CONSTRAINT `poolctrl_event_actionC` FOREIGN KEY (`action`) REFERENCES `poolctrl_eventaction` (`eventactionID`) ON DELETE CASCADE,
   ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()),
   ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start);
-- 
cgit v1.2.3-55-g7522

