X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=f44e52646a52c8ca660328c76e2f8dc77ca18a85;hb=fce601e1c9d98e68cc840f1281ba8bfee410a371;hp=0bdc6549131bcb981885767d62058e9f2be2bb27;hpb=d3b90e6aa8ab580c77ead76ff5c6c6dca7991cc6;p=zpackage

diff --git a/db.sql b/db.sql
index 0bdc654..f44e526 100644
--- a/db.sql
+++ b/db.sql
@@ -47,7 +47,7 @@ without rowid
 -- really don't like this.
 
 -- files contained in a package
-create table paths (
+create table packagefiles (
 	-- package id triple
 	package	text,
 	version	text,
@@ -187,6 +187,15 @@ create table repository (
 	refreshed	integer -- last refresh time
 );
 
+-- urls for downloading packages.  possibly unneeded
+create table repository_packages (
+	repo	text,
+	pkg	text, -- glob pattern?  in which case others not needed
+	version	text,
+	release	text,
+	url	text
+);
+
 -- track which repository a package was cloned from, i.e. where we got it
 create table packagesource (
 	name	text,