#3453 Index for rpm search
Merged a year ago by tkopecek. Opened 2 years ago by tkopecek.
tkopecek/koji issue3448  into  master

@@ -0,0 +1,7 @@ 

+ -- upgrade script to migrate the Koji database schema

+ -- from version 1.30 to 1.31

+ 

+ BEGIN;

+     -- index for default search method for rpms

+     CREATE INDEX rpminfo_filename ON rpminfo((name || '-' || version || '-' || release || '.' || arch || '.rpm')) INCLUDE (id);

+ COMMIT;

file modified
+1
@@ -734,6 +734,7 @@ 

  	CONSTRAINT rpminfo_unique_nvra UNIQUE (name,version,release,arch,external_repo_id)

  ) WITHOUT OIDS;

  CREATE INDEX rpminfo_build ON rpminfo(build_id);

+ CREATE INDEX rpminfo_filename ON rpminfo((name || '-' || version || '-' || release || '.' || arch || '.rpm')) INCLUDE (id);

  

  -- sighash is the checksum of the signature header

  CREATE TABLE rpmsigs (

Metadata Update from @tkopecek:
- Pull-request tagged with: testing-ready

2 years ago

Metadata Update from @relias-redhat:
- Pull-request tagged with: testing-done

a year ago

Commit c2f9cc6 fixes this pull-request

Pull-Request has been merged by tkopecek

a year ago