Class Doctrine\DBAL\Schema\MySQLSchemaManager

`extends`	`AbstractSchemaManager<AbstractMySQLPlatform>`

Schema manager for the MySQL RDBMS.

Doctrine\DBAL\Schema\AbstractSchemaManager
- Doctrine\DBAL\Schema\MySQLSchemaManager

Methods


					
	public

listTableNames()

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::listTableNames()


					
	public

listTables()

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::listTables()


					
	public

listTableDetails($name)

{@inheritDoc}

Deprecated

Use {@see introspectTable()} instead.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::listTableDetails()


					
	public

listTableColumns($table, $database = null)

{@inheritDoc}

Parameters

$table

The name of the table.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::listTableColumns()


					
	public

listTableIndexes($table)

{@inheritDoc}

Parameters

$table

The name of the table.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::listTableIndexes()


					
	public

listTableForeignKeys($table, $database = null)

{@inheritDoc}

Parameters

$table

The name of the table.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::listTableForeignKeys()


					
	protected

_getPortableViewDefinition($view)

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableViewDefinition()


					
	protected

_getPortableTableDefinition($table)

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableTableDefinition()


					
	protected

_getPortableTableIndexesList($tableIndexes, $tableName = null)

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableTableIndexesList()


					
	protected

_getPortableDatabaseDefinition($database)

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableDatabaseDefinition()


					
	protected

_getPortableTableColumnDefinition($tableColumn)

{@inheritDoc}

Implements

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableTableColumnDefinition()


					
	private

expectedDbType(string $type, mixed[] $tableColumn): string

Returns the database data type for a given doctrine type and column

Note that for data types that depend on length where length is not part of the column definition and therefore the $tableColumn['length'] will not be set, for example TEXT (which could be LONGTEXT, MEDIUMTEXT) or BLOB (LONGBLOB or TINYBLOB), the expectedDbType cannot be inferred exactly, merely the default type.

This method is intended to be used to determine underlying database type where doctrine type is inferred from a DC2Type comment.


					
	private

getMariaDb1027ColumnDefault(MariaDb1027Platform $platform, string|null $columnDefault): ?string

Return Doctrine/Mysql-compatible column default values for MariaDB 10.2.7+ servers.

