diff -r d57af0b0302e -r 0fe1f610698d schema.sql --- a/schema.sql Sat Nov 17 20:31:01 2007 -0500 +++ b/schema.sql Sat Nov 17 21:09:31 2007 -0500 @@ -52,8 +52,9 @@ page_id varchar(63), namespace varchar(16) NOT NULL default 'Article', page_text text, - char_tag varchar(63) -) CHARACTER SET `utf8`; + char_tag varchar(63), + FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text) +) ENGINE = MYISAM CHARACTER SET `utf8`; CREATE TABLE {{TABLE_PREFIX}}pages( page_order int(8),