[TYPO3-dev] RFC: Change roadmap for 4.5 and 5.0

[Thomas Hempel]

Hi,

> Correct if I'm wrong, but Thomas means that there are several columns in 
> Typo3 database that are used to store multiple values, while the 
> correct, normalized representation would be to turn the column into a 
> separate table and link the two using foreign keys.
> 
> An example is the usergroup field in the be_users table. It stores all 
> groups the user belongs to in a single column like this: 
> "22,6,9,10,7,20,14,8". For this table to be in 1st normal form, you 
> would need to create another table, called, say "usergroups" and store 
> these rows (assuming the user above has uid=1):
> 
> User_uid | Group_uid
> 1 | 22
> 1 | 6
> 1 | 9
> 1 | 10
> 1 | 7
> 1 | 20
> 1 | 14
> 1 | 8
> 
yeah, this one of the worst things in the DB. It a horror to find all 
users who are in a special usergroup. I don't have the hole structure in 
my mind, but I think there are some other fields that should be changed 
for future releases. Especially for such a major release like 5.0.


Greets,
Thomas

--
typo3-unleashed.net