diff options
| author | Andrej Rode <mail@andrejro.de> | 2017-08-15 23:05:43 +0200 |
|---|---|---|
| committer | Andrej Rode <mail@andrejro.de> | 2017-08-15 23:05:43 +0200 |
| commit | b1af1f9cc2497087e5de47970024c235a17ea4c2 (patch) | |
| tree | 61256337acb4b6d556ef3b7859fda3cb8c04dedd /db | |
| parent | a5fc5bd0979e8de1fce8a8addd351a6e7bd6aeb8 (diff) | |
Change default value for datetime fields to valid range
Diffstat (limited to 'db')
| -rw-r--r-- | db/install.sql | 4 |
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 '', |