From 0920c4d4f30a3345870d385d5c6f3e0919228b56 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Mon, 12 Dec 2022 17:06:57 -0800
Subject: (oauth2 + email added): a mess that may or may not really work and
 needs to be refactored...

---
 crates/secd/store/pg/sql/write_oauth_provider.sql | 25 +++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 crates/secd/store/pg/sql/write_oauth_provider.sql

(limited to 'crates/secd/store/pg/sql/write_oauth_provider.sql')

diff --git a/crates/secd/store/pg/sql/write_oauth_provider.sql b/crates/secd/store/pg/sql/write_oauth_provider.sql
new file mode 100644
index 0000000..ba69857
--- /dev/null
+++ b/crates/secd/store/pg/sql/write_oauth_provider.sql
@@ -0,0 +1,25 @@
+insert into secd.oauth_provider (
+       oauth_provider_id
+       , name
+       , flow
+       , base_url
+       , response_type
+       , default_scope
+       , client_id
+       , client_secret
+       , redirect_url
+       , created_at
+       , deleted_at
+) values (
+       default
+       , $1
+       , $2
+       , $3
+       , $4
+       , $5
+       , $6
+       , $7
+       , $8
+       , $9
+       , $10
+) on conflict (name, flow) do nothing;
-- 
cgit v1.2.3