Since MariaDb 10.2.7 column defaults stored in information_schema are now quoted to distinguish them from expressions (see MDEV-10134).
CURRENT_TIMESTAMP, CURRENT_TIME, CURRENT_DATE are stored in information_schema as current_timestamp(), currdate(), currtime()
Quoted 'NULL' is not enforced by Maria, it is technically possible to have null in some circumstances (see https://jira.mariadb.org/browse/MDEV-14053)
' is always stored as '' in information_schema (normalized)

Parameters

$columnDefault

default value as stored in information_schema for MariaDB >= 10.2.7


					
	protected

_getPortableTableForeignKeysList($tableForeignKeys)

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableTableForeignKeysList()


					
	protected

_getPortableTableForeignKeyDefinition($tableForeignKey): ForeignKeyConstraint

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableTableForeignKeyDefinition()


					
	public

createComparator(): Comparator

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::createComparator()


					
	protected

selectTableNames(string $databaseName): Result

Selects names of tables in the specified database.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::selectTableNames()


					
	protected

selectTableColumns(string $databaseName, ?string $tableName = null): Result

Selects definitions of table columns in the specified database. If the table name is specified, narrows down the…

Selects definitions of table columns in the specified database. If the table name is specified, narrows down the selection to this table.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::selectTableColumns()


					
	protected

selectIndexColumns(string $databaseName, ?string $tableName = null): Result

Selects definitions of index columns in the specified database. If the table name is specified, narrows down the…

Selects definitions of index columns in the specified database. If the table name is specified, narrows down the selection to this table.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::selectIndexColumns()


					
	protected

selectForeignKeyColumns(string $databaseName, ?string $tableName = null): Result

Selects definitions of foreign key columns in the specified database. If the table name is specified, narrows down the…

Selects definitions of foreign key columns in the specified database. If the table name is specified, narrows down the selection to this table.

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::selectForeignKeyColumns()


					
	protected

fetchTableOptionsByTable(string $databaseName, ?string $tableName = null): array

{@inheritDoc}

Overrides

Doctrine\DBAL\Schema\AbstractSchemaManager::fetchTableOptionsByTable()


					
	private

parseCreateOptions(?string $string): string[]|true[]

Methods inherited from Doctrine\DBAL\Schema\AbstractSchemaManager
__construct(), getDatabasePlatform(), tryMethod(), listDatabases(), listNamespaceNames(), listSchemaNames(), listSequences(), doListTableColumns(), doListTableIndexes(), tablesExist(), doListTableNames(), filterAssetNames(), doListTables(), doListTableDetails(), normalizeName(), fetchTableColumnsByTable(), fetchIndexColumnsByTable(), fetchForeignKeyColumnsByTable(), introspectTable(), listViews(), doListTableForeignKeys(), dropDatabase(), dropSchema(), dropTable(), dropIndex(), dropConstraint(), dropForeignKey(), dropSequence(), dropUniqueConstraint(), dropView(), createSchemaObjects(), createDatabase(), createTable(), createSequence(), createConstraint(), createIndex(), createForeignKey(), createUniqueConstraint(), createView(), dropSchemaObjects(), dropAndCreateConstraint(), dropAndCreateIndex(), dropAndCreateForeignKey(), dropAndCreateSequence(), dropAndCreateTable(), dropAndCreateDatabase(), dropAndCreateView(), alterSchema(), migrateSchema(), alterTable(), renameTable(), _getPortableDatabasesList(), getPortableNamespacesList(), getPortableNamespaceDefinition(), _getPortableSequencesList(), _getPortableSequenceDefinition(), _getPortableTableColumnList(), _getPortableTablesList(), _getPortableViewsList(), createSchema(), introspectSchema(), createSchemaConfig(), getSchemaSearchPaths(),

Methods inherited from Doctrine\DBAL\Schema\AbstractSchemaManager

__construct(), getDatabasePlatform(), tryMethod(), listDatabases(), listNamespaceNames(), listSchemaNames(), listSequences(), doListTableColumns(), doListTableIndexes(), tablesExist(), doListTableNames(), filterAssetNames(), doListTables(), doListTableDetails(), normalizeName(), fetchTableColumnsByTable(), fetchIndexColumnsByTable(), fetchForeignKeyColumnsByTable(), introspectTable(), listViews(), doListTableForeignKeys(), dropDatabase(), dropSchema(), dropTable(), dropIndex(), dropConstraint(), dropForeignKey(), dropSequence(), dropUniqueConstraint(), dropView(), createSchemaObjects(), createDatabase(), createTable(), createSequence(), createConstraint(), createIndex(), createForeignKey(), createUniqueConstraint(), createView(), dropSchemaObjects(), dropAndCreateConstraint(), dropAndCreateIndex(), dropAndCreateForeignKey(), dropAndCreateSequence(), dropAndCreateTable(), dropAndCreateDatabase(), dropAndCreateView(), alterSchema(), migrateSchema(), alterTable(), renameTable(), _getPortableDatabasesList(), getPortableNamespacesList(), getPortableNamespaceDefinition(), _getPortableSequencesList(), _getPortableSequenceDefinition(), _getPortableTableColumnList(), _getPortableTablesList(), _getPortableViewsList(), createSchema(), introspectSchema(), createSchemaConfig(), getSchemaSearchPaths(),

Constants
`private`	`MARIADB_ESCAPE_SEQUENCES = [ '\\0' => "\0", "\\'" => "'", '\\"' => '"', '\\b' => "\b", '\\n' => "\n", '\\r' => "\r", '\\t' => "\t", '\\Z' => "\x1a", '\\\\' => '\\', '\\%' => '%', '\\_' => '_', "''" => "'", ]`	#

Properties inherited from Doctrine\DBAL\Schema\AbstractSchemaManager
`$_conn, $_platform`

Namespaces

Classes

Interfaces

Exceptions

Class Doctrine\DBAL\Schema\MySQLSchemaManager

Overrides

Overrides

Deprecated

Overrides

Parameters

Overrides

Parameters

Overrides

Parameters

Overrides

Overrides

Overrides

Overrides

Overrides

Implements

Parameters

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides