 fvExtension              VARCHAR(32),
 fvType                   INTEGER(10) UNSIGNED NOT NULL DEFAULT 0,
                  PRIMARY KEY (fID, fvID)
-)ENGINE=MYISAM;
+);
 
 ALTER TABLE FileVersions ADD  INDEX fvExtension  (fvType);
 

cDateLastIndexed         DATETIME,
cDateLastSitemapped      DATETIME,
                 PRIMARY KEY (cID)
)ENGINE=MYISAM;

ALTER TABLE PageSearchIndex ADD  FULLTEXT INDEX cName  (cName);


  PRIMARY KEY  (`fID`)
);

CREATE TABLE IF NOT EXISTS `UserSearchIndexAttributes` (
  `uID` int(11) unsigned NOT NULL DEFAULT '0',
  `ak_profile_private_messages_enabled` tinyint(4) DEFAULT '0',
  `ak_profile_private_messages_notification_enabled` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`uID`)
);
