From ad5dbda6edfa7d58062a620cf2fd6d1cbd152021 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Wed, 19 Apr 2023 09:55:22 +0900 Subject: Revert "Add `transaction_type` enum type." This reverts commit 9761a87255c1eddf23029a0492965aed713bf5de. --- 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 deletions(-) delete mode 100644 deploy/kakeibo.transaction_type.sql delete mode 100644 revert/kakeibo.transaction_type.sql delete mode 100644 verify/kakeibo.transaction_type.sql diff --git a/deploy/kakeibo.transaction_type.sql b/deploy/kakeibo.transaction_type.sql deleted file mode 100644 index 1d6cddf..0000000 --- a/deploy/kakeibo.transaction_type.sql +++ /dev/null @@ -1,8 +0,0 @@ --- 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 deleted file mode 100644 index 7601b35..0000000 --- a/revert/kakeibo.transaction_type.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert life-archive:kakeibo.transaction_type from pg - -BEGIN; - -DROP TYPE kakeibo.transaction_type; - -COMMIT; diff --git a/sqitch.plan b/sqitch.plan index 54ded53..d4c9768 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -27,5 +27,3 @@ 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 deleted file mode 100644 index 9db545a..0000000 --- a/verify/kakeibo.transaction_type.sql +++ /dev/null @@ -1,11 +0,0 @@ --- 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