aboutsummaryrefslogtreecommitdiff
path: root/deploy
diff options
context:
space:
mode:
Diffstat (limited to 'deploy')
-rw-r--r--deploy/transaction_type.sql5
-rw-r--r--deploy/transaction_type@v1.0.0-dev1.sql11
2 files changed, 12 insertions, 4 deletions
diff --git a/deploy/transaction_type.sql b/deploy/transaction_type.sql
index b29421f..a101f75 100644
--- a/deploy/transaction_type.sql
+++ b/deploy/transaction_type.sql
@@ -3,9 +3,6 @@
BEGIN;
-CREATE TYPE kakeibo.transaction_type AS ENUM(
- 'income',
- 'outgo'
-);
+DROP TYPE kakeibo.transaction_type;
COMMIT;
diff --git a/deploy/transaction_type@v1.0.0-dev1.sql b/deploy/transaction_type@v1.0.0-dev1.sql
new file mode 100644
index 0000000..b29421f
--- /dev/null
+++ b/deploy/transaction_type@v1.0.0-dev1.sql
@@ -0,0 +1,11 @@
+-- Deploy kakeibo:transaction_type to pg
+-- requires: appschema
+
+BEGIN;
+
+CREATE TYPE kakeibo.transaction_type AS ENUM(
+ 'income',
+ 'outgo'
+);
+
+COMMIT;