initial commit

[squeep-indie-auther] / src / db / postgres / sql / scopes-insert.sql

diff --git a/src/db/postgres/sql/scopes-insert.sql b/src/db/postgres/sql/scopes-insert.sql
new file mode 100644 (file)
index 0000000..a933e28
--- /dev/null
+++ b/src/db/postgres/sql/scopes-insert.sql
@@ -0,0 +1,6 @@
+-- Insert an externally-provided scope, or ignore.
+INSERT INTO scope
+       (scope)
+SELECT
+       unnest(${scopes})
+ON CONFLICT (scope) DO NOTHING