aboutsummaryrefslogtreecommitdiffstats
path: root/youridb.sql
diff options
context:
space:
mode:
authorNicolas Vigier <boklm@mageia.org>2012-02-10 21:23:00 +0000
committerNicolas Vigier <boklm@mageia.org>2012-02-10 21:23:00 +0000
commit1adf74349898730445bd27b4e912503d03fab2b8 (patch)
tree253ad370d0560f54094728d8ab4c80388150703e /youridb.sql
parent39f1a32d93adef18e47ac9cb432d655bda60bb96 (diff)
downloadmgarepo-1adf74349898730445bd27b4e912503d03fab2b8.tar
mgarepo-1adf74349898730445bd27b4e912503d03fab2b8.tar.gz
mgarepo-1adf74349898730445bd27b4e912503d03fab2b8.tar.bz2
mgarepo-1adf74349898730445bd27b4e912503d03fab2b8.tar.xz
mgarepo-1adf74349898730445bd27b4e912503d03fab2b8.zip
add index on sha1
Diffstat (limited to 'youridb.sql')
-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);