> For the complete documentation index, see [llms.txt](https://docs.nm1scripts.in/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nm1scripts.in/classy-series/advanced-classy-notification/sql.md).

# SQL

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

```sql
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;

```