Changes between Initial Version and Version 1 of UserCreatesReadingList

Timestamp:

03/05/26 15:03:49 (2 weeks ago)

Author:

211099

Comment:

--

UserCreatesReadingList

@@ +1 @@
+==  User Creates a Reading List
+
+=== Authors: **Regular User / Writer**
+A user creates a new personal reading list, choosing whether to make it public or private.
+
+**1.** The user navigates to their profile and selects "Create New Reading List".
+
+**2.** The system displays a form requesting the list name, description, and visibility setting.
+
+**3.** The user fills in the details and selects whether the list is public or private.
+
+**4.** The system inserts a new record into the READING_LIST table.
+{{{#!sql
+INSERT INTO READING_LIST (name, content, is_public, user_id, created_at, updated_at)
+VALUES ('Sara''s Fantasy Favorites', 
+        'My collection of the best fantasy stories with strong female leads', 
+        TRUE, 4, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
+}}}
+
+**5.** The system confirms the reading list was created and redirects the user to their new empty list.
+
+**6.** The system displays the reading list with zero stories added yet.
+{{{#!sql
+SELECT rl.list_id, rl.name, rl.content, rl.is_public, COUNT(rli.story_id) AS total_stories
+FROM READING_LIST rl
+LEFT JOIN READING_LIST_ITEMS rli ON rl.list_id = rli.list_id
+WHERE rl.user_id = 4
+GROUP BY rl.list_id;
+}}}