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:
typo3cms database:updateschema "*.add,*.change"
typo3cms database:updateschema "*.add" --raw
typo3cms 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