PHP download

Download the PHP package donatj/mysql-schema without Composer

On this page you can find all versions of the php package donatj/mysql-schema. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download donatj/mysql-schema
More information about donatj/mysql-schema
Files in donatj/mysql-schema

Vendor donatj
Package mysql-schema
Short Description Object Hierarchy Representing MySQL Schema
License MIT

Keywords mysql schema modeling

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of donatj/mysql-schema

Informations about the package mysql-schema

Simple PHP MySQL Schema Model

Requirements

php: >=5.4.0

Installing

Install the latest version with:

Documentation

Class: donatj\MySqlSchema\Columns\AbstractColumn

Method: AbstractColumn->__construct

Parameters:

string $name

Method: AbstractColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractColumn->getComment

Returns:

string

Method: AbstractColumn->setComment

Parameters:

string $comment

Returns:

void

Method: AbstractColumn->isNullable

Returns:

bool

Method: AbstractColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: AbstractColumn->getName

Returns:

string

Method: AbstractColumn->setName

Parameters:

string $name

Returns:

void

Method: AbstractColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractColumn->getTypeName

Returns:

string

Method: AbstractColumn->getDefault

Returns:

mixed

Method: AbstractColumn->setDefault

Parameters:

mixed $default

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\CharsetColumnInterface

Method: CharsetColumnInterface->getCharset

Returns:

null | string

Method: CharsetColumnInterface->setCharset

Parameters:

null | string $charset

Returns:

void

Method: CharsetColumnInterface->getCollation

Returns:

null | string

Method: CharsetColumnInterface->setCollation

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\DecimalPlacesInterface

Method: DecimalPlacesInterface->getDecimalPlaces

Returns:

int

Method: DecimalPlacesInterface->setDecimalPlaces

Parameters:

int $decimalPlaces

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\MaxDigitsInterface

Method: MaxDigitsInterface->getMaxDigits

Returns:

int

Method: MaxDigitsInterface->setMaxDigits

Parameters:

int $maxDigits

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\OptionalLengthInterface

Method: OptionalLengthInterface->getLength

Returns:

int | null

Method: OptionalLengthInterface->setLength

Parameters:

int | null $length

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\PrecisionInterface

Method: PrecisionInterface->getPrecision

Returns:

int

Method: PrecisionInterface->setPrecision

Parameters:

int $precision

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\RequiredLengthInterface

Method: RequiredLengthInterface->getLength

Returns:

int

Method: RequiredLengthInterface->setLength

Parameters:

int $length

Returns:

void

Class: donatj\MySqlSchema\Columns\Interfaces\SignedInterface

Method: SignedInterface->isSigned

Returns:

bool

Method: SignedInterface->setSigned

Parameters:

bool $signed

Returns:

void

Class: donatj\MySqlSchema\Columns\Json\JsonColumn

Method: JsonColumn->getTypeName

Returns:

string

Method: JsonColumn->__construct

Parameters:

string $name

Method: JsonColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: JsonColumn->getComment

Returns:

string

Method: JsonColumn->setComment

Parameters:

string $comment

Returns:

void

Method: JsonColumn->isNullable

Returns:

bool

Method: JsonColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: JsonColumn->getName

Returns:

string

Method: JsonColumn->setName

Parameters:

string $name

Returns:

void

Method: JsonColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: JsonColumn->getDefault

Returns:

mixed

Method: JsonColumn->setDefault

Parameters:

mixed $default

Returns:

void

Class: donatj\MySqlSchema\Columns\Numeric\AbstractFloatingColumn

Method: AbstractFloatingColumn->__construct

Parameters:

string $name
int $precision

Method: AbstractFloatingColumn->getPrecision

Returns:

int

Method: AbstractFloatingColumn->setPrecision

Parameters:

int $precision

Returns:

void

Method: AbstractFloatingColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractFloatingColumn->getComment

Returns:

string

Method: AbstractFloatingColumn->setComment

Parameters:

string $comment

Returns:

void

Method: AbstractFloatingColumn->isNullable

Returns:

bool

Method: AbstractFloatingColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: AbstractFloatingColumn->getName

Returns:

string

Method: AbstractFloatingColumn->setName

