aboutsummaryrefslogtreecommitdiffhomepage
path: root/app/DoctrineMigrations
Commit message (Collapse)AuthorAgeFilesLines
* 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>
* Replace raw query with named parameterKevin Decherf2017-12-101-2/+3
| | | | | | Fix possible issue with special chars on #3139 Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* Add craue setting to enable sharing of origin url to ShaarliKevin Decherf2017-11-251-0/+52
| | | | | | | Also fix the field name used in the query string and add it to baggy theme Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* Fix phpcsadev2017-11-211-5/+4
|
* Implements down migrationadev2017-11-211-1/+12
|
* Fix installation commandadev2017-11-212-3/+32
|
* Add an initial migrationadev2017-11-211-0/+181
|
* Merge pull request #3425 from wallabag/add-setting-for-headersNicolas Lœuillet2017-11-211-0/+52
|\ | | | | Added internal setting to enable/disable headers storage
| * Added internal setting to enable/disable headers storageNicolas Lœuillet2017-11-201-0/+52
| |
* | Fix MySQL issue on mig from #3373Kevin Decherf2017-11-201-0/+1
| | | | | | | | Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* | Fix phpcsKevin Decherf2017-11-191-1/+1
| | | | | | | | Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* | Add originUrl property to Entry, handle that in EntryRestController, handle ↵Kevin Decherf2017-11-191-0/+55
|/ | | | | | migration Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
* Fixed @Kdecherf's reviewNicolas Lœuillet2017-10-131-0/+1
|