Hello,
Patches and table dumps pertinent to this email are at:
http://postgresql.tinysofa.com/files/patches/01-event/
Database Dumps
==============
000-events.dump
---------------
Dump of 'events' table, with:
* New field additions: city, state, country.
* All entries assigned a city, state (if applicable) and country.
* All entries with proper start and end dates.
001-events_text.dump
--------------------
Dump of 'events_text' table, with:
* Entries edited to remove redundant information addressed by above
changes to 'events'.
* Any translations found in archived entries has been properly inserted
as a translation (see our pgweb, go to the events archive, and switch to
"Turkish" to see some of Devrim's entries translated.)
002-countries.dump
------------------
Dump of new 'countries' (note: plural names for tables are bad) table, with:
* Fields: id, country, tld
* Information is taken from the CIA World Facts book.
Patches
=======
01-pgweb-ts-events-admin-template.patch
---------------------------------------
* Change the events output in the admin system to show location.
02-pgweb-ts-events-admin.patch
------------------------------
* Change the events edit screen to allow entry of city, state and country.
* Add templating function 'format_location' to... format location.
03-pgweb-ts-events-system.patch
-------------------------------
* Change user event submission form to feature city, state and country.
* Add 'fetch_countries_list' to database functions.
* Provide a 'location' template variable to the events templates.
04-pgweb-ts-events-template.patch
---------------------------------
* Change event-related templates to show a "Location".
* Fix event detail screen to show proper posted_by.
Omar