-- Vezi toti useri M
DROP VIEW view_male_users;
CREATE VIEW view_male_users AS
    SELECT id, first_name, last_name, gender FROM users WHERE gender = 'M';

-- Sterge posturile userilor M
DROP TRIGGER trigger_delete_post;
CREATE TRIGGER trigger_delete_post INSTEAD OF DELETE ON view_male_users
    FOR EACH ROW BEGIN
      DELETE FROM posts WHERE user_id = :OLD.id;
    END;
/


-- Adauga emailu vechi tabela in old_user_emails
DROP TRIGGER trigger_delete_post;
CREATE TRIGGER trigger_update_user_email INSTEAD OF DELETE ON view_male_users
    FOR EACH ROW BEGIN
    END;
/