diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2023-10-30 20:47:50 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2023-10-30 20:47:50 +0100 |
| commit | 0324df6f889f18500cc8d201fdc2845f3e4d1acf (patch) | |
| tree | fafa9ab06c7fc7a3d48392cd0fd1ac959cc40a37 /app/SQL/install.sql.mysql.php | |
| parent | 06d00995049db9c7b915f67cfd4a5708aace458f (diff) | |
SQL increase length of VARCHAR fields (#5756)
* SQL increase length of VARCHAR fields
Increase length of all fields, keeping the limits for:
* Unique indexes on UTF-8: 191 bytes for MySQL;
* Unique indexes on ASCII: 767 bytes for MySQL;
* Max URL for external tools: 32768 characters;
* Max VARCHAR: 65535 bytes for MySQL;
Follow-up of https://github.com/FreshRSS/FreshRSS/pull/5038
Fix https://github.com/FreshRSS/FreshRSS/issues/4986
* Fix length test
Diffstat (limited to 'app/SQL/install.sql.mysql.php')
| -rw-r--r-- | app/SQL/install.sql.mysql.php | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/app/SQL/install.sql.mysql.php b/app/SQL/install.sql.mysql.php index 74fc65b19..cb12fa179 100644 --- a/app/SQL/install.sql.mysql.php +++ b/app/SQL/install.sql.mysql.php @@ -26,8 +26,8 @@ CREATE TABLE IF NOT EXISTS `_feed` ( `description` TEXT, `lastUpdate` INT(11) DEFAULT 0, -- Until year 2038 `priority` TINYINT(2) NOT NULL DEFAULT 10, - `pathEntries` VARCHAR(511) DEFAULT NULL, - `httpAuth` VARCHAR(511) DEFAULT NULL, + `pathEntries` VARCHAR(65535) DEFAULT NULL, + `httpAuth` VARCHAR(1024) DEFAULT NULL, `error` BOOLEAN DEFAULT 0, `ttl` INT NOT NULL DEFAULT 0, -- v0.7.3 `attributes` TEXT, -- v1.11.0 @@ -42,18 +42,18 @@ ENGINE = INNODB; CREATE TABLE IF NOT EXISTS `_entry` ( `id` BIGINT NOT NULL, -- v0.7 - `guid` VARCHAR(760) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, -- Maximum for UNIQUE is 767B - `title` VARCHAR(255) NOT NULL, - `author` VARCHAR(255), + `guid` VARCHAR(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, -- Maximum for UNIQUE is 767B + `title` VARCHAR(65535) NOT NULL, + `author` VARCHAR(65535), `content_bin` MEDIUMBLOB, -- v0.7 - `link` VARCHAR(1023) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `link` VARCHAR(32768) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `date` INT(11), -- Until year 2038 `lastSeen` INT(11) DEFAULT 0, -- v1.1.1, Until year 2038 `hash` BINARY(16), -- v1.1.1 `is_read` BOOLEAN NOT NULL DEFAULT 0, `is_favorite` BOOLEAN NOT NULL DEFAULT 0, `id_feed` INT, -- 1.20.0 - `tags` VARCHAR(1023), + `tags` VARCHAR(65535), `attributes` TEXT, -- v1.20.0 PRIMARY KEY (`id`), FOREIGN KEY (`id_feed`) REFERENCES `_feed`(`id`) ON DELETE CASCADE ON UPDATE CASCADE, @@ -69,18 +69,18 @@ INSERT IGNORE INTO `_category` (id, name) VALUES(1, "Uncategorized"); CREATE TABLE IF NOT EXISTS `_entrytmp` ( -- v1.7 `id` BIGINT NOT NULL, - `guid` VARCHAR(760) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `title` VARCHAR(255) NOT NULL, - `author` VARCHAR(255), + `guid` VARCHAR(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `title` VARCHAR(65535) NOT NULL, + `author` VARCHAR(65535), `content_bin` MEDIUMBLOB, - `link` VARCHAR(1023) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `link` VARCHAR(32768) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `date` INT(11), `lastSeen` INT(11) DEFAULT 0, `hash` BINARY(16), `is_read` BOOLEAN NOT NULL DEFAULT 0, `is_favorite` BOOLEAN NOT NULL DEFAULT 0, `id_feed` INT, -- 1.20.0 - `tags` VARCHAR(1023), + `tags` VARCHAR(65535), `attributes` TEXT, -- v1.20.0 PRIMARY KEY (`id`), FOREIGN KEY (`id_feed`) REFERENCES `_feed`(`id`) ON DELETE CASCADE ON UPDATE CASCADE, @@ -91,7 +91,7 @@ ENGINE = INNODB; CREATE TABLE IF NOT EXISTS `_tag` ( -- v1.12 `id` INT NOT NULL AUTO_INCREMENT, - `name` VARCHAR(63) NOT NULL, + `name` VARCHAR(191) NOT NULL, `attributes` TEXT, PRIMARY KEY (`id`), UNIQUE KEY (`name`) |