Add 'extra' field to User model

3 files changed, 14 insertions, 1 deletions

diff --git a/db/downgrade_0046---0045.sql b/db/downgrade_0046---0045.sql
new file mode 100644
index 000000000..c0cc566af
--- /dev/null
+++ b/db/downgrade_0046---0045.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE users
+    DROP COLUMN extra;
+
+COMMIT;
diff --git a/db/schema.sql b/db/schema.sql
index 27f4bad13..fe45fb4aa 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -31,7 +31,8 @@ create table users (
     title           text,
     twitter_id      bigint  unique,
     facebook_id     bigint  unique,
-    area_id         integer
+    area_id         integer,
+    extra           text
 );
 
 -- Record details of reporting bodies, including open311 configuration details
diff --git a/db/schema_0046-user-add-extra.sql b/db/schema_0046-user-add-extra.sql
new file mode 100644
index 000000000..06937237c
--- /dev/null
+++ b/db/schema_0046-user-add-extra.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE users
+    ADD COLUMN extra TEXT;
+
+COMMIT;