summaryrefslogtreecommitdiff
path: root/schema/ttrss_schema_mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema/ttrss_schema_mysql.sql')
-rw-r--r--schema/ttrss_schema_mysql.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index b4da8dbfc..65a6a56b0 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -80,7 +80,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key,
index(owner_uid),
foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
index(cat_id),
- foreign key (cat_id) references ttrss_feed_categories(id),
+ foreign key (cat_id) references ttrss_feed_categories(id) ON DELETE SET NULL,
index(parent_feed),
foreign key (parent_feed) references ttrss_feeds(id) ON DELETE SET NULL) TYPE=InnoDB;