diff options
| author | Alexander_Kabui | 2024-08-29 11:05:39 +0300 |
|---|---|---|
| committer | Alexander_Kabui | 2024-08-29 11:05:39 +0300 |
| commit | a45ab3e62df6e1dfcc6fff03916369fbdaf68ab8 (patch) | |
| tree | 752d1155cef35e3ba058fb991542e09659ff733e /sql | |
| parent | 7b17ab9d98f6a12f2a5b9b0eec8ff4c2c3ef2a5e (diff) | |
| download | genenetwork3-a45ab3e62df6e1dfcc6fff03916369fbdaf68ab8.tar.gz | |
Add default timestamp and and primary key for Rating table.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/update/llm_db_update.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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; |