yii\db\Command::createTable PHP Method

Command Class Documentation Mostrar archivo Open project: yiisoft/yii2

createTable() public method

The columns in the new table should be specified as name-definition pairs (e.g. 'name' => 'string'), where name stands for a column name which will be properly quoted by the method, and definition stands for the column type which can contain an abstract DB type. The method [[QueryBuilder::getColumnType()]] will be called to convert the abstract column types to physical ones. For example, string will be converted as varchar(255), and string not null becomes varchar(255) not null. If a column is specified with definition only (e.g. 'PRIMARY KEY (name, type)'), it will be directly inserted into the generated SQL.

public createTable ( string $table, array $columns, string $options = null )
$table	string	the name of the table to be created. The name will be properly quoted by the method.
$columns	array	the columns (name => definition) in the new table.
$options	string	additional SQL fragment that will be appended to the generated SQL.

    public function createTable($table, $columns, $options = null)
    {
        $sql = $this->db->getQueryBuilder()->createTable($table, $columns, $options);
        return $this->setSql($sql);
    }

Command

addColumn

addCommentOnColumn

addCommentOnTable

addForeignKey

addPrimaryKey

alterColumn

batchInsert

bindParam

bindPendingParams

bindValue

bindValues