-- Teste final: criar um post de exemplo
INSERT INTO core_business.posts (
    company_id, 
    author_id, 
    content_text, 
    status, 
    target_social_accounts,
    content_hashtags,
    tags
) VALUES (
    1,
    4,  
    'Este é um post de teste para validar o sistema! 🚀 #teste #socialmanager',
    'DRAFT',
    '{1}',
    '{"teste", "socialmanager"}',
    '{"teste", "social", "manager"}'
);

-- Verificar o post criado
SELECT p.id, p.content_text, p.status, p.post_type, c.name as company_name, u.name as author_name
FROM core_business.posts p
JOIN core_business.companies c ON p.company_id = c.id
JOIN core_business.users u ON p.author_id = u.id;
