-- 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;
