From 131c856bdd5c48bbd8358fc8c1840fce4fcf2178 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Sun, 5 Mar 2023 14:29:29 +0900 Subject: Rename column of transactions from type to type_code. --- revert/insert_transaction.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'revert/insert_transaction.sql') diff --git a/revert/insert_transaction.sql b/revert/insert_transaction.sql index d15552f..be936fc 100644 --- a/revert/insert_transaction.sql +++ b/revert/insert_transaction.sql @@ -4,9 +4,8 @@ BEGIN; -DROP FUNCTION kakeibo.insert_transaction(INTEGER, DATE, TEXT); CREATE OR REPLACE FUNCTION kakeibo.insert_transaction( - p_type kakeibo.transaction_type, + p_type INTEGER, p_date DATE, p_note TEXT ) RETURNS INTEGER AS $$ -- cgit v1.2.3