docs/en/user/query-upgrade-21-22.rst

   1 Migration 20161001072726
   2 ------------------------
   3
   4 MySQL
   5 ^^^^^
   6
   7 Migration up
   8 """"""""""""
   9
  10 .. code-block:: sql
  11
  12     ALTER TABLE wallabag_entry_tag DROP FOREIGN KEY FK_C9F0DD7CBA364942
  13     ALTER TABLE wallabag_entry_tag DROP FOREIGN KEY FK_C9F0DD7CBAD26311
  14     ALTER TABLE wallabag_entry_tag ADD CONSTRAINT FK_entry_tag_entry FOREIGN KEY (entry_id) REFERENCES wallabag_entry (id) ON DELETE CASCADE
  15     ALTER TABLE wallabag_entry_tag ADD CONSTRAINT FK_entry_tag_tag FOREIGN KEY (tag_id) REFERENCES wallabag_tag (id) ON DELETE CASCADE
  16     ALTER TABLE wallabag_annotation DROP FOREIGN KEY FK_A7AED006BA364942
  17     ALTER TABLE wallabag_annotation ADD CONSTRAINT FK_annotation_entry FOREIGN KEY (entry_id) REFERENCES wallabag_entry (id) ON DELETE CASCADE
  18
  19 Migration down
  20 """"""""""""""
  21
  22 We didn't write down migration for ``20161001072726``.
  23
  24 PostgreSQL
  25 ^^^^^^^^^^
  26
  27 Migration up
  28 """"""""""""
  29
  30 .. code-block:: sql
  31
  32     ALTER TABLE wallabag_entry_tag DROP CONSTRAINT fk_c9f0dd7cba364942
  33     ALTER TABLE wallabag_entry_tag DROP CONSTRAINT fk_c9f0dd7cbad26311
  34     ALTER TABLE wallabag_entry_tag ADD CONSTRAINT FK_entry_tag_entry FOREIGN KEY (entry_id) REFERENCES wallabag_entry (id) ON DELETE CASCADE
  35     ALTER TABLE wallabag_entry_tag ADD CONSTRAINT FK_entry_tag_tag FOREIGN KEY (tag_id) REFERENCES wallabag_tag (id) ON DELETE CASCADE
  36     ALTER TABLE wallabag_annotation DROP CONSTRAINT fk_a7aed006ba364942
  37     ALTER TABLE wallabag_annotation ADD CONSTRAINT FK_annotation_entry FOREIGN KEY (entry_id) REFERENCES wallabag_entry (id) ON DELETE CASCADE
  38
  39 Migration down
  40 """"""""""""""
  41
  42 We didn't write down migration for ``20161001072726``.
  43
  44 SQLite
  45 ^^^^^^
  46
  47 This migration can only be executed safely on MySQL or PostgreSQL.
  48
  49 Migration 20161022134138
  50 ------------------------
  51
  52 MySQL
  53 ^^^^^
  54
  55 Migration up
  56 """"""""""""
  57
  58 .. code-block:: sql
  59
  60     ALTER DATABASE wallabag CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
  61     ALTER TABLE wallabag_user CHANGE confirmation_token confirmation_token VARCHAR(180) DEFAULT NULL;
  62     ALTER TABLE wallabag_user CHANGE salt salt VARCHAR(180) NOT NULL;
  63     ALTER TABLE wallabag_user CHANGE password password VARCHAR(180) NOT NULL;
  64     ALTER TABLE wallabag_annotation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  65     ALTER TABLE wallabag_entry CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  66     ALTER TABLE wallabag_tag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  67     ALTER TABLE wallabag_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  68     ALTER TABLE wallabag_annotation CHANGE `text` `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  69     ALTER TABLE wallabag_annotation CHANGE `quote` `quote` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  70     ALTER TABLE wallabag_entry CHANGE `title` `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  71     ALTER TABLE wallabag_entry CHANGE `content` `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  72     ALTER TABLE wallabag_tag CHANGE `label` `label` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  73     ALTER TABLE wallabag_user CHANGE `name` `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  74
  75 Migration down
  76 """"""""""""""
  77
  78 .. code-block:: sql
  79
  80     ALTER DATABASE wallabag CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;
  81     ALTER TABLE wallabag_annotation CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  82     ALTER TABLE wallabag_entry CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  83     ALTER TABLE wallabag_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  84     ALTER TABLE wallabag_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  85     ALTER TABLE wallabag_annotation CHANGE `text` `text` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  86     ALTER TABLE wallabag_annotation CHANGE `quote` `quote` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  87     ALTER TABLE wallabag_entry CHANGE `title` `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  88     ALTER TABLE wallabag_entry CHANGE `content` `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  89     ALTER TABLE wallabag_tag CHANGE `label` `label` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  90     ALTER TABLE wallabag_user CHANGE `name` `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  91
  92 PostgreSQL and SQLite
  93 ^^^^^^^^^^^^^^^^^^^^^
  94
  95 This migration only apply to MySQL.
  96
  97 Migration 20161024212538
  98 ------------------------
  99
 100 MySQL
 101 ^^^^^
 102
 103 Migration up
 104 """"""""""""
 105
 106 .. code-block:: sql
 107
 108     ALTER TABLE wallabag_oauth2_clients ADD user_id INT NOT NULL
 109     ALTER TABLE wallabag_oauth2_clients ADD CONSTRAINT IDX_user_oauth_client FOREIGN KEY (user_id) REFERENCES wallabag_user (id) ON DELETE CASCADE
 110     CREATE INDEX IDX_635D765EA76ED395 ON wallabag_oauth2_clients (user_id)
 111
 112 Migration down
 113 """"""""""""""
 114
 115 .. code-block:: sql
 116
 117     ALTER TABLE wallabag_oauth2_clients DROP FOREIGN KEY IDX_user_oauth_client
 118     ALTER TABLE wallabag_oauth2_clients DROP user_id
 119
 120 PostgreSQL
 121 ^^^^^^^^^^
 122
 123 Migration up
 124 """"""""""""
 125
 126 .. code-block:: sql
 127
 128     ALTER TABLE wallabag_oauth2_clients ADD user_id INT DEFAULT NULL
 129     ALTER TABLE wallabag_oauth2_clients ADD CONSTRAINT IDX_user_oauth_client FOREIGN KEY (user_id) REFERENCES wallabag_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE
 130     CREATE INDEX IDX_635D765EA76ED395 ON wallabag_oauth2_clients (user_id)
 131
 132
 133 Migration down
 134 """"""""""""""
 135
 136 .. code-block:: sql
 137
 138     ALTER TABLE wallabag_oauth2_clients DROP CONSTRAINT idx_user_oauth_client
 139     ALTER TABLE wallabag_oauth2_clients DROP user_id
 140
 141 SQLite
 142 ^^^^^^
 143
 144 Migration up
 145 """"""""""""
 146
 147 .. code-block:: sql
 148
 149     CREATE TEMPORARY TABLE __temp__wallabag_oauth2_clients AS SELECT id, random_id, redirect_uris, secret, allowed_grant_types, name FROM wallabag_oauth2_clients
 150     DROP TABLE wallabag_oauth2_clients
 151     CREATE TABLE wallabag_oauth2_clients (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, random_id VARCHAR(255) NOT NULL COLLATE BINARY, redirect_uris CLOB NOT NULL COLLATE BINARY, secret VARCHAR(255) NOT NULL COLLATE BINARY, allowed_grant_types CLOB NOT NULL COLLATE BINARY, name CLOB DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id), CONSTRAINT IDX_user_oauth_client FOREIGN KEY (user_id) REFERENCES wallabag_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE)
 152     INSERT INTO wallabag_oauth2_clients (id, random_id, redirect_uris, secret, allowed_grant_types, name) SELECT id, random_id, redirect_uris, secret, allowed_grant_types, name FROM __temp__wallabag_oauth2_clients
 153     DROP TABLE __temp__wallabag_oauth2_clients
 154     CREATE INDEX IDX_635D765EA76ED395 ON wallabag_oauth2_clients (user_id)
 155
 156 Migration down
 157 """"""""""""""
 158
 159 .. code-block:: sql
 160
 161     DROP INDEX IDX_635D765EA76ED395
 162     CREATE TEMPORARY TABLE __temp__wallabag_oauth2_clients AS SELECT id, random_id, redirect_uris, secret, allowed_grant_types, name FROM wallabag_oauth2_clients
 163     DROP TABLE wallabag_oauth2_clients
 164     CREATE TABLE wallabag_oauth2_clients (id INTEGER NOT NULL, random_id VARCHAR(255) NOT NULL COLLATE BINARY, redirect_uris CLOB NOT NULL COLLATE BINARY, secret VARCHAR(255) NOT NULL COLLATE BINARY, allowed_grant_types CLOB NOT NULL COLLATE BINARY, name CLOB DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
 165     INSERT INTO wallabag_oauth2_clients (id, random_id, redirect_uris, secret, allowed_grant_types, name) SELECT id, random_id, redirect_uris, secret, allowed_grant_types, name FROM __temp__wallabag_oauth2_clients
 166     DROP TABLE __temp__wallabag_oauth2_clients
 167
 168 Migration 20161031132655
 169 ------------------------
 170
 171 MySQL
 172 ^^^^^
 173
 174 Migration up
 175 """"""""""""
 176
 177 .. code-block:: sql
 178
 179     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('download_images_enabled', 0, 'misc')
 180
 181 Migration down
 182 """"""""""""""
 183
 184 .. code-block:: sql
 185
 186     DELETE FROM wallabag_craue_config_setting WHERE name = 'download_images_enabled';
 187
 188 PostgreSQL
 189 ^^^^^^^^^^
 190
 191 Migration up
 192 """"""""""""
 193
 194 .. code-block:: sql
 195
 196     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('download_images_enabled', 0, 'misc')
 197
 198 Migration down
 199 """"""""""""""
 200
 201 .. code-block:: sql
 202
 203     DELETE FROM wallabag_craue_config_setting WHERE name = 'download_images_enabled';
 204
 205 SQLite
 206 ^^^^^^
 207
 208 Migration up
 209 """"""""""""
 210
 211 .. code-block:: sql
 212
 213     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('download_images_enabled', 0, 'misc')
 214
 215 Migration down
 216 """"""""""""""
 217
 218 .. code-block:: sql
 219
 220     DELETE FROM wallabag_craue_config_setting WHERE name = 'download_images_enabled';
 221
 222 Migration 20161104073720
 223 ------------------------
 224
 225 MySQL
 226 ^^^^^
 227
 228 Migration up
 229 """"""""""""
 230
 231 .. code-block:: sql
 232
 233     CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at)
 234
 235 Migration down
 236 """"""""""""""
 237
 238 .. code-block:: sql
 239
 240     DROP INDEX IDX_entry_created_at ON wallabag_entry
 241
 242 PostgreSQL
 243 ^^^^^^^^^^
 244
 245 Migration up
 246 """"""""""""
 247
 248 .. code-block:: sql
 249
 250     CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at)
 251
 252 Migration down
 253 """"""""""""""
 254
 255 .. code-block:: sql
 256
 257     DROP INDEX idx_entry_created_at
 258
 259 SQLite
 260 ^^^^^^
 261
 262 Migration up
 263 """"""""""""
 264
 265 .. code-block:: sql
 266
 267     DROP INDEX created_at_idx
 268     DROP INDEX IDX_F4D18282A76ED395
 269     CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM wallabag_entry
 270     DROP TABLE wallabag_entry
 271     CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uuid CLOB 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', PRIMARY KEY(id))
 272     INSERT INTO wallabag_entry (id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public) SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM __temp__wallabag_entry
 273     DROP TABLE __temp__wallabag_entry
 274     CREATE INDEX created_at_idx ON wallabag_entry (created_at)
 275     CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
 276     CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at)
 277
 278 Migration down
 279 """"""""""""""
 280
 281 .. code-block:: sql
 282
 283     DROP INDEX IDX_entry_created_at
 284     DROP INDEX IDX_F4D18282A76ED395
 285     DROP INDEX created_at_idx
 286     CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM wallabag_entry
 287     DROP TABLE wallabag_entry
 288     CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uuid CLOB 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', PRIMARY KEY(id))
 289     INSERT INTO wallabag_entry (id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public) SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM __temp__wallabag_entry
 290     DROP TABLE __temp__wallabag_entry
 291     CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
 292     CREATE INDEX created_at_idx ON wallabag_entry (created_at)
 293
 294 Migration 20161106113822
 295 ------------------------
 296
 297 MySQL
 298 ^^^^^
 299
 300 Migration up
 301 """"""""""""
 302
 303 .. code-block:: sql
 304
 305     ALTER TABLE wallabag_config ADD action_mark_as_read INT DEFAULT 0
 306
 307 Migration down
 308 """"""""""""""
 309
 310 .. code-block:: sql
 311
 312     ALTER TABLE wallabag_config DROP action_mark_as_read
 313
 314 PostgreSQL
 315 ^^^^^^^^^^
 316
 317 Migration up
 318 """"""""""""
 319
 320 .. code-block:: sql
 321
 322     ALTER TABLE wallabag_config ADD action_mark_as_read INT DEFAULT 0
 323
 324 Migration down
 325 """"""""""""""
 326
 327 .. code-block:: sql
 328
 329     ALTER TABLE wallabag_config DROP action_mark_as_read
 330
 331 SQLite
 332 ^^^^^^
 333
 334 Migration up
 335 """"""""""""
 336
 337 .. code-block:: sql
 338
 339     ALTER TABLE wallabag_config ADD COLUMN action_mark_as_read INTEGER DEFAULT 0
 340
 341 Migration down
 342 """"""""""""""
 343
 344 .. code-block:: sql
 345
 346     DROP INDEX UNIQ_87E64C53A76ED395
 347     CREATE TEMPORARY TABLE __temp__wallabag_config AS SELECT id, user_id, theme, items_per_page, language, rss_token, rss_limit, reading_speed, pocket_consumer_key FROM wallabag_config
 348     DROP TABLE wallabag_config
 349     CREATE TABLE wallabag_config (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, theme VARCHAR(255) NOT NULL COLLATE BINARY, items_per_page INTEGER NOT NULL, language VARCHAR(255) NOT NULL COLLATE BINARY, rss_token VARCHAR(255) DEFAULT NULL COLLATE BINARY, rss_limit INTEGER DEFAULT NULL, reading_speed DOUBLE PRECISION DEFAULT NULL, pocket_consumer_key VARCHAR(255) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
 350     INSERT INTO wallabag_config (id, user_id, theme, items_per_page, language, rss_token, rss_limit, reading_speed, pocket_consumer_key) SELECT id, user_id, theme, items_per_page, language, rss_token, rss_limit, reading_speed, pocket_consumer_key FROM __temp__wallabag_config
 351     DROP TABLE __temp__wallabag_config
 352     CREATE UNIQUE INDEX UNIQ_87E64C53A76ED395 ON wallabag_config (user_id)
 353
 354 Migration 20161117071626
 355 ------------------------
 356
 357 MySQL
 358 ^^^^^
 359
 360 Migration up
 361 """"""""""""
 362
 363 .. code-block:: sql
 364
 365     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('share_unmark', 0, 'entry')
 366     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('unmark_url', 'https://unmark.it', 'entry')
 367
 368 Migration down
 369 """"""""""""""
 370
 371 .. code-block:: sql
 372
 373     DELETE FROM wallabag_craue_config_setting WHERE name = 'share_unmark';
 374     DELETE FROM wallabag_craue_config_setting WHERE name = 'unmark_url';
 375
 376 PostgreSQL
 377 ^^^^^^^^^^
 378
 379 Migration up
 380 """"""""""""
 381
 382 .. code-block:: sql
 383
 384     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('share_unmark', 0, 'entry')
 385     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('unmark_url', 'https://unmark.it', 'entry')
 386
 387 Migration down
 388 """"""""""""""
 389
 390 .. code-block:: sql
 391
 392     DELETE FROM wallabag_craue_config_setting WHERE name = 'share_unmark';
 393     DELETE FROM wallabag_craue_config_setting WHERE name = 'unmark_url';
 394
 395 SQLite
 396 ^^^^^^
 397
 398 Migration up
 399 """"""""""""
 400
 401 .. code-block:: sql
 402
 403     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('share_unmark', 0, 'entry')
 404     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('unmark_url', 'https://unmark.it', 'entry')
 405
 406 Migration down
 407 """"""""""""""
 408
 409 .. code-block:: sql
 410
 411     DELETE FROM wallabag_craue_config_setting WHERE name = 'share_unmark';
 412     DELETE FROM wallabag_craue_config_setting WHERE name = 'unmark_url';
 413
 414 Migration 20161118134328
 415 ------------------------
 416
 417 MySQL
 418 ^^^^^
 419
 420 Migration up
 421 """"""""""""
 422
 423 .. code-block:: sql
 424
 425     ALTER TABLE wallabag_entry ADD http_status VARCHAR(3) DEFAULT NULL
 426
 427 Migration down
 428 """"""""""""""
 429
 430 .. code-block:: sql
 431
 432     ALTER TABLE wallabag_entry DROP http_status
 433
 434 PostgreSQL
 435 ^^^^^^^^^^
 436
 437 Migration up
 438 """"""""""""
 439
 440 .. code-block:: sql
 441
 442     ALTER TABLE wallabag_entry ADD http_status VARCHAR(3) DEFAULT NULL
 443
 444 Migration down
 445 """"""""""""""
 446
 447 .. code-block:: sql
 448
 449     ALTER TABLE wallabag_entry DROP http_status
 450
 451 SQLite
 452 ^^^^^^
 453
 454 Migration up
 455 """"""""""""
 456
 457 .. code-block:: sql
 458
 459     ALTER TABLE wallabag_entry ADD COLUMN http_status VARCHAR(3) DEFAULT NULL
 460
 461 Migration down
 462 """"""""""""""
 463
 464 .. code-block:: sql
 465
 466     DROP INDEX created_at_idx
 467     DROP INDEX IDX_F4D18282A76ED395
 468     CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM wallabag_entry
 469     DROP TABLE wallabag_entry
 470     CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uuid CLOB 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', PRIMARY KEY(id))
 471     INSERT INTO wallabag_entry (id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public) SELECT id, user_id, uuid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public FROM __temp__wallabag_entry
 472     DROP TABLE __temp__wallabag_entry
 473     CREATE INDEX created_at_idx ON wallabag_entry (created_at)
 474     CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
 475
 476 Migration 20161122144743
 477 ------------------------
 478
 479 MySQL
 480 ^^^^^
 481
 482 Migration up
 483 """"""""""""
 484
 485 .. code-block:: sql
 486
 487     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('restricted_access', 0, 'entry')
 488
 489 Migration down
 490 """"""""""""""
 491
 492 .. code-block:: sql
 493
 494     DELETE FROM wallabag_craue_config_setting WHERE name = 'restricted_access';
 495
 496 PostgreSQL
 497 ^^^^^^^^^^
 498
 499 Migration up
 500 """"""""""""
 501
 502 .. code-block:: sql
 503
 504     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('restricted_access', 0, 'entry')
 505
 506 Migration down
 507 """"""""""""""
 508
 509 .. code-block:: sql
 510
 511     DELETE FROM wallabag_craue_config_setting WHERE name = 'restricted_access';
 512
 513 SQLite
 514 ^^^^^^
 515
 516 Migration up
 517 """"""""""""
 518
 519 .. code-block:: sql
 520
 521     INSERT INTO wallabag_craue_config_setting (name, value, section) VALUES ('restricted_access', 0, 'entry')
 522
 523 Migration down
 524 """"""""""""""
 525
 526 .. code-block:: sql
 527
 528     DELETE FROM wallabag_craue_config_setting WHERE name = 'restricted_access';
 529
 530 Migration 20161122203647
 531 ------------------------
 532
 533 MySQL
 534 ^^^^^
 535
 536 Migration up
 537 """"""""""""
 538
 539 .. code-block:: sql
 540
 541     ALTER TABLE wallabag_user DROP expired, DROP credentials_expired
 542
 543 Migration down
 544 """"""""""""""
 545
 546 .. code-block:: sql
 547
 548     ALTER TABLE wallabag_user ADD expired SMALLINT DEFAULT NULL, ADD credentials_expired SMALLINT DEFAULT NULL
 549
 550 PostgreSQL
 551 ^^^^^^^^^^
 552
 553 Migration up
 554 """"""""""""
 555
 556 .. code-block:: sql
 557
 558     ALTER TABLE wallabag_user DROP expired
 559     ALTER TABLE wallabag_user DROP credentials_expired
 560
 561 Migration down
 562 """"""""""""""
 563
 564 .. code-block:: sql
 565
 566     ALTER TABLE wallabag_user ADD expired SMALLINT DEFAULT NULL
 567     ALTER TABLE wallabag_user ADD credentials_expired SMALLINT DEFAULT NULL
 568
 569 SQLite
 570 ^^^^^^
 571
 572 Migration up
 573 """"""""""""
 574
 575 .. code-block:: sql
 576
 577     DROP INDEX UNIQ_1D63E7E5C05FB297
 578     DROP INDEX UNIQ_1D63E7E5A0D96FBF
 579     DROP INDEX UNIQ_1D63E7E592FC23A8
 580     CREATE TEMPORARY TABLE __temp__wallabag_user AS SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expires_at, confirmation_token, password_requested_at, roles, credentials_expire_at, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted FROM wallabag_user
 581     DROP TABLE wallabag_user
 582     CREATE TABLE wallabag_user (id INTEGER NOT NULL, username VARCHAR(180) NOT NULL COLLATE BINARY, username_canonical VARCHAR(180) NOT NULL COLLATE BINARY, email VARCHAR(180) NOT NULL COLLATE BINARY, email_canonical VARCHAR(180) NOT NULL COLLATE BINARY, enabled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL COLLATE BINARY, password VARCHAR(255) NOT NULL COLLATE BINARY, last_login DATETIME DEFAULT NULL, locked BOOLEAN NOT NULL, expires_at DATETIME DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL COLLATE BINARY, password_requested_at DATETIME DEFAULT NULL, roles CLOB NOT NULL COLLATE BINARY, credentials_expire_at DATETIME DEFAULT NULL, name CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, authCode INTEGER DEFAULT NULL, twoFactorAuthentication BOOLEAN NOT NULL, trusted CLOB DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
 583     INSERT INTO wallabag_user (id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expires_at, confirmation_token, password_requested_at, roles, credentials_expire_at, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted) SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expires_at, confirmation_token, password_requested_at, roles, credentials_expire_at, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted FROM __temp__wallabag_user
 584     DROP TABLE __temp__wallabag_user
 585     CREATE UNIQUE INDEX UNIQ_1D63E7E5C05FB297 ON wallabag_user (confirmation_token)
 586     CREATE UNIQUE INDEX UNIQ_1D63E7E5A0D96FBF ON wallabag_user (email_canonical)
 587     CREATE UNIQUE INDEX UNIQ_1D63E7E592FC23A8 ON wallabag_user (username_canonical)
 588
 589 Migration down
 590 """"""""""""""
 591
 592 .. code-block:: sql
 593
 594     ALTER TABLE wallabag_user ADD COLUMN expired SMALLINT DEFAULT NULL
 595     ALTER TABLE wallabag_user ADD COLUMN credentials_expired SMALLINT DEFAULT NULL
 596
 597 Migration 20161128084725
 598 ------------------------
 599
 600 MySQL
 601 ^^^^^
 602
 603 Migration up
 604 """"""""""""
 605
 606 .. code-block:: sql
 607
 608     ALTER TABLE wallabag_config ADD list_mode INT DEFAULT NULL
 609
 610 Migration down
 611 """"""""""""""
 612
 613 .. code-block:: sql
 614
 615     ALTER TABLE wallabag_config DROP list_mode
 616
 617 PostgreSQL
 618 ^^^^^^^^^^
 619
 620 Migration up
 621 """"""""""""
 622
 623 .. code-block:: sql
 624
 625     ALTER TABLE wallabag_config ADD list_mode INT DEFAULT NULL
 626
 627 Migration down
 628 """"""""""""""
 629
 630 .. code-block:: sql
 631
 632     ALTER TABLE wallabag_config DROP list_mode
 633
 634 SQLite
 635 ^^^^^^
 636
 637 Migration up
 638 """"""""""""
 639
 640 .. code-block:: sql
 641
 642     ALTER TABLE wallabag_config ADD COLUMN list_mode INTEGER DEFAULT NULL
 643
 644 Migration down
 645 """"""""""""""
 646
 647 .. code-block:: sql
 648
 649     DROP INDEX UNIQ_87E64C53A76ED395
 650     CREATE TEMPORARY TABLE __temp__wallabag_config AS SELECT id, user_id, theme, items_per_page, language, rss_token, rss_limit, reading_speed, pocket_consumer_key FROM wallabag_config
 651     DROP TABLE wallabag_config
 652     CREATE TABLE wallabag_config (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, theme VARCHAR(255) NOT NULL COLLATE BINARY, items_per_page INTEGER NOT NULL, language VARCHAR(255) NOT NULL COLLATE BINARY, rss_token VARCHAR(255) DEFAULT NULL COLLATE BINARY, rss_limit INTEGER DEFAULT NULL, reading_speed DOUBLE PRECISION DEFAULT NULL, pocket_consumer_key VARCHAR(255) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id))
 653     INSERT INTO wallabag_config (id, user_id, theme, items_per_page, language, rss_token, rss_limit, reading_speed, pocket_consumer_key) SELECT id, user_id, theme, items_per_page, language, rss_token, rss_limit, reading_speed, pocket_consumer_key FROM __temp__wallabag_config
 654     DROP TABLE __temp__wallabag_config
 655     CREATE UNIQUE INDEX UNIQ_87E64C53A76ED395 ON wallabag_config (user_id)
 656
 657 Migration 20161128131503
 658 ------------------------
 659
 660 MySQL
 661 ^^^^^
 662
 663 Migration up
 664 """"""""""""
 665
 666 .. code-block:: sql
 667
 668     ALTER TABLE wallabag_user DROP locked, DROP credentials_expire_at, DROP expires_at
 669
 670 Migration down
 671 """"""""""""""
 672
 673 .. code-block:: sql
 674
 675     ALTER TABLE wallabag_user ADD locked SMALLINT DEFAULT NULL, ADD credentials_expire_at DATETIME DEFAULT NULL, ADD expires_at DATETIME DEFAULT NULL
 676
 677 PostgreSQL
 678 ^^^^^^^^^^
 679
 680 Migration up
 681 """"""""""""
 682
 683 .. code-block:: sql
 684
 685     ALTER TABLE wallabag_user DROP locked
 686     ALTER TABLE wallabag_user DROP credentials_expire_at
 687     ALTER TABLE wallabag_user DROP expires_at
 688
 689 Migration down
 690 """"""""""""""
 691
 692 .. code-block:: sql
 693
 694     ALTER TABLE wallabag_user ADD locked SMALLINT DEFAULT NULL
 695     ALTER TABLE wallabag_user ADD credentials_expire_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL
 696     ALTER TABLE wallabag_user ADD expires_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL
 697
 698 SQLite
 699 ^^^^^^
 700
 701 Migration up
 702 """"""""""""
 703
 704 .. code-block:: sql
 705
 706     ALTER TABLE wallabag_user ADD COLUMN locked SMALLINT DEFAULT NULL
 707     ALTER TABLE wallabag_user ADD COLUMN credentials_expire_at DATETIME DEFAULT NULL
 708     ALTER TABLE wallabag_user ADD COLUMN expires_at DATETIME DEFAULT NULL
 709
 710 Migration down
 711 """"""""""""""
 712
 713 .. code-block:: sql
 714
 715     DROP INDEX UNIQ_1D63E7E592FC23A8
 716     DROP INDEX UNIQ_1D63E7E5A0D96FBF
 717     DROP INDEX UNIQ_1D63E7E5C05FB297
 718     CREATE TEMPORARY TABLE __temp__wallabag_user AS SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted, expired, credentials_expired FROM wallabag_user
 719     DROP TABLE wallabag_user
 720     CREATE TABLE wallabag_user (id INTEGER NOT NULL, username VARCHAR(180) NOT NULL COLLATE BINARY, username_canonical VARCHAR(180) NOT NULL COLLATE BINARY, email VARCHAR(180) NOT NULL COLLATE BINARY, email_canonical VARCHAR(180) NOT NULL COLLATE BINARY, enabled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL COLLATE BINARY, password VARCHAR(255) NOT NULL COLLATE BINARY, last_login DATETIME DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL COLLATE BINARY, password_requested_at DATETIME DEFAULT NULL, roles CLOB NOT NULL COLLATE BINARY, name CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, authCode INTEGER DEFAULT NULL, twoFactorAuthentication BOOLEAN NOT NULL, trusted CLOB DEFAULT NULL COLLATE BINARY, expired SMALLINT DEFAULT NULL, credentials_expired SMALLINT DEFAULT NULL, PRIMARY KEY(id))
 721     INSERT INTO wallabag_user (id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted, expired, credentials_expired) SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted, expired, credentials_expired FROM __temp__wallabag_user
 722     DROP TABLE __temp__wallabag_user
 723     CREATE UNIQUE INDEX UNIQ_1D63E7E592FC23A8 ON wallabag_user (username_canonical)
 724     CREATE UNIQUE INDEX UNIQ_1D63E7E5A0D96FBF ON wallabag_user (email_canonical)
 725     CREATE UNIQUE INDEX UNIQ_1D63E7E5C05FB297 ON wallabag_user (confirmation_token)
 726
 727 Migration 20161214094403
 728 ------------------------
 729
 730 MySQL
 731 ^^^^^
 732
 733 Migration up
 734 """"""""""""
 735
 736 .. code-block:: sql
 737
 738     CREATE INDEX IDX_entry_uid ON wallabag_entry (uid)
 739
 740 Migration down
 741 """"""""""""""
 742
 743 .. code-block:: sql
 744
 745     DROP INDEX IDX_entry_uid ON wallabag_entry
 746
 747 PostgreSQL
 748 ^^^^^^^^^^
 749
 750 Migration up
 751 """"""""""""
 752
 753 .. code-block:: sql
 754
 755     CREATE INDEX IDX_entry_uid ON wallabag_entry (uid)
 756
 757 Migration down
 758 """"""""""""""
 759
 760 .. code-block:: sql
 761
 762     DROP INDEX idx_entry_uid
 763
 764 SQLite
 765 ^^^^^^
 766
 767 Migration up
 768 """"""""""""
 769
 770 .. code-block:: sql
 771
 772     DROP INDEX IDX_F4D18282A76ED395
 773     DROP INDEX created_at_idx
 774     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 FROM wallabag_entry
 775     DROP TABLE wallabag_entry
 776     CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid CLOB 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', PRIMARY KEY(id))
 777     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) 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 FROM __temp__wallabag_entry
 778     DROP TABLE __temp__wallabag_entry
 779     CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)
 780     CREATE INDEX created_at_idx ON wallabag_entry (created_at)
 781     CREATE INDEX IDX_entry_uid ON wallabag_entry (uid)
 782
 783 Migration down
 784 """"""""""""""
 785
 786 .. code-block:: sql
 787
 788     DROP INDEX IDX_entry_uid
 789     DROP INDEX created_at_idx
 790     DROP INDEX IDX_F4D18282A76ED395
 791     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 FROM wallabag_entry
 792     DROP TABLE wallabag_entry
 793     CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, uid CLOB 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', PRIMARY KEY(id))
 794     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) 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 FROM __temp__wallabag_entry
 795     DROP TABLE __temp__wallabag_entry
 796     CREATE INDEX created_at_idx ON wallabag_entry (created_at)
 797     CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id)