remove foreign key on files from elf tables

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 8ed6537e56b1c635f4587f0d224a7aab59f9d722..350bdd090b08d2102d4fd05ab9412249b8ed12b8 100644 (file)
--- 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
 ;