39 Commits

Author	SHA1	Message	Date
Jan Eitzinger	17906ec0eb	Add down migrations for documentation	2024-11-21 15:54:46 +01:00
Jan Eitzinger	35bd7739c6	fix: Replace reserved keywords in database schemas ... Port migration to mariadb	2024-11-21 15:02:30 +01:00
Christoph Kluge	37f4ed7770	add additional indices for sorting performance	2024-10-09 17:52:46 +02:00
Christoph Kluge	582dc8bf46	add energy column index	2024-09-30 18:29:46 +02:00
Christoph Kluge	6367c1ab4d	Merge branch 'dev' into 275_tag_scope_jobview_rework	2024-09-17 14:32:06 +02:00
Christoph Kluge	d5382aec4f	Merge branch 'dev' into 275_add_tag_scope	2024-09-05 16:44:41 +02:00
Christoph Kluge	7ea4086807	Rework sqlite indices in v8 migration	2024-09-05 15:06:38 +02:00
Christoph Kluge	cff60eb51c	increase server timeout limit, improve and add db indices ... - change energy footprint key to string	2024-08-27 17:43:48 +02:00
Christoph Kluge	31765ce0ef	Merge branch 'dev' into 275_add_tag_scope	2024-08-23 14:52:42 +02:00
Jan Eitzinger	a8a27c9b51	Add project index to job table	2024-08-19 12:11:53 +02:00
Jan Eitzinger	5e074dad10	Resolve error in migration	2024-08-15 12:39:14 +02:00
Jan Eitzinger	5c99f5f8bb	Only add footprint columns if not 0	2024-08-15 12:35:11 +02:00
Jan Eitzinger	ba2f406bc0	Extend sqlite db migration	2024-08-15 09:41:54 +02:00
Christoph Kluge	9b5c6e3164	fix StartJobTest, add tag_scope to migration	2024-08-05 10:37:42 +02:00
Christoph Kluge	e14d6a81fe	fix: fix db migration to v8, changes key name to cpu_load	2024-07-11 17:24:33 +02:00
Jan Eitzinger	97c807cd33	Add migration for footprint	2024-06-28 16:49:24 +02:00
Michael Schwarz	ce792426e6	Disable foreign key check while updating database	2024-03-14 09:15:15 +01:00
Jan Eitzinger	105b7eabf0	Add migration and introduce dirty flag handling	2024-03-08 10:47:32 +01:00
Jan Eitzinger	dd887cbb1f	Do all tag queries with query builder ... Fix bug in mysql database initialization. Fixes #231	2024-03-06 13:47:52 +01:00
Jan Eitzinger	b5a7249ad5	Fix sqlite migration for configuration	2023-06-30 09:15:58 +02:00
Jan Eitzinger	dd80d5af9e	Change config value datatype ... Fixes #167	2023-06-29 14:55:38 +02:00
Jan Eitzinger	eb626db9c2	Debug compression service	2023-06-27 14:29:56 +02:00
Jan Eitzinger	d1e3e06b10	Add insert timestamp to tag, jobtag ... Fixes #43	2023-06-27 09:41:06 +02:00
Michael Schwarz	a183c23e25	Fix truncate call on mysql and provide step 4 migrations for mysql	2023-06-07 16:49:08 +02:00
Michael Schwarz	df240c2394	Fix database migration order	2023-06-07 11:45:58 +02:00
Jan Eitzinger	e444b83149	Fix errors	2023-06-05 16:07:01 +02:00
Jan Eitzinger	5ca4bdbd91	Remove VACUUM	2023-06-05 16:01:14 +02:00
Jan Eitzinger	8b6a1c8045	Add migration for job table contraints	2023-06-05 15:58:07 +02:00
Jan Eitzinger	2de85b0120	Add composite indexes	2023-06-01 15:40:37 +02:00
Jan Eitzinger	7491ae9e3c	Fix typo in DB schema	2023-05-04 17:26:33 +02:00
Jan Eitzinger	5404be3ca7	Add unique constrain on job table	2023-05-04 16:04:57 +02:00
Jan Eitzinger	500ae29d25	Synchronize DB Schema with json schema ... Rework tests	2023-04-21 12:59:27 +02:00
Christoph Kluge	8bd72ce807	Small fixes after full file review ... - Remove unnecessary field 'project' from GQl and regenerate - Add newlines to file ends - Fix command-line manager user addition	2023-02-23 12:33:14 +01:00
Christoph Kluge	d0d578a1e6	Fix user.projects up migration file	2023-02-22 10:17:40 +01:00
Christoph Kluge	822c8b570c	Remove exists checks from sql migrations to v3	2023-02-21 18:05:29 +01:00
Christoph Kluge	acbef39045	Fix header, add migration for user.projects column	2023-02-21 17:33:27 +01:00
Jan Eitzinger	63f8555af7	Add migration support for mysql	2023-02-21 14:45:59 +01:00
Jan Eitzinger	a4f5b139f9	Remove hardcoded index generation	2023-02-21 11:36:23 +01:00
Jan Eitzinger	8ffb562d6b	Introduce db migration support	2023-02-21 10:57:22 +01:00