From 41e8d135a85566f8b383f2ae29d3b651148083ac Mon Sep 17 00:00:00 2001 From: Ellie Huxtable Date: Mon, 8 Jan 2024 13:43:33 +0000 Subject: 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. --- .../migrations/20240108124837_drop-some-defaults.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 atuin-server-postgres/migrations/20240108124837_drop-some-defaults.sql 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; -- cgit v1.3.1