
--
-- Table structure for table `general_configs`
--

CREATE TABLE `general_configs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `tooltipval` mediumtext CHARACTER SET latin1,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `levels` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_configs`
--

INSERT INTO `general_configs` VALUES (1,'Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,'2019-10-03 19:47:07','2020-06-03 18:29:06',1,79,NULL,'level_1'),(2,'External Entities','Influencing Factors that exist outside organization',1,'2019-10-08 23:43:09','2020-06-03 18:29:07',1,79,NULL,'level_2'),(3,'Organizational Factors (Central)','Operations that are controlled within the central operations',1,'2019-10-09 22:25:38','2020-06-03 18:29:07',1,79,NULL,'level_3'),(4,'Organizational Factors (Regional)','Contextual features of the region and operations',1,'2020-02-03 12:41:52','2020-06-03 18:29:07',1,79,NULL,'level_4'),(5,'Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,'2020-02-03 12:42:44','2020-06-03 18:29:07',1,79,NULL,'level_5'),(6,'Outcome','Outcome help!',0,'2020-01-03 05:30:51','2020-01-03 05:30:51',1,1,'2020-01-24 18:55:23','level_6');

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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2020_02_18_030911_alter_reviewconfigs_table',1),(2,'2020_03_06_042230_add_gid_to_reviewconfigs_table',2);

--
-- Table structure for table `organization_users`
--

CREATE TABLE `organization_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `organization_id` int(10) NOT NULL,
  `title` varchar(255) CHARACTER SET latin1 NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organization_users`
--

