public results from the CPAN

public

ASNMTAP

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

  KEY `comments_ibfk_1` (`catalogID`,`uKey`),
  KEY `comments_ibfk_2` (`catalogID`,`remoteUser`),
  CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`catalogID`, `uKey`) REFERENCES `plugins` (`catalogID`, `uKey`),
  CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`catalogID`, `remoteUser`) REFERENCES `users` (`catalogID`, `remoteUser`)
) 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);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IQ','Iraq',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IR','Iran',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IS','Iceland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('IT','Italy',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('JM','Jamaica',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('JO','Jordan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('JP','Japan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KE','Kenya',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KG','Kyrgyzstan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KH','Cambodia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KI','Kiribati',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KM','Comoros',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KN','Saint Kitts and Nevis',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KP','Korea (North)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KR','Korea (South)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('KW','Kuwait',0);

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

insert into `countries` (`countryID`,`countryName`,`activated`) values ('MD','Moldova',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MG','Madagascar',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MH','Marshall Islands',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MK','Macedonia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ML','Mali',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MM','Myanmar',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MN','Mongolia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MO','Macau',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MP','Northern Mariana Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MQ','Martinique',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MR','Mauritania',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MS','Montserrat',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MT','Malta',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MU','Mauritius',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MV','Maldives',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MW','Malawi',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MX','Mexico',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MY','Malaysia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('MZ','Mozambique',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NA','Namibia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NC','New Caledonia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NE','Niger',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NF','Norfolk Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NG','Nigeria',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NI','Nicaragua',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NL','Netherlands',1);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NO','Norway',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NP','Nepal',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NR','Nauru',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NT','Neutral Zone',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NU','Niue',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('NZ','New Zealand (Aotearoa)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('OM','Oman',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PA','Panama',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PE','Peru',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PF','French Polynesia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PG','Papua New Guinea',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PH','Philippines',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PK','Pakistan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PL','Poland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PM','St. Pierre and Miquelon',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PN','Pitcairn',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PR','Puerto Rico',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PT','Portugal',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PW','Palau',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('PY','Paraguay',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('QA','Qatar',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('RE','Reunion',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('RO','Romania',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('RU','Russian Federation',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('RW','Rwanda',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SA','Saudi Arabia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('Sb','Solomon Islands',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SC','Seychelles',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SD','Sudan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SE','Sweden',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SG','Singapore',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SH','St. Helena',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SI','Slovenia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SJ','Svalbard and Jan Mayen',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SK','Slovak Republic',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SL','Sierra Leone',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SM','San Marino',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SN','Senegal',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SO','Somalia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SR','Suriname',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ST','Sao Tome and Principe',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SU','USSR (former)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SV','El Salvador',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SY','Syria',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('SZ','Swaziland',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TC','Turks and Caicos Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TD','Chad',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TF','French Southern Territo',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TG','Togo',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TH','Thailand',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TJ','Tajikistan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TK','Tokelau',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TM','Turkmenistan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TN','Tunisia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TO','Tonga',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TP','East Timor',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TR','Turkey',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TT','Trinidad and Tobago',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TV','Tuvalu',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TW','Taiwan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('TZ','Tanzania',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('UA','Ukraine',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('UG','Uganda',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('UK','United Kingdom',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('UM','US Minor Outlying Island',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('US','United States',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('UY','Uruguay',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('UZ','Uzbekistan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VA','Vatican City State',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VC','Saint Vincent and the G.',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VE','Venezuela',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VG','Virgin Islands (British)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VI','Virgin Islands (U.S.)',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VN','Viet Nam',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('VU','Vanuatu',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('WF','Wallis and Futuna Islan',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('WS','Samoa',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('YE','Yemen',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('YT','Mayotte',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('YU','Yugoslavia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZA','South Africa',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZM','Zambia',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZR','Zaire',0);
insert into `countries` (`countryID`,`countryName`,`activated`) values ('ZW','Zimbabwe',0);

/*Table structure for table `crontabs` */

DROP TABLE IF EXISTS `crontabs`;

CREATE TABLE `crontabs` (
  `catalogID` varchar(5) NOT NULL default 'CID',
  `lineNumber` char(2) NOT NULL default '',
  `uKey` varchar(11) NOT NULL default '',
  `collectorDaemon` varchar(64) NOT NULL default '',
  `arguments` varchar(1024) default '',

( run in 0.810 second using v1.01-cache-2.11-cpan-0bb4e1dffa6 )