diff options
| author | Nils Adermann <naderman@naderman.de> | 2006-01-19 16:38:00 +0000 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2006-01-19 16:38:00 +0000 |
| commit | 93960a1b8e7b43c4bc504baeabe6a88427b529c6 (patch) | |
| tree | d0cfcd0425bc8f965451970e4be2d8961948b203 /phpBB/install/schemas | |
| parent | 38a63d94be400223a463378ecbfd668121c16ce8 (diff) | |
| download | forums-93960a1b8e7b43c4bc504baeabe6a88427b529c6.tar forums-93960a1b8e7b43c4bc504baeabe6a88427b529c6.tar.gz forums-93960a1b8e7b43c4bc504baeabe6a88427b529c6.tar.bz2 forums-93960a1b8e7b43c4bc504baeabe6a88427b529c6.tar.xz forums-93960a1b8e7b43c4bc504baeabe6a88427b529c6.zip | |
looks like I forgot to commit these two files :o
git-svn-id: file:///svn/phpbb/trunk@5476 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 9 |
1 files changed, 4 insertions, 5 deletions
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 '', |