From 4c62f84dbc9ebade4172597eecb71194054a578d Mon Sep 17 00:00:00 2001 From: Egor Tensin Date: Sat, 8 Jul 2023 16:31:43 +0200 Subject: sqlite: SQL formatting --- src/sqlite/v01.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/src/sqlite/v01.sql b/src/sqlite/v01.sql index b37e486..acde438 100644 --- a/src/sqlite/v01.sql +++ b/src/sqlite/v01.sql @@ -31,7 +31,6 @@ CREATE INDEX cimple_runs_index_status ON cimple_runs(status); CREATE INDEX cimple_runs_index_repo_id ON cimple_runs(repo_id); CREATE VIEW cimple_runs_readable AS - SELECT run.id, status.label, run.ec, run.output, repo.url, run.rev - FROM cimple_runs AS run + SELECT run.id, status.label, run.ec, run.output, repo.url, run.rev FROM cimple_runs AS run INNER JOIN cimple_run_status as status ON run.status = status.id INNER JOIN cimple_repos as repo ON run.repo_id = repo.id; -- cgit v1.2.3