Writer Adds a Chapter to a Story

Authors: Writter

A writer adds a new chapter to an existing published or draft story, providing chapter details such as title, content, and chapter number.

1. The writer navigates to their story and selects "Add New Chapter".

2. The system displays the chapter creation form requesting chapter number, chapter name, title, and content.

3. The system checks what chapter number should come next.

SELECT MAX(chapter_number) + 1 AS next_chapter
FROM CHAPTER
WHERE story_id = 1;

4. The writer fills in all chapter details and submits the form.

5. The system inserts a new record into the CHAPTER table.

INSERT INTO CHAPTER (chapter_number, chapter_name, title, content, word_count, published_at, view_count, story_id, created_at, updated_at)
VALUES (4, 'Chapter Four', 'The Council of Kings',
'Lyra stood before the five thrones, her heart hammering...',
3800, CURRENT_TIMESTAMP, 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

6. The system notifies all users who have the story in their reading list.

INSERT INTO NOTIFICATION (content, is_read, created_at)
VALUES ('Elena published a new chapter of "The Chronicles of Eldoria"', FALSE, CURRENT_TIMESTAMP);

7. The system confirms the chapter was added and displays it on the story page.