In installerul modului presupunem ca ati creat un tabel –
$installer = $this; $installer->startSetup(); $moduleTableName = $installer->getTable('mymodule/mymodule'); if($installer->getConnection()->isTableExists($moduleTableName) != true) { $table = $installer->getConnection() ->newTable($moduleTableName);
$installer->getConnection()->createTable($table);
Pe una din coloanele create doriti sa creati un foreign key -> asemanator
->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array( 'nullable' => false, ), 'Created at')
exista (->addForeignKey())
->addForeignKey( $installer->getFkName( 'mymodule/mymodule', 'product_id', 'catalog/product', 'entity_id' ), 'product_id', $installer->getTable('catalog/product'), 'entity_id', Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE );