From 036989246e31e2966340de37b4055b871838c1fe Mon Sep 17 00:00:00 2001
From: diml <diml>
Date: Tue, 20 Nov 2007 23:37:15 +0000
Subject: [PATCH] added default values for datetime fields

---
 blocks/search/db/install.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/blocks/search/db/install.xml b/blocks/search/db/install.xml
index b118e4e1b2..d71fd70847 100644
--- a/blocks/search/db/install.xml
+++ b/blocks/search/db/install.xml
@@ -12,8 +12,8 @@
         <FIELD NAME="itemtype" TYPE="char" LENGTH="32" NOTNULL="true" DEFAULT="standard" SEQUENCE="false" ENUM="false" PREVIOUS="doctype" NEXT="title"/>
         <FIELD NAME="title" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="itemtype" NEXT="url"/>
         <FIELD NAME="url" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="title" NEXT="docdate"/>
-        <FIELD NAME="docdate" TYPE="datetime" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="url" NEXT="updated"/>
-        <FIELD NAME="updated" TYPE="datetime" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="docdate" NEXT="courseid"/>
+        <FIELD NAME="docdate" TYPE="datetime" NOTNULL="true" DEFAULT="'0000-00-00 00:00:00'" SEQUENCE="false" ENUM="false" PREVIOUS="url" NEXT="updated"/>
+        <FIELD NAME="updated" TYPE="datetime" NOTNULL="true" DEFAULT="'0000-00-00 00:00:00'" SEQUENCE="false" ENUM="false" PREVIOUS="docdate" NEXT="courseid"/>
         <FIELD NAME="courseid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="updated" NEXT="groupid"/>
         <FIELD NAME="groupid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="courseid"/>
       </FIELDS>
-- 
2.39.5