[Sommaire] [Imprimer]

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