fixes for 1.0-beta

[github/wallabag/wallabag.git] / install / update_sqlite_from_0_to_1.php

diff --git a/install/update_sqlite_from_0_to_1.php b/install/update_sqlite_from_0_to_1.php
index 2ee65522c7f98b970e87fa7715d4506113dbb662..f3801eb1caa3ddad43cafe2f9c13e049200b912d 100644 (file)
--- a/install/update_sqlite_from_0_to_1.php
+++ b/install/update_sqlite_from_0_to_1.php
@@ -11,7 +11,7 @@ $sql = 'ALTER TABLE entries RENAME TO tempEntries;';
 $query = $handle->prepare($sql);
 $query->execute();
 
-$sql = 'CREATE TABLE entries (id INTEGER PRIMARY KEY, title TEXT, url TEXT, is_read NUMERIC, is_fav NUMERIC, content BLOB, user_id NUMERIC);';
+$sql = 'CREATE TABLE entries (id INTEGER PRIMARY KEY, title TEXT, url TEXT, is_read NUMERIC DEFAULT 0, is_fav NUMERIC DEFAULT 0, content BLOB, user_id NUMERIC);';
 $query = $handle->prepare($sql);
 $query->execute();