diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0039---0038.sql | 4 | ||||
| -rwxr-xr-x | db/rerun_dbic_loader.pl | 2 | ||||
| -rw-r--r-- | db/schema.sql | 4 | ||||
| -rw-r--r-- | db/schema_0039-social-login.sql | 4 |
4 files changed, 12 insertions, 2 deletions
diff --git a/db/downgrade_0039---0038.sql b/db/downgrade_0039---0038.sql new file mode 100644 index 000000000..62bbc42ef --- /dev/null +++ b/db/downgrade_0039---0038.sql @@ -0,0 +1,4 @@ +begin; +alter table users drop column twitter_id; +alter table users drop column facebook_id; +commit; diff --git a/db/rerun_dbic_loader.pl b/db/rerun_dbic_loader.pl index d7dfd1c10..958b28241 100755 --- a/db/rerun_dbic_loader.pl +++ b/db/rerun_dbic_loader.pl @@ -32,6 +32,6 @@ make_schema_at( components => [ 'FilterColumn', 'InflateColumn::DateTime', 'EncodedColumn' ], }, - FixMyStreet->dbic_connect_info(), + [ FixMyStreet->dbic_connect_info ], ); diff --git a/db/schema.sql b/db/schema.sql index 72fccd7f3..3761553a5 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -27,7 +27,9 @@ create table users ( password text not null default '', from_body integer, flagged boolean not null default 'f', - title text + title text, + twitter_id bigint unique, + facebook_id bigint unique ); -- Record details of reporting bodies, including open311 configuration details diff --git a/db/schema_0039-social-login.sql b/db/schema_0039-social-login.sql new file mode 100644 index 000000000..ae55d5655 --- /dev/null +++ b/db/schema_0039-social-login.sql @@ -0,0 +1,4 @@ +begin; +alter table users add column twitter_id bigint unique; +alter table users add column facebook_id bigint unique; +commit; |