Referential integrity, FULLTEXT and table types

2003-07-28 Thread Tom Gazzini
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

RE: Referential integrity, FULLTEXT and table types

2003-07-28 Thread Marek Lewczuk
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

Re: Referential integrity, FULLTEXT and table types

2003-07-28 Thread Santino
At 16:20 +0100 28-07-2003, Tom Gazzini wrote: 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