 
 CREATE TABLE `accounts` (
   `id` int(11) NOT NULL,
-  `mail` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_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,
+  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_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

-- テーブルのデータのダンプ `touchedlog`
--

INSERT INTO `touchedlog` (`IDm`, `timestamp`) VALUES
('01010214E014EE21', 1481262982);

-- --------------------------------------------------------


ALTER TABLE `accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `touchedlog`
--
ALTER TABLE `touchedlog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `whitelist`
--
ALTER TABLE `whitelist`
