a9f4cdbf12b6fce85eda7cfd508b5ffdc2a07f57
1 -- Break fulltext search index out to separate table from cur
2 -- This is being done mainly to allow us to use InnoDB tables
3 -- for the main db while keeping the MyISAM fulltext index for
6 -- 2002-12-16, 2003-01-25 Brion VIBBER <brion@pobox.com>
8 -- Creating searchindex table...
9 DROP TABLE IF EXISTS /*$wgDBprefix*/searchindex
;
10 CREATE TABLE /*$wgDBprefix*/searchindex (
11 si_page
int(8) unsigned
NOT NULL,
12 si_title
varchar(255) NOT NULL default '',
13 si_text mediumtext
NOT NULL default '',
15 ) TYPE=MyISAM PACK_KEYS
=1;
17 -- Copying data into new table...
18 INSERT INTO /*$wgDBprefix*/searchindex
19 (si_page
,si_title
,si_text
)
21 cur_id
,cur_ind_title
,cur_ind_text
22 FROM /*$wgDBprefix*/cur
;
25 -- Creating fulltext index...
26 ALTER TABLE /*$wgDBprefix*/searchindex
27 ADD FULLTEXT
si_title (si_title
),
28 ADD FULLTEXT
si_text (si_text
);
30 -- Dropping index columns from cur table.
31 ALTER TABLE /*$wgDBprefix*/cur
32 DROP COLUMN cur_ind_title
,
33 DROP COLUMN cur_ind_text
;