Example #1
0
 /**
  * Builds the SQL query to alter table
  *
  * @return string
  */
 public function build()
 {
     $sqls = [];
     foreach ($this->add_columns as $add) {
         $sqls[] = 'ADD COLUMN ' . $add->toSql();
     }
     foreach ($this->alter_columns as $column_name => $alter) {
         $sqls[] = 'CHANGE COLUMN ' . BQ . $column_name . BQ . SP . $alter->toSql();
     }
     return 'ALTER TABLE ' . BQ . $this->table->getName() . BQ . LF . TAB . join(',' . LF . TAB, $sqls);
 }
Example #2
0
 /**
  * @return string
  */
 public function build()
 {
     $columns = [];
     foreach ($this->table->getColumns() as $column) {
         $columns[] = $column->toSql();
     }
     $indexes = [];
     foreach ($this->table->getIndexes() as $index) {
         $indexes[$index->getName()] = $index->toSql();
     }
     $foreign_keys = [];
     foreach ($this->table->getForeignKeys() as $foreign_key) {
         $foreign_key_constraint = join(DOT, $foreign_key->getFields());
         $foreign_keys[$foreign_key_constraint] = $foreign_key->toSql();
         if (!isset($indexes[$foreign_key_constraint])) {
             $indexes[$foreign_key_constraint] = Index::buildLink($foreign_key_constraint)->toSql();
         }
     }
     return 'CREATE TABLE IF NOT EXISTS ' . BQ . $this->table->getName() . BQ . ' (' . ($columns ? LF . TAB : '') . join(',' . LF . TAB, $columns) . ($indexes ? ',' . LF . TAB : '') . join(',' . LF . TAB, $indexes) . ($foreign_keys ? ',' . LF . TAB : '') . join(',' . LF . TAB, $foreign_keys) . LF . ') DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci';
 }