diff options
| author | Alexander_Kabui | 2024-09-03 11:08:31 +0300 |
|---|---|---|
| committer | Alexander_Kabui | 2024-09-03 11:08:31 +0300 |
| commit | c34d75a29b7d144030542b9de4fd0e0d614303a9 (patch) | |
| tree | c93b2a4ba834100a3079d3f8cd4eb59812c29e12 /sql/update | |
| parent | c16c54759cfd493250424ee3f565862e5d6009b3 (diff) | |
| download | genenetwork3-c34d75a29b7d144030542b9de4fd0e0d614303a9.tar.gz | |
Use Jsonb for storing results.
Diffstat (limited to 'sql/update')
| -rw-r--r-- | sql/update/llm_db_tables.sql | 2 | ||||
| -rw-r--r-- | sql/update/llm_db_update.sql | 2 |
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; |