Hi all, I'm trying to create a map mashup using CakePHP for my first Web App with Cake :) But I'm just afraid that I'm not structuring my database correctly...
The idea: A simple mashup with google maps which allows people to submit/search points of interest on a map and click on the pointers for address information and to view/add comments. Users don't have to register but there is an option available if they want to. My db tables so far: --------------------------------- pois (point of interests) --------------------------------- id name address1 address2 locality state country lng lat ip_address (should I log this?) user_id comment_id created_by (this is filled out by the user if they do not want to registered) email_address (this is filled out by the user if they do not want to registered) created_on updated_on --------------------------------- users --------------------------------- id username password firstname lastname email_address --------------------------------- comments --------------------------------- id title content created_by (this is filled out by the user if they do not want to registered) email_address (this is filled out by the user if they do not want to registered) ip_address (should I log this?) user_id Have I gone about the right way doing this for a CakePHP app? If not do you mind shedding some light? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
