Re: Database design for local information specific site

I suggest you to:

- Create a single table Cities (id,name). For example

Id Name
1 New York
2 Madrid
3 Roma

- Create a single table called Properties (id,city_id, property,
value) and place in that table All the properties for each city. For
instance:

Id City_Id Property Value
1 1 "greeting" "HELLO"
2 2 "greeting" "HOLA"
3 3 "greeting" "CIAO"
4 1 "contact" "contact_us@yoursite"
5 2 "contact" "contact_es@yoursite"
6 3 "contact" "contact_it@yoursite"

- Add a session value with city_Id, once the user has enter in the
site, and use that id to retreive all the properties from the current
city.

I think that with the above schema you don't need to do too much joins
for retreive your localized properties, just need to know the city_id

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---