--
-- Host: localhost    Database: teste_inventario
-- ------------------------------------------------------


--
-- Table structure for table `bap_menu`
--

CREATE TABLE `bap_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_by` int(11) NOT NULL DEFAULT '1',
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `section` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `dont_translate` tinyint(1) DEFAULT NULL,
  `visibility` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



CREATE TABLE IF NOT EXISTS `company_status` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `company_id` int(10) UNSIGNED NOT NULL,
  `status_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `company_status_company_id_foreign` (`company_id`),
  KEY `company_status_status_id_foreign` (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `bap_menu`
--

INSERT INTO `bap_menu` VALUES (1,1,'/dashboard','home','apps','',NULL,1,'2018-09-16 05:58:14',NULL,0,1),(2,9,'/settings','settings','settings','settings.access',NULL,1,'2018-09-16 05:58:14','2018-11-23 12:59:37',0,1),(3,2,'/companies','companies','settings','companies.browse',NULL,1,'2018-09-16 05:58:50','2018-09-16 05:59:11',0,1),(4,5,'/clients','clients','settings','clients.browse',NULL,1,'2018-09-16 05:59:16','2018-09-16 05:59:38',0,1),(5,4,'/suppliers','suppliers','settings','suppliers.browse',NULL,1,'2018-09-16 05:59:44','2018-09-16 06:00:03',0,1),(6,10,'/users','users','settings','users.browse',NULL,1,'2018-09-16 19:20:18','2018-11-23 12:59:37',0,1),(7,3,'/places','places','settings','places.browse',NULL,1,'2018-09-17 16:24:50','2018-09-18 02:40:19',0,1),(8,6,'/collaborators','collaborators','settings','collaborators.browse',NULL,1,'2018-09-19 16:14:53','2018-11-23 12:57:51',0,1),(9,7,'/assets','assets','settings','assets.browse',NULL,1,'2018-09-22 02:23:18','2018-11-23 12:57:51',0,1),(10,8,'/reports','reports','settings','',NULL,1,'2018-10-10 01:33:32','2018-11-23 12:59:37',0,1),(11,1,'/reports','General Report','settings','',10,1,'2018-11-23 12:56:45','2018-11-23 12:57:51',0,1),(12,2,'/reports/conservationstate','Conservation State Report','settings','',10,1,'2018-11-23 12:58:11','2018-11-23 12:58:59',0,1),(13,3,'/reports/costs','Costs Report','settings','',10,1,'2018-11-23 12:59:05','2018-11-23 13:00:02',0,1);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','admin','web','2018-09-16 05:58:15','2018-09-16 05:58:15'),(2,'Chefe de inventário','chefe','web','2018-09-16 05:58:15','2018-09-16 05:58:15'),(3,'Gerente local','gerente','web','2018-09-16 05:58:15','2018-09-16 05:58:15');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `perm_group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'clients.settings','web','2018-09-14 01:51:18','2018-09-14 01:51:18','Clients'),(2,'clients.browse','web','2018-09-14 01:51:18','2018-09-14 01:51:18','Clients'),(3,'clients.create','web','2018-09-14 01:51:18','2018-09-14 01:51:18','Clients'),(4,'clients.update','web','2018-09-14 01:51:18','2018-09-14 01:51:18','Clients'),(5,'clients.destroy','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Clients'),(6,'companies.settings','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Companies'),(7,'companies.browse','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Companies'),(8,'companies.create','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Companies'),(9,'companies.update','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Companies'),(10,'companies.destroy','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Companies'),(11,'suppliers.settings','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Suppliers'),(12,'suppliers.browse','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Suppliers'),(13,'suppliers.create','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Suppliers'),(14,'suppliers.update','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Suppliers'),(15,'suppliers.destroy','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Suppliers'),(16,'settings.access','web','2018-09-14 01:51:19','2018-09-14 01:51:19','Settings'),(17,'users.settings','web',NULL,NULL,'Users'),(18,'users.browse','web',NULL,NULL,'Users'),(19,'users.create','web',NULL,NULL,'Users'),(20,'users.update','web',NULL,NULL,'Users'),(21,'users.destroy','web',NULL,NULL,'Users'),(22,'places.settings','web',NULL,NULL,'Places'),(23,'places.browse','web',NULL,NULL,'Places'),(24,'places.create','web',NULL,NULL,'Places'),(25,'places.update','web',NULL,NULL,'Places'),(26,'places.destroy','web',NULL,NULL,'Places'),(27,'places.settings','web',NULL,NULL,'Places'),(28,'collaborators.settings','web',NULL,NULL,'Collaborators'),(29,'collaborators.browse','web',NULL,NULL,'Collaborators'),(30,'collaborators.create','web',NULL,NULL,'Collaborators'),(31,'collaborators.update','web',NULL,NULL,'Collaborators'),(32,'collaborators.destroy','web',NULL,NULL,'Collaborators'),(33,'collaborators.settings','web',NULL,NULL,'Collaborators'),(34,'areas.browse','web',NULL,NULL,'Areas'),(35,'areas.create','web',NULL,NULL,'Areas'),(36,'areas.update','web',NULL,NULL,'Areas'),(37,'areas.destroy','web',NULL,NULL,'Areas'),(38,'assets.browse','web',NULL,NULL,'Assets'),(39,'assets.create','web',NULL,NULL,'Assets'),(40,'assets.update','web',NULL,NULL,'Assets'),(41,'assets.destroy','web',NULL,NULL,'Assets'),(42,'assets.settings','web',NULL,NULL,'Assets'),
(43, 'maintenances.settings', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Maintenances'),
(44, 'maintenances.browse', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Maintenances'),
(45, 'maintenances.create', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Maintenances'),
(46, 'maintenances.update', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Maintenances'),
(47, 'maintenances.destroy', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Maintenances'),
(48, 'reports.settings', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Reports'),
(49, 'reports.browse', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Reports'),
(50, 'reports.create', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Reports'),
(51, 'reports.update', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Reports'),
(52, 'reports.destroy', 'web', '2019-01-16 17:19:48', '2019-01-16 17:19:48', 'Reports');


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(1,2),(2,1),(2,2),(2,3),(3,1),(3,2),(3,3),(4,1),(4,2),(4,3),(5,1),(5,2),(5,3),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(11,2),(12,1),(12,2),(12,3),(13,1),(13,2),(13,3),(14,1),(14,2),(14,3),(15,1),(15,2),(15,3),(16,1),(17,2),(18,2),(19,2),(20,2),(21,2),(22,1),(22,2),(23,1),(23,2),(24,1),(24,2),(25,1),(25,2),(26,1),(26,2),(27,1),(27,2),(28,1),(28,2),(29,1),(29,2),(29,3),(30,1),(30,2),(30,3),(31,1),(31,2),(31,3),(32,1),(32,2),(32,3),(38,1),(38,2),(38,3),(39,1),(39,2),(39,3),(40,1),(40,2),(40,3),(41,1),(41,2),(41,3),(42,1),(42,2);

--
-- Table structure for table `bap_language`
--

CREATE TABLE `bap_language` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bap_language`
--

INSERT INTO `bap_language` VALUES (1,'English','en',1,'2018-09-24 01:46:14','2018-09-24 01:46:14',NULL),(2,'Portugues','pt',1,'2018-09-24 01:51:03','2018-09-24 01:51:03',NULL);

--
-- Table structure for table `bap_date_format`
--

CREATE TABLE `bap_date_format` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `js_details` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Javascript Date Format',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bap_date_format`
--

INSERT INTO `bap_date_format` VALUES (1,'YYYY-MM-DD','Y-m-d','2018-09-24 01:46:12',NULL,NULL,'YYYY-MM-DD'),(2,'YY-MM-DD','y-m-d','2018-09-24 01:46:12',NULL,NULL,'YY-MM-DD'),(3,'MM/DD/YYYY','m/d/Y','2018-09-24 01:46:12',NULL,NULL,'MM/DD/YYYY'),(4,'MM/DD/YY','m/d/y','2018-09-24 01:46:13',NULL,NULL,'MM/DD/YY'),(5,'DD/MM/YYYY','d/m/Y','2018-09-30 18:57:11','2018-09-30 18:57:11',NULL,'DD/MM/YYYY');

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status`
--

INSERT INTO `status` VALUES (1,'Ativo','patrimônio ativo','2018-10-09 15:41:45','2018-10-09 15:41:45',NULL),(2,'Em manutenção','patrimônio em manutenção','2018-10-09 15:42:16','2018-10-09 15:42:16',NULL),(3,'Desabilitado','patrimônio desabilitado','2018-10-09 15:42:45','2018-10-09 15:42:45',NULL), (4,'Baixado','Patrimônio já baixado','2018-10-09 15:42:45','2018-10-09 15:42:45',NULL);

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

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `left_panel_hide` tinyint(1) NOT NULL DEFAULT '0',
  `theme` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'theme-red',
  `address_country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_street` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time_format_id` int(10) unsigned DEFAULT '1',
  `date_format_id` int(10) unsigned DEFAULT '1',
  `time_zone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'America/Sao_Paulo',
  `profile_pic_conf` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'initials',
  `profile_image_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language_id` int(10) unsigned DEFAULT '1',
  `access_to_all_entity` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int(10) unsigned DEFAULT NULL,
  `person_tax_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `personal_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_tax_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `neighborhood` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place_id` int(10) unsigned DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_time_format_id_foreign` (`time_format_id`),
  KEY `users_date_format_id_foreign` (`date_format_id`),
  KEY `users_language_id_foreign` (`language_id`),
  KEY `users_company_id_foreign` (`company_id`),
  KEY `users_place_id_foreign` (`place_id`),
  CONSTRAINT `users_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  CONSTRAINT `users_date_format_id_foreign` FOREIGN KEY (`date_format_id`) REFERENCES `bap_date_format` (`id`),
  CONSTRAINT `users_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `bap_language` (`id`),
  CONSTRAINT `users_place_id_foreign` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`),
  CONSTRAINT `users_time_format_id_foreign` FOREIGN KEY (`time_format_id`) REFERENCES `bap_time_format` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,'admin@laravel-bap.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','2GN8boN2aF0puYXx9IwxZfZ2DOovNps6cJ7E9umi0LdqC2oJ06DiA8UAgRIH','2018-09-24 01:46:21','2018-11-17 15:25:46',NULL,1,'FireWire','Admin','--','--','(99) 9999-9999','(99) 99999-9999','(99) 9999-9999','--','--','--',0,'theme-blue',NULL,'Rio Grande do Sul','Bagé','08.392-849','Salgado Filho',1,5,'America/Sao_Paulo','image','profile_1_.jpeg',2,1,'FireWire Admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'julioleichtweis@gmail.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','i0Hacz4dsOuYHmK3IIziIajkka0r9lxqs2Uyuw63jjqmwiODwOBHP6Hd7Heq','2018-11-02 16:42:15','2018-11-04 02:49:42',NULL,1,'julio','leichtweis',NULL,NULL,NULL,'(89) 54358-9423','(98) 5439-5982',NULL,NULL,NULL,0,'theme-red',NULL,'-----','------','00.000-000','------',1,5,'America/Sao_Paulo','initials',NULL,1,0,'julio leichtweis',1,'059.840.354-83',NULL,NULL,'1960-10-10',NULL,NULL,NULL,NULL,'-----'),(13,'flavio@mail.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','CgJ4vqcgAuv8gOCNdjDgMVxM6o7e7TNxv648C3flPdRhzdL0PSplNYeLbyKo','2018-11-02 19:48:13','2018-11-02 19:52:27',NULL,1,'flavio','alberto',NULL,NULL,NULL,'(57) 84395-7349','(85) 7589-9437',NULL,NULL,NULL,0,'theme-red',NULL,'---','--------','00.000-000','----------',1,1,'America/Sao_Paulo','initials',NULL,2,0,'flavio alberto',1,'985.773.359-87',NULL,NULL,'1988-02-02',NULL,NULL,NULL,1,NULL),(14,'barabara@mail.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','v2Y7tdIRel2a3i1dxW8BOIVhwjJhcDdpGo82wX6mCazyjxDC2OXDrbqF59bv','2018-11-02 19:49:27','2018-11-02 19:51:59',NULL,1,'barbara','acosta',NULL,NULL,NULL,'(95) 87432-8957','(54) 5342-5345',NULL,NULL,NULL,0,'theme-red',NULL,'estado','cidade','09.548-954','ru',2,1,'America/Sao_Paulo','initials',NULL,2,0,'barbara acosta',1,'545.432.523-45',NULL,NULL,'1977-10-10',NULL,NULL,NULL,3,NULL),(15,'dani2@mail.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','nCZoN6jwE30GYKVtuJG5N1S87fBBpYj2Pa0WJdpIEZiIBBN5dkeKxrACJx1X','2018-11-02 19:51:00','2018-11-02 19:51:37',NULL,1,'daniel','cesar',NULL,NULL,NULL,NULL,'(95) 4857-3850',NULL,NULL,NULL,0,'theme-red',NULL,'estado','cidade','09.589-438','rua',2,1,'America/Sao_Paulo','initials',NULL,2,0,'daniel cesar',1,'878.457.342-37',NULL,NULL,'1933-10-10',NULL,NULL,NULL,2,NULL),(16,'flavio2@mail.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','f0VpYkw2fGbCxTZdCZaLhyboqGYKTPPbbCTA8GEE6QWAApzHyxyhgEUF4UEI','2018-11-02 23:18:11','2018-11-05 00:00:42',NULL,1,'flavio','santos',NULL,NULL,NULL,'(98) 57435-8973','(95) 8785-6578',NULL,NULL,NULL,0,'theme-red',NULL,'---','-------------','00.000-000','------------',2,1,'America/Sao_Paulo','initials',NULL,2,0,'flavio santos',2,'758.926.758-93',NULL,NULL,'1974-10-10',NULL,NULL,NULL,NULL,NULL),(17,'andradas@mail.com','$2y$12$6dtmtWcairlF2R88.uM1C.zZCDOb4tvKxCo3Cggi6sXd0qKROT.gi','FNCHLmBsgknghZQj052ivYNUDexLoRStJL8tgN2uWrKoYS1p3hReYtNoVaIc','2018-11-05 01:47:58','2018-11-05 01:48:33',NULL,1,'joao','claudio',NULL,NULL,NULL,'(65) 46346-3546','(66) 5345-6546',NULL,NULL,NULL,0,'theme-red',NULL,NULL,NULL,NULL,NULL,2,1,'America/Sao_Paulo','initials',NULL,2,0,'joao claudio',2,'889.573.872-35',NULL,NULL,'1977-10-10',NULL,NULL,NULL,4,NULL);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int(10) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'Modules\\Platform\\User\\Entities\\User',1),(2,'Modules\\Platform\\User\\Entities\\User',12),(2,'Modules\\Platform\\User\\Entities\\User',16),(3,'Modules\\Platform\\User\\Entities\\User',13),(3,'Modules\\Platform\\User\\Entities\\User',14),(3,'Modules\\Platform\\User\\Entities\\User',15),(3,'Modules\\Platform\\User\\Entities\\User',17);


