From: Nathan Wagner <nw@hydaspes.if.org>
Date: Sat, 1 Dec 2018 01:26:39 +0000 (+0000)
Subject: add tables to cache package library information
X-Git-Tag: v0.3.0~4
X-Git-Url: https://pd.if.org/git/?p=zpackage;a=commitdiff_plain;h=b43ccedab337edb1d4c66cc1e65e2bfdf2d42a48

add tables to cache package library information
---

diff --git a/db.sql b/db.sql
index 548dba8..967cdb3 100644
--- a/db.sql
+++ b/db.sql
@@ -594,4 +594,18 @@ union
 select 'preserve' as op, *, null, null, null from preserve
 ;
 
+/*
+ * tables for repository info, essentially materalized views
+ */
+create table repository_libs (
+	pkgid text,
+	soname text
+);
+
+create table repository_libsneeded (
+	pkgid text,
+	soname text,
+	selfsat integer
+);
+
 commit;