X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=install%2Fupdate_sqlite_from_0_to_1.php;h=299abf48d33ce7a0c8e5859d5dc5d1d9f6acf05c;hb=572e758bf2e76308a3fa3eda9a8d9e9be8b53ecc;hp=2ee65522c7f98b970e87fa7715d4506113dbb662;hpb=580d60b9416b3445300f37fc0ecc160254ed0676;p=github%2Fwallabag%2Fwallabag.git

diff --git a/install/update_sqlite_from_0_to_1.php b/install/update_sqlite_from_0_to_1.php
index 2ee65522..299abf48 100644
--- a/install/update_sqlite_from_0_to_1.php
+++ b/install/update_sqlite_from_0_to_1.php
@@ -1,5 +1,5 @@
 <?php
-
+# import script to upgrade from poche 0.3
 $db_path = 'sqlite:../db/poche.sqlite';
 $handle = new PDO($db_path);
 $handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
@@ -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();
 
@@ -51,6 +51,14 @@ $sql = 'CREATE TABLE users_config (id INTEGER PRIMARY KEY, user_id NUMERIC, name
 $query = $handle->prepare($sql);
 $query->execute();
 
+$sql = 'INSERT INTO users_config (user_id, name, value) VALUES (1, "pager", "10");';
+$query = $handle->prepare($sql);
+$query->execute();
+
+$sql = 'INSERT INTO users_config (user_id, name, value) VALUES (1, "language", "en_EN.UTF8");';
+$query = $handle->prepare($sql);
+$query->execute();
+
 # Suppression de la table temporaire
 $sql = 'DROP TABLE tempEntries;';
 $query = $handle->prepare($sql);