From 09777e63adbabfa62804b0c30e541e20c5f91756 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Tue, 21 Aug 2018 11:18:35 +0000 Subject: [PATCH] add check constraints to package release --- db.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/db.sql b/db.sql index 2c03a4a..d134208 100644 --- a/db.sql +++ b/db.sql @@ -34,7 +34,10 @@ create table packages ( build_time integer default (strftime('%s', 'now')), install_time integer, checksum text, -- checksum of package contents. null for incompleted packages - primary key (package,version,release) + primary key (package,version,release), + check (typeof(release) = 'integer'), + check (release > 0) + -- TODO enforce name and release conventions ) without rowid ; -- 2.40.0