boka3/evolutions/005-user-add-creationtime.sql
Erik Thuning 57cb0b0076 Implemented automatic removal of old users' PII.
This entailed adding a new routine in include/Cron.php that checks for old
users and purges their username and notes.

As part of this some other changes were necessary:
 - Introduced a creation time for users, so it's possible to distinguish
   between an old user with no loans and a new user with no loans.
 - The user.name field in the database now allows null values.
2025-09-23 16:46:32 +02:00

2 lines
80 B
SQL

alter table `user` add column `created` bigint(20) not null default 1735686000;