diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-11-15 22:07:29 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-11-15 22:07:29 +0000 |
| commit | 3bb1d7070e507be97c531d3626b8f4e8ff101e1b (patch) | |
| tree | b1c238cfcbe1d5e9ebd086676f8439e0242ecb8d /phpBB/db | |
| parent | 2b8692875e8e8dd434ac5d7a9b89cade381feb59 (diff) | |
| download | forums-3bb1d7070e507be97c531d3626b8f4e8ff101e1b.tar forums-3bb1d7070e507be97c531d3626b8f4e8ff101e1b.tar.gz forums-3bb1d7070e507be97c531d3626b8f4e8ff101e1b.tar.bz2 forums-3bb1d7070e507be97c531d3626b8f4e8ff101e1b.tar.xz forums-3bb1d7070e507be97c531d3626b8f4e8ff101e1b.zip | |
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
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 16 |
1 files changed, 8 insertions, 8 deletions
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`) +) # -------------------------------------------------------- # |