From 7b4cd3abae88bf1b8a04642489b68a741e4d2c6a Mon Sep 17 00:00:00 2001 From: Marien Fressinaud Date: Wed, 11 Sep 2019 18:40:17 +0200 Subject: add: Allow admins to configure default feeds (#2515) * Homogenize SQL_INSERT_FEEDS across database types * Extract default feeds into system configuration * Adapt default feeds init during installation --- app/SQL/install.sql.sqlite.php | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) (limited to 'app/SQL/install.sql.sqlite.php') diff --git a/app/SQL/install.sql.sqlite.php b/app/SQL/install.sql.sqlite.php index 1dd5f2647..d1dbfc192 100644 --- a/app/SQL/install.sql.sqlite.php +++ b/app/SQL/install.sql.sqlite.php @@ -99,12 +99,10 @@ $SQL_CREATE_TABLE_TAGS = array( 'CREATE INDEX entrytag_id_entry_index ON `entrytag` (`id_entry`);', ); -global $SQL_INSERT_FEEDS; -$SQL_INSERT_FEEDS = array( -'INSERT OR IGNORE INTO `feed` (url, category, name, website, description, ttl) - VALUES ("https://freshrss.org/feeds/all.atom.xml", 1, "FreshRSS.org", "https://freshrss.org/", "FreshRSS, a free, self-hostable aggregator…", 86400);', -'INSERT OR IGNORE INTO `feed` (url, category, name, website, description, ttl) - VALUES ("https://github.com/FreshRSS/FreshRSS/releases.atom", 1, "FreshRSS releases", "https://github.com/FreshRSS/FreshRSS/", "FreshRSS releases @ GitHub", 86400);', +define( + 'SQL_INSERT_FEED', + 'INSERT OR IGNORE INTO `feed` (url, category, name, website, description, ttl) + VALUES(:url, 1, :name, :website, :description, 86400);' ); define('SQL_DROP_TABLES', 'DROP TABLE IF EXISTS `entrytag`, `tag`, `entrytmp`, `entry`, `feed`, `category`'); -- cgit v1.2.3