From a45ab3e62df6e1dfcc6fff03916369fbdaf68ab8 Mon Sep 17 00:00:00 2001
From: Alexander_Kabui
Date: Thu, 29 Aug 2024 11:05:39 +0300
Subject: Add default timestamp and and primary key for Rating table.

---
 sql/update/llm_db_update.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/update/llm_db_update.sql b/sql/update/llm_db_update.sql
index 6608a90..a4eb848 100644
--- a/sql/update/llm_db_update.sql
+++ b/sql/update/llm_db_update.sql
@@ -34,4 +34,4 @@ CREATE TABLE IF NOT EXISTS history (
 CREATE INDEX IF NOT EXISTS idx_tbl_history_cols_task_id_user_id
 ON history (task_id, user_id);
 
-ALTER TABLE Rating ADD COLUMN created_at TIMESTAMP;
+ALTER TABLE Rating ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
-- 
cgit v1.2.3