Commit graph

136 commits

Author SHA1 Message Date
Thomas Gelf
44c156041a schema: add PostgreSQL, small fixes for MySQL
refs #132
2017-09-28 11:02:13 +02:00
Thomas Gelf
cd2ed5cfae schema, IcingaTemplateChoice: add columns for...
...upcoming features
2017-09-27 20:41:41 +02:00
Markus Frosch
4ab59ea1e3 Update foreign key constraint for import_source under PostgreSQL
So that import_runs will be deleted with the import_source.

fixes #1141
2017-08-30 16:40:12 +02:00
Thomas Gelf
fc9d40ceff schema: fix object_type for eventually erraneous
...service_set templates
2017-08-28 06:54:20 +02:00
Thomas Gelf
69607ada3c SyncRule: switch priority order, migrate DB
fixes #1077
2017-08-22 17:10:49 +02:00
Thomas Gelf
7c18c0b614 schema: unique constraint for import_row_modifier
...priority. Also align current priority to id to get as close as possible
to current fetch order.
2017-08-20 16:01:46 +02:00
Thomas Gelf
9542c74404 schema: forgot to raise version 2017-07-20 09:55:32 +02:00
Thomas Gelf
95769c3ee2 Modifier: add a description field
fixes #465
2017-07-14 14:45:25 +02:00
Thomas Gelf
2cdba2aa65 Import and Sync: add description fields
fixes #1018
2017-07-14 14:27:05 +02:00
Thomas Gelf
aea69c42bc schema: fix PostgreSQL data type 2017-07-14 13:21:42 +02:00
Thomas Gelf
05d8e5bb00 Datalist: Allow to restrict entries by role
fixes #1012
2017-07-14 13:21:42 +02:00
Thomas Gelf
4a0e8df2f2 Host,Service: add check_timeout property
fixes #546
2017-07-14 13:21:42 +02:00
Thomas Gelf
303b8776a2 schema: relax choice constraint for delete 2017-07-14 13:21:42 +02:00
Thomas Gelf
69579bcaf9 schema/pgsql: add choices 2017-07-14 13:21:42 +02:00
Thomas Gelf
46a9b2574b schema: add resolved hostgroup member tables
refs #832
2017-07-14 13:21:42 +02:00
Thomas Gelf
379e5d12ae schema: add index on activity log author
fixes #687
2017-01-18 13:29:13 +01:00
Thomas Gelf
07b6090c31 schema: add variable cache/lookup tables
refs #13068
2016-12-15 19:45:22 +01:00
Thomas Gelf
4f8f79557b schema: provide migration for conditional fields
fixes #13253
2016-12-14 17:41:15 +01:00
Thomas Gelf
d2bd133d51 schema: allow to delete service sets...
...containing services and also hosts using service sets without requiring one
to manually remove all assigned sets first

fixes #13531
2016-12-14 15:29:44 +01:00
Markus Frosch
64284ee96a Add schema migration for ServiceSet foreign keys
This will clean up dangling service_set for non-existing host and service for service_set

refs #13309
2016-11-28 16:46:47 +01:00
Thomas Gelf
92bb24b414 schema: add cnt_apply column 2016-11-03 13:25:32 +01:00
Thomas Gelf
3f7a184d2f schema: get rid of service_set_service, introduce
...a service_set_id column directly on the service
2016-10-25 23:12:23 +00:00
Thomas Gelf
47cd8cdc89 schema: add assign_type migrations for pgsql...
...and complete them for mysql
2016-10-25 02:00:50 +00:00
Geneviève Plantin
b2bdeac360 Change version of DB 2016-10-22 06:08:24 +00:00
Geneviève Plantin
0fe47f9919 Add apply_for migrations in schema 2016-10-22 06:08:10 +00:00
Thomas Gelf
cf4dccc817 Notification: add fields support
fixes #12642
2016-10-13 14:34:25 +00:00
Thomas Gelf
d7a53ac19f schema: add more sync object types
fixes #11361
2016-10-12 08:50:58 +00:00
Thomas Gelf
63fca7143c schema: add icinga_service_set_inheritance...
...and fix NULL constraints
2016-10-12 08:07:51 +00:00
Thomas Gelf
1a03cea5d7 schema: add service set tables 2016-10-12 07:03:51 +00:00
Thomas Gelf
f60f35bd1f schema/pgsql: fix forgotten column configs
thanks @greatexpectations!

