Enhance PHP Customeradmin & License Management -- 2

Create / fix the current customeradmin.php which has the purpose to manage the customers and assign licenses . As an addition all functions are handled in customerhandler.php . all customer activities, get / edit / create assign licence, extend licence should be logged. We are using PHP and MariaDB . there are the databases:

DESCRIBE Customers;

CustomerID int(11) NO PRI NULL auto_increment
CompanyName varchar(200) NO UNI NULL
Address text NO NULL
Country varchar(100) NO NULL
City varchar(100) NO NULL
PostCode varchar(20) NO NULL
ContactPerson varchar(200) NO NULL
ContactPhone varchar(50) NO NULL
ContactEmail varchar(255) NO NULL
InvoicingEmail varchar(255) NO NULL
LicenseType enum('Basic','Business','Professional') NO NULL
DataControllersNoLicense int(11) NO NULL
DataControllersEditAllowed tinyint(1) NO 0
GDPRActiveNoLicense int(11) NO 1
WebPublishingLicense tinyint(1) NO 0
ConsentLicense tinyint(1) NO 0
LicenseActiveFrom date NO NULL
LicenseActiveTo date NO NULL
DPOResellerCustomer tinyint(1) NO 0
DPOResellerID int(11) YES NULL
LinkedToProfessionalLicense tinyint(1) NO 0
ProfessionalLicenseID int(11) YES NULL
IsActive tinyint(1) NO MUL 0
CreatedAt timestamp NO current_timestamp()
UpdatedAt timestamp NO current_timestamp() on update current_timestamp()


Your SQL query has been executed successfully.

DESCRIBE Customer_Log;

LogID int(11) NO PRI NULL auto_increment
CustomerID int(11) NO MUL NULL
UserID int(11) NO MUL NULL
UserType enum('admin','dpo','customer') NO NULL
ActionType varchar(50) NO MUL NULL
ActionDescription text NO NULL
OldValues text YES NULL
NewValues text YES NULL
IPAddress varchar(45) NO NULL
CreatedAt timestamp NO MUL current_timestamp()