diff options
| -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); |