X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=6a8f51ed05ec56e63b639cceeb5efb7c48f6284e;hb=7cc581729bb4b242c803299f72eed987b9fee216;hp=6eb01906be160c00f26c263f4c033b46d81ad63a;hpb=ec7869647ac453722efaf40ad0c61f186166040d;p=zpackage

diff --git a/db.sql b/db.sql
index 6eb0190..6a8f51e 100644
--- a/db.sql
+++ b/db.sql
@@ -38,6 +38,13 @@ create table packages (
 without rowid
 ;
 
+create table packagestatus (
+	pkgid	text primary key,
+	status	text, -- installed installing removed upgraded
+	-- asof timestamp
+	asof	integer default (strftime('%s', 'now'))
+);
+
 create table packagetags (
 	-- package id triple
 	package	text,