summaryrefslogtreecommitdiff
path: root/app/SQL/install.sql.sqlite.php
diff options
context:
space:
mode:
authorGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2014-07-05 01:20:45 +0200
committerGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2014-07-05 01:20:45 +0200
commit1b43167fb8206dfd17923c389de1e3bd6b76045e (patch)
tree7df7b3ba1566f5f14707ed0683604b6fbc59d413 /app/SQL/install.sql.sqlite.php
parentb34f59e85aa851b82210fdc50074918034f960db (diff)
SQL: Add f.ttl column to control feed cache duration
Preparation of https://github.com/marienfressinaud/FreshRSS/issues/250 Will also be used to disable automatic update for selected feeds
Diffstat (limited to 'app/SQL/install.sql.sqlite.php')
-rw-r--r--app/SQL/install.sql.sqlite.php1
1 files changed, 1 insertions, 0 deletions
diff --git a/app/SQL/install.sql.sqlite.php b/app/SQL/install.sql.sqlite.php
index 8cdec981f..b90a5ef5e 100644
--- a/app/SQL/install.sql.sqlite.php
+++ b/app/SQL/install.sql.sqlite.php
@@ -19,6 +19,7 @@ $SQL_CREATE_TABLES = array(
`httpAuth` varchar(511) DEFAULT NULL,
`error` boolean DEFAULT 0,
`keep_history` MEDIUMINT NOT NULL DEFAULT -2,
+ `ttl` INT NOT NULL DEFAULT -2,
`cache_nbEntries` int DEFAULT 0,
`cache_nbUnreads` int DEFAULT 0,
FOREIGN KEY (`%1$scategory`) REFERENCES `%1$scategory`(`id`) ON DELETE SET NULL ON UPDATE CASCADE,