Table
class Table (View source)
Traits
Properties
| protected array | $custom_types | Define the query for create the custom type |
from PgsqlCompose |
Methods
Add tiny integer column
Add Medium integer column
Add small integer column
Change tiny integer column
Change Big integer column
Change Medium integer column
Change Small integer column
Change MEDIUMBLOB column
Change timestamp column
Add Foreign KEY constraints
Drop constraints column;
Table constructor
Generate the sql
Change a column in the table
Rename a column in the table
Drop table column
Set the engine
Get the engine
Set the collation
Get the collation
Set the charset
Get the charset
Get the define table name
Set the define table name
Set the adapter
Normalize the data type
Details
Table
addFloat(string $column, array $attribute = [])
Add float column
Table
addDouble(string $column, array $attribute = [])
Add double column
Table
addDoublePrimary(string $column)
Add double primary column
Table
addFloatPrimary(string $column)
Add float primary column
Table
addIncrement(string $column)
Add increment primary column
Table
addInteger(string $column, array $attribute = [])
Add integer column
Table
addIntegerPrimary(string $column)
Add integer primary column
Table
addBigIncrement(string $column)
Add big increment primary column
Table
addTinyInteger(string $column, array $attribute = [])
Add tiny integer column
Table
addBigInteger(string $column, array $attribute = [])
Add Big integer column
Table
addMediumInteger(string $column, array $attribute = [])
Add Medium integer column
Table
addMediumIncrement(string $column)
Add Medium integer column
Table
addSmallInteger(string $column, array $attribute = [])
Add small integer column
Table
addSmallIntegerIncrement(string $column)
Add Smallint integer column
Table
changeFloat(string $column, array $attribute = [])
Change float column
Table
changeDouble(string $column, array $attribute = [])
Change double column
Table
changeDoublePrimary(string $column)
Change double primary column
Table
changeFloatPrimary(string $column)
Change float primary column
Table
changeIncrement(string $column)
Change increment primary column
Table
changeInteger(string $column, array $attribute = [])
Change integer column
Table
changeIntegerPrimary(string $column)
Change integer primary column
Table
changeBigIncrement(string $column)
Change big increment primary column
Table
changeTinyInteger(string $column, array $attribute = [])
Change tiny integer column
Table
changeBigInteger(string $column, array $attribute = [])
Change Big integer column
Table
changeMediumInteger(string $column, array $attribute = [])
Change Medium integer column
Table
changeMediumIncrement(string $column)
Change Medium integer column
Table
changeSmallInteger(string $column, array $attribute = [])
Change Small integer column
Table
changeSmallIntegerPrimary(string $column)
Change Small integer column
Table
addBoolean(string $column, array $attribute = [])
Add BOOLEAN column
Table
addUuidPrimary(string $column, array $attribute = [])
Add UUID column
Table
addUuid(string $column, array $attribute = [])
Add UUID column
Table
addBinary(string $column, array $attribute = [])
Add BINARY column
Table
addTinyBlob(string $column, array $attribute = [])
Add TINYBLOB column
Table
addLongBlob(string $column, array $attribute = [])
Add LONGBLOB column
Table
addMediumBlob(string $column, array $attribute = [])
Add MEDIUMBLOB column
Table
addIpAddress(string $column, array $attribute = [])
Add ip column
Table
addMacAddress(string $column, array $attribute = [])
Add mac column
Table
addEnum(string $column, array $attribute = [])
Add enum column
Table
addCheck(string $column, array $attribute = [])
Add check column
Table
changeBoolean(string $column, array $attribute = [])
Change boolean column
Table
changeUuid(string $column, array $attribute = [])
Change UUID column
Table
changeBinary(string $column, array $attribute = [])
Change BLOB column
Table
changeLongBlob(string $column, array $attribute = [])
Change TINYBLOB column
Table
changeMediumBlob(string $column, array $attribute = [])
Change MEDIUMBLOB column
Table
changeTinyBlob(string $column, array $attribute = [])
Change TINYBLOB column
Table
changeIpAddress(string $column, array $attribute = [])
Change ip column
Table
changeMacAddress(string $column, array $attribute = [])
Change mac column
Table
changeEnum(string $column, array $attribute = [])
Change enum column
Table
changeCheck(string $column, array $attribute = [])
Change check column
Table
addString(string $column, array $attribute = [])
Add string column
Table
addJson(string $column, array $attribute = [])
Add json column
Table
addChar(string $column, array $attribute = [])
Add character column
Table
addLongtext(string $column, array $attribute = [])
Add longtext column
Table
addText(string $column, array $attribute = [])
Add text column
Table
addBlob(string $column, array $attribute = [])
Add blob column
Table
changeString(string $column, array $attribute = [])
Change string column
Table
changeJson(string $column, array $attribute = [])
Change json column
Table
changeChar(string $column, array $attribute = [])
Change character column
Table
changeLongtext(string $column, array $attribute = [])
Change longtext column
Table
changeText(string $column, array $attribute = [])
Change text column
Table
changeBlob(string $column, array $attribute = [])
Change blob column
Table
addDatetime(string $column, array $attribute = [])
Add datetime column
Table
addTimestamp(string $column, array $attribute = [])
Add timestamp column
Table
addDate(string $column, array $attribute = [])
Add date column
Table
addTime(string $column, array $attribute = [])
Add time column
Table
addYear(string $column, array $attribute = [])
Add year column
Table
addTimestamps()
Add default timestamps
Table
addSoftDelete()
Add default timestamps
Table
changeDatetime(string $column, array $attribute = [])
Change datetime column
Table
changeDate(string $column, array $attribute = [])
Change date column
Table
changeTime(string $column, array $attribute = [])
Change time column
Table
changeYear(string $column, array $attribute = [])
Change year column
Table
changeTimestamp(string $column, array $attribute = [])
Change timestamp column
Table
changeTimestamps()
Change default timestamps
Table
addForeign(string $name, array $attributes = [])
Add Foreign KEY constraints
Table
dropForeign(string|array $name, bool $as_raw = false)
Drop constraints column;
Table
addIndex(string $name)
Add table index;
Table
dropIndex(string $name)
Drop table index;
Table
dropPrimary()
Drop primary column;
Table
addUnique(string $name)
Add table unique;
Table
dropUnique(string $name)
Drop table unique;
array
getCustomTypeQueries()
Get the custom type for pgsql
__construct(string $table, string $adapter, string $scope)
Table constructor
string
make()
Generate the sql
Table
addRaw(string $definition)
Add a raw column definition
Table
addColumn(string $name, string $type, array $attribute = [])
Add new column in the table
Table
changeColumn(string $name, string $type, array $attribute = [])
Change a column in the table
Table
renameColumn(string $name, string $new)
Rename a column in the table
Table
dropColumn(string $name)
Drop table column
void
withEngine(string $engine)
Set the engine
string
getEngine()
Get the engine
void
withCollation(string $collation)
Set the collation
string
getCollation()
Get the collation
void
withCharset(string $charset)
Set the charset
string
getCharset()
Get the charset
string
getTable()
Get the define table name
string
setTable(string $table)
Set the define table name
Table
setScope(string $scope)
Set the scope
Table
setAdapter(string $adapter)
Set the adapter
string
normalizeOfType(string $type)
Normalize the data type