[Sommaire] [Imprimer]

   1  <?php
   2  
   3  //

   4  // The following will only work for non-circular references

   5  // if you have a dependancy chain, you will need to use

   6  // ADD CONSTRAINT syntax (with INITIALLY DEFERRED)

   7  // which is sticky and version dependant

   8  //

   9  foreach ($tablefk->getForeignKeys() as $fk) { ?> 
  10  ALTER TABLE <?php echo $tablefk->getName() ?> 
  11      ADD CONSTRAINT <?php echo $fk->getName() ?> FOREIGN KEY (<?php echo $fk->getLocalColumnNames() ?>)
  12      REFERENCES <?php echo $fk->getForeignTableName() ?> (<?php echo $fk->getForeignColumnNames() ?>)
  13  <?php if ($fk->hasOnUpdate()) { ?> 
  14      ON UPDATE <?php echo $fk->getOnUpdate() ?> 
  15  <?php } ?>
  16  <?php if ($fk->hasOnDelete()) { ?> 
  17      ON DELETE <?php echo $fk->getOnDelete() ?> 
  18  <?php } ?> 
  19  ;
  20  <?php } ?>