dmitriygnatenko-v2/migrations/20220914205000_add_language_table.sql

-- +goose Up
CREATE TABLE language
(
    id         TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    url        CHAR(2)          NOT NULL UNIQUE,
    title      VARCHAR(255)     NOT NULL,
    is_default BOOL             NOT NULL DEFAULT false
);

INSERT INTO language (url, title, is_default)
VALUES ('ru', 'Русский', true),
       ('en', 'English', false);

-- +goose Down
DROP TABLE language;