INSERT INTO `organization_users` VALUES (2,81,9,'Test user',NULL,NULL,NULL,NULL,NULL),(3,85,9,'Admin',NULL,NULL,NULL,NULL,NULL),(7,89,12,'Assistant Commissioner',NULL,NULL,NULL,NULL,NULL),(8,90,13,'DHS',NULL,NULL,NULL,NULL,NULL),(12,91,13,'DHS',NULL,NULL,NULL,NULL,NULL),(13,93,13,'DHS',NULL,NULL,NULL,NULL,NULL),(14,92,13,'DHS',NULL,NULL,NULL,NULL,NULL),(19,96,14,'DCF',NULL,NULL,NULL,NULL,NULL),(20,97,14,'DCF',NULL,NULL,NULL,NULL,NULL),(21,98,14,'DCF',NULL,NULL,NULL,NULL,NULL),(32,107,21,'CSTraining7',NULL,NULL,NULL,NULL,NULL),(33,108,21,'CSTraining9',NULL,NULL,NULL,NULL,NULL),(37,109,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(38,110,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(39,111,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(40,112,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(41,113,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(42,114,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(44,116,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(45,117,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(46,115,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(49,94,12,'Safety Analyst',NULL,NULL,NULL,NULL,NULL),(55,88,12,'Director',NULL,NULL,NULL,NULL,NULL),(56,87,12,'Director',NULL,NULL,NULL,NULL,NULL),(57,106,21,'CSTraining5',NULL,NULL,NULL,NULL,NULL),(58,105,21,'CSTraining3',NULL,NULL,NULL,NULL,NULL),(63,100,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(64,99,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(71,120,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(75,119,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(77,121,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(78,104,21,'CSTraining1',NULL,NULL,NULL,NULL,NULL),(79,122,12,'OCFS Liaison',NULL,NULL,NULL,NULL,NULL),(80,118,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(82,123,10,'MN DSD',NULL,NULL,NULL,NULL,NULL),(84,124,10,'MN DSD',NULL,NULL,NULL,NULL,NULL),(85,95,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(86,125,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(88,127,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(89,128,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(90,129,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(91,130,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(92,131,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(93,132,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(94,133,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(95,134,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(96,135,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(97,136,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(98,137,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(99,138,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(100,126,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(101,139,23,'HCS',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` VALUES (1,'5 row','',NULL,1,'2020-06-03 09:36:34','2020-06-03 09:38:28',1,1,'2020-06-03 09:38:28'),(2,'five row q','',NULL,1,'2020-06-03 10:49:27','2020-06-03 10:50:55',1,1,'2020-06-03 10:50:55'),(3,'Org. Row 5','',NULL,1,'2020-06-03 11:56:12','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(4,'Org. Row 4','',NULL,1,'2020-06-03 11:56:35','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(5,'Org. Row 3','',NULL,1,'2020-06-03 11:56:46','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(6,'Org. Row 2','',NULL,1,'2020-06-03 11:57:03','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(7,'Org. Row 1','',NULL,1,'2020-06-03 11:57:16','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(8,'Demo Agency','',NULL,1,'2020-06-03 16:25:32','2020-06-03 18:36:39',79,79,'2020-06-03 18:36:39'),(9,'Mapping Demo','',NULL,1,'2020-06-03 18:33:31','2020-06-03 18:33:31',79,79,NULL),(10,'MN DSD','',NULL,1,'2020-06-10 15:39:05','2020-06-10 15:39:05',80,80,NULL),(11,'DevDigital Test','',NULL,1,'2020-06-12 06:19:42','2020-06-12 06:24:52',1,1,'2020-06-12 06:24:52'),(12,'NY ACS','',NULL,1,'2020-06-24 14:09:30','2020-06-24 14:09:30',80,80,NULL),(13,'MN DHS','',NULL,1,'2020-06-24 14:56:33','2020-06-24 14:56:33',80,80,NULL),(14,'NJ DCF','',NULL,1,'2020-07-13 14:27:40','2020-07-13 14:27:40',80,80,NULL),(15,'KY DCBS','',NULL,1,'2020-07-13 14:28:17','2020-07-13 14:28:17',80,80,NULL),(16,'Utah DCFS','',NULL,1,'2020-07-13 14:28:45','2020-07-13 14:28:45',80,80,NULL),(17,'WI DCF','',NULL,1,'2020-07-13 14:29:13','2020-07-13 14:29:13',80,80,NULL),(18,'Hennepin County ES','',NULL,1,'2020-07-13 14:30:01','2020-07-17 02:22:39',80,80,NULL),(19,'Hennepin County DHS','',NULL,1,'2020-07-17 02:22:53','2020-08-20 14:02:34',80,80,NULL),(20,'test','',NULL,1,'2020-07-31 12:07:07','2020-07-31 12:09:04',1,1,'2020-07-31 12:09:04'),(21,'Training','',NULL,1,'2020-08-03 19:26:40','2020-08-03 19:26:40',80,80,NULL),(22,'SLR II Demo','',NULL,1,'2020-08-24 18:54:11','2020-08-24 18:54:11',79,79,NULL),(23,'Heritage Christian Services','',NULL,1,'2020-10-01 19:29:58','2020-10-01 19:29:58',80,80,NULL),(24,'Test SLR','',NULL,1,'2020-10-19 19:30:53','2020-10-19 19:40:21',80,80,'2020-10-19 19:40:21');

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

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` VALUES ('mitesh.parmar@devdigital.com','$2y$10$0ay9/OUBEdDCdLC1kHIE.udTCXgIgyPv6xhpAuRCMqH2LZn9l1TX.','2020-06-03 10:50:02'),('tom@devdigital.com','$2y$10$U7VTsOX9q7WEjpOypvPXC.F1SUz4Gb.gnvXc25z8189daCe9G/VAi','2020-06-03 13:41:12'),('dg@collaborative-safety.com','$2y$10$/2XGhFt2S5Q2gvoBwok.Mun282/lQ.8gPwY/h7VAfB07CZUL.ySOO','2020-06-03 13:41:20'),('kk@collaborative-safety.com','$2y$10$bOKgqJKwVuHubgavrlBXReW7lLjbSXeNG9Ce6S5UJc6.e/gxXJrTa','2020-06-10 15:31:09'),('johnny@myeyedesigns.com','$2y$10$ge2fobpgrEWe5fEh3bJ65O0IYOpJ7cHSvg9bv9UE9iKsj5jiSOfHO','2020-06-10 15:42:37'),('shahrukh.shaikh@devdigital.com','$2y$10$w52uKWxeVftkokwWRQpkM.ezzCYjOsmnmbaE1lwEnFFvsGh1UWFBe','2020-06-12 06:29:08'),('brittany.lochner@state.mn.us','$2y$10$/cdS2qbFhVe2Uz04vx3Rxu8ltr7TeMsd.Ths4E1cm0xJJuRbyWB9S','2020-06-24 15:03:22'),('Amanda.Craig@dcf.nj.gov','$2y$10$h42XfgXHoa6WSGkSpBrJSuN81TIpSkK6z6BL4ocdTUBBNxLl5nCKu','2020-07-28 13:40:41'),('Charyl.Yarbrough@dcf.nj.gov','$2y$10$0gjsBeAFPED415s.skp4x.vpxgwoIOss.sC5S3TCfY0GY0YeHE3gC','2020-07-28 13:56:07'),('abcd@ab.cd.a.xy','$2y$10$PfNS5ghTYGo3QgzKF2TUyuZQeROSt5bhPtTbf54EswzZuh96LL60m','2020-07-29 10:13:45'),('mitesh.parmar@dev.dig.ital.com','$2y$10$A6kDhL9mPrHlP65r/gH7euchKOLVftACdwzsfGBFzGWBnntvekzVe','2020-07-29 10:18:11'),('weberamy@uwm.edu','$2y$10$8LnFNRNp5O7TCS2CkXVYu.LvHkRAXpKd3pACEvGrNmu2OrC2P56q6','2020-08-06 20:12:16'),('acleland@wisc.edu','$2y$10$EVLEALP8e5O/kz9Ntj.t9.aBX9bQVSK7DOsG1HuxGubWEzIu43V0S','2020-08-06 20:12:55'),('erika.winterfeldt@fdlco.wi.gov','$2y$10$y2JDbrc0HkBOktvISYwmZu7ubSxn5zGdXYK8RxYl3HmsChpo0h6gW','2020-08-06 20:41:50'),('edds@countyofdane.com','$2y$10$/x0V290PZjxRKo9VJBhgveL/o80DIlJizCuI89Bs.LyLiZCoLHley','2020-08-06 20:42:58'),('kay.reinhard@fdlco.wi.gov','$2y$10$hy.ppDNaobOZpyW/637.Tuowwv8kZm5gHlKkGUWy0TkEZ9TnFgI0O','2020-08-06 20:43:30'),('Tyler.Oettinger@wisconsin.gov','$2y$10$ZcYxBNpxMW5HF4./3J/JH.4SRtx7ocYi2NR/ZaiRVV/bVBpunsOOa','2020-08-06 20:45:38'),('Ancil.Payne@acs.nyc.gov','$2y$10$Blxe4jyPhy2ITDz/y4CMx.3opF9nF9Qgxr69ZJy7sDe/VpcWda55S','2020-08-10 16:56:36'),('colette.davis@hennepin.us','$2y$10$5sy/rrB3y0Jo4gcMWt/1f.mLbt3zkxpgTC14eKDyr7mNdGNEIUpsu','2020-08-28 15:54:34'),('fintan.moore@hennepin.us','$2y$10$esXh8CWOjgkehCGY1Q0htuC9TOfSndTON3SzE6y.tyoahskIhTGI2','2020-08-28 15:54:43'),('Crystal.Ramos@acs.nyc.gov','$2y$10$ylx8b87WY4//5iak6sbOGOOCrGbr7De9OV5TA1B7jG.GHUx4vNpJe','2020-10-08 00:06:52');

--
-- Table structure for table `reviewconfigs`
--

CREATE TABLE `reviewconfigs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gid` int(11) DEFAULT NULL,
  `organization_id` int(10) unsigned DEFAULT NULL,
  `review_id` int(10) unsigned DEFAULT NULL,
  `levels` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tooltipval` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned 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=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `reviewconfigs`
--

INSERT INTO `reviewconfigs` VALUES (1,1,1,NULL,'level_1','Government and Regulatory Body','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(2,2,1,NULL,'level_2','External Entities','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(3,3,1,NULL,'level_3','Organizational Factors (Central)','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(4,4,1,NULL,'level_4','Organizational Factors (Regional)','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(5,5,1,NULL,'level_5','Processes Conditions Actor Activities','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(6,1,2,NULL,'level_1','Government and Regulatory Body','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(7,2,2,NULL,'level_2','External Entities','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(8,3,2,NULL,'level_3','Organizational Factors (Central)','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(9,4,2,NULL,'level_4','Organizational Factors (Regional)','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(10,5,2,NULL,'level_5','Processes Conditions Actor Activities','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(11,1,3,NULL,'level_1','Row 5','Row 5 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(12,2,3,NULL,'level_2','Row 4','Row 4 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(13,3,3,NULL,'level_3','Row 3','Row 3 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(14,4,3,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(15,5,3,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(16,2,4,NULL,'level_2','Row 4','Row 4 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(17,3,4,NULL,'level_3','Row 3','Row 3 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(18,4,4,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(19,5,4,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(20,3,5,NULL,'level_3','Row 3','Row 3 Tool tip!',1,72,72,'2020-06-03 11:56:46','2020-06-03 11:56:46',NULL),(21,4,5,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:56:46','2020-06-03 11:56:46',NULL),(22,5,5,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:56:46','2020-06-03 11:56:46',NULL),(23,4,6,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:57:03','2020-06-03 11:57:03',NULL),(24,5,6,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:57:03','2020-06-03 11:57:03',NULL),(25,5,7,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:57:16','2020-06-03 11:57:16',NULL),(26,1,8,NULL,'level_1','Government and Regulatory Body','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(27,2,8,NULL,'level_2','External Entities','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(28,3,8,NULL,'level_3','Organizational Factors (Central)','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(29,4,8,NULL,'level_4','Organizational Factors (Regional)','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(30,5,8,NULL,'level_5','Processes Conditions Actor Activities','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(31,31,9,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(32,32,9,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(33,33,9,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(34,34,9,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(35,35,9,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(36,36,10,NULL,'level_1','Government and Regulatory Body','Factors influenced by State & Federal legislation or mandated standards',1,80,80,'2020-06-10 15:39:05','2020-08-14 15:45:55',NULL),(37,37,10,NULL,'level_2','External Factors','Influencing Factors that exist outside of organization',1,80,80,'2020-06-10 15:39:05','2020-08-14 15:45:55',NULL),(38,38,10,NULL,'level_3','County / Regional Factors','Operations that are controlled within the County or Regional operations',1,80,80,'2020-06-10 15:39:05','2020-08-14 15:45:55',NULL),(39,39,10,NULL,'level_4','Provider Factors','Environmental features of the provider organization',1,80,80,'2020-06-10 15:39:06','2020-08-14 15:45:55',NULL),(40,40,10,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-06-10 15:39:06','2020-08-14 15:45:55',NULL),(41,1,11,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(42,2,11,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(43,3,11,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(44,4,11,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(45,5,11,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(46,1,12,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(47,2,12,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(48,3,12,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(49,4,12,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(50,5,12,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(51,1,13,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(52,2,13,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(53,3,13,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(54,4,13,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(55,5,13,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(56,1,14,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(57,2,14,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(58,3,14,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(59,4,14,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(60,5,14,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(61,1,15,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(62,2,15,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(63,3,15,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(64,4,15,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(65,5,15,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(66,1,16,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(67,2,16,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(68,3,16,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(69,4,16,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(70,5,16,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(71,71,17,NULL,'level_1','Government and Regulatory Bodies (Federal & State)','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(72,72,17,NULL,'level_2','External Entities (community partners, stakeholders)','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(73,73,17,NULL,'level_3','State Organizational Factors (DCF policy, standards, expectations)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(74,74,17,NULL,'level_4','County Organizational Factors (County board, county norms, etc.)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(75,75,17,NULL,'level_5','Local Worker Activities, Conditions, & Processes (case worker decisions, training, technology)','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(76,1,18,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(77,2,18,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(78,3,18,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(79,4,18,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(80,5,18,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(81,81,19,NULL,'level_1','Control Factors','Control Factors',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(82,82,19,NULL,'level_2','Conditional Factors','Conditional Factors',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(83,83,19,NULL,'level_3','Human Factors','Human Factors',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(84,84,19,NULL,'level_4','Learning Point(s)','Learning Point(s)',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(85,85,19,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50','2020-10-06 15:25:50'),(86,86,20,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(87,87,20,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(88,88,20,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(89,4,20,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21','2020-07-31 12:07:21'),(90,90,20,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(91,1,21,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(92,2,21,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(93,3,21,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(94,4,21,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(95,5,21,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(96,2,22,NULL,'level_2','Control Factors','Control Factors',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(97,3,22,NULL,'level_3','Condiitonal Factors','Condiitonal Factors',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(98,4,22,NULL,'level_4','Human Factors','Human Factors',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(99,5,22,NULL,'level_5','Learning Point(s)','Learning Point (s)',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(100,1,23,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-10-01 19:29:58','2020-10-01 19:29:58',NULL),(101,2,23,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-10-01 19:29:58','2020-10-01 19:29:58',NULL),(102,3,23,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-10-01 19:29:58','2020-10-01 19:29:58',NULL),(103,4,23,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-10-01 19:29:59','2020-10-01 19:29:59',NULL),(104,5,23,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-10-01 19:29:59','2020-10-01 19:29:59',NULL),(105,2,24,NULL,'level_2','Control Factors','Control Factors',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL),(106,3,24,NULL,'level_3','Conditional Factors','Conditional Factors',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL),(107,4,24,NULL,'level_4','Human Factors','Human Factors',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL),(108,5,24,NULL,'level_5','Learning Point(s)','Learning Point(s)',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL);

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `organization_id` int(10) NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `review_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `edit_by` int(10) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (1,0,1,'5 row review','graph_1.xml','',0,'2020-06-03 09:36:56','2020-06-03 09:38:15',1,1,'2020-06-03 09:38:15'),(2,0,3,'Test Review 1','graph_2.xml','',73,'2020-06-03 12:19:46','2020-06-03 13:06:21',72,73,'2020-06-03 13:06:21'),(3,0,3,'Org. User 1 Review','graph_3.xml','',73,'2020-06-03 12:37:19','2020-06-03 13:06:21',73,73,'2020-06-03 13:06:21'),(4,0,3,'Org. User 2 Review','graph_4.xml','',74,'2020-06-03 12:37:37','2020-06-03 13:06:21',74,74,'2020-06-03 13:06:21'),(5,0,3,'My Own DevDigital Review','graph_5.xml','',0,'2020-06-03 12:55:20','2020-06-03 13:06:21',74,73,'2020-06-03 13:06:21'),(6,0,3,'Org. Row 5 Review 1','graph_6.xml','',0,'2020-06-03 13:06:48','2020-06-03 13:23:50',72,72,'2020-06-03 13:23:50'),(7,0,3,'Org. Row 5 Review 2','graph_7.xml','',0,'2020-06-03 13:10:08','2020-06-03 13:23:50',72,74,'2020-06-03 13:23:50'),(8,0,3,'Shahrukh Devdigital','','',72,'2020-06-03 13:11:48','2020-06-03 13:23:50',74,72,'2020-06-03 13:23:50'),(9,0,3,'Shahrukh Gmail','','',72,'2020-06-03 13:12:18','2020-06-03 13:23:50',73,72,'2020-06-03 13:23:50'),(10,0,3,'Admin Review 1','graph_10.xml','',74,'2020-06-03 13:26:18','2020-06-03 13:36:13',72,74,'2020-06-03 13:36:13'),(11,0,3,'Admin Review 2','graph_11.xml','',73,'2020-06-03 13:26:49','2020-06-03 13:36:13',72,73,'2020-06-03 13:36:13'),(12,0,3,'Devdigital Review 1','','',73,'2020-06-03 13:31:37','2020-06-03 13:33:14',74,73,'2020-06-03 13:33:14'),(13,0,3,'Gmail Review 1','','',0,'2020-06-03 13:31:46','2020-06-03 13:33:14',73,73,'2020-06-03 13:33:14'),(14,0,3,'Gmail Review 2','','',0,'2020-06-03 13:31:56','2020-06-03 13:33:14',73,73,'2020-06-03 13:33:14'),(15,0,3,'Devdigital Review 2','','',0,'2020-06-03 13:32:08','2020-06-03 13:33:14',74,74,'2020-06-03 13:33:14'),(16,0,3,'Devdigital Review 1','graph_16.xml','',74,'2020-06-03 13:33:30','2020-06-03 13:36:13',74,74,'2020-06-03 13:36:13'),(17,0,3,'Devdigital Review 2','','',73,'2020-06-03 13:33:39','2020-06-03 13:36:13',74,73,'2020-06-03 13:36:13'),(18,0,8,'Test','graph_18.xml','',0,'2020-06-03 16:26:59','2020-06-03 18:37:27',79,79,'2020-06-03 18:37:27'),(19,0,9,'Test the mapping software','graph_19.xml','',79,'2020-06-03 16:27:21','2020-09-25 14:36:40',80,79,NULL),(20,0,9,'Test-1','graph_20.xml','',79,'2020-06-03 18:34:18','2020-09-04 15:38:23',79,79,NULL),(21,0,9,'Child Fatality Review AF-23-65','graph_21.xml','',81,'2020-06-03 19:40:37','2020-08-17 14:56:19',80,81,'2020-08-17 14:56:19'),(22,0,9,'Commercial Superintendent - Nashville','graph_22.xml','',1,'2020-06-04 06:01:45','2020-06-12 06:19:00',1,1,NULL),(23,0,9,'Test Map 3','graph_23.xml','',81,'2020-06-10 15:40:56','2020-10-14 17:30:58',80,81,'2020-10-14 17:30:58'),(24,0,11,'Test Review 1','graph_24.xml','',86,'2020-06-12 06:22:17','2020-06-12 06:24:36',1,86,'2020-06-12 06:24:36'),(25,0,9,'test123456','graph_25.xml','',81,'2020-06-18 20:06:03','2020-10-14 17:30:58',81,81,'2020-10-14 17:30:58'),(26,0,9,'ACS Test','graph_26.xml','',81,'2020-06-23 17:16:55','2020-10-14 17:30:58',81,81,'2020-10-14 17:30:58'),(27,0,9,'test 1004','graph_27.xml','',79,'2020-06-24 15:21:03','2020-10-14 17:30:58',83,79,'2020-10-14 17:30:58'),(28,0,13,'New name of review','graph_28.xml','',0,'2020-06-26 17:34:51','2020-06-26 17:45:40',80,80,'2020-06-26 17:45:40'),(29,0,9,'check 123','graph_29.xml','',81,'2020-06-26 17:54:31','2020-08-25 17:31:14',81,81,'2020-08-25 17:31:14'),(30,0,13,'SCIR Region 2 LP1','graph_30.xml','',92,'2020-06-26 17:57:32','2020-07-13 16:17:09',92,92,NULL),(31,0,13,'SCIR Region 7','graph_31.xml','',92,'2020-07-13 16:13:36','2020-07-13 16:16:31',92,92,NULL),(32,0,14,'Test','graph_32.xml','',97,'2020-07-28 17:04:51','2020-10-14 17:31:36',97,80,'2020-10-14 17:31:36'),(33,0,14,'Test','graph_33.xml','',97,'2020-07-28 17:05:56','2020-10-14 17:31:36',97,97,'2020-10-14 17:31:36'),(34,0,17,'Test 07 28 20','graph_34.xml','',100,'2020-07-28 17:18:01','2020-07-29 14:59:08',100,80,'2020-07-29 14:59:08'),(35,0,9,'WI Map test','graph_35.xml','',81,'2020-07-29 14:09:07','2020-07-29 14:09:35',81,81,NULL),(36,0,17,'Test 07 28 20','graph_36.xml','',0,'2020-07-29 14:59:48','2020-07-29 15:01:32',80,80,'2020-07-29 15:01:32'),(37,0,17,'Test_7-29-20','graph_37.xml','',100,'2020-07-29 18:52:43','2020-08-11 19:17:50',100,100,'2020-08-11 19:17:50'),(38,0,17,'20-Q3_Test-0001_8-6-20','graph_38.xml','',100,'2020-08-03 18:56:40','2020-08-03 18:57:00',100,100,NULL),(39,0,21,'Test Map 1','graph_39.xml','',0,'2020-08-03 20:14:05','2020-08-14 18:16:15',80,83,NULL),(40,0,21,'Test Map 2','graph_40.xml','',108,'2020-08-03 20:16:03','2020-08-03 20:16:16',108,108,NULL),(41,0,21,'Test Map 3','graph_41.xml','',108,'2020-08-03 20:16:35','2020-08-03 20:16:40',108,108,NULL),(42,0,21,'Test Map 4','graph_42.xml','',108,'2020-08-03 20:16:57','2020-08-03 20:17:02',108,108,NULL),(43,0,17,'Test - Wisconsin','graph_43.xml','',99,'2020-08-06 18:11:45','2020-08-10 16:15:41',99,80,'2020-08-10 16:15:41'),(44,0,17,'Test- Wisconsin','','',99,'2020-08-06 18:42:10','2020-08-10 16:15:41',99,99,'2020-08-10 16:15:41'),(45,0,9,'test 8/6/20','graph_45.xml','',81,'2020-08-06 20:01:28','2020-08-06 20:01:43',81,81,NULL),(46,0,17,'Test - WI','graph_46.xml','',99,'2020-08-06 22:56:10','2020-08-10 16:36:25',99,99,'2020-08-10 16:36:25'),(47,0,17,'New Test Review','graph_47.xml','',115,'2020-08-10 13:46:35','2020-08-10 16:14:33',115,80,NULL),(48,0,17,'New Test Review','','',115,'2020-08-10 13:48:28','2020-08-10 13:48:33',115,115,NULL),(49,0,17,'New WI Test Review','graph_49.xml','',115,'2020-08-10 13:51:49','2020-08-10 14:43:16',115,115,NULL),(50,0,17,'New WI Test Review','','',115,'2020-08-10 14:25:08','2020-08-10 14:26:14',115,115,NULL),(51,0,17,'20-Q3_Milw-962_KO1_8-11-20','graph_51.xml','',100,'2020-08-10 14:44:56','2020-08-10 14:45:56',100,100,NULL),(52,0,17,'20-Q3_Keno-968_KO2_8-11-20','graph_52.xml','',100,'2020-08-10 14:53:29','2020-08-10 15:25:20',100,100,NULL),(53,0,17,'20-Q3_Milw-973_KO1_8-12-20','graph_53.xml','',100,'2020-08-10 14:59:05','2020-08-10 14:59:22',100,100,NULL),(54,0,17,'20-Q3_Milw-973_KO2_8-12-20','graph_54.xml','',100,'2020-08-10 15:00:17','2020-08-10 15:00:32',100,100,NULL),(55,0,17,'20-Q3_Brown-991_KO1_8-18-20','graph_55.xml','',100,'2020-08-10 15:01:17','2020-08-10 15:01:29',100,100,NULL),(56,0,17,'20-Q3_Keno-968_KO1_8-11-20','graph_56.xml','',100,'2020-08-10 15:26:49','2020-08-11 15:35:13',100,100,NULL),(57,0,12,'20-02','graph_57.xml','',87,'2020-08-11 02:48:07','2020-08-11 02:48:23',87,87,NULL),(58,0,12,'20-89','graph_58.xml','',87,'2020-08-11 15:34:37','2020-08-11 15:34:51',87,87,NULL),(59,0,12,'20-90','graph_59.xml','',87,'2020-08-11 16:21:41','2020-08-11 16:21:58',87,87,NULL),(60,0,12,'Crystal test','graph_60.xml','',94,'2020-08-11 16:38:25','2020-08-11 16:38:44',94,94,NULL),(61,0,17,'V2_20-Q3_Milw-973_KO1_8-12-20','graph_61.xml','',99,'2020-08-12 14:20:05','2020-08-12 14:20:27',99,99,NULL),(62,0,12,'18-42','graph_62.xml','',120,'2020-08-12 15:54:50','2020-08-12 18:33:23',120,120,NULL),(63,0,12,'19-01','graph_63.xml','',120,'2020-08-12 18:28:37','2020-08-12 18:28:51',120,120,NULL),(64,0,12,'Sophia Test','graph_64.xml','',121,'2020-08-13 13:00:52','2020-08-13 13:01:33',121,121,NULL),(65,0,12,'Lakesha Test','graph_65.xml','',119,'2020-08-13 13:58:23','2020-08-13 13:58:50',119,119,NULL),(66,0,9,'test 1004','','',83,'2020-08-13 17:04:15','2020-08-13 17:04:19',83,83,NULL),(67,0,9,'Mapping test for MN DSD','graph_67.xml','',81,'2020-08-14 15:25:55','2020-08-14 15:26:13',81,81,NULL),(68,0,14,'JT Mapping 8/18/20','graph_68.xml','',1,'2020-08-17 16:26:55','2020-08-28 06:20:32',82,1,NULL),(69,0,17,'20_Q3_Brown_991_KO1','graph_69.xml','',99,'2020-08-18 13:41:25','2020-08-18 13:41:42',99,99,NULL),(70,0,17,'20_Q3_Brown_991_KO1_Version 2','graph_70.xml','',99,'2020-08-18 13:49:23','2020-08-18 13:49:46',99,99,NULL),(71,0,22,'SLR II Demo','graph_71.xml','',79,'2020-08-24 18:54:34','2020-09-11 19:37:12',79,79,NULL),(72,0,9,'test999','graph_72.xml','',1,'2020-08-25 17:10:58','2020-08-28 13:31:22',80,1,NULL),(73,0,9,'test26','graph_73.xml','',0,'2020-08-26 05:26:04','2020-08-28 13:31:14',1,1,NULL),(74,0,22,'NH OCA Test','graph_74.xml','',79,'2020-08-27 13:02:39','2020-08-27 13:02:53',79,79,NULL),(75,0,22,'Test123456','graph_75.xml','',0,'2020-08-27 17:36:07','2020-08-27 18:42:05',80,80,NULL),(76,0,22,'CASE 1','graph_76.xml','',135,'2020-08-27 18:51:12','2020-09-11 18:08:47',135,79,NULL),(77,0,22,'Test','graph_77.xml','',134,'2020-08-27 18:51:58','2020-09-16 21:09:45',134,79,NULL),(78,0,22,'Cold','graph_78.xml','',133,'2020-08-27 18:52:02','2020-08-27 18:54:08',133,133,NULL),(79,0,22,'CaseID 123456','graph_79.xml','',138,'2020-08-27 18:52:03','2020-08-27 18:52:24',138,138,NULL),(80,0,22,'Test','','',0,'2020-08-27 18:54:27','2020-08-27 18:54:27',133,133,NULL),(81,0,22,'Test #1','graph_81.xml','',133,'2020-08-27 18:54:48','2020-08-27 18:55:01',133,133,NULL),(82,0,22,'test','graph_82.xml','',135,'2020-08-27 18:55:27','2020-08-27 18:55:43',135,135,NULL),(83,0,19,'419309806','graph_83.xml','',95,'2020-08-28 15:42:58','2020-08-28 15:43:50',95,95,NULL),(84,0,9,'Test','graph_84.xml','',79,'2020-09-04 15:37:13','2020-10-14 17:31:36',79,79,'2020-10-14 17:31:36'),(85,0,22,'whatever you want','','',0,'2020-09-11 18:09:27','2020-09-11 18:09:27',132,132,NULL),(86,0,22,'Whatever you want','','',134,'2020-09-11 18:09:31','2020-09-11 18:09:42',134,134,NULL),(87,0,22,'TGIF','graph_87.xml','',133,'2020-09-11 18:10:37','2020-09-11 18:11:02',133,133,NULL),(88,0,22,'whatever you want','','',0,'2020-09-11 18:10:37','2020-09-11 18:10:37',133,133,NULL),(89,0,22,'Today','graph_89.xml','',133,'2020-09-11 18:11:06','2020-09-11 18:11:19',133,133,NULL),(90,0,13,'Testing - RH','','',90,'2020-09-23 11:41:45','2020-09-23 11:41:53',90,90,NULL),(91,0,13,'Test - RH','graph_91.xml','',90,'2020-09-23 11:46:26','2020-09-23 11:46:41',90,90,NULL),(92,0,12,'20-05','graph_92.xml','',121,'2020-09-23 14:59:25','2020-09-23 15:02:54',121,121,NULL),(93,0,9,'Test review 123','graph_93.xml','',81,'2020-10-01 19:12:10','2020-10-14 17:31:36',81,81,'2020-10-14 17:31:36'),(94,0,9,'Hennepin Test1','graph_94.xml','',81,'2020-10-05 18:11:24','2020-10-14 17:31:36',81,81,'2020-10-14 17:31:36'),(95,0,19,'SSIS # 419309806','graph_95.xml','',95,'2020-10-06 14:53:26','2020-10-06 14:53:43',95,95,NULL),(96,0,19,'Test Map SLR','graph_96.xml','',0,'2020-10-06 15:26:20','2020-10-19 18:53:14',80,80,'2020-10-19 18:53:14'),(97,0,19,'MC-SLR','graph_97.xml','',95,'2020-10-06 15:43:26','2020-10-06 15:43:40',95,95,NULL),(98,0,23,'test map','graph_98.xml','',0,'2020-10-14 17:28:57','2020-10-14 17:30:41',80,80,'2020-10-14 17:30:41'),(99,0,19,'test 03','','',0,'2020-10-14 17:30:17','2020-10-14 17:30:41',80,80,'2020-10-14 17:30:41'),(100,0,9,'Case test 123','graph_100.xml','',81,'2020-10-19 18:17:24','2020-10-19 19:32:36',81,81,'2020-10-19 19:32:36'),(101,0,19,'Test 123 TEST','graph_101.xml','',0,'2020-10-19 18:21:28','2020-10-19 18:53:14',80,80,'2020-10-19 18:53:14'),(102,0,23,'HCS SCIR 2005 Bata','graph_102.xml','',139,'2020-10-19 19:12:00','2020-10-19 19:22:44',139,139,NULL),(103,0,24,'test1','graph_103.xml','',0,'2020-10-19 19:31:12','2020-10-19 19:33:10',80,80,'2020-10-19 19:33:10'),(104,0,19,'testing SLR layout','graph_104.xml','',0,'2020-10-19 19:42:00','2020-10-19 19:42:40',80,80,NULL);

--
-- Table structure for table `site_configs`
--

CREATE TABLE `site_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `val` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_configs`
--

INSERT INTO `site_configs` VALUES (1,'app_name','Collaborative Safety, LLC | Transforming culture, together.',1,'string','2019-07-10 03:16:47','2020-06-03 11:53:34',1,72,NULL),(2,'image','GH78FUUXuSP2X8YlJ1k0401qyOU9J1WD9w3zHWur.png',1,'string','2019-07-10 03:16:47','2019-07-10 03:31:07',1,1,NULL),(3,'records_per_page','100',1,'int','2019-07-10 03:16:47','2020-03-19 07:18:01',1,47,NULL),(4,'footer_title_for_admin','Collaborative Safety, LLC. All rights reserved.',1,'string','2019-07-10 03:16:47','2020-04-29 05:54:13',1,47,NULL),(5,'site_title','Home | Collaborative Safety',1,'string','2019-07-10 03:16:47','2020-01-02 13:12:51',1,30,NULL),(6,'tagline','',1,'string','2019-07-10 03:16:47','2019-10-02 00:44:03',1,1,NULL),(7,'copyright_text','© 2019 All Rights Reserved by Collaborative Safety',1,'string','2019-07-10 03:16:47','2020-01-02 13:10:28',1,30,NULL),(8,'phone','123-456-7890',1,'string','2019-07-10 03:16:47','2020-01-02 13:12:30',1,30,NULL),(9,'from_name','Collaborative Safety, LLC | Transforming culture, together.',1,'string','2019-07-10 03:16:48','2020-06-03 11:53:34',1,72,NULL),(10,'from_email','mapping@collaborative-safety.com',1,'email','2019-07-10 03:16:48','2020-06-03 11:53:34',1,72,NULL),(11,'admin_email','mapping@collaborative-safety.com',1,'email','2019-07-10 03:16:48','2020-06-03 11:53:34',1,72,NULL),(12,'robots_meta_tag',NULL,1,'string','2019-07-10 03:16:48','2020-06-03 11:23:47',1,1,NULL),(13,'google_analytics_code',NULL,1,'string','2019-07-10 03:16:48','2019-07-10 03:16:48',1,1,NULL),(14,'advantage_title','Why The laravelmvc Systems?',1,'string','2019-07-11 06:36:58','2019-07-11 06:37:13',1,1,NULL),(15,'advantage_sub_title','Our advantages',1,'string','2019-07-11 06:36:58','2019-07-11 06:37:13',1,1,NULL),(16,'our_team_title','Why The laravelmvc Team?',1,'string','2019-07-11 06:41:41','2019-07-11 06:42:05',1,1,NULL),(17,'our_team_sub_title','Who are we',1,'string','2019-07-11 06:41:41','2019-07-11 06:42:05',1,1,NULL),(18,'disadvantage_title','The Not So Pure Alternatives',1,'string','2019-07-11 06:45:09','2019-07-11 06:45:09',1,1,NULL),(19,'disadvantage_sub_title','Disadvantages of others',1,'string','2019-07-11 06:45:09','2019-07-11 06:45:09',1,1,NULL),(20,'contact_title','Leave a request \r\nand our manager will contact you',1,'string','2019-07-11 06:50:03','2019-07-15 02:51:44',1,1,NULL),(21,'contact_sub_title','Any questions?',1,'string','2019-07-11 06:50:03','2019-07-15 04:04:33',1,1,NULL),(22,'email','monali.rana@devdigital.com',1,'string','2019-07-11 06:51:58','2019-08-05 05:52:44',1,1,NULL),(23,'disadvantage_left_section_title','Bottles & Jugs',1,'string','2019-07-11 06:59:59','2019-07-11 06:59:59',1,1,NULL),(24,'disadvantage_right_section_title','Water Fountains, Bottle Fillers, Non RO Systems',1,'string','2019-07-11 06:59:59','2019-07-11 06:59:59',1,1,NULL),(25,'contact_thank_you_message','Thank you for contacting us. We will respond to you as soon as possible.',1,'string','2019-07-14 22:57:46','2019-07-15 04:04:13',1,1,NULL),(26,'freetrial_title','Leave a request to schedule a free trial',1,'string','2019-07-15 02:51:06','2019-07-15 02:51:06',1,1,NULL),(27,'freetrial_thank_you_message_title','Great water is on the way!',1,'string','2019-07-15 02:51:06','2019-07-15 02:51:06',1,1,NULL),(28,'freetrial_thank_you_message_description','Your H2O Consultant will\r\ncontact you shortly',1,'string','2019-07-15 02:51:06','2019-07-15 03:16:03',1,1,NULL),(29,'referral_title','Share Your Love for\r\nlaravelmvc and Earn Cash',1,'string','2019-07-15 02:51:21','2019-07-15 03:19:10',1,1,NULL),(30,'referral_description','If you know of anyone who is using the 5-gallon jugs, or anyone who would enjoy our solution, please fill out the information below',1,'string','2019-07-15 02:51:21','2019-07-15 02:51:21',1,1,NULL),(31,'referral_thank_you_message','Thank you for referring the Contact. Our H2O Consultant will contact you shortly.',1,'string','2019-07-15 02:51:21','2019-07-17 00:00:20',1,1,NULL),(32,'logo',NULL,1,'file','2019-08-06 01:09:10','2019-08-06 01:09:10',1,1,NULL),(33,'blog_title','The Not So Pure Alternatives',1,'string','2019-08-06 06:59:36','2019-08-06 06:59:36',2,2,NULL),(34,'blog_sub_title','Sub Blog',1,'string','2019-08-06 06:59:36','2019-08-06 06:59:36',2,2,NULL),(35,'meta_description_for_front','',1,'string','2019-10-02 00:44:04','2019-10-02 00:44:04',1,1,NULL),(36,'company_name','Collaborative Safety',1,'string','2019-10-02 00:44:04','2019-10-25 20:27:39',1,24,NULL),(37,'company_address_line1','TEA Building 801 2nd Ave. N. 3rd Floor',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(38,'company_address_line2','',1,'string','2019-10-02 00:44:04','2019-10-02 00:44:04',1,1,NULL),(39,'company_city','Nashville',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(40,'company_state','TENNESSEE',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(41,'company_country','United States',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(42,'company_zipcode','37201',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(43,'company_email','contact@collaborativesafety.com',1,'email','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(44,'password_strength','Strong',1,'string','2019-10-02 00:44:05','2020-06-03 11:45:56',1,1,NULL),(45,'login_attempt','3',1,'int','2019-10-02 00:44:05','2020-03-19 07:17:20',1,47,NULL),(46,'minimum_password_length','5',1,'int','2019-10-02 00:44:05','2020-06-03 11:45:44',1,1,NULL),(47,'user_block_time','1',1,'int','2019-10-02 00:44:05','2019-10-02 00:44:05',1,1,NULL);

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) 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 `user_types`
--

INSERT INTO `user_types` VALUES (1,'Super Admin',1,'2019-07-02 18:30:00','2019-07-02 18:30:00',1,1,NULL),(2,'Admin',1,'2019-07-02 18:30:00','2019-07-02 18:30:00',1,1,NULL),(3,'organization user',1,'2019-07-02 18:30:00','2019-07-02 18:30:00',1,1,NULL);

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

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_type_id` tinyint(4) NOT NULL DEFAULT '1',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_image` char(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `last_login_at` timestamp NULL DEFAULT NULL,
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_user_type_id_foreign` (`user_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,1,'vikas.jain@devdigital.com','$2y$10$KHlN9k6h/na0x.YzpDtQke88NGR.ue7k/186rSObihqXiPHSqxuka','Collaborative','Safety','c62d868cf3d4617d8027980b13560bde31e90835.png',1,'TJ4UQNUNOJAGB9DRnUo2rvwxf9sYg2Ur225191paXvTKFFYjaFehUfq7vs1m','2019-08-06 06:26:05',NULL,NULL,'2019-08-05 04:04:00','2020-06-03 11:42:03',1,1,NULL),(71,3,'mitesh.parmar@devdigital.com',NULL,'mitesh','parmar',NULL,0,NULL,NULL,NULL,NULL,'2020-06-03 10:50:02','2020-06-03 10:50:44',1,1,'2020-06-03 10:50:44'),(72,1,'shahrukh.shaikh@devdigital.com',NULL,'Shahrukh','Shaikh','',0,'yghPU3PtvNHKLQt9FO2gOkYZQysZzIazSYLts8BayseRqTWCBAYyNbSgiUAi',NULL,NULL,NULL,'2020-06-03 11:42:42','2020-06-12 06:29:22',1,1,'2020-06-12 06:29:22'),(73,3,'shaikhshahrukh124@gmail.com','$2y$10$cTiizMpCVahD54m9QtnhJOHD2Wu4OxpAX/IPzooXEvf0jvP/g/Et6','Shahrukh','Gmail',NULL,1,'ORJFdMiqmkfCeiLhSPAhIeaSECOlylosLxSrGRWGEIuKe3K0v7S2C1ZPGELJ','2020-06-03 11:59:29',NULL,NULL,'2020-06-03 11:58:04','2020-06-03 13:36:32',72,73,'2020-06-03 13:36:32'),(74,3,'shahrukh.devdigital@gmail.com','$2y$10$2tU00rVR3jmaEcN/GMzVn.OCxnm.q4gzFuMbV1tb95gVNU2hCgdxC','Shahrukh','Devdigital',NULL,1,'jayW7Kftcu7ZAF8wHx6HH28QwNFa8d6ikijGfa0fbkj8DiqUUABb3pQQmizz','2020-06-03 11:59:40',NULL,NULL,'2020-06-03 11:58:40','2020-06-03 13:36:32',72,74,'2020-06-03 13:36:32'),(75,1,'daniel@devdigital.com','$2y$10$kQxj80NwlJ.JshgyfTSx0uopaacs9e0XFA6j8H2s0svokHaU4x/l.','Daniel','McMahan',NULL,1,'QZPXaAIzHjtnm2n03R9z9C9o932bc4YA4Imh9Xy9FAda2rRPfQ5up2frZUmZ','2020-06-03 13:40:51',NULL,NULL,'2020-06-03 13:38:13','2020-06-03 13:40:51',1,75,NULL),(76,1,'tom@devdigital.com',NULL,'Tom','Ross',NULL,0,NULL,NULL,NULL,NULL,'2020-06-03 13:41:12','2020-06-03 13:41:12',75,75,NULL),(77,1,'dg@collaborative-safety.com',NULL,'Dave','Garrett',NULL,0,NULL,NULL,NULL,NULL,'2020-06-03 13:41:19','2020-06-03 13:41:19',75,75,NULL),(78,1,'sm@collaborative-safety.com','$2y$10$NUkxIlJl/ozLrvDH0KxQPO7aANw6iat3YSCBqbPKbhE/Mk9rP2vqq','Scott','Modell',NULL,1,'htJH5aRoK3nGgvjPbfK97GtJV4ISVY3bvUdXF3RVyUiFCIBYM7j5kNAjPNhv','2020-06-03 15:26:34',NULL,NULL,'2020-06-03 13:41:23','2020-06-03 15:26:34',75,78,NULL),(79,1,'Nh@collaborative-safety.com','$2y$10$Mgzs/CRxPuOzuBP7HgCYAeIbxG6Z6a2xZhi53FcMfMNM2p.MzsyHC','Noel','Hengelbrok','0905ac67ae2ac5c43d64058b9d69537faa9f31eb.JPG',1,'VgBaqHfT6QQM8MEaoDnn7gzp4yz2dlyw1Zd6aoPMokh9xHrGY2VkoSklYTQj','2020-06-03 13:46:16',NULL,NULL,'2020-06-03 13:41:26','2020-06-03 18:25:41',75,79,NULL),(80,1,'kw@collaborative-safety.com','$2y$10$F7ZWZbLV6uD.v1po4KJ./eZOiR.X7VKjDtfi9Kpyd0gLUNyeJbSk2','Kenny','Weaver',NULL,1,'Mo63vaGCyTNUoL42Mlr5YvQLK4WMNj0nTsC73p1CNXqGU1Jp0aNU97Aq0UYZ','2020-06-03 16:25:18',NULL,NULL,'2020-06-03 13:47:44','2020-06-03 16:25:18',79,80,NULL),(81,3,'mrkjweaver@gmail.com','$2y$10$Hsg8wdlpALvvmJKX/BOlAeqp9gMhikKFo8xiL0QFFuBG29dkAQiS6','Johnny','Test',NULL,1,'dFesGo1yoYYIswkM6X8QA2yiKBpQ7WGVKlyzFajRlM767TXTSmBxeCyq5ZRt','2020-06-10 15:12:11',NULL,NULL,'2020-06-09 14:37:57','2020-06-10 15:12:11',80,81,NULL),(82,1,'cm@collaborative-safety.com','$2y$10$6x2vh.h0EhEUFnjJZipHROtnigE2vptQAZvGTFA//A37FfOL8bC7.','Casey','Melsek',NULL,1,'emH4rMZc30wLzMJ7b99EpViblTOVvF1it1ijI45WktPUYCs20Slmi0CX2Yjw','2020-06-10 16:02:32',NULL,NULL,'2020-06-10 15:30:16','2020-06-10 16:02:32',79,82,NULL),(83,1,'ne@collaborative-safety.com','$2y$10$2QIuKIoualCeQQfRAHwV1e4lt4.Fhp/6YX3XFtCWncNJf/mT/.QeO','Natia','Ellis',NULL,1,'Dk5nSkPyEWbLrwTRtMbutKJgUvZBexYdcGqrUpH1TUwhU4LqCAWGZ1if5cWc','2020-06-24 15:08:21',NULL,NULL,'2020-06-10 15:30:47','2020-06-24 15:08:21',79,83,NULL),(84,1,'kk@collaborative-safety.com',NULL,'Kelly','Knutson',NULL,0,NULL,NULL,NULL,NULL,'2020-06-10 15:31:09','2020-06-10 15:31:09',79,79,NULL),(85,3,'johnny@myeyedesigns.com',NULL,'Johnny','Jackson',NULL,0,NULL,NULL,NULL,NULL,'2020-06-10 15:42:37','2020-06-10 15:44:17',1,1,'2020-06-10 15:44:17'),(86,3,'shahrukhtest22@getnada.com','$2y$10$4D3dULJIOGp2MFdD5rTEG.k7irDK0W5phuXCUGsF134ZuEoyTBlMG','Shahrukh','Test',NULL,1,'Y8v1TnCfFWEtj15j1xV4fXloocVnZkbQruafvkAskcInbQ6ZqvYdic4b9Ibh','2020-06-12 06:21:40',NULL,NULL,'2020-06-12 06:20:38','2020-06-12 06:25:11',1,86,'2020-06-12 06:25:11'),(87,3,'Cynthia.Franco@acs.nyc.gov','$2y$10$TnxxQApexcI4VEtxHzOB6O5qFSf1ILuDGeg0Tz/jYJ/.BGAZueO5G','Cynthia','Franco',NULL,1,'fOqYCSC3s4w8YyimcxNQRuKuMucffy8V5E4KQ9NltvaHwhhfs9gdNPhV0oDc','2020-08-10 21:50:25',NULL,NULL,'2020-06-24 14:22:58','2020-08-11 02:53:25',80,87,NULL),(88,3,'Donna.Lawrence@acs.nyc.gov','$2y$10$7ZPFA9aKyAs45E7U6z3a7.oXybiPLRCpjbb0bAGeruFW/3u6rH9KK','Donna','Lawrence',NULL,1,'qLY01NAexIXvX4m2sVtqRWK0rhvne0kfV0fEXR1nIEUeXZgCpWDqZ0jPCjlQ','2020-08-10 21:48:55',NULL,NULL,'2020-06-24 14:24:32','2020-08-11 15:34:16',80,88,NULL),(89,3,'Ancil.Payne@acs.nyc.gov',NULL,'Ancil','Payne',NULL,0,NULL,NULL,NULL,NULL,'2020-06-24 14:27:47','2020-06-24 14:27:47',80,80,NULL),(90,3,'ryan.hartneck@state.mn.us','$2y$10$6gP.uMJ5QYLsHPa15hbtUOFtAZzc2SahXmt85yjLur4Firvs2E1TG','Ryan','Hartneck',NULL,1,'JtvSYuq1ACTKP56G0CadfOfFc7KKDevhv8tRPkg6LgWw7H7FmOmtFO8qhyFw','2020-06-25 12:52:01',NULL,NULL,'2020-06-24 14:57:44','2020-06-25 12:52:01',80,90,NULL),(91,3,'brittany.lochner@state.mn.us','$2y$10$6tFMxrGYzdBTkGNWXqrL.e8LYXAyN1rs4hc6GTbSNb3G3ejK7T0YC','Brittany','Lochner',NULL,1,'kXJFhlqiBsWEgyZKn8VM0hiS4zJEVgZqwbvO5PXjTHgWZPUx8as0oemjdPe0','2020-06-24 15:02:08',NULL,NULL,'2020-06-24 14:59:30','2020-06-24 15:02:08',80,91,NULL),(92,3,'kristine.frick@state.mn.us','$2y$10$W.I.vsq4AR2nfgNIPHYciOSxPHKQdKHNG4mCKtNHb0voEXYrVh1xe','Kristine','Frick',NULL,1,'aeLXck2BfykXUU09Hr2meOFcv4X7IRzUEMZrg5gQETxyqqhrNsD8CueKa3CZ','2020-06-24 15:32:22',NULL,NULL,'2020-06-24 15:01:05','2020-06-24 15:32:22',80,92,NULL),(93,3,'lori.munsterman@state.mn.us','$2y$10$fb1/bwI5Yc3WXJg.UYjO1O/O/nMiweXPuAXLI7LLcgAGoZ6ISLc2u','Lori','Munsterman',NULL,1,'JxhjeYw5gNkYzTyoqo62yNSfA1ZcAPjD1MhnHxZGqxkOgThtv1ORrcuwsoCh','2020-06-25 18:42:15',NULL,NULL,'2020-06-24 15:01:54','2020-06-25 18:42:15',80,93,NULL),(94,3,'Crystal.Ramos@acs.nyc.gov','$2y$10$UyKUNLelwZxeEn2iGiDLrugqMmK0zES0ko9SwXuAhovl7padCc.7K','Crystal','Ramos',NULL,1,'9P0XDPGtjBaXYokRF99ArskaND0qMooVb0TwebQKX7Kctf6Cgl0CT8Ba2aFl','2020-08-10 19:08:58',NULL,NULL,'2020-07-16 18:37:49','2020-08-11 16:36:56',80,94,NULL),(95,3,'paul.lennander@hennepin.us','$2y$10$vGAwyFLuE2Lvg.07EI3Fdu2PSUKab0H5MDd6XGmFmELqTT3Eikq9y','Paul','Lennander',NULL,1,'raCH9FF9CiIKWeTkhNJn9t07L5gysRoC9eQhVFsA7Y7GFKtrZ4NQSwbEQ53w','2020-08-28 15:41:30',NULL,NULL,'2020-07-17 02:25:59','2020-08-28 15:41:30',80,95,NULL),(96,3,'Amanda.Craig@dcf.nj.gov',NULL,'Amanda','Craig',NULL,0,NULL,NULL,NULL,NULL,'2020-07-28 13:40:41','2020-07-28 13:40:41',80,80,NULL),(97,3,'Michael.Garr@dcf.nj.gov','$2y$10$fnwuVYBvs7iTeRleZqSPm.oUg.Ts/f7O4mpFAfkDkTR4WyqNQ7ixu','Michael','Garr',NULL,1,'ODm1h3EuoRcAtKyWptsX0yAlV8Dw3X3Gpzx0w3oHab0JBQ1teoFYVDIimfdW','2020-07-28 16:34:23',NULL,NULL,'2020-07-28 13:53:58','2020-07-28 16:34:23',80,97,NULL),(98,3,'Charyl.Yarbrough@dcf.nj.gov',NULL,'Charyl','Yarbrough',NULL,0,NULL,NULL,NULL,NULL,'2020-07-28 13:56:07','2020-07-28 13:56:07',80,80,NULL),(99,3,'jamie.gennrich1@wisconsin.gov','$2y$10$B9AoPgWMJkkuAyX/BQVijubz8LM7cYTR.UV5eHcgosWtawt4HhAsW','Jamie','Gennrich','',1,'8iQHzUicrmmECOOUXzhqNSuPlSTF5DV7z8H1pA4gbJ1QprNZxIgx78RmuWHn','2020-07-28 17:32:20',NULL,NULL,'2020-07-28 15:56:44','2020-08-06 18:11:22',80,0,NULL),(100,3,'Alexandra.Mattia@wisconsin.gov','$2y$10$X5IiwFlKA3xXO4VhyhKoKOtzRFXRtxotN6lC6RNFjQIK6XN.p2j0G','Lexi','Mattia',NULL,1,'Tovf1DF9l2PTTAmVHNQqE89x5KmhdB4sWdLsZjpUOE1ziJHdcg4U1cTj7KBV','2020-07-28 17:17:05',NULL,NULL,'2020-07-28 15:57:17','2020-07-28 17:17:05',80,100,NULL),(101,3,'abcd@ab.cd.a.xy',NULL,'aa','aa',NULL,0,NULL,NULL,NULL,NULL,'2020-07-29 10:13:44','2020-07-29 10:35:39',1,1,'2020-07-29 10:35:39'),(102,3,'mitesh.parmar@dev.dig.ital.com',NULL,'mitesh','parmar',NULL,0,NULL,NULL,NULL,NULL,'2020-07-29 10:18:10','2020-07-29 10:35:57',1,1,'2020-07-29 10:35:57'),(103,3,'nilesh.rathod@devdigital.com','$2y$10$nBryGeTb/7AUaGkLKim3oO.1cvyAuXk5zpeNwx.7Vo.yvU/fn7tT6','Nileshsinh','Rathod',NULL,1,'nnrABQxHDlNofMKJ0nsxMsOjOEhy154FpYYed1Rv0erSyEsDU64gnbAbrUF3','2020-07-31 12:10:26',NULL,NULL,'2020-07-31 12:09:41','2020-07-31 12:10:59',1,103,'2020-07-31 12:10:59'),(104,3,'cstraining1@yahoo.com','$2y$10$mo1bj5Pxp6rUrkzEMptU9.CNmi5MB9FgCnCv75pXAlrZv.qkDPVdi','CS','Training1',NULL,1,'njyCQ4s0zsRGwGmQWmwi3YR7KnWVPlYbUMN645QNFM1m6LIvzijP4lAn5YXs','2020-08-03 19:28:51',NULL,NULL,'2020-08-03 19:27:51','2020-08-12 13:13:32',80,80,NULL),(105,3,'cstraining3@yahoo.com','$2y$10$Jgl9mkDu1kKeXICRvjNzTucOiJ/xJLj2/Yvp843yOUDZr1ORykBzi','CS','Training3',NULL,1,'dEnUa1Ua7TDzDRZFw6vZuCxbltn5dDPkq53stionC9OpkudFPXTS1shS9jjq','2020-08-03 19:42:53',NULL,NULL,'2020-08-03 19:30:07','2020-08-10 21:52:19',80,80,NULL),(106,3,'cstraining5@yahoo.com','$2y$10$lkaIrqlMbPQ5eEsS50oT6ex4CpqkDTBN0PydLnkiV1WwK6k0Sj1x2','CS','Training5',NULL,1,'o2CzA5ePpkx4w5TVBQxc0PbnMVO3y6NS2av02laCnHHLAFC88wr73OARiCSI','2020-08-03 19:44:09',NULL,NULL,'2020-08-03 19:40:08','2020-08-10 21:52:03',80,80,NULL),(107,3,'cstraining7@yahoo.com','$2y$10$5kiSvM6AeOzfnWeblPfLI.pu/QZpAkaaj6zHWMbgK65/W5W3CqufC','CS','Training7',NULL,1,'Aq8z89aaaOYa8ObUbKkWU98siNSLHMCIhD9oNOh61V9QeTvMsvOULtmM4MC9','2020-08-03 19:45:19',NULL,NULL,'2020-08-03 19:40:57','2020-08-03 19:45:19',80,107,NULL),(108,3,'cstraining9@yahoo.com','$2y$10$9kQ1.Ukav5V8lPpGa0K4B.FwmnlzreFguquYfB34dav6vQxvTedlS','CS','Training9',NULL,1,'8pI8YSJfvRe40X4Z4S3HwF1noiePoQBscoefWrjYkstZNd1zSZNG5ZFGhTqH','2020-08-03 19:49:01',NULL,NULL,'2020-08-03 19:41:44','2020-08-03 19:49:01',80,108,NULL),(109,3,'weberamy@uwm.edu',NULL,'Amy','Weber',NULL,0,NULL,NULL,NULL,NULL,'2020-08-06 20:12:16','2020-08-06 20:12:16',80,80,NULL),(110,3,'acleland@wisc.edu',NULL,'Andrea','Cleland',NULL,0,NULL,NULL,NULL,NULL,'2020-08-06 20:12:55','2020-08-06 20:12:55',80,80,NULL),(111,3,'erika.winterfeldt@fdlco.wi.gov',NULL,'Erika','Winterfeldt',NULL,0,NULL,NULL,NULL,NULL,'2020-08-06 20:41:50','2020-08-06 20:41:50',80,80,NULL),(112,3,'jhrubes@crawfordcountywi.org','$2y$10$7NZ2BcIs/GwWZ52qA/EPTu4XhlN3gyXovbBmS8ZeHYzFLFM/w.tuy','Jada','Hrubes',NULL,1,'reprvKb9BzaR8yXIIjpYVVv7mh0Mwd3lNYsGPvYPFsUHnDGnTB1dtEKiJtnF','2020-08-06 21:12:38',NULL,NULL,'2020-08-06 20:42:26','2020-08-06 21:12:38',80,112,NULL),(113,3,'edds@countyofdane.com',NULL,'Jennifer','Edds',NULL,0,NULL,NULL,NULL,NULL,'2020-08-06 20:42:58','2020-08-06 20:42:58',80,80,NULL),(114,3,'kay.reinhard@fdlco.wi.gov',NULL,'Kay','Metty-Reinhard',NULL,0,NULL,NULL,NULL,NULL,'2020-08-06 20:43:30','2020-08-06 20:43:30',80,80,NULL),(115,3,'Melinda.Mommaerts@browncountywi.gov','$2y$10$LplLhwnj9/iGzpyhLKfW0e2ag2zdPBzWMiA.EVFNs1UnxA07llb6S','Melinda','Mommaerts',NULL,1,'6Pnw225XEcsyQan6aW7MCvvkE2dOExmQf07KZXVsCjAPzIJx5dG6lJYce6Sp','2020-08-10 13:39:04',NULL,NULL,'2020-08-06 20:44:18','2020-08-10 13:39:04',80,115,NULL),(116,3,'serena.breining@wisc.edu','$2y$10$kDkLEDeShIDxL/hExQ3dq.2Ew0wvhWPpw8BBEJgU0Syt5onfcHaUm','Serena','Breining',NULL,1,'AocIZN0RTTJL0Szb1HdXNFezm8jw3hLbrBCAm6JKsmXGmlqra6mMSzoQamvt','2020-08-06 20:47:21',NULL,NULL,'2020-08-06 20:45:02','2020-08-06 20:47:21',80,116,NULL),(117,3,'Tyler.Oettinger@wisconsin.gov',NULL,'Tyler','Oettinger',NULL,0,NULL,NULL,NULL,NULL,'2020-08-06 20:45:38','2020-08-06 20:45:38',80,80,NULL),(118,3,'alexis.porter@acs.nyc.gov','$2y$10$gynrDDu3CX23nbYxLmpwlOLDrFVhrK.WIA2uXtT3H8gJOkIX8J4IC','Alexis','Porter',NULL,1,'pQL3DjNmTWvZ7g5tMMfgWPGpn6kzFMlX0tIuMVffF5wI44yQQNRSqV0BDpun','2020-08-12 13:04:26',NULL,NULL,'2020-08-12 12:55:28','2020-08-12 13:05:49',80,80,NULL),(119,3,'lakesha.balkcom@acs.nyc.gov','$2y$10$Em4iPcFqPRfq2YPQYERwxeXsEea9BaJ16yVA4peg6Vzd.agxkSM0i','Lakesha','Balkcom',NULL,1,'pPlAR9ckLGOrCQuE8QACcnUHyJwzG7tBybYqVm3GTibUfG6IsqilC6jjHkti','2020-08-12 13:11:04',NULL,NULL,'2020-08-12 12:56:12','2020-08-12 13:54:27',80,119,NULL),(120,3,'catherine.risola@acs.nyc.gov','$2y$10$EwiO5hyXtB6FHJgMFdxDZuwhLjbZhf81Atf3cnJ6C7NZu4ffhWSGe','Catherine','Risola',NULL,1,'vkLshwEXBxpoXgxO9vat8uBodl5Ril6ed5WwcJzinRV594SlOVBleOkBBvWt','2020-08-12 13:07:07',NULL,NULL,'2020-08-12 12:57:57','2020-08-12 18:26:18',80,120,NULL),(121,3,'sophia.blackstock@acs.nyc.gov','$2y$10$e3jtAEFcUGUVyA2ygtB47u7me5PQS5oRWLkZpA3b8uHjDOlpf1OJi','Sophia','Blackstock',NULL,1,'NRenrfAlvfz0GWuBllEE7dzRIB5RuUhuOgbpT1HmtwGB5SDVEWThktmkfPB3','2020-08-12 13:12:42',NULL,NULL,'2020-08-12 12:59:50','2020-08-12 14:14:27',80,121,NULL),(122,3,'anthony.tucci@acs.nyc.gov','$2y$10$NxUmVsUmxaHzUoux.iN5q.z3DuLbdq6R7LiAkwPh/SN1rZhDBodim','Anthony','Tucci',NULL,1,'HDwvvdCdAIgF0rXDlNOB1appP0Rc2fWBUlIm5mdUMTSwlV6MFkySQYlIMSoG','2020-08-12 13:08:52',NULL,NULL,'2020-08-12 13:00:27','2020-08-12 13:31:17',80,122,NULL),(123,3,'charles.young@state.mn.us','$2y$10$McrNdHQUW2YYL3J0tzAn3u06YK8/HVppJn.1pernuoSYM4owVlefe','Charles','Young',NULL,1,'LfFQGnhPeIYWVARGN5XByU8TOqUg6Z8B8gAh2YHOmDBo57FkEO2CTs5MvDYS','2020-08-14 16:08:29',NULL,NULL,'2020-08-14 15:50:48','2020-08-14 16:08:29',80,123,NULL),(124,3,'aric.gregg@state.mn.us','$2y$10$1wed6tLjuTbYdLomY95svOnBZm/tr8Kji4kNBzBpSw1c3Jb6a4zVa','Aric','Gregg',NULL,1,'yA8Wf0S4bvZTCt5c6ESfZPQPpKymQnfRklF7NliPf7UJEpqIiamTNZVIINrk','2020-08-14 16:09:07',NULL,NULL,'2020-08-14 15:51:26','2020-08-14 16:09:08',80,124,NULL),(125,3,'Kimette.Almon@hennepin.us','$2y$10$CLvBBW2Nns3A6r6LxRfRR.L.DKSvEvGNRlQq1K9RA4h6Y0O./G5N6','Kimette','Almon',NULL,1,'6DsXeL0sRAFaL4AFXHjzhd3i9P102rxOe4IoWZ9cLGNT7mHY3lk3qrrvohbM','2020-08-20 16:14:10',NULL,NULL,'2020-08-20 14:03:33','2020-08-20 16:14:10',80,125,NULL),(126,3,'colette.davis@hennepin.us',NULL,'Colette','Davis',NULL,0,NULL,NULL,NULL,NULL,'2020-08-20 14:04:18','2020-08-20 14:04:18',80,80,NULL),(127,3,'fintan.moore@hennepin.us',NULL,'Fintan','Moore',NULL,0,NULL,NULL,NULL,NULL,'2020-08-20 14:04:53','2020-08-20 14:04:53',80,80,NULL),(128,3,'jennifer.carlson@hennepin.us','$2y$10$grJFT/X0tD2/CHVuVSDFD.kIOa66gZrf3.6N58aT7GN8HUCGyAUBi','Jennifer','Carlson',NULL,1,'IP99ql6bJLLW7Pa20av8BQwWRDqdeXfohDfqgcLrEUde6f4QFkcGgaLT3M7H','2020-10-19 18:12:24',NULL,NULL,'2020-08-20 14:05:30','2020-10-19 18:12:24',80,128,NULL),(129,3,'lisa.berry@hennepin.us','$2y$10$e3nN02tGSOmVzXH0oKAL6uXVjBPbR5PsKlnUGvYw8RACRFKM4dyWC','Lisa','Berry',NULL,1,'GpPmHPwFQOEeQAx9JGIBBbMk1Bs5QoAmxYfoIv5W4ypFYMC1EyUkI05eCjQY','2020-08-28 17:01:49',NULL,NULL,'2020-08-20 14:05:56','2020-08-28 17:01:49',80,129,NULL),(130,3,'meg.carriveau@hennepin.us','$2y$10$22e2mkp5PN86BgW7WUtcVOJHyw7riyhZHXleETQNebmDYTxwOxBr2','Meg','Carriveau',NULL,1,'0AlLsGYwszRShqh0GC7gGwucbk5MECLgyMORFkZCcy6eXfthHT6Wr9JtlS07','2020-10-19 18:13:16',NULL,NULL,'2020-08-20 14:06:29','2020-10-19 18:13:16',80,130,NULL),(131,3,'sarah.storm@hennepin.us','$2y$10$w/VVXps.ByP26RUq/Xy.GuaFZIqEhyTS1SaNqLGaU/JaqUkLvXlK.','Sarah','Storm',NULL,1,'VLowYYMCy3Jkmlvuz8gTsNobasW96ArE6RoR21pdhrp1YgOoD9JJNHXt4u26','2020-09-11 19:19:05',NULL,NULL,'2020-08-20 14:06:58','2020-09-11 19:19:05',80,131,NULL),(132,3,'SLR2_User_1@mail.com','$2y$10$zflBALFxS0QjiD2Uv0xbXeD2TrGhlMELpfmJVIYBa868xSePcb.ru','SLR','User1',NULL,1,'cV32lpjwlhh2swJ0ztHmlhqnJLHeSPveYV6bbf8Yk1aDZSxOGL13sl2qeKXl','2020-08-25 13:25:43',NULL,NULL,'2020-08-25 13:21:17','2020-08-25 13:25:43',80,132,NULL),(133,3,'SLR2_User_2@mail.com','$2y$10$stZExHvwY85TEz/iiIlO6e0G3gXmSHUEUCm7yYx4OMRwhgOni2Xoq','SLR','User2',NULL,1,'5W5fPaOI5UFzjQpQ9hXzQ9YuCtymhkgmj1whjWeMr6HiVZ3MDswi5NyUfgQs','2020-08-25 13:27:27',NULL,NULL,'2020-08-25 13:26:35','2020-08-25 13:27:27',80,133,NULL),(134,3,'SLR2_User_3@mail.com','$2y$10$swpDMPDmca6vDBKloD5kWO7qPDyeAvW3XQxwOXUTHIJwFBgHcyS3y','SLR','User3',NULL,1,'YIdUwvpQ07Otqs47fO0ie2vcmkLUfQbeEdbuZiZJlT2xtzDQkLAqJxhmKhvb','2020-08-25 13:30:11',NULL,NULL,'2020-08-25 13:29:32','2020-08-25 13:30:11',80,134,NULL),(135,3,'SLR2_User_4@mail.com','$2y$10$7naGJuxr3wshzPaTU8ktQu89QX2tB6DbB/hKiBQuVci1LBJdDx9EC','SLR','User4',NULL,1,'63HHlrcrRpk5gAcrkFB8K6UK7F1tYft7HDFjPL9MN5g8nTM9VRUkuYILtasL','2020-08-25 13:31:36',NULL,NULL,'2020-08-25 13:31:00','2020-08-25 13:31:36',80,135,NULL),(136,3,'SLR2_User_5@mail.com','$2y$10$lwOIFgOD0QhlbnCcYAfSb.5R84DWZiCcuYtIvuYzXzwduSKgW7NLe','SLR','User5',NULL,1,'AFCtRfK4EpEU6wcEEBRXEvP6Cw3WvaiRb10wbaIWs9cfc6xMbAGxeD0tt95u','2020-08-25 13:35:32',NULL,NULL,'2020-08-25 13:32:25','2020-08-25 13:35:32',80,136,NULL),(137,3,'SLR2_User_6@mail.com','$2y$10$b63YcSJkCpW0hLDrHS.LV..ELZe5f5F38gcrD6nN3yFIO1HbAUcAi','SLR','User6',NULL,1,'LBfTsTUuyzPiRj4QUJyzW8vbjIKGpV9HAkbb28UEYQgW8ztqdf6uBVIwObaU','2020-08-25 13:36:00',NULL,NULL,'2020-08-25 13:33:01','2020-08-25 13:36:00',80,137,NULL),(138,3,'SLR2_User_7@mail.com','$2y$10$gAmJxoPOBxZbJW1L99xduus4Doe7SprwDMHz1cm28jInOiRIbzTwy','SLR','User7',NULL,1,'TJmcJJHLUBhh77ArcHE05hC8JjDLnehNdujU3A4aal7LMi9groqroOiQF17A','2020-08-25 13:36:25',NULL,NULL,'2020-08-25 13:34:10','2020-08-25 13:36:25',80,138,NULL),(139,3,'pfredericks@heritagechristianservices.org','$2y$10$N6C.BL.pEM3D8qQ3Gj0XrOk/Al6P1lx23CPAmmwrIc3aycMpRpQE6','Paul','Fredericks',NULL,1,'MvsQoDdBHbmYxnlErb5PcQ5dCDyzLBAhh1ySefh3SXWw0vMuFuCruBD2dtgi','2020-10-19 19:10:58',NULL,NULL,'2020-10-01 19:31:22','2020-10-19 19:10:58',80,139,NULL);


