add packagestatus table

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 6eb01906be160c00f26c263f4c033b46d81ad63a..6a8f51ed05ec56e63b639cceeb5efb7c48f6284e 100644 (file)
--- 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,