blob: 36507a2be8e889e5b0f6d0080eec9929dbce35b1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
-- Break fulltext search index out to separate table from cur
-- This is being done mainly to allow us to use InnoDB tables
-- for the main db while keeping the MyISAM fulltext index for
-- search.
-- 2002-12-16, 2003-01-25 Brion VIBBER <brion@pobox.com>
-- Creating searchindex table...
DROP TABLE IF EXISTS /*$wgDBprefix*/searchindex;
CREATE TABLE /*$wgDBprefix*/searchindex (
-- Key to page_id
si_page int unsigned NOT NULL,
-- Munged version of title
si_title varchar(255) NOT NULL default '',
-- Munged version of body text
si_text mediumtext NOT NULL,
UNIQUE KEY (si_page)
) ENGINE=MyISAM;
-- Copying data into new table...
INSERT INTO /*$wgDBprefix*/searchindex
(si_page,si_title,si_text)
SELECT
cur_id,cur_ind_title,cur_ind_text
FROM /*$wgDBprefix*/cur;
-- Creating fulltext index...
ALTER TABLE /*$wgDBprefix*/searchindex
ADD FULLTEXT si_title (si_title),
ADD FULLTEXT si_text (si_text);
-- Dropping index columns from cur table.
ALTER TABLE /*$wgDBprefix*/cur
DROP COLUMN cur_ind_title,
DROP COLUMN cur_ind_text;
|
