diff options
| author | Andrew Dolgov <[email protected]> | 2005-12-28 19:59:47 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2005-12-28 19:59:47 +0100 |
| commit | de99f5005d48a668392ff4bda877854134e0d2f1 (patch) | |
| tree | ff1ed8884e4b3a7ecee38f3563add4ca854de794 /schema/ttrss_schema_pgsql.sql | |
| parent | 09829e2a32770772fa07ce2eff958dc0050939c0 (diff) | |
add parent_feed column to ttrss_feeds, create upgrade script for 1.1.1, move out old scripts to schema/obsolete
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
| -rw-r--r-- | schema/ttrss_schema_pgsql.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 9df7418fa..c2db4b36c 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -49,7 +49,8 @@ create table ttrss_feeds (id serial not null primary key, last_error text not null default '', site_url varchar(250) not null default '', auth_login varchar(250) not null default '', - auth_pass varchar(250) not null default ''); + parent_feed integer default null references ttrss_feeds(id) on delete set null, + auth_pass varchar(250) not null default ''); create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid); |