[TYPO3-dev] Creating tables via tca file

[Ivano Luberti]

Il 06/04/2017 17:17, NGUYEN Duc Quan ha scritto:
> Hi,
>
> I recently had an issue which caused a strange behavior and I am
> wondering if this is something usable.
>
> Scenario:
>
> 1a) I created a tca file "tx_myextension_domain_model_something" with
> all the usual tca stuff in it
> 1b) I forgot to define the create statement in the ext_tables.sql file
> 2) I went to the "Install Tool" and clicked the "Compare current
> database with specification"
>
> => the database analyser still gives me the option to create the table
> "tx_myextension_domain_model_something" but with only the l10n field
>
> Does this mean that it would be possible to define the whole db table
> via tca and the ext_tables.sql file would be obsolete? And I am just
> missing the knowledge to do so.
>

Nope, you have to define the table using SQL the TCA is used by the
backned to dipslay and validate fields choosing among various types:
text, date, select....and more specific TYPO3 fields like the ones to
choose frontend users


> This would be a nice thing since it eliminates an additional task.
>
> I am using Typo3 8.7.0 LTS.
>
>
> Cheers,
> Quan
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev

-- 
==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-8932061
web: www.archicoop.it
==================================================