From 59b4cd804cf9134f830109bfc51fba3856a21ea3 Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Mon, 3 Dec 2012 11:21:45 +0000
Subject: add subcategory field to problem table

---
 db/schema.sql                                  | 5 ++++-
 db/schema_0027-add_sub_category_to_problem.sql | 6 ++++++
 2 files changed, 10 insertions(+), 1 deletion(-)
 create mode 100644 db/schema_0027-add_sub_category_to_problem.sql

(limited to 'db')

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;
-- 
cgit v1.2.3