DELIMITER $$


DROP PROCEDURE IF EXISTS `chkLocalUpdate`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `chkLocalUpdate`(IN localdb VARCHAR(50), IN centraldb VARCHAR(50))
BEGIN
    
    SET @getStmnt = CONCAT(
	'select a.gid, a.methn, a.gnpgs, a.gpid1, a.gpid2, a.germuid, a.lgid, a.glocn, a.gdate, a.gref, a.grplce, a.mgid 
		from ',localdb,'.germplsm a 
		where (a.grplce=0 and a.gid<0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(    
	'select a.nid, a.gid, a.ntype, a.nstat, a.nuid, a.nval, a.nlocn, a.ndate, a.nref, b.grplce 
		from ',localdb,'.names a,' ,localdb,'.germplsm b 
		where (a.gid<0 and b.grplce=0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(    
	'select a.aid, a.gid, a.atype, a.auid, a.aval, a.alocn, a.aref, a.adate, b.grplce 
		from ',localdb,'.atributs a,',localdb,'.germplsm b 
		where (a.gid<0 and b.grplce=0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(    
	'select a.gid, a.pno, a.pid, b.grplce 
		from ',localdb,'.progntrs a,',localdb,'.germplsm b 
		where (a.pid<0 or b.gid=0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    
    END$$

DELIMITER ;