From 93960a1b8e7b43c4bc504baeabe6a88427b529c6 Mon Sep 17 00:00:00 2001
From: Nils Adermann <naderman@naderman.de>
Date: Thu, 19 Jan 2006 16:38:00 +0000
Subject: looks like I forgot to commit these two files :o

git-svn-id: file:///svn/phpbb/trunk@5476 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/sqlite_schema.sql | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

(limited to 'phpBB/install/schemas/sqlite_schema.sql')

diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 3020dc3db0..32f7f3596d 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -564,14 +564,13 @@ CREATE TABLE phpbb_reports (
 
 # Table: phpbb_search_results
 CREATE TABLE phpbb_search_results (
-  search_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0',
-  session_id varchar(32) NOT NULL DEFAULT '',
+  search_key varchar(32) NOT NULL DEFAULT '',
   search_time int(11) NOT NULL DEFAULT '0',
-  search_array mediumtext(16777215) NOT NULL
+  search_keywords mediumtext(16777215) NOT NULL,
+  search_authors mediumtext(16777215) NOT NULL,
+  PRIMARY KEY (search_key)
 );
 
-CREATE INDEX session_id_phpbb_search_result on phpbb_search_results (session_id);
-
 # Table: phpbb_search_wordlist
 CREATE TABLE phpbb_search_wordlist (
   word_text varchar(50) NOT NULL DEFAULT '',
-- 
cgit v1.2.1

