@darius here seems to be a twist of things. I just ran my sdk and installed ref app 2.6.1 which runs on paltform 2.0.5 and something funny, the table structure of the reporting_report_design does NOT have a constraint report_definition_uuid_for_reporting_report_design it only has it as an index. see the attached for review
.
My question is, and maybe @mseaton and @raff can help me, is it possible that we no longer need such foreign_key created on this table? am confused. Seems we only need index for this table and NOTforeign_key constraint? what do others structure look like @ssmusoke
I have just checked here to see where such constraint is created and found none, only the index is created. If so, does it imply that by dropping that constraint manually suffice thereby having no need to restore it?