summaryrefslogtreecommitdiff
path: root/db/install.sql
diff options
context:
space:
mode:
authorAndrej Rode <mail@andrejro.de>2017-08-15 23:05:43 +0200
committerAndrej Rode <mail@andrejro.de>2017-08-15 23:05:43 +0200
commitb1af1f9cc2497087e5de47970024c235a17ea4c2 (patch)
tree61256337acb4b6d556ef3b7859fda3cb8c04dedd /db/install.sql
parenta5fc5bd0979e8de1fce8a8addd351a6e7bd6aeb8 (diff)
Change default value for datetime fields to valid range
Diffstat (limited to 'db/install.sql')
-rw-r--r--db/install.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/db/install.sql b/db/install.sql
index 0222dc08..3c3e41e6 100644
--- a/db/install.sql
+++ b/db/install.sql
@@ -205,7 +205,7 @@ DROP TABLE IF EXISTS `NewsComments`;
CREATE TABLE `NewsComments` (
`ID` bigint(11) NOT NULL,
`Refid` int(11) NOT NULL DEFAULT '0',
- `Datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `Datum` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`Text` text NOT NULL,
`UID` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -395,7 +395,7 @@ CREATE TABLE `User` (
`Sprache` char(64) NOT NULL,
`Menu` char(1) NOT NULL DEFAULT 'L',
`lastLogIn` int(11) NOT NULL,
- `CreateDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `CreateDate` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`Art` varchar(30) DEFAULT NULL,
`kommentar` text,
`Hometown` varchar(255) NOT NULL DEFAULT '',