jaeyun0503 opened a new pull request, #3675: URL: https://github.com/apache/texera/pull/3675
## Summary In effort to improve admin dashboard and allow admins to view account creation time, a new column `acc_creation` is introduced to the table `time_log`. This attribute is meant to store the timestamp of a user's account creation time and is a required column of the table. Also to make sure that the account creation time is logged when a user creates account, a trigger is introduced to the database. Closes Issue #3673. ## For Developers Please do the following steps to incorporate with new changes: - Apply core/scripts/sql/updates/12.sql to your local postgres instance --- The current design of this functionality is to use a trigger `trg_time_log_autocreate` that executes function `time_log_autocreate` to add new data row to `time_log` when a new entry is added to `user`. The user's uid and the current time stamp will be logged into the table and based on the design the account creation time should not be able to be modified. Some SQL statements were also added to the sql files so that it gives the existing users the same timestamp as we do not have the information of the previous accounts' creation time. Improvements in future PRs: - Add time zone to the admin dashboard so the admin does not get confusion - Change the name of the `time_log` table to fit the naming convention of tables Screenshot: <img width="509" height="359" alt="User Role" src="https://github.com/user-attachments/assets/4d393ad3-7bac-4b95-9d86-af2d54d22645"; /> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
