Should I add custom columns on out of box tables or create new tables and extend?

Go to solution
Todd O
Tera Guru

‎10-10-2016 05:42 PM

I have a situation where I'm populating Out of Box tables (e.g., Linux Server cmdb_ci_linux which is an extension of several other tables under it). I have few columns I'd like to add to this table that are unique for Linux Servers so, should I just add columns to this out of box table or should I create an extending table from this table and just add the couple columns on this new extending table?

Are there issues when we want to do a product upgrade and I've modified out of the box table like this? An additional twist on this is that I have some columns which will apply to many of the extending table from Computer (cmdb_ci_computer).   So, I'm considering adding these few columns on Computer table but again, I'm concerned when we go through a product upgrade that I may be shooting off my own foot but modifying out of box tables. Will upgrades go okay and retain data in these custom columns?

Thank you, thank you!

Todd

Labels:
0 Helpfuls
  • 2,286 Views
1 ACCEPTED SOLUTION
4 REPLIES 4

Go to solution
Deepak Kumar5
Kilo Sage

‎10-10-2016 05:48 PM

You can add your custom field in OOB table and that wouldn't be affected after upgrade.


Go to solution
Todd O
Tera Guru
In response to Deepak Kumar5

‎10-10-2016 05:53 PM

DK,


Do you have any links that indicate there are no upgrade issues with adding new columns to OOB tables? Thanks.


Todd


0 Helpfuls

Go to solution
Deepak Kumar5
Kilo Sage
In response to Todd O

‎10-10-2016 06:00 PM

We have many New fields in Incident table which is OOB table. I don't think I can get any Doc for this.


Upgrade may cause issue if you modify OOB scripts which may skip during upgrade.


0 Helpfuls