> I need to have a table that supports FULLTEXT searches. This > implies that this table should be a MyISAM table. > > However, I also require that this table act as a parent for > child tables in order to support referential integrity. If I > create the child tables as INNODB tables, will referential > integrity still work with the MyISAM parent table? >
Hello Tom, Currently you can't use InnoDB tables and Full-Text search, also you can't use MyISAM (which support Full-Text) with foreign keys (it's planned to implement foreign keys in MyISAM tables in MySQL 5.0). So my suggestion: use InnoDB & MyISAM together -> maybe it isn't "referential safe" but what can we do... Good luck, Marek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]