add extra column to body table

Adds and extra column for bodies and the associated Extra role.

3 files changed, 12 insertions, 1 deletions

diff --git a/db/downgrade_0061---0060.sql b/db/downgrade_0061---0060.sql
new file mode 100644
index 000000000..d6934b9b0
--- /dev/null
+++ b/db/downgrade_0061---0060.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE body DROP extra;
+
+COMMIT;
diff --git a/db/schema.sql b/db/schema.sql
index d08ea675d..fa0bd07bd 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -57,7 +57,8 @@ create table body (
     fetch_problems boolean not null default 'f',
     blank_updates_permitted boolean not null default 'f',
     convert_latlong boolean not null default 'f',
-    deleted boolean not null default 'f'
+    deleted boolean not null default 'f',
+    extra           text
 );
 
 create table body_areas (
diff --git a/db/schema_0061-add-extra-body.sql b/db/schema_0061-add-extra-body.sql
new file mode 100644
index 000000000..125b171fb
--- /dev/null
+++ b/db/schema_0061-add-extra-body.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE body ADD extra text;
+
+COMMIT;