diff options
| -rw-r--r-- | src/database.gleam | 9 |
1 files changed, 6 insertions, 3 deletions
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, ) |