add library index

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 48ff62587a052f0873fd9a1eb057e244aa396933..aadd91df9e24403814219cf3096c78d239bc141b 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -278,6 +278,7 @@ create table elflibraries (
 )
 without rowid
 ;
+create index elf_library_name_index on elflibraries(soname);
 
 create table elfneeded (
        file    text, -- hash of file
@@ -373,6 +374,8 @@ create table repository (
        priority        integer not null default 1,
        refreshed       integer -- last refresh time
 );
+-- force the url to be repourl/info.repo
+-- package urls repourl/pkgid.zpm
 
 -- urls for downloading packages.  possibly unneeded
 create table repository_packages (