aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2013-01-04 15:42:33 +0000
committerStruan Donald <struan@exo.org.uk>2013-01-04 15:42:33 +0000
commit8692e451268eaba507f64d3de99fdd40c7b63f80 (patch)
treef5c09b1adbb5f0212438bf6e4d8179ffdb914f5f /db
parentbc04a16b91516bee5164921d223605911fb67e44 (diff)
parent177ad0fe42f7474296287b448b485aa452e583f3 (diff)
Merge branch 'centro'
Conflicts: perllib/FixMyStreet/Cobrand/Default.pm
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql5
-rw-r--r--db/schema_0027-add_sub_category_to_problem.sql6
2 files changed, 10 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 6ebec5689..87e785de2 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -217,7 +217,10 @@ create table problem (
external_source_id text,
-- number of me toos
- interest_count integer default 0
+ interest_count integer default 0,
+
+ -- subcategory to enable filtering in reporting --
+ subcategory text
);
create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude);
create index problem_user_id_idx on problem ( user_id );
diff --git a/db/schema_0027-add_sub_category_to_problem.sql b/db/schema_0027-add_sub_category_to_problem.sql
new file mode 100644
index 000000000..6787bd371
--- /dev/null
+++ b/db/schema_0027-add_sub_category_to_problem.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER TABLE problem
+ ADD COLUMN subcategory TEXT;
+
+commit;