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.pgsql.php | 3 +++ 1 file changed, 3 insertions(+) (limited to 'app/SQL/install.sql.pgsql.php') diff --git a/app/SQL/install.sql.pgsql.php b/app/SQL/install.sql.pgsql.php index 038e8e070..ad14a37a0 100644 --- a/app/SQL/install.sql.pgsql.php +++ b/app/SQL/install.sql.pgsql.php @@ -106,7 +106,10 @@ $GLOBALS['SQL_UPDATE_MINOR'] = <<<'SQL' ALTER TABLE `_category` ALTER COLUMN "name" SET DATA TYPE VARCHAR(191); ALTER TABLE `_feed` + DROP CONSTRAINT IF EXISTS `_feed_url_key`, + ALTER COLUMN "url" SET DATA TYPE VARCHAR(32768), ALTER COLUMN "name" SET DATA TYPE VARCHAR(191), + ALTER COLUMN "website" SET DATA TYPE VARCHAR(32768), ALTER COLUMN "lastUpdate" SET DATA TYPE BIGINT, ALTER COLUMN "pathEntries" SET DATA TYPE VARCHAR(4096), ALTER COLUMN "httpAuth" SET DATA TYPE VARCHAR(1024); -- cgit v1.2.3