X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=db.sql;h=967cdb395390a8474aa37babf0295db76ddd630f;hp=548dba8bcca125c6d5533814a75d8d21f22298e3;hb=b43ccedab337edb1d4c66cc1e65e2bfdf2d42a48;hpb=3d50a117df2b79941e77dfe074cabff95f7f3fdc

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;