diff options
| -rw-r--r-- | src/sqlite/v01.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/sqlite/v01.sql b/src/sqlite/v01.sql index 26869b6..88bbc61 100644 --- a/src/sqlite/v01.sql +++ b/src/sqlite/v01.sql @@ -1,8 +1,10 @@ CREATE TABLE cimple_repositories ( id INTEGER PRIMARY KEY, - url TEXT NOT NULL UNIQUE + url TEXT NOT NULL ) STRICT; +CREATE UNIQUE INDEX cimple_repositories_url_index ON cimple_repositories(url); + CREATE TABLE cimple_runs ( id INTEGER PRIMARY KEY, result INTEGER NOT NULL, @@ -11,3 +13,5 @@ CREATE TABLE cimple_runs ( FOREIGN KEY (repo_id) REFERENCES cimple_repositories(id) ON DELETE CASCADE ON UPDATE CASCADE ) STRICT; + +CREATE INDEX cimple_runs_repo_id_index ON cimple_runs(repo_id); |