From ec7869647ac453722efaf40ad0c61f186166040d Mon Sep 17 00:00:00 2001
From: Nathan Wagner <nw@hydaspes.if.org>
Date: Sun, 1 Jul 2018 02:27:23 +0000
Subject: [PATCH] change repo db elf tables

---
 db.sql | 16 ++++++++++++++--
 1 file changed, 14 insertions(+), 2 deletions(-)

diff --git a/db.sql b/db.sql
index e1c1a5e..6eb0190 100644
--- 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?
-- 
2.40.0