diff options
author | Andrew Dolgov <[email protected]> | 2019-11-07 08:48:13 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2019-11-07 08:48:13 +0300 |
commit | 60609637bc0301bc89bf00453273302a2126689d (patch) | |
tree | 86e3f808d5c2f1c9c8cd51d32ef3bb9606fa3132 /schema/ttrss_schema_pgsql.sql | |
parent | 8551cce494d7db0ad291d2e16d3d66baa7cdc3ec (diff) |
schema: when inserting initial forum feed, don't hardcode admin UID as 1
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 edd347cfd..c818596b8 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -115,7 +115,7 @@ create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid); create index ttrss_feeds_cat_id_idx on ttrss_feeds(cat_id); insert into ttrss_feeds (owner_uid, title, feed_url) values - (1, 'Tiny Tiny RSS: Forum', 'http://tt-rss.org/forum/rss.php'); + ((select id from ttrss_users where login = 'admin'), 'Tiny Tiny RSS: Forum', 'https://tt-rss.org/forum/rss.php'); create table ttrss_archived_feeds (id integer not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, |