DROP TABLE IF EXISTS `v_messages`;
DROP VIEW IF EXISTS `v_messages`;

CREATE OR REPLACE VIEW `_mydb_chat`.`v_messages` AS 
SELECT m_messages.*, _mydb_account.m_account.c_handle, _mydb_account.m_account.c_body_background_color, _mydb_account.m_account.c_profile_image
FROM m_messages
LEFT OUTER JOIN _mydb_account.m_account ON m_messages.id_account = _mydb_account.m_account.id_account;
