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

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;