diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2017-08-10 12:34:16 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2017-08-10 12:34:16 +0100 |
| commit | eda7a2d88e13a89e22843203cf4f749c8679b4d7 (patch) | |
| tree | 682568bc6f46d262e5755268ac65238af4562b52 /db/schema.sql | |
| parent | b862ad1300116978f98eae9a079a22d49fc4f85e (diff) | |
| parent | df1494f5a9de03c80764adf6108cbf699f547459 (diff) | |
Merge branch '1244-corps-translatable-body-names'
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) +); |