view release on metacpan or  search on metacpan

applications/tools/mysql/asnmtap-3.002.003-distributed_mysql-v5.0.x.sql  view on Meta::CPAN

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `comments` */

/*Table structure for table `countries` */

DROP TABLE IF EXISTS `countries`;

CREATE TABLE `countries` (
  `countryID` char(2) NOT NULL default '',
  `countryName` varchar(45) default NULL,
  `activated` tinyint(1) NOT NULL default '0',
  PRIMARY KEY (`countryID`),
  KEY `countryName` (`countryName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `countries` */

insert into `countries` (`countryID`,`countryName`,`activated`) values ('00','+ All Countries',1);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AD','Andorra',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AE','United Arab Emirates',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AF','Afghanistan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AG','Antigua and Barbuda',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AI','Anguilla',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AL','Albania',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AM','Armenia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AN','Netherlands Antilles',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AO','Angola',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AQ','Antarctica',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AR','Argentina',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AS','American Samoa',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AT','Austria',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AU','Australia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AW','Aruba',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('AZ','Azerbaijan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BA','Bosnia and Herzegovina',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BB','Barbados',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BD','Bangladesh',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BE','Belgium',1);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BF','Burkina Faso',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BG','Bulgaria',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BH','Bahrain',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BI','Burundi',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BJ','Benin',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BM','Bermuda',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BN','Brunei Darussalam',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BO','Bolivia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BR','Brazil',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BS','Bahamas',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BT','Bhutan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BV','Bouvet Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BW','Botswana',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BY','Belarus',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('BZ','Belize',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CA','Canada',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CC','Cocos (Keeling) Islands',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CF','Central African Republic',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CG','Congo',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CH','Switzerland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CI','Cote D\'Ivoire',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CK','Cook Islands',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CL','Chile',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CM','Cameroon',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CN','China',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CO','Colombia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CR','Costa Rica',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CS','Czechoslovakia (former)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CU','Cuba',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CV','Cape Verde',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CX','Christmas Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CY','Cyprus',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('CZ','Czech Republic',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('DE','Germany',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('DJ','Djibouti',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('DK','Denmark',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('DM','Dominica',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('DO','Dominican Republic',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('DZ','Algeria',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('EC','Ecuador',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('EE','Estonia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('EG','Egypt',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('EH','Western Sahara',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ER','Eritrea',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ES','Spain',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ET','Ethiopia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FI','Finland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FJ','Fiji',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FK','Falkland Islands',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FM','Micronesia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FO','Faroe Islands',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FR','France',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('FX','France, Metropolitan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GA','Gabon',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GB','Great Britain (UK)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GD','Grenada',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GE','Georgia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GF','French Guiana',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GH','Ghana',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GI','Gibraltar',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GL','Greenland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GM','Gambia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GN','Guinea',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GP','Guadeloupe',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GQ','Equatorial Guinea',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GR','Greece',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GS','S. Georgia and S. Sandw',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GT','Guatemala',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GU','Guam',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GW','Guinea-Bissau',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('GY','Guyana',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('HK','Hong Kong',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('HM','Heard and McDonald Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('HN','Honduras',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('HR','Croatia (Hrvatska)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('HT','Haiti',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('HU','Hungary',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ID','Indonesia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IE','Ireland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IL','Israel',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IN','India',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IO','British Indian Ocean',0);