 --
 
 --
--- Table structure for table `person_custom`
---
-
-DROP TABLE IF EXISTS `person_custom`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `person_custom` (
-  `per_ID` mediumint(9) NOT NULL DEFAULT '0',
-  `c1` mediumint(9) DEFAULT NULL,
-  `c2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `c3` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
-  PRIMARY KEY (`per_ID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `person_custom`
---
-
-LOCK TABLES `person_custom` WRITE;
-/*!40000 ALTER TABLE `person_custom` DISABLE KEYS */;
-SET autocommit=0;
-INSERT INTO `person_custom` VALUES (50,NULL,NULL,'Law School'),(78,2,NULL,NULL),(80,NULL,'Fr. Join Smith',NULL);
-/*!40000 ALTER TABLE `person_custom` ENABLE KEYS */;
-UNLOCK TABLES;
-COMMIT;
-
--- Dumped table `person_custom` with 3 row(s)
---
-
---
--- Table structure for table `person_custom_master`
---
-
-DROP TABLE IF EXISTS `person_custom_master`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `person_custom_master` (
-  `custom_Order` smallint(6) NOT NULL DEFAULT '0',
-  `custom_Field` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
-  `custom_Name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
-  `custom_Special` mediumint(8) unsigned DEFAULT NULL,
-  `custom_FieldSec` tinyint(4) NOT NULL,
-  `type_ID` tinyint(4) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`custom_Field`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `person_custom_master`
---
-
-LOCK TABLES `person_custom_master` WRITE;
-/*!40000 ALTER TABLE `person_custom_master` DISABLE KEYS */;
-SET autocommit=0;
-INSERT INTO `person_custom_master` VALUES (1,'c1','Father of confession',11,2,9),(2,'c2','Father of confession - Other',NULL,2,3),(3,'c3','Highest Degree Received',NULL,1,4);
-/*!40000 ALTER TABLE `person_custom_master` ENABLE KEYS */;
-UNLOCK TABLES;
-COMMIT;
-
--- Dumped table `person_custom_master` with 3 row(s)
---
-
---
--- Table structure for table `person_per`
---
-
-DROP TABLE IF EXISTS `person_per`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `person_per` (
-  `per_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
-  `per_Title` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_FirstName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_MiddleName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_LastName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_Suffix` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_Address1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_Address2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_City` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_State` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_Zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_Country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_HomePhone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_WorkPhone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_CellPhone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_Email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_WorkEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_BirthMonth` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `per_BirthDay` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `per_BirthYear` year(4) DEFAULT NULL,
-  `per_MembershipDate` date DEFAULT NULL,
-  `per_Gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `per_fmr_ID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `per_cls_ID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `per_fam_ID` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `per_Envelope` smallint(5) unsigned DEFAULT NULL,
-  `per_DateLastEdited` datetime DEFAULT NULL,
-  `per_DateEntered` datetime NOT NULL,
-  `per_EnteredBy` smallint(5) NOT NULL DEFAULT '0',
-  `per_EditedBy` smallint(5) unsigned DEFAULT '0',
-  `per_FriendDate` date DEFAULT NULL,
-  `per_Flags` mediumint(9) NOT NULL DEFAULT '0',
-  `per_FacebookID` bigint(20) unsigned DEFAULT NULL,
-  `per_Twitter` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  `per_LinkedIn` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
-  PRIMARY KEY (`per_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `person_per`
---
-
-LOCK TABLES `person_per` WRITE;
-/*!40000 ALTER TABLE `person_per` DISABLE KEYS */;
-SET autocommit=0;
-INSERT INTO `person_per` VALUES (1,NULL,'Church',NULL,'Admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0000',NULL,0,0,0,0,NULL,NULL,'2004-08-25 18:00:00',1,0,NULL,0,NULL,NULL,NULL),(2,'Mr','Mathew','','Campbell','','3259 Daisy Dr',NULL,'Denton','AR',NULL,'USA','(728)-139-0768',NULL,'(003)-025-4087','mathew.campbell@example.com',NULL,6,15,'1970',NULL,1,1,1,1,NULL,NULL,'2009-12-25 07:19:06',1,0,NULL,0,NULL,NULL,NULL),(3,'Mr','Tony','','Campbell','','9889 Lone Wolf Trail','','Worcester','ME','','USA','(221) 294-5282','','(820) 203-5704','tony.wade@example.com','',3,3,'1945',NULL,1,0,2,0,0,'2016-11-19 16:07:39','2006-05-18 08:07:27',1,1,NULL,0,NULL,NULL,NULL),(4,'Mr','Darren','','Campbell','','8142 Locust Rd','','Tucson','WV','','USA','(336) 819-5290','','(800) 502-3720','darren.freeman@example.com','',7,23,'1910',NULL,1,4,5,1,0,'2016-11-19 15:39:19','2016-04-03 09:13:02',1,1,NULL,0,NULL,NULL,NULL),(5,'Mr','Albert','','Campbell','','2560 Edwards Rd','','Garland','MT','','USA','(389) 860-7800','','(591) 749-3007','albert.garcia@example.com','',9,9,'2013',NULL,1,3,1,1,0,'2016-11-19 15:39:30','2003-06-23 04:32:34',1,1,NULL,0,NULL,NULL,NULL),(6,'Mrs','Constance','','Hart','','4878 Valley View Ln',NULL,'Grand Rapids','ND',NULL,'USA','(042)-989-4488',NULL,'(385)-141-5437','constance.hart@example.com',NULL,7,8,'1966',NULL,2,1,1,2,NULL,NULL,'2009-04-13 01:17:12',1,0,NULL,0,NULL,NULL,NULL),(7,'Mr','Marion','','Hart','','9211 Railroad St',NULL,'Rockford','ME',NULL,'USA','(178)-657-2640',NULL,'(167)-162-6079','marion.sutton@example.com',NULL,11,11,'1960',NULL,1,2,1,2,NULL,NULL,'2006-08-18 00:45:56',1,0,NULL,0,NULL,NULL,NULL),(8,'Ms','Herminia','','Hart','','9302 Mcclellan Rd','','Anna','AR','','USA','(628) 153-9939','','(568) 461-7599','herminia.bennett@example.com','',11,1,'2016',NULL,2,3,1,2,0,'2016-11-19 15:42:20','2004-11-25 05:24:25',1,1,NULL,0,NULL,NULL,NULL),(9,'Mrs','Jean','','Hart','','1952 E Sandy Lake Rd','','Grand Prairie','VA','','USA','(079) 999-6246','','(604) 581-1182','jean.williams@example.com','',6,7,'2015',NULL,2,3,1,2,0,'2016-11-19 15:42:14','2009-08-19 12:28:31',1,1,NULL,0,NULL,NULL,NULL),(10,'Mr','Tom','','Hart','','3822 Ranchview Dr','','Yakima','MT','','USA','(527) 157-1824','','(295) 083-9014','tom.gardner@example.com','',6,29,'2014',NULL,1,3,1,2,0,'2016-11-19 15:42:10','2003-02-22 08:03:31',1,1,NULL,0,NULL,NULL,NULL),(11,'Miss','Isabella','','Hart','','1062 W Campbell Ave','','Orange','AZ','','USA','(812) 239-4176','','(370) 444-2204','isabella.murphy@example.com','',11,1,'2013',NULL,2,3,1,2,0,'2016-11-19 15:42:07','2011-12-29 16:42:21',1,1,NULL,0,NULL,NULL,NULL),(12,'Miss','Hannah','','Hart','','8339 W Campbell Ave','','Cincinnati','MA','','USA','(807) 426-5975','','(438) 063-5382','hannah.dean@example.com','',11,10,'2012',NULL,2,3,1,2,0,'2016-11-19 15:42:04','2014-10-07 16:03:06',1,1,NULL,0,NULL,NULL,NULL),(13,'Mr','Ivan','','Hart','','9113 Wheeler Ridge Dr','','Glendale','FL','','USA','(087) 032-9002','','(722) 034-5627','ivan.hayes@example.com','',2,8,'2010',NULL,1,3,1,2,0,'2016-11-19 15:42:01','2013-02-28 09:48:03',1,1,NULL,0,NULL,NULL,NULL),(14,'Mr','Nathan','','Lewis','','2379 Northaven Rd',NULL,'Detroit','WV',NULL,'USA','(609)-441-0871',NULL,'(289)-209-6037','nathan.lewis@example.com',NULL,9,5,'1947',NULL,1,1,1,3,NULL,NULL,'2007-11-19 10:08:41',1,0,NULL,0,NULL,NULL,NULL),(15,'Miss','Vivan','','Lewis','','4179 Nowlin Rd',NULL,'Burkburnett','CO',NULL,'USA','(705)-700-7379',NULL,'(673)-131-2063','vivan.stone@example.com',NULL,1,7,'1953',NULL,2,2,2,3,NULL,NULL,'2009-12-31 07:48:03',1,0,NULL,0,NULL,NULL,NULL),(16,'Miss','Alicia','','Lewis','','9671 Crockett St',NULL,'Antioch','AK',NULL,'USA','(207)-652-5270',NULL,'(101)-986-5384','alicia.wood@example.com',NULL,5,8,'2001',NULL,2,3,2,3,NULL,NULL,'2011-05-22 19:11:16',1,0,NULL,0,NULL,NULL,NULL),(17,'Mr','Edwin','','Lewis','','8088 Westheimer Rd',NULL,'New Haven','OK',NULL,'USA','(282)-503-9925',NULL,'(564)-714-4633','edwin.adams@example.com',NULL,4,3,'1960',NULL,1,4,5,3,NULL,NULL,'2003-09-03 15:13:09',1,0,NULL,0,NULL,NULL,NULL),(18,'Miss','Kathryn','','Ray','','4212 Parker Rd',NULL,'Chesapeake','WI',NULL,'USA','(220)-345-1335',NULL,'(698)-371-0398','kathryn.ray@example.com',NULL,1,1,'1961',NULL,2,1,1,4,NULL,NULL,'2003-10-14 16:05:17',1,0,NULL,0,NULL,NULL,NULL),(19,'Ms','Laurie','','Ray','','8886 Edwards Rd',NULL,'Burkburnett','OK',NULL,'USA','(729)-498-1504',NULL,'(325)-373-6885','laurie.spencer@example.com',NULL,12,4,'1945',NULL,2,2,1,4,NULL,NULL,'2008-05-09 05:12:00',1,0,NULL,0,NULL,NULL,NULL),(20,'Mr','Ruben','','Ray','','4029 Marsh Ln',NULL,'Laredo','PA',NULL,'USA','(025)-226-8939',NULL,'(860)-989-5496','ruben.robertson@example.com',NULL,7,31,'1947',NULL,1,4,2,4,NULL,NULL,'2011-02-18 08:54:47',1,0,NULL,0,NULL,NULL,NULL),(21,'Mr','Anthony','','Ray','','1384 Mockingbird Hill',NULL,'Hartford','TX',NULL,'USA','(338)-134-5037',NULL,'(824)-719-7975','anthony.romero@example.com',NULL,8,11,'2001',NULL,1,3,2,4,NULL,NULL,'2009-08-31 21:41:59',1,0,NULL,0,NULL,NULL,NULL),(22,'Ms','Tiffany','','Ray','','5628 College St',NULL,'Houston','WI',NULL,'USA','(345)-423-2511',NULL,'(290)-521-0022','tiffany.mitchelle@example.com',NULL,9,11,'2003',NULL,2,3,2,4,NULL,NULL,'2007-06-22 01:54:41',1,0,NULL,0,NULL,NULL,NULL),(23,'Miss','Leah','','Ray','','3962 Preston Rd',NULL,'Seattle','IN',NULL,'USA','(062)-298-8987',NULL,'(460)-918-7940','leah.romero@example.com',NULL,2,28,'2008',NULL,2,3,2,4,NULL,NULL,'2009-08-13 03:54:14',1,0,NULL,0,NULL,NULL,NULL),(24,'Mr','Clyde','','Ray','','6667 Elgin St',NULL,'Flint','ID',NULL,'USA','(033)-156-6960',NULL,'(880)-267-2598','clyde.prescott@example.com',NULL,8,11,'2007',NULL,1,3,2,4,NULL,NULL,'2016-03-23 12:51:45',1,0,NULL,0,NULL,NULL,NULL),(25,'Mrs','Peyton','','Ray','','2168 Daisy Dr',NULL,'Ontario','CT',NULL,'USA','(872)-942-4541',NULL,'(575)-806-0327','peyton.caldwell@example.com',NULL,12,18,'2005',NULL,2,3,2,4,NULL,NULL,'2007-08-08 06:34:24',1,0,NULL,0,NULL,NULL,NULL),(26,'Mr','Paul','','Smith','','5572 Robinson Rd',NULL,'Santa Clarita','KY',NULL,'USA','(886)-863-1106',NULL,'(619)-224-1159','paul.robertson@example.com',NULL,11,21,'1983',NULL,1,1,1,5,NULL,NULL,'2007-09-14 23:32:06',1,0,NULL,0,NULL,NULL,NULL),(27,'Mr','Isaac','','Murry','','4358 W Pecan St','','Columbus','IN','','USA','(094) 366-3908','','(776) 335-5061','isaac.medina@example.com','',7,18,'1967',NULL,1,0,0,0,0,'2016-11-19 15:43:47','2004-09-21 04:59:36',1,1,NULL,0,NULL,NULL,NULL),(28,'Mr','Rafael','','Dixon','','6730 Mockingbird Hill',NULL,'Roanoke','IL',NULL,'USA','(449)-349-7865',NULL,'(868)-958-9892','rafael.dixon@example.com',NULL,12,4,'1990',NULL,1,1,2,6,NULL,NULL,'2013-07-25 20:18:03',1,0,NULL,0,NULL,NULL,NULL),(29,'Mr','Flenn','','Dixon','','1240 Preston Rd','','Cary','MS','','USA','(003) 336-4322','','(053) 745-5201','flenn.watts@example.com','',10,28,'1959',NULL,1,0,0,0,0,'2016-11-19 15:40:58','2004-03-04 00:12:40',1,1,NULL,0,NULL,NULL,NULL),(30,'Miss','Kenzi','','Dixon','','8077 Mcclellan Rd','','Lancaster','PA','','USA','(644) 129-3577','','(930) 426-1283','kenzi.fields@example.com','',4,30,'2012',NULL,2,3,2,6,0,'2016-11-19 15:41:11','2014-09-29 01:36:32',1,1,NULL,0,NULL,NULL,NULL),(31,'Miss','Paula','','Dixon','','5240 Brown Terrace','','Orange','TN','','USA','(306) 612-2729','','(669) 399-3249','paula.rice@example.com','',9,10,'1973',NULL,2,0,0,0,0,'2016-11-19 15:40:40','2007-04-14 04:13:25',1,1,NULL,0,NULL,NULL,NULL),(32,'Mr','Chad','','Dixon','','3902 Robinson Rd','','Fort Worth','AZ','','USA','(933) 231-0313','','(525) 406-0888','chad.fuller@example.com','',2,20,'1992',NULL,1,0,0,0,0,'2016-11-19 15:41:02','2010-07-15 12:40:49',1,1,NULL,0,NULL,NULL,NULL),(33,'Ms','Riley','','Dixon','','2739 E Sandy Lake Rd','','Frederick','AZ','','USA','(601) 891-3110','','(283) 918-7088','riley.reed@example.com','',9,23,'1961',NULL,2,0,0,0,0,'2016-11-19 15:40:43','2006-07-25 23:21:13',1,1,NULL,0,NULL,NULL,NULL),(34,'Mr','Alvin','','Stewart','','7045 Wycliff Ave',NULL,'Gainesville','SD',NULL,'USA','(813)-837-2427',NULL,'(919)-556-7534','alvin.stewart@example.com',NULL,12,16,'1974',NULL,1,1,1,7,NULL,NULL,'2011-08-17 04:00:29',1,0,NULL,0,NULL,NULL,NULL),(35,'Mr','Shane','','Stewart','','9986 Blossom Hill Rd','','Hayward','KY','','USA','(988) 219-6753','','(271) 473-8298','tony.wade@example.com','',1,16,'1951',NULL,1,0,0,0,0,'2018-01-01 19:25:55','2007-12-26 21:13:22',1,1,NULL,0,0,'',''),(36,'Miss','Kathryn',NULL,'Robertson',NULL,'7218 E Pecan St',NULL,'Gilbert','NE',NULL,'USA','(109)-946-0677',NULL,'(493)-248-4574','kathryn.robertson@example.com',NULL,1,14,'1977',NULL,2,1,0,0,NULL,NULL,'2015-02-07 16:23:42',1,0,NULL,0,NULL,NULL,NULL),(37,'Mr','Wayne',NULL,'Robertson',NULL,'5100 Bollinger Rd',NULL,'Bridgeport','WV',NULL,'USA','(584)-942-4752',NULL,'(947)-378-9079','wayne.jacobs@example.com',NULL,3,10,'1982',NULL,1,2,0,0,NULL,NULL,'2005-03-04 15:19:32',1,0,NULL,0,NULL,NULL,NULL),(38,'Miss','Mae',NULL,'Robertson',NULL,'5205 Saddle Dr',NULL,'Fort Wayne','PA',NULL,'USA','(572)-934-2319',NULL,'(625)-704-9068','mae.robinson@example.com',NULL,8,19,'1979',NULL,2,3,0,0,NULL,NULL,'2008-10-02 23:33:21',1,0,NULL,0,NULL,NULL,NULL),(39,'Mr','Soham',NULL,'Robertson',NULL,'3619 Daisy Dr',NULL,'San Jose','AL',NULL,'USA','(789)-386-8063',NULL,'(314)-889-8596','soham.vargas@example.com',NULL,10,3,'1961',NULL,1,3,0,0,NULL,NULL,'2003-04-01 17:32:42',1,0,NULL,0,NULL,NULL,NULL),(40,'Mr','Austin',NULL,'Robertson',NULL,'5722 Adams St',NULL,'Rochester','NJ',NULL,'USA','(728)-300-2942',NULL,'(359)-620-0341','austin.chapman@example.com',NULL,7,13,'1977',NULL,1,3,0,0,NULL,NULL,'2015-05-27 00:37:53',1,0,NULL,0,NULL,NULL,NULL),(41,'Mrs','Stella',NULL,'Robertson',NULL,'5862 Brown Terrace',NULL,'Centennial','AK',NULL,'USA','(751)-040-3371',NULL,'(979)-231-1273','stella.steward@example.com',NULL,2,15,'1956',NULL,2,3,0,0,NULL,NULL,'2003-12-11 09:28:32',1,0,NULL,0,NULL,NULL,NULL),(42,'Mr','Clinton',NULL,'Robertson',NULL,'1916 Lone Wolf Trail',NULL,'Glendale','OR',NULL,'USA','(253)-317-5937',NULL,'(954)-007-6834','clinton.black@example.com',NULL,10,20,'1969',NULL,1,3,0,0,NULL,NULL,'2012-03-22 08:26:55',1,0,NULL,0,NULL,NULL,NULL),(43,'Ms','Natalie','','Diaz','','1158 Harrison Ct',NULL,'Hialeah','IA',NULL,'USA','(613)-399-6088',NULL,'(129)-829-3141','natalie.diaz@example.com',NULL,5,26,'1970',NULL,2,1,3,9,NULL,NULL,'2013-04-20 15:01:05',1,0,NULL,0,NULL,NULL,NULL),(44,'Mrs','Rhonda','','Diaz','','7320 Cackson St',NULL,'Murrieta','NH',NULL,'USA','(169)-598-1721',NULL,'(839)-859-9851','rhonda.mcdonalid@example.com',NULL,4,4,'1973',NULL,2,2,3,9,NULL,NULL,'2012-02-09 10:41:53',1,0,NULL,0,NULL,NULL,NULL),(48,'Mr','Kurt','','Diaz','','5324 Adams St',NULL,'Richardson','WI',NULL,'USA','(284)-936-1476',NULL,'(220)-137-4630','kurt.hernandez@example.com',NULL,6,20,'2005',NULL,1,3,3,9,NULL,NULL,'2010-01-07 01:55:34',1,0,NULL,0,NULL,NULL,NULL),(49,'Ms','Lorraine','','Diaz','','4771 Crockett St',NULL,'Las Cruces','MA',NULL,'USA','(344)-896-8256',NULL,'(825)-077-7472','lorraine.craig@example.com',NULL,7,26,'2007',NULL,2,3,3,9,NULL,NULL,'2004-06-21 14:40:43',1,0,NULL,0,NULL,NULL,NULL),(50,'Mrs','Sherri','','Gordon','','1255 Brown Terrace','','Louisville','MI','','USA','(215) 006-0420','','(730) 313-8457','sherri.gordon@example.com','',12,18,'1972',NULL,2,1,2,10,0,'2019-09-11 23:09:35','2004-09-09 18:40:30',1,1,NULL,0,0,'',''),(51,'Ms','Rebecca','','Gordon','','6049 Lone Wolf Trail','','Fayetteville','VA','','USA','(808) 292-7083','','(134) 378-9433','rebecca.walker@example.com','',11,28,'1960',NULL,2,0,0,0,0,'2016-11-19 15:41:44','2006-11-20 15:07:23',1,1,NULL,0,NULL,NULL,NULL),(52,'Mr','Vernon','','Newman','','5427 Stevens Creek Blvd',NULL,'Orlando','MN',NULL,'USA','(792)-676-7007',NULL,'(427)-110-3793','vernon.newman@example.com',NULL,8,24,'1961',NULL,1,1,0,11,NULL,NULL,'2006-10-11 03:51:16',1,0,NULL,0,NULL,NULL,NULL),(53,'Mr','George','','Newman','','9425 Lovers Ln','','Madison','LA','','USA','(321) 940-9019','','(782) 311-7625','george.powell@example.com','',5,5,'1988',NULL,1,0,0,0,0,'2016-11-19 15:43:22','2006-06-21 08:18:13',1,1,NULL,0,NULL,NULL,NULL),(54,'Mr','Connor','','Newman','','7304 Parker Rd',NULL,'Forney','CA',NULL,'USA','(838)-504-2399',NULL,'(354)-932-3933','connor.silva@example.com',NULL,5,12,'1977',NULL,1,3,0,11,NULL,NULL,'2006-05-24 17:02:09',1,0,NULL,0,NULL,NULL,NULL),(55,'Mrs','Marie','','Newman','','3717 Lovers Ln',NULL,'Hialeah','NE',NULL,'USA','(833)-140-7523',NULL,'(740)-971-1815','marie.king@example.com',NULL,10,20,'1950',NULL,2,4,0,11,NULL,NULL,'2015-10-04 01:39:08',1,0,NULL,0,NULL,NULL,NULL),(56,'Mr','Norman','','Newman','','8751 E North St',NULL,'Norwalk','TX',NULL,'USA','(185)-313-3302',NULL,'(936)-644-4251','norman.rice@example.com',NULL,3,9,'1970',NULL,1,4,0,11,NULL,NULL,'2006-07-23 14:13:59',1,0,NULL,0,NULL,NULL,NULL),(57,'Mr','Jon','','Olson','','1272 Shady Ln Dr',NULL,'Toledo','MT',NULL,'USA','(698)-235-3995',NULL,'(242)-098-1494','jon.olson@example.com',NULL,1,20,'1981',NULL,1,1,1,12,NULL,NULL,'2014-08-31 04:21:43',1,0,NULL,0,NULL,NULL,NULL),(58,'Ms','Sandra','','Olson','','6590 Ranchview Dr',NULL,'Mcallen','RI',NULL,'USA','(071)-579-9864',NULL,'(654)-049-3879','sandra.vasquez@example.com',NULL,12,28,'1992',NULL,2,2,1,12,NULL,NULL,'2007-11-22 02:36:13',1,0,NULL,0,NULL,NULL,NULL),(59,'Mr','Franklin','','Beck','','6381 Valwood Pkwy',NULL,'Buffalo','ME',NULL,'USA','(237)-926-6342',NULL,'(742)-524-0575','franklin.beck@example.com',NULL,7,30,'1974',NULL,1,1,0,13,NULL,NULL,'2007-02-01 16:50:26',1,0,NULL,0,NULL,NULL,NULL),(60,'Mr','Joel','','Beck','','2334 Daisy Dr','','Yakima','UT','','USA','(206) 919-0303','','(748) 409-3185','joel.murray@example.com','',6,26,'2011',NULL,1,3,0,13,0,'2016-11-19 15:27:13','2006-11-07 12:19:08',1,1,NULL,0,NULL,NULL,NULL),(61,'Miss','Stella','','Beck','','9568 Mockingbird Hill','','Inglewood','IL','','USA','(830) 356-0875','','(970) 626-0902','stella.soto@example.com','',7,18,'2010',NULL,2,3,0,13,0,'2016-11-19 15:25:34','2009-03-23 09:24:30',1,1,NULL,0,NULL,NULL,NULL),(62,'Ms','Emma','','Beck','','8890 Hunters Creek Dr','','Vallejo','MT','','USA','(623) 770-5283','','(447) 069-6505','emma.rice@example.com','',11,30,'2015',NULL,2,3,0,13,0,'2016-11-19 15:25:41','2013-07-10 17:58:37',1,1,NULL,0,NULL,NULL,NULL),(63,'Miss','Julie','','Beck','','9648 Frances Ct','','Amarillo','OK','','USA','(523) 696-1294','','(107) 329-0388','julie.gregory@example.com','',8,21,'1982',NULL,2,2,0,13,0,'2016-11-19 15:27:02','2004-10-13 20:53:29',1,1,NULL,0,NULL,NULL,NULL),(67,'Miss','Brianna','','Berry','','1931 Edwards Rd','','Riverside','PA','','USA','(174) 272-0341','','(310) 207-4173','brianna.berry@example.com','',10,17,'1977',NULL,2,2,1,14,0,'2016-11-19 15:38:39','2013-10-15 09:25:25',1,1,NULL,0,NULL,NULL,NULL),(68,'Mr','Salvador','','Berry','','1487 W Sherman Dr','','Portland','NJ','','USA','(004) 784-0725','','(696) 118-7224','salvador.robertson@example.com','',11,9,'1944',NULL,1,1,1,14,0,'2016-11-19 15:38:31','2003-09-29 17:56:26',1,1,NULL,0,NULL,NULL,NULL),(69,'Mr','Salvador','','Berry','','7928 Country Club Rd','','Lincoln','FL','','USA','(873) 186-8043','','(063) 874-1910','salvador.steward@example.com','',11,1,'2011',NULL,1,3,1,14,0,'2016-11-19 15:38:00','2010-10-03 22:37:50',1,1,NULL,0,NULL,NULL,NULL),(70,'Ms','Edith',NULL,'Simmons',NULL,'3395 N Stelling Rd',NULL,'Murrieta','KY',NULL,'USA','(228)-690-1613',NULL,'(602)-815-9891','edith.simmons@example.com',NULL,3,25,'1977',NULL,2,1,0,0,NULL,NULL,'2003-04-25 18:30:46',1,0,NULL,0,NULL,NULL,NULL),(71,'Mr','Dave',NULL,'Simmons',NULL,'7581 Central St',NULL,'Roseville','RI',NULL,'USA','(196)-952-9025',NULL,'(850)-773-0796','dave.bradley@example.com',NULL,2,17,'1965',NULL,1,2,0,0,NULL,NULL,'2013-07-20 08:52:02',1,0,NULL,0,NULL,NULL,NULL),(72,'Mr','Jonathan',NULL,'Simmons',NULL,'4096 Elgin St',NULL,'Saint Paul','OR',NULL,'USA','(267)-764-5383',NULL,'(359)-187-3057','jonathan.holland@example.com',NULL,3,10,'1983',NULL,1,3,0,0,NULL,NULL,'2002-10-01 07:06:30',1,0,NULL,0,NULL,NULL,NULL),(73,'Mr','Allen',NULL,'Simmons',NULL,'5097 Sunset St',NULL,'Belen','CO',NULL,'USA','(084)-776-1439',NULL,'(549)-426-1692','allen.howard@example.com',NULL,12,18,'1983',NULL,1,3,0,0,NULL,NULL,'2006-10-24 06:38:46',1,0,NULL,0,NULL,NULL,NULL),(74,'Mr','Micheal',NULL,'Simmons',NULL,'9703 Harrison Ct',NULL,'Alexandria','MD',NULL,'USA','(025)-038-3863',NULL,'(542)-730-3571','micheal.gordon@example.com',NULL,7,27,'1987',NULL,1,3,0,0,NULL,NULL,'2005-01-21 16:03:19',1,0,NULL,0,NULL,NULL,NULL),(75,'Mr','Kelly',NULL,'Simmons',NULL,'7765 Marsh Ln',NULL,'Oxnard','UT',NULL,'USA','(637)-815-9511',NULL,'(747)-456-7524','kelly.foster@example.com',NULL,12,9,'1960',NULL,1,3,0,0,NULL,NULL,'2008-02-08 09:12:55',1,0,NULL,0,NULL,NULL,NULL),(76,'Mr','Leroy','','Larson','','3866 Edwards Rd',NULL,'Inglewood','CO',NULL,'USA','(663)-858-8880',NULL,'(731)-811-2661','leroy.larson@example.com',NULL,3,17,'1993',NULL,1,1,2,16,NULL,NULL,'2016-03-01 14:19:32',1,0,NULL,0,NULL,NULL,NULL),(77,'Ms','Natalie','','Larson','','5739 Hunters Creek Dr',NULL,'Charleston','NM',NULL,'USA','(209)-144-2421',NULL,'(265)-630-7859','natalie.lynch@example.com',NULL,5,23,'1977',NULL,2,2,2,16,NULL,NULL,'2013-07-06 04:09:48',1,0,NULL,0,NULL,NULL,NULL),(78,'Mr','Norman','','Cooper','','1782 Daisy Dr','','Oxnard','GA','','USA','(718) 878-3276','','(912) 550-0265','norman.cooper@example.com','',2,15,'1967',NULL,1,1,1,17,NULL,'2019-09-08 21:43:50','2014-09-26 00:09:54',1,3,NULL,0,0,'',''),(79,'Mr','Bradley','','Cooper','','9496 Cackson St',NULL,'El Monte','ME',NULL,'USA','(020)-152-0784',NULL,'(129)-121-8642','bradley.spencer@example.com',NULL,10,28,'1990',NULL,1,2,5,17,NULL,NULL,'2007-06-20 13:29:12',1,0,NULL,0,NULL,NULL,NULL),(80,'Miss','Judy','','Cooper','','5515 Lakeshore Rd','','Forney','AZ','','USA','(538) 341-4356','','(784) 554-0404','judy.douglas@example.com','',1,3,'2010',NULL,2,3,1,17,0,'2019-09-08 21:44:06','2015-12-26 15:02:22',1,3,NULL,0,0,'',''),(81,'Mrs','Isobel','','Cooper','','9849 Fairview St','','Edgewood','MD','','USA','(375) 417-6951','','(086) 565-1921','isobel.jimenez@example.com','',11,5,'2012',NULL,2,3,1,17,0,'2016-11-19 15:39:54','2008-02-28 11:35:15',1,1,NULL,0,NULL,NULL,NULL),(82,'Mr','Jesse','','Cooper','','4450 Brown Terrace','','Aurora','FL','','USA','(036) 874-8797','','(725) 279-2801','jesse.morales@example.com','',2,20,'2014',NULL,1,3,1,17,0,'2016-11-19 15:39:58','2007-04-24 18:10:43',1,1,NULL,0,NULL,NULL,NULL),(83,'Ms','Terry','','Cooper','','6299 Daisy Dr','','St. Louis','CT','','USA','(948) 039-8020','','(800) 640-6871','terry.kim@example.com','',9,20,'1982',NULL,2,0,0,0,0,'2016-11-19 15:40:22','2011-10-07 17:53:37',1,1,NULL,0,NULL,NULL,NULL),(84,'Mr','Randall','','Riley','','1403 Avondale Ave',NULL,'Scottsdale','ID',NULL,'USA','(055)-343-0760',NULL,'(217)-027-5703','randall.riley@example.com',NULL,9,10,'1982',NULL,1,1,1,18,NULL,NULL,'2002-04-09 05:31:36',1,0,NULL,0,NULL,NULL,NULL),(85,'Mr','Bernard','','Riley','','6129 Mockingbird Ln',NULL,'Portland','SC',NULL,'USA','(753)-827-4801',NULL,'(367)-872-9300','bernard.shaw@example.com',NULL,5,31,'1988',NULL,1,2,1,18,NULL,NULL,'2015-03-05 07:54:37',1,0,NULL,0,NULL,NULL,NULL),(86,'Ms','Charlene','','Riley','','2764 Mcgowen St',NULL,'Van Alstyne','ME',NULL,'USA','(351)-644-7769',NULL,'(272)-375-0289','charlene.holmes@example.com',NULL,2,24,'1994',NULL,2,4,2,18,NULL,NULL,'2003-02-10 12:19:20',1,0,NULL,0,NULL,NULL,NULL),(87,'Mr','Scott','','Riley','','6514 Lovers Ln',NULL,'Greeley','SC',NULL,'USA','(225)-752-3695',NULL,'(811)-926-7831','scott.curtis@example.com',NULL,9,12,'2011',NULL,1,3,2,18,NULL,NULL,'2008-11-13 08:27:32',1,0,NULL,0,NULL,NULL,NULL),(88,'Mr','Cecil','','Riley','','3843 Locust Rd',NULL,'Modesto','MS',NULL,'USA','(195)-545-9986',NULL,'(997)-692-8061','cecil.brooks@example.com',NULL,12,29,'2012',NULL,1,3,2,18,NULL,NULL,'2008-06-30 07:18:09',1,0,NULL,0,NULL,NULL,NULL),(89,'Mr','Charlie','','Riley','','7456 Walnut Hill Ln',NULL,'Berkeley','AR',NULL,'USA','(683)-044-6359',NULL,'(243)-373-2589','charlie.steward@example.com',NULL,11,28,'2013',NULL,1,3,2,18,NULL,NULL,'2005-04-12 20:56:36',1,0,NULL,0,NULL,NULL,NULL),(90,'Mr','Tomothy','','Riley','','1151 First Street',NULL,'Santa Ana','KS',NULL,'USA','(428)-265-4577',NULL,'(314)-894-6418','tomothy.morris@example.com',NULL,5,20,'2015',NULL,1,3,2,18,NULL,NULL,'2007-01-20 19:02:31',1,0,NULL,0,NULL,NULL,NULL),(91,'Mrs','Lydia','','Riley','','5887 Daisy Dr',NULL,'Sacramento','MS',NULL,'USA','(979)-417-1072',NULL,'(082)-882-0459','lydia.beck@example.com',NULL,10,18,'2016',NULL,2,3,2,18,NULL,NULL,'2010-12-30 01:21:15',1,0,NULL,0,NULL,NULL,NULL),(92,'Mr','Bruce','','Kennedy','','9481 Wycliff Ave',NULL,'Long Beach','KY',NULL,'USA','(306)-408-4342',NULL,'(414)-142-2127','bruce.kennedy@example.com',NULL,3,14,'1968',NULL,1,1,1,19,NULL,NULL,'2014-11-23 09:17:25',1,0,NULL,0,NULL,NULL,NULL),(93,'Ms','Katie','','Kennedy','','8164 W Sherman Dr',NULL,'Miramar','MA',NULL,'USA','(130)-036-3270',NULL,'(993)-725-1216','katie.hoffman@example.com',NULL,8,20,'1959',NULL,2,2,1,19,NULL,NULL,'2011-07-16 02:59:16',1,0,NULL,0,NULL,NULL,NULL),(94,'Mr','Rick','','Kennedy','','7581 Country Club Rd','','Vancouver','MN','','USA','(045) 695-1038','','(534) 739-9684','rick.simpson@example.com','',7,25,'1983',NULL,1,0,0,0,0,'2016-11-19 15:42:48','2006-05-25 19:29:47',1,1,NULL,0,NULL,NULL,NULL),(95,'Mrs','Judith','','Kennedy','','2874 Paddock Way','','Anaheim','IA','','USA','(773) 685-8434','','(384) 824-9114','judith.matthews@example.com','',8,1,'1978',NULL,0,0,0,0,0,'2016-11-19 15:42:57','2003-07-08 08:25:48',1,1,NULL,0,NULL,NULL,NULL),(96,'Mr','Curtis','','Kennedy','','8606 Cherry St','','Bernalillo','GA','','USA','(461) 623-8151','','(361) 282-0616','curtis.ross@example.com','',8,5,'1976',NULL,1,0,0,0,0,'2016-11-19 15:43:06','2006-04-08 10:42:12',1,1,NULL,0,NULL,NULL,NULL),(97,'Mr','Erik','','Kennedy','','9277 Pockrus Page Rd','','Detroit','ND','','USA','(867) 583-3910','','(526) 231-1258','erik.mitchell@example.com','',9,25,'1964',NULL,1,0,0,0,0,'2016-11-19 15:43:10','2010-01-28 17:10:25',1,1,NULL,0,NULL,NULL,NULL),(98,'Mrs','Carrie','','Kennedy','','7713 First Street',NULL,'Hayward','FL',NULL,'USA','(060)-528-8391',NULL,'(465)-239-8937','carrie.knight@example.com',NULL,4,19,'1960',NULL,2,5,5,19,NULL,NULL,'2007-02-16 17:31:50',1,0,NULL,0,NULL,NULL,NULL),(99,'Miss','Amanda','','Black','','4307 Avondale Ave',NULL,'Shiloh','CT',NULL,'USA','(828)-463-5829',NULL,'(207)-736-7509','amanda.black@example.com',NULL,5,18,'1966',NULL,2,1,2,20,NULL,NULL,'2014-05-10 06:07:19',1,0,NULL,0,NULL,NULL,NULL),(100,'Miss','Lena','','Black','','4858 Taylor St',NULL,'Manchester','UT',NULL,'USA','(747)-292-0200',NULL,'(006)-199-3045','lena.walker@example.com',NULL,12,24,'1971',NULL,2,2,2,20,NULL,NULL,'2004-09-29 01:37:47',1,0,NULL,0,NULL,NULL,NULL),(102,'Ms','Samantha','','Black','','9227 Plum St',NULL,'Coppell','MA',NULL,'USA','(374)-404-6562',NULL,'(060)-500-5393','samantha.duncan@example.com',NULL,8,10,'2010',NULL,2,3,2,20,NULL,NULL,'2005-03-07 21:32:47',1,0,NULL,0,NULL,NULL,NULL),(103,'Mrs','Serenity','','Black','','1122 W Belt Line Rd',NULL,'Norman','NY',NULL,'USA','(795)-160-6735',NULL,'(993)-000-0313','serenity.banks@example.com',NULL,12,17,'2013',NULL,2,3,2,20,NULL,NULL,'2014-05-16 11:35:23',1,0,NULL,0,NULL,NULL,NULL),(104,NULL,'Mark',NULL,'Smith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'(206) 555-1234','mark.smith@example.com',NULL,3,31,'1980',NULL,1,1,0,21,NULL,NULL,'2017-04-15 17:20:21',-1,0,NULL,0,NULL,NULL,NULL),(105,NULL,'Mary',NULL,'Smith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,3,30,'1985',NULL,1,2,0,21,NULL,NULL,'2017-04-15 17:20:21',-1,0,NULL,1,NULL,NULL,NULL),(106,NULL,'Sam',NULL,'Smith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,0,0,NULL,NULL,1,3,0,21,NULL,NULL,'2017-04-15 17:20:21',-1,0,NULL,0,NULL,NULL,NULL),(107,NULL,'Tony',NULL,'Smith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,0,0,NULL,NULL,1,3,0,21,NULL,NULL,'2017-04-15 17:20:21',-1,0,NULL,0,NULL,NULL,NULL);
-/*!40000 ALTER TABLE `person_per` ENABLE KEYS */;
-UNLOCK TABLES;
-COMMIT;
-
--- Dumped table `person_per` with 100 row(s)
---
-
---
--- Table structure for table `person_permission`
---
-
-DROP TABLE IF EXISTS `person_permission`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `person_permission` (
-  `per_id` int(11) NOT NULL,
-  `permission_id` int(11) NOT NULL,
-  PRIMARY KEY (`per_id`,`permission_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `person_permission`
---
-
-LOCK TABLES `person_permission` WRITE;
-/*!40000 ALTER TABLE `person_permission` DISABLE KEYS */;
-SET autocommit=0;
-/*!40000 ALTER TABLE `person_permission` ENABLE KEYS */;
-UNLOCK TABLES;
-COMMIT;
-
--- Dumped table `person_permission` with 0 row(s)
---
-
---
--- Table structure for table `person_roles`
---
-
-DROP TABLE IF EXISTS `person_roles`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `person_roles` (
-  `per_id` int(11) NOT NULL,
-  `role_id` int(11) NOT NULL,
-  PRIMARY KEY (`per_id`,`role_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `person_roles`
---
-
-LOCK TABLES `person_roles` WRITE;
-/*!40000 ALTER TABLE `person_roles` DISABLE KEYS */;
-SET autocommit=0;
-/*!40000 ALTER TABLE `person_roles` ENABLE KEYS */;
-UNLOCK TABLES;
-COMMIT;
-
--- Dumped table `person_roles` with 0 row(s)
+-- Table structure for table `group_grp`
+--
+
+DROP TABLE IF EXISTS `group_grp`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `group_grp` (
+  `grp_ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
+  `grp_Type` tinyint(4) NOT NULL DEFAULT 0,
+  `grp_RoleListID` mediumint(8) unsigned NOT NULL DEFAULT 0,
+  `grp_DefaultRole` mediumint(9) NOT NULL DEFAULT 0,
+  `grp_Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
+  `grp_Description` text COLLATE utf8_unicode_ci DEFAULT NULL,
+  `grp_hasSpecialProps` tinyint(1) NOT NULL DEFAULT 0,
+  `grp_active` tinyint(1) NOT NULL DEFAULT 1,
+  `grp_include_email_export` tinyint(1) NOT NULL DEFAULT 1,
+  PRIMARY KEY (`grp_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `group_grp`
+--
+
+LOCK TABLES `group_grp` WRITE;
+/*!40000 ALTER TABLE `group_grp` DISABLE KEYS */;
+SET autocommit=0;
+INSERT INTO `group_grp` VALUES (1,4,13,2,'Angels class',NULL,0,1,1),(2,4,14,2,'Class 1-3',NULL,0,1,1),(3,4,15,2,'Class 4-5',NULL,0,1,1),(4,4,16,2,'Class 6-7',NULL,0,1,1),(5,4,17,2,'High School Class',NULL,0,1,1),(6,4,18,2,'Youth Meeting',NULL,0,1,1),(7,0,19,1,'Boys Scouts',NULL,0,1,1),(8,0,20,1,'Girl Scouts',NULL,0,0,0),(9,0,21,1,'Church Board',NULL,0,1,0),(10,1,22,1,'Worship Service','',0,1,1),(11,0,23,1,'Clergy',NULL,0,1,1);
+/*!40000 ALTER TABLE `group_grp` ENABLE KEYS */;
+UNLOCK TABLES;
+COMMIT;
+
+-- Dumped table `group_grp` with 11 row(s)
+--
+
+--
+-- Table structure for table `groupprop_7`
+--
+
+DROP TABLE IF EXISTS `groupprop_7`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `groupprop_7` (
+  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
+  `c1` date DEFAULT NULL,
+  `c2` tinyint(4) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `groupprop_7`
+--
+
+LOCK TABLES `groupprop_7` WRITE;
+/*!40000 ALTER TABLE `groupprop_7` DISABLE KEYS */;
+SET autocommit=0;
+INSERT INTO `groupprop_7` VALUES (39,NULL,NULL),(42,NULL,NULL),(104,NULL,NULL),(134,NULL,NULL),(216,NULL,NULL),(300,NULL,1),(303,NULL,NULL),(313,NULL,2),(318,NULL,2),(327,NULL,1),(331,NULL,2),(365,NULL,NULL),(573,NULL,NULL),(575,NULL,1),(577,NULL,1),(581,NULL,2),(582,NULL,2),(662,NULL,NULL),(663,NULL,NULL),(664,NULL,1),(665,NULL,2),(748,NULL,NULL);
+/*!40000 ALTER TABLE `groupprop_7` ENABLE KEYS */;
+UNLOCK TABLES;
+COMMIT;
+
+-- Dumped table `groupprop_7` with 22 row(s)
 --
 
 --

--

--
-- Table structure for table `canvassdata_can`
--

DROP TABLE IF EXISTS `canvassdata_can`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canvassdata_can` (
  `can_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `can_famID` mediumint(9) NOT NULL DEFAULT '0',
  `can_Canvasser` mediumint(9) NOT NULL DEFAULT '0',
  `can_FYID` mediumint(9) DEFAULT NULL,
  `can_date` date DEFAULT NULL,
  `can_Positive` text COLLATE utf8_unicode_ci,
  `can_Critical` text COLLATE utf8_unicode_ci,
  `can_Insightful` text COLLATE utf8_unicode_ci,
  `can_Financial` text COLLATE utf8_unicode_ci,
  `can_Suggestion` text COLLATE utf8_unicode_ci,
  `can_NotInterested` tinyint(1) NOT NULL DEFAULT '0',
  `can_WhyNotInterested` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`can_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `canvassdata_can`
--

LOCK TABLES `canvassdata_can` WRITE;
/*!40000 ALTER TABLE `canvassdata_can` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `canvassdata_can` VALUES (1,17,0,23,'2019-09-09','asdsd','asdf','saf','sdfsdf','sdfsdf',1,'sdfsdf');
/*!40000 ALTER TABLE `canvassdata_can` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

-- Dumped table `canvassdata_can` with 1 row(s)
--

--

COMMIT;

-- Dumped table `family_custom` with 1 row(s)
--

--