Parameters:

string $name

Returns:

void

Method: AbstractFloatingColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractFloatingColumn->getTypeName

Returns:

string

Method: AbstractFloatingColumn->getDefault

Returns:

mixed

Method: AbstractFloatingColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: AbstractFloatingColumn->isSigned

Returns:

bool

Method: AbstractFloatingColumn->setSigned

Parameters:

bool $signed

Class: donatj\MySqlSchema\Columns\Numeric\AbstractIntegerColumn

Method: AbstractIntegerColumn->__construct

Parameters:

string $name

Method: AbstractIntegerColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractIntegerColumn->getComment

Returns:

string

Method: AbstractIntegerColumn->setComment

Parameters:

string $comment

Returns:

void

Method: AbstractIntegerColumn->isNullable

Returns:

bool

Method: AbstractIntegerColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: AbstractIntegerColumn->getName

Returns:

string

Method: AbstractIntegerColumn->setName

Parameters:

string $name

Returns:

void

Method: AbstractIntegerColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractIntegerColumn->getTypeName

Returns:

string

Method: AbstractIntegerColumn->getDefault

Returns:

mixed

Method: AbstractIntegerColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: AbstractIntegerColumn->isSigned

Returns:

bool

Method: AbstractIntegerColumn->setSigned

Parameters:

bool $signed

Method: AbstractIntegerColumn->getLength

Returns:

int | null

Method: AbstractIntegerColumn->setLength

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\Numeric\AbstractNumberColumn

Method: AbstractNumberColumn->__construct

Parameters:

string $name

Method: AbstractNumberColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractNumberColumn->getComment

Returns:

string

Method: AbstractNumberColumn->setComment

Parameters:

string $comment

Returns:

void

Method: AbstractNumberColumn->isNullable

Returns:

bool

Method: AbstractNumberColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: AbstractNumberColumn->getName

Returns:

string

Method: AbstractNumberColumn->setName

Parameters:

string $name

Returns:

void

Method: AbstractNumberColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractNumberColumn->getTypeName

Returns:

string

Method: AbstractNumberColumn->getDefault

Returns:

mixed

Method: AbstractNumberColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: AbstractNumberColumn->isSigned

Returns:

bool

Method: AbstractNumberColumn->setSigned

Parameters:

bool $signed

Class: donatj\MySqlSchema\Columns\Numeric\FixedPoint\DecimalColumn

Method: DecimalColumn->__construct

Parameters:

string $name
int $maxDigits
int $decimalPlaces

Method: DecimalColumn->getTypeName

Returns:

string

Method: DecimalColumn->getMaxDigits

Returns:

int

Method: DecimalColumn->setMaxDigits

Parameters:

int $maxDigits

Returns:

void

Method: DecimalColumn->getDecimalPlaces

Returns:

int

Method: DecimalColumn->setDecimalPlaces

Parameters:

int $decimalPlaces

Returns:

void

Method: DecimalColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: DecimalColumn->getComment

Returns:

string

Method: DecimalColumn->setComment

Parameters:

string $comment

Returns:

void

Method: DecimalColumn->isNullable

Returns:

bool

Method: DecimalColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: DecimalColumn->getName

Returns:

string

Method: DecimalColumn->setName

Parameters:

string $name

Returns:

void

Method: DecimalColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: DecimalColumn->getDefault

Returns:

mixed

Method: DecimalColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: DecimalColumn->isSigned

Returns:

bool

Method: DecimalColumn->setSigned

Parameters:

bool $signed

Class: donatj\MySqlSchema\Columns\Numeric\FloatingPoint\DoubleColumn

Method: DoubleColumn->getTypeName

Returns:

string

Method: DoubleColumn->__construct

Parameters:

string $name
int $precision

Method: DoubleColumn->getPrecision

Returns:

int

Method: DoubleColumn->setPrecision

Parameters:

int $precision

Returns:

void

Method: DoubleColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: DoubleColumn->getComment

Returns:

string

Method: DoubleColumn->setComment

Parameters:

string $comment

Returns:

void

Method: DoubleColumn->isNullable

Returns:

bool

