 
alter table 	IMAGE	modify (	URI	varchar2 (1000));
alter table 	DESCRIPTION	modify (	URI	varchar2 (1000));
alter table 	SOFTWARE	modify (	URI	varchar2 (1000));
alter table 	PROTOCOL	modify (	URI	varchar2 (1000));
alter table 	DATABASE	modify (	URI	varchar2 (1000));
alter table 	DESCRIPTION	modify (	TEXT	varchar2 (4000));
alter table 	BIBLIOGRAPHICREFERENCE	modify (	URI	varchar2 (1000));
alter table 	ORGANIZATION	modify (	URI	varchar2 (1000));
alter table 	PERSON	modify (	URI	varchar2 (1000));
alter table 	HARDWARE	modify (	URI	varchar2 (1000));
alter table 	DATABASEENTRY	modify (	URI	varchar2 (1000));
alter table 	AS_USER_ROLE_PROTECT_APP modify  (PROTECTION_GROUP_ID number null) ;

alter table FEATUREDIMENSIONFEATURE enable constraint FEATUREDIMENSIONFEATURE_PK;

create index 	DESIELMAP_COMSEQ_IDX	on 	DESIGNELEMENTMAP	(	COMPOSITE_SEQUENCE_ID	);
create index 	DESIELMAP_REP_IDX	on 	DESIGNELEMENTMAP	(	REPORTER_ID	);
create index 	DESIELMAP_DESCSEC_IDX	on 	DESIGNELEMENTMAP	(	DESC_SECURITY_ID	);

create index 	REP_REPGRP_IDX	on 	REPORTER	(	REPORTER_GROUP_ID	);
create index 	REP_DESCSEC_IDX	on 	REPORTER	(	DESC_SECURITY_ID	);
create index 	MOM_MD_HOST_IP_IDX	on 	MOM_MESSAGEDATA	(	HOST_IP	);
create index 	MOM_MD_WAIT_TIME_IDX	on 	MOM_MESSAGEDATA	(	WAIT_TIME	);
create index 	DESIELMAP_NM_IDX	on 	DESIGNELEMENTMAP	(	name	);
create index 	REP_CONTYPE_IDX	on 	REPORTER	(	CONTROL_TYPE_ID	);
create index 	REP_WAR_IDX	on 	REPORTER	(	WARNING_TYPE_ID	);

alter table	MOM_MESSAGEDATA	modify (host_iP	varchar2 (15) not null);

CREATE TABLE HARDWARE2SOFTWARE
(
  HARDWARE_ID  NUMBER                           NOT NULL,
  SOFTWARE_ID  NUMBER                           NOT NULL
) ;

ALTER TABLE HARDWARE2SOFTWARE ADD ( CONSTRAINT HARDWARE2SOFTWARE_PK PRIMARY KEY (HARDWARE_ID, SOFTWARE_ID));

COMMENT ON TABLE HARDWARE2SOFTWARE IS 'This table contains m:n associations b/w Hardware and Software that is targeted/compatible for the Hardware';

ALTER TABLE HARDWARE2SOFTWARE ADD (
  CONSTRAINT HARDWARE2SOFTWARE_FK_1 FOREIGN KEY (HARDWARE_ID) 
    REFERENCES HARDWARE (ID));

ALTER TABLE HARDWARE2SOFTWARE ADD (
  CONSTRAINT HARDWARE2SOFTWARE_FK_2 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));


