-- ABS-35939
ALTER TABLE SUBCONTRACTOR ADD (COUNTRY_ID NUMBER);

CREATE INDEX XIF2SUBCONTRACTOR ON SUBCONTRACTOR (COUNTRY_ID ASC);

ALTER TABLE SUBCONTRACTOR
  ADD CONSTRAINT SUBCONTRACTOR_COUNTRY FOREIGN KEY (COUNTRY_ID)
  REFERENCES COUNTRY (COUNTRY_ID);