Method: DoubleColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: DoubleColumn->getName

Returns:

string

Method: DoubleColumn->setName

Parameters:

string $name

Returns:

void

Method: DoubleColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: DoubleColumn->getDefault

Returns:

mixed

Method: DoubleColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: DoubleColumn->isSigned

Returns:

bool

Method: DoubleColumn->setSigned

Parameters:

bool $signed

Class: donatj\MySqlSchema\Columns\Numeric\FloatingPoint\FloatColumn

Method: FloatColumn->getTypeName

Returns:

string

Method: FloatColumn->__construct

Parameters:

string $name
int $precision

Method: FloatColumn->getPrecision

Returns:

int

Method: FloatColumn->setPrecision

Parameters:

int $precision

Returns:

void

Method: FloatColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: FloatColumn->getComment

Returns:

string

Method: FloatColumn->setComment

Parameters:

string $comment

Returns:

void

Method: FloatColumn->isNullable

Returns:

bool

Method: FloatColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: FloatColumn->getName

Returns:

string

Method: FloatColumn->setName

Parameters:

string $name

Returns:

void

Method: FloatColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: FloatColumn->getDefault

Returns:

mixed

Method: FloatColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: FloatColumn->isSigned

Returns:

bool

Method: FloatColumn->setSigned

Parameters:

bool $signed

Class: donatj\MySqlSchema\Columns\Numeric\Integers\BigIntColumn

Method: BigIntColumn->getTypeName

Returns:

string

Method: BigIntColumn->__construct

Parameters:

string $name

Method: BigIntColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: BigIntColumn->getComment

Returns:

string

Method: BigIntColumn->setComment

Parameters:

string $comment

Returns:

void

Method: BigIntColumn->isNullable

Returns:

bool

Method: BigIntColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: BigIntColumn->getName

Returns:

string

Method: BigIntColumn->setName

Parameters:

string $name

Returns:

void

Method: BigIntColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: BigIntColumn->getDefault

Returns:

mixed

Method: BigIntColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: BigIntColumn->isSigned

Returns:

bool

Method: BigIntColumn->setSigned

Parameters:

bool $signed

Method: BigIntColumn->getLength

Returns:

int | null

Method: BigIntColumn->setLength

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\Numeric\Integers\IntColumn

Method: IntColumn->getTypeName

Returns:

string

Method: IntColumn->__construct

Parameters:

string $name

Method: IntColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: IntColumn->getComment

Returns:

string

Method: IntColumn->setComment

Parameters:

string $comment

Returns:

void

Method: IntColumn->isNullable

Returns:

bool

Method: IntColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: IntColumn->getName

Returns:

string

Method: IntColumn->setName

Parameters:

string $name

Returns:

void

Method: IntColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: IntColumn->getDefault

Returns:

mixed

Method: IntColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: IntColumn->isSigned

Returns:

bool

Method: IntColumn->setSigned

Parameters:

bool $signed

Method: IntColumn->getLength

Returns:

int | null

Method: IntColumn->setLength

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\Numeric\Integers\MediumIntColumn

Method: MediumIntColumn->getTypeName

Returns:

string

Method: MediumIntColumn->__construct

Parameters:

string $name

Method: MediumIntColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: MediumIntColumn->getComment

Returns:

string

Method: MediumIntColumn->setComment

Parameters:

string $comment

Returns:

void

Method: MediumIntColumn->isNullable

Returns:

bool

Method: MediumIntColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: MediumIntColumn->getName

Returns:

string

Method: MediumIntColumn->setName

Parameters:

string $name

Returns:

void

Method: MediumIntColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: MediumIntColumn->getDefault

Returns:

mixed

Method: MediumIntColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: MediumIntColumn->isSigned

Returns:

bool

Method: MediumIntColumn->setSigned

Parameters:

bool $signed

Method: MediumIntColumn->getLength

Returns:

int | null

Method: MediumIntColumn->setLength

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\Numeric\Integers\SmallIntColumn

Method: SmallIntColumn->getTypeName

Returns:

string

Method: SmallIntColumn->__construct

Parameters:

string $name

Method: SmallIntColumn->getTables

Returns:

