[TYPO3-core] What property types should the ExtensionBuilder provide
peter.niederlag at typo3.org
Fri Apr 11 11:17:27 CEST 2014
On 11.04.2014 10:48, Nicolas de Haen wrote:
> My suggestion would be (foreign table in brackets):
> Image sys_file_reference
> File sys_file_reference
> FileCollection sys_file_collection
+1. Sounds reasonable to me.
> What about:
> FolderBasedFileCollection or StaticFileCollection ?
Haven't used them yet, seem to be used rather seldom to me.
> It's obvious that the Native Date formats should be "default" but should
> we keep the others? There might be use cases where you want a timestamp
> in the database but a Date field in backend forms.
> My suggestion would be:
> Date Date
> DateTime DateTime
> Date (timestamp) int
> DateTime (timestamp) int
> Time int
> TimeSec int
> And finally:
> we have the property type Float which is in fact a double since the TCA
> does not support the type float. It only has a type 'double2' which
> means: "Converts the input to a floating point with 2 decimal positions"
> At the moment property type float results in a column of type double(11,2).
> Is there any reason why float is not supported in TCA?
> Should we rename the property then to Double instead Float or offer both
> types and create the appropriate database columns?
On PHP-level imho there is no difference between float and double. So
basically this is just a matter of sql-field-definition and
In TCA there is just 'double2' which probably goes along with SQL
double(11,2). Seems like a reasonable default, that can easily be
adapted by the developer.
Greets and big thx for taking care,
More information about the TYPO3-team-core