]>
git.immae.eu Git - github/wallabag/wallabag.git/blob - install/update_sqlite_from_0_to_1.php
2ee65522c7f98b970e87fa7715d4506113dbb662
3 $db_path = 'sqlite:../db/poche.sqlite';
4 $handle = new PDO($db_path);
5 $handle->setAttribute(PDO
::ATTR_ERRMODE
, PDO
::ERRMODE_EXCEPTION
);
7 # Requêtes à exécuter pour mettre à jour poche.sqlite en 1.x
9 # ajout d'un champ user_id sur la table entries
10 $sql = 'ALTER TABLE entries RENAME TO tempEntries;';
11 $query = $handle->prepare($sql);
14 $sql = 'CREATE TABLE entries (id INTEGER PRIMARY KEY, title TEXT, url TEXT, is_read NUMERIC, is_fav NUMERIC, content BLOB, user_id NUMERIC);';
15 $query = $handle->prepare($sql);
18 $sql = 'INSERT INTO entries (id, title, url, is_read, is_fav, content) SELECT id, title, url, is_read, is_fav, content FROM tempEntries;';
19 $query = $handle->prepare($sql);
22 # Update tout pour mettre user_id = 1
23 $sql = 'UPDATE entries SET user_id = 1;';
24 $query = $handle->prepare($sql);
27 # Changement des flags pour les lus / favoris
28 $sql = 'UPDATE entries SET is_read = 1 WHERE is_read = -1;';
29 $query = $handle->prepare($sql);
32 $sql = 'UPDATE entries SET is_fav = 1 WHERE is_fav = -1;';
33 $query = $handle->prepare($sql);
36 # Création de la table users
37 $sql = 'CREATE TABLE users (id INTEGER PRIMARY KEY, username TEXT, password TEXT, name TEXT, email TEXT);';
38 $query = $handle->prepare($sql);
41 $sql = 'INSERT INTO users (username) SELECT value FROM config WHERE name = "login";';
42 $query = $handle->prepare($sql);
45 $sql = "UPDATE users SET password = (SELECT value FROM config WHERE name = 'password')";
46 $query = $handle->prepare($sql);
49 # Création de la table users_config
50 $sql = 'CREATE TABLE users_config (id INTEGER PRIMARY KEY, user_id NUMERIC, name TEXT, value TEXT);';
51 $query = $handle->prepare($sql);
54 # Suppression de la table temporaire
55 $sql = 'DROP TABLE tempEntries;';
56 $query = $handle->prepare($sql);
59 # Vidage de la table de config
60 $sql = 'DELETE FROM config;';
61 $query = $handle->prepare($sql);
64 echo 'welcome to poche 1.0 !';