SET NAMES cp1250;
 DELIMITER $$

DROP VIEW IF EXISTS v_log $$

CREATE VIEW v_log as
	SELECT idn,useridn,ip,czas,miejsce,czynnosc,LEFT(if(compressed,uncompress(info),info),250) as info,
		GUIDlink,table_link,osobaguid,lat,lon
	FROM log;
$$

DELIMITER ;

/*
$Log: v_log.sql,v $
Revision 1.1  2025/08/08 11:05:48  apro
init

*/
