Schema/Grammar.phpView Source

Show: PublicProtectedPrivateinherited
Table of Contents
Package
Default  

\ShSo\Lacassa\Schema\Grammar
jump to top

Package: Default
Parent(s)
\Illuminate\Database\Schema\Grammars\Grammar

Properties

>VPropertyprotectedarray $modifiers = array('VirtualAs', 'StoredAs', 'Unsigned', 'Charset', 'Collate', 'Nullable', 'Default', 'Increment', 'Comment', 'After', 'First')
The possible column modifiers.
Default valuearray('VirtualAs', 'StoredAs', 'Unsigned', 'Charset', 'Collate', 'Nullable', 'Default', 'Increment', 'Comment', 'After', 'First')Details
Type
array
>VPropertyprotectedarray $serials = array('bigInteger', 'integer', 'mediumInteger', 'smallInteger', 'tinyInteger')
The possible column serials.
Default valuearray('bigInteger', 'integer', 'mediumInteger', 'smallInteger', 'tinyInteger')Details
Type
array

Methods

methodpubliccompileAdd(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile an add column command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileColumnListing() : string

Compile the query to determine the list of columns.

Returns
TypeDescription
string
methodpubliccompileCreate(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command, \Illuminate\Database\Connection $connection) : string

Compile a create table command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
$connection\Illuminate\Database\Connection
Returns
TypeDescription
string
methodprotectedcompileCreateEncoding(string $sql, \Illuminate\Database\Connection $connection, \Illuminate\Database\Schema\Blueprint $blueprint) : string

Append the character set specifications to a command.

Parameters
NameTypeDescription
$sqlstring
$connection\Illuminate\Database\Connection
$blueprint\Illuminate\Database\Schema\Blueprint
Returns
TypeDescription
string
methodprotectedcompileCreateEngine(string $sql, \Illuminate\Database\Connection $connection, \Illuminate\Database\Schema\Blueprint $blueprint) : string

Append the engine specifications to a command.

Parameters
NameTypeDescription
$sqlstring
$connection\Illuminate\Database\Connection
$blueprint\Illuminate\Database\Schema\Blueprint
Returns
TypeDescription
string
methodprotectedcompileCreateTable(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command, \Illuminate\Database\Connection $connection) : string

Create the main create table clause.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
$connection\Illuminate\Database\Connection
Returns
TypeDescription
string
methodpubliccompileDisableForeignKeyConstraints() : string

Compile the command to disable foreign key constraints.

Returns
TypeDescription
string
methodpubliccompileDrop(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop table command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileDropColumn(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop column command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileDropForeign(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop foreign key command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileDropIfExists(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop table (if exists) command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileDropIndex(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop index command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileDropPrimary(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop primary key command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileDropUnique(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a drop unique key command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileEnableForeignKeyConstraints() : string

Compile the command to enable foreign key constraints.

Returns
TypeDescription
string
methodpubliccompileIndex(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a plain index key command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedcompileKey(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command, string $type) : string

Compile an index creation command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
$typestring
Returns
TypeDescription
string
methodpubliccompilePrimary(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a primary key command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileRename(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a rename table command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodpubliccompileTableExists() : string

Compile the query to determine the list of tables.

Returns
TypeDescription
string
methodpubliccompileUnique(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $command) : string

Compile a unique key command.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$command\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedgetColumns(\Illuminate\Database\Schema\Blueprint $blueprint) : array

Compile the blueprint's column definitions.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
Returns
TypeDescription
array
methodprotectedmodifyAfter(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for an "after" column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyCharset(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a character set column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyCollate(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a collation column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyComment(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a "comment" column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyDefault(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a default column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyFirst(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a "first" column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyIncrement(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for an auto-increment column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyNullable(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a nullable column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyStoredAs(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a generated stored column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyUnsigned(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for an unsigned column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedmodifyVirtualAs(\Illuminate\Database\Schema\Blueprint $blueprint, \Illuminate\Support\Fluent $column) : string | null

Get the SQL for a generated virtual column modifier.

Parameters
NameTypeDescription
$blueprint\Illuminate\Database\Schema\Blueprint
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string | null
methodprotectedtypeAscii(\Illuminate\Support\Fluent $column) : string

Create the column definition for a boolean type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeBigInteger(\Illuminate\Support\Fluent $column) : string

Create the column definition for a big integer type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeBigint(\Illuminate\Support\Fluent $column) : string

Create the column definition for a text type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeBinary(\Illuminate\Support\Fluent $column) : string

Create the column definition for a binary type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeBlob(\Illuminate\Support\Fluent $column) : string

Create the column definition for a blob type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeBoolean(\Illuminate\Support\Fluent $column) : string

Create the column definition for a boolean type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeChar(\Illuminate\Support\Fluent $column) : string

Create the column definition for a char type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeCounter(\Illuminate\Support\Fluent $column) : string

Create the column definition for a counter type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeDate(\Illuminate\Support\Fluent $column) : string

Create the column definition for a date type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeDateTime(\Illuminate\Support\Fluent $column) : string

Create the column definition for a date-time type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeDateTimeTz(\Illuminate\Support\Fluent $column) : string

Create the column definition for a date-time type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeDecimal(\Illuminate\Support\Fluent $column) : string

Create the column definition for a decimal type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeDouble(\Illuminate\Support\Fluent $column) : string

Create the column definition for a double type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeEnum(\Illuminate\Support\Fluent $column) : string

Create the column definition for an enum type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeFloat(\Illuminate\Support\Fluent $column) : string

Create the column definition for a float type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeFrozen(\Illuminate\Support\Fluent $column) : string

Create the column definition for a frozen type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeInet(\Illuminate\Support\Fluent $column) : string

Create the column definition for a inet type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeInt(\Illuminate\Support\Fluent $column) : string

Create the column definition for a int type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeInteger(\Illuminate\Support\Fluent $column) : string

Create the column definition for an integer type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeIpAddress(\Illuminate\Support\Fluent $column) : string

Create the column definition for an IP address type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeJson(\Illuminate\Support\Fluent $column) : string

Create the column definition for a json type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeJsonb(\Illuminate\Support\Fluent $column) : string

Create the column definition for a jsonb type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeList(\Illuminate\Support\Fluent $column) : string

Create the column definition for a list type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeLongText(\Illuminate\Support\Fluent $column) : string

Create the column definition for a long text type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeMacAddress(\Illuminate\Support\Fluent $column) : string

Create the column definition for a MAC address type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeMap(\Illuminate\Support\Fluent $column) : string

Create the column definition for a map type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeMediumInteger(\Illuminate\Support\Fluent $column) : string

Create the column definition for a medium integer type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeMediumText(\Illuminate\Support\Fluent $column) : string

Create the column definition for a medium text type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeSet(\Illuminate\Support\Fluent $column) : string

Create the column definition for a set type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeSmallInteger(\Illuminate\Support\Fluent $column) : string

Create the column definition for a small integer type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeString(\Illuminate\Support\Fluent $column) : string

Create the column definition for a string type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeText(\Illuminate\Support\Fluent $column) : string

Create the column definition for a text type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTime(\Illuminate\Support\Fluent $column) : string

Create the column definition for a time type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTimeTz(\Illuminate\Support\Fluent $column) : string

Create the column definition for a time type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTimestamp(\Illuminate\Support\Fluent $column) : string

Create the column definition for a timestamp type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTimestampTz(\Illuminate\Support\Fluent $column) : string

Create the column definition for a timestamp type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTimeuuid(\Illuminate\Support\Fluent $column) : string

Create the column definition for a timeuuid type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTinyInteger(\Illuminate\Support\Fluent $column) : string

Create the column definition for a tiny integer type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeTuple(\Illuminate\Support\Fluent $column) : string

Create the column definition for a tuple type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeUuid(\Illuminate\Support\Fluent $column) : string

Create the column definition for a uuid type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeVarchar(\Illuminate\Support\Fluent $column) : string

Create the column definition for a varchar type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedtypeVarint(\Illuminate\Support\Fluent $column) : string

Create the column definition for a varint type.

Parameters
NameTypeDescription
$column\Illuminate\Support\Fluent
Returns
TypeDescription
string
methodprotectedwrapValue(string $value) : string

Wrap a single string in keyword identifiers.

Parameters
NameTypeDescription
$valuestring
Returns
TypeDescription
string
Documentation was generated by phpDocumentor 2.9.0.