\donatj\MySqlSchema\Table[]

Method: SmallIntColumn->getComment

Returns:

string

Method: SmallIntColumn->setComment

Parameters:

string $comment

Returns:

void

Method: SmallIntColumn->isNullable

Returns:

bool

Method: SmallIntColumn->setNullable

Parameters:

bool $nullable

Returns:

void

Method: SmallIntColumn->getName

Returns:

string

Method: SmallIntColumn->setName

Parameters:

string $name

Returns:

void

Method: SmallIntColumn->toString

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: SmallIntColumn->getDefault

Returns:

mixed

Method: SmallIntColumn->setDefault

Parameters:

mixed $default

Returns:

void

Method: SmallIntColumn->isSigned

Returns:

bool

Method: SmallIntColumn->setSigned

Parameters:

bool $signed

Method: SmallIntColumn->getLength

Returns:

int | null

Method: SmallIntColumn->setLength

function setLength([ $length = null])

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\Numeric\Integers\TinyIntColumn

Method: TinyIntColumn->getTypeName

function getTypeName()

Returns:

string

Method: TinyIntColumn->__construct

function __construct($name)

Parameters:

string $name

Method: TinyIntColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: TinyIntColumn->getComment

function getComment()

Returns:

string

Method: TinyIntColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: TinyIntColumn->isNullable

function isNullable()

Returns:

bool

Method: TinyIntColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: TinyIntColumn->getName

function getName()

Returns:

string

Method: TinyIntColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: TinyIntColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: TinyIntColumn->getDefault

function getDefault()

Returns:

mixed

Method: TinyIntColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: TinyIntColumn->isSigned

function isSigned()

Returns:

bool

Method: TinyIntColumn->setSigned

function setSigned($signed)

Parameters:

bool $signed

Method: TinyIntColumn->getLength

function getLength()

Returns:

int | null

Method: TinyIntColumn->setLength

function setLength([ $length = null])

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\String\AbstractCharacterColumn

Method: AbstractCharacterColumn->__construct

function __construct($name, $length)

Parameters:

string $name
int $length

Method: AbstractCharacterColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractCharacterColumn->getComment

function getComment()

Returns:

string

Method: AbstractCharacterColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: AbstractCharacterColumn->isNullable

function isNullable()

Returns:

bool

Method: AbstractCharacterColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: AbstractCharacterColumn->getName

function getName()

Returns:

string

Method: AbstractCharacterColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: AbstractCharacterColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractCharacterColumn->getTypeName

function getTypeName()

Returns:

string

Method: AbstractCharacterColumn->getDefault

function getDefault()

Returns:

mixed

Method: AbstractCharacterColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: AbstractCharacterColumn->getCharset

function getCharset()

Returns:

null | string

Method: AbstractCharacterColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: AbstractCharacterColumn->getCollation

function getCollation()

Returns:

null | string

Method: AbstractCharacterColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Method: AbstractCharacterColumn->getLength

function getLength()

Returns:

int

Method: AbstractCharacterColumn->setLength

function setLength($length)

Parameters:

int $length

Class: donatj\MySqlSchema\Columns\String\AbstractStringColumn

Method: AbstractStringColumn->__construct

function __construct($name)

Parameters:

string $name

Method: AbstractStringColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractStringColumn->getComment

function getComment()

Returns:

string

Method: AbstractStringColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: AbstractStringColumn->isNullable

function isNullable()

Returns:

bool

Method: AbstractStringColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: AbstractStringColumn->getName

function getName()

Returns:

string

Method: AbstractStringColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: AbstractStringColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractStringColumn->getTypeName

function getTypeName()

Returns:

string

Method: AbstractStringColumn->getDefault

function getDefault()

Returns:

mixed

Method: AbstractStringColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: AbstractStringColumn->getCharset

function getCharset()

Returns:

null | string

Method: AbstractStringColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: AbstractStringColumn->getCollation

function getCollation()

Returns:

null | string

Method: AbstractStringColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\String\AbstractTextColumn

Method: AbstractTextColumn->__construct

function __construct($name)

Parameters:

string $name

Method: AbstractTextColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractTextColumn->getComment

