[TYPO3-dev] IRRE fields on tt_content

JoH asenau info at cybercraft.de
Tue Jan 12 11:53:35 CET 2010


> CREATE TABLE tt_content (
> ...
> irre_parentid int(11) DEFAULT '0' NOT NULL,
> irre_parenttable varchar(255) DEFAULT '' NOT NULL,
> ...
> );
>
> I am a little in doubt about NOT NULL but it should not hurt much.
> Using NULLable columns may cause more problems than it is worth in
> terms of database size.
>
> What do you think about adding such columns? Do you like field names?
> They are almost the same as in old Olly's IRRE document (with 'irre_'
> prefix added).

On the one hand I like the idea of having unified stuff especially with
tt_content, on the other hand we might run into trouble when there are two
different extensions using the same combination of parentid and parenttable.

i.e.: ICEbox is using relations between tt_content and tt_content. Since
there is no extra table generated (not even an extra MM table) this will
conflict with any other extension doing something similar.

So: +1 for the idea, but only for extensions that are working with at least
one own (and unique) table as parent table.

Just my 2 cents

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
Xing: http://contact.cybercraft.de
Twitter: http://twitter.com/bunnyfield
TYPO3 cookbook (2nd edition): http://www.typo3experts.com






More information about the TYPO3-dev mailing list