aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--youridb.sql1
1 files changed, 1 insertions, 0 deletions
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);