diff options
| -rw-r--r-- | src/sqlite/v01.sql | 2 | ||||
| -rw-r--r-- | 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; |