--ABS-78465
ALTER TABLE ROUTECONTROL_COMMISSION ADD (TURNOVERGROUP_ID NUMBER DEFAULT NULL);
CREATE INDEX INDX02_ROUTECONTR_COM_TURN ON ROUTECONTROL_COMMISSION (TURNOVERGROUP_ID ASC);
ALTER TABLE ROUTECONTROL_COMMISSION
  ADD CONSTRAINT FK_ROUTECONTR_COM_TURN FOREIGN KEY (TURNOVERGROUP_ID)
  REFERENCES TURNOVERGROUP(TURNOVERGROUP_ID) ON DELETE SET NULL;
  
ALTER TABLE ROUTECONTROL_COMMISSION
  DROP CONSTRAINT PK_ROUTECONTROL_COMMISSION CASCADE;
ALTER TABLE ROUTECONTROL_COMMISSION
  ADD CONSTRAINT PK_ROUTECONTROL_COMMISSION PRIMARY KEY (ROUTECONTROL_ID, TURNOVERGROUP_ID);
CREATE INDEX INDX03_ROUTECONTR_COM_TURN ON ROUTECONTROL_COMMISSION (ROUTECONTROL_ID ASC);