X-Git-Url: https://git.distorted.org.uk/~mdw/odin-cgi/blobdiff_plain/697afe0d09f38e5e1756ebced2543ac758594d7c..969db1ef94e92c88afaa35b683918b2bf33b87f0:/sql/setup-shorturl.sql

diff --git a/sql/setup-shorturl.sql b/sql/setup-shorturl.sql
index 3b20463..dee90a3 100644
--- a/sql/setup-shorturl.sql
+++ b/sql/setup-shorturl.sql
@@ -17,9 +17,10 @@ insert into odin_shorturl_seq (seq) values (10000);
 
 create table odin_shorturl
 	(tag varchar(16) primary key,
-	 stamp timestamp not null default current_timestamp,
+	 stamp bigint not null,
 	 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;
