initial commit

[squeep-indie-auther] / src / db / postgres / sql / scope-delete.sql

diff --git a/src/db/postgres/sql/scope-delete.sql b/src/db/postgres/sql/scope-delete.sql
new file mode 100644 (file)
index 0000000..9fd42a2
--- /dev/null
+++ b/src/db/postgres/sql/scope-delete.sql
@@ -0,0 +1,3 @@
+-- remove an inpermanent scope
+DELETE FROM scope
+       WHERE scope = $(scope) AND is_permanent = false