[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