aboutsummaryrefslogtreecommitdiff
path: root/revert/delete_item.sql
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-12 17:36:46 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-12 23:38:12 +0900
commitbaaa9bb106af01c0d6d5fd9cde87a27852bb8622 (patch)
tree71e4367513b3567d5d01d5b74f96c5e663965ebf /revert/delete_item.sql
parent40c84f86e9d7326bb0020c9210e0689179b1102c (diff)
Add function to delete item.
Diffstat (limited to 'revert/delete_item.sql')
-rw-r--r--revert/delete_item.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/revert/delete_item.sql b/revert/delete_item.sql
new file mode 100644
index 0000000..d5bda39
--- /dev/null
+++ b/revert/delete_item.sql
@@ -0,0 +1,7 @@
+-- Revert kakeibo:delete_item from pg
+
+BEGIN;
+
+DROP FUNCTION kakeibo.delete_item;
+
+COMMIT;