diff --git a/database_schema.txt b/database_schema.txt index 35e9664..9989f31 100644 --- a/database_schema.txt +++ b/database_schema.txt @@ -1,7 +1,8 @@ CREATE TABLE routemap ( route TEXT NOT NULL, stop TEXT NOT NULL ); CREATE INDEX route_index ON routemap(route); CREATE INDEX stop_index ON routemap(stop); +CREATE UNIQUE INDEX double_index ON routemap(route, stop); \ No newline at end of file