-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 20, 2016 at 06:11 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

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 utf8 */;

--
-- Database: `membership`
--

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

--
-- Table structure for table `group_permissions`
--

CREATE TABLE IF NOT EXISTS `group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `none_all` tinyint(1) NOT NULL,
  `can_view` tinyint(1) NOT NULL,
  `can_add` tinyint(1) NOT NULL,
  `can_edit` tinyint(1) NOT NULL,
  `can_delete` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=139 ;

--
-- Dumping data for table `group_permissions`
--

INSERT INTO `group_permissions` (`id`, `group_id`, `module_id`, `none_all`, `can_view`, `can_add`, `can_edit`, `can_delete`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(40, 7, 1, 0, 1, 1, 0, 0, '2016-12-14 05:15:41', 34, '2016-12-14 05:15:41', 0),
(41, 7, 2, 0, 1, 1, 0, 0, '2016-12-14 05:15:41', 34, '2016-12-14 05:15:41', 0),
(42, 7, 3, 0, 1, 1, 0, 0, '2016-12-14 05:15:41', 34, '2016-12-14 05:15:41', 0),
(43, 7, 4, 0, 1, 1, 0, 0, '2016-12-14 05:15:41', 34, '2016-12-14 05:15:41', 0),
(44, 7, 5, 0, 1, 0, 0, 0, '2016-12-14 05:15:41', 34, '2016-12-14 05:15:41', 0),
(80, 6, 3, 0, 0, 1, 0, 0, '2016-12-16 02:42:32', 34, '2016-12-16 02:42:32', 0),
(127, 5, 1, 0, 1, 0, 0, 0, '2016-12-19 06:33:30', 34, '2016-12-19 06:33:30', 0),
(128, 5, 2, 0, 1, 0, 0, 0, '2016-12-19 06:33:30', 34, '2016-12-19 06:33:30', 0),
(129, 5, 3, 0, 1, 0, 0, 0, '2016-12-19 06:33:30', 34, '2016-12-19 06:33:30', 0),
(130, 5, 4, 0, 1, 0, 0, 0, '2016-12-19 06:33:30', 34, '2016-12-19 06:33:30', 0),
(131, 5, 5, 0, 1, 0, 0, 0, '2016-12-19 06:33:30', 34, '2016-12-19 06:33:30', 0),
(132, 8, 1, 0, 1, 1, 0, 0, '2016-12-19 06:48:16', 34, '2016-12-19 06:48:16', 0),
(133, 8, 2, 0, 1, 1, 0, 0, '2016-12-19 06:48:16', 34, '2016-12-19 06:48:16', 0),
(134, 8, 3, 0, 1, 1, 1, 0, '2016-12-19 06:48:16', 34, '2016-12-19 06:48:16', 0),
(135, 8, 4, 0, 1, 1, 1, 1, '2016-12-19 06:48:16', 34, '2016-12-19 06:48:16', 0),
(136, 8, 5, 0, 1, 0, 0, 0, '2016-12-19 06:48:16', 34, '2016-12-19 06:48:16', 0),
(137, 9, 1, 0, 1, 1, 1, 1, '2016-12-19 06:49:09', 34, '2016-12-19 06:49:09', 0),
(138, 9, 2, 0, 1, 1, 1, 1, '2016-12-19 06:49:09', 34, '2016-12-19 06:49:09', 0);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2014_10_12_000000_create_users_table', 1),
('2014_10_12_100000_create_password_resets_table', 1),
('2016_02_01_152631_create_laravel_table', 1);

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

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(200) DEFAULT NULL,
  `can_add` tinyint(1) DEFAULT '0',
  `can_view` tinyint(1) DEFAULT '0',
  `can_edit` tinyint(1) DEFAULT '0',
  `can_delete` tinyint(1) DEFAULT '0',
  `order` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `module_name`, `can_add`, `can_view`, `can_edit`, `can_delete`, `order`) VALUES
(1, 'user_group', 1, 1, 1, 1, 1),
(2, 'user', 1, 1, 1, 1, 2),
(3, 'system_setting', 1, 1, 1, 0, 100),
(4, 'lessor', 1, 1, 1, 1, 3),
(5, 'report', 0, 1, 0, 0, 0);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `role_id` int(11) NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=99 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `username`, `password`, `role_id`, `picture`, `remember_token`, `state`, `is_deleted`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(34, 'Botin POV', 'botin.pov@gmail.com', '011409065', 'Botin.pov', '$2y$10$meLkWUAZnmsoGnB0DDHmaOj0w9E8YDWUpyC6jY75jzU/QL2g8J0cG', 5, '', '31EF71UO0EHopwNg4fmvRYR0yLjzU2h2z9586DVHinAmMaR5EtMe1rQd36jB', 0, 0, '2016-11-28 18:59:10', 0, '2016-12-19 20:04:36', NULL),
(35, 'srey lines', 'srey.pov@gmail.com', '011409065', 'sreyline', '$2y$10$.y7oDLhdFab8KIHFxuEt7eoLLeAvbvq/rw6Xl7K9CqWoApvLsKaS2', 0, '', NULL, 0, 1, '2016-11-29 23:52:18', 0, '2016-12-08 21:21:31', NULL),
(37, 'oun line', 'oun.line@gmail.com', '070214315', 'Ounline', '$2y$10$yTLzjMcl3vanhx.gKdGo7uPNrgsmOe6O.19XiV.WxHe/NyvZUdjAO', 0, '', NULL, 0, 1, '2016-11-30 02:20:27', 0, '2016-12-08 21:21:26', NULL),
(38, 'Botin POVs', 'botin.pov@gmail.coms', '11111111', 'botinss', '$2y$10$bINgwu2O6R1aDXkHnD9ifOgspI8qcAL2U2BvkYYirutrrH6/yJIKG', 0, '', NULL, 0, 1, '2016-11-30 02:37:30', 0, '2016-12-07 23:56:04', NULL),
(39, 'Test POvs', 'test.pov@gmail.com', '01111111111', 'Testpov2', '$2y$10$Juh1cb6CK5p.ukh.R2FihOIh6dy2LCBU4BsP9NgJEcy6qhsJNCwFm', 0, '', NULL, 0, 1, '2016-11-30 20:11:32', 0, '2016-12-07 23:55:59', NULL),
(40, 'admin Botin', 'admin.botin@gmail.com', '012345678', 'Botin_admin', '$2y$10$WGee.uznFLZP0b3T08vN1.FAJALw9Y8.lm44V1Fv1A0omUff9SQbS', 0, '', NULL, 0, 1, '2016-12-01 00:46:52', 0, '2016-12-07 23:55:51', NULL),
(47, 'Botin Botin', 'botin.botin@gmail.com', '011223344', 'Botinpov1', '$2y$10$7ECfN..Q4cfYNJJAU5GTO.ILXNTfSWq2B/2sOXOddOOPb8.x5K7fK', 0, '', NULL, 0, 1, '2016-12-01 21:08:36', 0, '2016-12-07 23:57:08', NULL),
(48, 'gggggggggg', 'ggg@gmail.com', '11111111111', 'gggggggggggg', '$2y$10$A9nes0ByoQ8VYGqyCSRqwubNZS7FFi.NOdnWl2CFycN7vpz6ww36q', 0, '', NULL, 0, 1, '2016-12-01 21:12:20', 0, '2016-12-07 23:55:29', NULL),
(49, 'rambo168', 'simchhayrambo@gmail.com', '016223278', 'chhayrambo', '$2y$10$OK9EnVMqAg35eFTxCUML6OkPTnVglAAz9TnwrN5GjdUGmyG12p9mq', 0, '', NULL, 0, 1, '2016-12-02 01:38:37', 0, '2016-12-07 23:57:11', NULL),
(52, 'Create user', 'create.user@gmail.com', '123456789', 'Create user', '$2y$10$5yKaoVmge1EH1jorRW2UGO0m5hIuXEODxhaNTOys9LRsnXf0CjvRW', 0, '', NULL, 1, 1, '2016-12-04 20:47:09', 0, '2016-12-07 23:54:33', NULL),
(53, 'Create users', 'create.users@gmail.com', '123456789', 'Create users', '$2y$10$1ImKP94cxRI.sE/Z5TPK1e6x4C5ub2B9GYNuBelMr1lCZB2KP1s7u', 0, '', NULL, 1, 1, '2016-12-04 20:47:56', 0, '2016-12-07 23:57:04', NULL),
(54, 'new User', 'new.user@mail.com', '111111111', 'NEW USER ', '$2y$10$Ce9yPUalhbAg7i/7XtrNOeHWXBPxtvpRj3qehBYHM5JNnO.yB0Seu', 0, '', NULL, 1, 1, '2016-12-04 20:50:01', 0, '2016-12-07 23:57:00', NULL),
(55, 'srey na', 'srey.na@gmail.com', '101010101', 'SREY NA', '$2y$10$OKD163nyNLyhNs2S7qzEsee/IvaAwz/gBj2ug5b/DmmfVGlb41eeq', 0, '', NULL, 1, 1, '2016-12-04 21:21:58', 0, '2016-12-07 23:56:56', NULL),
(56, 'srey nas', 'srey.nas@gmail.com', '101010101', 'SREY NAs', '$2y$10$LK3p0YMpS/uqRQLE9GoInusrMb7i/HsMwE43nXh.Ze11ix95pMlTa', 0, '', NULL, 1, 1, '2016-12-04 21:23:08', 0, '2016-12-07 23:56:52', NULL),
(57, 'mytest', 'mytest@mail.com', '123456789', 'mytest', '$2y$10$cXF40kAA6oEfEoClYbmrgOMBZESAgrM0dgLiHooCHNnPpN0q7G.iK', 0, '', NULL, 1, 1, '2016-12-06 02:56:49', 0, '2016-12-07 23:56:42', NULL),
(58, 'mytests', 'mytests@mail.com', '123456789', 'mytests', '$2y$10$5x1E.Yza6TRL3hU.OE02lOvwBw2F1HAxe2kToMCiW10Hl32v/r1Wq', 0, '', NULL, 1, 1, '2016-12-06 02:57:36', 0, '2016-12-07 23:56:36', NULL),
(59, 'gbgbgb', 'gbgbgb@gbgb.com', '123456789', '1234567', '$2y$10$Ib843WxBPZuaQOg4AvrFx.uTKkcFXP6HxcFSS1tURGyGc45x/aelO', 0, '', NULL, 1, 1, '2016-12-06 02:59:41', 0, '2016-12-07 23:56:29', NULL),
(60, 'show mane', 'show.mane@gmail.com', '123456789', 'showmane', '$2y$10$FoGH2lwGsWu3zMAZ1CvfOekKY1nGtQPsVaswLPnbIrRAeDxvnipzK', 0, '', NULL, 1, 1, '2016-12-06 03:05:01', 0, '2016-12-07 23:55:46', NULL),
(73, 'so pheak', 'so.pheak@gmail.com', '012341234', 'So pheak', '$2y$10$cszhhIKXwkoDye8dYSauXuDN92ku8jpskKV/DdKOgSBMrkslhhGJq', 0, '', 'd6Y83by10nniHXSGVwufqgkzzoLS5Fq3uBqQGrn2U2TGYjosZQ9UlwdRTeDk', 1, 1, '2016-12-07 23:59:11', 0, '2016-12-08 21:21:22', NULL),
(74, 'myfirstTest', 'myfirstTest@gmail.com', '010101000011', 'myfirstTest', '$2y$10$kP5ylBGHLxYF5bo1GB62tuaNBcj7H6xhGJphS7NltC4WqU3DDk2iC', 0, '', NULL, 1, 1, '2016-12-08 03:12:13', 0, '2016-12-08 03:20:23', NULL),
(75, 'myfirstTests', 'myfirstTests@gmail.com', '010101000011', 'myfirstTests', '$2y$10$qx/4XVbRs2OoVFVyrMLiXumewq1yPTnT70nMyMrmEAeeDYSySc7qu', 0, '', NULL, 1, 1, '2016-12-08 03:12:52', 0, '2016-12-08 03:20:17', NULL),
(76, 'mySecondTest', 'mySecrndTest@gmail.com', '010101000011', 'mySecordTest', '$2y$10$3.6JqtdzqDtNFVbsAVbX7upf3njWUivayaZaiL/jO90BJrdZ37GyK', 0, '', NULL, 1, 1, '2016-12-08 03:17:59', 0, '2016-12-08 03:20:13', NULL),
(77, 'mySecondTests', 'mySecrndTest@gmail.coms', '010101000011', 'mySecordTests', '$2y$10$IBuBaTwtWtab89rO3nfZeupnAxps5D2x8GfV0KySA6jdmC62ThUQG', 0, '', NULL, 1, 1, '2016-12-08 03:19:31', 0, '2016-12-08 03:20:09', NULL),
(78, 'mymy', 'mymy@gmail.com', '01111011111', 'MYMYMY', '$2y$10$zKQ5mw79l5cMSU/iaAeNa.yn4VQ8w3rBLlfZJWulm.Xz1oBbeYcdu', 0, '', NULL, 1, 1, '2016-12-08 03:23:55', 0, '2016-12-08 03:24:13', NULL),
(79, 'hongda', 'hongda@gmail.com', '011223344', 'Hong Da', '$2y$10$U22mjnu.GkBAez9U2..EF.5qBiUgXLXVXWF0Z3.bCEGe973aE4Nju', 0, '', NULL, 1, 1, '2016-12-08 03:25:06', 0, '2016-12-08 21:21:18', NULL),
(80, 'srey ya', 'srey.ya@gmail.com', '001234567', 'Srey ya', '$2y$10$hAIBXf9YmRFUH1vMIE4hf.GBiHhzfQagG0nI6qP.1KlI4o0Nldi2S', 0, '', NULL, 1, 1, '2016-12-08 18:42:42', 0, '2016-12-08 19:14:44', NULL),
(81, 'srey yas', 'srey.yas@gmail.com', '001234567', 'Srey yas', '$2y$10$3BYyF5MOqMFMsko5wxT6UuSnCYG/cxvSsxdxhShu0mbpaqH/0k/2S', 0, '', NULL, 1, 1, '2016-12-08 19:01:35', 0, '2016-12-08 19:14:18', NULL),
(82, 'srey yass', 'srey.yass@gmail.com', '001234567', 'Srey yass', '$2y$10$JSLtZjwGyZ4GP.EmeiJn.eF4Yvh3DDSAalNiPQqiftCF62uyZfGaW', 0, '', NULL, 1, 1, '2016-12-08 19:02:51', 0, '2016-12-08 19:14:35', NULL),
(83, 'srey yass', 'srey.yasss@gmail.com', '001234567', 'Srey yasss', '$2y$10$jhuMeGJZB1J58mhi1b5CaOV9iLjDlKN74pyzLn2KEENwas08mCpFy', 0, '', NULL, 1, 1, '2016-12-08 19:03:57', 0, '2016-12-08 19:14:31', NULL),
(84, 'srey yass', 'srey.yassss@gmail.com', '001234567', 'Srey yassss', '$2y$10$exoPsT8dWb9gK.jXOHDs.OqETmP0JwIy9r5.KUW2m.BvXiSOfPYB2', 0, '', NULL, 1, 1, '2016-12-08 19:04:36', 0, '2016-12-08 19:14:24', NULL),
(85, 'tin sreyda', 'tin.sreyda@gmail.com', '011409065', 'Tin sreyda', '$2y$10$MIcRAZLnyghBQiAA8G4QsOTpdH2OlE1wTX5Qsd.sNj/yAbkFZxI7i', 0, '', NULL, 1, 1, '2016-12-08 19:19:46', 0, '2016-12-08 21:21:10', NULL),
(87, 'Bo Sreyda', 'Bo.sreyda@gmail.com', '011223344', 'Bo Srey da', '$2y$10$vCIqK1Gm.MJUdP.zfhZeherc1LUSdGgXhCnWIp3Qm1XEwQvULMHfS', 0, '', NULL, 1, 1, '2016-12-08 19:36:05', 0, '2016-12-08 21:21:02', NULL),
(88, 'Botin POV2', 'botin.pov2@gmail.com', '0966497288', 'botin.pov2', '$2y$10$m49qCKiexO3rYbzAej6JbOfHZgQLSQB84ytdgfa8t6u8yZO.hjrJq', 0, '', 'Yck4ox9i3ADmp038EBjm3RNHA2PRgQo22Tp6hkDz6x2oWQd9wlAaHGYQmwfr', 1, 0, '2016-12-08 20:25:02', 0, '2016-12-09 00:01:07', NULL),
(89, 'Botin POV3', 'botin.pov3@gmail.com', '012345678', 'botin.pov3', '$2y$10$AjVWk6cyuF.KuuqO.MaTUuuI/VjoOqRf9AIjn/R28cEvxVNwUPIUm', 0, '', 'wLSJ0Ax50uP2QtnruN1WPIU6czKbQYMudci8gxLAYMLpZxXEzhT7rn1H3EoZ', 1, 1, '2016-12-08 23:58:54', 88, '2016-12-09 00:55:05', NULL),
(90, 'Botin POv4', 'botin.pov4@gmail.com', '012345612', 'Botin.pov4', '$2y$10$XcrskG7bAv/HEAnwg5n.Y.ql1JwqjIlZjxbNvIeBcw/ZZBG2pOXEe', 0, '', NULL, 1, 1, '2016-12-12 03:02:42', 34, '2016-12-12 21:32:28', NULL),
(91, 'Test Permission ', 'test.permission@gamil.com', '12345678', 'Test.permission', '$2y$10$WZM8a0Luo0lKNSFVFuCPNeMgBQICk/MGZfksoGiqO4TH5PemM8nja', 0, '', NULL, 1, 1, '2016-12-12 20:19:58', 34, '2016-12-12 21:22:11', NULL),
(92, 'manav ebabi', 'manav.ebabi@gmail.com', '011309057', 'manava', '$2y$10$u1xFvbhRh7Xdk/6Zz5fEIufAz77pPSR/3aus7SYUeyEtDjU0lGF.S', 0, '', NULL, 1, 1, '2016-12-12 20:22:47', 34, '2016-12-12 21:22:04', NULL),
(93, 'bunheang', 'bunheang@gmail.com', '01122334455', 'bunheang', '$2y$10$iNFA430zX5W/aYpg7X4.gOWwShnYgtkaf670dPqfUOs2ciTofr.Cu', 0, '', NULL, 1, 1, '2016-12-12 20:29:39', 34, '2016-12-12 21:21:57', NULL),
(94, 'buntehn', 'buntehn@gamil.com', '122334455', 'buntehn', '$2y$10$rL70ZXFvRBHyprZHVhKdo.pFVrfbMjf7JWObURl4bRV91JlnfpKca', 0, '', NULL, 1, 1, '2016-12-12 20:32:23', 34, '2016-12-12 21:21:43', NULL),
(95, 'doch', 'doch@mail.com', '011334455', 'Mr. Doch', '$2y$10$wkC.XaFZbrgHcYr3Q//yxOgPqIq2j34uSYvaqb5GVOeoajPJFJ7DC', 0, '', NULL, 1, 1, '2016-12-12 21:45:36', 34, '2016-12-13 01:29:37', NULL),
(96, 'Chomren', 'chomren@gmail.com', '011229034', 'Chomren', '$2y$10$9MsBSHzDfgs9mF1pM4EcD.GGniN/Ato6ZbQ6arAjUUhdTTYlQZW7C', 0, '', NULL, 1, 1, '2016-12-13 00:00:44', 34, '2016-12-13 01:29:41', NULL),
(97, 'Select test', 'select.test@gmail.com', '123456', 'select Test', '$2y$10$h2UjHx7c87EXund9FCep2.djZ49VJfUpQUeerd7UUpIfOC3jQXZhu', 7, '', NULL, 1, 0, '2016-12-18 20:09:44', 34, '2016-12-18 20:09:44', NULL),
(98, 'myfirst Select', 'myfirstSelect@gmail.com', '0114090656', 'myfirst Select', '$2y$10$/z02HSt/JxDnrPliOodtk.1l.Tc/WUWksWVO5IQNf0gMbiE8bVpxe', 8, '', NULL, 1, 0, '2016-12-18 23:23:51', 34, '2016-12-19 20:00:28', NULL);

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE IF NOT EXISTS `user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(15) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(2000) DEFAULT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `user_groups`
--

