text: -- phpMyAdmin SQL Dump
  -- version 4.6.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: mysql
  -- Generation Time: 2016 年 12 月 19 日 08:44
  -- サーバのバージョン： 5.7.17
  -- PHP Version: 5.6.26
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `app`
  --
  
  -- --------------------------------------------------------
  
  --
  -- テーブルの構造 `accounts`
  --
  
  CREATE TABLE `accounts` (
    `id` int(11) 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(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
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- テーブルのデータのダンプ `accounts`
  --
  
  INSERT INTO `accounts` (`id`, `mail`, `username`, `nickname`, `password`, `autority`, `isvalid`, `checkstring`) VALUES
  (1, 'test@test.test', 'test', 'passistest1234', '$2y$10$hBMWXvnGnKVARXenJD6oG.uevszX0HfHGHbgBx5NZ0Bz2QtoduZv.', 'guest', 1, 'xvdzstfklxrqsng93agbcb9tg4i72clr');
  
  -- --------------------------------------------------------
  
  --
  -- テーブルの構造 `nfctag`
  --
  
  CREATE TABLE `nfctag` (
    `IDm` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `account_id` int(8) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- テーブルの構造 `touchedlog`
  --
  
  CREATE TABLE `touchedlog` (
    `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;
  
  --
  -- テーブルのデータのダンプ `touchedlog`
  --
  
  INSERT INTO `touchedlog` (`id`, `IDm`, `timestamp`) VALUES
  (1, '01010214E014EE21', 1481262982);
  
  -- --------------------------------------------------------
  
  --
  -- テーブルの構造 `whitelist`
  --
  
  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;
  
  --
  -- テーブルのデータのダンプ `whitelist`
  --
  
  INSERT INTO `whitelist` (`id`, `mail`) VALUES
  (1, 'test@test.test');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `accounts`
  --
  ALTER TABLE `accounts`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `mail` (`mail`);
  
  --
  -- Indexes for table `nfctag`
  --
  ALTER TABLE `nfctag`
    ADD PRIMARY KEY (`IDm`);
  
  --
  -- Indexes for table `touchedlog`
  --
  ALTER TABLE `touchedlog`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `whitelist`
  --
  ALTER TABLE `whitelist`
    ADD PRIMARY KEY (`id`),
    ADD KEY `mail` (`mail`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `accounts`
  --
  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`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  