From 0866fdaee85bc8530437436abe7f8536b8b0f4f0 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Tue, 19 Jul 2022 15:17:08 +0200 Subject: Add database field attributes for entries (#4444) * Add database field attributes for entries Just like we already have for categories, feeds, etc. No core use yet, but allows in particular extensions to save per-entry data * Fix PHPStand * Fix wrong variable --- app/SQL/install.sql.mysql.php | 2 ++ 1 file changed, 2 insertions(+) (limited to 'app/SQL/install.sql.mysql.php') diff --git a/app/SQL/install.sql.mysql.php b/app/SQL/install.sql.mysql.php index 226cc0346..d85bd3dc3 100644 --- a/app/SQL/install.sql.mysql.php +++ b/app/SQL/install.sql.mysql.php @@ -55,6 +55,7 @@ CREATE TABLE IF NOT EXISTS `_entry` ( `is_favorite` BOOLEAN NOT NULL DEFAULT 0, `id_feed` INT, -- 1.20.0 `tags` VARCHAR(1023), + `attributes` TEXT, -- v1.20.0 PRIMARY KEY (`id`), FOREIGN KEY (`id_feed`) REFERENCES `_feed`(`id`) ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE KEY (`id_feed`,`guid`), -- v0.7 @@ -87,6 +88,7 @@ CREATE TABLE IF NOT EXISTS `_entrytmp` ( -- v1.7 `is_favorite` BOOLEAN NOT NULL DEFAULT 0, `id_feed` INT, -- 1.20.0 `tags` VARCHAR(1023), + `attributes` TEXT, -- v1.20.0 PRIMARY KEY (`id`), FOREIGN KEY (`id_feed`) REFERENCES `_feed`(`id`) ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE KEY (`id_feed`,`guid`), -- cgit v1.2.3