SELECT 
	TABLE_NAME AS `table`, 
    fields
FROM INFORMATION_SCHEMA.TABLES
JOIN (
	SELECT 
		GROUP_CONCAT(CONCAT(COLUMN_NAME,':',DATA_TYPE)) AS fields,
        TABLE_NAME AS COLS_TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_SCHEMA = :db
    GROUP BY TABLE_NAME
) cols ON COLS_TABLE_NAME = TABLE_NAME
WHERE TABLE_SCHEMA = :db