add logger pattern. fix install.sql