aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql/write_oauth_provider.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crates/secd/store/pg/sql/write_oauth_provider.sql')
-rw-r--r--crates/secd/store/pg/sql/write_oauth_provider.sql25
1 files changed, 25 insertions, 0 deletions
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;