Changes between Version 2 and Version 3 of WriterAddsChapterToStory

Timestamp:

08/24/26 16:00:37 (13 days ago)

Author:

211099

Comment:

--

WriterAddsChapterToStory

@@ -20 +20 @@
 
 {{{#!sql
-INSERT INTO CHAPTER (chapter_number, chapter_name, title, content, word_count, published_at, view_count, story_id, created_at, updated_at)
+INSERT INTO CHAPTER (chapter_number, chapter_name, title, chapter_content, word_count, published_at, view_count, story_id, chapter_created_at, chapter_updated_at)
 VALUES (4, 'Chapter Four', 'The Council of Kings',
 'Lyra stood before the five thrones, her heart hammering...',
@@ -28 +28 @@
 **6.** The system notifies all users who have the story in their reading list.
 {{{#!sql
-INSERT INTO NOTIFICATION (content, is_read, created_at)
-VALUES ('Elena published a new chapter of "The Chronicles of Eldoria"', FALSE, CURRENT_TIMESTAMP);
+INSERT INTO NOTIFICATION (notification_content, content_type, is_read, user_id, story_id, notification_created_at)
+VALUES ('Elena published a new chapter of "The Chronicles of Eldoria"', 'new_chapter', FALSE, 4, 1, CURRENT_TIMESTAMP);
 }}}