Changes between Version 1 and Version 2 of AdminRemovesAStory

Timestamp:

08/24/26 16:20:41 (13 days ago)

Author:

211099

Comment:

--

AdminRemovesAStory

@@ -2 +2 @@
 
 === Actor: **Admin**
+
 An admin removes an inappropriate published story from the platform after reviewing it for content violations.
 
@@ -9 +10 @@
 {{{#!sql
 SELECT s.story_id, s.short_description, s.mature_content,
-       u.username AS author, st.status,
+       u.username AS author, s.status,
        COUNT(DISTINCT c.comment_id) AS total_comments,
-       s.created_at
+       s.story_created_at
 FROM STORY s
 JOIN USERS u ON s.user_id = u.user_id
-JOIN STATUS st ON s.story_id = st.story_id
 LEFT JOIN COMMENT c ON s.story_id = c.story_id
-WHERE st.status = 'published'
-GROUP BY s.story_id, u.username, st.status
-ORDER BY s.created_at DESC;
+WHERE s.status = 'published'
+GROUP BY s.story_id, u.username, s.status
+ORDER BY s.story_created_at DESC;
 }}}
 
@@ -25 +25 @@
 **4.** The admin confirms the story violates platform rules and proceeds to delete it.
 
-**5.** The system deletes the story, and all related records are automatically removed via CASCADE.
+**5.** The system notifies the writer that their story is being removed due to a policy violation, before the story record is deleted.
+{{{#!sql
+INSERT INTO NOTIFICATION (notification_content, content_type, is_read, user_id, story_id, notification_created_at)
+VALUES ('Your story "Moonlight Promises" has been removed by an administrator due to a content policy violation.', 'story_removed', FALSE, 6, 3, CURRENT_TIMESTAMP);
+}}}
+
+**6.** The system deletes the story, and all related records (chapters, comments, likes, collaborations, genre links, reading list entries) are automatically removed via CASCADE.
 {{{#!sql
 DELETE FROM STORY
@@ -31 +37 @@
 }}}
 
-**6.** The system notifies the writer that their story was removed due to a policy violation.
-{{{#!sql
-INSERT INTO NOTIFICATION (content, is_read, created_at)
-VALUES ('Your story "Moonlight Promises" has been removed by an administrator due to a content policy violation.', FALSE, CURRENT_TIMESTAMP);
-}}}
-
 **7.** The system logs the action and confirms the story is no longer visible on the platform.