From 3bb1d7070e507be97c531d3626b8f4e8ff101e1b Mon Sep 17 00:00:00 2001
From: Bart van Bragt <bartvb@users.sourceforge.net>
Date: Thu, 15 Nov 2001 22:07:29 +0000
Subject: New and improved search_fill.php, still has a weird memory exhaustion
 bug

git-svn-id: file:///svn/phpbb/trunk@1327 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/db/mysql_schema.sql | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

(limited to 'phpBB/db')

diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index 2ad2682371..4810b3e812 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -271,14 +271,14 @@ CREATE TABLE phpbb_search_results (
 # Table structure for table `phpbb_search_wordlist`
 #
 DROP TABLE IF EXISTS phpbb_search_wordlist;
-CREATE TABLE phpbb_search_wordlist (
-  word_id int(11) NOT NULL auto_increment,
-  word_text varchar(100) NOT NULL default '',
-  word_weight tinyint(4) NOT NULL default '0',
-  PRIMARY KEY  (word_id),
-  KEY word_text (word_text)
-);
-
+CREATE TABLE `phpbb_search_wordlist` (
+  `word_text` varchar(50) binary NOT NULL default '',
+  `word_id` int(11) NOT NULL auto_increment,
+  `word_weight` tinyint(4) NOT NULL default '0',
+  `word_common` tinyint(1) unsigned NOT NULL default '0',
+  PRIMARY KEY (`word_text`),
+  KEY `word_id`(`word_id`)
+)
 
 # --------------------------------------------------------
 #
-- 
cgit v1.2.1