From 9f3ed54bddd49d1c22e111a3403bd155605efdd3 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 6 Feb 2018 13:27:32 -0300
Subject: [PATCH] Bug 20144: [sql_modes] Set default value for
 biblio.datecreated in tests

Fix for:
Field 'datecreated' doesn't have a default value

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
---
 t/db_dependent/Creators/Lib.t | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/t/db_dependent/Creators/Lib.t b/t/db_dependent/Creators/Lib.t
index 749c6a761e..248c4e76d9 100644
--- a/t/db_dependent/Creators/Lib.t
+++ b/t/db_dependent/Creators/Lib.t
@@ -148,8 +148,8 @@ my $author3 = 'Author 3';
 
 $query = '
   INSERT INTO biblio
-    (title, author)
-  VALUES (?,?)';
+    (title, author, datecreated)
+  VALUES (?,?, NOW())';
 $insert_sth = $dbh->prepare($query);
 $insert_sth->execute( $title1, $author1 );
 $insert_sth->execute( $title2, undef );
-- 
2.14.2