Changes between Version 3 and Version 4 of RegularUserRegistration

Timestamp:

08/24/26 16:04:29 (13 days ago)

Author:

211099

Comment:

--

RegularUserRegistration

@@ -13 +13 @@
 **4.** The system inserts a new record into the USERS table. 
 {{{#!sql
-INSERT INTO USERS (username, email, name, surname, password)
+INSERT INTO USERS (username, email, user_name, surname, password)
 VALUES ('sara_reader', 'sara.books@gmail.com', 'Sara', 'Petkovska', '$2a$10$hashedpassword004');
 }}}
@@ -20 +20 @@
 
 {{{#!sql
-INSERT INTO REGULAR_USER (user_id)
-VALUES (4);
+INSERT INTO REGULAR_USER (user_id, joined_at)
+VALUES (4, CURRENT_TIMESTAMP);
 }}}