fixes #12863
2016-10-06 17:46:14 +00:00
Thomas Gelf
989ac534ab schema/pgsql: allow to delete import sources...
...with history import runs

fixes #11972
2016-09-23 17:36:34 +00:00
Thomas Gelf
0e133daa8b schema: fix legacy booleans stored as strings
fixes #12526
2016-09-23 16:22:35 +00:00
Markus Frosch
a90595a004 IcingaHostGroup: Add apply statements 2016-09-09 08:32:42 +00:00
Markus Frosch
421c154e08 schema: ensure last_error_message is stored as TEXT 2016-09-09 06:41:00 +00:00
Thomas Gelf
1afdf66c07 schema/pgsql: allow to delete sync rules
fixes #11973
2016-09-08 23:42:30 +00:00
Thomas Gelf
b47c7be3d5 IcingaService: add use_var_overrides 2016-09-08 15:01:19 +00:00
Thomas Gelf
13ed701436 schema: migrations for range properties 2016-08-31 16:24:40 +00:00
Thomas Gelf
fbf4400ad2 schema: command argument_name should not be null
fixes #11554
fixes #11918
2016-08-26 07:02:15 +00:00
Thomas Gelf
eab8b5c9ba schema: shorten history large deployment logs...
...and free related disk space
2016-07-26 13:50:42 +02:00
Thomas Gelf
439757d464 IcingaHost: introduce API keys 2016-07-26 09:52:55 +02:00
Thomas Gelf
634d9e07b6 schema: raise schema versions for new installations
Forgot to commit & push migration 99, sorry :p
2016-07-22 18:11:47 +02:00
Thomas Gelf
8d2f546a2e schema: provide target_property for modifiers
refs #11949
2016-07-20 13:15:05 +02:00
Thomas Gelf
0605c5acc8 schema/pgsql: add unix_timestamp function 2016-05-21 00:59:16 +02:00
Thomas Gelf
804245a35a schema/pgsql: add timeperiod support for jobs 2016-05-21 00:25:38 +02:00
Thomas Gelf
b2f202079e schema/pgsql: apply_to for notifications 2016-05-21 00:15:27 +02:00
Thomas Gelf
8fe1bda36e schema/pgsql: add state columns for import sources 2016-05-21 00:11:01 +02:00
Thomas Gelf
b40e1af5e8 schema/pgsql: add job tables 2016-05-20 23:57:56 +02:00
Thomas Gelf
b4a0baa109 schema/pgsql: extend sync rule 2016-05-20 23:42:21 +02:00
Thomas Gelf
0e9a1392e5 schema/pgsql: allow no null var names 2016-05-20 23:20:19 +02:00
Thomas Gelf
19d56fc546 schema: add notification assign type column
thnx @spillerm

refs #11452
2016-03-27 19:11:28 +02:00
Thomas Gelf
e8cfeb74cc schema: add assign type column 2016-03-23 02:35:37 +01:00
Thomas Gelf
c7578bd7ef schema: allow for required arguments 2016-03-21 02:44:50 +01:00
Thomas Gelf
53657cdb31 schema/pgsql: larger file_path field for config
fixes #11383
2016-03-18 21:27:33 +01:00
Thomas Gelf
a3c089e6c6 schema: add tables for notification user(group)s 2016-03-15 22:23:21 +01:00
Thomas Gelf
247ef41483 schema: add notification assignment tables 2016-03-12 01:56:59 +01:00
Thomas Gelf
d3130d0494 schema: remove usergroup zone_id for now 2016-03-09 20:36:39 +01:00
Thomas Gelf
6377ed4bc7 schema/pgsql: allow for longer (> 255) commands
This has already been fixed for MySQL time ago.

