CREATE TABLE IF NOT EXISTS `cmw_core_options`
(
    `option_name`    VARCHAR(255) NOT NULL PRIMARY KEY,
    `option_value`   VARCHAR(500) NOT NULL,
    `option_updated` TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_mail_config_smtp`
(
    `mail_config_id`           INT(11)      NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `mail_config_mail`         VARCHAR(255) NOT NULL,
    `mail_config_mail_reply`   VARCHAR(255) NOT NULL,
    `mail_config_address_smtp` VARCHAR(255) NOT NULL,
    `mail_config_user`         VARCHAR(255) NOT NULL,
    `mail_config_port`         INT(5)       NOT NULL,
    `mail_config_protocol`     VARCHAR(50)  NOT NULL,
    `mail_config_body`         LONGTEXT     NULL,
    `mail_config_footer`       MEDIUMTEXT   NULL,
    `mail_config_enable`       TINYINT(1)   NOT NULL DEFAULT 1
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users`
(
    `user_id`                       INT(11)      NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `user_email`                    VARCHAR(500) NOT NULL,
    `user_pseudo`                   VARCHAR(255)          DEFAULT NULL,
    `user_firstname`                VARCHAR(255)          DEFAULT NULL,
    `user_lastname`                 VARCHAR(255)          DEFAULT NULL,
    `user_password`                 VARCHAR(255)          DEFAULT NULL,
    `user_state`                    TINYINT(1)   NOT NULL DEFAULT '1',
    `user_key`                      VARCHAR(255) NOT NULL,
    `user_terms_accepted`           TINYINT(1) NOT NULL DEFAULT 0,
    `user_terms_accepted_at`        DATETIME NULL,
    `user_created`                  TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `user_updated`                  TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `user_logged`                   TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY `user_email` (`user_email`),
    UNIQUE KEY `user_pseudo` (`user_pseudo`)
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE INDEX idx_registration_date ON cmw_users (user_created);

CREATE TABLE IF NOT EXISTS `cmw_users_remember_tokens`
(
    `token_id`       INT AUTO_INCREMENT PRIMARY KEY,
    `user_id`        INT          NOT NULL,
    `token_selector` VARCHAR(64)  NOT NULL,
    `token_hash`     VARCHAR(255) NOT NULL,
    `user_agent`     VARCHAR(512) DEFAULT NULL,
    `ip_address`     VARCHAR(45)  DEFAULT NULL,
    `created_at`     TIMESTAMP    DEFAULT CURRENT_TIMESTAMP,
    `last_used_at`   TIMESTAMP    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `expires_at`     TIMESTAMP    NOT NULL,
    INDEX `idx_user_id` (`user_id`),
    INDEX `idx_token_selector` (`token_selector`),
    INDEX `idx_expires_at` (`expires_at`),
    FOREIGN KEY (`user_id`) REFERENCES `cmw_users` (`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT ='Secure remember-me tokens for persistent authentication';


CREATE TABLE IF NOT EXISTS `cmw_users_2fa`
(
    `users_2fa_user_id`     INT(11)      NOT NULL PRIMARY KEY,
    `users_2fa_is_enabled`  TINYINT(1)   NOT NULL DEFAULT 0,
    `users_2fa_secret`      VARCHAR(255) NOT NULL,
    `users_2fa_is_enforced` TINYINT(1)   NOT NULL DEFAULT 0,
    CONSTRAINT `cmw_users_2fa_ibfk_1` FOREIGN KEY (`users_2fa_user_id`)
        REFERENCES `cmw_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_oauth`
(
    `id`      INT          NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `methode` VARCHAR(35)  NOT NULL,
    `data`    VARCHAR(500) NOT NULL,
    `user_id` INT          NOT NULL,
    INDEX (`user_id`),
    UNIQUE KEY (`methode`, `data`),
    CONSTRAINT FOREIGN KEY (`user_id`)
        REFERENCES `cmw_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_oauth_methods_enabled`
(
    `id`           INT         NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `methode`      VARCHAR(35) NOT NULL UNIQUE KEY,
    `date_enabled` TIMESTAMP   NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_pictures`
(
    `users_pictures_user_id`     INT          NOT NULL PRIMARY KEY,
    `users_pictures_image_name`  VARCHAR(255) NOT NULL,
    `users_pictures_last_update` TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT `cmw_users_pictures_ibfk_1` FOREIGN KEY (`users_pictures_user_id`)
        REFERENCES `cmw_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_settings`
(
    `users_settings_name`    VARCHAR(255) NOT NULL PRIMARY KEY,
    `users_settings_value`   VARCHAR(255) NOT NULL,
    `users_settings_updated` TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_reset_password_link`
(
    `users_mail`        VARCHAR(255) NOT NULL PRIMARY KEY,
    `secret_link`       VARCHAR(255) NOT NULL,
    `secret_date`       TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP
    ) ENGINE = InnoDB
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_long_date_code`
(
    `users_mail`           VARCHAR(255) NOT NULL PRIMARY KEY,
    `long_date_code`       VARCHAR(255) NOT NULL,
    `long_date_date`       TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP
    ) ENGINE = InnoDB
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_roles`
(
    `role_id`          INT(11)  NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `role_name`        TINYTEXT NOT NULL,
    `role_description` TEXT,
    `role_weight`      INT        DEFAULT 0,
    `role_is_default`  TINYINT(1) DEFAULT 0
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `cmw_users_roles`
(
    `id`      INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `user_id` INT(11) NOT NULL,
    `role_id` INT(11) NOT NULL,
    KEY `user_id` (`user_id`),
    KEY `role_id` (`role_id`),
    CONSTRAINT `cmw_users_roles_ibfk_1` FOREIGN KEY (`user_id`)
        REFERENCES `cmw_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `cmw_users_roles_ibfk_2` FOREIGN KEY (`role_id`)
        REFERENCES `cmw_roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_permissions
(
    permission_id          INT AUTO_INCREMENT PRIMARY KEY,
    permission_parent_id   INT                         NULL,
    permission_code        VARCHAR(50) CHARSET utf8mb4 NOT NULL,
    permission_description VARCHAR(255)                NULL,
    CONSTRAINT FK_PERMISSION_PARENT_ID
        FOREIGN KEY (permission_parent_id) REFERENCES cmw_permissions (permission_id)
            ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE = InnoDB
  CHARSET = utf8mb4;


CREATE TABLE IF NOT EXISTS cmw_roles_permissions
(
    permission_id INT NOT NULL,
    role_id       INT NOT NULL,
    PRIMARY KEY (role_id, permission_id),
    INDEX (role_id),
    CONSTRAINT FK_ROLE_PERMISSION_PERMISSION_ID
        FOREIGN KEY (permission_id) REFERENCES cmw_permissions (permission_id) ON DELETE CASCADE,
    CONSTRAINT FK_ROLE_PERMISSION_ROLE_ID
        FOREIGN KEY (role_id) REFERENCES cmw_roles (role_id) ON DELETE CASCADE
) ENGINE = InnoDB
  CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `cmw_menus`
(
    `menu_id`            INT(11)             NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `menu_name`          VARCHAR(255)        NOT NULL,
    `menu_url`           VARCHAR(255)        NOT NULL,
    `menu_parent_id`     INT(11) DEFAULT NULL,
    `menu_is_restricted` INT(1)  DEFAULT 0,
    `menu_is_custom_url` INT(1)  DEFAULT 0,
    `menu_order`         INT(10) UNSIGNED    NOT NULL,
    `menu_target_blank`  TINYINT(1) UNSIGNED NOT NULL,
    KEY `menu_parent_id` (`menu_parent_id`),
    CONSTRAINT `cmw_menus_ibfk_1` FOREIGN KEY (`menu_parent_id`)
        REFERENCES `cmw_menus` (`menu_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_menus_groups_allowed`
(
    `menus_groups_id`       INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `menus_groups_group_id` INT(11) NOT NULL,
    `menus_groups_menu_id`  INT(11) NOT NULL,
    KEY `menus_groups_group_id` (`menus_groups_group_id`),
    KEY `menus_groups_menu_id` (`menus_groups_menu_id`),
    CONSTRAINT `cmw_menus_groups_allowed_ibfk_1` FOREIGN KEY (`menus_groups_group_id`)
        REFERENCES `cmw_roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `cmw_menus_groups_allowed_ibfk_2` FOREIGN KEY (`menus_groups_menu_id`)
        REFERENCES `cmw_menus` (`menu_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_core_terms
(
    term_id                 INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    term_type               ENUM('terms_of_service','terms_of_sale','privacy_policy','legal_notice','cookie_policy','acceptable_use','license','refund_policy') NOT NULL,
    term_content            LONGTEXT NOT NULL,
    term_requires_accept    TINYINT(1) NOT NULL DEFAULT 1,
    term_published_at       DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    term_last_editor        INT(11) DEFAULT NULL,
    INDEX idx_type_pub (term_type, term_published_at),
    CONSTRAINT `cmw_core_terms_ibfk_1` FOREIGN KEY (`term_last_editor`)
    REFERENCES `cmw_users` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_core_terms_settings (
    term_type   ENUM('terms_of_service','terms_of_sale','privacy_policy','legal_notice','cookie_policy','acceptable_use','license','refund_policy') NOT NULL PRIMARY KEY,
    is_active   TINYINT(1) NOT NULL DEFAULT 1,
    updated_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_theme_config`
(
    `theme_config_id`    INT          NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `theme_config_name`  VARCHAR(255) NOT NULL,
    `theme_config_value` MEDIUMTEXT   NULL,
    `theme_config_theme` VARCHAR(255) NOT NULL
) ENGINE = InnoDB
  CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `cmw_core_routes`
(
    `core_routes_id`            INT                                   NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `core_routes_slug`          VARCHAR(300)                          NOT NULL,
    `core_routes_package`       VARCHAR(50)                           NOT NULL DEFAULT 'core',
    `core_routes_title`         VARCHAR(75)                           NOT NULL,
    `core_routes_method`        VARCHAR(10)                           NOT NULL DEFAULT 'GET',
    `core_routes_is_admin`      TINYINT(1)                            NOT NULL DEFAULT '0',
    `core_routes_is_dynamic`    TINYINT(1)                            NOT NULL DEFAULT '0',
    `core_routes_weight`        INT                                   NOT NULL DEFAULT '1',
    `core_routes_last_edit`     TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `core_routes_date_creation` TIMESTAMP                             NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARSET = utf8mb4;

CREATE TABLE IF NOT EXISTS `cmw_visits`
(
    `visits_id`       INT(11)      NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `visits_ip`       VARCHAR(39)  NOT NULL,
    `visits_date`     TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `visits_path`     VARCHAR(255) NOT NULL,
    `visits_package`  VARCHAR(255)          DEFAULT NULL,
    `visits_code`     INT(4)       NOT NULL,
    `visits_is_admin` TINYINT(4)   NOT NULL DEFAULT '0'
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE INDEX idx_visits_date ON cmw_visits (visits_date);
CREATE INDEX idx_visits_ip_partial ON cmw_visits (visits_ip(15));
CREATE INDEX idx_visits_date_ip ON cmw_visits (visits_date, visits_ip);

CREATE TABLE IF NOT EXISTS `cmw_maintenance`
(
    `maintenance_id`                  INT(11)                               NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `maintenance_no_end`              TINYINT(1)                            NOT NULL DEFAULT '0',
    `maintenance_is_enable`           TINYINT(1)                            NOT NULL DEFAULT '0',
    `maintenance_is_override_theme`   TINYINT(1)                            NOT NULL DEFAULT '0',
    `maintenance_override_theme_code` LONGTEXT                              NULL,
    `maintenance_title`               VARCHAR(255)                          NULL,
    `maintenance_description`         LONGTEXT                              NULL,
    `maintenance_type`                TINYINT(1)                            NULL,
    `maintenance_target_date`         TIMESTAMP                             NULL,
    `maintenance_last_updated_at`     TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `cmw_users_blacklist_pseudo`
(
    `id`             INT(11)      NOT NULL AUTO_INCREMENT,
    `pseudo`         VARCHAR(255) NOT NULL,
    `blacklisted_at` TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE (`pseudo`)
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_users_enforced2fa_roles
(
    enforced2fa_roles INT PRIMARY KEY,
    CONSTRAINT fk_enforced2fa_roles FOREIGN KEY (enforced2fa_roles)
        REFERENCES `cmw_roles` (`role_id`) ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_notification
(
    notification_id             INT AUTO_INCREMENT PRIMARY KEY,
    notification_package_name   VARCHAR(50)  NOT NULL,
    notification_title          VARCHAR(255) NOT NULL,
    notification_message        VARCHAR(255) NOT NULL,
    notification_slug           VARCHAR(255) NULL,
    notification_readed         TINYINT(1)   NOT NULL DEFAULT 0,
    notification_readed_silence TINYINT(1)   NOT NULL DEFAULT 0,
    notification_created_at     TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    notification_updated_at     TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_notification_settings
(
    notification_settings_id   INT AUTO_INCREMENT PRIMARY KEY,
    notification_settings_name VARCHAR(50)  NOT NULL,
    notification_settings_key  VARCHAR(255) NOT NULL
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_notification_refused_package
(
    notification_package_name VARCHAR(50) NOT NULL
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cmw_actived_resources
(
    activated_resource_id   INT AUTO_INCREMENT PRIMARY KEY,
    resource_key            VARCHAR(255) NOT NULL,
    resource_id             INT NOT NULL,
    resource_name           VARCHAR(80) NULL,
    resource_activate_at    TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP
    ) ENGINE = InnoDB
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;

/* INSERT AREA */
INSERT INTO cmw_core_terms (term_type, term_content, term_requires_accept)
VALUES ('terms_of_service', 'Write your ToS here', 1),
        ('terms_of_sale', 'Write your ToS (sales) here', 1),
        ('privacy_policy', 'Write your privacy policy here', 1),
        ('legal_notice', 'Write your legal notice here', 0),
        ('cookie_policy', 'Write your cookie policy here', 0),
        ('acceptable_use', 'Write your acceptable use guidelines here', 0),
        ('license', 'Write your license here', 0),
        ('refund_policy', 'Write your refund policy here', 0);

INSERT INTO cmw_core_terms_settings (term_type, is_active)
VALUES ('terms_of_service', 1),
        ('privacy_policy',   1),
        ('legal_notice',     1),
        ('cookie_policy',    1),
        ('terms_of_sale',    0),
        ('acceptable_use',   0),
        ('license',          0),
        ('refund_policy',    0)
    ON DUPLICATE KEY UPDATE is_active = VALUES(is_active);

INSERT INTO `cmw_core_options` (`option_name`, `option_value`, `option_updated`)
VALUES ('theme', 'Sampler', NOW()),
       ('captcha', 'none', NOW()),
       ('dateFormat', 'd-m-Y H:i:s', NOW()),
       ('editor_style', 'a11y-dark.css', NOW());

INSERT INTO `cmw_roles` (`role_name`, `role_description`, `role_weight`, `role_is_default`)
VALUES ('Visiteur', 'Rôle pour les visiteurs', 0, 0),
       ('Utilisateur', 'Rôle pour les utilisateurs', 1, 1),
       ('Editeur', 'Rôle pour les éditeurs', 5, 0),
       ('Modérateur', 'Rôle pour les modérateurs', 10, 0),
       ('Administrateur', 'Rôle pour les administrateurs', 100, 0);


INSERT INTO `cmw_permissions` (`permission_id`, `permission_parent_id`, `permission_code`)
VALUES (1, NULL, 'operator');

#Insert operator permission for the admin role
INSERT INTO `cmw_roles_permissions` (`permission_id`, `role_id`)
VALUES ('1', '5');

#Insert the Default profile picture image
INSERT INTO `cmw_users_settings` (users_settings_name, users_settings_value)
VALUES ('defaultImage', 'defaultImage.jpg'),
       ('resetPasswordMethod', '1'),
       ('listEnforcedToggle', '0'),
       ('profilePage', '1'),
       ('securityReinforced', '0'),
       ('needTerms', '0'),
       ('needTextTerms', 'J’accepte les <a target="_blank" href="/all_terms">Termes et Conditions</a>');

INSERT INTO `cmw_maintenance` (maintenance_is_enable, maintenance_title, maintenance_description, maintenance_type,
                               maintenance_target_date)
VALUES (0, 'Maintenance', 'Maintenance en cours !', NULL, NULL);

INSERT INTO `cmw_menus` (menu_id, menu_name, menu_url, menu_parent_id, menu_is_restricted, menu_order,
                         menu_target_blank)
VALUES (1, 'Accueil', 'home', NULL, 0, 1, 0),
       (2, 'CraftMyWebsite', 'https://craftmywebsite.fr', NULL, 1, 2, 1);

INSERT INTO `cmw_menus_groups_allowed` (menus_groups_id, menus_groups_group_id, menus_groups_menu_id)
VALUES (1, 5, 2);

INSERT INTO `cmw_notification_settings` (`notification_settings_name`, `notification_settings_key`)
VALUES ('showOnDiscord', '0'),
       ('webhookDiscord', ''),
       ('sendMail', '0'),
       ('mailReceiver', '');