dropCommentFromColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public string dropCommentFromColumn ( $table, $column )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $column string The name of the column to be commented. The column name will be properly quoted by the method. return string The SQL statement for adding comment on column

createIndex() public method Builds a SQL statement for creating a new index. See also https://bugs.mysql.com/bug.php?id=48875. public string createIndex ( $name, $table, $columns, $unique = false )$name string The name of the index. The name will be properly quoted by the method. $table string The table that the new index will be created for. The table name will be properly quoted by the method. $columns string|array The column(s) that should be included in the index. If there are

checkIntegrity() public method Builds a SQL statement for enabling or disabling integrity check. public string checkIntegrity ( $check = true, $schema = '', $table = '' )$check boolean Whether to turn on or off the integrity check. $schema string The schema of the tables. Meaningless for MySQL. $table string The table name. Meaningless for MySQL. return string The SQL statement for checking integrity

buildLimit() public method public string buildLimit ( $limit, $offset )$limit integer $offset integer return string The LIMIT and OFFSET clauses

addCommentOnTable() public method (available since version 2.0.8) Builds a SQL command for adding comment to table public string addCommentOnTable ( $table, $comment )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $comment string The text of the comment to be added. The comment will be properly quoted by the method. return string The SQL statement for adding comment on table

addCommentOnColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public string addCommentOnColumn ( $table, $column, $comment )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $column string The name of the column to be commented. The column name will be properly quoted by the method. $comment string The text of the comment to be added. The comment will be properly quoted

$typeMap public property Mapping from abstract column types (keys) to physical column types (values). public array $typeMap = [\yii\db\mysql\Schema::TYPE_PK => 'int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\mysql\Schema::TYPE_UPK => 'int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\mysql\Schema::TYPE_BIGPK => 'bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY', \yii\db\mysql\Schema::TYPE_UBIGPK => 'bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', \yi

__toString() public method Builds the full string for the column's schema public string __toString ( )

buildUnsignedString() protected method Builds the unsigned string for column. Defaults to unsupported. protected string buildUnsignedString ( )return string A string containing UNSIGNED keyword.

buildFirstString() protected method Builds the first constraint for the column. Defaults to unsupported. protected string buildFirstString ( )return string A string containing the FIRST constraint.