aboutsummaryrefslogtreecommitdiff
path: root/web
diff options
context:
space:
mode:
authorGravatar Thomas Petazzoni <thomas.petazzoni@bootlin.com>2018-09-21 12:14:35 +0200
committerGravatar Thomas Petazzoni <thomas.petazzoni@bootlin.com>2018-09-21 12:14:35 +0200
commit3ba26de8eb92595929e08aa696babbbf574b5852 (patch)
tree35db8eedb166b4a0e0b29f774d3d79a08af1f6a3 /web
parent89b010c88ce9e1dd09b7d7587f322f38a9c10ad4 (diff)
downloadbuildroot-test-3ba26de8eb92595929e08aa696babbbf574b5852.tar.gz
buildroot-test-3ba26de8eb92595929e08aa696babbbf574b5852.tar.bz2
web/schema.sql: fix default value for date
'0000-00-00 00:00:00' is no longer a valid datetime value for MySQL, so let's use what is considered a valid default value. Signed-off-by: Thomas Petazzoni <thomas.petazzoni@bootlin.com>
Diffstat (limited to 'web')
-rw-r--r--web/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/web/schema.sql b/web/schema.sql
index e496283..65fd883 100644
--- a/web/schema.sql
+++ b/web/schema.sql
@@ -1,7 +1,7 @@
CREATE TABLE `results` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`status` int(11) NOT NULL DEFAULT '0',
- `builddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `builddate` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`submitter` varchar(255) NOT NULL DEFAULT '',
`commitid` char(40) NOT NULL DEFAULT '',
`identifier` char(40) NOT NULL DEFAULT '',