change repo db elf tables

diff --git a/db.sql b/db.sql
index e1c1a5ed9a2b13c19ab95547f22a58b5df0f5856..6eb01906be160c00f26c263f4c033b46d81ad63a 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -104,10 +104,22 @@ without rowid
 ;
 
 create table elfinfo (
-       file    text, -- hash of blob
+       file    text primary key, -- hash of blob
        elftype text,
        foreign key (file) references files on delete cascade
-);
+)
+without rowid
+;
+
+create table elfdeps (
+       file    text,
+       soname  text,
+       dependency text,
+       primary key (file, soname, dependency),
+       foreign key (file) references files on delete cascade
+)
+without rowid
+;
 
 -- TODO just elf information?
 -- and just hash, not package?