-- MySQL dump 10.11 -- -- Host: localhost Database: intranet -- ------------------------------------------------------ -- Server version 5.0.38-Ubuntu_0ubuntu1-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `nuke_antiflood` -- DROP TABLE IF EXISTS `nuke_antiflood`; CREATE TABLE `nuke_antiflood` ( `ip_addr` varchar(48) NOT NULL, `time` varchar(14) NOT NULL, KEY `ip_addr` (`ip_addr`), KEY `time` (`time`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_antiflood` -- LOCK TABLES `nuke_antiflood` WRITE; /*!40000 ALTER TABLE `nuke_antiflood` DISABLE KEYS */; INSERT INTO `nuke_antiflood` VALUES ('126.1.10.109','1186675692'),('126.1.10.11','1184764142'); /*!40000 ALTER TABLE `nuke_antiflood` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_authors` -- DROP TABLE IF EXISTS `nuke_authors`; CREATE TABLE `nuke_authors` ( `aid` varchar(25) NOT NULL default '', `name` varchar(50) default NULL, `url` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `pwd` varchar(40) default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) NOT NULL default '', PRIMARY KEY (`aid`), KEY `aid` (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_authors` -- LOCK TABLES `nuke_authors` WRITE; /*!40000 ALTER TABLE `nuke_authors` DISABLE KEYS */; INSERT INTO `nuke_authors` VALUES ('admin','God','http://','rogerio@gruposabara.com.br','5b0994672ef896dac4a142f785aa79dc',0,1,''),('rogerio','rogerio','','rogerio@gruposabara.com.br','1364f538f4266b6bc5eac760801a14ff',5,1,''),('lula','luizfelipe','','luizfelipe@gruposabara.com.br','65dd566918646e558d299bc985b475d2',32,1,''); /*!40000 ALTER TABLE `nuke_authors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_autonews` -- DROP TABLE IF EXISTS `nuke_autonews`; CREATE TABLE `nuke_autonews` ( `anid` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `aid` varchar(30) NOT NULL default '', `title` varchar(80) NOT NULL default '', `time` varchar(19) NOT NULL default '', `hometext` text NOT NULL, `bodytext` text NOT NULL, `topic` int(3) NOT NULL default '1', `informant` varchar(20) NOT NULL default '', `notes` text NOT NULL, `ihome` int(1) NOT NULL default '0', `alanguage` varchar(30) NOT NULL default '', `acomm` int(1) NOT NULL default '0', `associated` text NOT NULL, PRIMARY KEY (`anid`), KEY `anid` (`anid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_autonews` -- LOCK TABLES `nuke_autonews` WRITE; /*!40000 ALTER TABLE `nuke_autonews` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_autonews` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_banned_ip` -- DROP TABLE IF EXISTS `nuke_banned_ip`; CREATE TABLE `nuke_banned_ip` ( `id` int(11) NOT NULL auto_increment, `ip_address` varchar(15) NOT NULL default '', `reason` varchar(255) NOT NULL default '', `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_banned_ip` -- LOCK TABLES `nuke_banned_ip` WRITE; /*!40000 ALTER TABLE `nuke_banned_ip` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_banned_ip` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_banner` -- DROP TABLE IF EXISTS `nuke_banner`; CREATE TABLE `nuke_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `name` varchar(50) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `alttext` varchar(255) NOT NULL default '', `date` datetime default NULL, `dateend` datetime default NULL, `position` int(10) NOT NULL default '0', `active` tinyint(1) NOT NULL default '1', `ad_class` varchar(5) NOT NULL default '', `ad_code` text NOT NULL, `ad_width` int(4) default '0', `ad_height` int(4) default '0', PRIMARY KEY (`bid`), KEY `bid` (`bid`), KEY `cid` (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_banner` -- LOCK TABLES `nuke_banner` WRITE; /*!40000 ALTER TABLE `nuke_banner` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_banner` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_banner_clients` -- DROP TABLE IF EXISTS `nuke_banner_clients`; CREATE TABLE `nuke_banner_clients` ( `cid` int(11) NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `contact` varchar(60) NOT NULL default '', `email` varchar(60) NOT NULL default '', `login` varchar(10) NOT NULL default '', `passwd` varchar(10) NOT NULL default '', `extrainfo` text NOT NULL, PRIMARY KEY (`cid`), KEY `cid` (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_banner_clients` -- LOCK TABLES `nuke_banner_clients` WRITE; /*!40000 ALTER TABLE `nuke_banner_clients` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_banner_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_banner_plans` -- DROP TABLE IF EXISTS `nuke_banner_plans`; CREATE TABLE `nuke_banner_plans` ( `pid` int(10) NOT NULL auto_increment, `active` tinyint(1) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `delivery` varchar(10) NOT NULL default '', `delivery_type` varchar(25) NOT NULL default '', `price` varchar(25) NOT NULL default '0', `buy_links` text NOT NULL, PRIMARY KEY (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_banner_plans` -- LOCK TABLES `nuke_banner_plans` WRITE; /*!40000 ALTER TABLE `nuke_banner_plans` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_banner_plans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_banner_positions` -- DROP TABLE IF EXISTS `nuke_banner_positions`; CREATE TABLE `nuke_banner_positions` ( `apid` int(10) NOT NULL auto_increment, `position_number` int(5) NOT NULL default '0', `position_name` varchar(255) NOT NULL default '', PRIMARY KEY (`apid`), KEY `position_number` (`position_number`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_banner_positions` -- LOCK TABLES `nuke_banner_positions` WRITE; /*!40000 ALTER TABLE `nuke_banner_positions` DISABLE KEYS */; INSERT INTO `nuke_banner_positions` VALUES (1,0,'Page Top'),(2,1,'Left Block'); /*!40000 ALTER TABLE `nuke_banner_positions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_banner_terms` -- DROP TABLE IF EXISTS `nuke_banner_terms`; CREATE TABLE `nuke_banner_terms` ( `terms_body` text NOT NULL, `country` varchar(255) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_banner_terms` -- LOCK TABLES `nuke_banner_terms` WRITE; /*!40000 ALTER TABLE `nuke_banner_terms` DISABLE KEYS */; INSERT INTO `nuke_banner_terms` VALUES ('
Introduction: This Agreement between you and [sitename] consists of these Terms and Conditions. "You" or "Advertiser" means the entity identified in this enrollment form, and/or any agency acting on its behalf, which shall also be bound by the terms of this Agreement. Please read very carefully these Terms and Conditions.

Uses: You agree that your ads may be placed on (i) [sitename] web site and (ii) Any ads may be modified without your consent to comply with any policy of [sitename]. [sitename] reserves the right to, and in its sole discretion may, at any time review, reject, modify, or remove any ad. No liability of [sitename] and/or its owner(s) shall result from any such decision.

Parties\' Responsibilities: You are responsible of your own site and/or service advertised in [sitename] web site. You are solely responsible for the advertising image creation, advertising text and for the content of your ads, including URL links. [sitename] is not responsible for anything regarding your Web site(s) including, but not limited to, maintenance of your Web site(s), order entry, customer service, payment processing, shipping, cancellations or returns.

Impressions Count: Any hit to [sitename] web site is counted as an impression. Due to our advertising price we don\'t discriminate from users or automated robots. Even if you access to [sitename] web site and see your own banner ad it will be counted as a valid impression. Only in the case of [sitename] web site administrator, the impressions will not be counted.

Termination, Cancellation: [sitename] may at any time, in its sole discretion, terminate the Campaign, terminate this Agreement, or cancel any ad(s) or your use of any Target. [sitename] will notify you via email of any such termination or cancellation, which shall be effective immediately. No refund will be made for any reason. Remaining impressions will be stored in a database and you\'ll be able to request another campaign to complete your inventory. You may cancel any ad and/or terminate this Agreement with or without cause at any time. Termination of your account shall be effective when [sitename] receives your notice via email. No refund will be made for any reason. Remaining impressions will be stored in a database for future uses by you and/or your company.

Content: [sitename] web site doesn\'t accepts advertising that contains: (i) pornography, (ii) explicit adult content, (iii) moral questionable content, (iv) illegal content of any kind, (v) illegal drugs promotion, (vi) racism, (vii) politics content, (viii) religious content, and/or (ix) fraudulent suspicious content. If your advertising and/or target web site has any of this content and you purchased an advertising package, you\'ll not receive refund of any kind but your banners ads impressions will be stored for future use.

Confidentiality: Each party agrees not to disclose Confidential Information of the other party without prior written consent except as provided herein. "Confidential Information" includes (i) ads, prior to publication, (ii) submissions or modifications relating to any advertising campaign, (iii) clickthrough rates or other statistics (except in an aggregated form that includes no identifiable information about you), and (iv) any other information designated in writing as "Confidential." It does not include information that has become publicly known through no breach by a party, or has been (i) independently developed without access to the other party\'s Confidential Information; (ii) rightfully received from a third party; or (iii) required to be disclosed by law or by a governmental authority.

No Guarantee: [sitename] makes no guarantee regarding the levels of clicks for any ad on its site. [sitename] may offer the same Target to more than one advertiser. You may not receive exclusivity unless special private contract between [sitename] and you.

No Warranty: [sitename] MAKES NO WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION WITH RESPECT TO ADVERTISING AND OTHER SERVICES, AND EXPRESSLY DISCLAIMS THE WARRANTIES OR CONDITIONS OF NONINFRINGEMENT, MERCHANTABILITY AND FITNESS FOR ANY PARTICULAR PURPOSE.

Limitations of Liability: In no event shall [sitename] be liable for any act or omission, or any event directly or indirectly resulting from any act or omission of Advertiser, Partner, or any third parties (if any). EXCEPT FOR THE PARTIES\' INDEMNIFICATION AND CONFIDENTIALITY OBLIGATIONS HEREUNDER, (i) IN NO EVENT SHALL EITHER PARTY BE LIABLE UNDER THIS AGREEMENT FOR ANY CONSEQUENTIAL, SPECIAL, INDIRECT, EXEMPLARY, PUNITIVE, OR OTHER DAMAGES WHETHER IN CONTRACT, TORT OR ANY OTHER LEGAL THEORY, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES AND NOTWITHSTANDING ANY FAILURE OF ESSENTIAL PURPOSE OF ANY LIMITED REMEDY AND (ii) [sitename] AGGREGATE LIABILITY TO ADVERTISER UNDER THIS AGREEMENT FOR ANY CLAIM IS LIMITED TO THE AMOUNT PAID TO [sitename] BY ADVERTISER FOR THE AD GIVING RISE TO THE CLAIM. Each party acknowledges that the other party has entered into this Agreement relying on the limitations of liability stated herein and that those limitations are an essential basis of the bargain between the parties. Without limiting the foregoing and except for payment obligations, neither party shall have any liability for any failure or delay resulting from any condition beyond the reasonable control of such party, including but not limited to governmental action or acts of terrorism, earthquake or other acts of God, labor conditions, and power failures.

Payment: You agree to pay in advance the cost of the advertising. [sitename] will not setup any banner ads campaign(s) unless the payment process is complete. [sitename] may change its pricing at any time without prior notice. If you have an advertising campaign running and/or impressions stored for future use for any mentioned cause and [sitename] changes its pricing, you\'ll not need to pay any difference. Your purchased banners fee will remain the same. Charges shall be calculated solely based on records maintained by [sitename]. No other measurements or statistics of any kind shall be accepted by [sitename] or have any effect under this Agreement.

Representations and Warranties: You represent and warrant that (a) all of the information provided by you to [sitename] to enroll in the Advertising Campaign is correct and current; (b) you hold all rights to permit [sitename] and any Partner(s) to use, reproduce, display, transmit and distribute your ad(s); and (c) [sitename] and any Partner(s) Use, your Target(s), and any site(s) linked to, and products or services to which users are directed, will not, in any state or country where the ad is displayed (i) violate any criminal laws or third party rights giving rise to civil liability, including but not limited to trademark rights or rights relating to the performance of music; or (ii) encourage conduct that would violate any criminal or civil law. You further represent and warrant that any Web site linked to your ad(s) (i) complies with all laws and regulations in any state or country where the ad is displayed; (ii) does not breach and has not breached any duty toward or rights of any person or entity including, without limitation, rights of publicity or privacy, or rights or duties under consumer protection, product liability, tort, or contract theories; and (iii) is not false, misleading, defamatory, libelous, slanderous or threatening.

Your Obligation to Indemnify: You agree to indemnify, defend and hold [sitename], its agents, affiliates, subsidiaries, directors, officers, employees, and applicable third parties (e.g., all relevant Partner(s), licensors, licensees, consultants and contractors) ("Indemnified Person(s)") harmless from and against any and all third party claims, liability, loss, and expense (including damage awards, settlement amounts, and reasonable legal fees), brought against any Indemnified Person(s), arising out of, related to or which may arise from your use of the Advertising Program, your Web site, and/or your breach of any term of this Agreement. Customer understands and agrees that each Partner, as defined herein, has the right to assert and enforce its rights under this Section directly on its own behalf as a third party beneficiary.

Information Rights: [sitename] may retain and use for its own purposes all information you provide, including but not limited to Targets, URLs, the content of ads, and contact and billing information. [sitename] may share this information about you with business partners and/or sponsors. [sitename] will not sell your information. Your name, web site\'s URL and related graphics shall be used by [sitename] in its own web site at any time as a sample to the public, even if your Advertising Campaign has been finished.

Miscellaneous: Any decision made by [sitename] under this Agreement shall be final. [sitename] shall have no liability for any such decision. You will be responsible for all reasonable expenses (including attorneys\' fees) incurred by [sitename] in collecting unpaid amounts under this Agreement. This Agreement shall be governed by the laws of [country]. Any dispute or claim arising out of or in connection with this Agreement shall be adjudicated in [country]. This constitutes the entire agreement between the parties with respect to the subject matter hereof. Advertiser may not resell, assign, or transfer any of its rights hereunder. Any such attempt may result in termination of this Agreement, without liability to [sitename] and without any refund. The relationship(s) between [sitename] and the "Partners" is not one of a legal partnership relationship, but is one of independent contractors. This Agreement shall be construed as if both parties jointly wrote it.
','Canada'); /*!40000 ALTER TABLE `nuke_banner_terms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbauth_access` -- DROP TABLE IF EXISTS `nuke_bbauth_access`; CREATE TABLE `nuke_bbauth_access` ( `group_id` mediumint(8) NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_post` tinyint(1) NOT NULL default '0', `auth_reply` tinyint(1) NOT NULL default '0', `auth_edit` tinyint(1) NOT NULL default '0', `auth_delete` tinyint(1) NOT NULL default '0', `auth_sticky` tinyint(1) NOT NULL default '0', `auth_announce` tinyint(1) NOT NULL default '0', `auth_vote` tinyint(1) NOT NULL default '0', `auth_pollcreate` tinyint(1) NOT NULL default '0', `auth_attachments` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', KEY `group_id` (`group_id`), KEY `forum_id` (`forum_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbauth_access` -- LOCK TABLES `nuke_bbauth_access` WRITE; /*!40000 ALTER TABLE `nuke_bbauth_access` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbauth_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbbanlist` -- DROP TABLE IF EXISTS `nuke_bbbanlist`; CREATE TABLE `nuke_bbbanlist` ( `ban_id` mediumint(8) unsigned NOT NULL auto_increment, `ban_userid` mediumint(8) NOT NULL default '0', `ban_ip` varchar(8) NOT NULL default '', `ban_email` varchar(255) default NULL, `ban_time` int(11) default NULL, `ban_expire_time` int(11) default NULL, `ban_by_userid` mediumint(8) default NULL, `ban_priv_reason` text, `ban_pub_reason_mode` tinyint(1) default NULL, `ban_pub_reason` text, PRIMARY KEY (`ban_id`), KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbbanlist` -- LOCK TABLES `nuke_bbbanlist` WRITE; /*!40000 ALTER TABLE `nuke_bbbanlist` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbbanlist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbcategories` -- DROP TABLE IF EXISTS `nuke_bbcategories`; CREATE TABLE `nuke_bbcategories` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(100) default NULL, `cat_order` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbcategories` -- LOCK TABLES `nuke_bbcategories` WRITE; /*!40000 ALTER TABLE `nuke_bbcategories` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbcategories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbconfig` -- DROP TABLE IF EXISTS `nuke_bbconfig`; CREATE TABLE `nuke_bbconfig` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbconfig` -- LOCK TABLES `nuke_bbconfig` WRITE; /*!40000 ALTER TABLE `nuke_bbconfig` DISABLE KEYS */; INSERT INTO `nuke_bbconfig` VALUES ('config_id','1'),('board_disable','0'),('sitename','MySite.com'),('site_desc',''),('cookie_name','phpbb2mysql'),('cookie_path','/'),('cookie_domain','MySite.com'),('cookie_secure','0'),('session_length','3600'),('allow_html','1'),('allow_html_tags','b,i,u,pre'),('allow_bbcode','1'),('allow_smilies','1'),('allow_sig','1'),('allow_namechange','0'),('allow_theme_create','0'),('allow_avatar_local','1'),('allow_avatar_remote','0'),('allow_avatar_upload','0'),('override_user_style','1'),('posts_per_page','15'),('topics_per_page','50'),('hot_threshold','25'),('max_poll_options','10'),('max_sig_chars','255'),('max_inbox_privmsgs','100'),('max_sentbox_privmsgs','100'),('max_savebox_privmsgs','100'),('board_email_sig','Thanks, Webmaster@MySite.com'),('board_email','Webmaster@MySite.com'),('smtp_delivery','0'),('smtp_host',''),('require_activation','0'),('flood_interval','15'),('board_email_form','0'),('avatar_filesize','6144'),('avatar_max_width','80'),('avatar_max_height','80'),('avatar_path','modules/Forums/images/avatars'),('avatar_gallery_path','modules/Forums/images/avatars'),('smilies_path','modules/Forums/images/smiles'),('default_style','1'),('default_dateformat','D M d, Y g:i a'),('board_timezone','10'),('prune_enable','0'),('privmsg_disable','0'),('gzip_compress','0'),('coppa_fax',''),('coppa_mail',''),('board_startdate','1013908210'),('default_lang','english'),('smtp_username',''),('smtp_password',''),('record_online_users','2'),('record_online_date','1034668530'),('server_name','MySite.com'),('server_port','80'),('script_path','/modules/Forums/'),('version','.0.20'),('enable_confirm','0'),('sendmail_fix','0'),('search_flood_interval','15'),('rand_seed','0'); /*!40000 ALTER TABLE `nuke_bbconfig` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbdisallow` -- DROP TABLE IF EXISTS `nuke_bbdisallow`; CREATE TABLE `nuke_bbdisallow` ( `disallow_id` mediumint(8) unsigned NOT NULL auto_increment, `disallow_username` varchar(25) default NULL, PRIMARY KEY (`disallow_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbdisallow` -- LOCK TABLES `nuke_bbdisallow` WRITE; /*!40000 ALTER TABLE `nuke_bbdisallow` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbdisallow` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbforum_prune` -- DROP TABLE IF EXISTS `nuke_bbforum_prune`; CREATE TABLE `nuke_bbforum_prune` ( `prune_id` mediumint(8) unsigned NOT NULL auto_increment, `forum_id` smallint(5) unsigned NOT NULL default '0', `prune_days` tinyint(4) unsigned NOT NULL default '0', `prune_freq` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`prune_id`), KEY `forum_id` (`forum_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbforum_prune` -- LOCK TABLES `nuke_bbforum_prune` WRITE; /*!40000 ALTER TABLE `nuke_bbforum_prune` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbforum_prune` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbforums` -- DROP TABLE IF EXISTS `nuke_bbforums`; CREATE TABLE `nuke_bbforums` ( `forum_id` smallint(5) unsigned NOT NULL auto_increment, `cat_id` mediumint(8) unsigned NOT NULL default '0', `forum_name` varchar(150) default NULL, `forum_desc` text, `forum_status` tinyint(4) NOT NULL default '0', `forum_order` mediumint(8) unsigned NOT NULL default '1', `forum_posts` mediumint(8) unsigned NOT NULL default '0', `forum_topics` mediumint(8) unsigned NOT NULL default '0', `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0', `prune_next` int(11) default NULL, `prune_enable` tinyint(1) NOT NULL default '1', `auth_view` tinyint(2) NOT NULL default '0', `auth_read` tinyint(2) NOT NULL default '0', `auth_post` tinyint(2) NOT NULL default '0', `auth_reply` tinyint(2) NOT NULL default '0', `auth_edit` tinyint(2) NOT NULL default '0', `auth_delete` tinyint(2) NOT NULL default '0', `auth_sticky` tinyint(2) NOT NULL default '0', `auth_announce` tinyint(2) NOT NULL default '0', `auth_vote` tinyint(2) NOT NULL default '0', `auth_pollcreate` tinyint(2) NOT NULL default '0', `auth_attachments` tinyint(2) NOT NULL default '0', PRIMARY KEY (`forum_id`), KEY `forums_order` (`forum_order`), KEY `cat_id` (`cat_id`), KEY `forum_last_post_id` (`forum_last_post_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbforums` -- LOCK TABLES `nuke_bbforums` WRITE; /*!40000 ALTER TABLE `nuke_bbforums` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbforums` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbgroups` -- DROP TABLE IF EXISTS `nuke_bbgroups`; CREATE TABLE `nuke_bbgroups` ( `group_id` mediumint(8) NOT NULL auto_increment, `group_type` tinyint(4) NOT NULL default '1', `group_name` varchar(40) NOT NULL default '', `group_description` varchar(255) NOT NULL default '', `group_moderator` mediumint(8) NOT NULL default '0', `group_single_user` tinyint(1) NOT NULL default '1', PRIMARY KEY (`group_id`), KEY `group_single_user` (`group_single_user`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbgroups` -- LOCK TABLES `nuke_bbgroups` WRITE; /*!40000 ALTER TABLE `nuke_bbgroups` DISABLE KEYS */; INSERT INTO `nuke_bbgroups` VALUES (1,1,'Anonymous','Personal User',0,1),(3,2,'Moderators','Moderators of this Forum',5,0),(4,1,'','Personal User',0,1),(5,1,'','Personal User',0,1),(6,1,'','Personal User',0,1); /*!40000 ALTER TABLE `nuke_bbgroups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbposts` -- DROP TABLE IF EXISTS `nuke_bbposts`; CREATE TABLE `nuke_bbposts` ( `post_id` mediumint(8) unsigned NOT NULL auto_increment, `topic_id` mediumint(8) unsigned NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `poster_id` mediumint(8) NOT NULL default '0', `post_time` int(11) NOT NULL default '0', `poster_ip` varchar(8) NOT NULL default '', `post_username` varchar(25) default NULL, `enable_bbcode` tinyint(1) NOT NULL default '1', `enable_html` tinyint(1) NOT NULL default '0', `enable_smilies` tinyint(1) NOT NULL default '1', `enable_sig` tinyint(1) NOT NULL default '1', `post_edit_time` int(11) default NULL, `post_edit_count` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`post_id`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`), KEY `poster_id` (`poster_id`), KEY `post_time` (`post_time`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbposts` -- LOCK TABLES `nuke_bbposts` WRITE; /*!40000 ALTER TABLE `nuke_bbposts` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbposts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbposts_text` -- DROP TABLE IF EXISTS `nuke_bbposts_text`; CREATE TABLE `nuke_bbposts_text` ( `post_id` mediumint(8) unsigned NOT NULL default '0', `bbcode_uid` varchar(10) NOT NULL default '', `post_subject` varchar(60) default NULL, `post_text` text, PRIMARY KEY (`post_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbposts_text` -- LOCK TABLES `nuke_bbposts_text` WRITE; /*!40000 ALTER TABLE `nuke_bbposts_text` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbposts_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbprivmsgs` -- DROP TABLE IF EXISTS `nuke_bbprivmsgs`; CREATE TABLE `nuke_bbprivmsgs` ( `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment, `privmsgs_type` tinyint(4) NOT NULL default '0', `privmsgs_subject` varchar(255) NOT NULL default '0', `privmsgs_from_userid` mediumint(8) NOT NULL default '0', `privmsgs_to_userid` mediumint(8) NOT NULL default '0', `privmsgs_date` int(11) NOT NULL default '0', `privmsgs_ip` varchar(8) NOT NULL default '', `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1', `privmsgs_enable_html` tinyint(1) NOT NULL default '0', `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1', `privmsgs_attach_sig` tinyint(1) NOT NULL default '1', PRIMARY KEY (`privmsgs_id`), KEY `privmsgs_from_userid` (`privmsgs_from_userid`), KEY `privmsgs_to_userid` (`privmsgs_to_userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbprivmsgs` -- LOCK TABLES `nuke_bbprivmsgs` WRITE; /*!40000 ALTER TABLE `nuke_bbprivmsgs` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbprivmsgs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbprivmsgs_text` -- DROP TABLE IF EXISTS `nuke_bbprivmsgs_text`; CREATE TABLE `nuke_bbprivmsgs_text` ( `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0', `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0', `privmsgs_text` text, PRIMARY KEY (`privmsgs_text_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbprivmsgs_text` -- LOCK TABLES `nuke_bbprivmsgs_text` WRITE; /*!40000 ALTER TABLE `nuke_bbprivmsgs_text` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbprivmsgs_text` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbranks` -- DROP TABLE IF EXISTS `nuke_bbranks`; CREATE TABLE `nuke_bbranks` ( `rank_id` smallint(5) unsigned NOT NULL auto_increment, `rank_title` varchar(50) NOT NULL default '', `rank_min` mediumint(8) NOT NULL default '0', `rank_max` mediumint(8) NOT NULL default '0', `rank_special` tinyint(1) default '0', `rank_image` varchar(255) default NULL, PRIMARY KEY (`rank_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbranks` -- LOCK TABLES `nuke_bbranks` WRITE; /*!40000 ALTER TABLE `nuke_bbranks` DISABLE KEYS */; INSERT INTO `nuke_bbranks` VALUES (1,'Site Admin',-1,-1,1,'modules/Forums/images/ranks/6stars.gif'),(2,'Newbie',1,0,0,'modules/Forums/images/ranks/1star.gif'); /*!40000 ALTER TABLE `nuke_bbranks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbsearch_results` -- DROP TABLE IF EXISTS `nuke_bbsearch_results`; CREATE TABLE `nuke_bbsearch_results` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, `search_time` int(11) NOT NULL default '0', PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbsearch_results` -- LOCK TABLES `nuke_bbsearch_results` WRITE; /*!40000 ALTER TABLE `nuke_bbsearch_results` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbsearch_results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbsearch_wordlist` -- DROP TABLE IF EXISTS `nuke_bbsearch_wordlist`; CREATE TABLE `nuke_bbsearch_wordlist` ( `word_text` varchar(50) NOT NULL default '', `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word_common` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`word_text`), KEY `word_id` (`word_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbsearch_wordlist` -- LOCK TABLES `nuke_bbsearch_wordlist` WRITE; /*!40000 ALTER TABLE `nuke_bbsearch_wordlist` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbsearch_wordlist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbsearch_wordmatch` -- DROP TABLE IF EXISTS `nuke_bbsearch_wordmatch`; CREATE TABLE `nuke_bbsearch_wordmatch` ( `post_id` mediumint(8) unsigned NOT NULL default '0', `word_id` mediumint(8) unsigned NOT NULL default '0', `title_match` tinyint(1) NOT NULL default '0', KEY `word_id` (`word_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbsearch_wordmatch` -- LOCK TABLES `nuke_bbsearch_wordmatch` WRITE; /*!40000 ALTER TABLE `nuke_bbsearch_wordmatch` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbsearch_wordmatch` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbsessions` -- DROP TABLE IF EXISTS `nuke_bbsessions`; CREATE TABLE `nuke_bbsessions` ( `session_id` char(32) NOT NULL default '', `session_user_id` mediumint(8) NOT NULL default '0', `session_start` int(11) NOT NULL default '0', `session_time` int(11) NOT NULL default '0', `session_ip` char(8) NOT NULL default '0', `session_page` int(11) NOT NULL default '0', `session_logged_in` tinyint(1) NOT NULL default '0', `session_admin` tinyint(2) NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `session_user_id` (`session_user_id`), KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbsessions` -- LOCK TABLES `nuke_bbsessions` WRITE; /*!40000 ALTER TABLE `nuke_bbsessions` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbsessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbsmilies` -- DROP TABLE IF EXISTS `nuke_bbsmilies`; CREATE TABLE `nuke_bbsmilies` ( `smilies_id` smallint(5) unsigned NOT NULL auto_increment, `code` varchar(50) default NULL, `smile_url` varchar(100) default NULL, `emoticon` varchar(75) default NULL, PRIMARY KEY (`smilies_id`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbsmilies` -- LOCK TABLES `nuke_bbsmilies` WRITE; /*!40000 ALTER TABLE `nuke_bbsmilies` DISABLE KEYS */; INSERT INTO `nuke_bbsmilies` VALUES (1,':D','icon_biggrin.gif','Very Happy'),(2,':-D','icon_biggrin.gif','Very Happy'),(3,':grin:','icon_biggrin.gif','Very Happy'),(4,':)','icon_smile.gif','Smile'),(5,':-)','icon_smile.gif','Smile'),(6,':smile:','icon_smile.gif','Smile'),(7,':(','icon_sad.gif','Sad'),(8,':-(','icon_sad.gif','Sad'),(9,':sad:','icon_sad.gif','Sad'),(10,':o','icon_surprised.gif','Surprised'),(11,':-o','icon_surprised.gif','Surprised'),(12,':eek:','icon_surprised.gif','Surprised'),(13,'8O','icon_eek.gif','Shocked'),(14,'8-O','icon_eek.gif','Shocked'),(15,':shock:','icon_eek.gif','Shocked'),(16,':?','icon_confused.gif','Confused'),(17,':-?','icon_confused.gif','Confused'),(18,':???:','icon_confused.gif','Confused'),(19,'8)','icon_cool.gif','Cool'),(20,'8-)','icon_cool.gif','Cool'),(21,':cool:','icon_cool.gif','Cool'),(22,':lol:','icon_lol.gif','Laughing'),(23,':x','icon_mad.gif','Mad'),(24,':-x','icon_mad.gif','Mad'),(25,':mad:','icon_mad.gif','Mad'),(26,':P','icon_razz.gif','Razz'),(27,':-P','icon_razz.gif','Razz'),(28,':razz:','icon_razz.gif','Razz'),(29,':oops:','icon_redface.gif','Embarassed'),(30,':cry:','icon_cry.gif','Crying or Very sad'),(31,':evil:','icon_evil.gif','Evil or Very Mad'),(32,':twisted:','icon_twisted.gif','Twisted Evil'),(33,':roll:','icon_rolleyes.gif','Rolling Eyes'),(34,':wink:','icon_wink.gif','Wink'),(35,';)','icon_wink.gif','Wink'),(36,';-)','icon_wink.gif','Wink'),(37,':!:','icon_exclaim.gif','Exclamation'),(38,':?:','icon_question.gif','Question'),(39,':idea:','icon_idea.gif','Idea'),(40,':arrow:','icon_arrow.gif','Arrow'),(41,':|','icon_neutral.gif','Neutral'),(42,':-|','icon_neutral.gif','Neutral'),(43,':neutral:','icon_neutral.gif','Neutral'),(44,':mrgreen:','icon_mrgreen.gif','Mr. Green'); /*!40000 ALTER TABLE `nuke_bbsmilies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbthemes` -- DROP TABLE IF EXISTS `nuke_bbthemes`; CREATE TABLE `nuke_bbthemes` ( `themes_id` mediumint(8) unsigned NOT NULL auto_increment, `template_name` varchar(30) NOT NULL default '', `style_name` varchar(30) NOT NULL default '', `head_stylesheet` varchar(100) default NULL, `body_background` varchar(100) default NULL, `body_bgcolor` varchar(6) default NULL, `body_text` varchar(6) default NULL, `body_link` varchar(6) default NULL, `body_vlink` varchar(6) default NULL, `body_alink` varchar(6) default NULL, `body_hlink` varchar(6) default NULL, `tr_color1` varchar(6) default NULL, `tr_color2` varchar(6) default NULL, `tr_color3` varchar(6) default NULL, `tr_class1` varchar(25) default NULL, `tr_class2` varchar(25) default NULL, `tr_class3` varchar(25) default NULL, `th_color1` varchar(6) default NULL, `th_color2` varchar(6) default NULL, `th_color3` varchar(6) default NULL, `th_class1` varchar(25) default NULL, `th_class2` varchar(25) default NULL, `th_class3` varchar(25) default NULL, `td_color1` varchar(6) default NULL, `td_color2` varchar(6) default NULL, `td_color3` varchar(6) default NULL, `td_class1` varchar(25) default NULL, `td_class2` varchar(25) default NULL, `td_class3` varchar(25) default NULL, `fontface1` varchar(50) default NULL, `fontface2` varchar(50) default NULL, `fontface3` varchar(50) default NULL, `fontsize1` tinyint(4) default NULL, `fontsize2` tinyint(4) default NULL, `fontsize3` tinyint(4) default NULL, `fontcolor1` varchar(6) default NULL, `fontcolor2` varchar(6) default NULL, `fontcolor3` varchar(6) default NULL, `span_class1` varchar(25) default NULL, `span_class2` varchar(25) default NULL, `span_class3` varchar(25) default NULL, `img_size_poll` smallint(5) unsigned default NULL, `img_size_privmsg` smallint(5) unsigned default NULL, PRIMARY KEY (`themes_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbthemes` -- LOCK TABLES `nuke_bbthemes` WRITE; /*!40000 ALTER TABLE `nuke_bbthemes` DISABLE KEYS */; INSERT INTO `nuke_bbthemes` VALUES (1,'subSilver','subSilver','subSilver.css','','0E3259','000000','006699','5493B4','','DD6900','EFEFEF','DEE3E7','D1D7DC','','','','98AAB1','006699','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, \'Courier New\', sans-serif',10,11,12,'444444','006600','FFA34F','','','',NULL,NULL); /*!40000 ALTER TABLE `nuke_bbthemes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbthemes_name` -- DROP TABLE IF EXISTS `nuke_bbthemes_name`; CREATE TABLE `nuke_bbthemes_name` ( `themes_id` smallint(5) unsigned NOT NULL default '0', `tr_color1_name` char(50) default NULL, `tr_color2_name` char(50) default NULL, `tr_color3_name` char(50) default NULL, `tr_class1_name` char(50) default NULL, `tr_class2_name` char(50) default NULL, `tr_class3_name` char(50) default NULL, `th_color1_name` char(50) default NULL, `th_color2_name` char(50) default NULL, `th_color3_name` char(50) default NULL, `th_class1_name` char(50) default NULL, `th_class2_name` char(50) default NULL, `th_class3_name` char(50) default NULL, `td_color1_name` char(50) default NULL, `td_color2_name` char(50) default NULL, `td_color3_name` char(50) default NULL, `td_class1_name` char(50) default NULL, `td_class2_name` char(50) default NULL, `td_class3_name` char(50) default NULL, `fontface1_name` char(50) default NULL, `fontface2_name` char(50) default NULL, `fontface3_name` char(50) default NULL, `fontsize1_name` char(50) default NULL, `fontsize2_name` char(50) default NULL, `fontsize3_name` char(50) default NULL, `fontcolor1_name` char(50) default NULL, `fontcolor2_name` char(50) default NULL, `fontcolor3_name` char(50) default NULL, `span_class1_name` char(50) default NULL, `span_class2_name` char(50) default NULL, `span_class3_name` char(50) default NULL, PRIMARY KEY (`themes_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbthemes_name` -- LOCK TABLES `nuke_bbthemes_name` WRITE; /*!40000 ALTER TABLE `nuke_bbthemes_name` DISABLE KEYS */; INSERT INTO `nuke_bbthemes_name` VALUES (1,'The lightest row colour','The medium row color','The darkest row colour','','','','Border round the whole page','Outer table border','Inner table border','Silver gradient picture','Blue gradient picture','Fade-out gradient on index','Background for quote boxes','All white areas','','Background for topic posts','2nd background for topic posts','','Main fonts','Additional topic title font','Form fonts','Smallest font size','Medium font size','Normal font size (post body etc)','Quote & copyright text','Code text colour','Main table header text colour','','',''); /*!40000 ALTER TABLE `nuke_bbthemes_name` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbtopics` -- DROP TABLE IF EXISTS `nuke_bbtopics`; CREATE TABLE `nuke_bbtopics` ( `topic_id` mediumint(8) unsigned NOT NULL auto_increment, `forum_id` smallint(8) unsigned NOT NULL default '0', `topic_title` char(60) NOT NULL default '', `topic_poster` mediumint(8) NOT NULL default '0', `topic_time` int(11) NOT NULL default '0', `topic_views` mediumint(8) unsigned NOT NULL default '0', `topic_replies` mediumint(8) unsigned NOT NULL default '0', `topic_status` tinyint(3) NOT NULL default '0', `topic_vote` tinyint(1) NOT NULL default '0', `topic_type` tinyint(3) NOT NULL default '0', `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0', `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0', `topic_moved_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`topic_id`), KEY `forum_id` (`forum_id`), KEY `topic_moved_id` (`topic_moved_id`), KEY `topic_status` (`topic_status`), KEY `topic_type` (`topic_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbtopics` -- LOCK TABLES `nuke_bbtopics` WRITE; /*!40000 ALTER TABLE `nuke_bbtopics` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbtopics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbtopics_watch` -- DROP TABLE IF EXISTS `nuke_bbtopics_watch`; CREATE TABLE `nuke_bbtopics_watch` ( `topic_id` mediumint(8) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `notify_status` tinyint(1) NOT NULL default '0', KEY `topic_id` (`topic_id`), KEY `user_id` (`user_id`), KEY `notify_status` (`notify_status`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbtopics_watch` -- LOCK TABLES `nuke_bbtopics_watch` WRITE; /*!40000 ALTER TABLE `nuke_bbtopics_watch` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbtopics_watch` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbuser_group` -- DROP TABLE IF EXISTS `nuke_bbuser_group`; CREATE TABLE `nuke_bbuser_group` ( `group_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `user_pending` tinyint(1) default NULL, KEY `group_id` (`group_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbuser_group` -- LOCK TABLES `nuke_bbuser_group` WRITE; /*!40000 ALTER TABLE `nuke_bbuser_group` DISABLE KEYS */; INSERT INTO `nuke_bbuser_group` VALUES (1,-1,0),(3,5,0),(4,2,0),(5,3,0),(6,4,0); /*!40000 ALTER TABLE `nuke_bbuser_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbvote_desc` -- DROP TABLE IF EXISTS `nuke_bbvote_desc`; CREATE TABLE `nuke_bbvote_desc` ( `vote_id` mediumint(8) unsigned NOT NULL auto_increment, `topic_id` mediumint(8) unsigned NOT NULL default '0', `vote_text` text NOT NULL, `vote_start` int(11) NOT NULL default '0', `vote_length` int(11) NOT NULL default '0', PRIMARY KEY (`vote_id`), KEY `topic_id` (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbvote_desc` -- LOCK TABLES `nuke_bbvote_desc` WRITE; /*!40000 ALTER TABLE `nuke_bbvote_desc` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbvote_desc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbvote_results` -- DROP TABLE IF EXISTS `nuke_bbvote_results`; CREATE TABLE `nuke_bbvote_results` ( `vote_id` mediumint(8) unsigned NOT NULL default '0', `vote_option_id` tinyint(4) unsigned NOT NULL default '0', `vote_option_text` varchar(255) NOT NULL default '', `vote_result` int(11) NOT NULL default '0', KEY `vote_option_id` (`vote_option_id`), KEY `vote_id` (`vote_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbvote_results` -- LOCK TABLES `nuke_bbvote_results` WRITE; /*!40000 ALTER TABLE `nuke_bbvote_results` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbvote_results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbvote_voters` -- DROP TABLE IF EXISTS `nuke_bbvote_voters`; CREATE TABLE `nuke_bbvote_voters` ( `vote_id` mediumint(8) unsigned NOT NULL default '0', `vote_user_id` mediumint(8) NOT NULL default '0', `vote_user_ip` char(8) NOT NULL default '', KEY `vote_id` (`vote_id`), KEY `vote_user_id` (`vote_user_id`), KEY `vote_user_ip` (`vote_user_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbvote_voters` -- LOCK TABLES `nuke_bbvote_voters` WRITE; /*!40000 ALTER TABLE `nuke_bbvote_voters` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbvote_voters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_bbwords` -- DROP TABLE IF EXISTS `nuke_bbwords`; CREATE TABLE `nuke_bbwords` ( `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word` char(100) NOT NULL default '', `replacement` char(100) NOT NULL default '', PRIMARY KEY (`word_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_bbwords` -- LOCK TABLES `nuke_bbwords` WRITE; /*!40000 ALTER TABLE `nuke_bbwords` DISABLE KEYS */; /*!40000 ALTER TABLE `nuke_bbwords` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_blocks` -- DROP TABLE IF EXISTS `nuke_blocks`; CREATE TABLE `nuke_blocks` ( `bid` int(10) NOT NULL auto_increment, `bkey` varchar(15) NOT NULL default '', `title` varchar(60) NOT NULL default '', `content` text NOT NULL, `url` varchar(200) NOT NULL default '', `bposition` char(1) NOT NULL default '', `weight` int(10) NOT NULL default '1', `active` int(1) NOT NULL default '1', `refresh` int(10) NOT NULL default '0', `time` varchar(14) NOT NULL default '0', `blanguage` varchar(30) NOT NULL default '', `blockfile` varchar(255) NOT NULL default '', `view` int(1) NOT NULL default '0', `expire` varchar(14) NOT NULL default '0', `action` char(1) NOT NULL default '', `subscription` int(1) NOT NULL default '0', PRIMARY KEY (`bid`), KEY `bid` (`bid`), KEY `title` (`title`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_blocks` -- LOCK TABLES `nuke_blocks` WRITE; /*!40000 ALTER TABLE `nuke_blocks` DISABLE KEYS */; INSERT INTO `nuke_blocks` VALUES (1,'','Modulos','','','l',2,1,0,'','','block-Modules.php',0,'0','d',0),(2,'admin','Administration','· Administration
\r\n· NEW Story
\r\n· Change Survey
\r\n· Content
\r\n· Logout','','l',3,1,0,'985591188','','',2,'0','d',0),(3,'','Quem está online','','','r',5,1,0,'','','block-Who_is_Online.php',0,'0','d',0),(4,'','Busca','','','l',4,1,0,'','','block-Search.php',0,'0','d',0),(5,'','Languages','','','l',5,0,3600,'','','block-Languages.php',0,'0','d',0),(6,'','Random Headlines','','','l',6,0,3600,'','','block-Random_Headlines.php',0,'0','d',0),(8,'userbox','User\'s Custom Box','','','r',1,1,0,'','','',1,'0','d',0),(9,'','Categories Menu','','','r',2,0,0,'','','block-Categories.php',0,'0','d',0),(10,'','Enquetes','','','r',3,1,0,'','','block-Survey.php',0,'0','d',0),(11,'','Login','','','r',4,1,3600,'','','block-Login.php',3,'0','d',0),(12,'','Big Story of Today','','','r',6,0,3600,'','','block-Big_Story_of_Today.php',0,'0','d',0),(13,'','Artigos Antigos','','','r',7,1,0,'','','block-Old_Articles.php',0,'0','d',0),(14,'','Information','
\r\n\"Powered\r\n

\r\n\"Valid\r\n

\r\n\"Valid

','','r',8,0,0,'','','',0,'0','d',0),(15,'','Links Úteis',' \r\n \r\nWebmail
\r\nHelpdesk
\r\nAlterar Senha E-mail
\r\nAlterar Senha Internet
\r\nAlterar Senha Rede
\r\nAgenda Corporativa
\r\n','','l',1,1,0,'','','',0,'0','d',0); /*!40000 ALTER TABLE `nuke_blocks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nuke_cities` -- DROP TABLE IF EXISTS `nuke_cities`; CREATE TABLE `nuke_cities` ( `id` mediumint(4) NOT NULL default '0', `local_id` mediumint(3) NOT NULL default '0', `city` varchar(65) NOT NULL default '', `cc` char(2) NOT NULL default '', `country` varchar(35) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `nuke_cities` -- LOCK TABLES `nuke_cities` WRITE; /*!40000 ALTER TABLE `nuke_cities` DISABLE KEYS */; INSERT INTO `nuke_cities` VALUES (1,1,'Asâdâbâd','af','Afghanistan'),(2,2,'Âybak','af','Afghanistan'),(3,3,'Baghlân','af','Afghanistan'),(4,4,'Balkh','af','Afghanistan'),(5,5,'Bâmîyân','af','Afghanistan'),(6,6,'Chaghcharân','af','Afghanistan'),(7,7,'Chârîkâr','af','Afghanistan'),(8,8,'Farâh','af','Afghanistan'),(9,9,'Fayzâbâd','af','Afghanistan'),(10,10,'Ghardez','af','Afghanistan'),(11,11,'Ghazni','af','Afghanistan'),(12,12,'Herât','af','Afghanistan'),(13,13,'Jalâlâbâd','af','Afghanistan'),(14,14,'Kâbul','af','Afghanistan'),(15,15,'Khânâbâd','af','Afghanistan'),(16,16,'Khawst','af','Afghanistan'),(17,17,'Kholm','af','Afghanistan'),(18,18,'Lashkar Gâh','af','Afghanistan'),(19,19,'Mahmûd-e Râqî','af','Afghanistan'),(20,20,'Maydânshahr','af','Afghanistan'),(21,21,'Maymânah','af','Afghanistan'),(22,22,'Mazâr-e Sharîf','af','Afghanistan'),(23,23,'Mehtar Lâm','af','Afghanistan'),(24,24,'Nûristân','af','Afghanistan'),(25,25,'Pol-e Alam','af','Afghanistan'),(26,26,'Pol-e Khumri','af','Afghanistan'),(27,27,'Qal´eh-ye Naw','af','Afghanistan'),(28,28,'Qalât-e Ghilzay','af','Afghanistan'),(29,29,'Qandahâr','af','Afghanistan'),(30,30,'Qundûz','af','Afghanistan'),(31,31,'Sar-e Pul','af','Afghanistan'),(32,32,'Shibarghan','af','Afghanistan'),(33,33,'Tâloqân','af','Afghanistan'),(34,34,'Tarîn Kawt','af','Afghanistan'),(35,35,'Zaranj','af','Afghanistan'),(36,36,'Zareh Sharan','af','Afghanistan'),(37,1,'Bajram Curri','al','Albania'),(38,2,'Ballsh','al','Albania'),(39,3,'Berat','al','Albania'),(40,4,'Bilisht','al','Albania'),(41,5,'Bulqizë','al','Albania'),(42,6,'Burrel','al','Albania'),(43,7,'Çorovodë','al','Albania'),(44,8,'Delvinë','al','Albania'),(45,9,'Durrës','al','Albania'),(46,10,'Elbasan','al','Albania'),(47,11,'Ersekë','al','Albania'),(48,12,'Fier','al','Albania'),(49,13,'Gjirokastër','al','Albania'),(50,14,'Gramsh','al','Albania'),(51,15,'Kavajë','al','Albania'),(52,16,'Koplik','al','Albania'),(53,17,'Korçë','al','Albania'),(54,18,'Krujë','al','Albania'),(55,19,'Krumë','al','Albania'),(56,20,'Kuçovë','al','Albania'),(57,21,'Kukës','al','Albania'),(58,22,'Laç','al','Albania'),(59,23,'Lezhë','al','Albania'),(60,24,'Librazhd','al','Albania'),(61,25,'Lushnjë','al','Albania'),(62,26,'Patos','al','Albania'),(63,27,'Peqin','al','Albania'),(64,28,'Përmet','al','Albania'),(65,29,'Peshkopi','al','Albania'),(66,30,'Pogradec','al','Albania'),(67,31,'Pukë','al','Albania'),(68,32,'Rrëshen','al','Albania'),(69,33,'Sarandë','al','Albania'),(70,34,'Shkodër','al','Albania'),(71,35,'Tepelenë','al','Albania'),(72,36,'Tiranë','al','Albania'),(73,37,'Vlorë','al','Albania'),(74,1,'´Ayn Baydâ','dz','Algeria'),(75,2,'´Ayn Daflah','dz','Algeria'),(76,3,'´Ayn Tamûshanat','dz','Algeria'),(77,4,'Adrâr','dz','Algeria'),(78,5,'al-´Ulmah','dz','Algeria'),(79,6,'al-Aghwât','dz','Algeria'),(80,7,'al-Bayadh','dz','Algeria'),(81,8,'al-Bûnî','dz','Algeria'),(82,9,'al-Jazâ´ir','dz','Algeria'),(83,10,'al-Wâd','dz','Algeria'),(84,11,'Annâbah','dz','Algeria'),(85,12,'ash-Shalif','dz','Algeria'),(86,13,'at-Tarif','dz','Algeria'),(87,14,'Bab Azwâr','dz','Algeria'),(88,15,'Bashshar','dz','Algeria'),(89,16,'Bâtnah','dz','Algeria'),(90,17,'Bijâyah','dz','Algeria'),(91,18,'Biskrah','dz','Algeria'),(92,19,'Blîdah','dz','Algeria'),(93,20,'Bû Sâ´adah','dz','Algeria'),(94,21,'Bûîrah','dz','Algeria'),(95,22,'Bumardas','dz','Algeria'),(96,23,'Burj Bû Arrîrij','dz','Algeria'),(97,24,'Burj-al-Kiffan','dz','Algeria'),(98,25,'Ghâlizân','dz','Algeria'),(99,26,'Ghardâyah','dz','Algeria'),(100,27,'Ilizi','dz','Algeria'),(101,28,'Jîjîlî','dz','Algeria'),(102,29,'Jilfah','dz','Algeria'),(103,30,'Khanshalah','dz','Algeria'),(104,31,'Masîlah','dz','Algeria'),(105,32,'Midyah','dz','Algeria'),(106,33,'Mîlah','dz','Algeria'),(107,34,'Muaskar','dz','Algeria'),(108,35,'Mustaghanam','dz','Algeria'),(109,36,'Naama','dz','Algeria'),(110,37,'Qalmah','dz','Algeria'),(111,38,'Qustantînah','dz','Algeria'),(112,39,'Sakîkdah','dz','Algeria'),(113,40,'Satîf','dz','Algeria'),(114,41,'Saydâ\'','dz','Algeria'),(115,42,'Sîdî ban-al-´Abbas','dz','Algeria'),(116,43,'Sûq Ahrâs','dz','Algeria'),(117,44,'Tamanghâsat','dz','Algeria'),(118,45,'Tibâzah','dz','Algeria'),(119,46,'Tibissah','dz','Algeria'),(120,47,'Tîlîmsân','dz','Algeria'),(121,48,'Tindûf','dz','Algeria'),(122,49,'Tîsamsîlt','dz','Algeria'),(123,50,'Tiyârat','dz','Algeria'),(124,51,'Tîzî Wazû','dz','Algeria'),(125,52,'Umm-al-Bawâghî','dz','Algeria'),(126,53,'Wahrân','dz','Algeria'),(127,54,'Warqlâ','dz','Algeria'),(128,1,'Aoloau','as','American Samoa'),(129,2,'Aua','as','American Samoa'),(130,3,'Faga\'alu','as','American Samoa'),(131,4,'Fagasa','as','American Samoa'),(132,5,'Fagatogo','as','American Samoa'),(133,6,'Faleniu','as','American Samoa'),(134,7,'Futiga','as','American Samoa'),(135,8,'Ili\'ili','as','American Samoa'),(136,9,'Lauli\'i','as','American Samoa'),(137,10,'Leone','as','American Samoa'),(138,11,'Malaeimi','as','American Samoa'),(139,12,'Mapusagafou','as','American Samoa'),(140,13,'Nu\'uuli','as','American Samoa'),(141,14,'Ofu','as','American Samoa'),(142,15,'Pago Pago','as','American Samoa'),(143,16,'Pava\'ia\'i','as','American Samoa'),(144,17,'Swains','as','American Samoa'),(145,18,'Tafuna','as','American Samoa'),(146,19,'Taputimu','as','American Samoa'),(147,20,'Utulei','as','American Samoa'),(148,21,'Vailoatai','as','American Samoa'),(149,22,'Vaitogi','as','American Samoa'),(150,1,'Andorra la Vella','ad','Andorra'),(151,2,'Canillo','ad','Andorra'),(152,3,'Encamp','ad','Andorra'),(153,4,'La Massana','ad','Andorra'),(154,5,'Les Escaldes','ad','Andorra'),(155,6,'Ordino','ad','Andorra'),(156,7,'Sant Julià de Lòria','ad','Andorra'),(157,1,'Benguela','ao','Angola'),(158,2,'Caála','ao','Angola'),(159,3,'Cabinda','ao','Angola'),(160,4,'Caxito','ao','Angola'),(161,5,'Chissamba','ao','Angola'),(162,6,'Huambo','ao','Angola'),(163,7,'Kuito','ao','Angola'),(164,8,'Lobito','ao','Angola'),(165,9,'Luanda','ao','Angola'),(166,10,'Lubango','ao','Angola'),(167,11,'Lucapa','ao','Angola'),(168,12,'Luena','ao','Angola'),(169,13,'Malanje','ao','Angola'),(170,14,'M\'banza-Kongo','ao','Angola'),(171,15,'Menongue','ao','Angola'),(172,16,'Namibe','ao','Angola'),(173,17,'N\'dalatando','ao','Angola'),(174,18,'Ondjiva','ao','Angola'),(175,19,'Saurimo','ao','Angola'),(176,20,'Soyo','ao','Angola'),(177,21,'Sumbe','ao','Angola'),(178,22,'Uíge','ao','Angola'),(179,23,'Waku-Kungo','ao','Angola'),(180,1,'Sandy Ground','ai','Anguilla'),(181,2,'The Valley','ai','Anguilla'),(182,1,'Amundsen-Scott','aq','Antarctica'),(183,2,'Bellingshausen','aq','Antarctica'),(184,3,'Capitán Arturo Prat','aq','Antarctica'),(185,4,'Casey','aq','Antarctica'),(186,5,'Chang Cheng','aq','Antarctica'),(187,6,'Davis','aq','Antarctica'),(188,7,'Dumont d\'Urville','aq','Antarctica'),(189,8,'Escudero','aq','Antarctica'),(190,9,'Esperanza','aq','Antarctica'),(191,10,'General Belgrano II','aq','Antarctica'),(192,11,'General Bernardo O\'Higgins','aq','Antarctica'),(193,12,'MacMurdo','aq','Antarctica'),(194,13,'Maitri','aq','Antarctica'),(195,14,'Mirnyj','aq','Antarctica'),(196,15,'Molodezhnaya','aq','Antarctica'),(197,16,'Novolazarovskaya','aq','Antarctica'),(198,17,'Presidente Eduardo Frei Montalva','aq','Antarctica'),(199,18,'Rothera','aq','Antarctica'),(200,19,'Syowa','aq','Antarctica'),(201,20,'Vicecomodoro Marambio','aq','Antarctica'),(202,1,'All Saints','ag','Antigua & Barbuda'),(203,2,'Bolands','ag','Antigua & Barbuda'),(204,3,'Carlisle','ag','Antigua & Barbuda'),(205,4,'Cedar Grove','ag','Antigua & Barbuda'),(206,5,'Codrington','ag','Antigua & Barbuda'),(207,6,'English Harbour','ag','Antigua & Barbuda'),(208,7,'Falmouth','ag','Antigua & Barbuda'),(209,8,'Freetown','ag','Antigua & Barbuda'),(210,9,'Jennings','ag','Antigua & Barbuda'),(211,10,'Liberta','ag','Antigua & Barbuda'),(212,11,'Old Road','ag','Antigua & Barbuda'),(213,12,'Parham','ag','Antigua & Barbuda'),(214,13,'Saint John\'s','ag','Antigua & Barbuda'),(215,14,'Swetes','ag','Antigua & Barbuda'),(216,15,'Willikies','ag','Antigua & Barbuda'),(217,1,'Bahía Blanca','ar','Argentina'),(218,2,'Buenos Aires','ar','Argentina'),(219,3,'Catamarca','ar','Argentina'),(220,4,'Comodoro Rivadavia','ar','Argentina'),(221,5,'Concordia','ar','Argentina'),(222,6,'Córdoba','ar','Argentina'),(223,7,'Corrientes','ar','Argentina'),(224,8,'Formosa','ar','Argentina'),(225,9,'Jujuy','ar','Argentina'),(226,10,'La Plata','ar','Argentina'),(227,11,'La Rioja','ar','Argentina'),(228,12,'Mar del Plata','ar','Argentina'),(229,13,'Mendoza','ar','Argentina'),(230,14,'Mercedes','ar','Argentina'),(231,15,'Neuquén','ar','Argentina'),(232,16,'Paraná','ar','Argentina'),(233,17,'Posadas','ar','Argentina'),(234,18,'Rawson','ar','Argentina'),(235,19,'Resistencia','ar','Argentina'),(236,20,'Río Cuarto','ar','Argentina'),(237,21,'Río Gallegos','ar','Argentina'),(238,22,'Rosario','ar','Argentina'),(239,23,'Salta','ar','Argentina'),(240,24,'San Carlos de Bariloche','ar','Argentina'),(241,25,'San Juan','ar','Argentina'),(242,26,'San Luis','ar','Argentina'),(243,27,'San Nicolás','ar','Argentina'),(244,28,'San Rafael','ar','Argentina'),(245,29,'Santa Fé','ar','Argentina'),(246,30,'Santa Rosa','ar','Argentina'),(247,31,'Santiago del Estero','ar','Argentina'),(248,32,'Tandil','ar','Argentina'),(249,33,'Trelew','ar','Argentina'),(250,34,'Tucumán','ar','Argentina'),(251,35,'Ushuaia','ar','Argentina'),(252,36,'Viedma','ar','Argentina'),(253,1,'Abovyan','am','Armenia'),(254,2,'Alaverdi','am','Armenia'),(255,3,'Ararat','am','Armenia'),(256,4,'Armavir','am','Armenia'),(257,5,'Artashat','am','Armenia'),(258,6,'Artik','am','Armenia'),(259,7,'Ashtarak','am','Armenia'),(260,8,'Charentsavan','am','Armenia'),(261,9,'Dilijan','am','Armenia'),(262,10,'Gavar','am','Armenia'),(263,11,'Goris','am','Armenia'),(264,12,'Gyumri','am','Armenia'),(265,13,'Hrazdan','am','Armenia'),(266,14,'Ijevan','am','Armenia'),(267,15,'Kapan','am','Armenia'),(268,16,'Sevan','am','Armenia'),(269,17,'Stepanavan','am','Armenia'),(270,18,'Vagharshapat','am','Armenia'),(271,19,'Vanadzor','am','Armenia'),(272,20,'Vardenis','am','Armenia'),(273,21,'Yegheknadzor','am','Armenia'),(274,22,'Yerevan','am','Armenia'),(275,1,'Oranjestad','aw','Aruba'),(276,2,'Sint Nicolas','aw','Aruba'),(277,1,'Adelaide','au','Australia'),(278,2,'Albury-Wodonga','au','Australia'),(279,3,'Ballarat','au','Australia'),(280,4,'Brisbane','au','Australia'),(281,5,'Cairns','au','Australia'),(282,6,'Canberra','au','Australia'),(283,7,'Darwin','au','Australia'),(284,8,'Geelong','au','Australia'),(285,9,'Gold Coast','au','Australia'),(286,10,'Hobart','au','Australia'),(287,11,'Launceston','au','Australia'),(288,12,'Melbourne','au','Australia'),(289,13,'Newcastle','au','Australia'),(290,14,'Perth','au','Australia'),(291,15,'Shoalhaven','au','Australia'),(292,16,'Sunshine Coast','au','Australia'),(293,17,'Sydney','au','Australia'),(294,18,'Toowoomba','au','Australia'),(295,19,'Townsville','au','Australia'),(296,20,'Wollongong','au','Australia'),(297,1,'Baden','at','Austria'),(298,2,'Bregenz','at','Austria'),(299,3,'Dornbirn','at','Austria'),(300,4,'Eisenstadt','at','Austria'),(301,5,'Feldkirch','at','Austria'),(302,6,'Graz','at','Austria'),(303,7,'Innsbruck','at','Austria'),(304,8,'Klagenfurt','at','Austria'),(305,9,'Klosterneuburg','at','Austria'),(306,10,'Krems','at','Austria'),(307,11,'Leoben','at','Austria'),(308,12,'Linz','at','Austria'),(309,13,'Salzburg','at','Austria'),(310,14,'Sankt Pölten','at','Austria'),(311,15,'Steyr','at','Austria'),(312,16,'Traun','at','Austria'),(313,17,'Villach','at','Austria'),(314,18,'Wels','at','Austria'),(315,19,'Wien','at','Austria'),(316,20,'Wiener Neustadt','at','Austria'),(317,21,'Wolfsberg','at','Austria'),(318,1,'Äli Bayramli','az','Azerbaijan'),(319,2,'Bakixanov','az','Azerbaijan'),(320,3,'Baku','az','Azerbaijan'),(321,4,'Bärdä','az','Azerbaijan'),(322,5,'Biläcäri','az','Azerbaijan'),(323,6,'Gäncä','az','Azerbaijan'),(324,7,'Göyçay','az','Azerbaijan'),(325,8,'Hövsan','az','Azerbaijan'),(326,9,'Imisli','az','Azerbaijan'),(327,10,'Kälbäcär','az','Azerbaijan'),(328,11,'Länkäran','az','Azerbaijan'),(329,12,'Mastaga','az','Azerbaijan'),(330,13,'Mingäçevir','az','Azerbaijan'),(331,14,'Naxçivan','az','Azerbaijan'),(332,15,'Qarasuxur','az','Azerbaijan'),(333,16,'Qazax','az','Azerbaijan'),(334,17,'Räsulzadä','az','Azerbaijan'),(335,18,'Säki','az','Azerbaijan'),(336,19,'Salyan','az','Azerbaijan'),(337,20,'Sumqayit','az','Azerbaijan'),(338,21,'Xaçmaz','az','Azerbaijan'),(339,22,'Xankändi','az','Azerbaijan'),(340,23,'Yevlax','az','Azerbaijan'),(341,1,'Alice Town','bs','Bahamas'),(342,2,'Andros Town','bs','Bahamas'),(343,3,'Arthur\'s Town','bs','Bahamas'),(344,4,'Clarence Town','bs','Bahamas'),(345,5,'Cockburn Town','bs','Bahamas'),(346,6,'Colonel Hill','bs','Bahamas'),(347,7,'Coopers Town','bs','Bahamas'),(348,8,'Duncan Town','bs','Bahamas'),(349,9,'Dunmore Town','bs','Bahamas'),(350,10,'Freeport','bs','Bahamas'),(351,11,'Freetown','bs','Bahamas'),(352,12,'George Town','bs','Bahamas'),(353,13,'Great Harbour','bs','Bahamas'),(354,14,'High Rock','bs','Bahamas'),(355,15,'Marsh Harbour','bs','Bahamas'),(356,16,'Matthew Town','bs','Bahamas'),(357,17,'Nassau','bs','Bahamas'),(358,18,'Nicholls Town','bs','Bahamas'),(359,19,'Pirates Well','bs','Bahamas'),(360,20,'Port Nelson','bs','Bahamas'),(361,21,'Rock Sound','bs','Bahamas'),(362,22,'Snug Corner','bs','Bahamas'),(363,23,'Sweeting Cay','bs','Bahamas'),(364,24,'West End','bs','Bahamas'),(365,1,'´Îsâ','bh','Bahrain'),(366,2,'al-Manâmah','bh','Bahrain'),(367,3,'al-Muharraq','bh','Bahrain'),(368,4,'ar-Rifa´a','bh','Bahrain'),(369,5,'Hidd','bh','Bahrain'),(370,6,'Jidd Hafs','bh','Bahrain'),(371,7,'Sitrah','bh','Bahrain'),(372,1,'Bâgar Hât','bd','Bangladesh'),(373,2,'Bândarban','bd','Bangladesh'),(374,3,'Barguna','bd','Bangladesh'),(375,4,'Barîsâl','bd','Bangladesh'),(376,5,'Begamganj','bd','Bangladesh'),(377,6,'Bholâ','bd','Bangladesh'),(378,7,'Bogorâ','bd','Bangladesh'),(379,8,'Brâhman Bâriya','bd','Bangladesh'),(380,9,'Chândpûr','bd','Bangladesh'),(381,10,'Châttagâm','bd','Bangladesh'),(382,11,'Chuâdângâ','bd','Bangladesh'),(383,12,'Dhâka','bd','Bangladesh'),(384,13,'Dinâjpûr','bd','Bangladesh'),(385,14,'Farîdpûr','bd','Bangladesh'),(386,15,'Fenî','bd','Bangladesh'),(387,16,'Gâybândâ','bd','Bangladesh'),(388,17,'Gâzîpûr','bd','Bangladesh'),(389,18,'Gopâlganj','bd','Bangladesh'),(390,19,'Habîganj','bd','Bangladesh'),(391,20,'Jaipûr Hât','bd','Bangladesh'),(392,21,'Jamâlpûr','bd','Bangladesh'),(393,22,'Jessor','bd','Bangladesh'),(394,23,'Jhâlâkâtî','bd','Bangladesh'),(395,24,'Jhanaydâh','bd','Bangladesh'),(396,25,'Khagrachari','bd','Bangladesh'),(397,26,'Khulnâ','bd','Bangladesh'),(398,27,'Kishorganj','bd','Bangladesh'),(399,28,'Koks Bâzâr','bd','Bangladesh'),(400,29,'Komîllâ','bd','Bangladesh'),(401,30,'Kurîgrâm','bd','Bangladesh'),(402,31,'Kushtiyâ','bd','Bangladesh'),(403,32,'Lakshmîpûr','bd','Bangladesh'),(404,33,'Lâlmanîr Hât','bd','Bangladesh'),(405,34,'Madârîpûr','bd','Bangladesh'),(406,35,'Mâgura','bd','Bangladesh'),(407,36,'Maimansingh','bd','Bangladesh'),(408,37,'Mânikganj','bd','Bangladesh'),(409,38,'Maulvi Bâzâr','bd','Bangladesh'),(410,39,'Meherpur','bd','Bangladesh'),(411,40,'Munshiganj','bd','Bangladesh'),(412,41,'Narâl','bd','Bangladesh'),(413,42,'Nârâyanganj','bd','Bangladesh'),(414,43,'Narsingdi','bd','Bangladesh'),(415,44,'Nator','bd','Bangladesh'),(416,45,'Naugâon','bd','Bangladesh'),(417,46,'Nawâbganj','bd','Bangladesh'),(418,47,'Netrâkonâ','bd','Bangladesh'),(419,48,'Nilphâmâri','bd','Bangladesh'),(420,49,'Noâkhâli','bd','Bangladesh'),(421,50,'Pâbna','bd','Bangladesh'),(422,51,'Pâlang','bd','Bangladesh'),(423,52,'Panchagarh','bd','Bangladesh'),(424,53,'Patûâkhâlî','bd','Bangladesh'),(425,54,'Pirojpûr','bd','Bangladesh'),(426,55,'Rajbârî','bd','Bangladesh'),(427,56,'Râjshâhî','bd','Bangladesh'),(428,57,'Rângâmâtî','bd','Bangladesh'),(429,58,'Rangpûr','bd','Bangladesh'),(430,59,'Sa´idpur','bd','Bangladesh'),(431,60,'Sâtkhîrâ','bd','Bangladesh'),(432,61,'Sherpûr','bd','Bangladesh'),(433,62,'Silhat','bd','Bangladesh'),(434,63,'Sirâjganj','bd','Bangladesh'),(435,64,'Sûnâmganj','bd','Bangladesh'),(436,65,'Tangâyal','bd','Bangladesh'),(437,66,'Thâkurgâon','bd','Bangladesh'),(438,67,'Tungî','bd','Bangladesh'),(439,1,'Bathsheba','bb','Barbados'),(440,2,'Blackmans','bb','Barbados'),(441,3,'Bridgetown','bb','Barbados'),(442,4,'Bulkeley','bb','Barbados'),(443,5,'Crab Hill','bb','Barbados'),(444,6,'Crane','bb','Barbados'),(445,7,'Greenland','bb','Barbados'),(446,8,'Hillaby','bb','Barbados'),(447,9,'Holetown','bb','Barbados'),(448,10,'Oistins','bb','Barbados'),(449,11,'Speightstown','bb','Barbados'),(450,1,'Babrujsk','by','Belarus'),(451,2,'Baranavichy','by','Belarus'),(452,3,'Barisaw','by','Belarus'),(453,4,'Brèst','by','Belarus'),(454,5,'Homjel\'','by','Belarus'),(455,6,'Hrodna','by','Belarus'),(456,7,'Lida','by','Belarus'),(457,8,'Mahiljow','by','Belarus'),(458,9,'Maladzechna','by','Belarus'),(459,10,'Mazyr','by','Belarus'),(460,11,'Minsk','by','Belarus'),(461,12,'Navapolack','by','Belarus'),(462,13,'Orsha','by','Belarus'),(463,14,'Pinsk','by','Belarus'),(464,15,'Polack','by','Belarus'),(465,16,'Rèchyca','by','Belarus'),(466,17,'Salihorsk','by','Belarus'),(467,18,'Svetlahorsk','by','Belarus'),(468,19,'Vicebsk','by','Belarus'),(469,20,'Zhlobin','by','Belarus'),(470,1,'Aalst','be','Belgium'),(471,2,'Antwerpen','be','Belgium'),(472,3,'Arlon','be','Belgium'),(473,4,'Brugge','be','Belgium'),(474,5,'Brussel','be','Belgium'),(475,6,'Charleroi','be','Belgium'),(476,7,'Genk','be','Belgium'),(477,8,'Gent','be','Belgium'),(478,9,'Hasselt','be','Belgium'),(479,10,'Kortrijk','be','Belgium'),(480,11,'La Louvière','be','Belgium'),(481,12,'Leuven','be','Belgium'),(482,13,'Liège','be','Belgium'),(483,14,'Mechelen','be','Belgium'),(484,15,'Mons','be','Belgium'),(485,16,'Namur','be','Belgium'),(486,17,'Oostende','be','Belgium'),(487,18,'Roeselare','be','Belgium'),(488,19,'Seraing','be','Belgium'),(489,20,'Sint-Niklaas','be','Belgium'),(490,21,'Tournai','be','Belgium'),(491,22,'Wavre','be','Belgium'),(492,1,'Belize','bz','Belize'),(493,2,'Belmopan','bz','Belize'),(494,3,'Benque Viejo','bz','Belize'),(495,4,'Corozal','bz','Belize'),(496,5,'Dangriga','bz','Belize'),(497,6,'Orange Walk','bz','Belize'),(498,7,'Punta Gorda','bz','Belize'),(499,8,'San Ignacio','bz','Belize'),(500,9,'San Pedro','bz','Belize'),(501,1,'Abomey','bj','Benin'),(502,2,'Bohicon','bj','Benin'),(503,3,'Comé','bj','Benin'),(504,4,'Cotonou','bj','Benin'),(505,5,'Cové','bj','Benin'),(506,6,'Djougou','bj','Benin'),(507,7,'Dogbo','bj','Benin'),(508,8,'Kandi','bj','Benin'),(509,9,'Kouandé','bj','Benin'),(510,10,'Lokossa','bj','Benin'),(511,11,'Malanville','bj','Benin'),(512,12,'Natitingou','bj','Benin'),(513,13,'Nikki','bj','Benin'),(514,14,'Ouidah','bj','Benin'),(515,15,'Parakou','bj','Benin'),(516,16,'Pobé','bj','Benin'),(517,17,'Porto Novo','bj','Benin'),(518,18,'Sakété','bj','Benin'),(519,19,'Savalou','bj','Benin'),(520,20,'Savé','bj','Benin'),(521,1,'Hamilton','bm','Bermuda'),(522,2,'Saint George','bm','Bermuda'),(523,1,'Chhukha','bt','Bhutan'),(524,2,'Damphu','bt','Bhutan'),(525,3,'Gasa','bt','Bhutan'),(526,4,'Geylegphug','bt','Bhutan'),(527,5,'Ha','bt','Bhutan'),(528,6,'Jakar','bt','Bhutan'),(529,7,'Lhuntshi','bt','Bhutan'),(530,8,'Mongar','bt','Bhutan'),(531,9,'Paro','bt','Bhutan'),(532,10,'Pemagatsel','bt','Bhutan'),(533,11,'Phuntsholing','bt','Bhutan'),(534,12,'Punakha','bt','Bhutan'),(535,13,'Samchi','bt','Bhutan'),(536,14,'Samdrup Jongkhar','bt','Bhutan'),(537,15,'Shemgang','bt','Bhutan'),(538,16,'Taga Dzong','bt','Bhutan'),(539,17,'Tashigang','bt','Bhutan'),(540,18,'Timphu','bt','Bhutan'),(541,19,'Tongsa','bt','Bhutan'),(542,20,'Wangdiphodrang','bt','Bhutan'),(543,1,'Bermejo','bo','Bolivia'),(544,2,'Camiri','bo','Bolivia'),(545,3,'Cobija','bo','Bolivia'),(546,4,'Cochabamba','bo','Bolivia'),(547,5,'El Alto','bo','Bolivia'),(548,6,'Guayaramerín','bo','Bolivia'),(549,7,'La Paz','bo','Bolivia'),(550,8,'Llallagua','bo','Bolivia'),(551,9,'Montero','bo','Bolivia'),(552,10,'Oruro','bo','Bolivia'),(553,11,'Potosí','bo','Bolivia'),(554,12,'Riberalta','bo','Bolivia'),(555,13,'San Ignacio','bo','Bolivia'),(556,14,'Santa Cruz','bo','Bolivia'),(557,15,'Sucre','bo','Bolivia'),(558,16,'Tarija','bo','Bolivia'),(559,17,'Trinidad','bo','Bolivia'),(560,18,'Tupiza','bo','Bolivia'),(561,19,'Villazón','bo','Bolivia'),(562,20,'Yacuíba','bo','Bolivia'),(563,1,'Banja Luka','ba','Bosnia-Herzegovina'),(564,2,'Bihac','ba','Bosnia-Herzegovina'),(565,3,'Bijeljina','ba','Bosnia-Herzegovina'),(566,4,'Bosanska Krupa','ba','Bosnia-Herzegovina'),(567,5,'Brchko','ba','Bosnia-Herzegovina'),(568,6,'Bugojno','ba','Bosnia-Herzegovina'),(569,7,'Cazin','ba','Bosnia-Herzegovina'),(570,8,'Doboj','ba','Bosnia-Herzegovina'),(571,9,'Focha','ba','Bosnia-Herzegovina'),(572,10,'Gorazhde','ba','Bosnia-Herzegovina'),(573,11,'Konjic','ba','Bosnia-Herzegovina'),(574,12,'Mostar','ba','Bosnia-Herzegovina'),(575,13,'Prijedor','ba','Bosnia-Herzegovina'),(576,14,'Sarajevo','ba','Bosnia-Herzegovina'),(577,15,'Travnik','ba','Bosnia-Herzegovina'),(578,16,'Trebinje','ba','Bosnia-Herzegovina'),(579,17,'Tuzla','ba','Bosnia-Herzegovina'),(580,18,'Velika Kladusha','ba','Bosnia-Herzegovina'),(581,19,'Visoko','ba','Bosnia-Herzegovina'),(582,20,'Zenica','ba','Bosnia-Herzegovina'),(583,1,'Bobonong','bw','Botswana'),(584,2,'Francistown','bw','Botswana'),(585,3,'Gaborone','bw','Botswana'),(586,4,'Ghanzi','bw','Botswana'),(587,5,'Gumare','bw','Botswana'),(588,6,'Hukuntsi','bw','Botswana'),(589,7,'Jwaneng','bw','Botswana'),(590,8,'Kanye','bw','Botswana'),(591,9,'Kasane','bw','Botswana'),(592,10,'Letlhakane','bw','Botswana'),(593,11,'Lobatse','bw','Botswana'),(594,12,'Mahalapye','bw','Botswana'),(595,13,'Masunga','bw','Botswana'),(596,14,'Maun','bw','Botswana'),(597,15,'Mochudi','bw','Botswana'),(598,16,'Mogoditshane','bw','Botswana'),(599,17,'Molepolole','bw','Botswana'),(600,18,'Moshupa','bw','Botswana'),(601,19,'Orapa','bw','Botswana'),(602,20,'Palapye','bw','Botswana'),(603,21,'Ramotswa','bw','Botswana'),(604,22,'Selibe Phikwe','bw','Botswana'),(605,23,'Serowe','bw','Botswana'),(606,24,'Shakawe','bw','Botswana'),(607,25,'Sowa','bw','Botswana'),(608,26,'Thamaga','bw','Botswana'),(609,27,'Tlokweng','bw','Botswana'),(610,28,'Tonota','bw','Botswana'),(611,29,'Tsabong','bw','Botswana'),(612,30,'Tutume','bw','Botswana'),(613,1,'Águas Lindas de Goiás','br','Brazil'),(614,2,'Alagoinhas','br','Brazil'),(615,3,'Alvorada','br','Brazil'),(616,4,'Americana','br','Brazil'),(617,5,'Ananindeua','br','Brazil'),(618,6,'Anápolis','br','Brazil'),(619,7,'Angra dos Reis','br','Brazil'),(620,8,'Aparecida de Goiânia','br','Brazil'),(621,9,'Apucarana','br','Brazil'),(622,10,'Aracaju','br','Brazil'),(623,11,'Araçatuba','br','Brazil'),(624,12,'Araguaína','br','Brazil'),(625,13,'Arapiraca','br','Brazil'),(626,14,'Araraquara','br','Brazil'),(627,15,'Araras','br','Brazil'),(628,16,'Atibaia','br','Brazil'),(629,17,'Barbacena','br','Brazil'),(630,18,'Barra Mansa','br','Brazil'),(631,19,'Barreiras','br','Brazil'),(632,20,'Barretos','br','Brazil'),(633,21,'Barueri','br','Brazil'),(634,22,'Bauru','br','Brazil'),(635,23,'Belém','br','Brazil'),(636,24,'Belford Roxo','br','Brazil'),(637,25,'Belo Horizonte','br','Brazil'),(638,26,'Betim','br','Brazil'),(639,27,'Blumenau','br','Brazil'),(640,28,'Boa Vista','br','Brazil'),(641,29,'Botucatu','br','Brazil'),(642,30,'Bragança Paulista','br','Brazil'),(643,31,'Brasília','br','Brazil'),(644,32,'Cabo de Santo Agostinho','br','Brazil'),(645,33,'Cabo Frio','br','Brazil'),(646,34,'Cachoeirinha','br','Brazil'),(647,35,'Cachoeiro de Itapemirim','br','Brazil'),(648,36,'Camaçari','br','Brazil'),(649,37,'Camaragibe','br','Brazil'),(650,38,'Campina Grande','br','Brazil'),(651,39,'Campinas','br','Brazil'),(652,40,'Campo Grande','br','Brazil'),(653,41,'Campos','br','Brazil'),(654,42,'Canoas','br','Brazil'),(655,43,'Carapicuíba','br','Brazil'),(656,44,'Cariacica','br','Brazil'),(657,45,'Caruaru','br','Brazil'),(658,46,'Cascavel','br','Brazil'),(659,47,'Castanhal','br','Brazil'),(660,48,'Catanduva','br','Brazil'),(661,49,'Caucaia','br','Brazil'),(662,50,'Caxias','br','Brazil'),(663,51,'Caxias do Sul','br','Brazil'),(664,52,'Chapecó','br','Brazil'),(665,53,'Colombo','br','Brazil'),(666,54,'Conselheiro Lafaiete','br','Brazil'),(667,55,'Contagem','br','Brazil'),(668,56,'Coronel Fabriciano','br','Brazil'),(669,57,'Cotia','br','Brazil'),(670,58,'Criciúma','br','Brazil'),(671,59,'Cubatão','br','Brazil'),(672,60,'Cuiabá','br','Brazil'),(673,61,'Curitiba','br','Brazil'),(674,62,'Diadema','br','Brazil'),(675,63,'Divinópolis','br','Brazil'),(676,64,'Dourados','br','Brazil'),(677,65,'Duque de Caxias','br','Brazil'),(678,66,'Embu','br','Brazil'),(679,67,'Feira de Santana','br','Brazil'),(680,68,'Ferraz de Vasconcelos','br','Brazil'),(681,69,'Florianópolis','br','Brazil'),(682,70,'Fortaleza','br','Brazil'),(683,71,'Foz do Iguaçu','br','Brazil'),(684,72,'Franca','br','Brazil'),(685,73,'Francisco Morato','br','Brazil'),(686,74,'Franco da Rocha','br','Brazil'),(687,75,'Garanhuns','br','Brazil'),(688,76,'Goiânia','br','Brazil'),(689,77,'Governador Valadares','br','Brazil'),(690,78,'Gravataí','br','Brazil'),(691,79,'Guarapuava','br','Brazil'),(692,80,'Guaratinguetá','br','Brazil'),(693,81,'Guarujá','br','Brazil'),(694,82,'Guarulhos','br','Brazil'),(695,83,'Hortolândia','br','Brazil'),(696,84,'Ibirité','br','Brazil'),(697,85,'Ilhéus','br','Brazil'),(698,86,'Imperatriz','br','Brazil'),(699,87,'Indaiatuba','br','Brazil'),(700,88,'Ipatinga','br','Brazil'),(701,89,'Itaboraí','br','Brazil'),(702,90,'Itabuna','br','Brazil'),(703,91,'Itajaí','br','Brazil'),(704,92,'Itapecerica da Serra','br','Brazil'),(705,93,'Itapetininga','br','Brazil'),(706,94,'Itapevi','br','Brazil'),(707,95,'Itaquaquecetuba','br','Brazil'),(708,96,'Itu','br','Brazil'),(709,97,'Jaboatão','br','Brazil'),(710,98,'Jacareí','br','Brazil'),(711,99,'Jandira','br','Brazil'),(712,100,'Jaraguá do Sul','br','Brazil'),(713,101,'Jaú','br','Brazil'),(714,102,'Jequié','br','Brazil'),(715,103,'João Pessoa','br','Brazil'),(716,104,'Joinville','br','Brazil'),(717,105,'Juazeiro','br','Brazil'),(718,106,'Juazeiro do Norte','br','Brazil'),(719,107,'Juiz de Fora','br','Brazil'),(720,108,'Jundiaí','br','Brazil'),(721,109,'Lages','br','Brazil'),(722,110,'Lauro de Freitas','br','Brazil'),(723,111,'Limeira','br','Brazil'),(724,112,'Londrina','br','Brazil'),(725,113,'Luziânia','br','Brazil'),(726,114,'Macaé','br','Brazil'),(727,115,'Macapá','br','Brazil'),(728,116,'Maceió','br','Brazil'),(729,117,'Magé','br','Brazil'),(730,118,'Manaus','br','Brazil'),(731,119,'Marabá','br','Brazil'),(732,120,'Maracanaú','br','Brazil'),(733,121,'Marília','br','Brazil'),(734,122,'Maringá','br','Brazil'),(735,123,'Mauá','br','Brazil'),(736,124,'Mogi Guaçu','br','Brazil'),(737,125,'Moji das Cruzes','br','Brazil'),(738,126,'Montes Claros','br','Brazil'),(739,127,'Mossoró','br','Brazil'),(740,128,'Natal','br','Brazil'),(741,129,'Nilópolis','br','Brazil'),(742,130,'Niterói','br','Brazil'),(743,131,'Nossa Senhora do Socorro','br','Brazil'),(744,132,'Nova Friburgo','br','Brazil'),(745,133,'Nova Iguaçu','br','Brazil'),(746,134,'Novo Hamburgo','br','Brazil'),(747,135,'Olinda','br','Brazil'),(748,136,'Osasco','br','Brazil'),(749,137,'Palhoça','br','Brazil'),(750,138,'Palmas','br','Brazil'),(751,139,'Paranaguá','br','Brazil'),(752,140,'Parnaíba','br','Brazil'),(753,141,'Parnamirim','br','Brazil'),(754,142,'Passo Fundo','br','Brazil'),(755,143,'Patos de Minas','br','Brazil'),(756,144,'Paulista','br','Brazil'),(757,145,'Pelotas','br','Brazil'),(758,146,'Petrolina','br','Brazil'),(759,147,'Petrópolis','br','Brazil'),(760,148,'Pindamonhangaba','br','Brazil'),(761,149,'Pinhais','br','Brazil'),(762,150,'Piracicaba','br','Brazil'),(763,151,'Poá','br','Brazil'),(764,152,'Poços de Caldas','br','Brazil'),(765,153,'Ponta Grossa','br','Brazil'),(766,154,'Porto Alegre','br','Brazil'),(767,155,'Porto Velho','br','Brazil'),(768,156,'Pouso Alegre','br','Brazil'),(769,157,'Praia Grande','br','Brazil'),(770,158,'Presidente Prudente','br','Brazil'),(771,159,'Queimados','br','Brazil'),(772,160,'Recife','br','Brazil'),(773,161,'Resende','br','Brazil'),(774,162,'Ribeirão das Neves','br','Brazil'),(775,163,'Ribeirão Pires','br','Brazil'),(776,164,'Ribeirão Preto','br','Brazil'),(777,165,'Rio Branco','br','Brazil'),(778,166,'Rio Claro','br','Brazil'),(779,167,'Rio de Janeiro','br','Brazil'),(780,168,'Rio Grande','br','Brazil'),(781,169,'Rio Verde','br','Brazil'),(782,170,'Rondonópolis','br','Brazil'),(783,171,'Sabará','br','Brazil'),(784,172,'Salvador','br','Brazil'),(785,173,'Santa Bárbara d\'Oeste','br','Brazil'),(786,174,'Santa Cruz do Sul','br','Brazil'),(787,175,'Santa Luzia','br','Brazil'),(788,176,'Santa Maria','br','Brazil'),(789,177,'Santa Rita','br','Brazil'),(790,178,'Santarém','br','Brazil'),(791,179,'Santo André','br','Brazil'),(792,180,'Santos','br','Brazil'),(793,181,'São Bernardo do Campo','br','Brazil'),(794,182,'São Caetano do Sul','br','Brazil'),(795,183,'São Carlos','br','Brazil'),(796,184,'São Gonçalo','br','Brazil'),(797,185,'São João de Meriti','br','Brazil'),(798,186,'São José','br','Brazil'),(799,187,'São José do Rio Preto','br','Brazil'),(800,188,'São José dos Campos','br','Brazil'),(801,189,'São José dos Pinhais','br','Brazil'),(802,190,'São Leopoldo','br','Brazil'),(803,191,'São Luís','br','Brazil'),(804,192,'São Paulo','br','Brazil'),(805,193,'São Vicente','br','Brazil'),(806,194,'Sapucaia','br','Brazil'),(807,195,'Serra','br','Brazil'),(808,196,'Sete Lagoas','br','Brazil'),(809,197,'Sobral','br','Brazil'),(810,198,'Sorocaba','br','Brazil'),(811,199,'Sumaré','br','Brazil'),(812,200,'Suzano','br','Brazil'),(813,201,'Taboão da Serra','br','Brazil'),(814,202,'Taubaté','br','Brazil'),(815,203,'Teixeira de Freitas','br','Brazil'),(816,204,'Teófilo Otoni','br','Brazil'),(817,205,'Teresina','br','Brazil'),(818,206,'Teresópolis','br','Brazil'),(819,207,'Timon','br','Brazil'),(820,208,'Uberaba','br','Brazil'),(821,209,'Uberlândia','br','Brazil'),(822,210,'Uruguaiana','br','Brazil'),(823,211,'Valparaiso de Goiás','br','Brazil'),(824,212,'Varginha','br','Brazil'),(825,213,'Várzea Grande','br','Brazil'),(826,214,'Várzea Paulista','br','Brazil'),(827,215,'Viamão','br','Brazil'),(828,216,'Vila Velha','br','Brazil'),(829,217,'Vitória','br','Brazil'),(830,218,'Vitória da Conquista','br','Brazil'),(831,219,'Vitória de Santo Antão','br','Brazil'),(832,220,'Volta Redonda','br','Brazil'),(833,1,'East End-Long Look','vg','British Virgin Islands'),(834,2,'Little Harbour','vg','British Virgin Islands'),(835,3,'Road Town','vg','British Virgin Islands'),(836,4,'Settlement','vg','British Virgin Islands'),(837,5,'Spanish Town','vg','British Virgin Islands'),(838,6,'West End','vg','British Virgin Islands'),(839,1,'Bandar Seri Begawan','bn','Brunei'),(840,2,'Bangar','bn','Brunei'),(841,3,'Kuala Belait','bn','Brunei'),(842,4,'Seria','bn','Brunei'),(843,5,'Tutong','bn','Brunei'),(844,1,'Blagoevgrad','bg','Bulgaria'),(845,2,'Burgas','bg','Bulgaria'),(846,3,'Dobrich','bg','Bulgaria'),(847,4,'Gabrovo','bg','Bulgaria'),(848,5,'Haskovo','bg','Bulgaria'),(849,6,'Jambol','bg','Bulgaria'),(850,7,'Kardzhali','bg','Bulgaria'),(851,8,'Kazanlak','bg','Bulgaria'),(852,9,'Kjustendil','bg','Bulgaria'),(853,10,'Lovech','bg','Bulgaria'),(854,11,'Montana','bg','Bulgaria'),(855,12,'Pazardzhik','bg','Bulgaria'),(856,13,'Pernik','bg','Bulgaria'),(857,14,'Pleven','bg','Bulgaria'),(858,15,'Plovdiv','bg','Bulgaria'),(859,16,'Razgrad','bg','Bulgaria'),(860,17,'Ruse','bg','Bulgaria'),(861,18,'Shumen','bg','Bulgaria'),(862,19,'Silistra','bg','Bulgaria'),(863,20,'Sliven','bg','Bulgaria'),(864,21,'Smoljan','bg','Bulgaria'),(865,22,'Sofija','bg','Bulgaria'),(866,23,'Stara Zagora','bg','Bulgaria'),(867,24,'Targovishte','bg','Bulgaria'),(868,25,'Varna','bg','Bulgaria'),(869,26,'Veliko Tarnovo','bg','Bulgaria'),(870,27,'Vidin','bg','Bulgaria'),(871,28,'Vraca','bg','Bulgaria'),(872,1,'Banfora','bf','Burkina Faso'),(873,2,'Batié','bf','Burkina Faso'),(874,3,'Bobo Dioulasso','bf','Burkina Faso'),(875,4,'Bogandé','bf','Burkina Faso'),(876,5,'Boromo','bf','Burkina Faso'),(877,6,'Boulsa','bf','Burkina Faso'),(878,7,'Boussé','bf','Burkina Faso'),(879,8,'Dano','bf','Burkina Faso'),(880,9,'Dédougou','bf','Burkina Faso'),(881,10,'Diapaga','bf','Burkina Faso'),(882,11,'Diébougou','bf','Burkina Faso'),(883,12,'Djibo','bf','Burkina Faso'),(884,13,'Dori','bf','Burkina Faso'),(885,14,'Fada N\'gourma','bf','Burkina Faso'),(886,15,'Gaoua','bf','Burkina Faso'),(887,16,'Gayéri','bf','Burkina Faso'),(888,17,'Gorom-Gorom','bf','Burkina Faso'),(889,18,'Gourcy','bf','Burkina Faso'),(890,19,'Houndé','bf','Burkina Faso'),(891,20,'Kaya','bf','Burkina Faso'),(892,21,'Kombissiri','bf','Burkina Faso'),(893,22,'Kongoussi','bf','Burkina Faso'),(894,23,'Koudougou','bf','Burkina Faso'),(895,24,'Koupéla','bf','Burkina Faso'),(896,25,'Léo','bf','Burkina Faso'),(897,26,'Manga','bf','Burkina Faso'),(898,27,'Nouna','bf','Burkina Faso'),(899,28,'Orodara','bf','Burkina Faso'),(900,29,'Ouagadougou','bf','Burkina Faso'),(901,30,'Ouahigouya','bf','Burkina Faso'),(902,31,'Pama','bf','Burkina Faso'),(903,32,'Pô','bf','Burkina Faso'),(904,33,'Réo','bf','Burkina Faso'),(905,34,'Sindou','bf','Burkina Faso'),(906,35,'Tenkodogo','bf','Burkina Faso'),(907,36,'Tougan','bf','Burkina Faso'),(908,37,'Yako','bf','Burkina Faso'),(909,38,'Ziniaré','bf','Burkina Faso'),(910,39,'Zorgo','bf','Burkina Faso'),(911,1,'Bubanza','bi','Burundi'),(912,2,'Bujumbura','bi','Burundi'),(913,3,'Bururi','bi','Burundi'),(914,4,'Cankuzo','bi','Burundi'),(915,5,'Cibitoke','bi','Burundi'),(916,6,'Gitega','bi','Burundi'),(917,7,'Karuzi','bi','Burundi'),(918,8,'Kayanza','bi','Burundi'),(919,9,'Kirundo','bi','Burundi'),(920,10,'Makamba','bi','Burundi'),(921,11,'Muramvya','bi','Burundi'),(922,12,'Muyinga','bi','Burundi'),(923,13,'Ngozi','bi','Burundi'),(924,14,'Rutana','bi','Burundi'),(925,15,'Ruyigi','bi','Burundi'),(926,1,'Banlung','kh','Cambodia'),(927,2,'Bat Dâmbâng','kh','Cambodia'),(928,3,'Dong Tong','kh','Cambodia'),(929,4,'Kâmpóng Cham','kh','Cambodia'),(930,5,'Kâmpóng Chhnang','kh','Cambodia'),(931,6,'Kâmpóng Spoeu','kh','Cambodia'),(932,7,'Kâmpóng Thum','kh','Cambodia'),(933,8,'Kâmpôt','kh','Cambodia'),(934,9,'Krâchéh','kh','Cambodia'),(935,10,'Krong Kaeb','kh','Cambodia'),(936,11,'Krong Pailin','kh','Cambodia'),(937,12,'Phnum Pénh','kh','Cambodia'),(938,13,'Phumi Sâmraông','kh','Cambodia'),(939,14,'Phumi Takaev','kh','Cambodia'),(940,15,'Pousat','kh','Cambodia'),(941,16,'Preah Sihanouk','kh','Cambodia'),(942,17,'Prey Veaeng','kh','Cambodia'),(943,18,'Senmonorom','kh','Cambodia'),(944,19,'Siem Reab','kh','Cambodia'),(945,20,'Sisophon','kh','Cambodia'),(946,21,'Stueng Traeng','kh','Cambodia'),(947,22,'Svay Rieng','kh','Cambodia'),(948,23,'Ta Khmau','kh','Cambodia'),(949,24,'Tbeng Mean Chey','kh','Cambodia'),(950,1,'Bafang','cm','Cameroon'),(951,2,'Bafoussam','cm','Cameroon'),(952,3,'Bamenda','cm','Cameroon'),(953,4,'Bana','cm','Cameroon'),(954,5,'Bertoua','cm','Cameroon'),(955,6,'Buéa','cm','Cameroon'),(956,7,'Douala','cm','Cameroon'),(957,8,'Ebolowa','cm','Cameroon'),(958,9,'Edéa','cm','Cameroon'),(959,10,'Foumban','cm','Cameroon'),(960,11,'Garoua','cm','Cameroon'),(961,12,'Kaélé','cm','Cameroon'),(962,13,'Kousséri','cm','Cameroon'),(963,14,'Kumba','cm','Cameroon'),(964,15,'Limbe','cm','Cameroon'),(965,16,'Loum','cm','Cameroon'),(966,17,'Maroua','cm','Cameroon'),(967,18,'Mokolo','cm','Cameroon'),(968,19,'Ngaoundéré','cm','Cameroon'),(969,20,'Nkongsamba','cm','Cameroon'),(970,21,'Yaoundé','cm','Cameroon'),(971,1,'Abbotsford','ca','Canada'),(972,2,'Barrie','ca','Canada'),(973,3,'Calgary','ca','Canada'),(974,4,'Charlottetown','ca','Canada'),(975,5,'Chicoutimi-Jonquière','ca','Canada'),(976,6,'Edmonton','ca','Canada'),(977,7,'Fredericton','ca','Canada'),(978,8,'Guelph','ca','Canada'),(979,9,'Halifax','ca','Canada'),(980,10,'Hamilton','ca','Canada'),(981,11,'Iqaluit','ca','Canada'),(982,12,'Kelowna','ca','Canada'),(983,13,'Kingston','ca','Canada'),(984,14,'Kitchener','ca','Canada'),(985,15,'London','ca','Canada'),(986,16,'Montréal','ca','Canada'),(987,17,'Oshawa','ca','Canada'),(988,18,'Ottawa','ca','Canada'),(989,19,'Québec','ca','Canada'),(990,20,'Regina','ca','Canada'),(991,21,'Saint Catharines-Niagara','ca','Canada'),(992,22,'Saint John\'s','ca','Canada'),(993,23,'Saskatoon','ca','Canada'),(994,24,'Sherbrooke','ca','Canada'),(995,25,'Sudbury','ca','Canada'),(996,26,'Thunder Bay','ca','Canada'),(997,27,'Toronto','ca','Canada'),(998,28,'Trois-Rivières','ca','Canada'),(999,29,'Vancouver','ca','Canada'),(1000,30,'Victoria','ca','Canada'),(1001,31,'Whitehorse','ca','Canada'),(1002,32,'Windsor','ca','Canada'),(1003,33,'Winnipeg','ca','Canada'),(1004,34,'Yellowknife','ca','Canada'),(1005,1,'Assomada','cv','Cape Verde'),(1006,2,'Mindelo','cv','Cape Verde'),(1007,3,'Mosteiros','cv','Cape Verde'),(1008,4,'Nova Sintra','cv','Cape Verde'),(1009,5,'Pedra Badejo','cv','Cape Verde'),(1010,6,'Pombas','cv','Cape Verde'),(1011,7,'Ponta do Sol','cv','Cape Verde'),(1012,8,'Porto Novo','cv','Cape Verde'),(1013,9,'Praia','cv','Cape Verde'),(1014,10,'Ribeira Brava','cv','Cape Verde'),(1015,11,'Sal Rei','cv','Cape Verde'),(1016,12,'Santa Maria','cv','Cape Verde'),(1017,13,'São Domingos','cv','Cape Verde'),(1018,14,'São Filipe','cv','Cape Verde'),(1019,15,'São Miguel','cv','Cape Verde'),(1020,16,'Tarrafal','cv','Cape Verde'),(1021,17,'Vila do Maio','cv','Cape Verde'),(1022,1,'Bodden Town','ky','Cayman Islands'),(1023,2,'George Town','ky','Cayman Islands'),(1024,3,'West Bay','ky','Cayman Islands'),(1025,1,'Bambari','cf','Central Africa'),(1026,2,'Bangassou','cf','Central Africa'),(1027,3,'Bangui','cf','Central Africa'),(1028,4,'Batangafo','cf','Central Africa'),(1029,5,'Berbérati','cf','Central Africa'),(1030,6,'Bimbo','cf','Central Africa'),(1031,7,'Birao','cf','Central Africa'),(1032,8,'Boda','cf','Central Africa'),(1033,9,'Bossangoa','cf','Central Africa'),(1034,10,'Bossembélé','cf','Central Africa'),(1035,11,'Bouar','cf','Central Africa'),(1036,12,'Bozoum','cf','Central Africa'),(1037,13,'Bria','cf','Central Africa'),(1038,14,'Carnot','cf','Central Africa'),(1039,15,'Ippy','cf','Central Africa'),(1040,16,'Kaga-Bandoro','cf','Central Africa'),(1041,17,'Mbaiki','cf','Central Africa'),(1042,18,'Mobaye','cf','Central Africa'),(1043,19,'Ndélé','cf','Central Africa'),(1044,20,'Nola','cf','Central Africa'),(1045,21,'Obo','cf','Central Africa'),(1046,22,'Paoua','cf','Central Africa'),(1047,23,'Rafaï','cf','Central Africa'),(1048,24,'Sibut','cf','Central Africa'),(1049,1,'Abéché','td','Chad'),(1050,2,'Am Timan','td','Chad'),(1051,3,'Ati','td','Chad'),(1052,4,'Biltine','td','Chad'),(1053,5,'Bitkine','td','Chad'),(1054,6,'Bol','td','Chad'),(1055,7,'Bongor','td','Chad'),(1056,8,'Doba','td','Chad'),(1057,9,'Dourbali','td','Chad'),(1058,10,'Faya','td','Chad'),(1059,11,'Kélo','td','Chad'),(1060,12,'Koumra','td','Chad'),(1061,13,'Kyabé','td','Chad'),(1062,14,'Laï','td','Chad'),(1063,15,'Léré','td','Chad'),(1064,16,'Mao','td','Chad'),(1065,17,'Massaguet','td','Chad'),(1066,18,'Mongo','td','Chad'),(1067,19,'Moundou','td','Chad'),(1068,20,'N\'Djaména','td','Chad'),(1069,21,'Oum Hadjer','td','Chad'),(1070,22,'Pala','td','Chad'),(1071,23,'Sarh','td','Chad'),(1072,1,'Antofagasta','cl','Chile'),(1073,2,'Arica','cl','Chile'),(1074,3,'Calama','cl','Chile'),(1075,4,'Chillán','cl','Chile'),(1076,5,'Coihaique','cl','Chile'),(1077,6,'Concepción','cl','Chile'),(1078,7,'Copiapó','cl','Chile'),(1079,8,'Coquimbo','cl','Chile'),(1080,9,'Curicó','cl','Chile'),(1081,10,'Iquique','cl','Chile'),(1082,11,'La Serena','cl','Chile'),(1083,12,'Los Ángeles','cl','Chile'),(1084,13,'Osorno','cl','Chile'),(1085,14,'Puente Alto','cl','Chile'),(1086,15,'Puerto Montt','cl','Chile'),(1087,16,'Punta Arenas','cl','Chile'),(1088,17,'Quilpué','cl','Chile'),(1089,18,'Rancagua','cl','Chile'),(1090,19,'San Bernardo','cl','Chile'),(1091,20,'Santiago','cl','Chile'),(1092,21,'Talca','cl','Chile'),(1093,22,'Talcahuano','cl','Chile'),(1094,23,'Temuco','cl','Chile'),(1095,24,'Valdivia','cl','Chile'),(1096,25,'Valparaíso','cl','Chile'),(1097,26,'Viña del Mar','cl','Chile'),(1098,1,'Acheng','cn','China'),(1099,2,'Aksu','cn','China'),(1100,3,'Anbu','cn','China'),(1101,4,'Anda','cn','China'),(1102,5,'Ankang','cn','China'),(1103,6,'Anqing','cn','China'),(1104,7,'Anqiu','cn','China'),(1105,8,'Anshan','cn','China'),(1106,9,'Anshun','cn','China'),(1107,10,'Anyang','cn','China'),(1108,11,'Aomen','cn','China'),(1109,12,'Badaojiang','cn','China'),(1110,13,'Bagongshan','cn','China'),(1111,14,'Baicheng','cn','China'),(1112,15,'Baiyin','cn','China'),(1113,16,'Bantou','cn','China'),(1114,17,'Baoding','cn','China'),(1115,18,'Baoji','cn','China'),(1116,19,'Baoshan','cn','China'),(1117,20,'Baotou','cn','China'),(1118,21,'Beian','cn','China'),(1119,22,'Beibei','cn','China'),(1120,23,'Beihai','cn','China'),(1121,24,'Beijing','cn','China'),(1122,25,'Beipiao','cn','China'),(1123,26,'Bengbu','cn','China'),(1124,27,'Benxi','cn','China'),(1125,28,'Binzhou','cn','China'),(1126,29,'Boli','cn','China'),(1127,30,'Boshan','cn','China'),(1128,31,'Bozhou','cn','China'),(1129,32,'Buhe','cn','China'),(1130,33,'Cangzhou','cn','China'),(1131,34,'Changchun','cn','China'),(1132,35,'Changde','cn','China'),(1133,36,'Changji','cn','China'),(1134,37,'Changsha','cn','China'),(1135,38,'Changzhi','cn','China'),(1136,39,'Changzhou','cn','China'),(1137,40,'Chaohu','cn','China'),(1138,41,'Chaoyang','cn','China'),(1139,42,'Chaozhou','cn','China'),(1140,43,'Chengde','cn','China'),(1141,44,'Chengdu','cn','China'),(1142,45,'Chenghai','cn','China'),(1143,46,'Chengzihe','cn','China'),(1144,47,'Chenzhou','cn','China'),(1145,48,'Chifeng','cn','China'),(1146,49,'Chizhou','cn','China'),(1147,50,'Chongqing','cn','China'),(1148,51,'Chuncheng','cn','China'),(1149,52,'Chuzhou','cn','China'),(1150,53,'Daan','cn','China'),(1151,54,'Daan','cn','China'),(1152,55,'Dachang','cn','China'),(1153,56,'Dali','cn','China'),(1154,57,'Dalian','cn','China'),(1155,58,'Daliang','cn','China'),(1156,59,'Dandong','cn','China'),(1157,60,'Datong','cn','China'),(1158,61,'Dawukou','cn','China'),(1159,62,'Daxian','cn','China'),(1160,63,'Dehui','cn','China'),(1161,64,'Deyang','cn','China'),(1162,65,'Dezhou','cn','China'),(1163,66,'Didao','cn','China'),(1164,67,'Dingshu','cn','China'),(1165,68,'Dingzhou','cn','China'),(1166,69,'Dongchang','cn','China'),(1167,70,'Dongguan','cn','China'),(1168,71,'Donghai','cn','China'),(1169,72,'Donghe','cn','China'),(1170,73,'Dongling','cn','China'),(1171,74,'Dongtai','cn','China'),(1172,75,'Dongying','cn','China'),(1173,76,'Dunhua','cn','China'),(1174,77,'Ezhou','cn','China'),(1175,78,'Fengcheng','cn','China'),(1176,79,'Foshan','cn','China'),(1177,80,'Fuling','cn','China'),(1178,81,'Fushun','cn','China'),(1179,82,'Fuxin','cn','China'),(1180,83,'Fuyang','cn','China'),(1181,84,'Fuyu','cn','China'),(1182,85,'Fuzhou','cn','China'),(1183,86,'Gangdong','cn','China'),(1184,87,'Ganzhou','cn','China'),(1185,88,'Gaomi','cn','China'),(1186,89,'Gaozhou','cn','China'),(1187,90,'Gejiu','cn','China'),(1188,91,'Gongzhuling','cn','China'),(1189,92,'Guangshui','cn','China'),(1190,93,'Guangyuan','cn','China'),(1191,94,'Guangzhou','cn','China'),(1192,95,'Guilin','cn','China'),(1193,96,'Guiqing','cn','China'),(1194,97,'Guiyang','cn','China'),(1195,98,'Haibowan','cn','China'),(1196,99,'Haicheng','cn','China'),(1197,100,'Haikou','cn','China'),(1198,101,'Hailar','cn','China'),(1199,102,'Hailun','cn','China'),(1200,103,'Hami','cn','China'),(1201,104,'Handan','cn','China'),(1202,105,'Hangu','cn','China'),(1203,106,'Hangzhou','cn','China'),(1204,107,'Hanzhong','cn','China'),(1205,108,'Harbin','cn','China'),(1206,109,'Hebi','cn','China'),(1207,110,'Hefei','cn','China'),(1208,111,'Hegang','cn','China'),(1209,112,'Hekou','cn','China'),(1210,113,'Hengshan','cn','China'),(1211,114,'Hengshui','cn','China'),(1212,115,'Hengyang','cn','China'),(1213,116,'Heze','cn','China'),(1214,117,'Hohhot','cn','China'),(1215,118,'Honggang','cn','China'),(1216,119,'Honghu','cn','China'),(1217,120,'Huadian','cn','China'),(1218,121,'Huaibei','cn','China'),(1219,122,'Huaihua','cn','China'),(1220,123,'Huaiyin','cn','China'),(1221,124,'Huanggang','cn','China'),(1222,125,'Huangshi','cn','China'),(1223,126,'Huangyan','cn','China'),(1224,127,'Huangzhou','cn','China'),(1225,128,'Huicheng','cn','China'),(1226,129,'Huizhou','cn','China'),(1227,130,'Hulan','cn','China'),(1228,131,'Hulan Ergi','cn','China'),(1229,132,'Humen','cn','China'),(1230,133,'Huzhou','cn','China'),(1231,134,'Jiagedagi','cn','China'),(1232,135,'Jiamusi','cn','China'),(1233,136,'Jian','cn','China'),(1234,137,'Jiangmen','cn','China'),(1235,138,'Jiangyin','cn','China'),(1236,139,'Jiangyou','cn','China'),(1237,140,'Jiaohe','cn','China'),(1238,141,'Jiaozhou','cn','China'),(1239,142,'Jiaozuo','cn','China'),(1240,143,'Jiaxing','cn','China'),(1241,144,'Jiayuguan','cn','China'),(1242,145,'Jieshi','cn','China'),(1243,146,'Jieshou','cn','China'),(1244,147,'Jilin','cn','China'),(1245,148,'Jinan','cn','China'),(1246,149,'Jinchang','cn','China'),(1247,150,'Jincheng','cn','China'),(1248,151,'Jinchengjiang','cn','China'),(1249,152,'Jingdezhen','cn','China'),(1250,153,'Jingmen','cn','China'),(1251,154,'Jingzhou','cn','China'),(1252,155,'Jinhua','cn','China'),(1253,156,'Jining','cn','China'),(1254,157,'Jining','cn','China'),(1255,158,'Jinma','cn','China'),(1256,159,'Jinsha','cn','China'),(1257,160,'Jinxi','cn','China'),(1258,161,'Jinzhou','cn','China'),(1259,162,'Jinzhou','cn','China'),(1260,163,'Jishu','cn','China'),(1261,164,'Jiujiang','cn','China'),(1262,165,'Jiulong','cn','China'),(1263,166,'Jiupu','cn','China'),(1264,167,'Jiutai','cn','China'),(1265,168,'Jixi','cn','China'),(1266,169,'Kaifeng','cn','China'),(1267,170,'Kaili','cn','China'),(1268,171,'Kaiyuan','cn','China'),(1269,172,'Kaiyuan','cn','China'),(1270,173,'Karamay','cn','China'),(1271,174,'Kashi','cn','China'),(1272,175,'Korla','cn','China'),(1273,176,'Kunming','cn','China'),(1274,177,'Laiwu','cn','China'),(1275,178,'Laiyang','cn','China'),(1276,179,'Langfang','cn','China'),(1277,180,'Lanzhou','cn','China'),(1278,181,'Laohekou','cn','China'),(1279,182,'Lasa','cn','China'),(1280,183,'Leiyang','cn','China'),(1281,184,'Lengshuijiang','cn','China'),(1282,185,'Leshan','cn','China'),(1283,186,'Lianran','cn','China'),(1284,187,'Liaocheng','cn','China'),(1285,188,'Liaoyang','cn','China'),(1286,189,'Liaoyuan','cn','China'),(1287,190,'Licheng','cn','China'),(1288,191,'Linchuan','cn','China'),(1289,192,'Linfen','cn','China'),(1290,193,'Linhai','cn','China'),(1291,194,'Linhe','cn','China'),(1292,195,'Linqing','cn','China'),(1293,196,'Linshui','cn','China'),(1294,197,'Linxi','cn','China'),(1295,198,'Linyi','cn','China'),(1296,199,'Lishui','cn','China'),(1297,200,'Liupanshui','cn','China'),(1298,201,'Liuzhou','cn','China'),(1299,202,'Longfeng','cn','China'),(1300,203,'Longjiang','cn','China'),(1301,204,'Longyan','cn','China'),(1302,205,'Loudi','cn','China'),(1303,206,'Luan','cn','China'),(1304,207,'Luohe','cn','China'),(1305,208,'Luoyang','cn','China'),(1306,209,'Luzhou','cn','China'),(1307,210,'Maanshan','cn','China'),(1308,211,'Macheng','cn','China'),(1309,212,'Majie','cn','China'),(1310,213,'Maoming','cn','China'),(1311,214,'Meihekou','cn','China'),(1312,215,'Meizhou','cn','China'),(1313,216,'Mentougou','cn','China'),(1314,217,'Mianchang','cn','China'),(1315,218,'Mianyang','cn','China'),(1316,219,'Mingshui','cn','China'),(1317,220,'Minhang','cn','China'),(1318,221,'Mudanjiang','cn','China'),(1319,222,'Nancha','cn','China'),(1320,223,'Nanchang','cn','China'),(1321,224,'Nanchong','cn','China'),(1322,225,'Nanjing','cn','China'),(1323,226,'Nanning','cn','China'),(1324,227,'Nanping','cn','China'),(1325,228,'Nantong','cn','China'),(1326,229,'Nantongkuang','cn','China'),(1327,230,'Nanyang','cn','China'),(1328,231,'Nehe','cn','China'),(1329,232,'Neijiang','cn','China'),(1330,233,'Ningbo','cn','China'),(1331,234,'Nongan','cn','China'),(1332,235,'Panjin','cn','China'),(1333,236,'Panzhihua','cn','China'),(1334,237,'Pingdingshan','cn','China'),(1335,238,'Pingliang','cn','China'),(1336,239,'Pingxiang','cn','China'),(1337,240,'Pulandian','cn','China'),(1338,241,'Puqi','cn','China'),(1339,242,'Puyang','cn','China'),(1340,243,'Qianguo','cn','China'),(1341,244,'Qianjiang','cn','China'),(1342,245,'Qincheng','cn','China'),(1343,246,'Qingdao','cn','China'),(1344,247,'Qingyuan','cn','China'),(1345,248,'Qinhuangdao','cn','China'),(1346,249,'Qiqihar','cn','China'),(1347,250,'Qitaihe','cn','China'),(1348,251,'Quanwan','cn','China'),(1349,252,'Quanzhou','cn','China'),(1350,253,'Qujing','cn','China'),(1351,254,'Ranghulu','cn','China'),(1352,255,'Rizhao','cn','China'),(1353,256,'Rongcheng','cn','China'),(1354,257,'Rongcheng','cn','China'),(1355,258,'Ruian','cn','China'),(1356,259,'Saertu','cn','China'),(1357,260,'Saigong','cn','China'),(1358,261,'Sanbu','cn','China'),(1359,262,'Sanmenxia','cn','China'),(1360,263,'Sanming','cn','China'),(1361,264,'Shahe','cn','China'),(1362,265,'Shanghai','cn','China'),(1363,266,'Shangqiu','cn','China'),(1364,267,'Shangrao','cn','China'),(1365,268,'Shantou','cn','China'),(1366,269,'Shanwei','cn','China'),(1367,270,'Shaoguan','cn','China'),(1368,271,'Shaowu','cn','China'),(1369,272,'Shaoxing','cn','China'),(1370,273,'Shaoyang','cn','China'),(1371,274,'Shashi','cn','China'),(1372,275,'Shatin','cn','China'),(1373,276,'Shenjiamen','cn','China'),(1374,277,'Shenyang','cn','China'),(1375,278,'Shenzhen','cn','China'),(1376,279,'Shihezi','cn','China'),(1377,280,'Shijiazhuang','cn','China'),(1378,281,'Shiqiao','cn','China'),(1379,282,'Shishou','cn','China'),(1380,283,'Shiyan','cn','China'),(1381,284,'Shizuishan','cn','China'),(1382,285,'Shuangcheng','cn','China'),(1383,286,'Shuangyashan','cn','China'),(1384,287,'Shuimogou','cn','China'),(1385,288,'Siping','cn','China'),(1386,289,'Songjiang','cn','China'),(1387,290,'Sucheng','cn','China'),(1388,291,'Suihua','cn','China'),(1389,292,'Suining','cn','China'),(1390,293,'Suizhou','cn','China'),(1391,294,'Sujiatun','cn','China'),(1392,295,'Suzhou','cn','China'),(1393,296,'Suzhou','cn','China'),(1394,297,'Taian','cn','China'),(1395,298,'Taicheng','cn','China'),(1396,299,'Taipo','cn','China'),(1397,300,'Taiyuan','cn','China'),(1398,301,'Tanggu','cn','China'),(1399,302,'Tangshan','cn','China'),(1400,303,'Taonan','cn','China'),(1401,304,'Tengzhou','cn','China'),(1402,305,'Tiangjiaan','cn','China'),(1403,306,'Tianjin','cn','China'),(1404,307,'Tianmen','cn','China'),(1405,308,'Tieli','cn','China'),(1406,309,'Tieling','cn','China'),(1407,310,'Tongchuan','cn','China'),(1408,311,'Tongliao','cn','China'),(1409,312,'Tongling','cn','China'),(1410,313,'Tongren','cn','China'),(1411,314,'Tongzhou','cn','China'),(1412,315,'Tuanmun','cn','China'),(1413,316,'Urumqi','cn','China'),(1414,317,'Wafangdian','cn','China'),(1415,318,'Wanxian','cn','China'),(1416,319,'Weifang','cn','China'),(1417,320,'Weihai','cn','China'),(1418,321,'Weinan','cn','China'),(1419,322,'Wencheng','cn','China'),(1420,323,'Wenzhou','cn','China'),(1421,324,'Wuchang','cn','China'),(1422,325,'Wuda','cn','China'),(1423,326,'Wuhan','cn','China'),(1424,327,'Wuhu','cn','China'),(1425,328,'Wulanhaote','cn','China'),(1426,329,'Wuning','cn','China'),(1427,330,'Wuwei','cn','China'),(1428,331,'Wuxi','cn','China'),(1429,332,'Wuxue','cn','China'),(1430,333,'Wuzhou','cn','China'),(1431,334,'Xiamen','cn','China'),(1432,335,'Xian','cn','China'),(1433,336,'Xiangdong','cn','China'),(1434,337,'Xiangfan','cn','China'),(1435,338,'Xianggang','cn','China'),(1436,339,'Xiangtan','cn','China'),(1437,340,'Xianning','cn','China'),(1438,341,'Xiantao','cn','China'),(1439,342,'Xianyang','cn','China'),(1440,343,'Xiaogan','cn','China'),(1441,344,'Xiaolan','cn','China'),(1442,345,'Xichang','cn','China'),(1443,346,'Xiejiaji','cn','China'),(1444,347,'Xilinhaote','cn','China'),(1445,348,'Xinan','cn','China'),(1446,349,'Xincheng','cn','China'),(1447,350,'Xingcheng','cn','China'),(1448,351,'Xingtai','cn','China'),(1449,352,'Xingyi','cn','China'),(1450,353,'Xining','cn','China'),(1451,354,'Xinji','cn','China'),(1452,355,'Xinpu','cn','China'),(1453,356,'Xinshi','cn','China'),(1454,357,'Xintai','cn','China'),(1455,358,'Xinxiang','cn','China'),(1456,359,'Xinyang','cn','China'),(1457,360,'Xinzhou','cn','China'),(1458,361,'Xuanhua','cn','China'),(1459,362,'Xuanzhou','cn','China'),(1460,363,'Xuchang','cn','China'),(1461,364,'Xuzhou','cn','China'),(1462,365,'Yaan','cn','China'),(1463,366,'Yakeshi','cn','China'),(1464,367,'Yanan','cn','China'),(1465,368,'Yancheng','cn','China'),(1466,369,'Yangjiang','cn','China'),(1467,370,'Yangquan','cn','China'),(1468,371,'Yangzhou','cn','China'),(1469,372,'Yanji','cn','China'),(1470,373,'Yantai','cn','China'),(1471,374,'Yibin','cn','China'),(1472,375,'Yichang','cn','China'),(1473,376,'Yichun','cn','China'),(1474,377,'Yichun','cn','China'),(1475,378,'Yidu','cn','China'),(1476,379,'Yinchuan','cn','China'),(1477,380,'Yingcheng','cn','China'),(1478,381,'Yingkou','cn','China'),(1479,382,'Yingzhong','cn','China'),(1480,383,'Yining','cn','China'),(1481,384,'Yiyang','cn','China'),(1482,385,'Yizheng','cn','China'),(1483,386,'Yongan','cn','China'),(1484,387,'Yuanlong','cn','China'),(1485,388,'Yuci','cn','China'),(1486,389,'Yueyang','cn','China'),(1487,390,'Yuhong','cn','China'),(1488,391,'Yulin','cn','China'),(1489,392,'Yuncheng','cn','China'),(1490,393,'Yunyang','cn','China'),(1491,394,'Yushan','cn','China'),(1492,395,'Yushan','cn','China'),(1493,396,'Yushu','cn','China'),(1494,397,'Yuyao','cn','China'),(1495,398,'Zalantun','cn','China'),(1496,399,'Zaoyang','cn','China'),(1497,400,'Zaozhuang','cn','China'),(1498,401,'Zhalainuoer','cn','China'),(1499,402,'Zhangdian','cn','China'),(1500,403,'Zhangjiakou','cn','China'),(1501,404,'Zhangye','cn','China'),(1502,405,'Zhangzhou','cn','China'),(1503,406,'Zhanjiang','cn','China'),(1504,407,'Zhaocheng','cn','China'),(1505,408,'Zhaodong','cn','China'),(1506,409,'Zhaoqing','cn','China'),(1507,410,'Zhaotong','cn','China'),(1508,411,'Zhaoyang','cn','China'),(1509,412,'Zhengzhou','cn','China'),(1510,413,'Zhenjiang','cn','China'),(1511,414,'Zhicheng','cn','China'),(1512,415,'Zhongshan','cn','China'),(1513,416,'Zhoucun','cn','China'),(1514,417,'Zhoukou','cn','China'),(1515,418,'Zhucheng','cn','China'),(1516,419,'Zhuhai','cn','China'),(1517,420,'Zhuji','cn','China'),(1518,421,'Zhumadian','cn','China'),(1519,422,'Zhuozhou','cn','China'),(1520,423,'Zhuzhou','cn','China'),(1521,424,'Zigong','cn','China'),(1522,425,'Zouxian','cn','China'),(1523,426,'Zunyi','cn','China'),(1524,1,'Armenia','co','Colombia'),(1525,2,'Barrancabermeja','co','Colombia'),(1526,3,'Barranquilla','co','Colombia'),(1527,4,'Bello','co','Colombia'),(1528,5,'Bogotá','co','Colombia'),(1529,6,'Bucaramanga','co','Colombia'),(1530,7,'Buenaventura','co','Colombia'),(1531,8,'Buga','co','Colombia'),(1532,9,'Cali','co','Colombia'),(1533,10,'Cartagena','co','Colombia'),(1534,11,'Cartago','co','Colombia'),(1535,12,'Cúcuta','co','Colombia'),(1536,13,'Dos Quebradas','co','Colombia'),(1537,14,'Envigado','co','Colombia'),(1538,15,'Florencia','co','Colombia'),(1539,16,'Floridablanca','co','Colombia'),(1540,17,'Girardot','co','Colombia'),(1541,18,'Girón','co','Colombia'),(1542,19,'Ibagué','co','Colombia'),(1543,20,'Itagüí','co','Colombia'),(1544,21,'Maicao','co','Colombia'),(1545,22,'Manizales','co','Colombia'),(1546,23,'Medellín','co','Colombia'),(1547,24,'Montería','co','Colombia'),(1548,25,'Neiva','co','Colombia'),(1549,26,'Palmira','co','Colombia'),(1550,27,'Pasto','co','Colombia'),(1551,28,'Pereira','co','Colombia'),(1552,29,'Popayán','co','Colombia'),(1553,30,'Santa Marta','co','Colombia'),(1554,31,'Sincelejo','co','Colombia'),(1555,32,'Soacha','co','Colombia'),(1556,33,'Sogamoso','co','Colombia'),(1557,34,'Soledad','co','Colombia'),(1558,35,'Tuluá','co','Colombia'),(1559,36,'Tunja','co','Colombia'),(1560,37,'Valledupar','co','Colombia'),(1561,38,'Villavicencio','co','Colombia'),(1562,1,'Domoni','km','Comoros'),(1563,2,'Fomboni','km','Comoros'),(1564,3,'Mitsamiouli','km','Comoros'),(1565,4,'Moroni','km','Comoros'),(1566,5,'Mutsamudu','km','Comoros'),(1567,1,'Brazzaville','cg','Congo'),(1568,2,'Djambala','cg','Congo'),(1569,3,'Dongou','cg','Congo'),(1570,4,'Ewo','cg','Congo'),(1571,5,'Gamboma','cg','Congo'),(1572,6,'Impfondo','cg','Congo'),(1573,7,'Kinkala','cg','Congo'),(1574,8,'Loandjili','cg','Congo'),(1575,9,'Loubomo','cg','Congo'),(1576,10,'Madingou','cg','Congo'),(1577,11,'Makoua','cg','Congo'),(1578,12,'Matsanga','cg','Congo'),(1579,13,'Mossaka','cg','Congo'),(1580,14,'Mossendjo','cg','Congo'),(1581,15,'Ngamaba-Mfilou','cg','Congo'),(1582,16,'Nkayi','cg','Congo'),(1583,17,'Ouesso','cg','Congo'),(1584,18,'Owando','cg','Congo'),(1585,19,'Pointe Noire','cg','Congo'),(1586,20,'Sibiti','cg','Congo'),(1587,1,'Bandundu','cd','Congo (Dem. Rep.)'),(1588,2,'Beni','cd','Congo (Dem. Rep.)'),(1589,3,'Boma','cd','Congo (Dem. Rep.)'),(1590,4,'Bukavu','cd','Congo (Dem. Rep.)'),(1591,5,'Bunia','cd','Congo (Dem. Rep.)'),(1592,6,'Butembo','cd','Congo (Dem. Rep.)'),(1593,7,'Gemena','cd','Congo (Dem. Rep.)'),(1594,8,'Goma','cd','Congo (Dem. Rep.)'),(1595,9,'Ilebo','cd','Congo (Dem. Rep.)'),(1596,10,'Isiro','cd','Congo (Dem. Rep.)'),(1597,11,'Kalemie','cd','Congo (Dem. Rep.)'),(1598,12,'Kananga','cd','Congo (Dem. Rep.)'),(1599,13,'Kikwit','cd','Congo (Dem. Rep.)'),(1600,14,'Kindu','cd','Congo (Dem. Rep.)'),(1601,15,'Kinshasa','cd','Congo (Dem. Rep.)'),(1602,16,'Kisangani','cd','Congo (Dem. Rep.)'),(1603,17,'Kolwezi','cd','Congo (Dem. Rep.)'),(1604,18,'Likasi','cd','Congo (Dem. Rep.)'),(1605,19,'Lubumbashi','cd','Congo (Dem. Rep.)'),(1606,20,'Matadi','cd','Congo (Dem. Rep.)'),(1607,21,'Mbandaka','cd','Congo (Dem. Rep.)'),(1608,22,'Mbuji-Mayi','cd','Congo (Dem. Rep.)'),(1609,23,'Mwene-Ditu','cd','Congo (Dem. Rep.)'),(1610,24,'Tshikapa','cd','Congo (Dem. Rep.)'),(1611,25,'Uvira','cd','Congo (Dem. Rep.)'),(1612,1,'Amuri','ck','Cook Islands'),(1613,2,'Atiu','ck','Cook Islands'),(1614,3,'Avarua','ck','Cook Islands'),(1615,4,'Mangaia','ck','Cook Islands'),(1616,5,'Mauke','ck','Cook Islands'),(1617,6,'Mitiaro','ck','Cook Islands'),(1618,7,'Nassau','ck','Cook Islands'),(1619,8,'Omoka','ck','Cook Islands'),(1620,9,'Rakahanga','ck','Cook Islands'),(1621,10,'Roto','ck','Cook Islands'),(1622,11,'Tauhunu','ck','Cook Islands'),(1623,1,'Aguacaliente','cr','Costa Rica'),(1624,2,'Alajuela','cr','Costa Rica'),(1625,3,'Cartago','cr','Costa Rica'),(1626,4,'Curridabat','cr','Costa Rica'),(1627,5,'Desamparados','cr','Costa Rica'),(1628,6,'Heredia','cr','Costa Rica'),(1629,7,'Ipís','cr','Costa Rica'),(1630,8,'Liberia','cr','Costa Rica'),(1631,9,'Limón','cr','Costa Rica'),(1632,10,'Paraíso','cr','Costa Rica'),(1633,11,'Puntarenas','cr','Costa Rica'),(1634,12,'Purral','cr','Costa Rica'),(1635,13,'San Francisco','cr','Costa Rica'),(1636,14,'San Isidro','cr','Costa Rica'),(1637,15,'San José','cr','Costa Rica'),(1638,16,'San José','cr','Costa Rica'),(1639,17,'San Juan','cr','Costa Rica'),(1640,18,'San Miguel','cr','Costa Rica'),(1641,19,'San Pedro','cr','Costa Rica'),(1642,20,'San Vicente','cr','Costa Rica'),(1643,21,'Turrialba','cr','Costa Rica'),(1644,1,'Bjelovar','hr','Croatia'),(1645,2,'Chakovec','hr','Croatia'),(1646,3,'Dhakovo','hr','Croatia'),(1647,4,'Dubrovnik','hr','Croatia'),(1648,5,'Gospic','hr','Croatia'),(1649,6,'Karlovac','hr','Croatia'),(1650,7,'Koprivnica','hr','Croatia'),(1651,8,'Krapina','hr','Croatia'),(1652,9,'Osijek','hr','Croatia'),(1653,10,'Pozhega','hr','Croatia'),(1654,11,'Pula','hr','Croatia'),(1655,12,'Rijeka','hr','Croatia'),(1656,13,'Sesvete','hr','Croatia'),(1657,14,'Shibenik','hr','Croatia'),(1658,15,'Sisak','hr','Croatia'),(1659,16,'Slavonski Brod','hr','Croatia'),(1660,17,'Split','hr','Croatia'),(1661,18,'Varazhdin','hr','Croatia'),(1662,19,'Velika Gorica','hr','Croatia'),(1663,20,'Vinkovci','hr','Croatia'),(1664,21,'Virovitica','hr','Croatia'),(1665,22,'Vukovar','hr','Croatia'),(1666,23,'Zadar','hr','Croatia'),(1667,24,'Zagreb','hr','Croatia'),(1668,1,'Bayamo','cu','Cuba'),(1669,2,'Camagüey','cu','Cuba'),(1670,3,'Cárdenas','cu','Cuba'),(1671,4,'Ciego de Ávila','cu','Cuba'),(1672,5,'Cienfuegos','cu','Cuba'),(1673,6,'Consolación del Sur','cu','Cuba'),(1674,7,'Contramaestre','cu','Cuba'),(1675,8,'Guantánamo','cu','Cuba'),(1676,9,'Holguín','cu','Cuba'),(1677,10,'La Habana','cu','Cuba'),(1678,11,'Las Tunas','cu','Cuba'),(1679,12,'Manzanillo','cu','Cuba'),(1680,13,'Matanzas','cu','Cuba'),(1681,14,'Mayarí','cu','Cuba'),(1682,15,'Nueva Gerona','cu','Cuba'),(1683,16,'Palma Soriano','cu','Cuba'),(1684,17,'Pinar del Rio','cu','Cuba'),(1685,18,'Puerto Padre','cu','Cuba'),(1686,19,'Sancti Spíritus','cu','Cuba'),(1687,20,'Santa Clara','cu','Cuba'),(1688,21,'Santiago de Cuba','cu','Cuba'),(1689,1,'Aradippou','cy','Cyprus'),(1690,2,'Dali','cy','Cyprus'),(1691,3,'Deryneia','cy','Cyprus'),(1692,4,'Dipkarpaz','cy','Cyprus'),(1693,5,'Dromolaxia','cy','Cyprus'),(1694,6,'Gazimagusa','cy','Cyprus'),(1695,7,'Geri','cy','Cyprus'),(1696,8,'Girne','cy','Cyprus'),(1697,9,'Güzelyurt','cy','Cyprus'),(1698,10,'Larnaka','cy','Cyprus'),(1699,11,'Lefka','cy','Cyprus'),(1700,12,'Lefkosa','cy','Cyprus'),(1701,13,'Lefkosia','cy','Cyprus'),(1702,14,'Lemesos','cy','Cyprus'),(1703,15,'Livadia','cy','Cyprus'),(1704,16,'Pafos','cy','Cyprus'),(1705,17,'Paralimni','cy','Cyprus'),(1706,18,'Tseri','cy','Cyprus'),(1707,19,'Xylofagou','cy','Cyprus'),(1708,20,'Ypsonas','cy','Cyprus'),(1709,1,'Brno','cz','Czech Republic'),(1710,2,'Cheské Budejovice','cz','Czech Republic'),(1711,3,'Chomutov','cz','Czech Republic'),(1712,4,'Dechín','cz','Czech Republic'),(1713,5,'Frýdek-Místek','cz','Czech Republic'),(1714,6,'Havírov','cz','Czech Republic'),(1715,7,'Hradec Králové','cz','Czech Republic'),(1716,8,'Jihlava','cz','Czech Republic'),(1717,9,'Karlovy Vary','cz','Czech Republic'),(1718,10,'Karviná','cz','Czech Republic'),(1719,11,'Kladno','cz','Czech Republic'),(1720,12,'Liberec','cz','Czech Republic'),(1721,13,'Most','cz','Czech Republic'),(1722,14,'Olomouc','cz','Czech Republic'),(1723,15,'Opava','cz','Czech Republic'),(1724,16,'Ostrava','cz','Czech Republic'),(1725,17,'Pardubice','cz','Czech Republic'),(1726,18,'Plzen','cz','Czech Republic'),(1727,19,'Praha','cz','Czech Republic'),(1728,20,'Ústí','cz','Czech Republic'),(1729,21,'Zlín','cz','Czech Republic'),(1730,1,'Aabenraa','dk','Denmark'),(1731,2,'Aalborg','dk','Denmark'),(1732,3,'Århus','dk','Denmark'),(1733,4,'Esbjerg','dk','Denmark'),(1734,5,'Fredericia','dk','Denmark'),(1735,6,'Greve Strand','dk','Denmark'),(1736,7,'Helsingør','dk','Denmark'),(1737,8,'Hillerød','dk','Denmark'),(1738,9,'Holstebro','dk','Denmark'),(1739,10,'Horsens','dk','Denmark'),(1740,11,'Hørsholm','dk','Denmark'),(1741,12,'København','dk','Denmark'),(1742,13,'Køge','dk','Denmark'),(1743,14,'Kolding','dk','Denmark'),(1744,15,'Næstved','dk','Denmark'),(1745,16,'Nykøbing','dk','Denmark'),(1746,17,'Odense','dk','Denmark'),(1747,18,'Randers','dk','Denmark'),(1748,19,'Ribe','dk','Denmark'),(1749,20,'Ringkøbing','dk','Denmark'),(1750,21,'Rønne','dk','Denmark'),(1751,22,'Roskilde','dk','Denmark'),(1752,23,'Silkeborg','dk','Denmark'),(1753,24,'Slagelse','dk','Denmark'),(1754,25,'Sorø','dk','Denmark'),(1755,26,'Vejle','dk','Denmark'),(1756,27,'Viborg','dk','Denmark'),(1757,1,'´Ali Sabîh','dj','Djibouti'),(1758,2,'Dikhil','dj','Djibouti'),(1759,3,'Jibûti','dj','Djibouti'),(1760,4,'Tajûrah','dj','Djibouti'),(1761,5,'Ubuk','dj','Djibouti'),(1762,1,'Atkinson','dm','Dominica'),(1763,2,'Barroui','dm','Dominica'),(1764,3,'Berekua','dm','Dominica'),(1765,4,'Castle Bruce','dm','Dominica'),(1766,5,'Coulihaut','dm','Dominica'),(1767,6,'Délices','dm','Dominica'),(1768,7,'Hampstead','dm','Dominica'),(1769,8,'La Plaine','dm','Dominica'),(1770,9,'Mahaut','dm','Dominica'),(1771,10,'Marigot','dm','Dominica'),(1772,11,'Petite Soufrière','dm','Dominica'),(1773,12,'Pointe Michel','dm','Dominica'),(1774,13,'Pont Cassé','dm','Dominica'),(1775,14,'Portsmouth','dm','Dominica'),(1776,15,'Rosalie','dm','Dominica'),(1777,16,'Roseau','dm','Dominica'),(1778,17,'Saint Joseph','dm','Dominica'),(1779,18,'Soufrière','dm','Dominica'),(1780,19,'Vieille Case','dm','Dominica'),(1781,20,'Wesley','dm','Dominica'),(1782,1,'Azua','do','Dominican Republic'),(1783,2,'Bajos de Haina','do','Dominican Republic'),(1784,3,'Baní','do','Dominican Republic'),(1785,4,'Barahona','do','Dominican Republic'),(1786,5,'Bonao','do','Dominican Republic'),(1787,6,'Comendador','do','Dominican Republic'),(1788,7,'Cotuí','do','Dominican Republic'),(1789,8,'Dajabón','do','Dominican Republic'),(1790,9,'El Seybo','do','Dominican Republic'),(1791,10,'Esperanza','do','Dominican Republic'),(1792,11,'Hato Mayor','do','Dominican Republic'),(1793,12,'Higüey','do','Dominican Republic'),(1794,13,'Jimaní','do','Dominican Republic'),(1795,14,'La Romana','do','Dominican Republic'),(1796,15,'La Vega','do','Dominican Republic'),(1797,16,'Mao','do','Dominican Republic'),(1798,17,'Moca','do','Dominican Republic'),(1799,18,'Monte Cristi','do','Dominican Republic'),(1800,19,'Monte Plata','do','Dominican Republic'),(1801,20,'Nagua','do','Dominican Republic'),(1802,21,'Neyba','do','Dominican Republic'),(1803,22,'Pedernales','do','Dominican Republic'),(1804,23,'Puerto Plata','do','Dominican Republic'),(1805,24,'Sabaneta','do','Dominican Republic'),(1806,25,'Salcedo','do','Dominican Republic'),(1807,26,'Samaná','do','Dominican Republic'),(1808,27,'San Cristóbal','do','Dominican Republic'),(1809,28,'San Francisco de Macorís','do','Dominican Republic'),(1810,29,'San Juan de la Maguana','do','Dominican Republic'),(1811,30,'San Pedro de Macorís','do','Dominican Republic'),(1812,31,'Santiago','do','Dominican Republic'),(1813,32,'Santo Domingo','do','Dominican Republic'),(1814,33,'Villa Altagracia','do','Dominican Republic'),(1815,1,'Aileu','tp','East Timor'),(1816,2,'Ainaro','tp','East Timor'),(1817,3,'Aubá','tp','East Timor'),(1818,4,'Baucau','tp','East Timor'),(1819,5,'Bazartete','tp','East Timor'),(1820,6,'Dare','tp','East Timor'),(1821,7,'Dili','tp','East Timor'),(1822,8,'Ermera','tp','East Timor'),(1823,9,'Lautem','tp','East Timor'),(1824,10,'Liquiça','tp','East Timor'),(1825,11,'Lolotoi','tp','East Timor'),(1826,12,'Los Palos','tp','East Timor'),(1827,13,'Maliana','tp','East Timor'),(1828,14,'Manatuto','tp','East Timor'),(1829,15,'Metinaro','tp','East Timor'),(1830,16,'Pante Macassar','tp','East Timor'),(1831,17,'Same','tp','East Timor'),(1832,18,'Suai','tp','East Timor'),(1833,19,'Viqueque','tp','East Timor'),(1834,1,'Ambato','ec','Ecuador'),(1835,2,'Azogues','ec','Ecuador'),(1836,3,'Babahoyo','ec','Ecuador'),(1837,4,'Cuenca','ec','Ecuador'),(1838,5,'Eloy Alfaro','ec','Ecuador'),(1839,6,'Esmeraldas','ec','Ecuador'),(1840,7,'Guaranda','ec','Ecuador'),(1841,8,'Guayaquil','ec','Ecuador'),(1842,9,'Ibarra','ec','Ecuador'),(1843,10,'La Libertad','ec','Ecuador'),(1844,11,'Latacunga','ec','Ecuador'),(1845,12,'Loja','ec','Ecuador'),(1846,13,'Macas','ec','Ecuador'),(1847,14,'Machala','ec','Ecuador'),(1848,15,'Manta','ec','Ecuador'),(1849,16,'Milagro','ec','Ecuador'),(1850,17,'Nueva Loja','ec','Ecuador'),(1851,18,'Orellana','ec','Ecuador'),(1852,19,'Pasaje','ec','Ecuador'),(1853,20,'Portoviejo','ec','Ecuador'),(1854,21,'Puerto Baquerizo Moreno','ec','Ecuador'),(1855,22,'Puyo','ec','Ecuador'),(1856,23,'Quevedo','ec','Ecuador'),(1857,24,'Quito','ec','Ecuador'),(1858,25,'Riobamba','ec','Ecuador'),(1859,26,'Santo Domingo','ec','Ecuador'),(1860,27,'Tena','ec','Ecuador'),(1861,28,'Tulcán','ec','Ecuador'),(1862,29,'Zamora','ec','Ecuador'),(1863,1,'al-´Arîsh','eg','Egypt'),(1864,2,'al-Fayyûm','eg','Egypt'),(1865,3,'al-Ghardaqah','eg','Egypt'),(1866,4,'al-Hawâmidîyah','eg','Egypt'),(1867,5,'al-Iskandarîyah','eg','Egypt'),(1868,6,'al-Ismâîlîyah','eg','Egypt'),(1869,7,'al-Jîzah','eg','Egypt'),(1870,8,'al-Khârijah','eg','Egypt'),(1871,9,'al-Mahallah al-Kubrâ','eg','Egypt'),(1872,10,'al-Mansûrah','eg','Egypt'),(1873,11,'al-Matarîyah','eg','Egypt'),(1874,12,'al-Minyâ','eg','Egypt'),(1875,13,'al-Qahira','eg','Egypt'),(1876,14,'al-Uqsur','eg','Egypt'),(1877,15,'as-Suways','eg','Egypt'),(1878,16,'Aswân','eg','Egypt'),(1879,17,'Asyût','eg','Egypt'),(1880,18,'at-Tûr','eg','Egypt'),(1881,19,'az-Zaqâzîq','eg','Egypt'),(1882,20,'Banhâ','eg','Egypt'),(1883,21,'Banî Suwayf','eg','Egypt'),(1884,22,'Bilbays','eg','Egypt'),(1885,23,'Bilqâs','eg','Egypt'),(1886,24,'Bûr Sa´îd','eg','Egypt'),(1887,25,'Damanhûr','eg','Egypt'),(1888,26,'Disûq','eg','Egypt'),(1889,27,'Dumyât','eg','Egypt'),(1890,28,'Idfû','eg','Egypt'),(1891,29,'Idkû','eg','Egypt'),(1892,30,'Jirjâ','eg','Egypt'),(1893,31,'Kafr-ad-Dawwâr','eg','Egypt'),(1894,32,'Kafr-ash-Shaykh','eg','Egypt'),(1895,33,'Mallawî','eg','Egypt'),(1896,34,'Marsâ Matrûh','eg','Egypt'),(1897,35,'Mît Gamr','eg','Egypt'),(1898,36,'Qalyûb','eg','Egypt'),(1899,37,'Qinâ','eg','Egypt'),(1900,38,'Sawhâj','eg','Egypt'),(1901,39,'Shibîn-al-Kawm','eg','Egypt'),(1902,40,'Shubrâ al-Khaymah','eg','Egypt'),(1903,41,'Talkhâ','eg','Egypt'),(1904,42,'Tantâ','eg','Egypt'),(1905,1,'Ahuachapán','sv','El Salvador'),(1906,2,'Antiguo Cuscatlán','sv','El Salvador'),(1907,3,'Apopa','sv','El Salvador'),(1908,4,'Chalatenango','sv','El Salvador'),(1909,5,'Cojutepeque','sv','El Salvador'),(1910,6,'Cuscatancingo','sv','El Salvador'),(1911,7,'Delgado','sv','El Salvador'),(1912,8,'Gotera','sv','El Salvador'),(1913,9,'Ilopango','sv','El Salvador'),(1914,10,'La Unión','sv','El Salvador'),(1915,11,'Mejicanos','sv','El Salvador'),(1916,12,'Nueva San Salvador','sv','El Salvador'),(1917,13,'Quezaltepeque','sv','El Salvador'),(1918,14,'San Marcos','sv','El Salvador'),(1919,15,'San Martín','sv','El Salvador'),(1920,16,'San Miguel','sv','El Salvador'),(1921,17,'San Salvador','sv','El Salvador'),(1922,18,'San Vicente','sv','El Salvador'),(1923,19,'Santa Ana','sv','El Salvador'),(1924,20,'Sensuntepeque','sv','El Salvador'),(1925,21,'Sonsonate','sv','El Salvador'),(1926,22,'Soyapango','sv','El Salvador'),(1927,23,'Usulután','sv','El Salvador'),(1928,24,'Zacatecoluca','sv','El Salvador'),(1929,1,'Aconibe','gq','Equatorial Guinea'),(1930,2,'Acurenam','gq','Equatorial Guinea'),(1931,3,'Añisoc','gq','Equatorial Guinea'),(1932,4,'Bata','gq','Equatorial Guinea'),(1933,5,'Ebebiyin','gq','Equatorial Guinea'),(1934,6,'Evinayong','gq','Equatorial Guinea'),(1935,7,'Luba','gq','Equatorial Guinea'),(1936,8,'Malabo','gq','Equatorial Guinea'),(1937,9,'Mbini','gq','Equatorial Guinea'),(1938,10,'Mikomeseng','gq','Equatorial Guinea'),(1939,11,'Moca','gq','Equatorial Guinea'),(1940,12,'Mongomo','gq','Equatorial Guinea'),(1941,13,'Niefang','gq','Equatorial Guinea'),(1942,14,'Nsok','gq','Equatorial Guinea'),(1943,15,'Palé','gq','Equatorial Guinea'),(1944,16,'Riaba','gq','Equatorial Guinea'),(1945,1,'Âddî K\'eyih','er','Eritrea'),(1946,2,'Âddî Kwala','er','Eritrea'),(1947,3,'Âddî Ugrî','er','Eritrea'),(1948,4,'Âk\'ordat','er','Eritrea'),(1949,5,'Âsmara','er','Eritrea'),(1950,6,'Âsseb','er','Eritrea'),(1951,7,'Barentu','er','Eritrea'),(1952,8,'Bêylul','er','Eritrea'),(1953,9,'Dek\'emhâre','er','Eritrea'),(1954,10,'Êdd','er','Eritrea'),(1955,11,'Gînda','er','Eritrea'),(1956,12,'Himbirtî','er','Eritrea'),(1957,13,'Keren','er','Eritrea'),(1958,14,'Mersa Fatma','er','Eritrea'),(1959,15,'Mitsiwa','er','Eritrea'),(1960,16,'Nefasît','er','Eritrea'),(1961,17,'Sen\'afê','er','Eritrea'),(1962,18,'Teseney','er','Eritrea'),(1963,1,'Elva','ee','Estonia'),(1964,2,'Haapsalu','ee','Estonia'),(1965,3,'Jôgeva','ee','Estonia'),(1966,4,'Jôhvi','ee','Estonia'),(1967,5,'Kärdla','ee','Estonia'),(1968,6,'Keila','ee','Estonia'),(1969,7,'Kiviôli','ee','Estonia'),(1970,8,'Kohtla-Järve','ee','Estonia'),(1971,9,'Kuressaare','ee','Estonia'),(1972,10,'Maardu','ee','Estonia'),(1973,11,'Narva','ee','Estonia'),(1974,12,'Paide','ee','Estonia'),(1975,13,'Pärnu','ee','Estonia'),(1976,14,'Pôlva','ee','Estonia'),(1977,15,'Rakvere','ee','Estonia'),(1978,16,'Rapla','ee','Estonia'),(1979,17,'Sillamäe','ee','Estonia'),(1980,18,'Tallinn','ee','Estonia'),(1981,19,'Tapa','ee','Estonia'),(1982,20,'Tartu','ee','Estonia'),(1983,21,'Valga','ee','Estonia'),(1984,22,'Viljandi','ee','Estonia'),(1985,23,'Vôru','ee','Estonia'),(1986,1,'Âddîgrat','et','Ethiopia'),(1987,2,'Âddîs Âbebâ','et','Ethiopia'),(1988,3,'Ârba Minch','et','Ethiopia'),(1989,4,'Asayita','et','Ethiopia'),(1990,5,'Âsosa','et','Ethiopia'),(1991,6,'Âssela','et','Ethiopia'),(1992,7,'Âwassa','et','Ethiopia'),(1993,8,'Bahir Dar','et','Ethiopia'),(1994,9,'Debre Birhan','et','Ethiopia'),(1995,10,'Debre Mark\'os','et','Ethiopia'),(1996,11,'Debre Zeyit','et','Ethiopia'),(1997,12,'Desê','et','Ethiopia'),(1998,13,'Dirê Dawa','et','Ethiopia'),(1999,14,'Gambêla','et','Ethiopia'),(2000,15,'Gondar','et','Ethiopia'),(2001,16,'Harer','et','Ethiopia'),(2002,17,'Jijiga','et','Ethiopia'),(2003,18,'Jîmma','et','Ethiopia'),(2004,19,'Kembolcha','et','Ethiopia'),(2005,20,'Mek\'elê','et','Ethiopia'),(2006,21,'Nazrêt','et','Ethiopia'),(2007,22,'Nek\'emtê','et','Ethiopia'),(2008,23,'Shashemennê','et','Ethiopia'),(2009,24,'Soddo','et','Ethiopia'),(2010,1,'Bantam','xa','Ext. Territ. of Australia'),(2011,2,'The Settlement','xa','Ext. Territ. of Australia'),(2012,3,'West Island','xa','Ext. Territ. of Australia'),(2013,4,'Willis Island Meteorological Station','xa','Ext. Territ. of Australia'),(2014,1,'Goose Green','fk','Falkland Islands'),(2015,2,'Grytviken','fk','Falkland Islands'),(2016,3,'Port Howard','fk','Falkland Islands'),(2017,4,'Port Stanley','fk','Falkland Islands'),(2018,1,'Eiði','fo','Faroe Islands'),(2019,2,'Fuglafjarð','fo','Faroe Islands'),(2020,3,'Gøta','fo','Faroe Islands'),(2021,4,'Húsavík','fo','Faroe Islands'),(2022,5,'Hvalbi','fo','Faroe Islands'),(2023,6,'Klaksvík','fo','Faroe Islands'),(2024,7,'Kollafjarð','fo','Faroe Islands'),(2025,8,'Kvívík','fo','Faroe Islands'),(2026,9,'Leirvík','fo','Faroe Islands'),(2027,10,'Midvágs','fo','Faroe Islands'),(2028,11,'Nes','fo','Faroe Islands'),(2029,12,'Runavík','fo','Faroe Islands'),(2030,13,'Sandavágs','fo','Faroe Islands'),(2031,14,'Sands','fo','Faroe Islands'),(2032,15,'Sjó','fo','Faroe Islands'),(2033,16,'Skála','fo','Faroe Islands'),(2034,17,'Sørvags','fo','Faroe Islands'),(2035,18,'Tórshavn','fo','Faroe Islands'),(2036,19,'Tvøroyri','fo','Faroe Islands'),(2037,20,'Vágs','fo','Faroe Islands'),(2038,21,'Vestmanna','fo','Faroe Islands'),(2039,1,'Ba','fj','Fiji'),(2040,2,'Deuba','fj','Fiji'),(2041,3,'Korokade','fj','Fiji'),(2042,4,'Korovou','fj','Fiji'),(2043,5,'Labasa','fj','Fiji'),(2044,6,'Lami','fj','Fiji'),(2045,7,'Lautoka','fj','Fiji'),(2046,8,'Levuka','fj','Fiji'),(2047,9,'Nadi','fj','Fiji'),(2048,10,'Nausori','fj','Fiji'),(2049,11,'Navouvalu','fj','Fiji'),(2050,12,'Navua','fj','Fiji'),(2051,13,'Rakiraki','fj','Fiji'),(2052,14,'Savusavu','fj','Fiji'),(2053,15,'Seaqaqa','fj','Fiji'),(2054,16,'Sigatoka','fj','Fiji'),(2055,17,'Suva','fj','Fiji'),(2056,18,'Tavua','fj','Fiji'),(2057,19,'Tubou','fj','Fiji'),(2058,20,'Vatukoula','fj','Fiji'),(2059,1,'Espoo','fi','Finland'),(2060,2,'Hämeenlinna','fi','Finland'),(2061,3,'Helsinki','fi','Finland'),(2062,4,'Hyvinkää','fi','Finland'),(2063,5,'Järvenpää','fi','Finland'),(2064,6,'Joensuu','fi','Finland'),(2065,7,'Jyväskylä','fi','Finland'),(2066,8,'Kajaani','fi','Finland'),(2067,9,'Kokkola','fi','Finland'),(2068,10,'Kotka','fi','Finland'),(2069,11,'Kouvola','fi','Finland'),(2070,12,'Kuopio','fi','Finland'),(2071,13,'Lahti','fi','Finland'),(2072,14,'Lappeenranta','fi','Finland'),(2073,15,'Lohja','fi','Finland'),(2074,16,'Maarianhamina','fi','Finland'),(2075,17,'Mikkeli','fi','Finland'),(2076,18,'Nurmijärvi','fi','Finland'),(2077,19,'Oulu','fi','Finland'),(2078,20,'Pori','fi','Finland'),(2079,21,'Porvoo','fi','Finland'),(2080,22,'Rovaniemi','fi','Finland'),(2081,23,'Seinäjoki','fi','Finland'),(2082,24,'Tampere','fi','Finland'),(2083,25,'Turku','fi','Finland'),(2084,26,'Vaasa','fi','Finland'),(2085,27,'Vantaa','fi','Finland'),(2086,1,'Agen','fr','France'),(2087,2,'Aix-en-Provence','fr','France'),(2088,3,'Ajaccio','fr','France'),(2089,4,'Albi','fr','France'),(2090,5,'Alençon','fr','France'),(2091,6,'Amiens','fr','France'),(2092,7,'Angers','fr','France'),(2093,8,'Angoulême','fr','France'),(2094,9,'Annecy','fr','France'),(2095,10,'Arras','fr','France'),(2096,11,'Auch','fr','France'),(2097,12,'Aurillac','fr','France'),(2098,13,'Auxerre','fr','France'),(2099,14,'Avignon','fr','France'),(2100,15,'Bar-le-Duc','fr','France'),(2101,16,'Bastia','fr','France'),(2102,17,'Beauvais','fr','France'),(2103,18,'Belfort','fr','France'),(2104,19,'Besançon','fr','France'),(2105,20,'Blois','fr','France'),(2106,21,'Bobigny','fr','France'),(2107,22,'Bordeaux','fr','France'),(2108,23,'Boulogne-Billancourt','fr','France'),(2109,24,'Bourg-en-Bresse','fr','France'),(2110,25,'Bourges','fr','France'),(2111,26,'Brest','fr','France'),(2112,27,'Caen','fr','France'),(2113,28,'Cahors','fr','France'),(2114,29,'Carcassonne','fr','France'),(2115,30,'Châlons-en-Champagne','fr','France'),(2116,31,'Chambéry','fr','France'),(2117,32,'Charleville-Mézières','fr','France'),(2118,33,'Chartres','fr','France'),(2119,34,'Châteauroux','fr','France'),(2120,35,'Chaumont','fr','France'),(2121,36,'Clermont-Ferrand','fr','France'),(2122,37,'Colmar','fr','France'),(2123,38,'Créteil','fr','France'),(2124,39,'Digne-les-Bains','fr','France'),(2125,40,'Dijon','fr','France'),(2126,41,'Épinal','fr','France'),(2127,42,'Évreux','fr','France'),(2128,43,'Évry','fr','France'),(2129,44,'Foix','fr','France'),(2130,45,'Gap','fr','France'),(2131,46,'Grenoble','fr','France'),(2132,47,'Guéret','fr','France'),(2133,48,'La Rochelle','fr','France'),(2134,49,'La Roche-sur-Yon','fr','France'),(2135,50,'Laon','fr','France'),(2136,51,'Laval','fr','France'),(2137,52,'Le Havre','fr','France'),(2138,53,'Le Mans','fr','France'),(2139,54,'Le Puy-en-Velay','fr','France'),(2140,55,'Lille','fr','France'),(2141,56,'Limoges','fr','France'),(2142,57,'Lons-le-Saunier','fr','France'),(2143,58,'Lyon','fr','France'),(2144,59,'Mâcon','fr','France'),(2145,60,'Marseille','fr','France'),(2146,61,'Melun','fr','France'),(2147,62,'Mende','fr','France'),(2148,63,'Metz','fr','France'),(2149,64,'Montauban','fr','France'),(2150,65,'Mont-de-Marsan','fr','France'),(2151,66,'Montpellier','fr','France'),(2152,67,'Moulins','fr','France'),(2153,68,'Mulhouse','fr','France'),(2154,69,'Nancy','fr','France'),(2155,70,'Nanterre','fr','France'),(2156,71,'Nantes','fr','France'),(2157,72,'Nevers','fr','France'),(2158,73,'Nice','fr','France'),(2159,74,'Nîmes','fr','France'),(2160,75,'Niort','fr','France'),(2161,76,'Orléans','fr','France'),(2162,77,'Paris','fr','France'),(2163,78,'Pau','fr','France'),(2164,79,'Périgueux','fr','France'),(2165,80,'Perpignan','fr','France'),(2166,81,'Poitiers','fr','France'),(2167,82,'Pontoise','fr','France'),(2168,83,'Privas','fr','France'),(2169,84,'Quimper','fr','France'),(2170,85,'Reims','fr','France'),(2171,86,'Rennes','fr','France'),(2172,87,'Rodez','fr','France'),(2173,88,'Rouen','fr','France'),(2174,89,'Saint-Brieuc','fr','France'),(2175,90,'Saint-Étienne','fr','France'),(2176,91,'Saint-Lô','fr','France'),(2177,92,'Strasbourg','fr','France'),(2178,93,'Tarbes','fr','France'),(2179,94,'Toulon','fr','France'),(2180,95,'Toulouse','fr','France'),(2181,96,'Tours','fr','France'