*** Wartungsfenster jeden ersten Mittwoch vormittag im Monat ***

Skip to content

Streamline and optimise Constraints

By looking at the installation scr 02 I recognized no pattern in the settings of fkeys beside combined and not combined fkeys.

I think we could have a closer look at the settings, that are possible and use the opportunity to streamliine and optmise our fkey system.

Possible option MATCH FULL (comnined fkeys)

ON UPDATE CASCADE | RESTRICT | NO ACTION | SET NULL | SET DEFAULT (mixed in scr 02)

ON DELETE CASCADE | RESTRICT | NO ACTION | SET NULL | SET DEFAULT 8mixed in scr)

NOT DEFERRABLE | DEFERRABLE INITIALLY IMMEDIATE | DEFERRABLE INITIALLY DEFERRED | DEFERRABLE (maybe necessary for combined keys)