summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--setup/poolctrl.sql4
1 files 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,