ColumnSchemaBuilder

Type: Class
Namespace: craft\db\mysql
Inherits: craft\db\mysql\ColumnSchemaBuilder » yii\db\mysql\ColumnSchemaBuilder (opens new window) » yii\db\ColumnSchemaBuilder (opens new window) » yii\base\BaseObject (opens new window)
Implements: yii\base\Configurable (opens new window)
Since: 3.0.0

# Public Properties

Property	Description
categoryMap (opens new window)	array (opens new window) – Mapping of abstract column types (keys) to type categories (values).
comment (opens new window)	string (opens new window) – Comment value of the column.
db (opens new window)	yii\db\Connection (opens new window) – The current database connection.
typeCategoryMap (opens new window)	array (opens new window) – Mapping of abstract column types (keys) to type categories (values).

# Protected Properties

Property	Description
after (opens new window)	string (opens new window) – The column after which this column will be added.
append (opens new window)	`mixed` – SQL string to be appended to column schema definition.
check (opens new window)	string (opens new window) – The `CHECK` constraint for the column.
default (opens new window)	`mixed` – Default value of the column.
isFirst (opens new window)	boolean (opens new window) – Whether this column is to be inserted at the beginning of the table.
isNotNull (opens new window)	boolean (opens new window), null (opens new window) – Whether the column is or not nullable.
isUnique (opens new window)	boolean (opens new window) – Whether the column values should be unique.
isUnsigned (opens new window)	boolean (opens new window) – Whether the column values should be unsigned.
length (opens new window)	integer (opens new window), string (opens new window), array (opens new window) – Column size or precision definition.
type (opens new window)	string (opens new window) – The column type definition such as INTEGER, VARCHAR, DATETIME, etc.

# Public Methods

Method	Description
__call() (opens new window)	Calls the named method which is not a class method.
__construct() (opens new window)	Create a column schema builder instance giving the type and value precision.
__get() (opens new window)	Returns the value of an object property.
__isset() (opens new window)	Checks if a property is set, i.e. defined and not null.
__set() (opens new window)	Sets value of an object property.
__toString() (opens new window)	Builds the full string for the column's schema.
__unset() (opens new window)	Sets an object property to null.
after() (opens new window)	Adds an `AFTER` constraint to the column.
append() (opens new window)	Specify additional SQL to be appended to column definition.
canGetProperty() (opens new window)	Returns a value indicating whether a property can be read.
canSetProperty() (opens new window)	Returns a value indicating whether a property can be set.
check() (opens new window)	Sets a `CHECK` constraint for the column.
className() (opens new window)	Returns the fully qualified name of this class.
comment() (opens new window)	Specifies the comment for column.
defaultExpression() (opens new window)	Specify the default SQL expression for the column.
defaultValue() (opens new window)	Specify the default value for the column.
first() (opens new window)	Adds an `FIRST` constraint to the column.
getCategoryMap() (opens new window)
hasMethod() (opens new window)	Returns a value indicating whether a method is defined.
hasProperty() (opens new window)	Returns a value indicating whether a property is defined.
init() (opens new window)	Initializes the object.
notNull() (opens new window)	Adds a `NOT NULL` constraint to the column.
null() (opens new window)	Adds a `NULL` constraint to the column.
setCategoryMap() (opens new window)
unique() (opens new window)	Adds a `UNIQUE` constraint to the column.
unsigned() (opens new window)	Marks column as unsigned.

# Protected Methods

Method	Description
buildAfterString() (opens new window)	Builds the after constraint for the column. Defaults to unsupported.
buildAppendString() (opens new window)	Builds the custom string that's appended to column definition.
buildCheckString() (opens new window)	Builds the check constraint for the column.
buildCommentString() (opens new window)	Builds the comment specification for the column.
buildCompleteString() (opens new window)	Returns the complete column definition from input format.
buildDefaultString() (opens new window)	Builds the default value specification for the column.
buildDefaultValue() (opens new window)	Return the default value for the column.
buildFirstString() (opens new window)	Builds the first constraint for the column. Defaults to unsupported.
buildLengthString()	Builds the length/precision part of the column.
buildNotNullString() (opens new window)	Builds the not null constraint for the column.
buildUniqueString() (opens new window)	Builds the unique constraint for the column.
buildUnsignedString() (opens new window)	Builds the unsigned string for column. Defaults to unsupported.
getTypeCategory() (opens new window)	Returns the category of the column type.