add check constraints to package release

diff --git a/db.sql b/db.sql
index 2c03a4a43d1827e3cce1b159b2522ad587485fe5..d134208b4ea2f0ccccae3ef79a33c4eaf6d2e7be 100644 (file)
--- 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
 ;