[Typo3-dev] I don't want to fork!

[Elmar Hinz]

> 
> 
> I think both should remain, but without redundant data. All info
> about the account should be in fe_user, and all info about the
> user should be in tt_address. And then you have a relation
> between them.
> 
> Example:
> Move all the fields like Name, Address, Phone, Fax, www, Image,
> MSN/AIM/Yahoo screen name etc from fe_user to tt_address.
> Instead add a field (like the Groups field) in fe_user where you
> just choose a person from tt_address. Voila!
> 
> But! I guess this is even more difficult to realize than other
> solutions, but IMHO it it the most "clean" one. I mean, isn´t
> this the reason why we use a relational database like MySQL?  ;-)
> 
> 
> /Peter Kindström

The advantage is, that you can relate multiple adresses to one account. 
I guess that was the original idea to set up two tables.

The first disadvantage is that you need to query to query two tables, 
which makes things more complex for most extensions.

The second disadvantage is, that it seems impossible to integrate this 
complexity into already existing extensions.

The compromise would be to put a *main* address into fe_user, which 
serves for most cases and to use tt_address only for *additional* 
addresses. Then the mayority of extensions can use the simple approach.

The price for this compromise is, that in special cases you have to 
query two tables if you are searching for an address .

Elmar




-- 
Climate change 2005: Mexico, Guatemala, New Orleans, Sahel, Bangladesh,
Spain, Portugal, Austria, Swiss, France, ...
Production of CO2 is killing people.
Production of CO2 just for fun is killing people just for fun.