initial commit

[squeep-indie-auther] / src / db / sqlite / sql / scope-insert.sql

diff --git a/src/db/sqlite/sql/scope-insert.sql b/src/db/sqlite/sql/scope-insert.sql
new file mode 100644 (file)
index 0000000..78d26c0
--- /dev/null
+++ b/src/db/sqlite/sql/scope-insert.sql
@@ -0,0 +1,5 @@
+-- Insert an externally-provided scope, or ignore.
+INSERT INTO scope
+       (scope)
+VALUES (:scope)
+ON CONFLICT (scope) DO NOTHING