From b7a2cc89ddb95c934f4fca2e741f4e4f974f8252 Mon Sep 17 00:00:00 2001
From: diml <diml>
Date: Fri, 7 Sep 2007 18:56:17 +0000
Subject: [PATCH] add postgress model for search

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

diff --git a/search/db/postgres7.sql b/search/db/postgres7.sql
new file mode 100644
index 0000000000..8abc3030ed
--- /dev/null
+++ b/search/db/postgres7.sql
@@ -0,0 +1,11 @@
+CREATE TABLE prefix_search_documents (
+   id SERIAL8 PRIMARY KEY,
+   docid int4 NOT NULL,
+   doctype varchar(12) NOT NULL DEFAULT 'none',
+   title varchar(100) NOT NULL default '',
+   url varchar(250) NOT NULL default '',
+   docdate timestamp NOT NULL,
+   updated timestamp NOT NULL DEFAULT NOW(),
+   courseid int4,
+   groupid int4
+);
-- 
2.39.5