DELETE FROM brand_knowledge WHERE brand_id=1;

DELETE FROM content_rules WHERE brand_id=1;

DELETE FROM brand_transcripts WHERE brand_id=1;

DELETE FROM generation_blueprint WHERE brand_id=1;

DELETE FROM brand_content WHERE brand_id=1;

DELETE FROM brands WHERE brands.id = 1;