Changes between Initial Version and Version 1 of AdminRemovesAStory

Timestamp:

03/05/26 15:48:02 (2 weeks ago)

Author:

211099

Comment:

--

AdminRemovesAStory

@@ +1 @@
+==  Admin Removes a Story
+
+=== Actor: **Admin**
+An admin removes an inappropriate published story from the platform after reviewing it for content violations.
+
+**1.** The admin navigates to the content moderation dashboard.
+
+**2.** The system displays all published stories with their details.
+{{{#!sql
+SELECT s.story_id, s.short_description, s.mature_content,
+       u.username AS author, st.status,
+       COUNT(DISTINCT c.comment_id) AS total_comments,
+       s.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;
+}}}
+
+**3.** The admin selects a story flagged for inappropriate content and reviews it.
+
+**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.
+{{{#!sql
+DELETE FROM STORY
+WHERE story_id = 3;
+}}}
+
+**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.