From 1b4bb51edbaf27f93f26938fd517970dcea44458 Mon Sep 17 00:00:00 2001 From: diml Date: Mon, 10 Sep 2007 17:26:10 +0000 Subject: [PATCH] add new itemid field for indexing subitems. --- search/db/mysql.sql | 1 + search/db/postgres7.sql | 3 ++- 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/search/db/mysql.sql b/search/db/mysql.sql index 7e1aabeaaf..17c1719cca 100644 --- a/search/db/mysql.sql +++ b/search/db/mysql.sql @@ -2,6 +2,7 @@ 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, diff --git a/search/db/postgres7.sql b/search/db/postgres7.sql index 8abc3030ed..c585916aad 100644 --- a/search/db/postgres7.sql +++ b/search/db/postgres7.sql @@ -2,7 +2,8 @@ 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 '', + 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(), -- 2.39.5