add info about default SQL to create fields and database related topics

[DavidBruchmann]

Current behavior

SQL syntax to create common fields is not mentioned at all, and neither some side aspects like collation of whole tables or single fields.

Expected behavior/output

A basic chapter about default settings for fields, going into details about charset and collation, as well as special fields like timestamp in contrast to datetime, or json.
Also some special scenarios should be explained with respect to the database, like languages or workspaces.

In the overview of single fields I'd wish that the default SQL for each field is listed (it might consider different sorts of databases like mySQL, msSQL, postgres, SqLite if required.

[DavidBruchmann]

special issues like changing select fields from int to string should be part of the general chapter too.

[sbuerk]

I guess you refere to Default Schema generation for supported TCA types, which has been drastically enriched with TYPO3 v13 ?

Will provide something the next days as a start point, but TYPO3 v13 changes/details may be not included directly and delayed because of (after they have been added to the core):

• TCA type=input default schema generation still pending/not finished
• Database Analyzer stacks needs quote some pre-work(refactoring) to provide possible safe database value migration without requireing to add dozen of update wizards or workaround hacks (for core AND extension authors)
• It's planned to enhance the ext_tables.sql parser to support some stuff and fix/align other stuff in the Database Analyzer.

[DavidBruchmann]

Yes, it's about Default Schema generation for supported TCA types.
Great that you assigned yourself, curious what's coming!!!