refs #11315
2016-03-06 19:28:21 +01:00
Thomas Gelf
f37671c2c0 schema: align PostgreSQL and MySQL sync types 2016-03-05 20:34:24 +01:00
Thomas Gelf
4d84b41272 schema/pgsql: do not enforce import end_time 2016-03-05 20:07:05 +01:00
Thomas Gelf
b65c9f4d4a schema/pgsql: fix tests for timeperiod_ranges 2016-03-02 20:51:41 +01:00
Thomas Gelf
4dfe03816a schema/pgsql: fix primary key on icinga_user_*_set 2016-03-02 20:48:10 +01:00
Thomas Gelf
804a30f8d4 schema: add user fields 2016-03-01 05:12:27 +01:00
Thomas Gelf
7f24e7f50a schema/pgsql: various fixes 2016-03-01 04:17:45 +01:00
Markus Frosch
133b5fb0a1 Fix NOT NULLs in PostgreSQL base schema
refs #11110
2016-03-01 00:20:00 +01:00
Markus Frosch
5f9f97f122 Add PostgreSQL migration 77
refs #11110
2016-03-01 00:06:18 +01:00
Markus Frosch
e0b44e3f01 Bulk update PostgreSQL schema to 76
refs #11110
2016-02-29 23:53:00 +01:00
Thomas Gelf
611b94368b schema: rename value_format to argument_format 2015-08-03 13:51:26 +02:00
Alexander Fuhr
9c03ef5b62 schema/pgsql: fix the upgrade and the schema not null attribute
fixes #9783
2015-07-30 15:47:38 +02:00
Alexander Fuhr
dc91ab498d PostgreSQL Schema: Update it to the last MySQL state
fixes #9783
2015-07-30 14:08:08 +02:00
Alexander Fuhr
d9cff56373 SQLSchema: PostgreSQL update! 2015-07-02 16:09:17 +02:00
Alexander Fuhr
c58a0db429 SQLSchema: PostgreSQL fix wrong foreign key schema 2015-07-02 14:17:13 +02:00
Alexander Fuhr
6e0b430dcc SQLSchema: Add icinga_ host, service _field tables 2015-07-02 14:10:05 +02:00
Thomas Gelf
3f9a19ac91 schema: rename datalist_value to datalist_entry 2015-06-30 15:41:59 +02:00
Alexander Fuhr
775bc67fec Add imports support for Endpoint 2015-06-29 11:11:56 +02:00
Alexander Fuhr
f1c3f9025b Add imports support for UserGroup 2015-06-29 11:02:30 +02:00
Alexander Fuhr
61812d6115 Add imports support for Zone 2015-06-29 10:46:32 +02:00
Alexander Fuhr
cdb66b648a Add imports support for Command 2015-06-29 10:39:37 +02:00
Alexander Fuhr
c7f7d37523 Add imports support for Servicegroup 2015-06-29 10:28:57 +02:00
Alexander Fuhr
878841e33e Add imports support for Hostgroup 2015-06-29 10:20:15 +02:00
Alexander Fuhr
0af3ed4452 Add imports support for Timeperiod 2015-06-26 16:45:44 +02:00
Alexander Fuhr
f7bd670d1b Add imports support to User 2015-06-26 16:36:18 +02:00
Alexander Fuhr
fd74a8dfd5 Add imports support to Service 2015-06-26 16:20:16 +02:00
Thomas Gelf
2ea2e51e00 psql: update schema for global zones 2015-06-24 13:50:58 +02:00
Thomas Gelf
4094794743 schema/pgsql: remove superfluous comments 2015-06-24 13:07:37 +02:00
Alexander Fuhr
7aba7fdb5f pgsql.sql: fix missnamed fkey column 2015-06-23 17:15:30 +02:00
Alexander Fuhr
1f27c6cfbe Add PostgreSQL Schema that is fitting the MySQL Schema
refs #9442
2015-06-23 09:56:48 +02:00