SetBased / php-audit

    // Create SQL for columns.

    $code->append('(');

    foreach ($columns as $column)

    {

      $code->append(sprintf($format, '`'.$column['column_name'].'`', $column['column_type']), false);

      if (end($columns)!==$column)

      {

        $code->appendToLastLine(',');

      }

    }

    // Create SQL for table options.

    $tableOptions = DataLayer::getTableOptions($this->dataSchemaName, $this->tableName);

  {

    $sql = new CompoundSyntaxStore();

    $sql->append(sprintf('create temporary table `%s`.`%s` (', $schemaName, $tableName));

    foreach ($auditColumns as $column)

    {

      $sql->append(sprintf('%s %s', $column['column_name'], $column['column_type']));

      if (end($auditColumns)!==$column)

      {

        $sql->appendToLastLine(',');

      }

    }

    $sql->append(')');

    self::$dl->executeNone($sql->getCode());