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 | |
| parent | 3b9e5af4b93279926c27a1c9c19b223b93ba0cea (diff) | |
schema: set cat_id in ttrss_feeds to null when category is deleted
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/ttrss_schema_mysql.sql | 2 | ||||
| -rw-r--r-- | schema/ttrss_schema_pgsql.sql | 2 |
2 files changed, 2 insertions, 2 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; 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, |