Changes between Version 1 and Version 2 of WriterArchivesAStory

Timestamp:

08/24/26 16:19:08 (13 days ago)

Author:

211099

Comment:

--

WriterArchivesAStory

@@ -1 +1 @@
 ==  Writer Archives a Story
+=== Actor: **Writer**
 
-=== Actor: **Writer**
 A writer decides to archive a published story, making it no longer visible to regular users and guests but keeping it in the system.
 
@@ -8 +8 @@
 **2.** The system displays all stories with their current statuses.
 {{{#!sql
-SELECT s.story_id, s.short_description, st.status,
+SELECT s.story_id, s.short_description, s.status,
        COUNT(DISTINCT c.chapter_id) AS total_chapters,
        COUNT(DISTINCT l.user_id) AS total_likes
 FROM STORY s
-JOIN STATUS st ON s.story_id = st.story_id
 LEFT JOIN CHAPTER c ON s.story_id = c.story_id
 LEFT JOIN LIKES l ON s.story_id = l.story_id
 WHERE s.user_id = 2
-GROUP BY s.story_id, st.status;
+GROUP BY s.story_id, s.status;
 }}}
 
@@ -23 +22 @@
 **4.**The system updates the story status from published to archived.
 {{{#!sql
-UPDATE STATUS
+UPDATE STORY
 SET status = 'archived'
 WHERE story_id = 1 AND status = 'published';
@@ -30 +29 @@
 **5.** The system verifies the story no longer appears in public browsing queries.
 {{{#!sql
-SELECT s.story_id, s.short_description, st.status
-FROM STORY s
-JOIN STATUS st ON s.story_id = st.story_id
-WHERE st.status = 'published' AND s.story_id = 1;
+SELECT story_id, short_description, status
+FROM STORY
+WHERE status = 'published' AND story_id = 1;
 }}}
 
 **6.** The system sends a notification to users who had the story in their reading lists informing them it is no longer available.
 {{{#!sql
-INSERT INTO NOTIFICATION (content, is_read, created_at)
-VALUES ('"The Chronicles of Eldoria" has been archived by the author and is no longer available.', FALSE, CURRENT_TIMESTAMP);
+INSERT INTO NOTIFICATION (notification_content, content_type, is_read, user_id, story_id, notification_created_at)
+VALUES ('"The Chronicles of Eldoria" has been archived by the author and is no longer available.', 'story_archived', FALSE, 4, 1, CURRENT_TIMESTAMP);
 }}}