X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=aadd91df9e24403814219cf3096c78d239bc141b;hb=106b25a0eabbeb2a06d20c245c082202b3cb1a4e;hp=48ff62587a052f0873fd9a1eb057e244aa396933;hpb=0b5d1faa3bed99cfe7bf7556304387832c0fcd0e;p=zpackage diff --git a/db.sql b/db.sql index 48ff625..aadd91d 100644 --- 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 (