[TYPO3-dev] DBAL problems with pages.fe_group

[Franz Holzinger]

Hello

> SQL:
>   fe_group varchar(100) DEFAULT '0' NOT NULL
> 
> The odd thing is that the default value is the illegal id 0. Does TYPO3
> rely on this '0', instead of using '' meaning an empty list?
> 
> So what is best option?
> 
> a) Simply to remove the NOT NULL and the then useless DEFAULT '0'?
> b) Adding TCA options that enforce the SQL default in situations like this?
> c) Add DB triggers that turn '' into '0' for such fields?
> 
> I'm for a) If the field is a list then '' is an empty list not '0'. But
> is the Core ready for this?
> 
Use a) which is the most understandable solution.
The Core should be changed if needed.


- Franz