[Typo3-dev] Foreign keys anyone?

[Karsten Dambekalns]

Hi Arne.

On 2004-09-13, Arne Skjaerholt <skjaerho at cpi.no> wrote:
> Hello all,
> While I was browsing through my new typo3 installation I noticed
> something a tad worrying in the DB section. There are columns that
> appear to be referencing another column, but without any foreign key
> restrictions on them. Is this a concious design decision (in which case
> I'd be interested in knowing why) or is it simply an oversight from
> whoever wrote the DB scripts?

It is a half-conscious design decision. Just look up the date when
foreign key constraints where introduced in MySQL, and compare to when
TYPO3 was 'born'.

Of course it would be great to add such references, especially since
MySQL can always handle themm, even if the underlying storage engine
doesn't handle them (in case of which they'll just be ignored).

Karsten