aboutsummaryrefslogtreecommitdiff
path: root/app/SQL/install.sql.mysql.php
diff options
context:
space:
mode:
authorGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2019-10-05 10:37:15 +0200
committerGravatar GitHub <noreply@github.com> 2019-10-05 10:37:15 +0200
commit38932ee3bb3ccd41c0e2d79329e2d77fb5995256 (patch)
tree13979ffa248fa979591a966e1c9733e859687876 /app/SQL/install.sql.mysql.php
parent83b0521233771c1b2da617672ea168751ed8016d (diff)
MySQL entry content MEDIUMBLOB (#2551)
Fix https://github.com/FreshRSS/FreshRSS/issues/2448
Diffstat (limited to 'app/SQL/install.sql.mysql.php')
-rw-r--r--app/SQL/install.sql.mysql.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/app/SQL/install.sql.mysql.php b/app/SQL/install.sql.mysql.php
index 328e8acc0..a5db1b216 100644
--- a/app/SQL/install.sql.mysql.php
+++ b/app/SQL/install.sql.mysql.php
@@ -43,7 +43,7 @@ CREATE TABLE IF NOT EXISTS `_entry` (
`guid` VARCHAR(760) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, -- Maximum for UNIQUE is 767B
`title` VARCHAR(255) NOT NULL,
`author` VARCHAR(255),
- `content_bin` BLOB, -- v0.7
+ `content_bin` MEDIUMBLOB, -- v0.7
`link` VARCHAR(1023) 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
@@ -71,7 +71,7 @@ CREATE TABLE IF NOT EXISTS `_entrytmp` ( -- v1.7
`guid` VARCHAR(760) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`title` VARCHAR(255) NOT NULL,
`author` VARCHAR(255),
- `content_bin` BLOB,
+ `content_bin` MEDIUMBLOB,
`link` VARCHAR(1023) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`date` INT(11),
`lastSeen` INT(11) DEFAULT 0,