From 9761a87255c1eddf23029a0492965aed713bf5de Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Sat, 8 Apr 2023 14:41:24 +0900 Subject: Add `transaction_type` enum type. --- deploy/kakeibo.transaction_type.sql | 8 ++++++++ revert/kakeibo.transaction_type.sql | 7 +++++++ sqitch.plan | 2 ++ verify/kakeibo.transaction_type.sql | 11 +++++++++++ 4 files changed, 28 insertions(+) create mode 100644 deploy/kakeibo.transaction_type.sql create mode 100644 revert/kakeibo.transaction_type.sql create mode 100644 verify/kakeibo.transaction_type.sql diff --git a/deploy/kakeibo.transaction_type.sql b/deploy/kakeibo.transaction_type.sql new file mode 100644 index 0000000..1d6cddf --- /dev/null +++ b/deploy/kakeibo.transaction_type.sql @@ -0,0 +1,8 @@ +-- Deploy life-archive:kakeibo.transaction_type to pg +-- requires: kakeibo + +BEGIN; + +CREATE TYPE kakeibo.transaction_type AS ENUM ('outgo', 'income'); + +COMMIT; diff --git a/revert/kakeibo.transaction_type.sql b/revert/kakeibo.transaction_type.sql new file mode 100644 index 0000000..7601b35 --- /dev/null +++ b/revert/kakeibo.transaction_type.sql @@ -0,0 +1,7 @@ +-- Revert life-archive:kakeibo.transaction_type from pg + +BEGIN; + +DROP TYPE kakeibo.transaction_type; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index d4c9768..54ded53 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -27,3 +27,5 @@ update_timestamp [update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:18:34Z Masaya T photo 2023-03-27T15:39:16Z Masaya Tojo # Add photo schema. photo.photos [photo] 2023-03-27T16:00:51Z Masaya Tojo # Add table for tracking photos. @v1.0.0-alpha.4 2023-04-08T04:58:15Z Masaya Tojo # Tag v1.0.0-alpha.4 + +kakeibo.transaction_type [kakeibo] 2023-04-08T05:28:15Z Masaya Tojo # Add `transaction_type` enum type. diff --git a/verify/kakeibo.transaction_type.sql b/verify/kakeibo.transaction_type.sql new file mode 100644 index 0000000..9db545a --- /dev/null +++ b/verify/kakeibo.transaction_type.sql @@ -0,0 +1,11 @@ +-- Verify life-archive:kakeibo.transaction_type on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (select 1 from pg_type where typname = 'transaction_type'); + END +$$; + +ROLLBACK; -- cgit v1.2.3