aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAlexander_Kabui2024-09-03 11:08:31 +0300
committerAlexander_Kabui2024-09-03 11:08:31 +0300
commitc34d75a29b7d144030542b9de4fd0e0d614303a9 (patch)
treec93b2a4ba834100a3079d3f8cd4eb59812c29e12 /sql
parentc16c54759cfd493250424ee3f565862e5d6009b3 (diff)
downloadgenenetwork3-c34d75a29b7d144030542b9de4fd0e0d614303a9.tar.gz
Use Jsonb for storing results.
Diffstat (limited to 'sql')
-rw-r--r--sql/update/llm_db_tables.sql2
-rw-r--r--sql/update/llm_db_update.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/sql/update/llm_db_tables.sql b/sql/update/llm_db_tables.sql
index a6c0479..b501832 100644
--- a/sql/update/llm_db_tables.sql
+++ b/sql/update/llm_db_tables.sql
@@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS history (
user_id TEXT NOT NULL,
task_id TEXT NOT NULL,
query TEXT NOT NULL,
- results TEXT,
+ results JSONB,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (task_id)
) WITHOUT ROWID;
diff --git a/sql/update/llm_db_update.sql b/sql/update/llm_db_update.sql
index a4eb848..7f1a9f9 100644
--- a/sql/update/llm_db_update.sql
+++ b/sql/update/llm_db_update.sql
@@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS history (
user_id TEXT NOT NULL,
task_id TEXT NOT NULL,
query TEXT NOT NULL,
- results TEXT,
+ results JSONB,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (task_id)
) WITHOUT ROWID;