/*
 * Copyright ©  2022 Thomas J Collinson
 * All rights reserved
 */

CREATE TABLE `airport_widget_settings`
(
    `dispatch_idfk`      INT UNSIGNED         NOT NULL,
    `form_width`         VARCHAR(15)          NULL,
    `border_colour`      VARCHAR(30)          NULL,
    `background_colour`  VARCHAR(30)          NULL,
    `body_width`         VARCHAR(15)          NULL,
    `body_height`        VARCHAR(15)          NULL,
    `button_colour`      VARCHAR(30)          NULL,
    `button_text_colour` VARCHAR(30)          NULL,
    `font_css_url`       VARCHAR(256)         NULL,
    `font_family`        VARCHAR(100)         NULL,
    `highlight_colour`   VARCHAR(30)          NULL,
    `header_image_url`   VARCHAR(256)         NULL,
    `header_image`       TINYINT(1) DEFAULT 1 NOT NULL,
    `via`                TINYINT(1) DEFAULT 1 NOT NULL,
    `booking_date`       TINYINT(1) DEFAULT 1 NOT NULL,
    CONSTRAINT `airport_widget_settings_pk`
        PRIMARY KEY (`dispatch_idfk`),
    CONSTRAINT `airport_widget_settings_dispatch_systems_null_fk`
        FOREIGN KEY (`dispatch_idfk`) REFERENCES `dispatch_systems` (`id`)
            ON UPDATE CASCADE ON DELETE CASCADE
)
    COLLATE = `utf8_unicode_ci`;