From b318e4a2b4ca7b24bf7766038e003cbd4ac2d764 Mon Sep 17 00:00:00 2001
From: Nathan Wagner <nw@hydaspes.if.org>
Date: Sat, 14 Apr 2018 19:34:03 -0500
Subject: [PATCH] add packagetags table to schema

---
 db.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/db.sql b/db.sql
index f44e526..e1c1a5e 100644
--- a/db.sql
+++ b/db.sql
@@ -38,6 +38,17 @@ create table packages (
 without rowid
 ;
 
+create table packagetags (
+	-- package id triple
+	package	text,
+	version	text,
+	release	integer,
+	tag	text,
+	set_time integer default (strftime('%s', 'now')),
+	primary key (package,version,release,tag),
+	foreign key (package,version,release) references packages (package,version,release) on delete cascade
+);
+
 -- packagefile hash is columns as text, joined with null bytes, then
 -- sha256 sum of that
 -- package checksum is package columns as text, joined with null bytes,
-- 
2.40.0