Blueprint
class Blueprint (View source)
Properties
| protected string | $table | The table the blueprint describes. |
|
| protected array | $columns | The columns that should be added to the table. |
|
| protected array | $commands | The commands that should be run for the table. |
|
| string | $engine | The storage engine that should be used for the table. |
Methods
Add the commands that are implied by the blueprint.
Add the index commands fluently specified on columns.
Determine if the blueprint has a create command.
Indicate that the table should be dropped if it exists.
Indicate that the given columns should be dropped.
Indicate that the given columns should be renamed.
Indicate that the given primary key should be dropped.
Indicate that the given unique key should be dropped.
Indicate that the given foreign key should be dropped.
Indicate that the timestamp columns should be dropped.
Indicate that the soft delete column should be dropped.
Specify the primary key(s) for the table.
Create a new auto-incrementing integer column on the table.
Create a new auto-incrementing big integer column on the table.
Create a new medium text column on the table.
Create a new integer column on the table.
Create a new big integer column on the table.
Create a new medium integer column on the table.
Create a new tiny integer column on the table.
Create a new small integer column on the table.
Create a new unsigned integer column on the table.
Create a new unsigned big integer column on the table.
Create a new float column on the table.
Create a new double column on the table.
Create a new decimal column on the table.
Add nullable creation and update timestamps to the table.
Add creation and update timestamps to the table.
Add a "deleted at" timestamp for the table.
Add the proper columns for a polymorphic table.
Adds the remember_token column to the table.
Create a new drop index command on the blueprint.
Add a new index command to the blueprint.
Create a default index name for the table.
Add a new column to the blueprint.
Remove a column from the schema blueprint.
Add a new command to the blueprint.
Create a new Fluent command.
Get the table the blueprint describes.
Get the columns that should be added.
Get the commands on the blueprint.
Details
void
__construct(string $table, Closure $callback = null)
Create a new schema blueprint.
void
build(Connection $connection, Grammar $grammar)
Execute the blueprint against the database.
array
toSql(Connection $connection, Grammar $grammar)
Get the raw SQL statements for the blueprint.
protected void
addImpliedCommands()
Add the commands that are implied by the blueprint.
protected void
addFluentIndexes()
Add the index commands fluently specified on columns.
protected bool
creating()
Determine if the blueprint has a create command.
Fluent
create()
Indicate that the table needs to be created.
Fluent
drop()
Indicate that the table should be dropped.
Fluent
dropIfExists()
Indicate that the table should be dropped if it exists.
Fluent
dropColumn(string|array $columns)
Indicate that the given columns should be dropped.
Fluent
renameColumn(string $from, string $to)
Indicate that the given columns should be renamed.
Fluent
dropPrimary(string|array $index = null)
Indicate that the given primary key should be dropped.
Fluent
dropUnique(string|array $index)
Indicate that the given unique key should be dropped.
Fluent
dropIndex(string|array $index)
Indicate that the given index should be dropped.
Fluent
dropForeign(string $index)
Indicate that the given foreign key should be dropped.
void
dropTimestamps()
Indicate that the timestamp columns should be dropped.
void
dropSoftDeletes()
Indicate that the soft delete column should be dropped.
Fluent
rename(string $to)
Rename the table to a given name.
Fluent
primary(string|array $columns, string $name = null)
Specify the primary key(s) for the table.
Fluent
unique(string|array $columns, string $name = null)
Specify a unique index for the table.
Fluent
index(string|array $columns, string $name = null)
Specify an index for the table.
Fluent
foreign(string|array $columns, string $name = null)
Specify a foreign key for the table.
Fluent
increments(string $column)
Create a new auto-incrementing integer column on the table.
Fluent
bigIncrements(string $column)
Create a new auto-incrementing big integer column on the table.
Fluent
char(string $column, int $length = 255)
Create a new char column on the table.
Fluent
string(string $column, int $length = 255)
Create a new string column on the table.
Fluent
text(string $column)
Create a new text column on the table.
Fluent
mediumText(string $column)
Create a new medium text column on the table.
Fluent
longText(string $column)
Create a new long text column on the table.
Fluent
integer(string $column, bool $autoIncrement = false, bool $unsigned = false)
Create a new integer column on the table.
Fluent
bigInteger(string $column, bool $autoIncrement = false, bool $unsigned = false)
Create a new big integer column on the table.
Fluent
mediumInteger(string $column, bool $autoIncrement = false, bool $unsigned = false)
Create a new medium integer column on the table.
Fluent
tinyInteger(string $column, bool $autoIncrement = false, bool $unsigned = false)
Create a new tiny integer column on the table.
Fluent
smallInteger(string $column, bool $autoIncrement = false, bool $unsigned = false)
Create a new small integer column on the table.
Fluent
unsignedInteger(string $column, bool $autoIncrement = false)
Create a new unsigned integer column on the table.
Fluent
unsignedBigInteger(string $column, bool $autoIncrement = false)
Create a new unsigned big integer column on the table.
Fluent
float(string $column, int $total = 8, int $places = 2)
Create a new float column on the table.
Fluent
double(string $column, int|null $total = null, int|null $places = null)
Create a new double column on the table.
Fluent
decimal(string $column, int $total = 8, int $places = 2)
Create a new decimal column on the table.
Fluent
boolean(string $column)
Create a new boolean column on the table.
Fluent
enum(string $column, array $allowed)
Create a new enum column on the table.
Fluent
date(string $column)
Create a new date column on the table.
Fluent
dateTime(string $column)
Create a new date-time column on the table.
Fluent
time(string $column)
Create a new time column on the table.
Fluent
timestamp(string $column)
Create a new timestamp column on the table.
void
nullableTimestamps()
Add nullable creation and update timestamps to the table.
void
timestamps()
Add creation and update timestamps to the table.
Fluent
softDeletes()
Add a "deleted at" timestamp for the table.
Fluent
binary(string $column)
Create a new binary column on the table.
void
morphs(string $name, string|null $indexName = null)
Add the proper columns for a polymorphic table.
Fluent
rememberToken()
Adds the remember_token column to the table.
protected Fluent
dropIndexCommand(string $command, string $type, string|array $index)
Create a new drop index command on the blueprint.
protected Fluent
indexCommand(string $type, string|array $columns, string $index)
Add a new index command to the blueprint.
protected string
createIndexName(string $type, array $columns)
Create a default index name for the table.
protected Fluent
addColumn(string $type, string $name, array $parameters = array())
Add a new column to the blueprint.
$this
removeColumn(string $name)
Remove a column from the schema blueprint.
protected Fluent
addCommand(string $name, array $parameters = array())
Add a new command to the blueprint.
protected Fluent
createCommand(string $name, array $parameters = array())
Create a new Fluent command.
string
getTable()
Get the table the blueprint describes.
array
getColumns()
Get the columns that should be added.
array
getCommands()
Get the commands on the blueprint.