DELIMITER $$


DROP PROCEDURE IF EXISTS `updateLocalGMS`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `updateLocalGMS`(IN localdb VARCHAR(50), IN centraldb VARCHAR(50))
BEGIN
    
    SET @getStmnt = CONCAT(
	'update ',localdb,'.progntrs a,',localdb,'.updategid b 
		set a.pid=b.gid where (a.pid=b.lgid)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
	'update ',localdb,'.names a,',localdb,'.updategid b 
		set a.gid=b.gid where (a.gid=b.lgid)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
        
    SET @getStmnt = CONCAT(
	'update ',localdb,'.atributs a,',localdb,'.updategid b 
		set a.gid=b.gid where (a.gid=b.lgid)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
	'update ',localdb,'.listdata a,',localdb,'.updategid b 
		set a.gid=b.gid where (a.gid=b.lgid)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'insert into ',localdb,'.updatenames (lnid) 
		select a.nid 
		from ',localdb,'.names a where (a.nid<0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'update ',localdb,'.names a,',localdb,'.updatenames b 
		set a.nid = b.nid 
		where a.nid = b.lnid');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'insert into ',localdb,'.updateatributs (laid) 
		select a.aid 
		from ',localdb,'.atributs a 
		where (a.aid<0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'update ',localdb,'.atributs a,',localdb,'.updateatributs b 
		set a.aid = b.aid 
		where a.aid = b.laid');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'insert into ',localdb,'.updateinstln (linstalid) 
		select a.instalid 
		from ',localdb,'.instln a 
		where (a.instalid<0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'update ',localdb,'.instln a,',localdb,'.updateinstln b 
		set a.instalid = b.instalid
		where a.instalid = b.linstalid');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;	
    
    SET @getStmnt = CONCAT(
        'update ',localdb,'.users a,',localdb,'.updateinstln b 
		set a.instalid = b.instalid
		where a.instalid = b.linstalid');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;	
    
    SET @getStmnt = CONCAT(
        'insert into ',localdb,'.updateadmin (ladmin) 
		select a.admin 
		from ',localdb,'.instln a 
		where (a.admin<0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    SET @getStmnt = CONCAT(
        'update ',localdb,'.instln a,',localdb,'.updateadmin b 
		set a.admin = b.admin
		where a.admin = b.ladmin');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;	
    
    SET @getStmnt = CONCAT(
        'insert into ',localdb,'.updatechng (lcid) 
		select a.cid 
		from ',localdb,'.changes a where (a.cid<0)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;

    SET @getStmnt = CONCAT(
	'update ',localdb,'.updatechng a ,',localdb,'.changes b 
		set b.cid = a.cid where (b.cid=a.lcid)');
    PREPARE stmnt1 FROM @getStmnt;
    EXECUTE stmnt1;
    DEALLOCATE PREPARE stmnt1;
    
    
    END$$

DELIMITER ;