DROP TABLE IF EXISTS `v_svg`;
DROP VIEW IF EXISTS `v_svg`;

CREATE OR REPLACE VIEW `_mydb_svg`.`v_svg` AS 
SELECT m_svg.*, _mydb_account.m_account.c_handle
FROM m_svg
LEFT OUTER JOIN _mydb_account.m_account ON m_svg.id_account = _mydb_account.m_account.id_account
WHERE m_svg.c_delete <> 999;


CREATE OR REPLACE VIEW `_mydb_svg`.`v_comment` AS 
SELECT m_comment.*, _mydb_account.m_account.c_handle
FROM m_comment
LEFT OUTER JOIN _mydb_account.m_account ON m_comment.id_account = _mydb_account.m_account.id_account
WHERE m_comment.c_delete <> 999;
