diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0053---0052.sql | 5 | ||||
| -rw-r--r-- | db/schema.sql | 8 | ||||
| -rw-r--r-- | db/schema_0053-add-report-extra-fields-table.sql | 11 |
3 files changed, 24 insertions, 0 deletions
diff --git a/db/downgrade_0053---0052.sql b/db/downgrade_0053---0052.sql new file mode 100644 index 000000000..fdad6d0b8 --- /dev/null +++ b/db/downgrade_0053---0052.sql @@ -0,0 +1,5 @@ +BEGIN; + +DROP TABLE report_extra_fields; + +COMMIT; diff --git a/db/schema.sql b/db/schema.sql index af6570b7a..ed930a13e 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -538,3 +538,11 @@ CREATE TABLE translation ( msgstr text not null, unique(tbl, object_id, col, lang) ); + +CREATE TABLE report_extra_fields ( + id serial not null primary key, + name text not null, + cobrand text, + language text, + extra text +); diff --git a/db/schema_0053-add-report-extra-fields-table.sql b/db/schema_0053-add-report-extra-fields-table.sql new file mode 100644 index 000000000..be92abd47 --- /dev/null +++ b/db/schema_0053-add-report-extra-fields-table.sql @@ -0,0 +1,11 @@ +BEGIN; + +CREATE TABLE report_extra_fields ( + id serial not null primary key, + name text not null, + cobrand text, + language text, + extra text +); + +COMMIT; |