add tables to cache package library information

diff --git a/db.sql b/db.sql
index 548dba8bcca125c6d5533814a75d8d21f22298e3..967cdb395390a8474aa37babf0295db76ddd630f 100644 (file)
--- 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;