[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      $cols = $generator->parse("$basepath/columns.tpl");
  10      $pk = $generator->parse("$basepath/primarykey.tpl");
  11      $fk = $generator->parse("$basepath/foreignkey.tpl");
  12      $unique = $generator->parse("$basepath/unique.tpl");
  13      $index = $generator->parse("$basepath/index.tpl");
  14  
  15          $output = array();
  16          if(!empty($cols)) {
  17            $output[] = $cols;
  18          }
  19          if(!empty($pk)) {
  20            $output[] = $pk;
  21          }
  22          if(!empty($unique)) {
  23            $output[] = $unique;
  24          }
  25          if(!empty($index)) {
  26            $output[] = $index;
  27          }
  28          if(!empty($fk)) {
  29            $output[] = $fk;
  30          }
  31  
  32          echo implode(", ", $output);
  33  
  34  ?>
  35  )<?php if (!isset($mysqlTableType)) {
  36              $vendorSpecific = $table->getVendorSpecificInfo();
  37              if(isset($vendorSpecific['Type']))
  38                  $mysqlTableType = $vendorSpecific['Type'];
  39              else
  40                  $mysqlTableType = 'MyISAM';
  41         }
  42  ?>
  43  
  44  Type=<?php echo $mysqlTableType ?>
  45  <?php if($table->getDescription()) { ?> COMMENT='<?php echo $platform->escapeText($table->getDescription()) ?>'<?php } ?>;