 --
 
 CREATE TABLE `touchedlog` (
-  `IDm` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
+  `id` int(11) NOT NULL,
+  `IDm` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
   `timestamp` int(11) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 


CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `mail` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nickname` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  `autority` enum('guest','member','manager','admin') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'guest',
  `isvalid` tinyint(1) NOT NULL DEFAULT '0',
  `checkstring` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL


CREATE TABLE `whitelist` (
  `id` int(11) NOT NULL,
  `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
