diff options
author | Andrew Dolgov <[email protected]> | 2008-01-21 04:27:42 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-01-21 04:27:42 +0100 |
commit | f0907182c660e92544a8adc52f5505a910741727 (patch) | |
tree | e3b4a00f2cdcf93f13d4d154c63351b90f09af49 /schema/ttrss_schema_mysql.sql | |
parent | 3b9e5af4b93279926c27a1c9c19b223b93ba0cea (diff) |
schema: set cat_id in ttrss_feeds to null when category is deleted
Diffstat (limited to 'schema/ttrss_schema_mysql.sql')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 2 |
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; |