NG test task

CREATE TABLE IF NOT EXISTS news (
    id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT
    , date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
    , status ENUM('enabled', 'disabled') DEFAULT 'disabled'
    , INDEX (status, date)
);

CREATE TABLE IF NOT EXISTS lang (
    id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT
    , name VARCHAR(100) NOT NULL
    , abbr CHAR(2) NOT NULL COMMENT "Unique short abbreviation for language, like: ua, en, cz, pl"
    , UNIQUE (abbr)
);

CREATE TABLE IF NOT EXISTS translate_news_title (
    id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT
    , news_id INT UNSIGNED NOT NULL REFERENCES news(id)
    , lang_id SMALLINT UNSIGNED NOT NULL REFERENCES lang(id)
    , title VARCHAR(100) NOT NULL
    , FOREIGN KEY (news_id) REFERENCES news(id)
    , FOREIGN KEY (lang_id) REFERENCES lang(id)
    , UNIQUE (news_id, lang_id)
);

CREATE TABLE IF NOT EXISTS translate_news_text (
    id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT
    , news_id INT UNSIGNED NOT NULL
    , lang_id SMALLINT UNSIGNED NOT NULL
    , text TEXT NOT NULL
    , FOREIGN KEY (news_id) REFERENCES news(id)
    , FOREIGN KEY (lang_id) REFERENCES lang(id)
    , UNIQUE (news_id, lang_id)
);