Changes between Version 2 and Version 3 of NewUserRegistration

Timestamp:

01/22/26 02:42:50 (16 hours ago)

Author:

221296

Comment:

--

NewUserRegistration

@@ -3 +3 @@
 ==== Actors: **Guest User**
 
-**1.** A guest user selects Register and chooses to register as a regular user.
+**1.** Check if Email Already Exists
 
-**2.** The user enters personal details.
 
-**3.** The system creates the user with role USER.
+{{{#!sql
+SELECT COUNT(*)
+FROM user_entity
+WHERE email = :email;
+
+
+
+}}}
+
+
+**2.** Create New User Account.
 
 
 {{{#!sql
 INSERT INTO user_entity (first_name, last_name, email, password, role)
-VALUES ('John', 'Doe', 'john.doe@email.com', 'hashed_password', 'USER');
+VALUES (:firstName, :lastName, :email, :hashedPassword, 'USER');
 
+
+
+}}}
+
+
+
+**3.** Create Record in users Table.
+
+
+{{{#!sql
 INSERT INTO users (id)
 VALUES (currval('user_entity_id_seq'));