aboutsummaryrefslogtreecommitdiff
path: root/revert/insert_item.sql
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-12 16:45:59 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-12 23:38:12 +0900
commit40c84f86e9d7326bb0020c9210e0689179b1102c (patch)
tree6c884c18704fa726f1784fd6884048897b16d743 /revert/insert_item.sql
parent1a838c115140bdf0f35054351153fb21f2a228da (diff)
Add function to add new item.
Diffstat (limited to 'revert/insert_item.sql')
-rw-r--r--revert/insert_item.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/revert/insert_item.sql b/revert/insert_item.sql
new file mode 100644
index 0000000..40417f0
--- /dev/null
+++ b/revert/insert_item.sql
@@ -0,0 +1,7 @@
+-- Revert kakeibo:insert_item from pg
+
+BEGIN;
+
+DROP FUNCTION kakeibo.insert_item;
+
+COMMIT;