 insert into CATISSUE_QUERY_TABLE_DATA  ( TABLE_ID, TABLE_NAME, DISPLAY_NAME, ALIAS_NAME, PRIVILEGE_ID, FOR_SQI) values ( 35, 'CATISSUE_SPECIMEN_COLL_GROUP', 'Specimen Collection Group', 'SpecimenCollectionGroup',2,1);
 insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 209, 35, 'IDENTIFIER', 'bigint');
 insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 320, 35, 'NAME', 'varchar');
-insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 210, 35, 'CLINICAL_DIAGNOSIS', 'varchar');
-insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 211, 35, 'CLINICAL_STATUS', 'varchar');
-insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 212, 35, 'ACTIVITY_STATUS', 'varchar');
-insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 213, 35, 'SITE_ID', 'bigint');
+/* Changes relates to model replacing Table_id from 35 to 92 Virender Mehta 12th Oct 2007 */
+insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 210, 92, 'CLINICAL_DIAGNOSIS', 'varchar');
+insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 211, 92, 'CLINICAL_STATUS', 'varchar');
+insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 212, 92, 'ACTIVITY_STATUS', 'varchar');
+insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 213, 92, 'SITE_ID', 'bigint');
+/* Changes relates to model replacing Table_id from 35 to 92 Virender Mehta 12th Oct 2007 */
 insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 214, 35, 'COLLECTION_PROTOCOL_EVENT_ID', 'bigint');
 insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 215, 35, 'SURGICAL_PATHOLOGY_NUMBER', 'varchar');
 insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 216, 35, 'COLLECTION_PROTOCOL_REG_ID', 'bigint');

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');
insert into CATISSUE_RELATED_TABLES_MAP values ( 3 , 35 , 'IDENTIFIER','SITE_ID');
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');

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;