diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2022-07-19 15:17:08 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2022-07-19 15:17:08 +0200 |
| commit | 0866fdaee85bc8530437436abe7f8536b8b0f4f0 (patch) | |
| tree | fd73e2e55740423bfab64581c4934b6d50dd3162 /app/SQL/install.sql.sqlite.php | |
| parent | 2d807e06b1abffdbc40a60c3623e22e3c6b818c6 (diff) | |
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
Diffstat (limited to 'app/SQL/install.sql.sqlite.php')
| -rw-r--r-- | app/SQL/install.sql.sqlite.php | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/app/SQL/install.sql.sqlite.php b/app/SQL/install.sql.sqlite.php index dd2cca708..ccf256d6a 100644 --- a/app/SQL/install.sql.sqlite.php +++ b/app/SQL/install.sql.sqlite.php @@ -51,6 +51,7 @@ CREATE TABLE IF NOT EXISTS `entry` ( `is_favorite` BOOLEAN NOT NULL DEFAULT 0, `id_feed` INTEGER, -- 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 (`id_feed`,`guid`) @@ -82,6 +83,7 @@ CREATE TABLE IF NOT EXISTS `entrytmp` ( -- v1.7 `is_favorite` BOOLEAN NOT NULL DEFAULT 0, `id_feed` INTEGER, -- 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 (`id_feed`,`guid`) |