| | 1 | == Regular User Registration Process |
| | 2 | |
| | 3 | === Authors: **Registered Regular User** |
| | 4 | A new user registers on the platform as a regular user, gaining the ability to read stories, leave comments, likes, and manage their reading list. |
| | 5 | |
| | 6 | **1.** The user selects the option to register as a regular user on the platform. |
| | 7 | |
| | 8 | **2.** The system displays a registration form requesting username, email, name, surname, and password. |
| | 9 | |
| | 10 | |
| | 11 | **3.** The user fills in and submits the registration form. |
| | 12 | |
| | 13 | **4.** The system inserts a new record into the USERS table. |
| | 14 | {{{#!sql |
| | 15 | INSERT INTO USERS (username, email, name, surname, password) |
| | 16 | VALUES ('sara_reader', 'sara.books@gmail.com', 'Sara', 'Petkovska', '$2a$10$hashedpassword004'); |
| | 17 | }}} |
| | 18 | |
| | 19 | **5.** The system registers the user as a regular user in the REGULAR_USER table using the generated user_id. |
| | 20 | |
| | 21 | {{{#!sql |
| | 22 | INSERT INTO REGULAR_USER (user_id) |
| | 23 | VALUES (4); |
| | 24 | }}} |
| | 25 | |
| | 26 | **6.** The system confirms successful registration and redirects the user to the platform homepage. |