diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2017-07-13 09:48:27 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2017-08-09 17:03:48 +0100 |
| commit | 46b9d8989d5ac2f8eedd196d11ceb4baf57728dd (patch) | |
| tree | 05e9e12f03c1328515afc1174cf4061f81c903fc /db/schema.sql | |
| parent | 4d18b5c100d0df1276f953b90fb3481391989376 (diff) | |
Add translation table.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql index d35071c0f..af6570b7a 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -528,3 +528,13 @@ CREATE TABLE contact_defect_types ( ALTER TABLE problem ADD COLUMN defect_type_id int REFERENCES defect_types(id); + +CREATE TABLE translation ( + id serial not null primary key, + tbl text not null, + object_id integer not null, + col text not null, + lang text not null, + msgstr text not null, + unique(tbl, object_id, col, lang) +); |