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 | |
| parent | 8551cce494d7db0ad291d2e16d3d66baa7cdc3ec (diff) | |
schema: when inserting initial forum feed, don't hardcode admin UID as 1
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 db8e262b0..60b121e37 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -146,7 +146,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, unique(feed_url(255), owner_uid)) ENGINE=InnoDB DEFAULT CHARSET=UTF8; 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_entries (id integer not null primary key auto_increment, title text not null, 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, |