From 93960a1b8e7b43c4bc504baeabe6a88427b529c6 Mon Sep 17 00:00:00 2001 From: Nils Adermann 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