[PATCH] Events Reorganization

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