Changes between Version 8 and Version 9 of UseCase001

Timestamp:

05/21/26 18:08:37 (6 days ago)

Author:

232012

Comment:

--

UseCase001

@@ -17 +17 @@
 {{{
 SELECT COUNT(*) 
-FROM User 
+FROM USERS 
 WHERE email = 'user@example.com';
 }}}
@@ -26 +26 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-INSERT INTO User (email, password, username, date_created) 
-VALUES ('user@example.com', 'hashed_password', 'NewUser', CURRENT_TIMESTAMP);
+INSERT INTO USERS (user_id, email, password, username, date_created) 
+VALUES (7, 'user@example.com', 'hashed_password', 'NewUser', CURRENT_DATE);
 }}}
 }}}
@@ -35 +35 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-INSERT INTO Consumer (user_id, points_collected) 
-VALUES (LAST_INSERT_ID(), 0);
+INSERT INTO CONSUMERS (user_id, points_collected) 
+VALUES (7, 0);
 }}}
 }}}