From a790e258604305b27df5797c6d97cca49ae5182e Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Sun, 16 Sep 2018 13:22:00 +0000 Subject: [PATCH] add scripts_pkgid view Added more constraint checks on package id columns. Added primary and foreign keys to scripts table. --- db.sql | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/db.sql b/db.sql index 0a18326..5583d02 100644 --- a/db.sql +++ b/db.sql @@ -43,6 +43,9 @@ create table packages ( -- check(instr(version,'-') = 0) -- check(instr(package,'/') = 0) -- check(instr(package,'/') = 0) + -- check(instr(version,' ') = 0) + -- check(instr(package,' ') = 0) + -- check(instr(package,' ') = 0) -- check(length(package) < 64) -- check(length(version) < 32) ) @@ -185,9 +188,16 @@ create table scripts ( version text, release integer, stage text, - hash text + hash text, + primary key (package,version,release,stage), + foreign key (package,version,release) references packages (package,version,release) on delete cascade ); +create view scripts_pkgid as +select printf('%s-%s-%s', package, version, release) as pkgid, * +from scripts +; + -- package dependencies: table of package, dependency, dep type (package, soname) create table packagedeps ( package text, -- 2.40.0