database:updateschema¶
Update database schema (TYPO3 Database Compare)
Compares the current database schema with schema definition from extensions's ext_tables.sql files and updates the schema based on the definition.
Valid schema update types are:
field.add
field.change
field.prefix
field.drop
table.add
table.change
table.prefix
table.drop
safe (includes all necessary operations, to add or change fields or tables)
destructive (includes all operations which rename or drop fields or tables)
The list of schema update types supports wildcards to specify multiple types, e.g.:
"
*
" (all updates)"
field.*
" (all field updates)"
*.add,*.change
" (all add/change updates)
To avoid shell matching all types with wildcards should be quoted.
Example:
typo3 database:updateschema "*.add,*.change"
typo3 database:updateschema "*.add" --raw
typo3 database:updateschema "*" --verbose
Arguments¶
schemaUpdateTypes
List of schema update types
Options¶
--dry-run
If set the updates are only collected and shown, but not executed
Accept value: no
Is value required: no
Is multiple: no
Default: false
--raw
If set, only the SQL statements, that are required to update the schema, are printed
Accept value: no
Is value required: no
Is multiple: no
Default: false