<html>
<!-- BEGIN WEBMAIL STATIONERY -->
<head></head>
<body>
<!-- WEBMAIL STATIONERY noneset -->
<DIV>I keep learning more about MySQL and I recently discovered that full text indexing does not work with the InnoDB table type. I also discovered that foreign keys do not work with MyISAM table types. What to do?</DIV>
<DIV> </DIV>
<DIV>I have a table with configuration values that relate to pages on my website. Each page can have a configuation setting with the same name and value, but I don't want two cofiguration settings with the same name for a page. I want to index the two columns in the table, the configuration setting name and the page it relates to, but I can't do this unless I change the table type to InnoDB.</DIV>
<DIV> </DIV>
<DIV>Can I do this with a trigger and still use the MyISAM table type?</DIV>
<!-- END WEBMAIL STATIONERY -->
</body>
</html>