aboutsummaryrefslogtreecommitdiffhomepage
path: root/app/DoctrineMigrations
Commit message (Collapse)AuthorAgeFilesLines
* Update depsJeremy Benoist2019-11-1240-237/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also CS (because cs-fixer got an update) Package operations: 0 installs, 26 updates, 0 removals - Updating twig/twig (v2.12.1 => v2.12.2) - Updating symfony/symfony (v3.4.33 => v3.4.34) - Updating doctrine/event-manager (v1.0.0 => 1.1.0) - Updating doctrine/collections (v1.6.2 => 1.6.3) - Updating doctrine/cache (v1.8.1 => 1.9.0) - Updating doctrine/persistence (1.1.1 => 1.2.0) - Updating doctrine/inflector (v1.3.0 => 1.3.1) - Updating symfony/mime (v4.3.5 => v4.3.7) - Updating swiftmailer/swiftmailer (v6.2.1 => v6.2.3) - Updating symfony/swiftmailer-bundle (v3.3.0 => v3.3.1) - Updating doctrine/dbal (v2.9.2 => v2.9.3) - Updating doctrine/instantiator (1.2.0 => 1.3.0) - Updating j0k3r/graby-site-config (1.0.93 => 1.0.94) - Updating phpoption/phpoption (1.5.0 => 1.5.2) - Updating symfony/http-client-contracts (v1.1.7 => v1.1.8) - Updating symfony/http-client (v4.3.5 => v4.3.7) - Updating sensiolabs/security-checker (v6.0.2 => v6.0.3) - Updating paragonie/constant_time_encoding (v2.2.3 => v2.3.0) - Updating scheb/two-factor-bundle (v4.7.1 => v4.8.0) - Updating symfony/phpunit-bridge (v4.3.6 => v4.3.7) - Updating composer/xdebug-handler (1.3.3 => 1.4.0) - Updating friendsofphp/php-cs-fixer (v2.15.3 => v2.16.0) - Updating doctrine/data-fixtures (v1.3.2 => 1.3.3) - Updating nette/schema (v1.0.0 => v1.0.1) - Updating nikic/php-parser (v4.2.4 => v4.3.0) - Updating sentry/sentry (2.2.2 => 2.2.4)
* Rename internal settings tableJeremy Benoist2019-08-081-0/+42
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | In fact it's not _just_ a rename. We are now able to use our own entity with the CraueConfigBundle which allow us to enforce a custom length on string field and avoid error with utf8mb4 on MySQL. To fix that issue before we were in need to fork CraueConfigBundle to hard apply these length changes. The recent 2.3.0 release fix that issue. That's why we are in need to rename the table (getting rid of the bundle name from it) Also updating deps: - Updating symfony/polyfill-mbstring (v1.11.0 => v1.12.0) - Updating symfony/polyfill-ctype (v1.11.0 => v1.12.0) - Updating symfony/polyfill-php70 (v1.11.0 => v1.12.0) - Updating symfony/polyfill-util (v1.11.0 => v1.12.0) - Updating symfony/polyfill-php56 (v1.11.0 => v1.12.0) - Updating symfony/polyfill-intl-icu (v1.11.0 => v1.12.0) - Updating symfony/polyfill-apcu (v1.11.0 => v1.12.0) - Updating j0k3r/graby-site-config (1.0.88 => 1.0.89) - Updating php-http/message (1.7.2 => 1.8.0) - Updating symfony/polyfill-php73 (v1.11.0 => v1.12.0) - Updating symfony/http-client (v4.3.2 => v4.3.3) - Updating symfony/polyfill-php72 (v1.11.0 => v1.12.0) - Updating symfony/polyfill-intl-idn (v1.11.0 => v1.12.0) - Updating symfony/mime (v4.3.2 => v4.3.3) - Updating craue/config-bundle (dev-utf8mb4 46cfd37 => 2.3.0) - Updating masterminds/html5 (2.6.0 => 2.7.0) - Updating nette/di (v3.0.0 => v3.0.1) - Updating symfony/polyfill-iconv (v1.11.0 => v1.12.0) - Updating wallabag/php-mobi (1.0.1 => 1.1.0)
* CSJeremy Benoist2019-08-081-1/+1
|
* Add `tag_label` & `config_feed_token` indexJeremy Benoist2019-08-081-1/+19
|
* Add user_created indexOlivier Mehani2019-08-071-0/+6
| | | | Signed-off-by: Olivier Mehani <shtrom@ssji.net>
* Add user_archived indexOlivier Mehani2019-08-071-0/+6
| | | | Signed-off-by: Olivier Mehani <shtrom@ssji.net>
* Fix PG migrationJeremy Benoist2019-08-071-2/+2
|
* Fix migrationsJeremy Benoist2019-08-072-32/+72
|
* Add index on starred entriesOlivier Mehani2019-08-061-0/+22
| | | | | | Fixes #4079 Signed-off-by: Olivier Mehani <shtrom@ssji.net>
* Update language in Entry model, and add indexOlivier Mehani2019-08-061-0/+24
| | | | | | Fixes #4080 Signed-off-by: Olivier Mehani <shtrom@ssji.net>
* Add ability to manually define the reading speedJeremy Benoist2019-07-081-0/+22
| | | | Instead of using a select, let the user decide its own speed.
* Fix hardcoded `wallabag_` prefix in migrationJeremy Benoist2019-07-013-14/+16
| | | | | Again. Looks like there are still some which were missing to be replaced.
* Merge pull request #4020 from wallabag/fix/sqlite-reading-time-nullJérémy Benoist2019-06-241-0/+65
|\ | | | | Fix `reading_time` being NULL on SQLite
| * Use `skipIf` instead of `abortIf`Jeremy Benoist2019-06-211-2/+2
| | | | | | | | This is to avoid migration using an other SGBD to break.
| * Fix `reading_time` being NULL on SQLiteJeremy Benoist2019-06-201-0/+65
| |
* | Fix PG migrationJeremy Benoist2019-06-191-4/+4
| |
* | Fix migration with prefix table nameJeremy Benoist2019-06-181-12/+12
|/ | | | | Looks like we missed one `wallabag_user` in migration. It can work for most people but if someone use a different prefix, it'll break.
* Merge pull request #3959 from wallabag/mig-tag-collationJérémy Benoist2019-06-061-0/+30
|\ | | | | mysql: change collation of tag label
| * mysql: change collation of tag tableKevin Decherf2019-05-191-0/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | utf8mb4_unicode_ci considers that 'caché' is equal to 'cache' which can lead to attaching incorrect tags to entries. This issue is due to some unicode normalization done by MySQL. utf8mb4_bin makes no unicode normalization, letting wallabag to consider 'cache' and 'caché' as two different tags. We change the collation of the whole table as Doctrine does not support setting a collation on a column for a specific platform (it tries to apply utf8mb4_bin even for pgsql and sqlite). Fixes #3302 Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* | Use two indexes instead of one for hashed urlsJeremy Benoist2019-06-051-23/+3
| | | | | | | | | | When using `OR` in a where clause, a composite index can't be used. We should use a `UNION` to take advantages of it. Instead, create 2 indexes on each hashed urls and make 2 queries to find an url. It'll be faster than the previous solution.
* | Use hash given url to avoid duplicateJeremy Benoist2019-05-293-86/+74
| | | | | | | | Using hashed url we can ensure an index on them to ensure it's fast.
* | Added given_url in entry tableNicolas Lœuillet2019-05-292-0/+86
| | | | | | | | | | | | | | | | | | | | - Added index on entry table for given_url field - Fix tests: The previous `bit.ly` url redirected to doc.wallabag but that url doesn't exist in the fixtures. I used our own internal "redirector" to create a redirect to an url which exist in the fixtures. Also, updating current migration to use the new `WallabagMigration`.
* | Fix SQLite constraintJeremy Benoist2019-05-101-3/+3
| |
* | Fix SQLite migrationJeremy Benoist2019-05-101-16/+17
| |
* | Cascade delete on oauth2 table when deleting a userJeremy Benoist2019-05-101-0/+95
|/
* Fix tests & cs & migrationJeremy Benoist2019-04-261-0/+58
|
* Fix index on MySQLJeremy Benoist2019-04-011-1/+1
|
* Some cleanupJeremy Benoist2019-04-011-5/+0
| | | | Also, do not run the hashed_url migration into a Doctrine migration
* Use a better index for hashed_urlJeremy Benoist2019-04-011-1/+4
| | | | | | It'll most often be used in addition to the `user_id`. Also, automatically generate the hash when saving the url. Switch from `md5` to `sha1`.
* Keep url in exists endpointJeremy Benoist2019-04-011-0/+44
| | | | | | - Add migration - Use md5 instead of sha512 (we don't need security here, just a hash) - Update tests
* Disable down for that migrationJeremy Benoist2019-03-011-6/+1
|
* Test each internal settings before creating themJeremy Benoist2019-03-011-41/+119
|
* Add missing entries in craue_config_setting.Nadrieril2019-03-011-0/+74
| | | | Should fix https://github.com/wallabag/wallabag/issues/3662
* Add SQLite & PG migrationJeremy Benoist2019-01-231-5/+41
| | | | | Also remove the forced `server_version` from dbal config to avoid an hard overriding across all database.
* Add backup codesJeremy Benoist2019-01-231-2/+20
|
* Enable OTP 2FAJeremy Benoist2019-01-231-0/+22
| | | | | | | | | - Update SchebTwoFactorBundle to version 3 - Enable Google 2fa on the bundle - Disallow ability to use both email and google as 2fa - Update Ocramius Proxy Manager to handle typed function & attributes (from PHP 7) - use `$this->addFlash` shortcut instead of `$this->get('session')->getFlashBag()->add` - update admin to be able to create/reset the 2fa
* Enable PHPStanJeremy Benoist2019-01-181-0/+32
| | | | | - Fix error for level 0 & 1 (level 7 has 699 errors...) - Add `updated_at` to site_credential (so the `timestamps()` method applies correctly)
* Fix utf8mb4 on vendor tablesJeremy Benoist2018-11-282-19/+47
| | | | | | | | | | | | | | When creating the schema for test these tables use default length for string: 255. Which fail when using utf8mb4. > Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes Also move the `setKeepStaticConnections` in before and after class to avoid: > SAVEPOINT DOCTRINE2_SAVEPOINT_2 does not exist See https://github.com/dmaicher/doctrine-test-bundle#troubleshooting
* Entry: add archived_at property and updateArchived methodSébastien Viande2018-09-211-0/+68
|
* php-cs-fixerKevin Decherf2018-09-051-1/+1
| | | | Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* We should able to get the table name unescapedJeremy Benoist2018-06-141-4/+4
| | | | When we want to perform complex queries to retrieve metadata from the database
* Fixed migrations with dash into db nameJeremy Benoist2018-06-1436-705/+93
|
* Merge pull request #3504 from aaa2000/fix-initial-migration-with-table-prefixJérémy Benoist2017-12-161-125/+125
|\ | | | | Fix initial migration when using custom table prefix
| * Use getTable() to retrieve prefixed table nameJeremy Benoist2017-12-161-126/+122
| |
| * Fix initial migration when using custom table prefixadev2017-12-141-125/+129
| | | | | | | | Fix #3503
* | Fixed lower case tags migrationNicolas Lœuillet2017-12-151-1/+1
|/
* CSJeremy Benoist2017-12-121-1/+0
|
* Use hasTable instead of try/catchJeremy Benoist2017-12-121-7/+1
|
* Change the way to check for initial migrationJeremy Benoist2017-12-121-4/+25
|
* migrations: fix duplicate violation during lowercase tag migrationKevin Decherf2017-12-101-8/+20
| | | | Signed-off-by: Kevin Decherf <kevin@kdecherf.com>