add packagetags table to schema

[zpackage] / db.sql

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