Changed Constraints for Web Service Security

Description

I don't like the constraints on Web Service Security (ws_webservicetype) because if you want to delete an entry in the main tab of the window, you get errors if there are still parameters/input-/outputfield/accesses. The same goes if you want to delete an entry via sql. So i created a small sql to change the foreign key constraints on those tables to change from "ON DELTE NO ACTION" to "ON DELETE CASCADE"

I created them for PSQL but i think they will work for Oracle too. The only changes i found so far is that maybe on Oracle you need to put the "ADD CONSTRAINT ...;" in brackets -> "ADD (CONSTRAINT ...);"

Environment

None

Assignee

Jan Thielemann

Reporter

Jan Thielemann

Labels

None

Tested By

None

Priority

Trivial
Configure