function getComment()

Returns:

string

Method: AbstractTextColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: AbstractTextColumn->isNullable

function isNullable()

Returns:

bool

Method: AbstractTextColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: AbstractTextColumn->getName

function getName()

Returns:

string

Method: AbstractTextColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: AbstractTextColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractTextColumn->getTypeName

function getTypeName()

Returns:

string

Method: AbstractTextColumn->getDefault

function getDefault()

Returns:

mixed

Method: AbstractTextColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: AbstractTextColumn->getCharset

function getCharset()

Returns:

null | string

Method: AbstractTextColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: AbstractTextColumn->getCollation

function getCollation()

Returns:

null | string

Method: AbstractTextColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\String\Character\CharColumn

Method: CharColumn->getTypeName

function getTypeName()

Returns:

string

Method: CharColumn->__construct

function __construct($name, $length)

Parameters:

string $name
int $length

Method: CharColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: CharColumn->getComment

function getComment()

Returns:

string

Method: CharColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: CharColumn->isNullable

function isNullable()

Returns:

bool

Method: CharColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: CharColumn->getName

function getName()

Returns:

string

Method: CharColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: CharColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: CharColumn->getDefault

function getDefault()

Returns:

mixed

Method: CharColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: CharColumn->getCharset

function getCharset()

Returns:

null | string

Method: CharColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: CharColumn->getCollation

function getCollation()

Returns:

null | string

Method: CharColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Method: CharColumn->getLength

function getLength()

Returns:

int

Method: CharColumn->setLength

function setLength($length)

Parameters:

int $length

Class: donatj\MySqlSchema\Columns\String\Character\VarcharColumn

Method: VarcharColumn->getTypeName

function getTypeName()

Returns:

string

Method: VarcharColumn->__construct

function __construct($name, $length)

Parameters:

string $name
int $length

Method: VarcharColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: VarcharColumn->getComment

function getComment()

Returns:

string

Method: VarcharColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: VarcharColumn->isNullable

function isNullable()

Returns:

bool

Method: VarcharColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: VarcharColumn->getName

function getName()

Returns:

string

Method: VarcharColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: VarcharColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: VarcharColumn->getDefault

function getDefault()

Returns:

mixed

Method: VarcharColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: VarcharColumn->getCharset

function getCharset()

Returns:

null | string

Method: VarcharColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: VarcharColumn->getCollation

function getCollation()

Returns:

null | string

Method: VarcharColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Method: VarcharColumn->getLength

function getLength()

Returns:

int

Method: VarcharColumn->setLength

function setLength($length)

Parameters:

int $length

Class: donatj\MySqlSchema\Columns\String\Text\LongTextColumn

Method: LongTextColumn->getTypeName

function getTypeName()

Returns:

string

Method: LongTextColumn->__construct

function __construct($name)

Parameters:

string $name

Method: LongTextColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: LongTextColumn->getComment

function getComment()

Returns:

string

Method: LongTextColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: LongTextColumn->isNullable

function isNullable()

Returns:

bool

Method: LongTextColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: LongTextColumn->getName

function getName()

Returns:

string

Method: LongTextColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: LongTextColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: LongTextColumn->getDefault

function getDefault()

Returns:

mixed

Method: LongTextColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: LongTextColumn->getCharset

function getCharset()

Returns:

null | string

Method: LongTextColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: LongTextColumn->getCollation

function getCollation()

Returns:

null | string

Method: LongTextColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\String\Text\MediumTextColumn

Method: MediumTextColumn->getTypeName

function getTypeName()

Returns:

string

Method: MediumTextColumn->__construct

function __construct($name)

Parameters:

string $name

Method: MediumTextColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: MediumTextColumn->getComment

function getComment()

Returns:

string

Method: MediumTextColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: MediumTextColumn->isNullable

function isNullable()

Returns:

bool

Method: MediumTextColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: MediumTextColumn->getName

function getName()

Returns:

string

Method: MediumTextColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: MediumTextColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: MediumTextColumn->getDefault

function getDefault()

Returns:

mixed

