mirror/Part-DB.Part-DB-server
1
0
Fork 1
mirror of https://github.com/Part-DB/Part-DB-server.git synced 2025-06-21 01:25:55 +02:00
Code Issues Projects Releases Packages Wiki Activity Actions
4051 commits 6 branches 60 tags 68 MiB
Commit graph

106 commits

Author SHA1 Message Date
Jan Böhmer
7eee3de965 Added fixing migrations for sqlite 2023-04-09 00:07:23 +02:00
Jan Böhmer
0c6245fe8e Removed unused migration 2023-04-09 00:04:56 +02:00
Jan Böhmer
342ed382e3 Properly mark the tinyint column with a comment, so that migrations can properly detect that no changes are needed 2023-04-09 00:04:13 +02:00
Jan Böhmer
aaf6c37871 Fixed some minor issues in database schema of MySQL 2023-04-08 23:49:47 +02:00
Jan Böhmer
65e1346a11 Improved output of some messages during migration 2023-04-08 23:39:45 +02:00
Jan Böhmer
036eaf3bae Removed warnings about changed permissions, as the old changes are reset later, and we now do the permission migration in Part-DB directly 2023-04-08 23:29:23 +02:00
Jan Böhmer
2717d7d311 Only drop the foreign keys during migration from legacy Part-DB DBs if they really exist 
This should fix issue #260
 2023-04-08 23:27:10 +02:00
Jan Böhmer
5b5e8a4fd5 Allow users (and admins) to decide whether their email should be shown on their public profile 2023-04-08 19:53:05 +02:00
Jan Böhmer
71b0c2d83e Properly quote users table for compatibility with newer MySQL databases 2023-04-08 19:51:29 +02:00
Jan Böhmer
749e7dbdf9 Rempve default value definitions, which cause problems on MySQL 8 2023-04-03 01:03:16 +02:00
Jan Böhmer
64199b91d5 Synchronized MySQL schema with entity definitions 2023-04-03 00:53:58 +02:00
Jan Böhmer
c8218f6891 Added an explicit type for an old migration, so that (new) sqlite databases do not have a phase where a field has no type 2023-04-03 00:49:24 +02:00
Jan Böhmer
8e2f297839 Added migrations for sqlite 2023-04-03 00:47:51 +02:00
Jan Böhmer
047c82791b Added basic fields and migration for MySQL 2023-04-02 19:10:36 +02:00
Jan Böhmer
97c3b9002a Mark SAML users as so in database and disable local password changing then. 2023-02-21 00:29:50 +01:00
Jan Böhmer
f9d5a9a3b5 Fixed problem with failing foreign key constraints on preview pic (2/2) 2023-02-20 00:09:23 +01:00
Jan Böhmer
82aec6f1ee Fixed problem with failing foreign key constraints on preview pic (1/2) 2023-02-20 00:06:00 +01:00
Jan Böhmer
29bce6f19f Use permissions presets as initial settings for group permissions during migration 2023-01-23 21:46:24 +01:00
Jan Böhmer
eddf956f63 Do not use RENAME INDEX as it is not supported in older MariaDB versions 2023-01-08 23:57:00 +01:00
Jan Böhmer
011bda3600 Rename indices instead of dropping and creating them again 
This should hopefully fix the failing migration on test action.
 2023-01-08 22:05:06 +01:00
Jan Böhmer
897ea72bd0 Removed DEFAULT value for description on projects table as thats not supported on older MySQL version 2023-01-08 19:19:40 +01:00
Jan Böhmer
e423ef1e09 Only drop the legacy foreign key if migrated from legacy DB. 2023-01-08 18:57:56 +01:00
Jan Böhmer
e679317b4b Added project system database schema for SQLite 2023-01-08 18:17:52 +01:00
Jan Böhmer
79db46b8e6 Renamed devices table to projects to have the same name as the entities. 2023-01-08 18:01:56 +01:00
Jan Böhmer
0e020dab74 Added an price field to allow defining the price of non-part BOM entries 2022-12-31 18:57:36 +01:00
Jan Böhmer
adc070d10c Added possibility to set project status 2022-12-29 15:22:34 +01:00
Jan Böhmer
b83b55b8d4 Added some constraints and validations to the BOM entries. 2022-12-26 13:57:11 +01:00
Jan Böhmer
0c7ec9f0c7 Added some basic DB fields for the new project system 2022-12-18 20:34:25 +01:00
Jan Böhmer
a0f934169c Allow to delete users while keeping log entries. 2022-12-17 00:25:54 +01:00
Jan Böhmer
e00ca9b4a9 Added IPN migration for SQLite 
This should fix issue #167
 2022-12-05 22:33:58 +01:00
Jan Böhmer
b1d359f538 Added internal part number field to parts 2022-12-04 02:28:47 +01:00
Jan Böhmer
984fc9be14 Escape users and groups table name in migration as these are reserved words in MySQL 8 
Should fix issue #194.
 2022-11-28 13:54:50 +01:00
Jan Böhmer
414c417b69 Added link to announcement where you can get more infos about upgrading permission system. 2022-11-27 23:10:15 +01:00
Jan Böhmer
c153502b3f Removed default value for MySQL permission column as it causes problems on older MySQL servers 2022-11-27 21:33:13 +01:00
Jan Böhmer
1c12174cd9 Fixed new permission migration for SQLite 2022-11-14 23:21:49 +01:00
Jan Böhmer
aabe3876a7 Improved migrations for MySQL 2022-11-14 23:12:18 +01:00
Jan Böhmer
10a035fcea Reset the permissions of the admin user. 2022-10-31 21:54:46 +01:00
Jan Böhmer
59ddf91527 Make PermissionData an embeddable so doctrine can properly track changes to the data array 2022-10-31 21:12:01 +01:00
Jan Böhmer
27bf7c3be9 Merge branch 'webauthn_tfa' 2022-10-05 22:41:39 +02:00
Jan Böhmer
720903c46a Added webauthn key migrations for sqlite 2022-10-05 22:11:28 +02:00
Jan Böhmer
ac978abe1d Allow to register Webauthn Keys 2022-10-04 00:08:58 +02:00
Jan Böhmer
a8766a85b0
Fixed migration error on MySQL 8 
Upwards from MySQL 8.0.2 groups is an reserved keyword and the table names need to be escaped.
 2022-09-26 15:04:35 +02:00
Jan Böhmer
03aaff3c79 Fixed migration error, when we did not migrated from an legacy Part-DB version 2022-09-25 21:22:37 +02:00
Jan Böhmer
8dcfbe3c91 Added currency table to row_format migration which were missing before. 2022-09-25 19:48:24 +02:00
Jan Böhmer
cebf244e0a Normalize table character sets as old Part-DB version produced different encoding 2022-09-25 19:35:33 +02:00
Jan Böhmer
79877c787e Change row format of tables before creating indices 
This is nee
 2022-09-25 19:29:03 +02:00
Jan Böhmer
40f0d00e37 Add database indices to improve peformance (part 3) 2022-09-25 18:51:18 +02:00
Jan Böhmer
ccc99eba0c Add database indices to improve performance (SQLITE) 2022-09-25 18:48:16 +02:00
Jan Böhmer
ed91ffc60a Add database indices to improve performance 2022-09-25 18:33:13 +02:00
Jan Böhmer
8e6300079a Fixed some migration issues, when migrating from old Part-DB versions 
Fixes issue #170, #67
 2022-09-17 18:43:08 +02:00