From 73f407e5cfec3e18e7cd9f3c31e93280a943bcf9 Mon Sep 17 00:00:00 2001 From: Sebastian Wagner Date: Fri, 24 Jun 2011 15:12:04 +0200 Subject: change start- and end-type to timestamp --- setup/poolctrl.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index b3d88a0..26efc92 100644 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -7,8 +7,8 @@ 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, - `start` varchar(10) COLLATE utf8_unicode_ci NOT NULL, - `end` varchar(10) COLLATE utf8_unicode_ci NOT NULL, + `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), `category` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `pbs_poolID` int(11) NOT NULL, -- cgit v1.2.3-55-g7522