text: --
  -- Tabellenstruktur für Tabelle `users`
  --
  
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `passwort` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `vorname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ,
    `nachname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ,
    `class` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
    `passwortcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `passwortcode_time` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`), UNIQUE (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  
  CREATE TABLE `securitytokens` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `user_id` int(10) NOT NULL,
    `identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `securitytoken` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  
  INSERT INTO `users` (`id`, `email`, `passwort`, `vorname`, `nachname`, `class`, `created_at`, `updated_at`, `passwortcode`, `passwortcode_time`) VALUES
  (1, 'Max.Mustermann@web.de', '$2y$10$4vNiWskcBoWmX28ehfHH5utYJJGidFEtB1WeJTe/XVkzLnudUJAqK', 'Max', 'Mustermann', '2BKWI2', '2019-11-20 13:47:01', '2019-11-20 13:47:01', NULL, NULL);
  