sql/setup-shorturl.sql: Add index by (url, owner).

[odin-cgi] / sql / setup-shorturl.sql

diff --git a/sql/setup-shorturl.sql b/sql/setup-shorturl.sql
index 3b20463bd2770df0590a444a5c64f22f22a05f09..eaddf90da13f477313f419401fc0a10144b10879 100644 (file)
--- a/sql/setup-shorturl.sql
+++ b/sql/setup-shorturl.sql
@@ -21,5 +21,6 @@ create table odin_shorturl
         owner varchar(64) not null,
         url text not null);
 create index odin_shorturl_by_owner on odin_shorturl (owner);
+create index odin_shorturl_by_url_owner on odin_shorturl (url, owner);
 
 commit;