aboutsummaryrefslogtreecommitdiff
path: root/app/SQL/install.sql.pgsql.php
diff options
context:
space:
mode:
authorGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2024-05-13 12:44:35 +0200
committerGravatar GitHub <noreply@github.com> 2024-05-13 12:44:35 +0200
commit4f57a46075fc38cffd479ab76b2ea56e9b626926 (patch)
treed6d1ed24ae44dce25a8f05c3b06dfcb9c695d709 /app/SQL/install.sql.pgsql.php
parente0cc121c7a556126b6c4968cb9efac47ee1382b5 (diff)
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
Diffstat (limited to 'app/SQL/install.sql.pgsql.php')
-rw-r--r--app/SQL/install.sql.pgsql.php3
1 files changed, 3 insertions, 0 deletions
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);