createTable() public method
Creates a SQL command for creating a new DB table.
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 yii\sphinx\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 $this createTable ( $table, $columns, $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. |
| return | $this |
The command object itself |
Please login to continue.