Zeitgeist Geo Location extension

Registered by Seif Lotfy

At UDS a lot of developers and big people seemed interested in the idea of association events with geo-locations...
Use cases of that would be "Who did i contact at work" or "What files do i use most at university"...
Morten started on this blueprint and we need to figure out how to store the geo locations in a DB design.
Although such info belongs into the event column. Do to our current development it should be developed as an extension.

My idea for the database design would be having 6 new tables:

|event_id | country_id | region_id | city_id | longtitude_id | latitude_id | desc_id

Most of them are self explanatory however desc_id will be a self set description such as HOME or UNI or WORK...
You take please

Blueprint information

Status:
Complete
Approver:
Zeitgeist Framework Team
Priority:
Undefined
Drafter:
Zeitgeist Framework Team
Direction:
Needs approval
Assignee:
Morten Mjelva
Definition:
Review
Series goal:
None
Implementation:
Implemented
Milestone target:
None
Started by
Seif Lotfy
Completed by
Seif Lotfy

Sprints

Whiteboard

done and done... the code is in lp:zeitgeist-extensions

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.