aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-04-19 09:55:22 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-04-19 09:55:22 +0900
commitad5dbda6edfa7d58062a620cf2fd6d1cbd152021 (patch)
tree18da9aa0c56acf6ae3df30732b5d49626608fa37
parent4d7ccd65f41d01babc8e438283456de0627e2ff5 (diff)
Revert "Add `transaction_type` enum type."
This reverts commit 9761a87255c1eddf23029a0492965aed713bf5de.
-rw-r--r--deploy/kakeibo.transaction_type.sql8
-rw-r--r--revert/kakeibo.transaction_type.sql7
-rw-r--r--sqitch.plan2
-rw-r--r--verify/kakeibo.transaction_type.sql11
4 files changed, 0 insertions, 28 deletions
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 <masaya@tojo.tokyo> # Add photo schema.
photo.photos [photo] 2023-03-27T16:00:51Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking photos.
@v1.0.0-alpha.4 2023-04-08T04:58:15Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.4
-
-kakeibo.transaction_type [kakeibo] 2023-04-08T05:28:15Z Masaya Tojo <masaya@tojo.tokyo> # 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;