-- ****************************************************************************************************
-- *      ______                                                  _                       _           *
-- *     |  ____|                                           /\   (_)                     | |          *
-- *     | |__  _   _ _ __ ___  _ __   ___  __ _ _ __      /  \   _ _ __ _ __   ___  _ __| |_ ___     *
-- *     |  __|| | | | '__/ _ \| '_ \ / _ \/ _` | '_ \    / /\ \ | | '__| '_ \ / _ \| '__| __/ __|    *
-- *     | |___| |_| | | | (_) | |_) |  __/ (_| | | | |  / ____ \| | |  | |_) | (_) | |  | |_\__ \    *
-- *     |______\__,_|_|  \___/| .__/ \___|\__,_|_| |_| /_/    \_\_|_|  | .__/ \___/|_|   \__|___/    *
-- *                           | |                                      | |                           *
-- *                           |_|                                      |_|                           *
-- *                                                                                                  *
-- ****************************************************************************************************

-- This file is part of the European Airports Project, a free, collaborative platform of airport data 
-- extending beyond the official AIPs.

-- Copyright (C) 2023

-- Florian Meissner <florianmeissner@gmx.de>

-- This program is free software: you can redistribute it and/or modify it under the 
-- terms of the GNU General Public License as published by the Free Software Foundation, either 
-- version 3 of the License, or (at your option) any later version. This program is distributed in the 
-- hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of 
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more 
-- details. You should have received a copy of the GNU General Public License along with this program. 
-- (license.md in the root folder of this project) If not, see <http://www.gnu.org/licenses/>.


USE eaMain;

START TRANSACTION;

CREATE TABLE IF NOT EXISTS `airportFrequencies` (
  `id` INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
  `airport` INT UNSIGNED NOT NULL,
  `type` ENUM(
      'A/A', 'A/G', 'AFIS', 'APP', 'ATIS', 'CNTR', 'CTAF', 'DEL', 'DEP', 'DIR', 'FIS', 
      'GND', 'MISC', 'PRE', 'UNIC', 'TWR') 
    NOT NULL DEFAULT 'MISC',
  `callsign` VARCHAR(30) NOT NULL,
  `frequency` DECIMAL(6, 3) NOT NULL COMMENT 'MHz',
  CONSTRAINT `airportFrequencies.fk_airport` FOREIGN KEY (`airport`) REFERENCES airports(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

COMMIT;
