Columns
The Blueprint
object has many column types available to construct your table schema. Additionally, you can modify the columns created with an additional set of methods and indexes.
bigIncrements
Create an auto-incrementing column using an unsigned BIGINT
type. This column is also set as the primary key for the table.
Example:
SchemaBuilder
SQL (MySQL)
bigInteger
Create a column using a BIGINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
bit
Create a column using a BIT
equivalent type for your database. The length can be specified as the second argument.
Example (default length):
SchemaBuilder
SQL (MySQL)
Example (custom length):
SchemaBuilder
SQL (MySQL)
boolean
Create a column using a BOOLEAN
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
char
Create a column using a CHAR
equivalent type for your database.
Example (default length):
SchemaBuilder
SQL (MySQL)
Example (custom length):
SchemaBuilder
SQL (MySQL)
date
Create a column using a DATE
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
datetime
Create a column using a DATETIME
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
datetimeTz
Create a column using a timezone-specific DATETIME
equivalent type for your database.
Some databases do not have the concept of a timezone-specific datetime. Those databases will use a normal DATETIME
type.
Example:
SchemaBuilder
SQL (SQL Server)
decimal
Create a column using a DECIMAL
equivalent type for your database. The length and precision can be specified as the second and third arguments.
Example (with defaults):
SchemaBuilder
SQL (MySQL)
Example (with length):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
enum
Create a column using a ENUM
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
float
Create a column using a FLOAT
equivalent type for your database. The length and precision can be specified as the second and third arguments.
Example (with defaults):
SchemaBuilder
SQL (MySQL)
Example (with length):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
increments
Create an auto-incrementing column using an unsigned INTEGER
type. This column is also set as the primary key for the table.
Example:
SchemaBuilder
SQL (MySQL)
integer
Create a column using a INTEGER
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
json
Create a column using a JSON
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
lineString
Create a column using a LINESTRING
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
longText
Create a column using a LONGTEXT
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
mediumIncrements
Create an auto-incrementing column using an unsigned MEDIUMINT
type. This column is also set as the primary key for the table.
Example:
SchemaBuilder
SQL (MySQL)
mediumInteger
Create a column using a MEDIUMINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
mediumText
Create a column using a MEDIUMTEXT
equivalent type for your database. For databases that distinguish between unicode and non-unicode fields, creates a non-unicode field.
Example:
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
money
Create a column using a MONEY
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
morphs
Creates the necessary columns for a polymorphic relationship. It takes the name provided and creates an _id
and an _type
column.
If you want different names for your polymorphic relationship columns, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (MySQL)
nullableMorphs
Creates the necessary columns for a polymorphic relationship. It takes the name provided and creates an _id
and an _type
column. The only difference between this method and morphs
is that the columns created here are nullable.
If you want different names for your polymorphic relationship columns, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (MySQL)
nullableTimestamps
Creates the createdDate
and modifiedDate
TIMESTAMP
columns. It creates the columns as nullable.
If you want different names for your timestamp columns, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (MySQL)
point
Create a column using a POINT
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
polygon
Create a column using a POLYGON
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
raw
An escape hatch to directly insert any sql in to the statement.
Example:
SchemaBuilder
SQL (MySQL)
smallIncrements
Create an auto-incrementing column using an unsigned SMALLINT
type. This column is also set as the primary key for the table.
Example:
SchemaBuilder
SQL (MySQL)
smallInteger
Create a column using a SMALLINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
smallMoney
Create a column using a SMALLMONEY
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
softDeletes
Creates a nullable deletedDate
TIMESTAMP
column.
If you want different names for your timestamp column, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (MySQL)
softDeletesTz
Creates a nullable deletedDate
timezone-specific TIMESTAMP
column.
If you want different names for your timestamp column, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (SQL Server)
string
Create a column using a VARCHAR
equivalent type for your database. For databases that distinguish between unicode- and non-unicode string data types, this function will create a non-unicode string.
Example (with defaults):
SchemaBuilder
SQL (MySQL)
Example (with length):
SchemaBuilder
SQL (MySQL)
text
Create a column using a TEXT
equivalent type for your database. For databases that distinguish between unicode- and non-unicode string data types, this function will create a non-unicode text field.
Example:
SchemaBuilder
SQL (MySQL)
time
Create a column using a TIME
equivalent type for your database.
Example:
SchemaBuilder
SQL (Postgres)
timeTz
Create a column using a timezone-specific TIME
equivalent type for your database.
Example:
SchemaBuilder
SQL (Postgres)
timestamp
Create a column using a TIMESTAMP
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
timestamps
Creates the createdDate
and modifiedDate
TIMESTAMP
columns.
If you want different names for your timestamp columns, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (MySQL)
timestampTz
Create a column using a timezone-specific TIMESTAMP
equivalent type for your database.
Example:
SchemaBuilder
SQL (Postgres)
timestampsTz
Creates the createdDate
and modifiedDate
timezone-specific TIMESTAMP
columns.
If you want different names for your timestamp columns, feel free to call other schema builder methods individually.
Example:
SchemaBuilder
SQL (Postgres)
tinyIncrements
Create an auto-incrementing column using an unsigned TINYINT
type. This column is also set as the primary key for the table.
Example:
SchemaBuilder
SQL (MySQL)
tinyInteger
Create a column using a TINYINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
unicodeLongText
Create a column using a LONGTEXT
equivalent type for your database. For databases that distinguish between unicode- and non-unicode string data types, this function will create a unicode text field.
Example:
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
unicodeMediumText
Create a unicode-enabled column using a MEDIUMTEXT
equivalent type for your database. For databases that distinguish between unicode- and non-unicode string data types, this function will create a unicode text field.
Example:
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
unicodeString
Create a column using a NVARCHAR
equivalent type for your database. For databases that distinguish between unicode- and non-unicode string data types, this function will create a unicode string.
Example (with defaults):
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
Example (with length):
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
unicodeText
Create a column using a NTEXT
equivalent type for your database.
Example:
SchemaBuilder
SQL (MySQL)
SQL (MSSQL)
unsignedBigInteger
Create a column using a UNSIGNED BIGINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
unsignedInteger
Create a column using a UNSIGNED INTEGER
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
unsignedMediumInteger
Create a column using a UNSIGNED MEDIUMINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
unsignedSmallInteger
Create a column using a UNSIGNED SMALLINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
unsignedTinyInteger
Create a column using a UNSIGNED TINYINT
equivalent type for your database.
Example (no precision):
SchemaBuilder
SQL (MySQL)
Example (with precision):
SchemaBuilder
SQL (MySQL)
uuid
SQL Server: Create a column using a uniqueidentifier
.
MySQL and Others: Create a column using a CHAR
equivalent type for your database and a length of 36. Used in conjunction with the CFML createUUID
method.
Example:
SchemaBuilder
MySQL (SQL Server)
SQL (MySQL)
Last updated