7QCTFwFH

1DROP TABLE IF EXISTS `accounts`;
2CREATE TABLE `accounts` (
3  `id` int(11) NOT NULL,
4  `login` varchar(16) NOT NULL,
5  `password` varchar(255) NOT NULL,
6  `email` varchar(255) NOT NULL,
7  `secondEmail` varchar(255) DEFAULT NULL,
8  `name` varchar(255) DEFAULT NULL,
9  `admin` tinyint(1) NOT NULL DEFAULT '0',
10  `ip` varchar(16) NOT NULL,
11  `regIP` varchar(16) NOT NULL,
12  `latest-auth` date DEFAULT NULL,
13  `recovery` varchar(255) DEFAULT NULL
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15
16--
17-- Дамп данных таблицы `accounts`
18--
19
20INSERT INTO `accounts` (`id`, `login`, `password`, `email`, `secondEmail`, `name`, `admin`, `ip`, `regIP`, `latest-auth`, `recovery`) VALUES
21(11, 'Scerka', '$2y$10$Fxajl.dNZIBKWvcOx8eWdeoAOks0Ilp1OI8LHEzoXYN4j/rxtoM4C', 'test@test.ru', 'test2@test.ru', 'Дмитрий', 1, '127.0.0.1', '127.0.0.1', NULL, NULL),
22(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),
23(13, 'test73', '$2y$10$6sV/OEcs2O7WDOWgNmBrLuCajvWPwxCUgf8RbJLgemsaI6NeeyAnq', 'test73@test73.ru', 'test731@test.ru', NULL, 0, '127.0.0.1', '127.0.0.1', NULL, NULL),
24(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),
25(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);