aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorDave Arter <davea@mysociety.org>2017-07-24 09:59:06 +0100
committerDave Arter <davea@mysociety.org>2017-08-17 13:21:31 +0100
commitfb03c300258b5d1dc419d7d08ecb3afa12a2fa5b (patch)
treec110c92155be4cfeadd91d1d663df0684c341929 /db
parent653d8b84d6a14f1759950e774b9b1a8bbba5f1b1 (diff)
Add site-wide extra fields for reports, and admin UI to manage
- Also provides an editor for the extra Open311 fields on contacts. - Adds .btn--small class for small buttons Fixes #1743.
Diffstat (limited to 'db')
-rw-r--r--db/downgrade_0053---0052.sql5
-rw-r--r--db/schema.sql8
-rw-r--r--db/schema_0053-add-report-extra-fields-table.sql11
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;