DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `login` varchar(16) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `secondEmail` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `ip` varchar(16) NOT NULL,
  `regIP` varchar(16) NOT NULL,
  `latest-auth` date DEFAULT NULL,
  `recovery` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `accounts`
--

INSERT INTO `accounts` (`id`, `login`, `password`, `email`, `secondEmail`, `name`, `admin`, `ip`, `regIP`, `latest-auth`, `recovery`) VALUES
(11, 'Scerka', '$2y$10$Fxajl.dNZIBKWvcOx8eWdeoAOks0Ilp1OI8LHEzoXYN4j/rxtoM4C', 'test@test.ru', 'test2@test.ru', 'Дмитрий', 1, '127.0.0.1', '127.0.0.1', NULL, NULL),
(12, 'test', '$2y$10$eM166.jBc.LBMNlMQBE72.XxoUgdcoUDCi4eHvPSJTkP3EHr.z1Ve', 'test@test.ru', NULL, NULL, 0, '127.0.0.1', '127.0.0.1', NULL, NULL),
(13, 'test73', '$2y$10$6sV/OEcs2O7WDOWgNmBrLuCajvWPwxCUgf8RbJLgemsaI6NeeyAnq', 'test73@test73.ru', 'test731@test.ru', NULL, 0, '127.0.0.1', '127.0.0.1', NULL, NULL),
(14, 'test731', '$2y$10$lsDIPbmfN6w8/LK/MAzJhemA5m0mg2fL9y.M8ALF6YG58Ah08EEMG', 'test731@test731.ru', 'test731@test73.ru', NULL, 0, '127.0.0.1', '127.0.0.1', NULL, NULL),
(15, 'demo', '$2y$10$vZXcKR8qhMBFHPwWD9T5AufvIxVKmbJdBa.kwKXNYeAtEfizsQpz.', 'sceri73@gmail.com', 'uvt-sc73@ya.ru', NULL, 1, '128.69.7.61', '128.69.7.61', NULL, NULL);