initial commit
[squeep-indie-auther] / src / db / sqlite / sql / scope-delete.sql
diff --git a/src/db/sqlite/sql/scope-delete.sql b/src/db/sqlite/sql/scope-delete.sql
new file mode 100644 (file)
index 0000000..562bb58
--- /dev/null
@@ -0,0 +1,3 @@
+-- remove an impermanent scope
+DELETE FROM scope
+       WHERE scope = :scope AND is_permanent = false