Changes between Version 2 and Version 3 of ExistingAdmin

Timestamp:

08/24/26 16:06:46 (13 days ago)

Author:

211099

Comment:

--

ExistingAdmin

@@ -8 +8 @@
 **2.**  The system displays a list of all registered users.
 {{{#!sql
-SELECT user_id, username, email, name, surname
+SELECT user_id, username, email, user_name, surname
 FROM USERS
-ORDER BY created_at DESC;
+ORDER BY user_created_at DESC;
 }}}
 
@@ -17 +17 @@
 **4.** The system inserts a new record into the ADMINS table using the selected user's user_id.
 {{{#!sql
-INSERT INTO ADMINS (user_id)
-VALUES (1);
+INSERT INTO ADMINS (user_id, assigned_at)
+VALUES (1, CURRENT_TIMESTAMP);
 }}}
 
 **5.**  The system confirms the user has been successfully promoted to admin and sends them a notification.
 {{{#!sql
-INSERT INTO NOTIFICATION (content, is_read, created_at)
-VALUES ('You have been granted admin privileges on the platform.', FALSE, CURRENT_TIMESTAMP);
+INSERT INTO NOTIFICATION (notification_content, content_type, is_read, user_id, story_id, notification_created_at)
+VALUES ('You have been granted admin privileges on the platform.', 'admin_promotion', FALSE, 1, ?, CURRENT_TIMESTAMP);
 }}}