From 41e8d135a85566f8b383f2ae29d3b651148083ac Mon Sep 17 00:00:00 2001
From: Ellie Huxtable <ellie@elliehuxtable.com>
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

(limited to '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

