Hello,
I’ am trying creating a model with a MyISAM table and an InnoDB table using the following schema.
<?xml version="1.0" encoding="UTF-8"?>
<model package="test" baseClass="xPDOObject" platform="mysql" defaultEngine="MyIsam" version="1.1" >
<object class="Link" table="links" engine="InnoDB" extends="xPDOSimpleObject" >
<field key="url" dbtype="varchar" precision="2083" phptype="string" null="false" default="" />
<index alias="URL" name="URL" primary="false" unique="false" type="HASH">
<column key="url" collation="A" null="false" />
</index>
<composite alias="Linkdetail" class="Linkdetail" local="id" foreign="id" cardinality="one" owner="local" />
</object>
<object class="Linkdetail" table="linksdetails" extends="xPDOSimpleObject " >
<field key="decription" dbtype="text" phptype="string" null="true" />
<aggregate alias="Link" class="Link" local="id" foreign="id" cardinality="one" owner="foreign" />
</object>
</model>
Trying to create the model with parseSchema and the DB tables with createObjectContainer ignores the InnoDB engines. Even when I changed the defaultEngine to InnoDB the engine remained MyISAM. Every time I tried I get a message like this:
[tt][2011-05-08 22:28:19] (INFO @ /test/index.php)
Created table `ft_links`
SQL: CREATE TABLE `ft_links` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT, `url` VARCHAR(2083) NOT NULL DEFAULT ’’, PRIMARY KEY (`id`), INDEX `URL` (`url`)) ENGINE=MyISAM
[2011-05-08 22:28:19] (INFO @ /test/index.php)
Created table `ft_linksdetails`
SQL: CREATE TABLE `ft_linksdetails` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT, `decription` TEXT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM
[/tt]
I am using xPDO 2.1.3-pl
MODX Staff