From 2e359b7bc9f28854271fc816e73cb72d8c29e6f6 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Tue, 31 Jul 2018 18:54:46 +0000 Subject: [PATCH] add packagestatus table --- db.sql | 7 +++++++ 1 file changed, 7 insertions(+) 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, -- 2.40.0