SQL

Auto-created on resource start via oxmysql. Run this only if creating manually.

CREATE TABLE IF NOT EXISTS `nm1_notify_settings` (
    `identifier`           VARCHAR(60)  NOT NULL,
    `variant`              TINYINT      NOT NULL DEFAULT 1,
    `position`             VARCHAR(20)  NOT NULL DEFAULT 'top-right',
    `mute_sound`           TINYINT(1)   NOT NULL DEFAULT 0,
    `disable_animations`   TINYINT(1)   NOT NULL DEFAULT 0,
    `updated_at`           TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;