diff options
| author | Nicolas Vigier <boklm@mageia.org> | 2012-02-10 21:23:00 +0000 |
|---|---|---|
| committer | Nicolas Vigier <boklm@mageia.org> | 2012-02-10 21:23:00 +0000 |
| commit | 1adf74349898730445bd27b4e912503d03fab2b8 (patch) | |
| tree | 253ad370d0560f54094728d8ab4c80388150703e /youridb.sql | |
| parent | 39f1a32d93adef18e47ac9cb432d655bda60bb96 (diff) | |
| download | mgarepo-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.sql | 1 |
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); |