Update schema to reflect development

1 files changed, 3 insertions, 3 deletions

diff --git a/schema.sql b/schema.sql
index 5686f23..62ecd66 100644
--- a/schema.sql
+++ b/schema.sql
@@ -7,7 +7,7 @@ create table if not exists torrents (
 );
 create table if not exists files (
     id serial not null primary key,
-    torrent_id integer not null references torrents,
+    torrent_id integer not null references torrents on delete cascade,
     path text,
     size bigint
 );
@@ -16,7 +16,7 @@ create table if not exists tags (
     name text
 );
 create table if not exists tags_torrents (
-    tag_id integer not null references tags,
-    torrent_id integer not null references torrents,
+    tag_id integer not null references tags on delete cascade,
+    torrent_id integer not null references torrents on delete cascade,
     primary key (tag_id, torrent_id)
 );