[Sommaire] [Imprimer]

   1  <?php foreach ($tablefk->getForeignKeys() as $fk) { ?>
   2  ALTER TABLE <?php echo $tablefk->getName()?>
   3      ADD CONSTRAINT <?php echo $fk->getName() ?> FOREIGN KEY (<?php echo $fk->getLocalColumnNames()?>)
   4      REFERENCES <?php echo $fk->getForeignTableName()?> (<?php echo $fk->getForeignColumnNames()?>)<?php
   5   if ($fk->hasOnDelete()) {?>
   6      ON DELETE <?php echo $fk->getOnDelete();
   7  }?>;
   8  
   9  <?php } ?>
  10  <?php
  11    /*
  12           -- TODO
  13          ON UPDATE $fk.OnUpdate
  14    */
  15  ?>
  16