Re: Database design for local information specific site

On Thu, Oct 2, 2008 at 5:13 PM, ORCC <oskarcah@gmail.com> wrote:

[..snip..]

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"

Instead of the above table, it might be an idea to create a "properties" table with:

Id     Property
1      "greeting"
2      "contact"
3      ....

.. and a HABTM table:

city_id   property_id     value
1           1                   "HELLO"
1           2                   "contact_us@yoursite"
2           1                   "HOLA"
2           2                   "contact_es@yoursite"
etc ...

- Gonzalo

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---