/[drupal]/contributions/modules/ham/ham.install
ViewVC logotype

Contents of /contributions/modules/ham/ham.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph

Revision 1.2 - (show annotations) (download) (as text)
Mon Nov 3 18:48:46 2008 UTC (12 months, 3 weeks ago) by ppicazo
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +1 -1 lines
File MIME type: text/x-php 
Removed one line from each locator conversion function which had no effect in function. Band is now determined when the logbook is imported, updated the database and install script to store the band information. Added band summary table to the main page. Also put in a stub function for the caching of the summary page tables which will be implemented soon.
1 <?
2 function ham_enable() {
3 // create empty qso lookbook table.
4 db_query("CREATE TABLE IF NOT EXISTS `ham_qso` (`qso_time` datetime NOT NULL,`qso_call` varchar(10) collate utf8_unicode_ci NOT NULL,`qso_remote_grid` varchar(10) collate utf8_unicode_ci default NULL, `qso_local_grid` varchar(10) collate utf8_unicode_ci default NULL, `qso_dxcc` int(11) default NULL, `qso_mode` varchar(10) collate utf8_unicode_ci default NULL, `qso_band` varchar(10) collate utf8_unicode_ci default NULL, `qso_freq` double NOT NULL, PRIMARY KEY (`qso_time`,`qso_call`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
5
6 // create and populate dxcc table
7 db_query("CREATE TABLE IF NOT EXISTS `ham_dxcc` (`dxcc_code` int(11) NOT NULL, `dxcc_country` varchar(75) NOT NULL, `dxcc_continent` enum('AF','AN','AS','EU','NA','OC','SA') NOT NULL, `dxcc_cqzone` int(11) NOT NULL, `dxcc_ituzone` int(11) NOT NULL, `dxcc_validsince` varchar(10) NOT NULL, `dxcc_status` enum('Active','Deleted') NOT NULL, PRIMARY KEY (`dxcc_code`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
8 db_query("INSERT INTO `ham_dxcc` (`dxcc_code`, `dxcc_country`, `dxcc_continent`, `dxcc_cqzone`, `dxcc_ituzone`, `dxcc_validsince`, `dxcc_status`) VALUES (5, 'Aaland Is.', 'EU', 15, 18, '1945-11-15', 'Active'),(2, 'Abu Ail Is. [deleted]', 'AF', 21, 39, '1991-03-31', 'Deleted'),(3, 'Afghanistan', 'AS', 21, 40, '1945-11-15', 'Active'),(4, 'Agalega & St. Brandon Is.', 'AF', 39, 53, '1945-11-15', 'Active'),(6, 'Alaska', 'NA', 1, 1, '1945-11-15', 'Active'),(7, 'Albania', 'EU', 15, 28, '1945-11-15', 'Active'),(8, 'Aldabra [deleted]', 'AF', 39, 53, '1976-06-28', 'Deleted'),(400, 'Algeria', 'AF', 33, 37, '1945-11-15', 'Active'),(9, 'American Samoa', 'OC', 32, 62, '1945-11-15', 'Active'),(10, 'Amsterdam & St. Paul Is.', 'AF', 39, 68, '1945-11-15', 'Active'),(11, 'Andaman & Nicobar Is.', 'AS', 26, 49, '1945-11-15', 'Active'),(203, 'Andorra', 'EU', 14, 27, '1945-11-15', 'Active'),(401, 'Angola', 'AF', 36, 52, '1945-11-15', 'Active'),(12, 'Anguilla', 'NA', 8, 11, '1945-11-15', 'Active'),(195, 'Annobon I.', 'AF', 36, 52, '1945-11-15', 'Active'),(13, 'Antarctica', 'AN', 13, 67, '1945-11-15', 'Active'),(94, 'Antigua & Barbuda', 'NA', 8, 11, '1945-11-15', 'Active'),(100, 'Argentina', 'SA', 13, 14, '1945-11-15', 'Active'),(14, 'Armenia', 'AS', 21, 29, '1945-11-15', 'Active'),(91, 'Aruba', 'SA', 9, 11, '1986-01-01', 'Active'),(205, 'Ascension I.', 'AF', 36, 66, '1945-11-15', 'Active'),(15, 'Asiatic Russia', 'AS', 17, 20, '1945-11-15', 'Active'),(16, 'Auckland & Campbell Is.', 'OC', 32, 60, '1945-11-15', 'Active'),(508, 'Austral I.', 'OC', 32, 63, '1998-04-01', 'Active'),(150, 'Australia', 'OC', 30, 55, '1945-11-15', 'Active'),(206, 'Austria', 'EU', 15, 28, '1945-11-15', 'Active'),(17, 'Aves I.', 'NA', 8, 11, '1945-11-15', 'Active'),(18, 'Azerbaijan', 'AS', 21, 29, '1945-11-15', 'Active'),(149, 'Azores', 'EU', 14, 36, '1945-11-15', 'Active'),(60, 'Bahamas', 'NA', 8, 11, '1945-11-15', 'Active'),(304, 'Bahrain', 'AS', 21, 39, '1945-11-15', 'Active'),(19, 'Bajo Nuevo [deleted]', 'NA', 8, 11, '1981-09-16', 'Deleted'),(20, 'Baker & Howland Is.', 'OC', 31, 61, '1945-11-15', 'Active'),(21, 'Balearic Is.', 'EU', 14, 37, '1945-11-15', 'Active'),(490, 'Banaba I. (Ocean I.)', 'OC', 31, 65, '1945-11-15', 'Active'),(305, 'Bangladesh', 'AS', 22, 41, '1945-11-15', 'Active'),(62, 'Barbados', 'NA', 8, 11, '1945-11-15', 'Active'),(27, 'Belarus', 'EU', 16, 29, '1945-11-15', 'Active'),(209, 'Belgium', 'EU', 14, 27, '1945-11-15', 'Active'),(66, 'Belize', 'NA', 7, 11, '1945-11-15', 'Active'),(416, 'Benin', 'AF', 35, 46, '1960-08-01', 'Active'),(64, 'Bermuda', 'NA', 5, 11, '1945-11-15', 'Active'),(306, 'Bhutan', 'AS', 22, 41, '1945-11-15', 'Active'),(23, 'Blenheim Reef [deleted]', 'AF', 39, 41, '1975-06-30', 'Deleted'),(104, 'Bolivia', 'SA', 10, 12, '1945-11-15', 'Active'),(85, 'Bonaire, Curacao (Neth. Antilles)', 'SA', 9, 11, '1945-11-15', 'Active'),(501, 'Bosnia-Herzegovinia', 'EU', 15, 28, '1991-10-15', 'Active'),(402, 'Botswana', 'AF', 38, 57, '1945-11-15', 'Active'),(24, 'Bouvet', 'AN', 38, 67, '1945-11-15', 'Active'),(108, 'Brazil', 'SA', 11, 12, '1945-11-15', 'Active'),(25, 'British North Borneo [deleted]', 'OC', 28, 54, '1963-09-15', 'Deleted'),(26, 'British Somaliland [deleted]', 'AF', 37, 48, '1960-06-30', 'Deleted'),(65, 'British Virgin Is.', 'NA', 8, 11, '1945-11-15', 'Active'),(345, 'Brunei Darussalam', 'OC', 28, 54, '1945-11-15', 'Active'),(212, 'Bulgaria', 'EU', 20, 28, '1945-11-15', 'Active'),(480, 'Burkina Faso', 'AF', 35, 46, '1960-08-16', 'Active'),(404, 'Burundi', 'AF', 36, 52, '1962-07-01', 'Active'),(31, 'C. Kiribati (British Phoenix Is.)', 'OC', 31, 62, '1945-11-15', 'Active'),(312, 'Cambodia', 'AS', 26, 49, '1945-11-15', 'Active'),(406, 'Cameroon', 'AF', 36, 47, '1945-11-15', 'Active'),(1, 'Canada', 'NA', 5, 2, '1945-11-15', 'Active'),(28, 'Canal Zone [deleted]', 'NA', 7, 11, '1979-09-30', 'Deleted'),(29, 'Canary Is.', 'AF', 33, 36, '1945-11-15', 'Active'),(409, 'Cape Verde', 'AF', 35, 46, '1945-11-15', 'Active'),(69, 'Cayman Islands', 'NA', 8, 11, '1945-11-15', 'Active'),(30, 'Celebe & Molucca Is. [deleted]', 'OC', 28, 54, '1963-05-01', 'Deleted'),(408, 'Central Africa', 'AF', 36, 47, '1960-08-13', 'Active'),(32, 'Ceuta & Melilla', 'AF', 33, 37, '1945-11-15', 'Active'),(410, 'Chad', 'AF', 36, 47, '1960-08-11', 'Active'),(33, 'Chagos Is.', 'AF', 39, 41, '1945-11-15', 'Active'),(34, 'Chatham Is.', 'OC', 32, 60, '1945-11-15', 'Active'),(512, 'Chesterfield Is.', 'OC', 30, 56, '1945-11-15', 'Active'),(112, 'Chile', 'SA', 12, 14, '1945-11-15', 'Active'),(318, 'China', 'AS', 24, 33, '1945-11-15', 'Active'),(35, 'Christmas I.', 'OC', 29, 54, '1945-11-15', 'Active'),(36, 'Clipperton I.', 'NA', 7, 10, '1945-11-15', 'Active'),(37, 'Cocos I.', 'NA', 7, 11, '1945-11-15', 'Active'),(38, 'Cocos-Keeling Is.', 'OC', 29, 54, '1945-11-15', 'Active'),(116, 'Colombia', 'SA', 9, 12, '1945-11-15', 'Active'),(411, 'Comoros', 'AF', 39, 53, '1975-07-15', 'Active'),(39, 'Comoros [deleted]', 'AF', 39, 53, '1975-07-06', 'Deleted'),(412, 'Congo (Republic of the)', 'AF', 36, 52, '1960-08-15', 'Active'),(489, 'Conway Reef', 'OC', 32, 56, '1945-11-15', 'Active'),(214, 'Corsica', 'EU', 15, 28, '1945-11-15', 'Active'),(308, 'Costa Rica', 'NA', 7, 11, '1945-11-15', 'Active'),(428, 'Cote d''Ivoire', 'AF', 35, 46, '1960-08-07', 'Active'),(40, 'Crete', 'EU', 20, 28, '1945-11-15', 'Active'),(497, 'Croatia', 'EU', 15, 28, '1991-05-26', 'Active'),(41, 'Crozet I.', 'AF', 39, 68, '1945-11-15', 'Active'),(70, 'Cuba', 'NA', 8, 11, '1945-11-15', 'Active'),(215, 'Cyprus', 'AS', 20, 39, '1945-11-15', 'Active'),(503, 'Czech Republic', 'EU', 15, 28, '1993-01-01', 'Active'),(218, 'Czechoslovakia [deleted]', 'EU', 15, 28, '1992-12-31', 'Deleted'),(137, 'DPR of Korea', 'AS', 25, 44, '1995-05-14', 'Active'),(42, 'Damao,Diu [deleted]', 'AS', 22, 41, '1961-12-31', 'Deleted'),(414, 'Dem. Rep. of Congo', 'AF', 36, 52, '1945-11-15', 'Active'),(221, 'Denmark', 'EU', 14, 18, '1945-11-15', 'Active'),(43, 'Desecheo I.', 'NA', 8, 11, '1979-03-01', 'Active'),(44, 'Desroches [deleted]', 'AF', 39, 53, '1976-06-28', 'Deleted'),(382, 'Djibouti', 'AF', 37, 48, '1945-11-15', 'Active'),(45, 'Dodecanese', 'EU', 20, 28, '1945-11-15', 'Active'),(95, 'Dominica', 'NA', 8, 11, '1945-11-15', 'Active'),(72, 'Dominican Republic', 'NA', 8, 11, '1945-11-15', 'Active'),(513, 'Ducie I.', 'OC', 32, 63, '2001-11-16', 'Active'),(48, 'E. Kiribati (Line Is.)', 'OC', 31, 61, '1945-11-15', 'Active'),(46, 'East Malaysia', 'OC', 28, 54, '1963-09-16', 'Active'),(47, 'Easter I.', 'SA', 12, 63, '1945-11-15', 'Active'),(120, 'Ecuador', 'SA', 10, 12, '1945-11-15', 'Active'),(478, 'Egypt', 'AF', 34, 38, '1945-11-15', 'Active'),(74, 'El Salvador', 'NA', 7, 11, '1945-11-15', 'Active'),(223, 'England', 'EU', 14, 27, '1945-11-15', 'Active'),(49, 'Equatorial Guinea', 'AF', 36, 47, '1945-11-15', 'Active'),(51, 'Eritrea', 'AF', 37, 48, '1945-11-15', 'Active'),(52, 'Estonia', 'EU', 15, 29, '1945-11-15', 'Active'),(53, 'Ethiopia', 'AF', 37, 48, '1945-11-15', 'Active'),(54, 'European Russia', 'EU', 16, 19, '1945-11-15', 'Active'),(141, 'Falkland Is.', 'SA', 13, 16, '1945-11-15', 'Active'),(222, 'Faroe Is.', 'EU', 14, 18, '1945-11-15', 'Active'),(55, 'Farquhar [deleted]', 'AF', 39, 53, '1976-06-28', 'Deleted'),(230, 'Fed. Rep. of Germany', 'EU', 14, 28, '1973-09-17', 'Active'),(56, 'Fernando de Noronha', 'SA', 11, 13, '1945-11-15', 'Active'),(176, 'Fiji', 'OC', 32, 56, '1945-11-15', 'Active'),(224, 'Finland', 'EU', 15, 18, '1945-11-15', 'Active'),(57, 'Fr. Equatorial Africa [deleted]', 'AF', 36, 57, '1960-08-16', 'Deleted'),(227, 'France', 'EU', 14, 27, '1945-11-15', 'Active'),(61, 'Franz Josef Land', 'EU', 40, 75, '1945-11-15', 'Active'),(63, 'French Guiana', 'SA', 9, 12, '1945-11-15', 'Active'),(67, 'French India [deleted]', 'AS', 22, 41, '1954-11-01', 'Deleted'),(58, 'French Indo-China [deleted]', 'AS', 26, 49, '1950-10-21', 'Deleted'),(175, 'French Polynesia', 'OC', 32, 63, '1998-03-31', 'Active'),(59, 'French West Africa [deleted]', 'AF', 35, 46, '1960-06-07', 'Deleted'),(420, 'Gabon', 'AF', 36, 52, '1960-08-17', 'Active'),(71, 'Galapagos Is.', 'SA', 10, 12, '1945-11-15', 'Active'),(75, 'Georgia', 'AS', 21, 29, '1945-11-15', 'Active'),(229, 'German Dem. Rep. [deleted]', 'EU', 14, 28, '1990-10-30', 'Deleted'),(81, 'Germany [deleted]', 'EU', 14, 28, '1973-07-17', 'Deleted'),(93, 'Geyser Reef [deleted]', 'AF', 39, 53, '1978-02-28', 'Deleted'),(424, 'Ghana', 'AF', 35, 46, '1957-03-05', 'Active'),(233, 'Gibraltar', 'EU', 14, 37, '1945-11-15', 'Active'),(99, 'Glorioso Is.', 'AF', 39, 53, '1945-11-15', 'Active'),(101, 'Goa [deleted]', 'AS', 22, 41, '1961-12-31', 'Deleted'),(102, 'Gold Coast, Togoland [deleted]', 'AF', 35, 46, '1957-03-05', 'Deleted'),(236, 'Greece', 'EU', 20, 28, '1945-11-15', 'Active'),(237, 'Greenland', 'NA', 40, 5, '1945-11-15', 'Active'),(77, 'Grenada', 'NA', 8, 11, '1945-11-15', 'Active'),(79, 'Guadeloupe', 'NA', 8, 11, '1945-11-15', 'Active'),(103, 'Guam', 'OC', 27, 64, '1945-11-15', 'Active'),(105, 'Guantanamo Bay', 'NA', 8, 11, '1945-11-15', 'Active'),(76, 'Guatemala', 'NA', 7, 11, '1945-11-15', 'Active'),(106, 'Guernsey', 'EU', 14, 27, '1945-11-15', 'Active'),(107, 'Guinea', 'AF', 35, 46, '1945-11-15', 'Active'),(109, 'Guinea-Bissau', 'AF', 35, 46, '1945-11-15', 'Active'),(129, 'Guyana', 'SA', 9, 12, '1945-11-15', 'Active'),(78, 'Haiti', 'NA', 8, 11, '1945-11-15', 'Active'),(110, 'Hawaii', 'OC', 31, 61, '1945-11-15', 'Active'),(111, 'Heard I.', 'AF', 39, 68, '1945-11-15', 'Active'),(80, 'Honduras', 'NA', 7, 11, '1945-11-15', 'Active'),(321, 'Hong Kong', 'AS', 24, 44, '1945-11-15', 'Active'),(239, 'Hungary', 'EU', 15, 28, '1945-11-15', 'Active'),(117, 'ITU HQ', 'EU', 14, 28, '1945-11-15', 'Active'),(242, 'Iceland', 'EU', 40, 17, '1945-11-15', 'Active'),(113, 'Ifni [deleted]', 'AF', 33, 37, '1969-05-13', 'Deleted'),(324, 'India', 'AS', 22, 41, '1945-11-15', 'Active'),(327, 'Indonesia', 'OC', 28, 51, '1963-05-01', 'Active'),(330, 'Iran', 'AS', 21, 40, '1945-11-15', 'Active'),(333, 'Iraq', 'AS', 21, 39, '1945-11-15', 'Active'),(245, 'Ireland', 'EU', 14, 27, '1945-11-15', 'Active'),(114, 'Isle of Man', 'EU', 14, 27, '1945-11-15', 'Active'),(336, 'Israel', 'AS', 20, 39, '1945-11-15', 'Active'),(115, 'Italian Somaliland [deleted]', 'AF', 38, 47, '1960-07-01', 'Deleted'),(248, 'Italy', 'EU', 15, 28, '1945-11-15', 'Active'),(82, 'Jamaica', 'NA', 8, 11, '1945-11-15', 'Active'),(118, 'Jan Mayen', 'EU', 40, 18, '1945-11-15', 'Active'),(339, 'Japan', 'AS', 25, 45, '1945-11-15', 'Active'),(119, 'Java [deleted]', 'OC', 28, 54, '1963-05-01', 'Deleted'),(122, 'Jersey', 'EU', 14, 27, '1945-11-15', 'Active'),(123, 'Johnston I.', 'OC', 31, 61, '1945-11-15', 'Active'),(342, 'Jordan', 'AS', 20, 39, '1945-11-15', 'Active'),(125, 'Juan Fernandez Is.', 'SA', 12, 14, '1945-11-15', 'Active'),(124, 'Juan de Nova, Europa', 'AF', 39, 53, '1945-11-15', 'Active'),(126, 'Kaliningrad', 'EU', 15, 29, '1945-11-15', 'Active'),(127, 'Kamaran Is. [deleted]', 'AS', 21, 39, '1982-03-10', 'Deleted'),(128, 'Karelo-Finnish Rep. [deleted]', 'EU', 15, 18, '1960-07-01', 'Deleted'),(130, 'Kazakhstan', 'AS', 17, 29, '1945-11-15', 'Active'),(430, 'Kenya', 'AF', 37, 48, '1945-11-15', 'Active'),(131, 'Kerguelen Is.', 'AF', 39, 68, '1945-11-15', 'Active'),(133, 'Kermadec Is.', 'OC', 32, 60, '1945-11-15', 'Active'),(134, 'Kingman Reef', 'OC', 31, 61, '1945-11-15', 'Active'),(139, 'Kura Muria I. [deleted]', 'AS', 21, 39, '1967-11-29', 'Deleted'),(138, 'Kure I.', 'OC', 31, 61, '1945-11-15', 'Active'),(348, 'Kuwait', 'AS', 21, 39, '1945-11-15', 'Active'),(68, 'Kuwait/Saudi Arabia Neut. Zone [deleted]', 'AS', 21, 39, '1969-12-14', 'Deleted'),(135, 'Kyrgyzstan', 'AS', 17, 29, '1945-11-15', 'Active'),(142, 'Lakshadweep Is.', 'AS', 22, 41, '1945-11-15', 'Active'),(143, 'Laos', 'AS', 26, 49, '1945-11-15', 'Active'),(145, 'Latvia', 'EU', 15, 29, '1945-11-14', 'Active'),(354, 'Lebanon', 'AS', 20, 39, '1945-11-15', 'Active'),(432, 'Lesotho', 'AF', 38, 57, '1945-11-15', 'Active'),(434, 'Liberia', 'AF', 35, 46, '1945-11-15', 'Active'),(436, 'Libya', 'AF', 34, 38, '1945-11-15', 'Active'),(251, 'Liechtenstein', 'EU', 14, 28, '1945-11-15', 'Active'),(146, 'Lithuania', 'EU', 15, 28, '1945-11-15', 'Active'),(147, 'Lord Howe I.', 'OC', 30, 60, '1945-11-15', 'Active'),(254, 'Luxembourg', 'EU', 14, 27, '1945-11-15', 'Active'),(152, 'Macao', 'AS', 24, 44, '1945-11-15', 'Active'),(502, 'Macedonia', 'EU', 15, 28, '1991-09-08', 'Active'),(153, 'Macquarie I.', 'OC', 30, 60, '1945-11-15', 'Active'),(438, 'Madagascar', 'AF', 39, 53, '1945-11-15', 'Active'),(256, 'Madeira Is.', 'AF', 33, 36, '1945-11-15', 'Active'),(440, 'Malawi', 'AF', 37, 53, '1945-11-15', 'Active'),(155, 'Malaya [deleted]', 'AS', 28, 54, '1963-09-16', 'Deleted'),(159, 'Maldives', 'AF', 22, 41, '1945-11-15', 'Active'),(442, 'Mali', 'AF', 35, 46, '1960-06-20', 'Active'),(161, 'Malpelo I.', 'SA', 7, 12, '1945-11-15', 'Active'),(257, 'Malta', 'EU', 15, 28, '1945-11-15', 'Active'),(151, 'Malyj Vysotskij I.', 'EU', 16, 29, '1945-11-15', 'Active'),(164, 'Manchuria [deleted]', 'AS', 24, 33, '1963-09-17', 'Deleted'),(166, 'Mariana Is.', 'OC', 27, 64, '1945-11-15', 'Active'),(167, 'Market Reef', 'EU', 15, 18, '1945-11-15', 'Active'),(509, 'Marquesas Is.', 'OC', 31, 63, '1998-04-01', 'Active'),(168, 'Marshall Is.', 'OC', 31, 65, '1945-11-15', 'Active'),(84, 'Martinique', 'NA', 8, 11, '1945-11-15', 'Active'),(444, 'Mauritania', 'AF', 35, 46, '1960-06-20', 'Active'),(165, 'Mauritius', 'AF', 39, 53, '1945-11-15', 'Active'),(169, 'Mayotte', 'AF', 39, 53, '1975-07-06', 'Active'),(171, 'Mellish Reef', 'OC', 30, 56, '1945-11-15', 'Active'),(50, 'Mexico', 'NA', 6, 10, '1945-11-15', 'Active'),(173, 'Micronesia', 'OC', 27, 65, '1981-01-01', 'Active'),(174, 'Midway I.', 'OC', 31, 61, '1945-11-15', 'Active'),(177, 'Minami Torishima', 'OC', 27, 90, '1945-11-15', 'Active'),(178, 'Minerva Reef [deleted]', 'OC', 32, 62, '1972-07-15', 'Deleted'),(179, 'Moldavia', 'EU', 16, 29, '1945-11-15', 'Active'),(260, 'Monaco', 'EU', 14, 27, '1945-11-15', 'Active'),(363, 'Mongolia', 'AS', 23, 32, '1945-11-15', 'Active'),(514, 'Montenegro', 'EU', 15, 28, '2006-06-28', 'Active'),(96, 'Montserrat', 'NA', 8, 11, '1945-11-15', 'Active'),(446, 'Morocco', 'AF', 33, 37, '1945-11-15', 'Active'),(180, 'Mount Athos', 'EU', 20, 28, '1945-11-15', 'Active'),(181, 'Mozambique', 'AF', 37, 53, '1945-11-15', 'Active'),(309, 'Myanmar', 'AS', 26, 49, '1945-11-15', 'Active'),(191, 'N. Cook Is.', 'OC', 32, 62, '1945-11-15', 'Active'),(464, 'Namibia', 'AF', 38, 57, '1945-11-15', 'Active'),(157, 'Nauru', 'OC', 31, 65, '1945-11-15', 'Active'),(182, 'Navassa I.', 'NA', 8, 11, '1945-11-15', 'Active'),(369, 'Nepal', 'AS', 22, 42, '1945-11-15', 'Active'),(263, 'Netherlands', 'EU', 14, 27, '1945-11-15', 'Active'),(183, 'Netherlands Borneo [deleted]', 'OC', 28, 54, '1963-05-01', 'Deleted'),(184, 'Netherlands N. Guinea [deleted]', 'OC', 28, 51, '1963-04-30', 'Deleted'),(162, 'New Caledonia', 'OC', 32, 56, '1945-11-15', 'Active'),(170, 'New Zealand', 'OC', 32, 60, '1945-11-15', 'Active'),(186, 'NewFoundland, Labrador [deleted]', 'NA', 5, 9, '1949-04-01', 'Deleted'),(86, 'Nicaragua', 'NA', 7, 11, '1945-11-15', 'Active'),(187, 'Niger', 'AF', 35, 46, '1960-08-03', 'Active'),(450, 'Nigeria', 'AF', 35, 46, '1945-11-15', 'Active'),(188, 'Niue', 'OC', 32, 62, '1945-11-15', 'Active'),(189, 'Norfolk I.', 'OC', 32, 60, '1945-11-15', 'Active'),(265, 'Northern Ireland', 'EU', 14, 27, '1945-11-15', 'Active'),(266, 'Norway', 'EU', 14, 18, '1945-11-15', 'Active'),(192, 'Ogasawara', 'AS', 27, 45, '1945-11-15', 'Active'),(193, 'Okinawa (Ryukyu Is. [deleted]', 'AS', 25, 45, '1972-05-16', 'Deleted'),(194, 'Okino Tori-shima [deleted]', 'AS', 27, 45, '1980-12-01', 'Deleted'),(370, 'Oman', 'AS', 21, 39, '1945-11-15', 'Active'),(372, 'Pakistan', 'AS', 21, 41, '1945-11-15', 'Active'),(22, 'Palau', 'OC', 27, 64, '1945-11-15', 'Active'),(510, 'Palestine', 'AS', 20, 39, '1999-02-02', 'Active'),(196, 'Palestine [deleted]', 'AS', 20, 39, '1968-07-01', 'Deleted'),(197, 'Palmyra & Jarvis Is.', 'OC', 31, 61, '1945-11-15', 'Active'),(88, 'Panama', 'NA', 7, 11, '1945-11-15', 'Active'),(163, 'Papua New Guinea', 'OC', 28, 51, '1975-09-16', 'Active'),(198, 'Papua Territory [deleted]', 'OC', 28, 51, '1975-09-16', 'Deleted'),(132, 'Paraguay', 'SA', 11, 14, '1945-11-15', 'Active'),(493, 'Penguin Is. [deleted]', 'AF', 38, 57, '1994-03-01', 'Deleted'),(243, 'People''s Dem. Rep. of Yemen [deleted]', 'AS', 21, 39, '1990-05-22', 'Deleted'),(136, 'Peru', 'SA', 10, 12, '1945-11-15', 'Active'),(199, 'Peter I I.', 'AN', 12, 72, '1945-11-15', 'Active'),(375, 'Philippines', 'OC', 27, 50, '1945-11-15', 'Active'),(172, 'Pitcairn I.', 'OC', 32, 63, '1945-11-15', 'Active'),(269, 'Poland', 'EU', 15, 28, '1945-11-15', 'Active'),(272, 'Portugal', 'EU', 14, 37, '1945-11-15', 'Active'),(200, 'Portuguese Timor [deleted]', 'OC', 28, 54, '1976-09-14', 'Deleted'),(505, 'Pratas I.', 'AS', 24, 44, '1994-01-01', 'Active'),(201, 'Prince Edward & Marion Is.', 'AF', 38, 57, '1945-11-15', 'Active'),(202, 'Puerto Rico', 'NA', 8, 11, '1945-11-15', 'Active'),(376, 'Qatar', 'AS', 21, 39, '1945-11-15', 'Active'),(433, 'Republic of Korea', 'AS', 25, 44, '1945-11-15', 'Active'),(453, 'Reunion I.', 'AF', 39, 53, '1960-06-25', 'Active'),(204, 'Revillagigedo', 'NA', 6, 10, '1945-11-15', 'Active'),(207, 'Rodrigues I.', 'AF', 39, 53, '1945-11-15', 'Active'),(275, 'Romania', 'EU', 20, 20, '1945-11-15', 'Active'),(460, 'Rotuma I.', 'OC', 32, 56, '1945-11-15', 'Active'),(208, 'Ruanda-Urundi [deleted]', 'AF', 36, 52, '1962-07-01', 'Deleted'),(454, 'Rwanda', 'AF', 36, 52, '1962-07-01', 'Active'),(234, 'S. Cook Is.', 'OC', 32, 62, '1945-11-15', 'Active'),(210, 'Saar [deleted]', 'EU', 14, 28, '1957-03-31', 'Deleted'),(211, 'Sable I.', 'NA', 5, 9, '1945-11-15', 'Active'),(213, 'Saint Martin', 'NA', 8, 11, '1945-11-15', 'Active'),(190, 'Samoa', 'OC', 32, 62, '1945-11-15', 'Active'),(216, 'San Andres & Providencia', 'NA', 7, 11, '1945-11-15', 'Active'),(217, 'San Felix & San Ambrosio', 'SA', 12, 14, '1945-11-15', 'Active'),(278, 'San Marino', 'EU', 15, 28, '1945-11-15', 'Active'),(219, 'Sao Tome & Principe', 'AF', 36, 47, '1945-11-15', 'Active'),(220, 'Sarawak [deleted]', 'OC', 28, 54, '1963-09-16', 'Deleted'),(225, 'Sardinia', 'EU', 15, 28, '1945-11-15', 'Active'),(378, 'Saudi Arabia', 'AS', 21, 39, '1945-11-15', 'Active'),(226, 'Saudi Arabia/Iraq Neut. Zone [deleted]', 'AS', 21, 39, '1981-12-25', 'Deleted'),(506, 'Scarborough Reef', 'AS', 27, 50, '1995-01-01', 'Active'),(279, 'Scotland', 'EU', 14, 27, '1945-11-15', 'Active'),(456, 'Senegal', 'AF', 35, 46, '1960-06-20', 'Active'),(296, 'Serbia', 'EU', 15, 28, '1945-11-15', 'Active'),(228, 'Serrana Bank & Roncador Cay [deleted]', 'NA', 8, 11, '1981-09-16', 'Deleted'),(379, 'Seychelles', 'AF', 39, 53, '1945-11-15', 'Active'),(458, 'Sierra Leone', 'AF', 35, 46, '1945-11-15', 'Active'),(231, 'Sikkim [deleted]', 'AS', 22, 41, '1975-05-01', 'Deleted'),(381, 'Singapore', 'AS', 28, 54, '1945-11-15', 'Active'),(504, 'Slovak Republic', 'EU', 15, 28, '1993-01-01', 'Active'),(499, 'Slovenia', 'EU', 15, 28, '1991-05-26', 'Active'),(185, 'Solomon Is.', 'OC', 28, 51, '1945-11-15', 'Active'),(232, 'Somalia', 'AF', 37, 48, '1945-11-15', 'Active'),(462, 'South Africa', 'AF', 38, 57, '1945-11-15', 'Active'),(235, 'South Georgia I.', 'SA', 13, 73, '1945-11-15', 'Active'),(238, 'South Orkney Is.', 'SA', 13, 73, '1945-11-15', 'Active'),(240, 'South Sandwich Is.', 'SA', 13, 73, '1945-11-15', 'Active'),(241, 'South Shetland Is.', 'SA', 13, 73, '1945-11-15', 'Active'),(244, 'Southern Sudan [deleted]', 'AF', 34, 48, '1994-12-31', 'Deleted'),(246, 'Sov. Mil. Order of Malta', 'EU', 15, 28, '1945-11-15', 'Active'),(281, 'Spain', 'EU', 14, 37, '1945-11-15', 'Active'),(247, 'Spratly Is.', 'OC', 26, 50, '1945-11-15', 'Active'),(315, 'Sri Lanka', 'AS', 22, 41, '1945-11-15', 'Active'),(250, 'St. Helena', 'AF', 36, 66, '1945-11-15', 'Active'),(249, 'St. Kitts & Nevis', 'NA', 8, 11, '1945-11-15', 'Active'),(97, 'St. Lucia', 'NA', 8, 11, '1945-11-15', 'Active'),(255, 'St. Maarten, Saba, St. Eustatius', 'NA', 8, 11, '1945-11-15', 'Active'),(252, 'St. Paul I.', 'NA', 5, 9, '1945-11-15', 'Active'),(253, 'St. Peter & St. Paul Rocks', 'SA', 11, 13, '1945-11-15', 'Active'),(277, 'St. Pierre & Miquelon', 'NA', 5, 9, '1945-11-15', 'Active'),(98, 'St. Vincent', 'NA', 8, 11, '1945-11-15', 'Active'),(466, 'Sudan', 'AF', 34, 48, '1945-11-15', 'Active'),(258, 'Sumatra [deleted]', 'OC', 28, 54, '1963-05-01', 'Deleted'),(140, 'Suriname', 'SA', 9, 12, '1945-11-15', 'Active'),(259, 'Svalbard', 'EU', 40, 18, '1945-11-15', 'Active'),(515, 'Swains Is.', 'OC', 32, 62, '2006-07-22', 'Active'),(261, 'Swan Is. [deleted]', 'NA', 7, 11, '1972-09-01', 'Deleted'),(468, 'Swaziland', 'AF', 38, 57, '1945-11-15', 'Active'),(284, 'Sweden', 'EU', 14, 18, '1945-11-15', 'Active'),(287, 'Switzerland', 'EU', 14, 28, '1945-11-15', 'Active'),(384, 'Syria', 'AS', 20, 39, '1945-11-15', 'Active'),(386, 'Taiwan', 'AS', 24, 44, '1945-11-15', 'Active'),(262, 'Tajikistan', 'AS', 17, 30, '1945-11-15', 'Active'),(264, 'Tangier [deleted]', 'AF', 33, 37, '1960-07-01', 'Deleted'),(470, 'Tanzania', 'AF', 37, 53, '1945-11-15', 'Active'),(507, 'Temotu Province', 'OC', 32, 51, '1998-03-31', 'Active'),(267, 'Terr. New Guinea [deleted]', 'OC', 28, 51, '1975-09-16', 'Deleted'),(387, 'Thailand', 'AS', 26, 49, '1945-11-15', 'Active'),(422, 'The Gambia', 'AF', 35, 46, '1945-11-15', 'Active'),(268, 'Tibet [deleted]', 'AS', 23, 41, '1974-05-31', 'Deleted'),(511, 'Timor - Leste', 'OC', 28, 54, '2000-03-01', 'Active'),(483, 'Togo', 'AF', 35, 46, '1945-11-15', 'Active'),(270, 'Tokelau Is.', 'OC', 31, 62, '1945-11-15', 'Active'),(160, 'Tonga', 'OC', 32, 62, '1945-11-15', 'Active'),(271, 'Trieste [deleted]', 'EU', 15, 28, '1957-04-01', 'Deleted'),(273, 'Trindade & Martin Vaz Is.', 'SA', 11, 15, '1945-11-15', 'Active'),(90, 'Trinidad & Tobago', 'SA', 9, 11, '1945-11-15', 'Active'),(274, 'Tristan da Cunha & Gough I.', 'AF', 38, 66, '1945-11-15', 'Active'),(276, 'Tromelin I.', 'AF', 39, 53, '1960-06-25', 'Active'),(474, 'Tunisia', 'AF', 33, 37, '1945-11-15', 'Active'),(390, 'Turkey', 'AS', 20, 39, '1945-11-15', 'Active'),(280, 'Turkmenistan', 'AS', 17, 30, '1945-11-15', 'Active'),(89, 'Turks & Caicos Is.', 'NA', 8, 11, '1945-11-15', 'Active'),(282, 'Tuvalu', 'OC', 31, 65, '1976-01-01', 'Active'),(283, 'UK Sov. Base Areas on Cyprus', 'AS', 20, 39, '1945-11-15', 'Active'),(286, 'Uganda', 'AF', 37, 48, '1945-11-15', 'Active'),(288, 'Ukraine', 'EU', 16, 29, '1945-11-15', 'Active'),(391, 'United Arab Emirates', 'AS', 21, 39, '1945-11-15', 'Active'),(289, 'United Nations HQ', 'NA', 5, 8, '1945-11-15', 'Active'),(291, 'United States of America', 'NA', 5, 6, '1945-11-15', 'Active'),(144, 'Uruguay', 'SA', 13, 14, '1945-11-15', 'Active'),(292, 'Uzbekistan', 'AS', 17, 30, '1945-11-15', 'Active'),(158, 'Vanuatu', 'OC', 32, 56, '1945-11-15', 'Active'),(295, 'Vatican', 'EU', 15, 28, '1945-11-15', 'Active'),(148, 'Venezuela', 'SA', 9, 12, '1945-11-15', 'Active'),(293, 'Vietnam', 'AS', 26, 49, '1945-11-15', 'Active'),(285, 'Virgin Is.', 'NA', 8, 11, '1945-11-15', 'Active'),(301, 'W. Kiribati (Gilbert Is.)', 'OC', 31, 65, '1945-11-15', 'Active'),(297, 'Wake I.', 'OC', 31, 65, '1945-11-15', 'Active'),(294, 'Wales', 'EU', 14, 27, '1945-11-15', 'Active'),(298, 'Wallis & Futuna Is.', 'OC', 32, 62, '1945-11-15', 'Active'),(488, 'Walvis Bay [deleted]', 'AF', 38, 57, '1994-03-01', 'Deleted'),(299, 'West Malaysia', 'AS', 28, 54, '1963-09-16', 'Active'),(302, 'Western Sahara', 'AF', 33, 37, '1945-11-15', 'Active'),(303, 'Willis I.', 'OC', 30, 60, '1945-11-15', 'Active'),(492, 'Yemen', 'AS', 21, 39, '1990-05-22', 'Active'),(154, 'Yemen Arab Rep. [deleted]', 'AS', 21, 39, '1990-05-22', 'Deleted'),(482, 'Zambia', 'AF', 36, 53, '1945-11-15', 'Active'),(307, 'Zanzibar [deleted]', 'AF', 37, 53, '1974-06-01', 'Deleted'),(452, 'Zimbabwe', 'AF', 38, 53, '1945-11-15', 'Active');");
9
10 drupal_set_message(t('Ham Database Tables Created.'));
11 }
12 ?>
  ViewVC Help
Powered by ViewVC 1.1.2