changeset 213 | 0fe1f610698d |
parent 210 | c7c2fde4f98d |
child 218 | e0ec986c0af3 |
--- 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),