aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
-rw-r--r--app/DoctrineMigrations/Version20170127093841.php56
-rw-r--r--docs/de/user/query-upgrade-21-22.rst82
-rw-r--r--docs/de/user/upgrade.rst5
-rw-r--r--docs/en/user/query-upgrade-21-22.rst82
-rw-r--r--docs/en/user/upgrade.rst2
-rw-r--r--docs/fr/user/query-upgrade-21-22.rst82
-rw-r--r--docs/fr/user/upgrade.rst5
7 files changed, 314 insertions, 0 deletions
diff --git a/app/DoctrineMigrations/Version20170127093841.php b/app/DoctrineMigrations/Version20170127093841.php
new file mode 100644
index 00000000..20c79479
--- /dev/null
+++ b/app/DoctrineMigrations/Version20170127093841.php
@@ -0,0 +1,56 @@
1<?php
2
3namespace Application\Migrations;
4
5use Doctrine\DBAL\Migrations\AbstractMigration;
6use Doctrine\DBAL\Schema\Schema;
7use Symfony\Component\DependencyInjection\ContainerAwareInterface;
8use Symfony\Component\DependencyInjection\ContainerInterface;
9
10/**
11 * Added indexes on wallabag_entry.is_starred and wallabag_entry.is_archived
12 */
13class Version20170127093841 extends AbstractMigration implements ContainerAwareInterface
14{
15 /**
16 * @var ContainerInterface
17 */
18 private $container;
19
20 private $indexStarredName = 'IDX_entry_starred';
21 private $indexArchivedName = 'IDX_entry_archived';
22
23 public function setContainer(ContainerInterface $container = null)
24 {
25 $this->container = $container;
26 }
27
28 private function getTable($tableName)
29 {
30 return $this->container->getParameter('database_table_prefix').$tableName;
31 }
32
33 /**
34 * @param Schema $schema
35 */
36 public function up(Schema $schema)
37 {
38 $entryTable = $schema->getTable($this->getTable('entry'));
39 $this->skipIf($entryTable->hasIndex($this->indexStarredName) && $entryTable->hasIndex($this->indexArchivedName), 'It seems that you already played this migration.');
40
41 $entryTable->addIndex(['is_starred'], $this->indexStarredName);
42 $entryTable->addIndex(['is_archived'], $this->indexArchivedName);
43 }
44
45 /**
46 * @param Schema $schema
47 */
48 public function down(Schema $schema)
49 {
50 $entryTable = $schema->getTable($this->getTable('entry'));
51 $this->skipIf(false === $entryTable->hasIndex($this->indexStarredName) && false === $entryTable->hasIndex($this->indexArchivedName), 'It seems that you already played this migration.');
52
53 $entryTable->dropIndex($this->indexStarredName);
54 $entryTable->dropIndex($this->indexArchivedName);
55 }
56}
diff --git a/docs/de/user/query-upgrade-21-22.rst b/docs/de/user/query-upgrade-21-22.rst
index cd201dc2..f32d5a19 100644
--- a/docs/de/user/query-upgrade-21-22.rst
+++ b/docs/de/user/query-upgrade-21-22.rst
@@ -795,3 +795,85 @@ Migration down
795 DROP TABLE __temp__wallabag_entry 795 DROP TABLE __temp__wallabag_entry
796 CREATE INDEX created_at_idx ON wallabag_entry (created_at) 796 CREATE INDEX created_at_idx ON wallabag_entry (created_at)
797 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) 797 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
798
799Migration 20170127093841
800------------------------
801
802MySQL
803^^^^^
804
805Migration up
806""""""""""""
807
808.. code-block:: sql
809
810 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
811 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
812
813Migration down
814""""""""""""""
815
816.. code-block:: sql
817
818 DROP INDEX IDX_entry_starred ON wallabag_entry
819 DROP INDEX IDX_entry_archived ON wallabag_entry
820
821PostgreSQL
822^^^^^^^^^^
823
824Migration up
825""""""""""""
826
827.. code-block:: sql
828
829 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
830 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
831
832Migration down
833""""""""""""""
834
835.. code-block:: sql
836
837 DROP INDEX IDX_entry_starred
838 DROP INDEX IDX_entry_archived
839
840SQLite
841^^^^^^
842
843Migration up
844""""""""""""
845
846.. code-block:: sql
847
848 DROP INDEX uid
849 DROP INDEX created_at
850 DROP INDEX IDX_F4D18282A76ED395
851 CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM wallabag_entry
852 DROP TABLE wallabag_entry
853 CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
854 INSERT INTO wallabag_entry (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status) SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM __temp__wallabag_entry
855 DROP TABLE __temp__wallabag_entry
856 CREATE INDEX uid ON wallabag_entry (uid)
857 CREATE INDEX created_at ON wallabag_entry (created_at)
858 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
859 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
860 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
861
862Migration down
863""""""""""""""
864
865.. code-block:: sql
866
867 DROP INDEX IDX_entry_archived
868 DROP INDEX IDX_entry_starred
869 DROP INDEX IDX_F4D18282A76ED395
870 DROP INDEX created_at
871 DROP INDEX uid
872 CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM wallabag_entry
873 DROP TABLE wallabag_entry
874 CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
875 INSERT INTO wallabag_entry (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status) SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM __temp__wallabag_entry
876 DROP TABLE __temp__wallabag_entry
877 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
878 CREATE INDEX created_at ON wallabag_entry (created_at)
879 CREATE INDEX uid ON wallabag_entry (uid)
diff --git a/docs/de/user/upgrade.rst b/docs/de/user/upgrade.rst
index 1107616e..544c7167 100644
--- a/docs/de/user/upgrade.rst
+++ b/docs/de/user/upgrade.rst
@@ -37,6 +37,11 @@ Dies ist die Migrationsliste von 2.1.x auf 2.2.0:
37* ``20161118134328``: ``http_status``-Feld zur ``entry``-Tabelle hinzugefügt 37* ``20161118134328``: ``http_status``-Feld zur ``entry``-Tabelle hinzugefügt
38* ``20161122144743``: Interne Einstellung für das (de-)aktivieren zum Holen von Artikeln mit einer Paywall hinzugefügt 38* ``20161122144743``: Interne Einstellung für das (de-)aktivieren zum Holen von Artikeln mit einer Paywall hinzugefügt
39* ``20161122203647``: ``expired``- und ``credentials_expired``-Feld aus der ``user``-Tabelle entfernt 39* ``20161122203647``: ``expired``- und ``credentials_expired``-Feld aus der ``user``-Tabelle entfernt
40* ``20161128084725``: added ``list_mode`` field on ``config`` table
41* ``20161128131503``: dropped ``locked``, ``credentials_expire_at`` and ``expires_at`` fields on ``user`` table
42* ``20161214094402``: renamed ``uuid`` to ``uid`` on ``entry`` table
43* ``20161214094403``: added ``uid`` index on ``entry`` table
44* ``20170127093841``: added ``is_starred`` and ``is_archived`` indexes on ``entry`` table
40 45
41Upgrade auf einem Shared Hosting 46Upgrade auf einem Shared Hosting
42^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 47^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git a/docs/en/user/query-upgrade-21-22.rst b/docs/en/user/query-upgrade-21-22.rst
index cd201dc2..f32d5a19 100644
--- a/docs/en/user/query-upgrade-21-22.rst
+++ b/docs/en/user/query-upgrade-21-22.rst
@@ -795,3 +795,85 @@ Migration down
795 DROP TABLE __temp__wallabag_entry 795 DROP TABLE __temp__wallabag_entry
796 CREATE INDEX created_at_idx ON wallabag_entry (created_at) 796 CREATE INDEX created_at_idx ON wallabag_entry (created_at)
797 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) 797 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
798
799Migration 20170127093841
800------------------------
801
802MySQL
803^^^^^
804
805Migration up
806""""""""""""
807
808.. code-block:: sql
809
810 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
811 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
812
813Migration down
814""""""""""""""
815
816.. code-block:: sql
817
818 DROP INDEX IDX_entry_starred ON wallabag_entry
819 DROP INDEX IDX_entry_archived ON wallabag_entry
820
821PostgreSQL
822^^^^^^^^^^
823
824Migration up
825""""""""""""
826
827.. code-block:: sql
828
829 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
830 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
831
832Migration down
833""""""""""""""
834
835.. code-block:: sql
836
837 DROP INDEX IDX_entry_starred
838 DROP INDEX IDX_entry_archived
839
840SQLite
841^^^^^^
842
843Migration up
844""""""""""""
845
846.. code-block:: sql
847
848 DROP INDEX uid
849 DROP INDEX created_at
850 DROP INDEX IDX_F4D18282A76ED395
851 CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM wallabag_entry
852 DROP TABLE wallabag_entry
853 CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
854 INSERT INTO wallabag_entry (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status) SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM __temp__wallabag_entry
855 DROP TABLE __temp__wallabag_entry
856 CREATE INDEX uid ON wallabag_entry (uid)
857 CREATE INDEX created_at ON wallabag_entry (created_at)
858 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
859 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
860 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
861
862Migration down
863""""""""""""""
864
865.. code-block:: sql
866
867 DROP INDEX IDX_entry_archived
868 DROP INDEX IDX_entry_starred
869 DROP INDEX IDX_F4D18282A76ED395
870 DROP INDEX created_at
871 DROP INDEX uid
872 CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM wallabag_entry
873 DROP TABLE wallabag_entry
874 CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
875 INSERT INTO wallabag_entry (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status) SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM __temp__wallabag_entry
876 DROP TABLE __temp__wallabag_entry
877 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
878 CREATE INDEX created_at ON wallabag_entry (created_at)
879 CREATE INDEX uid ON wallabag_entry (uid)
diff --git a/docs/en/user/upgrade.rst b/docs/en/user/upgrade.rst
index 99260e13..889b5300 100644
--- a/docs/en/user/upgrade.rst
+++ b/docs/en/user/upgrade.rst
@@ -43,7 +43,9 @@ Here is the migrations list for 2.1.x to 2.2.0 release:
43* ``20161122203647``: dropped ``expired`` and ``credentials_expired`` fields on ``user`` table 43* ``20161122203647``: dropped ``expired`` and ``credentials_expired`` fields on ``user`` table
44* ``20161128084725``: added ``list_mode`` field on ``config`` table 44* ``20161128084725``: added ``list_mode`` field on ``config`` table
45* ``20161128131503``: dropped ``locked``, ``credentials_expire_at`` and ``expires_at`` fields on ``user`` table 45* ``20161128131503``: dropped ``locked``, ``credentials_expire_at`` and ``expires_at`` fields on ``user`` table
46* ``20161214094402``: renamed ``uuid`` to ``uid`` on ``entry`` table
46* ``20161214094403``: added ``uid`` index on ``entry`` table 47* ``20161214094403``: added ``uid`` index on ``entry`` table
48* ``20170127093841``: added ``is_starred`` and ``is_archived`` indexes on ``entry`` table
47 49
48Upgrade on a shared hosting 50Upgrade on a shared hosting
49=========================== 51===========================
diff --git a/docs/fr/user/query-upgrade-21-22.rst b/docs/fr/user/query-upgrade-21-22.rst
index cd201dc2..f32d5a19 100644
--- a/docs/fr/user/query-upgrade-21-22.rst
+++ b/docs/fr/user/query-upgrade-21-22.rst
@@ -795,3 +795,85 @@ Migration down
795 DROP TABLE __temp__wallabag_entry 795 DROP TABLE __temp__wallabag_entry
796 CREATE INDEX created_at_idx ON wallabag_entry (created_at) 796 CREATE INDEX created_at_idx ON wallabag_entry (created_at)
797 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) 797 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
798
799Migration 20170127093841
800------------------------
801
802MySQL
803^^^^^
804
805Migration up
806""""""""""""
807
808.. code-block:: sql
809
810 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
811 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
812
813Migration down
814""""""""""""""
815
816.. code-block:: sql
817
818 DROP INDEX IDX_entry_starred ON wallabag_entry
819 DROP INDEX IDX_entry_archived ON wallabag_entry
820
821PostgreSQL
822^^^^^^^^^^
823
824Migration up
825""""""""""""
826
827.. code-block:: sql
828
829 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
830 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
831
832Migration down
833""""""""""""""
834
835.. code-block:: sql
836
837 DROP INDEX IDX_entry_starred
838 DROP INDEX IDX_entry_archived
839
840SQLite
841^^^^^^
842
843Migration up
844""""""""""""
845
846.. code-block:: sql
847
848 DROP INDEX uid
849 DROP INDEX created_at
850 DROP INDEX IDX_F4D18282A76ED395
851 CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM wallabag_entry
852 DROP TABLE wallabag_entry
853 CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
854 INSERT INTO wallabag_entry (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status) SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM __temp__wallabag_entry
855 DROP TABLE __temp__wallabag_entry
856 CREATE INDEX uid ON wallabag_entry (uid)
857 CREATE INDEX created_at ON wallabag_entry (created_at)
858 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
859 CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred)
860 CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived)
861
862Migration down
863""""""""""""""
864
865.. code-block:: sql
866
867 DROP INDEX IDX_entry_archived
868 DROP INDEX IDX_entry_starred
869 DROP INDEX IDX_F4D18282A76ED395
870 DROP INDEX created_at
871 DROP INDEX uid
872 CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM wallabag_entry
873 DROP TABLE wallabag_entry
874 CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
875 INSERT INTO wallabag_entry (id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status) SELECT id, user_id, uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status FROM __temp__wallabag_entry
876 DROP TABLE __temp__wallabag_entry
877 CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
878 CREATE INDEX created_at ON wallabag_entry (created_at)
879 CREATE INDEX uid ON wallabag_entry (uid)
diff --git a/docs/fr/user/upgrade.rst b/docs/fr/user/upgrade.rst
index 088b19a0..2ca5d127 100644
--- a/docs/fr/user/upgrade.rst
+++ b/docs/fr/user/upgrade.rst
@@ -37,6 +37,11 @@ Voici la liste des migrations de la 2.1.x à la 2.2.0 :
37* ``20161118134328``: ajout du champ ``http_status`` sur la table ``entry`` 37* ``20161118134328``: ajout du champ ``http_status`` sur la table ``entry``
38* ``20161122144743``: ajout du paramètre interne pour activer/désactiver la récupération d'articles derrière un paywall 38* ``20161122144743``: ajout du paramètre interne pour activer/désactiver la récupération d'articles derrière un paywall
39* ``20161122203647``: suppression des champs ``expired`` et ``credentials_expired`` sur la table ``user`` 39* ``20161122203647``: suppression des champs ``expired`` et ``credentials_expired`` sur la table ``user``
40* ``20161128084725``: ajout du champ ``list_mode`` sur la table ``config``
41* ``20161128131503``: suppression des champs ``locked``, ``credentials_expire_at`` et ``expires_at`` sur la table ``user``
42* ``20161214094402``: renommage du champ ``uuid`` en ``uid`` sur la table ``entry``
43* ``20161214094403``: ajout de l'index ``uid`` sur la table ``entry``
44* ``20170127093841``: ajout des index ``is_starred`` et ``is_archived`` sur la table ``entry``
40 45
41Mise à jour sur un hébergement mutualisé 46Mise à jour sur un hébergement mutualisé
42^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 47^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^