Roi777 table #5

--
-- Database: `admin_default`
-- roi777.com

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

--
-- Table structure for table `keitaro_users`
--

CREATE TABLE `keitaro_users` (
  `id` int(11) NOT NULL,
  `type` enum('ADMIN','USER') NOT NULL DEFAULT 'USER',
  `login` varchar(50) NOT NULL,
  `password` varchar(32) NOT NULL,
  `password_hash` varchar(255) DEFAULT NULL,
  `permissions` varchar(255) DEFAULT NULL,
  `rules` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `keitaro_users`
--

INSERT INTO `keitaro_users` (`id`, `type`, `login`, `password`, `password_hash`, `permissions`, `rules`) VALUES
(1, 'ADMIN', 'admin', '774b12b7fa8cda05840713d62de7d8be', '$2y$10$k.LjKUT.snuff2JKh55JROMuoQpdy9DbVyTGQk5svd9tHUxv9Ts7K', NULL, '[{\"id\":\"30\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"49\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"53\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"69\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"163\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"165\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"166\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"178\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"182\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"199\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"250\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"261\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"262\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"267\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"273\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"274\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"275\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"276\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"277\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"278\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"285\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"287\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"288\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"294\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"300\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"302\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"304\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"313\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"315\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"316\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"317\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"326\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"330\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"331\",\"permissions\":[\"edit\",\"delete\",\"reports\"]},{\"id\":\"337\",\"permissions\":[\"edit\",\"delete\",\"reports\"]}]'),
(2, 'USER', 'Filinski', '8c2c4ceec5d728cb9fffb1f17607a9be', NULL, NULL, '[{\"permissions\":[\"reports\"],\"id\":\"326\"},{\"permissions\":[\"reports\"],\"id\":\"256\"}]'),
(3, 'USER', 'cosl', '52529132fe3851bde5044d8d3c800bdc', NULL, NULL, '[{\"permissions\":[\"reports\"],\"id\":\"278\"},{\"permissions\":[\"reports\"],\"id\":\"277\"},{\"permissions\":[\"reports\"],\"id\":\"276\"},{\"permissions\":[\"reports\"],\"id\":\"275\"},{\"permissions\":[\"reports\"],\"id\":\"274\"},{\"permissions\":[\"reports\"],\"id\":\"273\"}]'),
(4, 'USER', 'stahanov', '583113185bdcac304f1f75f1d0a4e85a', NULL, NULL, '[{\"permissions\":[\"reports\"],\"id\":\"300\"}]'),
(5, 'USER', 'roi888', '21041aa198402a097dc9c61418efcd8c', NULL, '[\"view_dashboard\"]', '[{\"permissions\":[\"reports\"],\"id\":\"295\"}]'),
(6, 'USER', 'karl', '1a21f0d5f9716ec85f8b2456db0efe95', NULL, '[\"view_dashboard\"]', '[{\"permissions\":[\"reports\"],\"id\":\"304\"}]'),
(7, 'USER', '301', '3783c626c8e989a54c8a991e599c95cc', NULL, '[\"view_dashboard\"]', '[{\"permissions\":[\"reports\"],\"id\":\"301\"}]'),
(8, 'USER', 'san', '491b3be516cd5f2d0be83eded19d8d82', NULL, NULL, '[{\"permissions\":[\"reports\"],\"id\":\"317\"}]'),
(9, 'USER', 'lama', '28f2b6342492212906a26b4e9bf37362', NULL, '[\"view_dashboard\"]', '[{\"permissions\":[\"reports\"],\"id\":\"295\"}]'),
(10, 'USER', 'lamalama', '28f2b6342492212906a26b4e9bf37362', NULL, '[\"view_dashboard\"]', '[{\"permissions\":[\"reports\"],\"id\":\"295\"}]'),
(11, 'USER', 'alex', '5a96aee52299cf575d74649e2c958b26', NULL, '[\"view_dashboard\"]', '[{\"permissions\":[\"reports\"],\"id\":\"267\"},{\"permissions\":[\"reports\"],\"id\":\"330\"}]');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `keitaro_users`
--
ALTER TABLE `keitaro_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login` (`login`,`password`),
  ADD KEY `type` (`type`);

--
-- AUTO_INCREMENT for dumped tables
--