CREATE TABLE `users` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `Username` varchar(50) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `Firstname` varchar(50) NOT NULL,
  `Surname` varchar(50) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Hospital` varchar(255) NOT NULL,
  `Userlevel` int(11) NOT NULL,
  `Enabled` tinyint(1) NOT NULL,
  `Tasks` int(11) NOT NULL,
  `ContactAdmin` int(11) NOT NULL,
  `DrugShortages` int(11) DEFAULT NULL,
  `Preferences` varchar(11) NOT NULL,
  `LastLogin` date DEFAULT NULL,
  `PasswordChanged` int(1) DEFAULT NULL,
  `PreviousLogin` date DEFAULT NULL,
  `ValidationDate` date DEFAULT NULL,
  `WebSignup` tinyint(1) NOT NULL,
  `AdditionalField1` varchar(255) DEFAULT NULL,
  `AdditionalField2` varchar(255) DEFAULT NULL,
  `Authenticator` int(11) DEFAULT NULL,
  `Deleted` tinyint(1) NOT NULL,
  `GDPR_Consent` date DEFAULT NULL,
  `Activated` int(11) DEFAULT NULL,
  `Activation_String` varchar(255) DEFAULT NULL,
  `Activation_Date` date DEFAULT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1