From e6baf9c084aaabbbd9a1beaa832d9a0a9298078a Mon Sep 17 00:00:00 2001 From: Egor Tensin Date: Tue, 4 Jul 2023 21:00:02 +0200 Subject: sqlite: rename a column --- src/sqlite/v01.sql | 2 +- src/storage_sqlite.c | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/sqlite/v01.sql b/src/sqlite/v01.sql index 44c5116..454c19e 100644 --- a/src/sqlite/v01.sql +++ b/src/sqlite/v01.sql @@ -18,7 +18,7 @@ INSERT INTO cimple_run_status(id, label) VALUES (2, 'finished'); CREATE TABLE cimple_runs ( id INTEGER PRIMARY KEY, status INTEGER NOT NULL, - result INTEGER NOT NULL, + ec INTEGER NOT NULL, output BLOB NOT NULL, repo_id INTEGER NOT NULL, rev TEXT NOT NULL, diff --git a/src/storage_sqlite.c b/src/storage_sqlite.c index 087174e..eee26fe 100644 --- a/src/storage_sqlite.c +++ b/src/storage_sqlite.c @@ -150,8 +150,8 @@ static int storage_sqlite_prepare_statements(struct storage_sqlite *storage) /* clang-format off */ static const char *const fmt_repo_find = "SELECT id FROM cimple_repos WHERE url = ?;"; static const char *const fmt_repo_insert = "INSERT INTO cimple_repos(url) VALUES (?) RETURNING id;"; - static const char *const fmt_run_insert = "INSERT INTO cimple_runs(status, result, output, repo_id, rev) VALUES (1, -1, x'', ?, ?) RETURNING id;"; - static const char *const fmt_run_finished = "UPDATE cimple_runs SET status = 2, result = ? WHERE id = ?;"; + static const char *const fmt_run_insert = "INSERT INTO cimple_runs(status, ec, output, repo_id, rev) VALUES (1, -1, x'', ?, ?) RETURNING id;"; + static const char *const fmt_run_finished = "UPDATE cimple_runs SET status = 2, ec = ? WHERE id = ?;"; /* clang-format on */ int ret = 0; -- cgit v1.2.3