Make transaction type integer.

1 files changed, 16 insertions, 0 deletions

diff --git a/verify/transaction_type_to_integer.sql b/verify/transaction_type_to_integer.sql
new file mode 100644
index 0000000..808d5df
--- /dev/null
+++ b/verify/transaction_type_to_integer.sql
@@ -0,0 +1,16 @@
+-- Verify kakeibo:transaction_type_to_integer on pg
+
+BEGIN;
+
+DO $$
+  BEGIN
+    ASSERT(SELECT 1
+             FROM information_schema.columns 
+            WHERE table_name = 'transactions'
+              AND table_schema = 'kakeibo'
+              AND column_name = 'type'
+              AND data_type = 'integer');
+  END
+$$;
+
+ROLLBACK;