From 12262b41ecdcb959e05a8b7e6bf96477a9523336 Mon Sep 17 00:00:00 2001
From: diml <diml>
Date: Fri, 7 Sep 2007 18:54:47 +0000
Subject: [PATCH] fixes docdate bad default value format. Was '0', should have
 been 0.

---
 search/db/mysql.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 search/db/mysql.sql

diff --git a/search/db/mysql.sql b/search/db/mysql.sql
new file mode 100644
index 0000000000..7e1aabeaaf
--- /dev/null
+++ b/search/db/mysql.sql
@@ -0,0 +1,12 @@
+CREATE TABLE IF NOT EXISTS `prefix_search_documents` (
+  `id` int(11) NOT NULL auto_increment,
+  `docid` int(11) NOT NULL,
+  `doctype` varchar(12) NOT NULL default 'none',
+  `title` varchar(255) NOT NULL default '',
+  `url` varchar(255) NOT NULL default '',
+  `docdate` timestamp NOT NULL default 0,
+  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `courseid` int(11) NOT NULL default 0,
+  `groupid` int(11) NOT NULL default 0,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1;
-- 
2.39.5