diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-05 14:00:25 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-05 14:00:25 +0900 |
| commit | 830e7f51b597cc29750ac017beda663f6b31bfbe (patch) | |
| tree | f74ec81d384db9c0d10ed306625d965f420cdb0a /revert | |
| parent | 1c6642ef3ea7c6e4f4e1a90b07e1b60be6a7429b (diff) | |
Add foreign key constraint to transactions referencing types.
Diffstat (limited to 'revert')
| -rw-r--r-- | revert/transactions_type_code_fkey.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/revert/transactions_type_code_fkey.sql b/revert/transactions_type_code_fkey.sql new file mode 100644 index 0000000..7637e8e --- /dev/null +++ b/revert/transactions_type_code_fkey.sql @@ -0,0 +1,8 @@ +-- Revert kakeibo:transactions_type_code_fkey from pg + +BEGIN; + +ALTER TABLE kakeibo.transactions + DROP CONSTRAINT transactions_type_code_fkey; + +COMMIT; |