From 4f57a46075fc38cffd479ab76b2ea56e9b626926 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Mon, 13 May 2024 12:44:35 +0200 Subject: Auto-update 5038 (#6279) * Auto-update 5038 https://github.com/FreshRSS/FreshRSS/pull/5038 * PostgreSQL * Draft for MySQL * More draft MySQL * Finalise * A bit more robust --- app/SQL/install.sql.mysql.php | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'app/SQL/install.sql.mysql.php') diff --git a/app/SQL/install.sql.mysql.php b/app/SQL/install.sql.mysql.php index 598349167..9c989339c 100644 --- a/app/SQL/install.sql.mysql.php +++ b/app/SQL/install.sql.mysql.php @@ -115,6 +115,7 @@ SQL; $GLOBALS['SQL_UPDATE_MINOR'] = <<<'SQL' ALTER TABLE `_feed` + MODIFY COLUMN `website` TEXT CHARACTER SET latin1 COLLATE latin1_bin, MODIFY COLUMN `lastUpdate` BIGINT DEFAULT 0, MODIFY COLUMN `pathEntries` VARCHAR(4096), MODIFY COLUMN `httpAuth` VARCHAR(1024) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL; @@ -136,4 +137,7 @@ ALTER TABLE `_entrytmp` MODIFY COLUMN `tags` VARCHAR(2048); ALTER TABLE `_tag` MODIFY COLUMN `name` VARCHAR(191) NOT NULL; +ALTER TABLE `_feed` + DROP INDEX IF EXISTS `url`, -- IF EXISTS works with MariaDB but not with MySQL, so needs PHP workaround + MODIFY COLUMN `url` VARCHAR(32768) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL; SQL; -- cgit v1.2.3