diff options
| author | Egor Tensin <Egor.Tensin@gmail.com> | 2023-07-08 16:31:43 +0200 |
|---|---|---|
| committer | Egor Tensin <Egor.Tensin@gmail.com> | 2023-07-08 16:31:43 +0200 |
| commit | 4c62f84dbc9ebade4172597eecb71194054a578d (patch) | |
| tree | 0a1981986d2d812c860a6f5932fa8b9a79d8b3d8 | |
| parent | test: dedupe code by using @parametrize (diff) | |
| download | cimple-4c62f84dbc9ebade4172597eecb71194054a578d.tar.gz cimple-4c62f84dbc9ebade4172597eecb71194054a578d.zip | |
sqlite: SQL formatting
| -rw-r--r-- | src/sqlite/v01.sql | 3 |
1 files changed, 1 insertions, 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; |