--ABS-100319/ ABS-107134


-------------CONTRACTCOMPONENTMISC table---------------
ALTER TABLE CONTRACTCOMPONENTMISC
  DROP CONSTRAINT FK_CONTRACTCOMPMISC_MAATEMPLH;
  
ALTER TABLE CONTRACTCOMPONENTMISC
  ADD CONSTRAINT FK_CONTRACTCOMPMISC_MAATEMPLH FOREIGN KEY (RAATEMPLATEHEADER_ID)
  REFERENCES MAATEMPLATEHEADER (MAATEMPLATEHEADER_ID);

---------CUSTOMEREXTRAINFO table------------
ALTER TABLE CUSTOMEREXTRAINFO
  DROP CONSTRAINT FK_CUSTEXTRAINFO_MAATEMPLH;
  
ALTER TABLE CUSTOMEREXTRAINFO
  ADD CONSTRAINT FK_CUSTEXTRAINFO_MAATEMPLH FOREIGN KEY (RAATEMPLATEHEADER_ID)
  REFERENCES MAATEMPLATEHEADER (MAATEMPLATEHEADER_ID);



-------------MAATEMPLATEHEADER table--------------------
ALTER TABLE MAATEMPLATEHEADER ADD (DEFAULTTEMPLATE VARCHAR2(1) DEFAULT 'N' NOT NULL
                                           CONSTRAINT CHK_MAATEMPLH_DEFAULTTEMPLATE CHECK (DEFAULTTEMPLATE IN ('Y', 'N')));

CREATE UNIQUE INDEX XAK1MAATEMPLATEHEADER ON MAATEMPLATEHEADER (CODE ASC);

-------------MAATEMPLATEATTRIBUTE table--------------------
ALTER TABLE MAATEMPLATEATTRIBUTE ADD (INTERNALNAME VARCHAR2(50) NULL);

COMMENT ON COLUMN MAATEMPLATEATTRIBUTE.INTERNALNAME
  IS '"Java" name of the component';

ALTER TABLE MAATEMPLATEATTRIBUTE MODIFY ROUTEASSISTANTVERSION NULL;