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