addForeignKey() public method Creates a SQL command for adding a foreign key constraint to an existing table. The method will properly quote the table and column names. public $this addForeignKey ( $name, $table, $columns, $refTable, $refColumns, $delete = null, $update = null )$name string The name of the foreign key constraint. $table string The table that the foreign key constraint will be added to. $columns string|array The name of the column to that the constraint will be adde

addColumn() public method Creates a SQL command for adding a new DB column. public $this addColumn ( $table, $column, $type )$table string The table that the new column will be added to. The table name will be properly quoted by the method. $column string The name of the new column. The name will be properly quoted by the method. $type string The column type. yii\db\QueryBuilder::getColumnType() will be called to convert the give column type to the physical one. For example, string w

$db public property The Sphinx connection that this command is associated with. public yii\sphinx\Connection $db = null

typecast() protected method (available since version 2.0.3) Converts the input value according to $phpType after retrieval from the database. If the value is null or an yii\db\Expression, it will not be converted. protected mixed typecast ( $value )$value mixed Input value return mixed Converted value

phpTypecast() public method Converts the input value according to $phpType after retrieval from the database. If the value is null or an yii\db\Expression, it will not be converted. public mixed phpTypecast ( $value )$value mixed Input value return mixed Converted value

dbTypecast() public method Converts the input value according to $type and $dbType for use in a db query. If the value is null or an yii\db\Expression, it will not be converted. public mixed dbTypecast ( $value )$value mixed Input value return mixed Converted value. This may also be an array containing the value as the first element and the PDO type as the second element.

$type public property Abstract type of this column. Possible abstract types include: string, text, boolean, smallint, integer, bigint, float, decimal, datetime, timestamp, time, date, binary, and money. public string $type = null

$phpType public property The PHP type of this column. Possible PHP types include: string, boolean, integer, double. public string $phpType = null

$name public property Name of this column (without quotes). public string $name = null

$isPrimaryKey public property Whether this column is a primary key public boolean $isPrimaryKey = null