upstream/icingadb
1
0
Fork 0
mirror of https://github.com/Icinga/icingadb.git synced 2026-05-28 04:35:54 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions 1
1971 commits 29 branches 11 tags 14 MiB
Commit graph

80 commits

Author SHA1 Message Date
Julian Brost
682e3cb496
Merge pull request #215 from Icinga/add-missing-customvar-indices 
Add missing indices to *_customvar tables
 2021-10-13 16:13:29 +02:00
Ravi Kumar Kempapura Srinivasa
bab2d80ada Add foreign key with cascade delete constraints to history tables 
Earlier we did not have any foreign keys for history table. But when we delete a record from the parent
history table the corresponding records in their child tables must also be deleted. This is done with the
introduction of foreign key constraints with on cascade delete.
 2021-10-05 18:35:02 +02:00
Julian Brost
7c782e3eb8 History sync: use information from notification stream for user_notification_history table 2021-10-05 18:35:02 +02:00
Johannes Meyer
830dc20976 mysql.schema.sql: Add missing indices to *_customvar tables 2021-10-05 15:03:58 +02:00
Alexander A. Klimov
d8b3f75778 Schema: s/mediumtext/longtext/ 
... to make MySQL storage capabilities of likely large text columns
more similar (16MB -> 4GB) to (upcoming) Postgres ones (unlimited)
and not to have to pre-truncate anything.

refs #260
 2021-09-28 11:13:51 +02:00
Alexander A. Klimov
82d8f830af Include CheckResult#scheduling_source in state and history 
refs #160
 2021-09-22 17:30:13 +02:00
Julian Brost
af61846114
Merge pull request #344 from Icinga/feature/downtime-column-comments 
Schema: Add description to downtime columns 'triggered_by_id' and 'parent_id'
 2021-09-03 16:20:59 +02:00
Noah Hilverling
b9ec99185a Schema: Add description to downtime columns 'triggered_by_id' and 'parent_id' 2021-08-12 14:41:15 +02:00
Alexander A. Klimov
825dcbc817 Introduce downtime#scheduled_by 2021-08-09 20:12:10 +02:00
Eric Lippmann
783b3a6bfe
Merge pull request #323 from Icinga/feature/downtime-parent-downtime-id 
Downtime: Add parent_id
 2021-08-09 13:43:16 +02:00
Eric Lippmann
7e237c6aef
Merge pull request #329 from Icinga/schema-mode 
Use SET SESSION for schema modes
 2021-08-09 10:29:10 +02:00
Alexander A. Klimov
9fdf40bd88 Enlarge {comment,downtime}#name 255 -> 548 
I.e. large enough for "HOST!SERVICE!UUID".

refs #273
 2021-08-05 16:36:27 +02:00
Eric Lippmann
77c2365e6f Use SET SESSION for schema modes 
As of version 8, MySQL is stricter when it comes to setting system
and session variables and requires that the user importing our schema
be granted the SESSION_VARIABLES_ADMIN permission. Although the session
scope is already the default, we will now use SET SESSION for the modes
in our scheme for the sake of clarity.
 2021-08-05 09:49:53 +02:00
Alexander A. Klimov
1617a661d3 Clarify why acknowledgement_history#comment is NULLable 
refs #305
 2021-08-04 14:19:02 +02:00
Alexander A. Klimov
194c84ad3b Allow acknowledgement_history#{author,is_sticky,is_persistent} being NULL 
... for the case an ack_set event happened before Icinga DB history recording.

refs #305
 2021-08-04 12:21:16 +02:00
Alexander A. Klimov
7346edb836 Icinga DB: introduce Checkable#last_comment_id 2021-07-26 18:10:28 +02:00
Noah Hilverling
9f6c73ca56 Downtime: Add parent_id 2021-07-23 13:54:39 +02:00
Alexander A. Klimov
9bf1512e06 Introduce *_state#normalized_performance_data 2021-07-07 19:02:55 +02:00
Ravi Kumar Kempapura Srinivasa
6079665de9 output, long_output and performance_data columns modified to mediumtext 
mediumtext is a tradeoff between text and longtext; text being too short and longtext being too big.
 2021-06-24 13:49:26 +02:00
Eric Lippmann
bd577e583b
Merge pull request #269 from Icinga/bugfix/mysql-schema-bool-enums 
MySQL schema: reverse order of entries in enums for boolean to fix sort order
 2021-06-17 12:03:14 +02:00
Johannes Meyer
df4112d88a schema: Re-add indices for host_id and service_id in state tables 2021-06-01 15:28:06 +02:00
Eric Lippmann
8ae9c7b461 Schema: Reverse order of entries in enums for boolean 
This takes into account the changes made with f7cbc22.
 2021-05-31 14:42:49 +02:00
Julian Brost
f7cbc22299 MySQL schema: reverse order of entries in enums for boolean to fix sort order 
This ensures that 'n' < 'y' when sorting, as you'd expect when either comparing
the alphabetical order of both values or the corresponding 0/1 values for a
boolean.
 2021-05-31 14:35:30 +02:00
Johannes Meyer
62582d58ac Move schema/1.0.0-rc2.sql to schema/mysql/upgrades/1.0.0-rc2.sql 2021-05-31 14:05:15 +02:00
Johannes Meyer
53f6839ee2 Move schema/mysql.schema.sql to schema/mysql/schema.sql 2021-05-31 14:05:15 +02:00
Julian Brost
6cc2cd01b2 Increment icingadb_schema version 2021-05-28 17:11:54 +02:00
Julian Brost
228b149293 1.0.0-rc2.sql: add all changes since v1.0.0-rc1 git tag 2021-05-28 17:11:03 +02:00
Julian Brost
445ce238f9 mysql.schema.sql: integrate changes from 1.0.0-rc2.sql 2021-05-28 16:20:37 +02:00
Eric Lippmann
3f26374eac Move mysql.schema.sql 2021-05-25 23:32:19 +02:00
Noah Hilverling
3b3c02bc36 Schema (Host-/ServiceState): Add columns id and properties_checksum 2021-05-04 09:55:43 +02:00