INSERT INTO `user_groups` (`id`, `code`, `name`, `description`, `state`, `is_deleted`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Olala_01', 'Olala', 'yes it is group olala', 1, 1, '2016-12-12 04:00:20', '2016-12-13 08:28:40', 34, NULL),
(2, 'coco_03', 'coco', '   this is a group coco for us.', 1, 1, '2016-12-12 08:43:38', '2016-12-13 08:28:46', 34, 34),
(3, 'COCO_02', 'Group CoCO', '  this is a group coco for us.', 1, 1, '2016-12-12 09:15:50', '2016-12-12 09:18:18', 0, 34),
(4, 'ADMIN_02', 'ADMIN', 'this group, we keep it for user admin.', 1, 1, '2016-12-13 07:56:05', '2016-12-13 07:59:38', 34, NULL),
(5, 'ADMIN_03', 'ADMIN3', '       this group, we keep it for user admin.', 1, 0, '2016-12-13 07:58:39', '2016-12-19 06:33:30', 34, 34),
(6, 'SALE_01', 'Sale', '      this group create  seller .', 1, 0, '2016-12-13 08:16:34', '2016-12-16 02:42:32', 34, 34),
(7, 'Account_1', 'Account', ' user for accnount', 1, 0, '2016-12-13 09:36:05', '2016-12-14 05:15:40', 34, 34),
(8, 'Testing_1', 'Testing group', '               testing group', 1, 0, '2016-12-15 02:18:25', '2016-12-19 06:48:15', 34, 34),
(9, 'Admin_04', 'Basic Admin', '', 1, 0, '2016-12-19 06:49:09', '2016-12-19 06:49:09', 34, NULL);

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

--
-- Table structure for table `user_permissions`
--

CREATE TABLE IF NOT EXISTS `user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `can_add` tinyint(1) NOT NULL,
  `can_edit` tinyint(1) NOT NULL,
  `can_delete` tinyint(1) NOT NULL,
  `can_view` tinyint(1) NOT NULL,
  `none_all` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=374 ;

--
-- Dumping data for table `user_permissions`
--

INSERT INTO `user_permissions` (`id`, `user_id`, `permission_id`, `can_add`, `can_edit`, `can_delete`, `can_view`, `none_all`, `created_at`, `updated_at`) VALUES
(3, 47, 1, 1, 1, 1, 1, 0, '2016-12-02 04:08:36', '2016-12-02 04:08:36'),
(4, 47, 2, 1, 1, 1, 1, 0, '2016-12-02 04:08:36', '2016-12-02 04:08:36'),
(5, 47, 3, 1, 1, 1, 1, 0, '2016-12-02 04:08:36', '2016-12-02 04:08:36'),
(6, 47, 4, 1, 1, 1, 1, 0, '2016-12-02 04:08:36', '2016-12-02 04:08:36'),
(7, 47, 5, 1, 1, 1, 1, 0, '2016-12-02 04:08:36', '2016-12-02 04:08:36'),
(8, 48, 1, 0, 0, 0, 1, 0, '2016-12-02 04:12:20', '2016-12-02 04:12:20'),
(9, 48, 5, 0, 0, 0, 1, 0, '2016-12-02 04:12:20', '2016-12-02 04:12:20'),
(10, 49, 1, 1, 0, 0, 0, 0, '2016-12-02 08:38:38', '2016-12-02 08:38:38'),
(11, 49, 2, 1, 0, 0, 0, 0, '2016-12-02 08:38:38', '2016-12-02 08:38:38'),
(12, 49, 3, 1, 0, 0, 0, 0, '2016-12-02 08:38:38', '2016-12-02 08:38:38'),
(13, 49, 4, 1, 0, 0, 0, 0, '2016-12-02 08:38:38', '2016-12-02 08:38:38'),
(16, 52, 1, 1, 0, 0, 1, 0, '2016-12-05 03:47:09', '2016-12-05 03:47:09'),
(17, 52, 2, 1, 0, 0, 1, 0, '2016-12-05 03:47:09', '2016-12-05 03:47:09'),
(18, 52, 3, 1, 0, 0, 1, 0, '2016-12-05 03:47:09', '2016-12-05 03:47:09'),
(19, 52, 4, 1, 0, 0, 1, 0, '2016-12-05 03:47:09', '2016-12-05 03:47:09'),
(20, 52, 5, 1, 0, 0, 1, 0, '2016-12-05 03:47:09', '2016-12-05 03:47:09'),
(21, 53, 1, 0, 0, 0, 1, 0, '2016-12-05 03:47:56', '2016-12-05 03:47:56'),
(22, 53, 2, 0, 0, 0, 1, 0, '2016-12-05 03:47:56', '2016-12-05 03:47:56'),
(23, 53, 3, 0, 0, 0, 1, 0, '2016-12-05 03:47:56', '2016-12-05 03:47:56'),
(24, 53, 4, 0, 0, 0, 1, 0, '2016-12-05 03:47:56', '2016-12-05 03:47:56'),
(25, 53, 5, 0, 0, 0, 1, 0, '2016-12-05 03:47:56', '2016-12-05 03:47:56'),
(26, 54, 1, 0, 0, 0, 1, 0, '2016-12-05 03:50:01', '2016-12-05 03:50:01'),
(27, 54, 2, 0, 0, 0, 1, 0, '2016-12-05 03:50:01', '2016-12-05 03:50:01'),
(28, 54, 3, 0, 0, 0, 1, 0, '2016-12-05 03:50:01', '2016-12-05 03:50:01'),
(29, 54, 4, 0, 0, 0, 1, 0, '2016-12-05 03:50:01', '2016-12-05 03:50:01'),
(30, 54, 5, 0, 0, 0, 1, 0, '2016-12-05 03:50:01', '2016-12-05 03:50:01'),
(31, 56, 1, 0, 0, 0, 1, 0, '2016-12-05 04:23:08', '2016-12-05 04:23:08'),
(32, 56, 2, 0, 0, 0, 1, 0, '2016-12-05 04:23:08', '2016-12-05 04:23:08'),
(33, 56, 3, 0, 0, 0, 1, 0, '2016-12-05 04:23:08', '2016-12-05 04:23:08'),
(34, 56, 4, 0, 0, 0, 1, 0, '2016-12-05 04:23:08', '2016-12-05 04:23:08'),
(35, 56, 5, 0, 0, 0, 1, 0, '2016-12-05 04:23:08', '2016-12-05 04:23:08'),
(36, 57, 1, 0, 0, 0, 1, 0, '2016-12-06 09:56:49', '2016-12-06 09:56:49'),
(37, 57, 2, 0, 0, 0, 1, 0, '2016-12-06 09:56:49', '2016-12-06 09:56:49'),
(38, 57, 3, 0, 1, 0, 1, 0, '2016-12-06 09:56:49', '2016-12-06 09:56:49'),
(39, 57, 4, 0, 1, 0, 1, 0, '2016-12-06 09:56:49', '2016-12-06 09:56:49'),
(40, 57, 5, 0, 1, 0, 1, 0, '2016-12-06 09:56:49', '2016-12-06 09:56:49'),
(41, 58, 1, 0, 0, 0, 1, 0, '2016-12-06 09:57:36', '2016-12-06 09:57:36'),
(42, 58, 2, 0, 0, 0, 1, 0, '2016-12-06 09:57:36', '2016-12-06 09:57:36'),
(43, 58, 3, 0, 1, 0, 1, 0, '2016-12-06 09:57:36', '2016-12-06 09:57:36'),
(44, 58, 4, 0, 1, 0, 1, 0, '2016-12-06 09:57:36', '2016-12-06 09:57:36'),
(45, 58, 5, 0, 1, 0, 1, 0, '2016-12-06 09:57:36', '2016-12-06 09:57:36'),
(46, 59, 5, 0, 0, 0, 1, 0, '2016-12-06 09:59:41', '2016-12-06 09:59:41'),
(47, 60, 4, 1, 1, 1, 1, 0, '2016-12-06 10:05:01', '2016-12-06 10:05:01'),
(48, 61, 5, 0, 0, 0, 1, 0, '2016-12-06 10:07:19', '2016-12-06 10:07:19'),
(49, 62, 2, 1, 1, 1, 1, 0, '2016-12-06 10:09:29', '2016-12-06 10:09:29'),
(50, 63, 4, 1, 1, 1, 1, 0, '2016-12-07 02:19:17', '2016-12-07 02:19:17'),
(51, 64, 1, 1, 1, 1, 1, 0, '2016-12-07 02:22:27', '2016-12-07 02:22:27'),
(52, 65, 1, 1, 1, 1, 1, 0, '2016-12-07 02:23:03', '2016-12-07 02:23:03'),
(53, 65, 2, 1, 1, 1, 1, 0, '2016-12-07 02:23:03', '2016-12-07 02:23:03'),
(54, 66, 1, 1, 1, 1, 1, 0, '2016-12-07 02:23:46', '2016-12-07 02:23:46'),
(55, 66, 2, 1, 1, 1, 1, 0, '2016-12-07 02:23:46', '2016-12-07 02:23:46'),
(56, 66, 4, 1, 1, 1, 1, 0, '2016-12-07 02:23:46', '2016-12-07 02:23:46'),
(57, 67, 4, 1, 1, 1, 1, 0, '2016-12-07 02:28:19', '2016-12-07 02:28:19'),
(58, 68, 4, 1, 0, 0, 1, 0, '2016-12-07 02:41:44', '2016-12-07 02:41:44'),
(59, 68, 5, 1, 0, 0, 1, 0, '2016-12-07 02:41:44', '2016-12-07 02:41:44'),
(60, 69, 1, 0, 0, 0, 1, 0, '2016-12-07 02:47:38', '2016-12-07 02:47:38'),
(61, 69, 2, 0, 0, 0, 1, 0, '2016-12-07 02:47:38', '2016-12-07 02:47:38'),
(62, 69, 4, 0, 0, 0, 1, 0, '2016-12-07 02:47:38', '2016-12-07 02:47:38'),
(63, 69, 5, 0, 0, 0, 1, 0, '2016-12-07 02:47:38', '2016-12-07 02:47:38'),
(64, 70, 5, 0, 0, 0, 1, 0, '2016-12-07 04:34:32', '2016-12-07 04:34:32'),
(65, 71, 1, 1, 1, 1, 1, 0, '2016-12-08 06:46:16', '2016-12-08 06:46:16'),
(66, 71, 4, 1, 1, 1, 1, 0, '2016-12-08 06:46:16', '2016-12-08 06:46:16'),
(67, 71, 5, 1, 1, 1, 1, 0, '2016-12-08 06:46:16', '2016-12-08 06:46:16'),
(68, 72, 1, 1, 1, 1, 1, 0, '2016-12-08 06:47:08', '2016-12-08 06:47:08'),
(69, 72, 5, 1, 1, 1, 1, 0, '2016-12-08 06:47:08', '2016-12-08 06:47:08'),
(70, 73, 5, 1, 1, 1, 1, 0, '2016-12-08 06:59:11', '2016-12-08 06:59:11'),
(71, 73, 5, 1, 1, 1, 1, 0, '2016-12-08 06:59:11', '2016-12-08 06:59:11'),
(72, 74, 4, 1, 1, 1, 1, 0, '2016-12-08 10:12:14', '2016-12-08 10:12:14'),
(73, 74, 5, 1, 1, 1, 1, 0, '2016-12-08 10:12:14', '2016-12-08 10:12:14'),
(74, 75, 4, 1, 1, 1, 1, 0, '2016-12-08 10:12:52', '2016-12-08 10:12:52'),
(75, 75, 5, 1, 1, 1, 1, 0, '2016-12-08 10:12:52', '2016-12-08 10:12:52'),
(76, 76, 1, 1, 1, 1, 1, 0, '2016-12-08 10:17:59', '2016-12-08 10:17:59'),
(77, 76, 2, 1, 1, 1, 1, 0, '2016-12-08 10:17:59', '2016-12-08 10:17:59'),
(78, 76, 3, 1, 1, 1, 1, 0, '2016-12-08 10:17:59', '2016-12-08 10:17:59'),
(79, 76, 4, 1, 1, 1, 1, 0, '2016-12-08 10:17:59', '2016-12-08 10:17:59'),
(80, 76, 5, 1, 1, 1, 1, 0, '2016-12-08 10:17:59', '2016-12-08 10:17:59'),
(81, 77, 1, 1, 1, 1, 1, 0, '2016-12-08 10:19:31', '2016-12-08 10:19:31'),
(82, 77, 2, 1, 1, 1, 1, 0, '2016-12-08 10:19:31', '2016-12-08 10:19:31'),
(83, 78, 1, 1, 1, 1, 1, 0, '2016-12-08 10:23:56', '2016-12-08 10:23:56'),
(84, 79, 1, 0, 0, 0, 1, 0, '2016-12-08 10:25:06', '2016-12-08 10:25:06'),
(85, 79, 2, 0, 0, 0, 1, 0, '2016-12-08 10:25:06', '2016-12-08 10:25:06'),
(86, 79, 3, 0, 0, 0, 1, 0, '2016-12-08 10:25:06', '2016-12-08 10:25:06'),
(87, 79, 4, 0, 0, 0, 1, 0, '2016-12-08 10:25:06', '2016-12-08 10:25:06'),
(88, 79, 5, 0, 0, 0, 1, 0, '2016-12-08 10:25:06', '2016-12-08 10:25:06'),
(89, 80, 1, 1, 1, 1, 1, 0, '2016-12-09 01:42:42', '2016-12-09 01:42:42'),
(90, 80, 2, 1, 1, 1, 1, 0, '2016-12-09 01:42:42', '2016-12-09 01:42:42'),
(91, 80, 5, 1, 1, 1, 1, 0, '2016-12-09 01:42:42', '2016-12-09 01:42:42'),
(92, 85, 5, 0, 0, 0, 1, 0, '2016-12-09 02:19:46', '2016-12-09 02:19:46'),
(98, 87, 1, 1, 0, 0, 1, 0, '2016-12-09 03:05:01', '2016-12-09 03:05:01'),
(99, 87, 5, 1, 0, 0, 1, 0, '2016-12-09 03:05:01', '2016-12-09 03:05:01'),
(126, 88, 1, 0, 0, 0, 1, 0, '2016-12-09 04:42:55', '2016-12-09 04:42:55'),
(127, 88, 2, 0, 0, 0, 1, 0, '2016-12-09 04:42:55', '2016-12-09 04:42:55'),
(128, 88, 3, 0, 0, 0, 1, 0, '2016-12-09 04:42:55', '2016-12-09 04:42:55'),
(129, 88, 4, 0, 0, 0, 1, 0, '2016-12-09 04:42:55', '2016-12-09 04:42:55'),
(130, 88, 5, 0, 0, 0, 1, 0, '2016-12-09 04:42:55', '2016-12-09 04:42:55'),
(142, 89, 1, 1, 1, 1, 1, 0, '2016-12-09 07:00:01', '2016-12-09 07:00:01'),
(143, 89, 4, 1, 1, 1, 1, 0, '2016-12-09 07:00:01', '2016-12-09 07:00:01'),
(144, 89, 5, 1, 1, 1, 1, 0, '2016-12-09 07:00:01', '2016-12-09 07:00:01'),
(213, 90, 1, 0, 0, 0, 1, 0, '2016-12-12 10:09:44', '2016-12-12 10:09:44'),
(214, 90, 2, 0, 0, 0, 1, 0, '2016-12-12 10:09:44', '2016-12-12 10:09:44'),
(215, 90, 3, 0, 0, 0, 1, 0, '2016-12-12 10:09:44', '2016-12-12 10:09:44'),
(216, 90, 4, 0, 0, 0, 1, 0, '2016-12-12 10:09:44', '2016-12-12 10:09:44'),
(217, 90, 5, 0, 0, 0, 1, 0, '2016-12-12 10:09:45', '2016-12-12 10:09:45'),
(297, 91, 1, 1, 1, 1, 1, 0, '2016-12-13 03:20:35', '2016-12-13 03:20:35'),
(298, 91, 2, 0, 0, 1, 1, 0, '2016-12-13 03:20:35', '2016-12-13 03:20:35'),
(299, 91, 3, 0, 0, 0, 1, 0, '2016-12-13 03:20:35', '2016-12-13 03:20:35'),
(300, 91, 4, 0, 0, 1, 1, 0, '2016-12-13 03:20:35', '2016-12-13 03:20:35'),
(301, 91, 5, 0, 0, 0, 1, 0, '2016-12-13 03:20:35', '2016-12-13 03:20:35'),
(302, 92, 1, 1, 1, 1, 1, 0, '2016-12-13 03:22:47', '2016-12-13 03:22:47'),
(303, 92, 2, 0, 1, 1, 0, 0, '2016-12-13 03:22:47', '2016-12-13 03:22:47'),
(304, 92, 3, 0, 1, 0, 0, 0, '2016-12-13 03:22:47', '2016-12-13 03:22:47'),
(305, 92, 4, 0, 1, 1, 0, 0, '2016-12-13 03:22:47', '2016-12-13 03:22:47'),
(306, 93, 1, 1, 1, 1, 1, 0, '2016-12-13 03:29:39', '2016-12-13 03:29:39'),
(307, 93, 2, 0, 0, 0, 1, 0, '2016-12-13 03:29:39', '2016-12-13 03:29:39'),
(308, 93, 3, 0, 0, 0, 1, 0, '2016-12-13 03:29:39', '2016-12-13 03:29:39'),
(309, 93, 4, 0, 0, 0, 1, 0, '2016-12-13 03:29:39', '2016-12-13 03:29:39'),
(310, 93, 5, 0, 0, 0, 1, 0, '2016-12-13 03:29:39', '2016-12-13 03:29:39'),
(347, 94, 1, 1, 1, 0, 1, 0, '2016-12-13 03:39:17', '2016-12-13 03:39:17'),
(348, 94, 2, 0, 1, 0, 0, 0, '2016-12-13 03:39:17', '2016-12-13 03:39:17'),
(349, 94, 3, 0, 1, 0, 0, 0, '2016-12-13 03:39:17', '2016-12-13 03:39:17'),
(350, 94, 4, 0, 1, 0, 0, 0, '2016-12-13 03:39:17', '2016-12-13 03:39:17'),
(351, 95, 1, 0, 0, 1, 1, 0, '2016-12-13 04:45:36', '2016-12-13 04:45:36'),
(352, 95, 2, 1, 0, 0, 0, 0, '2016-12-13 04:45:36', '2016-12-13 04:45:36'),
(353, 95, 3, 0, 1, 0, 0, 0, '2016-12-13 04:45:36', '2016-12-13 04:45:36'),
(354, 95, 4, 0, 0, 1, 0, 0, '2016-12-13 04:45:36', '2016-12-13 04:45:36'),
(362, 96, 1, 1, 1, 1, 1, 0, '2016-12-13 07:27:17', '2016-12-13 07:27:17'),
(363, 96, 3, 1, 1, 0, 0, 0, '2016-12-13 07:27:17', '2016-12-13 07:27:17'),
(364, 96, 4, 0, 0, 1, 1, 0, '2016-12-13 07:27:17', '2016-12-13 07:27:17'),
(366, 97, 1, 0, 1, 1, 0, 0, '2016-12-19 06:20:07', '2016-12-19 06:20:07'),
(371, 34, 2, 0, 1, 1, 0, 0, '2016-12-20 03:04:26', '2016-12-20 03:04:26'),
(372, 34, 3, 1, 0, 0, 0, 0, '2016-12-20 03:04:26', '2016-12-20 03:04:26'),
(373, 34, 4, 1, 1, 0, 0, 0, '2016-12-20 03:04:26', '2016-12-20 03:04:26');

/*!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 */;