diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-05 12:57:14 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-05 12:57:14 +0900 |
| commit | 1c6642ef3ea7c6e4f4e1a90b07e1b60be6a7429b (patch) | |
| tree | 4a7203f092a8658b9a0bd0b643f4441201111df8 /deploy | |
| parent | 4b552c58f5988d1af18ef34ccec5979081c3bc14 (diff) | |
Rename column of transactions from type to type_code.
Diffstat (limited to 'deploy')
| -rw-r--r-- | deploy/transactions_type_code.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/deploy/transactions_type_code.sql b/deploy/transactions_type_code.sql new file mode 100644 index 0000000..5c29ec9 --- /dev/null +++ b/deploy/transactions_type_code.sql @@ -0,0 +1,8 @@ +-- Deploy kakeibo:transactions_type_code to pg +-- requires: transactions + +BEGIN; + +ALTER TABLE kakeibo.transactions RENAME COLUMN type to type_code; + +COMMIT; |