Jan Böhmer
|
27a28d4adc
|
Fixed the NatSortKey function where regex characters were improperly escaped in the old migration
This caused a "range out of order in character class" error and propably affected the functionality of the sort function
|
2024-07-28 17:08:55 +02:00 |
|
Jan Böhmer
|
4946a9ab0d
|
Fixed SQL declaration of NatSortKey function
We do not need the delimiter declarations
|
2024-06-18 22:32:07 +02:00 |
|
Jan Böhmer
|
123372d93f
|
Allow to emulate natural sort on mysql platforms
|
2024-06-18 21:42:00 +02:00 |
|
Jan Böhmer
|
0a482da93e
|
Use postgres native array_position function instead of our FIELD function and pass it as array literal instead of variadic function
Otherwise we will run into errors, that we can not give more than 100 arguments to a function
|
2024-06-17 23:13:04 +02:00 |
|
Jan Böhmer
|
8bb8118d9f
|
Use natural sorting for trees and others repository functions
|
2024-06-17 22:33:40 +02:00 |
|
Jan Böhmer
|
9db822eabd
|
Use natural sorting for string datatables columns when using postgres
The natural sorting solution is quite portable, so this should be possible for other database types too later
|
2024-06-17 21:38:16 +02:00 |
|
Jan Böhmer
|
4f75e2641b
|
Define a custom FIELD function to sort tables by list of ids without the emulation via string operations
|
2024-06-16 23:46:40 +02:00 |
|
Jan Böhmer
|
eab1c7096c
|
Use the postgres migration code generated by the new doctrine orm versions
This now uses IDENTITY columns for ID columns, which makes their behavior more similar to the behavior of MySQL and SQLite
|
2024-06-10 22:38:46 +02:00 |
|
Jan Böhmer
|
8ee3aaf4f4
|
Added Sqlite migrations required by new doctrine/orm version and fixed migration duplication for sqlite
|
2024-06-10 21:54:15 +02:00 |
|
Jan Böhmer
|
427b8659c9
|
Added MySQL migrations required by the doctrine upgrades
The new ORM versions, do not have anymore column comments, so these got removed
|
2024-06-10 21:43:25 +02:00 |
|
Jan Böhmer
|
a88a2e04cf
|
Added the required initial users and groups for the database migration
|
2024-06-09 00:11:58 +02:00 |
|
Jan Böhmer
|
02acafc348
|
Added postgres to the AbstractMultiPlatformMigration class
|
2024-06-06 23:11:11 +02:00 |
|