[Sommaire] [Imprimer]

   1  
   2  -----------------------------------------------------------------------------
   3  -- <?php echo $table->getName() ?>
   4  -----------------------------------------------------------------------------
   5  <?php
   6  echo $generator->parse("$basepath/drop.tpl");
   7  $sequence = $generator->parse("$basepath/sequence.tpl");
   8  if (!empty($sequence)) {
   9      echo $sequence;
  10  }
  11  ?>
  12  
  13  CREATE TABLE <?php echo $table->getName() ?> 
  14  (
  15      <?php
  16      $cols = $generator->parse("$basepath/columns.tpl");
  17      $pk = trim($generator->parse("$basepath/primarykey.tpl"));
  18      $unique = $generator->parse("$basepath/unique.tpl");
  19      $index = trim($generator->parse("$basepath/index.tpl"));    
  20      
  21      if ( empty($pk) && empty($unique)) {
  22          echo preg_replace('/[ ,]+[\s]*$/', '', $cols);
  23      } else {
  24          echo $cols;
  25      }
  26      
  27      if (empty($unique) && !empty($pk)) {
  28          echo preg_replace('/[ ,]+[\s]*$/', '', $pk);
  29      } else {
  30          echo $pk;
  31      }
  32      
  33      if (!empty($unique)) {
  34          echo preg_replace('/[ ,]+[\s]*$/', '', $unique);
  35      }    
  36  ?> 
  37  );
  38  <?php 
  39      if(!empty($index)) { 
  40          echo preg_replace('/[ ,]+[\s]*$/', '', $index); 
  41      } 
  42  ?>
  43  
  44  COMMENT ON TABLE <?php echo $table->getName() ?> IS '<?php echo $platform->escapeText($table->getDescription()) ?>';
  45  
  46  <?php
  47    foreach ($table->getColumns() as $col) {
  48      if( $col->getDescription() != '' ) {
  49  ?>
  50  COMMENT ON COLUMN <?php echo $table->getName() ?>.<?php echo $col->getName() ?> IS '<?php echo $platform->escapeText($col->getDescription()) ?>';
  51  <?php
  52      }
  53    }
  54  ?>
  55