diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0052---0051.sql | 5 | ||||
| -rw-r--r-- | db/schema.sql | 10 | ||||
| -rw-r--r-- | db/schema_0052-translation-table.sql | 13 |
3 files changed, 28 insertions, 0 deletions
diff --git a/db/downgrade_0052---0051.sql b/db/downgrade_0052---0051.sql new file mode 100644 index 000000000..715b4549f --- /dev/null +++ b/db/downgrade_0052---0051.sql @@ -0,0 +1,5 @@ +BEGIN; + +DROP TABLE translation; + +COMMIT; 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) +); diff --git a/db/schema_0052-translation-table.sql b/db/schema_0052-translation-table.sql new file mode 100644 index 000000000..95df499cc --- /dev/null +++ b/db/schema_0052-translation-table.sql @@ -0,0 +1,13 @@ +BEGIN; + +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) +); + +COMMIT; |