remove foreign key from elf tables

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index e1565e69aee73f8b6541b84522b8b058122e31cc..816cbe55e6e5f43562cffb693160c6cc9525a182 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -209,8 +209,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
 ;
@@ -218,8 +217,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
 ;