I have the same problem and I didn't found documentation to select the engine for a given table.
I tried to understand the code by myself and made modifications of my Doctrine v2.0.5, perhaps this is not the best one but here is a beginning of a solution :
-------------------------------------------------------------------------------
@ ORM\Mapping\Driver\DoctrineAnnotations.php:100
final class Table extends Annotation
{ public $name; public $schema; public $indexes; public $uniqueConstraints; public $engine; }@ ORM\Mapping\Driver\AnnotationDriver.php:144
$primaryTable = array(
'name' => $tableAnnot->name,
'schema' => $tableAnnot->schema,
'engine' => $tableAnnot->engine
);
@ ORM\Tools\SchemaTool.php:133
$table = $schema->createTable($class->getQuotedTableName($this->_platform));
if ( isset($class->table["engine"]) )
$table->addOption("engine",$class->table["engine"]);
-------------------------------------------------------------------------------
...and to define for instance the MyISAM engine in annotations :
/**
- @Entity
- @Table(engine="MyISAM")
*/
Because there is no foreign key on MyISAM tables, there are still problems on the schema creation/update when Doctrine executes the corresponding "alter table" SQL commands.
in Doctrine 2.2.2 will be
Doctrine/ORM/Tools/SchemaTool.php-149- /// PATCH ------------------------------------
Doctrine/ORM/Tools/SchemaTool.php-150- if ( isset($class->table["engine"]) )
Doctrine/ORM/Tools/SchemaTool.php-151- $table->addOption("engine",$class->table["engine"]);
Doctrine/ORM/Tools/SchemaTool.php-152- /// PATCH ------------------------------------
Doctrine/ORM/Mapping/ClassMetadataInfo.php-1719- /// PATCH ------------------------------------
Doctrine/ORM/Mapping/ClassMetadataInfo.php-1720- if (isset($table['engine']))
Doctrine/ORM/Mapping/ClassMetadataInfo.php-1723- /// PATCH ------------------------------------
Doctrine/ORM/Mapping/Table.php-42- /// PATCH ------------------------------------
Doctrine/ORM/Mapping/Table.php-43- /** @var string */
Doctrine/ORM/Mapping/Table.php-44- public $engine;
Doctrine/ORM/Mapping/Table.php-45- /// PATCH ------------------------------------
Doctrine/ORM/Mapping/Driver/AnnotationDriver.php-181- /// PATCH ------------------------------------
Doctrine/ORM/Mapping/Driver/AnnotationDriver.php-182- $primaryTable['engine'] = $tableAnnot->engine;
Doctrine/ORM/Mapping/Driver/AnnotationDriver.php-183- /// PATCH ------------------------------------
i found a problem in ManyToMany relations, the intermediate table will be InnoDB
You can do all tables as MyISAM already through metadata using @Table(options=
{"engine": "MyISAM"}) except Many-To-Many Join Tables. But you could create a listener to the "postSchemaGenerate" event and accept the schema instance there, modify everything accordingly.
should we add the support of the options for the @JoinTable annotation ?
Yes, that is probably what this ticket boils down to 