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 /atuin-server-postgres | |
| 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.
Diffstat (limited to 'atuin-server-postgres')
| -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; |