==  Writer Publishes a Story

=== Authors: **Writter**
A writer changes the status of a story from draft to published, making it visible to all users on the platform.

**1.** The writer navigates to their story management page and selects a story with draft status.

**2.**  The system displays the current story details and status.
{{{#!sql
SELECT s.story_id, s.short_description, st.status
FROM STORY s
JOIN STATUS st ON s.story_id = st.story_id
WHERE s.user_id = 2 AND st.status = 'draft';
}}}

**3.** The writer selects the option to publish the story.

**4.** The system updates the story status from draft to published.
{{{#!sql
UPDATE STATUS
SET status = 'published'
WHERE story_id = 1 AND status = 'draft';
}}}

**5.**  The system sends a notification to all users who follow the writer.

{{{#!sql
INSERT INTO NOTIFICATION (content, is_read, created_at)
VALUES ('Elena published a new story "The Chronicles of Eldoria"', FALSE, CURRENT_TIMESTAMP);
}}}

**6.** The system confirms the story is now publicly visible on the platform.