DROP TABLE IF EXISTS `v_draw`;
DROP VIEW IF EXISTS `v_draw`;

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


CREATE OR REPLACE VIEW `_mydb_draw`.`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;
