From 1adf74349898730445bd27b4e912503d03fab2b8 Mon Sep 17 00:00:00 2001
From: Nicolas Vigier <boklm@mageia.org>
Date: Fri, 10 Feb 2012 21:23:00 +0000
Subject: add index on sha1

---
 youridb.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/youridb.sql b/youridb.sql
index bef94ce..4ec3249 100644
--- a/youridb.sql
+++ b/youridb.sql
@@ -1 +1,2 @@
 CREATE TABLE submits ( sha1 character(40), rpmname varchar(512), EVR varchar(100), packager varchar(100), url varchar(512), revision integer, status integer, submit_ts timestamp with time zone );
+CREATE INDEX ON submits (sha1);
-- 
cgit v1.2.1