diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2024-05-13 12:44:35 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2024-05-13 12:44:35 +0200 |
| commit | 4f57a46075fc38cffd479ab76b2ea56e9b626926 (patch) | |
| tree | d6d1ed24ae44dce25a8f05c3b06dfcb9c695d709 /app/SQL | |
| parent | e0cc121c7a556126b6c4968cb9efac47ee1382b5 (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')
| -rw-r--r-- | app/SQL/install.sql.mysql.php | 4 | ||||
| -rw-r--r-- | app/SQL/install.sql.pgsql.php | 3 |
2 files changed, 7 insertions, 0 deletions
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; 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); |