diff options
| author | Ellie Huxtable <ellie@elliehuxtable.com> | 2024-01-08 13:43:33 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-08 13:43:33 +0000 |
| commit | 41e8d135a85566f8b383f2ae29d3b651148083ac (patch) | |
| tree | 04be1d4b81ac9cee692ff26bafd9569f9e908694 | |
| parent | docs: refer to image with multi-arch support (#1513) (diff) | |
| download | atuin-41e8d135a85566f8b383f2ae29d3b651148083ac.zip | |
chore: schema cleanup (#1522)
The columns referred to in this PR, were for some reason created with
defaults. When created years ago, they were `bigserial` not `bigint`.
The defaults were never actually used, as verified by
1. Checking the value of the sequences on the database
2. Checking the code
So we're safe to clean them up.
| -rw-r--r-- | atuin-server-postgres/migrations/20240108124837_drop-some-defaults.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/atuin-server-postgres/migrations/20240108124837_drop-some-defaults.sql b/atuin-server-postgres/migrations/20240108124837_drop-some-defaults.sql new file mode 100644 index 00000000..ad2af5a1 --- /dev/null +++ b/atuin-server-postgres/migrations/20240108124837_drop-some-defaults.sql @@ -0,0 +1,4 @@ +-- Add migration script here +alter table history alter column user_id drop default; +alter table sessions alter column user_id drop default; +alter table total_history_count_user alter column user_id drop default; |