Timezones Database for World Most Well-Known Cities with LATITUDE and LONGITUDE
Description:
The main purpose is listing timezones with latitude and longitude for the most well-known world cities, but you'll find also some extra fields also, they're bonus from me 
Fields:
1) ID
2) CAT
3) CITY NAME
4) STANDART TIMEZONE
5) DAYLIGHT SAVING TIME
6) CURRENT TIMEZONE OFFSET
7) TIMEZONE ABBREVIATION
8) COUNTRYCODE
9) AREACODE
10) LATITUDE
11) LONGITUDE
The bonus fields are DAYLIGHT SAVING TIME, CURRENT TIMEZONE OFFSET, TIMEZONE ABBREVIATION, COUNTRYCODE AND AREACODE
Structure:
PHP Code:
CREATE TABLE `site_data` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`cityname` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`standarttimezone` text character set utf8 collate utf8,
`dailylightsavingtime` text character set utf8 collate utf8,
`currenttimezoneoffset` text character set utf8 collate utf8,
`timezoneabbreviation` text character set utf8 collate utf8,
`countrycode` text character set utf8 collate utf8,
`areacode` text character set utf8 collate utf8,
`latitude` text character set utf8 collate utf8,
`longitude` text character set utf8 collate utf8,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1238 ;
Total records: 1.238
Price: 39$
Regards
|
