aircraft.sql

-- Adminer 4.3.1 MySQL dump

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `aircraft` /*!40100 DEFAULT CHARACTER SET utf8 */;


SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `A` varchar(4) DEFAULT NULL,
  `B` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `countries` (`id`, `A`, `B`) VALUES
(1, 'AP', 'Pakistan'),
(2, 'A2', 'Botswana'),
(3, 'A4O',  'Oman'),
(4, 'A6', 'United Arab Emirates'),
(5, 'A7', 'Qatar'),
(6, 'A9C',  'Bahrain'),
(7, 'B',  'China'),
(8, 'C',  'Canada'),
(9, 'C5', 'Gambia'),
(10,  'C6', 'Bahamas'),
(11,  'C9', 'Mozambique'),
(12,  'CC', 'Chile'),
(13,  'CN', 'Morocco'),
(14,  'CP', 'Bolivia'),
(15,  'CS', 'Portugal'),
(16,  'CX', 'Uruguay'),
(17,  'D',  'Germany'),
(18,  'D2', 'Angola'),
(19,  'E3', 'Eritrea'),
(20,  'E7', 'Bosnia and Herzegovina'),
(21,  'EC', 'Spain'),
(22,  'EI', 'Ireland'),
(23,  'EP', 'Iran'),
(24,  'ER', 'Moldova'),
(25,  'ES', 'Estonia'),
(26,  'EZ', 'Turkmenistan'),
(27,  'F',  'France'),
(28,  'G',  'United Kingdom'),
(29,  'HA', 'Hungary'),
(30,  'HB', 'Switzerland'),
(31,  'HI', 'Dominican Republic'),
(32,  'HK', 'Colombia'),
(33,  'HL', 'South Korea'),
(34,  'HP', 'Panama'),
(35,  'HR', 'Honduras'),
(36,  'HS', 'Thailand'),
(37,  'HZ', 'Saudi Arabia'),
(38,  'I',  'Italy'),
(39,  'J8', 'Saint Vincent and the Grenadines'),
(40,  'JA', 'Japan'),
(41,  'JY', 'Jordan'),
(42,  'LN', 'Norway'),
(43,  'LQ', 'Argentina'),
(44,  'LV', 'Argentina'),
(45,  'LX', 'Luxembourg'),
(46,  'LY', 'Lithuania'),
(47,  'LZ', 'Bulgaria'),
(48,  'M',  'Isle of Man'),
(49,  'N',  'United States'),
(50,  'OB', 'Peru'),
(51,  'OD', 'Lebanon'),
(52,  'OE', 'Austria'),
(53,  'OH', 'Finland'),
(54,  'OK', 'Czech Republic'),
(55,  'OM', 'Slovakia'),
(56,  'OO', 'Belgium'),
(57,  'OY', 'Denmark'),
(58,  'P2', 'Papua New Guinea'),
(59,  'P4', 'Aruba'),
(60,  'PH', 'Netherlands'),
(61,  'PJ', 'Netherlands Antilles'),
(62,  'PK', 'Indonesia'),
(63,  'PP', 'Brazil'),
(64,  'PR', 'Brazil'),
(65,  'PT', 'Brazil'),
(66,  'RA', 'Russian Federation'),
(67,  'RP', 'Philippines'),
(68,  'S2', 'Bangladesh'),
(69,  'S5', 'Slovenia'),
(70,  'SE', 'Sweden'),
(71,  'SP', 'Poland'),
(72,  'ST', 'Sudan'),
(73,  'SU', 'Egypt'),
(74,  'SX', 'Greece'),
(75,  'T7', 'San Marino'),
(76,  'TC', 'Turkey'),
(77,  'TG', 'Guatemala'),
(78,  'TJ', 'Cameroon'),
(79,  'TN', 'Congo'),
(80,  'TR', 'Gabon'),
(81,  'TS', 'Tunisia'),
(82,  'TT', 'Chad'),
(83,  'TU', 'Ivory Coast'),
(84,  'UP', 'Kazakhstan'),
(85,  'UR', 'Ukraine'),
(86,  'V8', 'Brunei'),
(87,  'VH', 'Australia'),
(88,  'VP-B', 'Bermuda'),
(89,  'VP-C', 'Cayman Islands'),
(90,  'VT', 'India'),
(91,  'XA', 'Mexico'),
(92,  'XB', 'Mexico'),
(93,  'XC', 'Mexico'),
(94,  'YI', 'Iraq'),
(95,  'YK', 'Syria'),
(96,  'YL', 'Latvia'),
(97,  'YR', 'Romania'),
(98,  'YU', 'Serbia'),
(99,  'YV', 'Venezuela'),
(100, 'ZK', 'New Zealand'),
(101, 'ZP', 'Paraguay'),
(102, 'ZS', 'South Africa'),
(103, '2',  'Guernsey'),
(104, '3A', 'Monaco'),
(105, '3B', 'Mauritius'),
(106, '3C', 'Equatorial Guinea'),
(107, '4K', 'Azerbaijan'),
(108, '4L', 'Georgia'),
(109, '4O', 'Montenegro'),
(110, '4X', 'Israel'),
(111, '5A', 'Libya'),
(112, '5B', 'Cyprus'),
(113, '5H', 'Tanzania'),
(114, '5N', 'Nigeria'),
(115, '5R', 'Madagascar'),
(116, '5V', 'Togo'),
(117, '5X', 'Uganda'),
(118, '5Y', 'Kenya'),
(119, '6V', 'Senegal'),
(120, '7T', 'Algeria'),
(121, '8P', 'Barbados'),
(122, '9A', 'Croatia'),
(123, '9G', 'Ghana'),
(124, '9H', 'Malta'),
(125, '9J', 'Zambia'),
(126, '9K', 'Kuwait'),
(127, '9M', 'Malaysia'),
(128, '9Q', 'Zaire'),
(129, '9U', 'Burundi'),
(130, '5U', 'Niger'),
(131, '9V', 'Singapore'),
(132, 'B-T',  'Taiwan'),
(133, 'EK', 'Armenia'),
(134, 'EW', 'Belarus'),
(135, 'HC', 'Ecuador'),
(136, 'S9', 'São Tomé and Príncipe'),
(137, 'TI', 'Costa Rica '),
(138, 'TZ', 'Mali'),
(139, 'V5', 'Namibia'),
(140, 'XY', 'Myanmar'),
(141, 'Z3', 'Macedonia, Republic of'),
(142, 'ZJ', 'Jersey'),
(143, 'E5', 'Cook Islands'),
(144, 'J2', 'Djibouti'),
(145, 'ZA', 'Albania');

DROP TABLE IF EXISTS `planes`;
CREATE TABLE `planes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `conNumber` varchar(255) NOT NULL,
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `countryCode` varchar(10) DEFAULT NULL,
  `seenScrape` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `allFields` (`reg`,`type`,`conNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `planesNew`;
CREATE TABLE `planesNew` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg` varchar(255) CHARACTER SET latin1 NOT NULL,
  `type` varchar(255) CHARACTER SET latin1 NOT NULL,
  `conNumber` varchar(255) CHARACTER SET latin1 NOT NULL,
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `countryCode` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `allFields` (`reg`,`type`,`conNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;