Changes between Version 2 and Version 3 of RegularUserLikesStory

Timestamp:

08/24/26 16:09:58 (13 days ago)

Author:

211099

Comment:

--

RegularUserLikesStory

@@ -2 +2 @@
 
 === Actor: **Regular User**
+
 A regular user likes a published story on the platform, and the writer receives a notification about it.
 
@@ -23 +24 @@
 }}}
 
-**5.**  The system inserts a new like record.
+**5.** The system inserts a new like record.
 {{{#!sql
-INSERT INTO LIKES (user_id, story_id, created_at)
+INSERT INTO LIKES (user_id, story_id, liked_at)
 VALUES (4, 1, CURRENT_TIMESTAMP);
 }}}
@@ -31 +32 @@
 **6.** The system creates a notification for the writer.
 {{{#!sql
-INSERT INTO NOTIFICATION (content, is_read, created_at)
-VALUES ('Sara liked your 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 ('Sara liked your story "The Chronicles of Eldoria"', 'like', FALSE, 2, 1, CURRENT_TIMESTAMP);
 }}}
 
-**7.** The system creates a notification for the writer.
-{{{#!sql
-INSERT INTO CONTENT_TYPE (notification_id, content_type)
-VALUES (1, 'like');
-}}}
-
-**8.** The system creates a notification for the writer.
-{{{#!sql
-INSERT INTO NOTIFY (user_id, story_id, notification_id)
-VALUES (2, 1, 1);
-}}}
-
-**9.** The system updates the like count displayed on the story page.
+**7.** The system updates the like count displayed on the story page.