20 lines
584 B
PHP
20 lines
584 B
PHP
<?php foreach ($foreignKeys as $column => $fkData): ?>
|
|
|
|
// creates index for column `<?= $column ?>`
|
|
$this->createIndex(
|
|
'<?= $fkData['idx'] ?>',
|
|
'<?= $table ?>',
|
|
'<?= $column ?>'
|
|
);
|
|
|
|
// add foreign key for table `<?= $fkData['relatedTable'] ?>`
|
|
$this->addForeignKey(
|
|
'<?= $fkData['fk'] ?>',
|
|
'<?= $table ?>',
|
|
'<?= $column ?>',
|
|
'<?= $fkData['relatedTable'] ?>',
|
|
'<?= $fkData['relatedColumn'] ?>',
|
|
'CASCADE'
|
|
);
|
|
<?php endforeach;
|