From b916bcfccc5a8b1c1852c0bf39bb6f9837296a4e Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= Date: Wed, 7 Aug 2013 19:14:28 +0200 Subject: fixes for 1.0-beta --- install/update_sqlite_from_0_to_1.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to '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 2ee65522..f3801eb1 100644 --- 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(); -- cgit v1.2.3