diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0043---0042.sql | 3 | ||||
| -rw-r--r-- | db/schema.sql | 3 | ||||
| -rw-r--r-- | db/schema_0043-add-user-area-field.sql | 4 |
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; |