QM8S7uWr

1CREATE TABLE IF NOT EXISTS messages
2(
3    lang_id SMALLINT(4) UNSIGNED NOT NULL,
4    msgid VARCHAR(100) NOT NULL,
5    msgstr TEXT NOT NULL,
6    PRIMARY KEY (lang_id, msgid)
7) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
8
9CREATE TABLE IF NOT EXISTS languages
10(
11    id SMALLINT(4) UNSIGNED NOT NULL,
12    code CHAR(5) NOT NULL,
13    enabled TINYINT(1) NOT NULL DEFAULT 1,
14    PRIMARY KEY (id),
15    UNIQUE KEY (code),
16    KEY (enabled)
17) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;