Method: MediumTextColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: MediumTextColumn->getCharset

function getCharset()

Returns:

null | string

Method: MediumTextColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: MediumTextColumn->getCollation

function getCollation()

Returns:

null | string

Method: MediumTextColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\String\Text\TextColumn

Method: TextColumn->getTypeName

function getTypeName()

Returns:

string

Method: TextColumn->__construct

function __construct($name)

Parameters:

string $name

Method: TextColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: TextColumn->getComment

function getComment()

Returns:

string

Method: TextColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: TextColumn->isNullable

function isNullable()

Returns:

bool

Method: TextColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: TextColumn->getName

function getName()

Returns:

string

Method: TextColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: TextColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: TextColumn->getDefault

function getDefault()

Returns:

mixed

Method: TextColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: TextColumn->getCharset

function getCharset()

Returns:

null | string

Method: TextColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: TextColumn->getCollation

function getCollation()

Returns:

null | string

Method: TextColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\String\Text\TinyTextColumn

Method: TinyTextColumn->getTypeName

function getTypeName()

Returns:

string

Method: TinyTextColumn->__construct

function __construct($name)

Parameters:

string $name

Method: TinyTextColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: TinyTextColumn->getComment

function getComment()

Returns:

string

Method: TinyTextColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: TinyTextColumn->isNullable

function isNullable()

Returns:

bool

Method: TinyTextColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: TinyTextColumn->getName

function getName()

Returns:

string

Method: TinyTextColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: TinyTextColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: TinyTextColumn->getDefault

function getDefault()

Returns:

mixed

Method: TinyTextColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: TinyTextColumn->getCharset

function getCharset()

Returns:

null | string

Method: TinyTextColumn->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: TinyTextColumn->getCollation

function getCollation()

Returns:

null | string

Method: TinyTextColumn->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Columns\Temporal\AbstractTemporalColumn

Method: AbstractTemporalColumn->__construct

function __construct($name)

Parameters:

string $name

Method: AbstractTemporalColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: AbstractTemporalColumn->getComment

function getComment()

Returns:

string

Method: AbstractTemporalColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: AbstractTemporalColumn->isNullable

function isNullable()

Returns:

bool

Method: AbstractTemporalColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: AbstractTemporalColumn->getName

function getName()

Returns:

string

Method: AbstractTemporalColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: AbstractTemporalColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: AbstractTemporalColumn->getTypeName

function getTypeName()

Returns:

string

Method: AbstractTemporalColumn->getDefault

function getDefault()

Returns:

mixed

Method: AbstractTemporalColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Class: donatj\MySqlSchema\Columns\Temporal\DateTimeColumn

Method: DateTimeColumn->getTypeName

function getTypeName()

Returns:

string

Method: DateTimeColumn->__construct

function __construct($name)

Parameters:

string $name

Method: DateTimeColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: DateTimeColumn->getComment

function getComment()

Returns:

string

Method: DateTimeColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: DateTimeColumn->isNullable

function isNullable()

Returns:

bool

Method: DateTimeColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: DateTimeColumn->getName

function getName()

Returns:

string

Method: DateTimeColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: DateTimeColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: DateTimeColumn->getDefault

function getDefault()

Returns:

mixed

Method: DateTimeColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Class: donatj\MySqlSchema\Columns\Temporal\TimeColumn

Method: TimeColumn->getTypeName

function getTypeName()

Returns:

string

Method: TimeColumn->__construct

function __construct($name)

Parameters:

string $name

Method: TimeColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: TimeColumn->getComment

function getComment()

Returns:

string

Method: TimeColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: TimeColumn->isNullable

function isNullable()

Returns:

bool

Method: TimeColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: TimeColumn->getName

function getName()

Returns:

string

Method: TimeColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: TimeColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: TimeColumn->getDefault

function getDefault()

Returns:

mixed

Method: TimeColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Class: donatj\MySqlSchema\Columns\Temporal\TimestampColumn

Method: TimestampColumn->getTypeName

function getTypeName()

Returns:

string

Method: TimestampColumn->__construct

function __construct($name)

Parameters:

string $name

