[dev.icinga.com #5635] document ido schema changes between 0.0.7 and 0.0.8

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/5635

Created by mfriedrich on 2014-02-11 15:56:40 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2014-03-07 09:58:02 +00:00)
Target Version: 0.0.8
Last Update: 2014-09-16 09:19:41 +00:00 (in Redmine)

Icinga Version: 0.0.7

---

Until there's a proper version schema for Icinga 2 DB IDO, these are the changes done between 0.0.7 and 0.0.8

https://git.icinga.org/?p=icinga-core.git;a=blob;f=module/idoutils/db/mysql/upgrade/mysql-upgrade-1.11.0.sql;h=3242fb7386671ae1db2ecf2c4eed734c4db67e6d;hb=refs/heads/next
https://git.icinga.org/?p=icinga-core.git;a=blob;f=module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.11.0.sql;h=aed401d965edb791d97d7055171562ff06365b2e;hb=refs/heads/next

-- -----------------------------------------
-- #5612
-- -----------------------------------------
ALTER TABLE icinga_statehistory ADD COLUMN check_source varchar(255) character set latin1 default NULL;

ALTER TABLE icinga_acknowledgements ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_commenthistory ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_contactnotifications ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_downtimehistory ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_eventhandlers ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_externalcommands ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_flappinghistory ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_hostchecks ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_logentries ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_notifications ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_processevents ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_servicechecks ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_statehistory ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;
ALTER TABLE icinga_systemcommands ADD COLUMN icinga_node varchar(255) character set latin1 default NULL;

Changesets

2014-03-07 09:40:30 +00:00 by (unknown) 33a8e50

Document DB IDO schema changes for 0.0.8

Fixes #5635

2014-03-07 10:11:28 +00:00 by (unknown) 3b8c1a0

DB IDO: Schema update for 0.0.8 provides 1.11.0 version.

Refs #5635

[icinga-migration]

Updated by mfriedrich on 2014-02-20 14:58:39 +00:00

• Description updated

[icinga-migration]

Updated by mfriedrich on 2014-03-03 15:06:33 +00:00

• Assigned to set to mfriedrich

[icinga-migration]

Updated by Anonymous on 2014-03-07 09:58:02 +00:00

• Status changed from New to Resolved
• Done % changed from 0 to 100

Applied in changeset i2:33a8e504ca070680445a961e0ae8d4fd6826633f.

[icinga-migration]

Updated by mfriedrich on 2014-09-16 09:19:41 +00:00

• Project changed from 32 to Icinga 2
• Category set to DB IDO