Timezones for locations

Users perform phone calls with numerous people from different countries quite often, therefore they require functionality which allows them to quickly figure out local time at phonecall destination. From our side, implementing this functionality will require:

• DONE adding new table:

CREATE TABLE `civicrm_timezone` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR(3) NOT NULL,
`abbreviation` VARCHAR(3) NOT NULL,
`country_id` int(10) NOT NULL, # fk to civicrm_country
PRIMARY `id`
) ENGINE=MyISAM ;

• populating civicrm_timezone with necessary data
• providing UI in Location block editing that allows choosing default timezone: a selector containing all the timezones
• providing UI in Location block displaying that presents default timezone
• we'll not implement UI for editing timezones at this stage (potential changes will be done directly in the database)

NOTE: Timezones will be available on per country basis for now.