From 446d104827d78aaacdeba972a76f8bc490310132 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Mon, 1 Oct 2018 15:17:55 +0000 Subject: [PATCH] remove foreign key on files from elf tables --- db.sql | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) diff --git a/db.sql b/db.sql index 8ed6537..350bdd0 100644 --- a/db.sql +++ b/db.sql @@ -266,8 +266,7 @@ without rowid create table elfinfo ( file text primary key, -- hash of blob - elftype text, - foreign key (file) references files on delete cascade + elftype text ) without rowid ; @@ -276,8 +275,7 @@ create table elfdeps ( file text, soname text, dependency text, - primary key (file, soname, dependency), - foreign key (file) references files on delete cascade + primary key (file, soname, dependency) ) without rowid ; @@ -286,8 +284,7 @@ without rowid -- and just hash, not package? create table elflibraries ( file text primary key, - soname text, - foreign key (file) references files on delete cascade + soname text ) without rowid ; @@ -295,8 +292,7 @@ without rowid create table elfneeded ( file text, needed text, -- soname of dependency - primary key (file, needed), - foreign key (file) references files on delete cascade + primary key (file, needed) ) without rowid ; -- 2.40.0