 UPDATE CATISSUE_SEARCH_DISPLAY_DATA SET ATTRIBUTE_ORDER = 9 WHERE RELATIONSHIP_ID=130 AND COL_ID=260;
 /*********************** Sachin: Setting the column/attribute order ENDS ************************/
 
+/************** 9 aug 2007 ***** for distribution array ***************************************/
+UPDATE CATISSUE_SEARCH_DISPLAY_DATA SET ATTRIBUTE_ORDER = 10 WHERE RELATIONSHIP_ID=131 AND COL_ID=72;
 
 
 


INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID, TABLES_IN_PATH) values (54,35,31,'27');

/* ************************************** QUERIES FOR SITE ***********************************************************/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (6, 185, 'Name',1);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (6, 184, 'Identifier',1);

/*Removed for PHI bug*/
INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID) values (130,21,1);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME) VALUES (130, 260 , 'Default Temperature In Centigrade');

/**************** 9 aug 2007 ********* inserting search display data for distribution array ******************/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (131, 72 , 'Distributed Quantity', 0);

/*******************Simple Search Edit scripts starts here***********/
/*Patch ID: SimpleSearchEdit_12*/
