schema.sql
changeset 264 0fe1f610698d
parent 261 c7c2fde4f98d
child 266 917dcc6c4ceb
child 272 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),