From 789d27eae688e30d22fe9627e9d98a9bf71a6264 Mon Sep 17 00:00:00 2001
From: diml <diml>
Date: Wed, 12 Sep 2007 21:23:55 +0000
Subject: [PATCH] changes reindexing strategy : deletes records rather than
 create back table search db model transfered to block_search. No db model
 needed here.

---
 search/db/README.txt    |  5 -----
 search/db/mysql.sql     | 13 -------------
 search/db/postgres7.sql | 12 ------------
 3 files changed, 30 deletions(-)
 delete mode 100644 search/db/README.txt
 delete mode 100644 search/db/mysql.sql
 delete mode 100644 search/db/postgres7.sql

diff --git a/search/db/README.txt b/search/db/README.txt
deleted file mode 100644
index 6ee6a18721..0000000000
--- a/search/db/README.txt
+++ /dev/null
@@ -1,5 +0,0 @@
-This databse scheme IS NOT installed automatically as other models 
-(blocks or modules), but is internally regenerated by the search engine. 
-Actually mysql and postgres7 supported. 
-
-TODO : change the generation process to the new XMLDB procedure. 
\ No newline at end of file
diff --git a/search/db/mysql.sql b/search/db/mysql.sql
deleted file mode 100644
index 17c1719cca..0000000000
--- a/search/db/mysql.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-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',
-  `itemtype` varchar(32) 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;
diff --git a/search/db/postgres7.sql b/search/db/postgres7.sql
deleted file mode 100644
index c585916aad..0000000000
--- a/search/db/postgres7.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-CREATE TABLE prefix_search_documents (
-   id SERIAL8 PRIMARY KEY,
-   docid int4 NOT NULL,
-   doctype varchar(12) NOT NULL DEFAULT 'none',
-   itemtype varchar(32) NOT NULL DEFAULT 'none',
-   title varchar(255) 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