From 21a279179a5e496082f4e43c5a2a5e10d90c0bdb Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Mon, 30 Oct 2023 21:10:09 +0100 Subject: Ready for year 2038 (#5570) * Ready for year 2038 Fix https://github.com/FreshRSS/FreshRSS/discussions/5569 Requires PHP on a 64-bit platform to take advantage of it. https://en.wikipedia.org/wiki/Year_2038_problem * Allows dates past 2038 Rework of https://github.com/FreshRSS/FreshRSS/pull/3259 https://github.com/FreshRSS/FreshRSS/issues/3258 * Auto alter columns * Changelog --- app/SQL/install.sql.sqlite.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'app/SQL/install.sql.sqlite.php') diff --git a/app/SQL/install.sql.sqlite.php b/app/SQL/install.sql.sqlite.php index 1369bad25..2796b63e9 100644 --- a/app/SQL/install.sql.sqlite.php +++ b/app/SQL/install.sql.sqlite.php @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `feed` ( `name` VARCHAR(191) NOT NULL, `website` VARCHAR(32768), `description` TEXT, - `lastUpdate` INT(11) DEFAULT 0, -- Until year 2038 + `lastUpdate` BIGINT DEFAULT 0, `priority` TINYINT(2) NOT NULL DEFAULT 10, `pathEntries` VARCHAR(65535) DEFAULT NULL, `httpAuth` VARCHAR(1024) DEFAULT NULL, @@ -43,8 +43,8 @@ CREATE TABLE IF NOT EXISTS `entry` ( `author` VARCHAR(65535), `content` TEXT, `link` VARCHAR(32768) NOT NULL, - `date` INT(11), -- Until year 2038 - `lastSeen` INT(11) DEFAULT 0, -- v1.1.1, Until year 2038 + `date` BIGINT, + `lastSeen` BIGINT DEFAULT 0, `hash` BINARY(16), -- v1.1.1 `is_read` BOOLEAN NOT NULL DEFAULT 0, `is_favorite` BOOLEAN NOT NULL DEFAULT 0, @@ -69,8 +69,8 @@ CREATE TABLE IF NOT EXISTS `entrytmp` ( -- v1.7 `author` VARCHAR(65535), `content` TEXT, `link` VARCHAR(32768) NOT NULL, - `date` INT(11), - `lastSeen` INT(11) DEFAULT 0, + `date` BIGINT, + `lastSeen` BIGINT DEFAULT 0, `hash` BINARY(16), `is_read` BOOLEAN NOT NULL DEFAULT 0, `is_favorite` BOOLEAN NOT NULL DEFAULT 0, -- cgit v1.2.3