DB changes to support OIDC auth

3 files changed, 7 insertions, 0 deletions

diff --git a/db/downgrade_0068---0067.sql b/db/downgrade_0068---0067.sql
new file mode 100644
index 000000000..c12c0374b
--- /dev/null
+++ b/db/downgrade_0068---0067.sql
@@ -0,0 +1,3 @@
+begin;
+alter table users drop column oidc_ids;
+commit;
diff --git a/db/schema.sql b/db/schema.sql
index 93d73ab00..a211ef50d 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -35,6 +35,7 @@ create table users (
     title           text,
     twitter_id      bigint  unique,
     facebook_id     bigint  unique,
+    oidc_ids        text    ARRAY,
     area_ids        integer ARRAY,
     extra           text
 );
diff --git a/db/schema_0068-oidc_login.sql b/db/schema_0068-oidc_login.sql
new file mode 100644
index 000000000..aadbef4da
--- /dev/null
+++ b/db/schema_0068-oidc_login.sql
@@ -0,0 +1,3 @@
+begin;
+alter table users add column oidc_ids text ARRAY;
+commit;