mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-24 05:05:20 -04:00
19 lines
447 B
SQL
19 lines
447 B
SQL
-- Up
|
|
|
|
CREATE TABLE translations (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
locale TEXT NOT NULL,
|
|
tKey TEXT NOT NULL,
|
|
tValue TEXT NOT NULL,
|
|
status INTEGER NOT NULL,
|
|
author_id TEXT NULL REFERENCES users(id)
|
|
);
|
|
|
|
CREATE INDEX "translations_locale" ON "translations" ("locale");
|
|
CREATE INDEX "translations_key" ON "translations" ("key");
|
|
CREATE INDEX "translations_status" ON "translations" ("status");
|
|
|
|
-- Down
|
|
|
|
DROP TABLE translations;
|