summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorSebastian Wagner2011-06-24 15:12:04 +0200
committerSebastian Wagner2011-06-24 15:12:04 +0200
commit73f407e5cfec3e18e7cd9f3c31e93280a943bcf9 (patch)
treee9eb9d61dd4489c669c686bb7e918a7042a5948f /setup
parentrename database (diff)
downloadpbs2-73f407e5cfec3e18e7cd9f3c31e93280a943bcf9.tar.gz
pbs2-73f407e5cfec3e18e7cd9f3c31e93280a943bcf9.tar.xz
pbs2-73f407e5cfec3e18e7cd9f3c31e93280a943bcf9.zip
change start- and end-type to timestamp
Diffstat (limited to 'setup')
-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,