CREATE TABLE `Login` (
  `id` binary(36) NOT NULL,
  `firstname` varchar(200) COLLATE utf8_bin NOT NULL,
  `lastname` varchar(200) COLLATE utf8_bin NOT NULL,
  `email` varchar(400) COLLATE utf8_bin NOT NULL,
  `password` binary(60) NOT NULL,
  `group` int(1) NOT NULL,
  `username` varchar(200) COLLATE utf8_bin NOT NULL,
  `deleted` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N',
  `active` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'Y',
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE `Login`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`);