aboutsummaryrefslogtreecommitdiff
path: root/app/SQL/install.sql.mysql.php
diff options
context:
space:
mode:
authorGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2015-05-11 22:42:41 +0200
committerGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2015-05-11 22:42:41 +0200
commit217c191a1ba3ac03b847d261a32e19975380fcad (patch)
treee222fb9f5c4b5ee415053451bbc3245ebdef1bab /app/SQL/install.sql.mysql.php
parent0745252b68f6f9b7c91ea437893b5f33b7a224c3 (diff)
More SQLite compatibility
Additional changes to add compatibility with SQLite for the new hash/lastSeen mode of updating articles.
Diffstat (limited to 'app/SQL/install.sql.mysql.php')
-rw-r--r--app/SQL/install.sql.mysql.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/app/SQL/install.sql.mysql.php b/app/SQL/install.sql.mysql.php
index afdd821b2..9c6af405d 100644
--- a/app/SQL/install.sql.mysql.php
+++ b/app/SQL/install.sql.mysql.php
@@ -41,7 +41,7 @@ CREATE TABLE IF NOT EXISTS `%1$sentry` (
`content_bin` blob, -- v0.7
`link` varchar(1023) CHARACTER SET latin1 NOT NULL,
`date` int(11), -- Until year 2038
- `lastSeen` INT(11) NOT NULL, -- v1.2, Until year 2038
+ `lastSeen` INT(11) DEFAULT 0, -- v1.2, Until year 2038
`hash` BINARY(16), -- v1.2
`is_read` boolean NOT NULL DEFAULT 0,
`is_favorite` boolean NOT NULL DEFAULT 0,