[Sommaire] [Imprimer]

   1  <?php
   2      $tableName = $table->getName();
   3      $length = strlen($tableName);
   4      if ($length > 27) {
   5          $length = 27;
   6      }
   7  ?>
   8  <?php if ( is_array($table->getPrimaryKey()) && count($table->getPrimaryKey()) ) { ?>
   9  ALTER TABLE <?php echo $table->getName() ?>
  10  
  11      ADD CONSTRAINT <?php echo substr($tableName,0,$length)?>_PK
  12  PRIMARY KEY (<?php
  13      $delim = "";
  14      foreach ($table->getPrimaryKey() as $col) {
  15          echo $delim . $col->getName();
  16          $delim = ",";
  17      }
  18  ?>);
  19  <?php } ?>