ColumnTypes extension

on

Methods

bigIncrements(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Add a big auto-incrementing column
bigInt(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a big integer column
binary(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a binary column
bit(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a bit column
blob(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a blob column
boolean(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a boolean column
char(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a char column
date(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a date column
dateTime(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a datetime column
decimal(String name, {int? precision, int? scale}) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a decimal column
double(String name, {int? precision, int? scale}) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a double column
enumType(String name, List<String> values) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create an enum column
float(String name, {int? precision, int? scale}) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a float column
geometry(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a geometry column
geometryCollection(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a geometry collection column
id([String name = 'id']) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Add an auto-incrementing primary key column
integer(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create an integer column
json(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a JSON column
lineString(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a line string geometry column
longBlob(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a long blob column
longText(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a long text column
mediumBlob(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a medium blob column
mediumInt(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a medium integer column
mediumText(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a medium text column
multiLineString(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a multi-line string geometry column
multiPoint(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a multi-point geometry column
multiPolygon(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a multi-polygon geometry column
point(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a point geometry column
polygon(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a polygon geometry column
setType(String name, List<String> values) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a set column
smallInt(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a small integer column
softDeletes([String name = 'deleted_at']) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create soft delete timestamp
string(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a string/varchar column
text(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a text column
time(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a time column
timeStamp(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a timestamp column
timeStamps() → void

Available on Schema, provided by the ColumnTypes extension

Create standard timestamps (created_at, updated_at)
tinyBlob(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a tiny blob column
tinyInt(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a tiny integer column
tinyText(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a tiny text column
uuid(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a UUID column
varBinary(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a variable binary column
year(String name) ColumnDefinition

Available on Schema, provided by the ColumnTypes extension

Create a year column