aboutsummaryrefslogtreecommitdiff
path: root/public/install.php
diff options
context:
space:
mode:
Diffstat (limited to 'public/install.php')
-rw-r--r--public/install.php7
1 files changed, 3 insertions, 4 deletions
diff --git a/public/install.php b/public/install.php
index 31c96fb39..3e2d7b0f9 100644
--- a/public/install.php
+++ b/public/install.php
@@ -27,6 +27,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` (
`pathEntries` varchar(500) DEFAULT NULL,
`httpAuth` varchar(500) DEFAULT NULL,
`error` int(1) NOT NULL DEFAULT \'0\',
+ `keep_history` int(1) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`id`),
FOREIGN KEY (`category`) REFERENCES %scategory(id) ON DELETE SET NULL ON UPDATE CASCADE
);');
@@ -39,12 +40,10 @@ define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` (
`content` text NOT NULL,
`link` text NOT NULL,
`date` int(11) NOT NULL,
- `is_read` int(11) NOT NULL,
- `is_favorite` int(11) NOT NULL,
- `is_public` int(1) NOT NULL,
+ `is_read` int(11) NOT NULL DEFAULT \'0\',
+ `is_favorite` int(11) NOT NULL DEFAULT \'0\',
`id_feed` varchar(6) NOT NULL,
`tags` text NOT NULL,
- `lastUpdate` int(11) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`id_feed`) REFERENCES %sfeed(id) ON DELETE CASCADE ON UPDATE CASCADE
);');