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_pgsql.sql | |
parent | 3b9e5af4b93279926c27a1c9c19b223b93ba0cea (diff) |
schema: set cat_id in ttrss_feeds to null when category is deleted
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 1a3ab1f0f..9b77533ed 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -52,7 +52,7 @@ create table ttrss_feed_categories(id serial not null primary key, create table ttrss_feeds (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, title varchar(200) not null, - cat_id integer references ttrss_feed_categories(id) default null, + cat_id integer default null references ttrss_feed_categories(id) on delete set null, feed_url varchar(250) not null, icon_url varchar(250) not null default '', update_interval integer not null default 0, |