Allow user to have an area assigned in admin

3 files changed, 9 insertions, 1 deletions

diff --git a/db/downgrade_0043---0042.sql b/db/downgrade_0043---0042.sql
new file mode 100644
index 000000000..5f32650aa
--- /dev/null
+++ b/db/downgrade_0043---0042.sql
@@ -0,0 +1,3 @@
+begin;
+alter table users drop column area_id;
+commit;
diff --git a/db/schema.sql b/db/schema.sql
index 48f0fd07e..b11bb30b7 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -30,7 +30,8 @@ create table users (
     is_superuser    boolean not null default 'f',
     title           text,
     twitter_id      bigint  unique,
-    facebook_id     bigint  unique
+    facebook_id     bigint  unique,
+    area_id         integer
 );
 
 -- Record details of reporting bodies, including open311 configuration details
diff --git a/db/schema_0043-add-user-area-field.sql b/db/schema_0043-add-user-area-field.sql
new file mode 100644
index 000000000..9b4b044d1
--- /dev/null
+++ b/db/schema_0043-add-user-area-field.sql
@@ -0,0 +1,4 @@
+BEGIN;
+ALTER TABLE users
+ADD COLUMN area_id integer;
+COMMIT;