Changes between Version 2 and Version 3 of WriterPublishesStory

Timestamp:

08/24/26 15:59:38 (13 days ago)

Author:

211099

Comment:

--

WriterPublishesStory

@@ -8 +8 @@
 **2.**  The system displays the current story details and status.
 {{{#!sql
-SELECT s.story_id, s.short_description, st.status
-FROM STORY s
-JOIN STATUS st ON s.story_id = st.story_id
-WHERE s.user_id = 2 AND st.status = 'draft';
+SELECT story_id, short_description, status
+FROM STORY
+WHERE user_id = 2 AND status = 'draft';
 }}}
 
@@ -18 +17 @@
 **4.** The system updates the story status from draft to published.
 {{{#!sql
-UPDATE STATUS
+UPDATE STORY
 SET status = 'published'
 WHERE story_id = 1 AND status = 'draft';
@@ -26 +25 @@
 
 {{{#!sql
-INSERT INTO NOTIFICATION (content, is_read, created_at)
-VALUES ('Elena published a new story "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 story "The Chronicles of Eldoria"', 'new_story', FALSE, 5, 1, CURRENT_TIMESTAMP);
 }}}