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);