 INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID) values (135,81,83);
 INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID) values (136,81,84);
 
+/*Changes due to model change (Virender Mehta  12th Oct 2007)*/ 
+INSERT INTO CATISSUE_QUERY_TABLE_DATA(TABLE_ID, TABLE_NAME, DISPLAY_NAME, ALIAS_NAME, PRIVILEGE_ID, FOR_SQI)
+values( 92, 'CATISSUE_ABSTRACT_SPECIMEN_COLL_GROUP', 'Abstract Specimen Coll Group', 'AbstractScg',2,null);
+
+INSERT INTO CATISSUE_INTERFACE_COLUMN_DATA(IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE )
+values ( 330, 92, 'IDENTIFIER', 'bigint');
+
+INSERT INTO CATISSUE_TABLE_RELATION(RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID)values (137,35,92);
+
+INSERT INTO CATISSUE_RELATED_TABLES_MAP values ( 92 , 35 , 'IDENTIFIER','IDENTIFIER');
+/*Changes due to model change (Virender Mehta  12th Oct 2007)*/ 
 commit;
/*Bug#3549 Inserting value for ATTRIBUTE_ORDER in specimen coll grp*/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (30, 320, 'Name',1,1);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (30, 209, 'Identifier',1,12);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (30, 210, 'Clinical Diagnosis',1,7);

INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (30, 211, 'Clinical Status',1,8);
/*INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (30, 212, 'Activity Status',1);*/

INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME,ATTRIBUTE_ORDER) VALUES (48, 224, 'Collection Protocol Title',11);

INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (31, 57, 'Study Calendar Event Point', 1,9);

insert into CATISSUE_RELATED_TABLES_MAP values ( 31 , 73 , 'IDENTIFIER','PARTICIPANT_ID');
insert into CATISSUE_RELATED_TABLES_MAP values ( 10 , 27 , 'IDENTIFIER','COLLECTION_PROTOCOL_ID');
insert into CATISSUE_RELATED_TABLES_MAP values ( 31 , 27 , 'IDENTIFIER','PARTICIPANT_ID');
/* Changes related to model change, replaced 35 with 92 Virender Mehta 12th Oct 2007*/
insert into CATISSUE_RELATED_TABLES_MAP values ( 3 , 92 , 'IDENTIFIER','SITE_ID');
/* Changes related to model change, replaced second_table_id from 35 to 92 Virender Mehta 12th Oct 2007*/
insert into CATISSUE_RELATED_TABLES_MAP values ( 11 , 35 , 'IDENTIFIER','COLLECTION_PROTOCOL_EVENT_ID');
insert into CATISSUE_RELATED_TABLES_MAP values ( 27 , 35 , 'IDENTIFIER','COLLECTION_PROTOCOL_REG_ID');
insert into CATISSUE_RELATED_TABLES_MAP values ( 21 , 33 , 'IDENTIFIER','STORAGE_CONTAINER_IDENTIFIER');
