[Sommaire] [Imprimer]

   1  -- -----------------------------------------------------------------------
   2  -- <?php echo $table->getName() ?>
   3  -- -----------------------------------------------------------------------
   4  <?php echo $generator->parse("$basepath/drop.tpl") ?>
   5  
   6  CREATE TABLE <?php echo $table->getName() ?>
   7  (
   8  <?php 
   9          
  10      $cols = $generator->parse("$basepath/columns.tpl");
  11      $fk = $generator->parse("$basepath/foreignkey.tpl");
  12      $unique = $generator->parse("$basepath/unique.tpl");
  13      $index = $generator->parse("$basepath/index.tpl");    
  14      
  15      if (empty($unique)) {        
  16          echo preg_replace('/[,]+\s*$/', '', $cols);
  17      } else {
  18          echo $cols;
  19          echo preg_replace('/[,]+\s*$/', '', $unique);
  20      }        
  21      
  22  ?> 
  23  );
  24  
  25  <?php
  26      if (!empty($index)) {
  27          echo $index;
  28      }
  29      
  30      if (!empty($fk)) {
  31          echo $fk;
  32      }
  33  ?>