Method: TimestampColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: TimestampColumn->getComment

function getComment()

Returns:

string

Method: TimestampColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: TimestampColumn->isNullable

function isNullable()

Returns:

bool

Method: TimestampColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: TimestampColumn->getName

function getName()

Returns:

string

Method: TimestampColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: TimestampColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: TimestampColumn->getDefault

function getDefault()

Returns:

mixed

Method: TimestampColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Class: donatj\MySqlSchema\Columns\Temporal\YearColumn

Method: YearColumn->__construct

function __construct($name [, $length = 4])

Parameters:

string $name
int $length - 2 or 4

Method: YearColumn->setLength

function setLength($length)

Parameters:

int $length - 2 or 4

Throws: \InvalidArgumentException

Returns:

void

Method: YearColumn->getTypeName

function getTypeName()

Returns:

string

Method: YearColumn->getTables

function getTables()

Returns:

\donatj\MySqlSchema\Table[]

Method: YearColumn->getComment

function getComment()

Returns:

string

Method: YearColumn->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: YearColumn->isNullable

function isNullable()

Returns:

bool

Method: YearColumn->setNullable

function setNullable($nullable)

Parameters:

bool $nullable

Returns:

void

Method: YearColumn->getName

function getName()

Returns:

string

Method: YearColumn->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: YearColumn->toString

function toString(\donatj\MySqlSchema\Table $table)

Parameters:

\donatj\MySqlSchema\Table $table

Returns:

string

Method: YearColumn->getDefault

function getDefault()

Returns:

mixed

Method: YearColumn->setDefault

function setDefault($default)

Parameters:

mixed $default

Returns:

void

Method: YearColumn->getLength

function getLength()

Returns:

int

Class: donatj\MySqlSchema\Columns\Traits\OptionalLengthTrait

Method: OptionalLengthTrait->getLength

function getLength()

Returns:

int | null

Method: OptionalLengthTrait->setLength

function setLength([ $length = null])

Parameters:

int | null $length

Class: donatj\MySqlSchema\Columns\Traits\RequiredLengthTrait

Method: RequiredLengthTrait->getLength

function getLength()

Returns:

int

Method: RequiredLengthTrait->setLength

function setLength($length)

Parameters:

int $length

Class: donatj\MySqlSchema\Columns\Traits\SignedTrait

Method: SignedTrait->isSigned

function isSigned()

Returns:

bool

Method: SignedTrait->setSigned

function setSigned($signed)

Parameters:

bool $signed

Class: donatj\MySqlSchema\Table

Method: Table->__construct

function __construct($name)

Table constructor.

Parameters:

string $name

Method: Table->getColumns

function getColumns()

Returns:

\donatj\MySqlSchema\Columns\AbstractColumn[]

Method: Table->getComment

function getComment()

Returns:

string

Method: Table->setComment

function setComment($comment)

Parameters:

string $comment

Returns:

void

Method: Table->getEngine

function getEngine()

Returns:

null | string

Method: Table->setEngine

function setEngine($engine)

Parameters:

null | string $engine

Returns:

void

Method: Table->getName

function getName()

Returns:

string

Method: Table->setName

function setName($name)

Parameters:

string $name

Returns:

void

Method: Table->addAutoIncrement

function addAutoIncrement(\donatj\MySqlSchema\Columns\Numeric\AbstractIntegerColumn $column)

Returns:

void

Method: Table->isAutoIncrement

function isAutoIncrement(\donatj\MySqlSchema\Columns\Numeric\AbstractIntegerColumn $column)

Parameters:

\donatj\MySqlSchema\Columns\Numeric\AbstractIntegerColumn $column

Returns:

bool

Method: Table->addPrimaryKey

function addPrimaryKey(\donatj\MySqlSchema\Columns\AbstractColumn $column)

Returns:

void

Method: Table->isPrimaryKey

function isPrimaryKey(\donatj\MySqlSchema\Columns\AbstractColumn $column)

Parameters:

\donatj\MySqlSchema\Columns\AbstractColumn $column

Returns:

bool

Method: Table->addKeyColumn

function addKeyColumn($keyName, \donatj\MySqlSchema\Columns\AbstractColumn $column [, $index = null [, $type = 'NORMAL' [, $method = '']]])

