From 50314eba1f00b5ec8c57ab82031792df80f4bb4e Mon Sep 17 00:00:00 2001 From: Fuwn Date: Tue, 14 May 2024 08:25:33 +0000 Subject: fix(database): non-constant defaults sqlite --- src/database.gleam | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'src') diff --git a/src/database.gleam b/src/database.gleam index d4d2c0b..8e8d320 100644 --- a/src/database.gleam +++ b/src/database.gleam @@ -21,9 +21,12 @@ pub fn setup(connection) { let add_column = fn(name) { let _ = sqlight.exec( - "alter table tb_count add column " - <> name - <> " text default current_timestamp;", + "alter table tb_count add column " <> name <> " text;", + connection, + ) + let _ = + sqlight.exec( + "update tb_count set " <> name <> " = current_timestamp;", connection, ) -- cgit v1.2.3