[dev.icinga.com #1355] Oracle: drop unnessary constraints and rename remaining

[icinga-migration]

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

Created by Tommi on 2011-03-27 13:52:45 +00:00

Assignee: Tommi
Status: Resolved (closed on 2011-05-03 20:47:02 +00:00)
Target Version: 1.4
Last Update: 2014-12-08 14:34:54 +00:00 (in Redmine)

---

see http://www.nagios-portal.org/wbb/index.php?page=Thread&postID=146365#post146365
Currently on nearly each and every column are mostly not null constraints, which are not used, because default values are specified. Additional, constraints are created with system defined names. This should be changed into describing names

Changesets

2011-05-03 20:33:05 +00:00 by Tommi 44c127b

drop constraints #1354
split tablespaces #1355
refs #1354, #1355

2011-05-03 20:59:45 +00:00 by Tommi 874e2ad

includes all patchesi and features in upgrade/*.sql
refs #1354,#1355,#1358,#1363,#1401,#1173

2011-05-03 21:04:22 +00:00 by Tommi be82317

fix int(11) to small #1173
fix int not large enogh #1401
drop constraints #1355
refs #1401,#1355,1173

2011-05-03 21:08:39 +00:00 by Tommi ed19196

includes all fixes from upgrade
refs #1401,#1173,#1355

2011-05-03 21:27:58 +00:00 by Tommi c74b02e

fixes for mysql int(11) to small #1173,
integer not big enough #1401
remove not null constraints #1355
refs #1355,#1401,#1173

2011-05-03 21:48:11 +00:00 by Tommi 2f773b2

includes all fixes from upgrade_1.4
remove unwanted characters
refs #1173,#1401,#1355

[icinga-migration]

Updated by Tommi on 2011-03-27 20:46:05 +00:00

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

commit 3ee455b
script move_icinga13_objects.sql

[icinga-migration]

Updated by mfriedrich on 2011-03-27 20:52:08 +00:00

please merge all upgrade scripts that into oracle-upgrade-1.4.0.sql

[icinga-migration]

Updated by mfriedrich on 2011-04-27 16:55:43 +00:00

is this verified working?

[icinga-migration]

Updated by Tommi on 2011-05-03 20:47:02 +00:00

• Status changed from Feedback to Resolved

commit 44c127b
verified in local environment

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:34:54 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 24 to IDOUtils