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