Changes between Version 3 and Version 4 of UseCase001

Timestamp:

05/12/26 23:33:30 (2 weeks ago)

Author:

232012

Comment:

--

UseCase001

@@ -14 +14 @@
 2. System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards.
 
+{{{
+SELECT COUNT(*) 
+FROM User 
+WHERE email = 'user@example.com';
+}}}
+
 3. System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}.
+
+{{{
+INSERT INTO User (email, password, username, date_created) 
+VALUES ('user@example.com', 'hashed_password', 'NewUser', CURRENT_TIMESTAMP);
+}}}
 
 4. System initializes a corresponding entry in the {{{Consumer table}}}, setting the {{{points_collected}}} to zero and establishing the one-to-one relationship with the new {{{user_id}}}.
 
+{{{
+INSERT INTO Consumer (user_id, points_collected) 
+VALUES (LAST_INSERT_ID(), 0);
+}}}
+
 5. System confirms the successful account creation and automatically logs the user in.
 }}}