Parameters:

string $keyName
\donatj\MySqlSchema\Columns\AbstractColumn $column
int | null $index
string $type
string $method

Returns:

void

Method: Table->addForeignKey

function addForeignKey(\donatj\MySqlSchema\Columns\AbstractColumn $local, \donatj\MySqlSchema\Columns\AbstractColumn $remote)

Returns:

void

Method: Table->addColumn

function addColumn(\donatj\MySqlSchema\Columns\AbstractColumn $column)

Returns:

void

Method: Table->toString

function toString()

Returns:

string

Method: Table->getCharset

function getCharset()

Returns:

null | string

Method: Table->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: Table->getCollation

function getCollation()

Returns:

null | string

Method: Table->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Traits\CharsetAndCollationTrait

Method: CharsetAndCollationTrait->getCharset

function getCharset()

Returns:

null | string

Method: CharsetAndCollationTrait->setCharset

function setCharset($charset)

Parameters:

null | string $charset

Returns:

void

Method: CharsetAndCollationTrait->getCollation

function getCollation()

Returns:

null | string

Method: CharsetAndCollationTrait->setCollation

function setCollation($collation)

Parameters:

null | string $collation

Returns:

void

Class: donatj\MySqlSchema\Traits\EscapeTrait

All versions of mysql-schema with dependencies

PHP Build Version

Package Version

Version v0.3.0 Release 11. Nov 2024
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of mysql-schema from vendor donatj

Requires php Version >=5.4.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package donatj/mysql-schema contains the following files

Loading the files please wait ....

Download the PHP package donatj/mysql-schema without Composer

FAQ

How can I use the PHP package after the download?

Do I need to create a project on this site?

When is it necessary to insert some auth.json content?

What is the advantage to use this site for my Composer projects?

Informations about the package mysql-schema

Simple PHP MySQL Schema Model

Requirements

Installing

Documentation

Class: donatj\MySqlSchema\Columns\AbstractColumn

Method: AbstractColumn->__construct

Parameters:

Method: AbstractColumn->getTables

Returns:

Method: AbstractColumn->getComment

Returns:

Method: AbstractColumn->setComment

Parameters:

Returns:

Method: AbstractColumn->isNullable

Returns:

Method: AbstractColumn->setNullable

Parameters:

Returns:

Method: AbstractColumn->getName

Returns:

Method: AbstractColumn->setName

Parameters:

Returns:

Method: AbstractColumn->toString

Parameters:

Returns:

Method: AbstractColumn->getTypeName

Returns:

Method: AbstractColumn->getDefault

Returns:

Method: AbstractColumn->setDefault

Parameters:

Returns:

Class: donatj\MySqlSchema\Columns\Interfaces\CharsetColumnInterface

Method: CharsetColumnInterface->getCharset

Returns:

Method: CharsetColumnInterface->setCharset

Parameters:

Returns:

Method: CharsetColumnInterface->getCollation

Returns:

Method: CharsetColumnInterface->setCollation

Parameters:

Returns:

Class: donatj\MySqlSchema\Columns\Interfaces\DecimalPlacesInterface

Method: DecimalPlacesInterface->getDecimalPlaces

Returns:

Method: DecimalPlacesInterface->setDecimalPlaces

Parameters:

Returns:

Class: donatj\MySqlSchema\Columns\Interfaces\MaxDigitsInterface

Method: MaxDigitsInterface->getMaxDigits

Returns:

Method: MaxDigitsInterface->setMaxDigits

Parameters:

Returns:

Class: donatj\MySqlSchema\Columns\Interfaces\OptionalLengthInterface

Method: OptionalLengthInterface->getLength

Returns:

Method: OptionalLengthInterface->setLength

Parameters:

Returns:

Class: donatj\MySqlSchema\Columns\Interfaces\PrecisionInterface

Method: PrecisionInterface->getPrecision

Returns:

Method: PrecisionInterface->setPrecision

Parameters:

Returns:

Class: donatj\MySqlSchema\Columns\Interfaces\RequiredLengthInterface

Method: RequiredLengthInterface->getLength

Returns:

Method: RequiredLengthInterface->setLength