-- mysqldump-php https://github.com/ifsnop/mysqldump-php
--
-- Host: database	Database: churchcrm
-- ------------------------------------------------------
-- Date: Fri, 10 Apr 2026 12:28:10 -0400

SET autocommit=0;
COMMIT;

-- Dumped table `calendars` with 5 row(s)
--

--
-- Table structure for table `calendar_events`
--

CREATE TABLE `calendar_events` (
  `calendar_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  PRIMARY KEY (`calendar_id`,`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `calendar_events`
--

SET autocommit=0;
INSERT INTO `calendar_events` VALUES (2,1),(2,2),(2,3);
COMMIT;

-- Dumped table `calendar_events` with 3 row(s)
--

--
-- Table structure for table `config_cfg`
--

CREATE TABLE `config_cfg` (
  `cfg_name` varchar(50) NOT NULL DEFAULT '',
  `cfg_value` text DEFAULT NULL,
  PRIMARY KEY (`cfg_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `config_cfg`
--

SET autocommit=0;
INSERT INTO `config_cfg` VALUES ('aFinanceQueries','28,30,31,32'),('bAllowPrereleaseUpgrade',''),('bEnableExternalCalendarAPI',''),('bEnableNonDeductible',''),('bEnableSelfRegistration','1'),('bForceUppercaseZip',''),('bHideFamilyNewsletter',''),('bHideFriendDate',''),('bHideLatLon',''),('bHideWeddingDate',''),('bPHPMailerAutoTLS',''),('bRequire2FA',''),('bSearchIncludeFamilyCustomProperties',''),('bSendUserDeletedEmail',''),('bSMTPAuth','0'),('bUseDonationEnvelopes',''),('bUseScannedChecks',''),('iChurchLatitude','39.1111974'),('iChurchLongitude','-94.5838009'),('IncludeDataInNewPersonNotifications',''),('plugin.external-backup.enabled','0'),('plugin.holidays.categories','official,religious'),('plugin.holidays.countries','USA'),('plugin.holidays.enabled','1'),('sChurchAddress','123 Main St'),('sChurchChkAcctNum','111111111'),('sChurchCity','Kansas City'),('sChurchCountry','United States'),('sChurchEmail','demo@churchcrm.io'),('sChurchName','Main St. Cathedral'),('sChurchPhone','555 123 4234'),('sChurchState','MO'),('sChurchZip','64106'),('sConfirmSigner','Elder Joe Smith'),('sDefaultCity','Kansas City'),('sDefaultCountry','United States'),('sDefaultState','MO'),('sDirectoryDisclaimer1','Every effort was made to insure the accuracy of this directory.  If there are any errors or omissions, please contact the church office.This directory is for the use of the people of'),('sLogLevel','100'),('sPHPMailerSMTPSecure',''),('sPledgeSummary2','as of'),('sReminderSigner','Elder Joe Smith'),('sSMTPHost','mailserver:1025'),('sSMTPPass',''),('sSMTPUser',''),('sTaxSigner','Elder Joe Smith'),('sTimeZone','America/Detroit'),('sTwoFASecretKey','ChangeThisToASecureRandomStringBeforeUse');
COMMIT;

-- Dumped table `config_cfg` with 45 row(s)
--

--
-- Table structure for table `deposit_dep`
--

CREATE TABLE `deposit_dep` (
  `dep_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `dep_Date` date DEFAULT NULL,
  `dep_Comment` text DEFAULT NULL,
  `dep_EnteredBy` mediumint(9) unsigned DEFAULT NULL,
  `dep_Closed` tinyint(1) NOT NULL DEFAULT 0,
  `dep_Type` enum('Bank','CreditCard','BankDraft') NOT NULL DEFAULT 'Bank',
  PRIMARY KEY (`dep_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci PACK_KEYS=0;

--
-- Dumping data for table `deposit_dep`
--

SET autocommit=0;
INSERT INTO `deposit_dep` VALUES (1,'2025-12-13','Updated Test Deposit',NULL,0,'Bank'),(2,'2018-02-18','',NULL,0,'Bank'),(3,'2018-02-25','',NULL,0,'Bank'),(4,'2018-03-04','',NULL,0,'Bank'),(5,'2018-03-11','',NULL,0,'Bank'),(6,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(7,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(8,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(9,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(10,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(11,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(12,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(13,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(14,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(15,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(16,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(17,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(18,'2021-04-25','Selenium Test Deposit',NULL,0,'Bank'),(20,'2025-12-13','Test Deposit',NULL,0,'Bank'),(21,'2025-12-13','Test Deposit',NULL,0,'Bank');
COMMIT;

-- Dumped table `deposit_dep` with 20 row(s)
--

--
-- Table structure for table `donateditem_di`
--

CREATE TABLE `donateditem_di` (
  `di_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `di_item` varchar(32) NOT NULL,
  `di_FR_ID` mediumint(9) unsigned NOT NULL,
  `di_donor_ID` mediumint(9) NOT NULL DEFAULT 0,
  `di_buyer_ID` mediumint(9) NOT NULL DEFAULT 0,
  `di_multibuy` smallint(1) NOT NULL DEFAULT 0,
  `di_title` varchar(128) NOT NULL,
  `di_description` text DEFAULT NULL,
  `di_sellprice` decimal(8,2) DEFAULT NULL,
  `di_estprice` decimal(8,2) DEFAULT NULL,
  `di_minimum` decimal(8,2) DEFAULT NULL,
  `di_materialvalue` decimal(8,2) DEFAULT NULL,
  `di_EnteredBy` smallint(5) unsigned NOT NULL DEFAULT 0,
  `di_EnteredDate` date NOT NULL,
  `di_picture` text DEFAULT NULL,
  PRIMARY KEY (`di_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `donateditem_di`
--

SET autocommit=0;
COMMIT;

-- Dumped table `donateditem_di` with 0 row(s)
--

--
-- Table structure for table `donationfund_fun`
--

CREATE TABLE `donationfund_fun` (
  `fun_ID` tinyint(3) NOT NULL AUTO_INCREMENT,
  `fun_Active` enum('true','false') NOT NULL DEFAULT 'true',
  `fun_Name` varchar(30) DEFAULT NULL,
  `fun_Description` varchar(100) DEFAULT NULL,
  `fun_Order` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`fun_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `donationfund_fun`
--

SET autocommit=0;
INSERT INTO `donationfund_fun` VALUES (1,'true','Pledges','Pledge income for the operating budget',1),(2,'true','New Building Fund','',2),(3,'true','Music Ministry','',3);
COMMIT;

-- Dumped table `donationfund_fun` with 3 row(s)
--

--
-- Table structure for table `eventcountnames_evctnm`
--

CREATE TABLE `eventcountnames_evctnm` (
  `evctnm_countid` int(5) NOT NULL AUTO_INCREMENT,
  `evctnm_eventtypeid` smallint(5) NOT NULL DEFAULT 0,
  `evctnm_countname` varchar(20) NOT NULL DEFAULT '',
  `evctnm_notes` varchar(20) NOT NULL DEFAULT '',
  UNIQUE KEY `evctnm_countid` (`evctnm_countid`),
  UNIQUE KEY `evctnm_eventtypeid` (`evctnm_eventtypeid`,`evctnm_countname`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `eventcountnames_evctnm`
--

SET autocommit=0;
INSERT INTO `eventcountnames_evctnm` VALUES (1,1,'Total',''),(2,1,'Members',''),(3,1,'Visitors',''),(4,2,'Total',''),(5,2,'Members',''),(6,2,'Visitors','');
COMMIT;

-- Dumped table `eventcountnames_evctnm` with 6 row(s)
--

--
-- Table structure for table `eventcounts_evtcnt`
--

CREATE TABLE `eventcounts_evtcnt` (
  `evtcnt_eventid` int(5) NOT NULL DEFAULT 0,
  `evtcnt_countid` int(5) NOT NULL DEFAULT 0,
  `evtcnt_countname` varchar(20) DEFAULT NULL,
  `evtcnt_countcount` int(6) DEFAULT NULL,
  `evtcnt_notes` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`evtcnt_eventid`,`evtcnt_countid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `eventcounts_evtcnt`
--

SET autocommit=0;
INSERT INTO `eventcounts_evtcnt` VALUES (1,4,'Total',25,''),(1,5,'Members',10,''),(1,6,'Visitors',0,''),(2,1,'Total',100,''),(2,2,'Members',0,''),(2,3,'Visitors',0,''),(3,4,'Total',100,''),(3,5,'Members',0,''),(3,6,'Visitors',0,'');
COMMIT;

-- Dumped table `eventcounts_evtcnt` with 9 row(s)
--

--
-- Table structure for table `events_event`
--

CREATE TABLE `events_event` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_type` int(11) NOT NULL DEFAULT 0,
  `event_title` varchar(255) NOT NULL DEFAULT '',
  `event_desc` varchar(255) DEFAULT NULL,
  `event_text` text DEFAULT NULL,
  `event_start` datetime NOT NULL,
  `event_end` datetime NOT NULL,
  `inactive` int(1) NOT NULL DEFAULT 0,
  `location_id` int(11) DEFAULT NULL,
  `secondary_contact_person_id` int(11) DEFAULT NULL,
  `primary_contact_person_id` int(11) DEFAULT NULL,
  `event_url` text DEFAULT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `events_event`
--

SET autocommit=0;
INSERT INTO `events_event` VALUES (1,2,'Sunday School Class Changes','This is when the students move to new classes','','2016-11-20 12:30:00','2016-11-20 13:30:00',0,NULL,NULL,NULL,NULL),(2,1,'Christmas Service','christmas service','','2016-12-24 22:30:00','2016-12-25 01:30:00',0,NULL,NULL,NULL,NULL),(3,2,'Summer Camp','Summer Camp','','2017-06-06 09:30:00','2017-06-11 09:30:00',0,NULL,NULL,NULL,NULL);
COMMIT;

-- Dumped table `events_event` with 3 row(s)
--

--
-- Table structure for table `event_attend`
--

CREATE TABLE `event_attend` (
  `attend_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL DEFAULT 0,
  `person_id` int(11) NOT NULL DEFAULT 0,
  `checkin_date` datetime DEFAULT NULL,
  `checkin_id` int(11) DEFAULT NULL,
  `checkout_date` datetime DEFAULT NULL,
  `checkout_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`attend_id`),
  UNIQUE KEY `event_id` (`event_id`,`person_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `event_attend`
--

SET autocommit=0;
INSERT INTO `event_attend` VALUES (1,3,104,'2017-04-15 17:23:46',26,NULL,NULL);
COMMIT;

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

--
-- Table structure for table `event_audience`
--

CREATE TABLE `event_audience` (
  `event_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`event_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `event_audience`
--

SET autocommit=0;
COMMIT;

-- Dumped table `event_audience` with 0 row(s)
--

--
-- Table structure for table `event_types`
--

CREATE TABLE `event_types` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) NOT NULL DEFAULT '',
  `type_defstarttime` time NOT NULL DEFAULT '00:00:00',
  `type_defrecurtype` enum('none','weekly','monthly','yearly') NOT NULL DEFAULT 'none',
  `type_defrecurDOW` enum('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday') NOT NULL DEFAULT 'Sunday',
  `type_defrecurDOM` char(2) NOT NULL DEFAULT '0',
  `type_defrecurDOY` date NOT NULL DEFAULT '2016-01-01',
  `type_active` int(1) NOT NULL DEFAULT 1,
  `type_grpid` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `event_types`
--

SET autocommit=0;
INSERT INTO `event_types` VALUES (1,'Church Service','10:30:00','weekly','Sunday','','2016-01-01',1,NULL),(2,'Sunday School','09:30:00','weekly','Sunday','','2016-01-01',1,NULL);
COMMIT;

-- Dumped table `event_types` with 2 row(s)
--

--
-- Table structure for table `family_custom`
--

CREATE TABLE `family_custom` (
  `fam_ID` mediumint(9) NOT NULL DEFAULT 0,
  `c1` mediumint(9) DEFAULT NULL,
  `c2` varchar(30) DEFAULT NULL,
  `c3` enum('winter','spring','summer','fall') DEFAULT NULL,
  `c4` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`fam_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `family_custom`
--

SET autocommit=0;
INSERT INTO `family_custom` VALUES (4,NULL,NULL,NULL,NULL),(10,79,'9999000000','spring',NULL),(21,NULL,NULL,NULL,2),(22,NULL,NULL,NULL,NULL),(24,NULL,NULL,NULL,NULL),(25,NULL,NULL,NULL,NULL),(26,NULL,NULL,NULL,NULL),(27,NULL,NULL,NULL,NULL),(28,NULL,NULL,NULL,NULL),(29,NULL,NULL,NULL,NULL),(31,NULL,NULL,NULL,NULL),(32,NULL,NULL,NULL,NULL),(34,NULL,NULL,NULL,NULL),(36,NULL,NULL,NULL,NULL),(38,NULL,NULL,NULL,NULL),(40,NULL,NULL,NULL,NULL),(41,NULL,NULL,NULL,NULL),(43,NULL,NULL,NULL,NULL),(44,NULL,NULL,NULL,NULL);
COMMIT;

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

--
-- Table structure for table `family_custom_master`
--

CREATE TABLE `family_custom_master` (
  `fam_custom_Order` smallint(6) NOT NULL DEFAULT 0,
  `fam_custom_Field` varchar(5) NOT NULL DEFAULT '',
  `fam_custom_Name` varchar(40) NOT NULL DEFAULT '',
  `fam_custom_Special` mediumint(8) unsigned DEFAULT NULL,
  `fam_custom_FieldSec` tinyint(4) NOT NULL DEFAULT 1,
  `type_ID` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `family_custom_master`
--

SET autocommit=0;
INSERT INTO `family_custom_master` VALUES (1,'c1','Sponser',9,1,9),(2,'c2','Emergency Phone',NULL,1,11),(3,'c3','Vacation Season',NULL,1,7),(4,'c4','Family Custom Drop Down List',25,1,12);
COMMIT;

-- Dumped table `family_custom_master` with 4 row(s)
--

--
-- Table structure for table `family_fam`
--

CREATE TABLE `family_fam` (
  `fam_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `fam_Name` varchar(50) DEFAULT NULL,
  `fam_Address1` varchar(255) DEFAULT NULL,
  `fam_Address2` varchar(255) DEFAULT NULL,
  `fam_City` varchar(50) DEFAULT NULL,
  `fam_State` varchar(50) DEFAULT NULL,
  `fam_Zip` varchar(50) DEFAULT NULL,
  `fam_Country` varchar(50) DEFAULT NULL,
  `fam_HomePhone` varchar(30) DEFAULT NULL,
  `fam_Email` varchar(100) DEFAULT NULL,
  `fam_WeddingDate` date DEFAULT NULL,
  `fam_DateEntered` datetime NOT NULL,
  `fam_DateLastEdited` datetime DEFAULT NULL,
  `fam_EnteredBy` smallint(5) NOT NULL DEFAULT 0,
  `fam_EditedBy` smallint(5) unsigned DEFAULT 0,
  `fam_scanCheck` text DEFAULT NULL,
  `fam_scanCredit` text DEFAULT NULL,
  `fam_SendNewsLetter` enum('FALSE','TRUE') NOT NULL DEFAULT 'FALSE',
  `fam_DateDeactivated` date DEFAULT NULL,
  `fam_Latitude` double DEFAULT NULL,
  `fam_Longitude` double DEFAULT NULL,
  `fam_Envelope` mediumint(9) NOT NULL DEFAULT 0,
  PRIMARY KEY (`fam_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `family_fam`
--

SET autocommit=0;
INSERT INTO `family_fam` VALUES (1,'Campbell','3259 Daisy Dr','','Denton','AR','','United States','(728) 139-0768','',NULL,'2009-12-25 07:19:06','2016-11-19 15:50:57',1,1,NULL,NULL,'FALSE',NULL,33.174318,-97.0673599,0),(2,'Hart','4878 Valley View Ln','','Grand Rapids','ND','','United States','(042) 989-4488','',NULL,'2009-04-13 01:17:12','2016-11-19 15:53:10',1,1,NULL,NULL,'FALSE',NULL,47.9132828,-97.0864844,0),(3,'Lewis','2379 Northaven Rd','','Detroit','WV','','United States','(609) 441-0871','','2010-02-10','2007-11-19 10:08:41','2017-04-15 17:21:40',1,1,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(4,'Ray','4212 Parker Rd','','Chesapeake','WI','','US','(220) 345-1335','',NULL,'2003-10-14 16:05:17','2021-04-25 21:36:43',1,1,NULL,NULL,'FALSE','2017-04-15',36.7001267,-76.2568083,0),(5,'Smith','5572 Robinson Rd','','Santa Clarita','KY','','United States','(886) 863-1106','','2016-09-12','2007-09-14 23:32:06','2017-04-15 17:22:04',1,1,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(6,'Dixon','6730 Mockingbird Hill','','Roanoke','IL','','United States','(449) 349-7865','',NULL,'2013-07-25 20:18:03','2016-11-19 15:52:44',1,1,NULL,NULL,'FALSE',NULL,37.316406,-79.8874658,0),(7,'Stewart','7045 Wycliff Ave','','Gainesville','SD','','United States','(813) 837-2427','',NULL,'2011-08-17 04:00:29','2016-11-19 15:56:55',1,1,NULL,NULL,'FALSE',NULL,0,0,0),(9,'Diaz','1158 Harrison Ct','','Hialeah','IA','','United States','(613) 399-6088','',NULL,'2013-04-20 15:01:05','2016-11-19 15:52:17',1,1,NULL,NULL,'FALSE',NULL,33.4447804,-112.0542146,0),(10,'Gordon','1255 Brown Terrace','','Louisville','MI','','United States','(215) 006-0420','','2011-07-13','2004-09-09 18:40:30','2019-09-11 23:04:11',1,1,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(11,'Newman','5427 Stevens Creek Blvd','','Orlando','MN','','United States','(792) 676-7007','',NULL,'2006-10-11 03:51:16','2016-11-19 15:54:22',1,1,NULL,NULL,'FALSE',NULL,46.729553,-94.6858998,0),(12,'Olson','1272 Shady Ln Dr','','Toledo','NE','','United States','(698) 235-3995','',NULL,'2014-08-31 04:21:43','2016-11-19 15:54:30',1,1,NULL,NULL,'FALSE',NULL,41.6932406,-83.5833554,0),(13,'Beck','6381 Valwood Pkwy','','Buffalo','ME','','United States','(237) 926-6342','','2010-07-22','2007-02-01 16:50:26','2016-11-19 15:49:36',1,1,NULL,NULL,'FALSE',NULL,46.8269852,-68.4858767,0),(14,'Berry','1931 Edwards Rd','','Riverside','PA','','United States','(174) 272-0341','',NULL,'2013-10-15 09:25:25','2016-11-19 15:49:57',1,1,NULL,NULL,'FALSE',NULL,40.0537096,-74.94436,0),(16,'Larson','3866 Edwards Rd','','Inglewood','CO','','United States','(663) 858-8880','',NULL,'2016-03-01 14:19:32','2016-11-19 15:53:48',1,1,NULL,NULL,'FALSE',NULL,29.3912942,-98.5103497,0),(17,'Cooper','1782 Daisy Dr','','Oxnard','GA','','United States','(718) 878-3276','',NULL,'2014-09-26 00:09:54','2016-11-19 15:51:35',1,1,NULL,NULL,'FALSE',NULL,34.2769999,-119.1552968,0),(18,'Riley','1403 Avondale Ave','','Scottsdale','ID','','United States','(055) 343-0760','','2010-12-22','2002-04-09 05:31:36','2016-11-19 16:43:48',1,1,NULL,NULL,'FALSE',NULL,33.4351234,-112.3063973,0),(19,'Kennedy','9481 Wycliff Ave','','Long Beach','KY','','United States','(306) 408-4342','',NULL,'2014-11-23 09:17:25','2016-11-19 15:53:40',1,1,NULL,NULL,'FALSE',NULL,37.8393332,-84.2700179,0),(20,'Black','4307 Avondale Ave','','Shiloh','CT','','United States','(828) 463-5829','',NULL,'2014-05-10 06:07:19','2016-11-19 15:50:25',1,1,NULL,NULL,'FALSE',NULL,33.4250486,-112.3982715,0),(21,'Smith','123 Main St.','','Seattle','WA','98121','US','(206) 555-5555','',NULL,'2017-04-15 17:19:26','2021-04-25 09:45:44',-1,1,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(22,'Troy942274','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 10:24:12',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(23,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 10:50:11',NULL,-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(24,'Troy786080','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 10:54:55',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(25,'Troy961022','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 12:35:39',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(26,'Troy516502','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 12:41:04',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(27,'Troy409842','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 12:45:41',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(28,'Troy543267','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 12:47:38',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(29,'Troy408868','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 12:48:31',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(30,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 13:13:24',NULL,-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(31,'Troy490520','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 13:15:57',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(32,'Troy303237','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 16:24:31',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(33,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 16:55:43',NULL,-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(34,'Troy762409','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 16:58:11',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(35,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 17:24:16',NULL,-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(36,'Troy160814','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 17:29:15',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(37,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 17:37:18',NULL,-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(38,'Troy927699','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 17:39:21',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(39,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 20:05:48',NULL,-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(40,'Troy789764','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 20:07:53',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(41,'Troy46414','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 21:41:31',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(42,'Master','123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'2021-04-25 21:52:35','2025-01-01 00:00:00',-1,0,NULL,NULL,'FALSE',NULL,NULL,NULL,0),(43,'Troy549983','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 21:55:18',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0),(44,'Troy228890','4222 Clinton Way','','Los Angelas','CA','','US','','',NULL,'2021-04-25 22:48:59',NULL,3,0,NULL,NULL,'TRUE',NULL,0,0,0);
COMMIT;

-- Dumped table `family_fam` with 42 row(s)
--

--
-- Table structure for table `fundraiser_fr`
--

CREATE TABLE `fundraiser_fr` (
  `fr_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `fr_date` date DEFAULT NULL,
  `fr_title` varchar(128) NOT NULL,
  `fr_description` text DEFAULT NULL,
  `fr_EnteredBy` smallint(5) unsigned NOT NULL DEFAULT 0,
  `fr_EnteredDate` date NOT NULL,
  PRIMARY KEY (`fr_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `fundraiser_fr`
--

SET autocommit=0;
INSERT INTO `fundraiser_fr` VALUES (1,'2016-11-19','2016 Car Wash','Youth Car Wash',1,'2016-11-19');
COMMIT;

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

--
-- Table structure for table `groupprop_1`
--

CREATE TABLE `groupprop_1` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`per_ID`),
  UNIQUE KEY `per_ID` (`per_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `groupprop_1`
--

SET autocommit=0;
COMMIT;

-- Dumped table `groupprop_1` with 0 row(s)
--

--
-- Table structure for table `groupprop_11`
--

CREATE TABLE `groupprop_11` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_11`
--

SET autocommit=0;
INSERT INTO `groupprop_11` VALUES (26,NULL),(33,NULL),(34,NULL),(37,NULL),(100,NULL),(125,NULL),(134,NULL),(293,NULL),(349,NULL),(374,NULL),(649,NULL),(650,NULL);
COMMIT;

-- Dumped table `groupprop_11` with 12 row(s)
--

--
-- Table structure for table `groupprop_13`
--

CREATE TABLE `groupprop_13` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_13`
--

SET autocommit=0;
INSERT INTO `groupprop_13` VALUES (79,NULL),(141,NULL),(240,NULL),(257,NULL),(273,NULL),(295,NULL),(297,NULL),(307,NULL),(322,NULL),(337,NULL),(350,NULL),(370,NULL),(386,NULL),(583,NULL),(654,NULL),(668,NULL),(670,NULL),(671,NULL);
COMMIT;

-- Dumped table `groupprop_13` with 18 row(s)
--

--
-- Table structure for table `groupprop_17`
--

CREATE TABLE `groupprop_17` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` enum('false','true') DEFAULT NULL,
  `c2` tinyint(4) DEFAULT NULL,
  `c3` int(11) DEFAULT NULL,
  `c4` varchar(100) DEFAULT NULL,
  `c6` date DEFAULT NULL,
  `c7` varchar(100) DEFAULT NULL,
  `c8` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_17`
--

SET autocommit=0;
INSERT INTO `groupprop_17` VALUES (2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,4,NULL,NULL,'2014-08-31','Bishop Youssef','Too young'),(5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'true',1,3,'David','2010-10-02','H.G. Bishop David',NULL),(29,NULL,2,NULL,NULL,'2008-05-17','H.G. Bishop Bola','Asked to be excluded'),(34,NULL,1,2,NULL,'2009-04-25','H.G. Bishop Abakeer','Asked to be excluded'),(59,NULL,2,NULL,NULL,NULL,NULL,NULL),(64,'true',1,1,'Kiriakos','2010-10-02','H.G. Bishop David','Add later'),(79,NULL,2,NULL,NULL,'1994-07-01','H.G. Bishop Beshoy',NULL),(88,NULL,1,NULL,'George','1989-04-01','H.G. Bishop Mettaos',NULL),(89,NULL,2,NULL,NULL,'1995-06-15','H.G. Bishop Tadros',NULL),(91,NULL,2,NULL,NULL,NULL,NULL,'Fady to get info'),(97,NULL,2,NULL,NULL,'1995-05-28','H.G. Bishop Samuel',NULL),(141,NULL,1,5,NULL,'2011-06-01','H.G. Bishop Aghathon',NULL),(145,NULL,1,NULL,'Mousa','1995-06-26','H.G. Bishop Pisenti','Asked to be excluded'),(154,NULL,2,NULL,NULL,'1998-07-09','H.G. Bishop Abraam',NULL),(183,NULL,2,1,'Guirgis','2009-04-25','H.G. Bishop Abakeer',NULL),(185,NULL,2,NULL,NULL,NULL,NULL,NULL),(190,NULL,2,NULL,NULL,NULL,NULL,NULL),(194,NULL,2,NULL,NULL,'1995-06-15','H. G. Bishop Domadius',NULL),(208,NULL,2,NULL,NULL,'1996-04-14','H.G. Bishop Philoppos',NULL),(216,'true',1,2,'Abanoub','2010-10-02','H.G. Bishop David',NULL),(235,'true',1,NULL,'Stefanos','2003-05-17','H.G. Bishop Bola',NULL),(240,NULL,3,NULL,NULL,NULL,NULL,NULL),(242,NULL,2,NULL,NULL,'1995-06-24','H.G. Bishop Bola',NULL),(244,NULL,2,NULL,NULL,'1995-06-14','H.H. Pope Shenouda III',NULL),(249,NULL,1,NULL,NULL,NULL,'H.G. Bishop Abakeer',NULL),(257,NULL,2,NULL,NULL,'2004-01-01','H.G. Bishop Bola','Asked to be excluded'),(285,NULL,2,NULL,'George',NULL,NULL,'Asked to be exclude'),(293,'true',1,3,NULL,'2009-04-25','H.G. Bishop Abakeer',NULL),(297,NULL,2,NULL,NULL,NULL,NULL,NULL),(299,NULL,2,NULL,NULL,NULL,NULL,NULL),(300,NULL,3,2,NULL,'2008-05-17','H.G. Bishop Bola',NULL),(301,NULL,4,5,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(303,NULL,4,3,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(307,'true',1,4,'Guirgis','2010-10-02',NULL,'H.G. Bishop David'),(311,NULL,4,NULL,NULL,'2011-05-22','H.G. Bishop Aghathon','Too young'),(317,NULL,3,3,NULL,'2010-10-02','H.G. Bishop David',NULL),(320,NULL,4,NULL,NULL,NULL,NULL,'Too young'),(321,NULL,NULL,NULL,'Michael','2005-05-01','H.G. Bishop Bola',NULL),(323,NULL,2,NULL,'Michael','1995-05-31','H.G. Bishop Antonious Markos',NULL),(331,NULL,3,NULL,NULL,'2010-10-02','H.G. Bishop David',NULL),(338,NULL,2,NULL,'Boktor','2007-11-01','H.G. Bishop Mettaos',NULL),(339,NULL,2,NULL,NULL,'1995-06-28','H.G. Bishop Abakeer',NULL),(342,NULL,4,NULL,NULL,NULL,NULL,'Too young'),(343,NULL,2,NULL,NULL,NULL,NULL,'Add later'),(344,'false',4,4,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(348,NULL,2,NULL,NULL,NULL,'H.G. Bishop Pisenti',NULL),(349,'true',1,NULL,NULL,'2010-10-02','H.G. Bishop David',NULL),(350,NULL,2,NULL,'George','2013-10-19','H.G. Bishop Sarafem',NULL),(351,'true',1,NULL,NULL,'1995-05-31','H.G. Bishop Philoppos',NULL),(352,NULL,3,1,NULL,'2013-10-19','H.G. Bishop Sarafem',NULL),(353,NULL,3,NULL,NULL,'2011-01-01','H.G. Bishop Theodosius',NULL),(354,NULL,1,NULL,NULL,'1995-06-10','H.G. Bishop Mettaos','Asked to be excluded'),(355,NULL,4,8,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(356,NULL,1,NULL,NULL,'2010-06-25','H.G. Bishop Aghathon','St. Mary - Can\'t do Sunday'),(357,NULL,1,NULL,'Ibrahim','1995-05-21',NULL,NULL),(358,NULL,2,NULL,NULL,NULL,NULL,'Asked to be excluded'),(360,NULL,2,NULL,NULL,NULL,'H.G. Bishop Abakeer',NULL),(362,NULL,3,1,NULL,'2008-05-17','H.G. Bishop Bola',NULL),(363,NULL,4,7,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(364,NULL,4,6,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(365,NULL,4,2,NULL,'2013-10-19','H.G. Bishop Sarafem','Too young'),(366,NULL,3,NULL,NULL,'1995-07-04','H.G. Bishop Theodosius',NULL),(367,NULL,2,NULL,NULL,NULL,NULL,'Add in June'),(369,NULL,1,NULL,NULL,'1995-05-29','H.G. Bishop Domadius','Asked to be excluded'),(370,NULL,2,NULL,NULL,'2003-05-17','H.G. Bishop Bola',NULL),(371,NULL,1,NULL,'Andraous',NULL,NULL,'St. Mary - Can\'t do Sunday'),(372,NULL,3,NULL,NULL,'2010-07-27','H.G. Bishop David',NULL),(373,NULL,3,NULL,NULL,NULL,NULL,'Fady to get info'),(374,NULL,3,NULL,NULL,NULL,NULL,NULL),(375,NULL,3,NULL,NULL,NULL,NULL,'Fady to get info'),(376,NULL,2,NULL,NULL,NULL,NULL,NULL),(377,'true',1,1,'Mikhael','1995-06-28','H.G. Bishop Aghathon',NULL),(378,NULL,2,NULL,NULL,NULL,NULL,NULL),(379,NULL,3,2,NULL,'2010-10-02','H.G. Bishop David','Add in April'),(380,NULL,3,5,NULL,'2010-10-02','H.G. Bishop David',NULL),(381,NULL,2,1,NULL,NULL,NULL,'Asked to be excluded'),(382,NULL,3,NULL,NULL,'2010-10-02','H.G. Bishop David',NULL),(383,NULL,2,2,NULL,'2008-05-17','H.G. Bishop Bola',NULL),(385,NULL,3,6,NULL,'2010-10-02','H.G. Bishop David',NULL),(386,NULL,3,6,NULL,'2008-05-17','H.G. Bishop Bola',NULL),(387,NULL,3,7,NULL,'2008-05-17','H.G. Bishop Bola',NULL),(388,NULL,2,NULL,NULL,NULL,NULL,'St. Mary - Can\'t commit'),(389,NULL,2,NULL,NULL,NULL,NULL,'St. Mary - Can\'t commit'),(390,NULL,2,NULL,NULL,NULL,NULL,'Hani to get info'),(391,NULL,2,NULL,NULL,NULL,NULL,NULL),(645,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
COMMIT;

-- Dumped table `groupprop_17` with 88 row(s)
--

--
-- Table structure for table `groupprop_2`
--

CREATE TABLE `groupprop_2` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` date DEFAULT NULL,
  `c2` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_2`
--

SET autocommit=0;
INSERT INTO `groupprop_2` VALUES (4,NULL,2),(151,NULL,NULL),(293,NULL,NULL),(301,NULL,1),(304,NULL,NULL),(309,NULL,NULL),(311,NULL,1),(314,NULL,2),(319,NULL,NULL),(328,NULL,NULL),(344,NULL,1),(363,NULL,NULL),(364,NULL,NULL),(385,NULL,NULL),(448,NULL,NULL),(572,NULL,3),(576,NULL,3),(617,NULL,NULL),(618,NULL,1),(633,NULL,1),(634,NULL,1),(635,NULL,NULL),(636,NULL,NULL),(637,NULL,NULL),(639,NULL,1),(661,NULL,NULL),(727,NULL,NULL),(749,NULL,NULL),(759,NULL,NULL),(760,NULL,NULL),(766,NULL,NULL),(774,NULL,NULL),(777,NULL,NULL),(778,NULL,NULL);
COMMIT;

-- Dumped table `groupprop_2` with 34 row(s)
--

--
-- Table structure for table `groupprop_20`
--

CREATE TABLE `groupprop_20` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_20`
--

SET autocommit=0;
INSERT INTO `groupprop_20` VALUES (5,NULL),(37,NULL),(51,NULL),(94,NULL),(305,NULL),(310,NULL),(312,NULL),(320,NULL),(325,NULL),(342,NULL),(355,NULL),(589,NULL),(602,NULL),(611,NULL),(620,NULL),(621,NULL),(629,NULL),(641,NULL),(649,NULL),(657,NULL),(660,NULL),(761,NULL),(769,NULL),(784,NULL),(789,NULL),(797,NULL),(829,NULL),(855,NULL),(860,NULL);
COMMIT;

-- Dumped table `groupprop_20` with 29 row(s)
--

--
-- Table structure for table `groupprop_23`
--

CREATE TABLE `groupprop_23` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` year(4) DEFAULT NULL,
  PRIMARY KEY (`per_ID`),
  UNIQUE KEY `per_ID` (`per_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `groupprop_23`
--

SET autocommit=0;
COMMIT;

-- Dumped table `groupprop_23` with 0 row(s)
--

--
-- Table structure for table `groupprop_25`
--

CREATE TABLE `groupprop_25` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` enum('false','true') DEFAULT NULL,
  `c2` int(11) DEFAULT NULL,
  `c3` date DEFAULT NULL,
  PRIMARY KEY (`per_ID`),
  UNIQUE KEY `per_ID` (`per_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `groupprop_25`
--

SET autocommit=0;
COMMIT;

-- Dumped table `groupprop_25` with 0 row(s)
--

--
-- Table structure for table `groupprop_45`
--

CREATE TABLE `groupprop_45` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `groupprop_45`
--

SET autocommit=0;
COMMIT;

-- Dumped table `groupprop_45` with 0 row(s)
--

--
-- Table structure for table `groupprop_47`
--

CREATE TABLE `groupprop_47` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `groupprop_47`
--

SET autocommit=0;
INSERT INTO `groupprop_47` VALUES (0);
COMMIT;

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

--
-- Table structure for table `groupprop_49`
--

CREATE TABLE `groupprop_49` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `groupprop_49`
--

SET autocommit=0;
COMMIT;

-- Dumped table `groupprop_49` with 0 row(s)
--

--
-- Table structure for table `groupprop_6`
--

CREATE TABLE `groupprop_6` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_6`
--

SET autocommit=0;
INSERT INTO `groupprop_6` VALUES (131,NULL),(326,NULL),(334,NULL),(398,NULL),(590,NULL),(601,NULL),(603,NULL),(607,NULL),(608,NULL),(609,NULL),(612,NULL),(613,NULL),(622,NULL),(652,NULL),(653,NULL),(674,NULL),(675,NULL),(703,NULL),(729,NULL),(754,NULL),(757,NULL),(770,NULL),(773,NULL),(781,NULL),(785,NULL),(788,NULL),(798,NULL),(852,NULL),(862,NULL);
COMMIT;

-- Dumped table `groupprop_6` with 29 row(s)
--

--
-- Table structure for table `groupprop_7`
--

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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_7`
--

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);
COMMIT;

-- Dumped table `groupprop_7` with 22 row(s)
--

--
-- Table structure for table `groupprop_9`
--

CREATE TABLE `groupprop_9` (
  `per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `c1` tinyint(4) DEFAULT NULL,
  `c2` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupprop_9`
--

SET autocommit=0;
INSERT INTO `groupprop_9` VALUES (47,NULL,NULL),(170,NULL,NULL),(190,NULL,NULL),(285,NULL,NULL),(296,2,NULL),(317,1,NULL),(321,2,NULL),(329,NULL,NULL),(330,2,NULL),(352,2,NULL),(362,1,NULL),(373,1,NULL),(379,1,NULL),(382,NULL,NULL),(578,1,NULL),(579,1,NULL),(580,NULL,NULL),(584,1,NULL),(585,NULL,NULL),(586,2,NULL),(669,NULL,NULL);
COMMIT;

-- Dumped table `groupprop_9` with 21 row(s)
--

--
-- Table structure for table `groupprop_master`
--

CREATE TABLE `groupprop_master` (
  `grp_ID` mediumint(9) unsigned NOT NULL DEFAULT 0,
  `prop_ID` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `prop_Field` varchar(5) NOT NULL DEFAULT '0',
  `prop_Name` varchar(40) DEFAULT NULL,
  `prop_Description` varchar(60) DEFAULT NULL,
  `type_ID` smallint(5) unsigned NOT NULL DEFAULT 0,
  `prop_Special` mediumint(9) unsigned DEFAULT NULL,
  `prop_PersonDisplay` enum('false','true') NOT NULL DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci COMMENT='Group-specific properties order, name, description, type';

--
-- Dumping data for table `groupprop_master`
--

SET autocommit=0;
INSERT INTO `groupprop_master` VALUES (23,1,'c1','sdfsaf','',6,NULL,'false');
COMMIT;

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

--
-- Table structure for table `group_grp`
--

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) NOT NULL DEFAULT '',
  `grp_Description` text 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=25 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `group_grp`
--

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),(12,0,26,1,'New Test Group',NULL,0,1,1),(13,0,27,1,'New Test Group',NULL,0,1,1),(14,0,28,1,'New Test Group',NULL,0,1,1),(15,0,29,1,'New Test Group',NULL,0,1,1),(16,0,30,1,'New Test Group',NULL,0,1,1),(17,0,31,1,'New Test Group',NULL,0,1,1),(18,0,32,1,'New Test Group',NULL,0,1,1),(19,0,33,1,'New Test Group',NULL,0,1,1),(20,0,34,1,'New Test Group',NULL,0,1,1),(21,0,35,1,'New Test Group',NULL,0,1,1),(22,0,36,1,'New Test Group',NULL,0,1,1),(23,0,37,1,'sdfsdfsdf',NULL,1,1,1);
COMMIT;

-- Dumped table `group_grp` with 23 row(s)
--


--
-- Table structure for table `kioskassginment_kasm`
--

CREATE TABLE `kioskassginment_kasm` (
  `kasm_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `kasm_kdevId` mediumint(9) DEFAULT NULL,
  `kasm_AssignmentType` mediumint(9) DEFAULT NULL,
  `kasm_EventId` mediumint(9) DEFAULT 0,
  PRIMARY KEY (`kasm_ID`),
  UNIQUE KEY `kasm_ID` (`kasm_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `kioskassginment_kasm`
--

SET autocommit=0;
COMMIT;

-- Dumped table `kioskassginment_kasm` with 0 row(s)
--

--
-- Table structure for table `kioskdevice_kdev`
--

CREATE TABLE `kioskdevice_kdev` (
  `kdev_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `kdev_GUIDHash` char(64) DEFAULT NULL,
  `kdev_Name` varchar(50) DEFAULT NULL,
  `kdev_deviceType` mediumint(9) NOT NULL DEFAULT 0,
  `kdev_lastHeartbeat` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `kdev_Accepted` tinyint(1) DEFAULT NULL,
  `kdev_PendingCommands` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`kdev_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `kioskdevice_kdev`
--

SET autocommit=0;
COMMIT;

-- Dumped table `kioskdevice_kdev` with 0 row(s)
--

--
-- Table structure for table `list_lst`
--

CREATE TABLE `list_lst` (
  `lst_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `lst_OptionID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `lst_OptionSequence` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `lst_OptionName` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `list_lst`
--

SET autocommit=0;
INSERT INTO `list_lst` VALUES (1,1,1,'Member'),(1,2,2,'Regular Attender'),(1,3,3,'Guest'),(1,5,4,'Non-Attender'),(1,4,5,'Non-Attender (staff)'),(2,1,1,'Head of Household'),(2,2,2,'Spouse'),(2,3,3,'Child'),(2,4,4,'Other Relative'),(2,5,5,'Non Relative'),(3,1,1,'Ministry'),(3,2,2,'Team'),(3,3,3,'Bible Study'),(3,4,4,'Sunday School Class'),(4,1,1,'True / False'),(4,2,2,'Date'),(4,3,3,'Text Field (50 char)'),(4,4,4,'Text Field (100 char)'),(4,5,5,'Text Field (Long)'),(4,6,6,'Year'),(4,7,7,'Season'),(4,8,8,'Number'),(4,9,9,'Person from Group'),(4,10,10,'Money'),(4,11,11,'Phone Number'),(4,12,12,'Custom Drop-Down List'),(5,1,1,'bAll'),(5,2,2,'bAdmin'),(5,3,3,'bAddRecords'),(5,4,4,'bEditRecords'),(5,5,5,'bDeleteRecords'),(5,7,7,'bManageGroups'),(5,8,8,'bFinance'),(5,9,9,'bNotes'),(10,1,1,'Teacher'),(10,2,2,'Student'),(11,1,1,'Member'),(12,1,1,'Teacher'),(12,2,2,'Student'),(13,1,1,'Teacher'),(13,2,2,'Student'),(14,1,1,'Teacher'),(14,2,2,'Student'),(15,1,1,'Teacher'),(15,2,2,'Student'),(16,1,1,'Teacher'),(16,2,2,'Student'),(17,1,1,'Teacher'),(17,2,2,'Student'),(18,1,1,'Teacher'),(18,2,2,'Student'),(19,1,1,'Member'),(20,1,1,'Member'),(21,1,1,'Member'),(3,5,5,'Scouts'),(22,1,1,'Member'),(23,1,1,'Member'),(24,1,1,'Default Option'),(24,2,2,'My Custom Item 1'),(24,3,3,'My Custom Item 2'),(25,1,1,'Default Option'),(26,1,1,'Member'),(27,1,1,'Member'),(28,1,1,'Member'),(29,1,1,'Member'),(30,1,1,'Member'),(31,1,1,'Member'),(32,1,1,'Member'),(33,1,1,'Member'),(34,1,1,'Member'),(35,1,1,'Member'),(36,1,1,'Member'),(37,1,2,'Member'),(37,2,1,'sdfsdf');
COMMIT;

-- Dumped table `list_lst` with 74 row(s)
--

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_typeId` int(11) NOT NULL,
  `location_name` varchar(256) NOT NULL,
  `location_address` varchar(45) NOT NULL,
  `location_city` varchar(45) NOT NULL,
  `location_state` varchar(45) NOT NULL,
  `location_zip` varchar(45) NOT NULL,
  `location_country` varchar(45) NOT NULL,
  `location_phone` varchar(45) DEFAULT NULL,
  `location_email` varchar(45) DEFAULT NULL,
  `location_timzezone` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `locations`
--

SET autocommit=0;
COMMIT;

-- Dumped table `locations` with 0 row(s)
--

--
-- Table structure for table `menu_links`
--

CREATE TABLE `menu_links` (
  `linkId` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `linkName` varchar(50) DEFAULT NULL,
  `linkUri` text NOT NULL,
  `linkOrder` int(11) NOT NULL,
  PRIMARY KEY (`linkId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `menu_links`
--

SET autocommit=0;
INSERT INTO `menu_links` VALUES (1,'CNN','https://www.cnn.com',0),(2,'Google','https://www.google.com',0);
COMMIT;

-- Dumped table `menu_links` with 2 row(s)
--

--
-- Table structure for table `multibuy_mb`
--

CREATE TABLE `multibuy_mb` (
  `mb_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `mb_per_ID` mediumint(9) NOT NULL DEFAULT 0,
  `mb_item_ID` mediumint(9) NOT NULL DEFAULT 0,
  `mb_count` decimal(8,0) DEFAULT NULL,
  PRIMARY KEY (`mb_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `multibuy_mb`
--

SET autocommit=0;
COMMIT;

-- Dumped table `multibuy_mb` with 0 row(s)
--

--
-- Table structure for table `note_nte`
--

CREATE TABLE `note_nte` (
  `nte_ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `nte_per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `nte_fam_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `nte_Private` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `nte_Text` text DEFAULT NULL,
  `nte_DateEntered` datetime NOT NULL,
  `nte_DateLastEdited` datetime DEFAULT NULL,
  `nte_EnteredBy` mediumint(8) NOT NULL DEFAULT 0,
  `nte_EditedBy` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `nte_Type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`nte_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=639 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `note_nte`
--

SET autocommit=0;

COMMIT;

-- Dumped table `note_nte` with 628 row(s)
--

--
-- Table structure for table `paddlenum_pn`
--

CREATE TABLE `paddlenum_pn` (
  `pn_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `pn_fr_ID` mediumint(9) unsigned DEFAULT NULL,
  `pn_Num` mediumint(9) unsigned DEFAULT NULL,
  `pn_per_ID` mediumint(9) NOT NULL DEFAULT 0,
  PRIMARY KEY (`pn_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `paddlenum_pn`
--

SET autocommit=0;
COMMIT;

-- Dumped table `paddlenum_pn` with 0 row(s)
--

--
-- Table structure for table `person2group2role_p2g2r`
--

CREATE TABLE `person2group2role_p2g2r` (
  `p2g2r_per_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `p2g2r_grp_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `p2g2r_rle_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`p2g2r_per_ID`,`p2g2r_grp_ID`),
  KEY `p2g2r_per_ID` (`p2g2r_per_ID`,`p2g2r_grp_ID`,`p2g2r_rle_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `person2group2role_p2g2r`
--

SET autocommit=0;
INSERT INTO `person2group2role_p2g2r` VALUES (2,9,1),(2,11,1),(4,1,1),(5,1,2),(7,6,1),(8,1,2),(9,1,2),(10,2,2),(11,3,2),(12,5,2),(13,2,2),(16,5,2),(21,6,2),(22,4,2),(24,4,2),(25,5,2),(26,7,1),(26,11,1),(30,3,2),(60,7,1),(63,1,1),(63,8,1),(67,2,1),(79,5,1),(79,9,1),(80,2,2),(80,8,1),(82,2,2),(83,9,1),(93,6,1),(95,8,1),(96,5,2),(100,4,1),(222,23,2),(223,23,2),(224,23,2),(225,23,2),(226,23,2),(227,23,2);
COMMIT;

-- Dumped table `person2group2role_p2g2r` with 39 row(s)
--

--
-- Table structure for table `person2volunteeropp_p2vo`
--

CREATE TABLE `person2volunteeropp_p2vo` (
  `p2vo_ID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `p2vo_per_ID` mediumint(9) DEFAULT NULL,
  `p2vo_vol_ID` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`p2vo_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `person2volunteeropp_p2vo`
--

SET autocommit=0;
COMMIT;

-- Dumped table `person2volunteeropp_p2vo` with 0 row(s)
--

--
-- Table structure for table `person_custom`
--

CREATE TABLE `person_custom` (
  `per_ID` mediumint(9) NOT NULL DEFAULT 0,
  `c1` mediumint(9) DEFAULT NULL,
  `c2` varchar(50) DEFAULT NULL,
  `c3` varchar(100) DEFAULT NULL,
  `c4` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`per_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `person_custom`
--

SET autocommit=0;
INSERT INTO `person_custom` VALUES (19,NULL,NULL,NULL,NULL),(50,NULL,NULL,'Law School',NULL),(78,2,NULL,NULL,NULL),(80,NULL,'Fr. Join Smith',NULL,NULL),(88,NULL,NULL,NULL,NULL),(104,NULL,NULL,NULL,2),(105,NULL,NULL,NULL,NULL),(108,NULL,NULL,NULL,NULL),(109,NULL,NULL,NULL,NULL),(110,NULL,NULL,NULL,NULL),(111,NULL,NULL,NULL,NULL),(112,NULL,NULL,NULL,NULL),(113,NULL,NULL,NULL,NULL),(114,NULL,NULL,NULL,NULL),(117,NULL,NULL,NULL,NULL),(118,NULL,NULL,NULL,NULL),(119,NULL,NULL,NULL,NULL),(120,NULL,NULL,NULL,NULL),(121,NULL,NULL,NULL,NULL),(122,NULL,NULL,NULL,NULL),(123,NULL,NULL,NULL,NULL),(124,NULL,NULL,NULL,NULL),(125,NULL,NULL,NULL,NULL),(126,NULL,NULL,NULL,NULL),(127,NULL,NULL,NULL,NULL),(128,NULL,NULL,NULL,NULL),(129,NULL,NULL,NULL,NULL),(130,NULL,NULL,NULL,NULL),(131,NULL,NULL,NULL,NULL),(132,NULL,NULL,NULL,NULL),(133,NULL,NULL,NULL,NULL),(134,NULL,NULL,NULL,NULL),(135,NULL,NULL,NULL,NULL),(136,NULL,NULL,NULL,NULL),(137,NULL,NULL,NULL,NULL),(138,NULL,NULL,NULL,NULL),(139,NULL,NULL,NULL,NULL),(140,NULL,NULL,NULL,NULL),(141,NULL,NULL,NULL,NULL),(142,NULL,NULL,NULL,NULL),(143,NULL,NULL,NULL,NULL),(144,NULL,NULL,NULL,NULL),(145,NULL,NULL,NULL,NULL),(146,NULL,NULL,NULL,NULL),(147,NULL,NULL,NULL,NULL),(148,NULL,NULL,NULL,NULL),(149,NULL,NULL,NULL,NULL),(150,NULL,NULL,NULL,NULL),(151,NULL,NULL,NULL,NULL),(152,NULL,NULL,NULL,NULL),(153,NULL,NULL,NULL,NULL),(156,NULL,NULL,NULL,NULL),(157,NULL,NULL,NULL,NULL),(158,NULL,NULL,NULL,NULL),(159,NULL,NULL,NULL,NULL),(160,NULL,NULL,NULL,NULL),(161,NULL,NULL,NULL,NULL),(162,NULL,NULL,NULL,NULL),(163,NULL,NULL,NULL,NULL),(164,NULL,NULL,NULL,NULL),(165,NULL,NULL,NULL,NULL),(166,NULL,NULL,NULL,NULL),(167,NULL,NULL,NULL,NULL),(168,NULL,NULL,NULL,NULL),(169,NULL,NULL,NULL,NULL),(172,NULL,NULL,NULL,NULL),(173,NULL,NULL,NULL,NULL),(174,NULL,NULL,NULL,NULL),(175,NULL,NULL,NULL,NULL),(176,NULL,NULL,NULL,NULL),(177,NULL,NULL,NULL,NULL),(178,NULL,NULL,NULL,NULL),(181,NULL,NULL,NULL,NULL),(182,NULL,NULL,NULL,NULL),(183,NULL,NULL,NULL,NULL),(184,NULL,NULL,NULL,NULL),(185,NULL,NULL,NULL,NULL),(186,NULL,NULL,NULL,NULL),(187,NULL,NULL,NULL,NULL),(190,NULL,NULL,NULL,NULL),(191,NULL,NULL,NULL,NULL),(192,NULL,NULL,NULL,NULL),(193,NULL,NULL,NULL,NULL),(194,NULL,NULL,NULL,NULL),(195,NULL,NULL,NULL,NULL),(196,NULL,NULL,NULL,NULL),(199,NULL,NULL,NULL,NULL),(200,NULL,NULL,NULL,NULL),(201,NULL,NULL,NULL,NULL),(202,NULL,NULL,NULL,NULL),(203,NULL,NULL,NULL,NULL),(204,NULL,NULL,NULL,NULL),(205,NULL,NULL,NULL,NULL),(206,NULL,NULL,NULL,NULL),(207,NULL,NULL,NULL,NULL),(208,NULL,NULL,NULL,NULL),(209,NULL,NULL,NULL,NULL),(210,NULL,NULL,NULL,NULL),(211,NULL,NULL,NULL,NULL),(212,NULL,NULL,NULL,NULL),(215,NULL,NULL,NULL,NULL),(216,NULL,NULL,NULL,NULL),(217,NULL,NULL,NULL,NULL),(218,NULL,NULL,NULL,NULL),(219,NULL,NULL,NULL,NULL),(220,NULL,NULL,NULL,NULL),(221,NULL,NULL,NULL,NULL),(222,NULL,NULL,NULL,NULL),(223,NULL,NULL,NULL,NULL),(224,NULL,NULL,NULL,NULL),(225,NULL,NULL,NULL,NULL),(226,NULL,NULL,NULL,NULL),(227,NULL,NULL,NULL,NULL),(228,NULL,NULL,NULL,NULL);
COMMIT;

-- Dumped table `person_custom` with 114 row(s)
--

--
-- Table structure for table `person_custom_master`
--

CREATE TABLE `person_custom_master` (
  `custom_Order` smallint(6) NOT NULL DEFAULT 0,
  `custom_Field` varchar(5) NOT NULL DEFAULT '',
  `custom_Name` varchar(40) 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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `person_custom_master`
--

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),(4,'c4','My Custom Drop Down List',24,1,12);
COMMIT;

-- Dumped table `person_custom_master` with 4 row(s)
--

--
-- Table structure for table `person_per`
--

CREATE TABLE `person_per` (
  `per_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `per_Title` varchar(50) DEFAULT NULL,
  `per_FirstName` varchar(50) DEFAULT NULL,
  `per_MiddleName` varchar(50) DEFAULT NULL,
  `per_LastName` varchar(50) DEFAULT NULL,
  `per_Suffix` varchar(50) DEFAULT NULL,
  `per_Address1` varchar(50) DEFAULT NULL,
  `per_Address2` varchar(50) DEFAULT NULL,
  `per_City` varchar(50) DEFAULT NULL,
  `per_State` varchar(50) DEFAULT NULL,
  `per_Zip` varchar(50) DEFAULT NULL,
  `per_Country` varchar(50) DEFAULT NULL,
  `per_HomePhone` varchar(30) DEFAULT NULL,
  `per_WorkPhone` varchar(30) DEFAULT NULL,
  `per_CellPhone` varchar(30) DEFAULT NULL,
  `per_Email` varchar(50) DEFAULT NULL,
  `per_WorkEmail` varchar(50) DEFAULT NULL,
  `per_BirthMonth` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `per_BirthDay` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `per_BirthYear` smallint(4) unsigned 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_Facebook` varchar(50) DEFAULT NULL,
  `per_Twitter` varchar(50) DEFAULT NULL,
  `per_LinkedIn` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`per_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `person_per`
--

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,0,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','','Denton','AR','','USA','(728)-139-0768','','(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','','Grand Rapids','ND','','USA','(042)-989-4488','','(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','','Rockford','ME','','USA','(178)-657-2640','','(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','','Detroit','WV','','USA','(609)-441-0871','','(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','','Burkburnett','CO','','USA','(705)-700-7379','','(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','','Antioch','AK','','USA','(207)-652-5270','','(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','','New Haven','OK','','USA','(282)-503-9925','','(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','','Chesapeake','WI','','USA','(220)-345-1335','','(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','','Burkburnett','OK','','USA','(729) 498-1504','','(325) 373-6885','laurie.spencer@example.com','',4,0,1945,NULL,2,2,1,4,0,'2021-04-25 21:36:05','2008-05-09 05:12:00',1,1,NULL,0,'','',''),(20,'Mr','Ruben','','Ray','','4029 Marsh Ln','','Laredo','PA','','USA','(025)-226-8939','','(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','','Hartford','TX','','USA','(338)-134-5037','','(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','','Houston','WI','','USA','(345)-423-2511','','(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','','Seattle','IN','','USA','(062)-298-8987','','(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','','Flint','ID','','USA','(033)-156-6960','','(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','','Ontario','CT','','USA','(872)-942-4541','','(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','','Santa Clarita','KY','','USA','(886)-863-1106','','(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','','Roanoke','IL','','USA','(449)-349-7865','','(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','','Gainesville','SD','','USA','(813)-837-2427','','(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,NULL,'',''),(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','','Hialeah','IA','','USA','(613)-399-6088','','(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','','Murrieta','NH','','USA','(169)-598-1721','','(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','','Richardson','WI','','USA','(284)-936-1476','','(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','','Las Cruces','MA','','USA','(344)-896-8256','','(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,NULL,'',''),(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','','Orlando','MN','','USA','(792)-676-7007','','(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','','Forney','CA','','USA','(838)-504-2399','','(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','','Hialeah','NE','','USA','(833)-140-7523','','(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','','Norwalk','TX','','USA','(185)-313-3302','','(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','','Toledo','MT','','USA','(698)-235-3995','','(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','','Mcallen','RI','','USA','(071)-579-9864','','(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','','Buffalo','ME','','USA','(237)-926-6342','','(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','','Inglewood','CO','','USA','(663)-858-8880','','(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','','Charleston','NM','','USA','(209)-144-2421','','(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,NULL,'',''),(79,'Mr','Bradley','','Cooper','','9496 Cackson St','','El Monte','ME','','USA','(020)-152-0784','','(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,NULL,'',''),(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','','Scottsdale','ID','','USA','(055)-343-0760','','(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','','Portland','SC','','USA','(753)-827-4801','','(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','','Van Alstyne','ME','','USA','(351)-644-7769','','(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','','Greeley','SC','','USA','(225)-752-3695','','(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','','Modesto','MS','','USA','(195) 545-9986','','(997) 692-8061','cecil.brooks@example.com','',12,29,NULL,NULL,1,3,2,18,0,'2023-11-16 12:39:33','2008-06-30 07:18:09',1,1,NULL,0,'','',''),(89,'Mr','Charlie','','Riley','','7456 Walnut Hill Ln','','Berkeley','AR','','USA','(683)-044-6359','','(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','','Santa Ana','KS','','USA','(428)-265-4577','','(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','','Sacramento','MS','','USA','(979)-417-1072','','(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','','Long Beach','KY','','USA','(306)-408-4342','','(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','','Miramar','MA','','USA','(130)-036-3270','','(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','','Hayward','FL','','USA','(060)-528-8391','','(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','','Shiloh','CT','','USA','(828)-463-5829','','(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','','Manchester','UT','','USA','(747)-292-0200','','(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','','Coppell','MA','','USA','(374)-404-6562','','(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','','Norman','NY','','USA','(795)-160-6735','','(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,'','Mark','','Smith','','123 Main St.','','Seattle','WA','98121','US','(206) 555-5555','','(206) 555-1234','mark.smith@example.com','',3,31,1980,NULL,1,1,0,21,0,'2021-04-25 09:41:33','2017-04-15 17:20:21',-1,1,NULL,0,'','',''),(105,'','Mary','','Smith','','123 Main St.','','Seattle','WA','98121','US','(206) 555-5555','','','','',3,30,1985,NULL,1,2,0,21,0,'2021-03-21 17:46:45','2017-04-15 17:20:21',-1,1,NULL,1,'','',''),(106,NULL,'Sam','','Smith','','123 Main St.','','Seattle','WA','98121','US','(206) 555-5555','','','',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','','Smith','','123 Main St.','','Seattle','WA','98121','US','(206) 555-5555','','','',NULL,0,0,NULL,NULL,1,3,0,21,NULL,NULL,'2017-04-15 17:20:21',-1,0,NULL,0,NULL,NULL,NULL),(108,NULL,'Mike','','Troy942274','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,22,NULL,NULL,'2021-04-25 10:24:12',3,0,NULL,0,NULL,NULL,NULL),(109,NULL,'Carol','','Troy942274','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,22,NULL,NULL,'2021-04-25 10:24:12',3,0,NULL,0,NULL,NULL,NULL),(110,NULL,'Alice','','Troy942274','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,22,NULL,NULL,'2021-04-25 10:24:12',3,0,NULL,0,NULL,NULL,NULL),(111,NULL,'Greg','','Troy942274','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,22,NULL,NULL,'2021-04-25 10:24:12',3,0,NULL,0,NULL,NULL,NULL),(112,NULL,'Marcia','','Troy942274','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,22,NULL,NULL,'2021-04-25 10:24:12',3,0,NULL,0,NULL,NULL,NULL),(113,NULL,'Peter','','Troy942274','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,22,NULL,NULL,'2021-04-25 10:24:12',3,0,NULL,0,NULL,NULL,NULL),(114,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 10:32:31',3,0,'2021-04-25',0,'','',''),(115,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,23,NULL,NULL,'2021-04-25 10:50:12',-1,0,NULL,0,NULL,NULL,NULL),(116,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,23,NULL,NULL,'2021-04-25 10:50:12',-1,0,NULL,1,NULL,NULL,NULL),(117,NULL,'Mike','','Troy786080','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,24,NULL,NULL,'2021-04-25 10:54:55',3,0,NULL,0,NULL,NULL,NULL),(118,NULL,'Carol','','Troy786080','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,24,NULL,NULL,'2021-04-25 10:54:55',3,0,NULL,0,NULL,NULL,NULL),(119,NULL,'Alice','','Troy786080','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,24,NULL,NULL,'2021-04-25 10:54:56',3,0,NULL,0,NULL,NULL,NULL),(120,NULL,'Greg','','Troy786080','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,24,NULL,NULL,'2021-04-25 10:54:56',3,0,NULL,0,NULL,NULL,NULL),(121,NULL,'Marcia','','Troy786080','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,24,NULL,NULL,'2021-04-25 10:54:56',3,0,NULL,0,NULL,NULL,NULL),(122,NULL,'Peter','','Troy786080','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,24,NULL,NULL,'2021-04-25 10:54:56',3,0,NULL,0,NULL,NULL,NULL),(123,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 10:56:50',3,0,'2021-04-25',0,'','',''),(124,NULL,'Mike','','Troy961022','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,25,NULL,NULL,'2021-04-25 12:35:39',3,0,NULL,0,NULL,NULL,NULL),(125,NULL,'Carol','','Troy961022','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,25,NULL,NULL,'2021-04-25 12:35:39',3,0,NULL,0,NULL,NULL,NULL),(126,NULL,'Alice','','Troy961022','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,25,NULL,NULL,'2021-04-25 12:35:39',3,0,NULL,0,NULL,NULL,NULL),(127,NULL,'Greg','','Troy961022','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,25,NULL,NULL,'2021-04-25 12:35:39',3,0,NULL,0,NULL,NULL,NULL),(128,NULL,'Marcia','','Troy961022','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,25,NULL,NULL,'2021-04-25 12:35:39',3,0,NULL,0,NULL,NULL,NULL),(129,NULL,'Peter','','Troy961022','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,25,NULL,NULL,'2021-04-25 12:35:39',3,0,NULL,0,NULL,NULL,NULL),(130,NULL,'Mike','','Troy516502','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,26,NULL,NULL,'2021-04-25 12:41:04',3,0,NULL,0,NULL,NULL,NULL),(131,NULL,'Carol','','Troy516502','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,26,NULL,NULL,'2021-04-25 12:41:04',3,0,NULL,0,NULL,NULL,NULL),(132,NULL,'Alice','','Troy516502','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,26,NULL,NULL,'2021-04-25 12:41:04',3,0,NULL,0,NULL,NULL,NULL),(133,NULL,'Greg','','Troy516502','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,26,NULL,NULL,'2021-04-25 12:41:04',3,0,NULL,0,NULL,NULL,NULL),(134,NULL,'Marcia','','Troy516502','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,26,NULL,NULL,'2021-04-25 12:41:04',3,0,NULL,0,NULL,NULL,NULL),(135,NULL,'Peter','','Troy516502','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,26,NULL,NULL,'2021-04-25 12:41:04',3,0,NULL,0,NULL,NULL,NULL),(136,NULL,'Mike','','Troy409842','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,27,NULL,NULL,'2021-04-25 12:45:41',3,0,NULL,0,NULL,NULL,NULL),(137,NULL,'Carol','','Troy409842','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,27,NULL,NULL,'2021-04-25 12:45:41',3,0,NULL,0,NULL,NULL,NULL),(138,NULL,'Alice','','Troy409842','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,27,NULL,NULL,'2021-04-25 12:45:41',3,0,NULL,0,NULL,NULL,NULL),(139,NULL,'Greg','','Troy409842','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,27,NULL,NULL,'2021-04-25 12:45:41',3,0,NULL,0,NULL,NULL,NULL),(140,NULL,'Marcia','','Troy409842','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,27,NULL,NULL,'2021-04-25 12:45:41',3,0,NULL,0,NULL,NULL,NULL),(141,NULL,'Peter','','Troy409842','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,27,NULL,NULL,'2021-04-25 12:45:41',3,0,NULL,0,NULL,NULL,NULL),(142,NULL,'Mike','','Troy543267','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,28,NULL,NULL,'2021-04-25 12:47:38',3,0,NULL,0,NULL,NULL,NULL),(143,NULL,'Carol','','Troy543267','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,28,NULL,NULL,'2021-04-25 12:47:38',3,0,NULL,0,NULL,NULL,NULL),(144,NULL,'Alice','','Troy543267','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,28,NULL,NULL,'2021-04-25 12:47:38',3,0,NULL,0,NULL,NULL,NULL),(145,NULL,'Greg','','Troy543267','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,28,NULL,NULL,'2021-04-25 12:47:38',3,0,NULL,0,NULL,NULL,NULL),(146,NULL,'Marcia','','Troy543267','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,28,NULL,NULL,'2021-04-25 12:47:38',3,0,NULL,0,NULL,NULL,NULL),(147,NULL,'Peter','','Troy543267','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,28,NULL,NULL,'2021-04-25 12:47:38',3,0,NULL,0,NULL,NULL,NULL),(148,NULL,'Mike','','Troy408868','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,29,NULL,NULL,'2021-04-25 12:48:31',3,0,NULL,0,NULL,NULL,NULL),(149,NULL,'Carol','','Troy408868','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,29,NULL,NULL,'2021-04-25 12:48:31',3,0,NULL,0,NULL,NULL,NULL),(150,NULL,'Alice','','Troy408868','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,29,NULL,NULL,'2021-04-25 12:48:31',3,0,NULL,0,NULL,NULL,NULL),(151,NULL,'Greg','','Troy408868','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,29,NULL,NULL,'2021-04-25 12:48:31',3,0,NULL,0,NULL,NULL,NULL),(152,NULL,'Marcia','','Troy408868','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,29,NULL,NULL,'2021-04-25 12:48:31',3,0,NULL,0,NULL,NULL,NULL),(153,NULL,'Peter','','Troy408868','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,29,NULL,NULL,'2021-04-25 12:48:31',3,0,NULL,0,NULL,NULL,NULL),(154,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,30,NULL,NULL,'2021-04-25 13:13:24',-1,0,NULL,0,NULL,NULL,NULL),(155,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,30,NULL,NULL,'2021-04-25 13:13:24',-1,0,NULL,1,NULL,NULL,NULL),(156,NULL,'Mike','','Troy490520','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,31,NULL,NULL,'2021-04-25 13:15:57',3,0,NULL,0,NULL,NULL,NULL),(157,NULL,'Carol','','Troy490520','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,31,NULL,NULL,'2021-04-25 13:15:57',3,0,NULL,0,NULL,NULL,NULL),(158,NULL,'Alice','','Troy490520','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,31,NULL,NULL,'2021-04-25 13:15:57',3,0,NULL,0,NULL,NULL,NULL),(159,NULL,'Greg','','Troy490520','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,31,NULL,NULL,'2021-04-25 13:15:57',3,0,NULL,0,NULL,NULL,NULL),(160,NULL,'Marcia','','Troy490520','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,31,NULL,NULL,'2021-04-25 13:15:57',3,0,NULL,0,NULL,NULL,NULL),(161,NULL,'Peter','','Troy490520','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,31,NULL,NULL,'2021-04-25 13:15:57',3,0,NULL,0,NULL,NULL,NULL),(162,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 13:17:35',3,0,'2021-04-25',0,'','',''),(163,NULL,'Mike','','Troy303237','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,32,NULL,NULL,'2021-04-25 16:24:32',3,0,NULL,0,NULL,NULL,NULL),(164,NULL,'Carol','','Troy303237','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,32,NULL,NULL,'2021-04-25 16:24:32',3,0,NULL,0,NULL,NULL,NULL),(165,NULL,'Alice','','Troy303237','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,32,NULL,NULL,'2021-04-25 16:24:32',3,0,NULL,0,NULL,NULL,NULL),(166,NULL,'Greg','','Troy303237','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,32,NULL,NULL,'2021-04-25 16:24:32',3,0,NULL,0,NULL,NULL,NULL),(167,NULL,'Marcia','','Troy303237','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,32,NULL,NULL,'2021-04-25 16:24:32',3,0,NULL,0,NULL,NULL,NULL),(168,NULL,'Peter','','Troy303237','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,32,NULL,NULL,'2021-04-25 16:24:32',3,0,NULL,0,NULL,NULL,NULL),(169,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 16:26:33',3,0,'2021-04-25',0,'','',''),(170,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,33,NULL,NULL,'2021-04-25 16:55:43',-1,0,NULL,0,NULL,NULL,NULL),(171,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,33,NULL,NULL,'2021-04-25 16:55:43',-1,0,NULL,1,NULL,NULL,NULL),(172,NULL,'Mike','','Troy762409','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,34,NULL,NULL,'2021-04-25 16:58:11',3,0,NULL,0,NULL,NULL,NULL),(173,NULL,'Carol','','Troy762409','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,34,NULL,NULL,'2021-04-25 16:58:11',3,0,NULL,0,NULL,NULL,NULL),(174,NULL,'Alice','','Troy762409','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,34,NULL,NULL,'2021-04-25 16:58:11',3,0,NULL,0,NULL,NULL,NULL),(175,NULL,'Greg','','Troy762409','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,34,NULL,NULL,'2021-04-25 16:58:11',3,0,NULL,0,NULL,NULL,NULL),(176,NULL,'Marcia','','Troy762409','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,34,NULL,NULL,'2021-04-25 16:58:11',3,0,NULL,0,NULL,NULL,NULL),(177,NULL,'Peter','','Troy762409','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,34,NULL,NULL,'2021-04-25 16:58:11',3,0,NULL,0,NULL,NULL,NULL),(178,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 16:59:38',3,0,'2021-04-25',0,'','',''),(179,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,35,NULL,NULL,'2021-04-25 17:24:16',-1,0,NULL,0,NULL,NULL,NULL),(180,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,35,NULL,NULL,'2021-04-25 17:24:16',-1,0,NULL,1,NULL,NULL,NULL),(181,NULL,'Mike','','Troy160814','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,36,NULL,NULL,'2021-04-25 17:29:15',3,0,NULL,0,NULL,NULL,NULL),(182,NULL,'Carol','','Troy160814','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,36,NULL,NULL,'2021-04-25 17:29:15',3,0,NULL,0,NULL,NULL,NULL),(183,NULL,'Alice','','Troy160814','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,36,NULL,NULL,'2021-04-25 17:29:15',3,0,NULL,0,NULL,NULL,NULL),(184,NULL,'Greg','','Troy160814','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,36,NULL,NULL,'2021-04-25 17:29:15',3,0,NULL,0,NULL,NULL,NULL),(185,NULL,'Marcia','','Troy160814','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,36,NULL,NULL,'2021-04-25 17:29:15',3,0,NULL,0,NULL,NULL,NULL),(186,NULL,'Peter','','Troy160814','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,36,NULL,NULL,'2021-04-25 17:29:15',3,0,NULL,0,NULL,NULL,NULL),(187,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 17:30:35',3,0,'2021-04-25',0,'','',''),(188,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,37,NULL,NULL,'2021-04-25 17:37:19',-1,0,NULL,0,NULL,NULL,NULL),(189,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,37,NULL,NULL,'2021-04-25 17:37:19',-1,0,NULL,1,NULL,NULL,NULL),(190,NULL,'Mike','','Troy927699','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,38,NULL,NULL,'2021-04-25 17:39:21',3,0,NULL,0,NULL,NULL,NULL),(191,NULL,'Carol','','Troy927699','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,38,NULL,NULL,'2021-04-25 17:39:21',3,0,NULL,0,NULL,NULL,NULL),(192,NULL,'Alice','','Troy927699','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,38,NULL,NULL,'2021-04-25 17:39:21',3,0,NULL,0,NULL,NULL,NULL),(193,NULL,'Greg','','Troy927699','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,38,NULL,NULL,'2021-04-25 17:39:21',3,0,NULL,0,NULL,NULL,NULL),(194,NULL,'Marcia','','Troy927699','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,38,NULL,NULL,'2021-04-25 17:39:21',3,0,NULL,0,NULL,NULL,NULL),(195,NULL,'Peter','','Troy927699','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,38,NULL,NULL,'2021-04-25 17:39:21',3,0,NULL,0,NULL,NULL,NULL),(196,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 17:40:34',3,0,'2021-04-25',0,'','',''),(197,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,39,NULL,NULL,'2021-04-25 20:05:48',-1,0,NULL,0,NULL,NULL,NULL),(198,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,39,NULL,NULL,'2021-04-25 20:05:48',-1,0,NULL,1,NULL,NULL,NULL),(199,NULL,'Mike','','Troy789764','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,40,NULL,NULL,'2021-04-25 20:07:53',3,0,NULL,0,NULL,NULL,NULL),(200,NULL,'Carol','','Troy789764','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,40,NULL,NULL,'2021-04-25 20:07:53',3,0,NULL,0,NULL,NULL,NULL),(201,NULL,'Alice','','Troy789764','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,40,NULL,NULL,'2021-04-25 20:07:53',3,0,NULL,0,NULL,NULL,NULL),(202,NULL,'Greg','','Troy789764','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,40,NULL,NULL,'2021-04-25 20:07:53',3,0,NULL,0,NULL,NULL,NULL),(203,NULL,'Marcia','','Troy789764','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,40,NULL,NULL,'2021-04-25 20:07:53',3,0,NULL,0,NULL,NULL,NULL),(204,NULL,'Peter','','Troy789764','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,40,NULL,NULL,'2021-04-25 20:07:53',3,0,NULL,0,NULL,NULL,NULL),(205,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 20:09:02',3,0,'2021-04-25',0,'','',''),(206,NULL,'Mike','','Troy46414','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,41,NULL,NULL,'2021-04-25 21:41:31',3,0,NULL,0,NULL,NULL,NULL),(207,NULL,'Carol','','Troy46414','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,41,NULL,NULL,'2021-04-25 21:41:31',3,0,NULL,0,NULL,NULL,NULL),(208,NULL,'Alice','','Troy46414','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,41,NULL,NULL,'2021-04-25 21:41:31',3,0,NULL,0,NULL,NULL,NULL),(209,NULL,'Greg','','Troy46414','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,41,NULL,NULL,'2021-04-25 21:41:31',3,0,NULL,0,NULL,NULL,NULL),(210,NULL,'Marcia','','Troy46414','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,41,NULL,NULL,'2021-04-25 21:41:31',3,0,NULL,0,NULL,NULL,NULL),(211,NULL,'Peter','','Troy46414','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,41,NULL,NULL,'2021-04-25 21:41:31',3,0,NULL,0,NULL,NULL,NULL),(212,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 21:43:48',3,0,'2021-04-25',0,'','',''),(213,NULL,'Sr.',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'sr@mater.cmo',NULL,8,7,1990,NULL,1,1,0,42,NULL,NULL,'2025-01-01 00:00:00',-1,0,NULL,0,NULL,NULL,NULL),(214,NULL,'lady',NULL,'Master',NULL,'123 Main St.',NULL,'Kansas City','MO','98001','US','',NULL,NULL,'lady@nower.com',NULL,8,7,2000,NULL,1,2,0,42,NULL,NULL,'2025-01-01 00:00:00',-1,0,NULL,1,NULL,NULL,NULL),(215,NULL,'Mike','','Troy549983','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,43,NULL,NULL,'2021-04-25 21:55:18',3,0,NULL,0,NULL,NULL,NULL),(216,NULL,'Carol','','Troy549983','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,43,NULL,NULL,'2021-04-25 21:55:18',3,0,NULL,0,NULL,NULL,NULL),(217,NULL,'Alice','','Troy549983','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,43,NULL,NULL,'2021-04-25 21:55:18',3,0,NULL,0,NULL,NULL,NULL),(218,NULL,'Greg','','Troy549983','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,43,NULL,NULL,'2021-04-25 21:55:18',3,0,NULL,0,NULL,NULL,NULL),(219,NULL,'Marcia','','Troy549983','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,43,NULL,NULL,'2021-04-25 21:55:18',3,0,NULL,0,NULL,NULL,NULL),(220,NULL,'Peter','','Troy549983','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,43,NULL,NULL,'2021-04-25 21:55:18',3,0,NULL,0,NULL,NULL,NULL),(221,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 21:57:16',3,0,'2021-04-25',0,'','',''),(222,NULL,'Mike','','Troy228890','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,44,NULL,NULL,'2021-04-25 22:48:59',3,0,NULL,0,NULL,NULL,NULL),(223,NULL,'Carol','','Troy228890','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,44,NULL,NULL,'2021-04-25 22:48:59',3,0,NULL,0,NULL,NULL,NULL),(224,NULL,'Alice','','Troy228890','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,44,NULL,NULL,'2021-04-25 22:48:59',3,0,NULL,0,NULL,NULL,NULL),(225,NULL,'Greg','','Troy228890','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,44,NULL,NULL,'2021-04-25 22:48:59',3,0,NULL,0,NULL,NULL,NULL),(226,NULL,'Marcia','','Troy228890','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,1,44,NULL,NULL,'2021-04-25 22:48:59',3,0,NULL,0,NULL,NULL,NULL),(227,NULL,'Peter','','Troy228890','','4222 Clinton Way','','Los Angelas','CA','','US','','','','',NULL,0,0,NULL,NULL,0,0,2,44,NULL,NULL,'2021-04-25 22:48:59',3,0,NULL,0,NULL,NULL,NULL),(228,'','Boby','','Hall','','','','Kansas City','MO','','United States','','','','boby@example.com','',12,21,1950,NULL,1,0,1,0,0,NULL,'2021-04-25 22:50:53',3,0,'2021-04-25',0,'','','');
INSERT INTO `person_per` VALUES (900,'Mr','John','','Plainauth','','','','','','','USA','','','','john.plainauth@example.com',NULL,1,1,1980,NULL,1,1,0,0,NULL,NULL,'2024-01-01 00:00:00',1,0,NULL,0,NULL,NULL,NULL);
COMMIT;

-- Dumped table `person_per` with 222 row(s)
--

--
-- Table structure for table `pledge_plg`
--

CREATE TABLE `pledge_plg` (
  `plg_plgID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `plg_FamID` mediumint(9) DEFAULT NULL,
  `plg_FYID` mediumint(9) DEFAULT NULL,
  `plg_date` date DEFAULT NULL,
  `plg_amount` decimal(8,2) DEFAULT NULL,
  `plg_schedule` enum('Weekly','Monthly','Quarterly','Once','Other') DEFAULT NULL,
  `plg_method` enum('CREDITCARD','CHECK','CASH','BANKDRAFT') DEFAULT NULL,
  `plg_comment` text DEFAULT NULL,
  `plg_DateLastEdited` date NOT NULL DEFAULT '2016-01-01',
  `plg_EditedBy` mediumint(9) NOT NULL DEFAULT 0,
  `plg_PledgeOrPayment` enum('Pledge','Payment') NOT NULL DEFAULT 'Pledge',
  `plg_fundID` tinyint(3) unsigned DEFAULT NULL,
  `plg_depID` mediumint(9) unsigned DEFAULT NULL,
  `plg_CheckNo` bigint(16) unsigned DEFAULT NULL,
  `plg_Problem` tinyint(1) DEFAULT NULL,
  `plg_scanString` text DEFAULT NULL,
  `plg_aut_ID` mediumint(9) NOT NULL DEFAULT 0,
  `plg_aut_Cleared` tinyint(1) NOT NULL DEFAULT 0,
  `plg_aut_ResultID` mediumint(9) NOT NULL DEFAULT 0,
  `plg_NonDeductible` decimal(8,2) NOT NULL,
  `plg_GroupKey` varchar(64) NOT NULL,
  PRIMARY KEY (`plg_plgID`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `pledge_plg`
--

SET autocommit=0;
INSERT INTO `pledge_plg` VALUES (1,13,22,'2018-03-04',30.00,'Once','CASH','','2018-03-04',1,'Payment',1,1,NULL,NULL,'',0,0,0,0.00,'cash|0|13|1|2018-03-04'),(2,13,22,'2018-03-04',20.00,'Once','CASH','','2018-03-04',1,'Payment',2,1,NULL,NULL,'',0,0,0,0.00,'cash|0|13|1|2018-03-04'),(3,13,22,'2018-03-04',100.00,'Once','CASH','','2018-03-04',1,'Payment',3,1,NULL,NULL,'',0,0,0,0.00,'cash|0|13|1|2018-03-04'),(4,14,22,'2018-03-04',100.00,'Once','CHECK','','2018-03-04',1,'Payment',1,1,127,NULL,'',0,0,0,0.00,'127|0|14|1|2018-03-04'),(5,20,22,'2018-03-04',500.00,'Once','CHECK','','2018-03-04',1,'Payment',1,2,100,NULL,'',0,0,0,0.00,'100|0|20|1|2018-03-04'),(6,20,22,'2018-03-04',100.00,'Once','CHECK','','2018-03-04',1,'Payment',2,2,100,NULL,'',0,0,0,0.00,'100|0|20|1|2018-03-04'),(7,20,22,'2018-03-04',100.00,'Once','CHECK','','2018-03-04',1,'Payment',3,2,100,NULL,'',0,0,0,0.00,'100|0|20|1|2018-03-04'),(8,20,22,'2018-03-04',25.00,'Once','CHECK','','2018-03-04',1,'Payment',1,3,5532,NULL,'',0,0,0,0.00,'5532|0|20|1|2018-03-04'),(9,20,22,'2018-03-04',25.00,'Once','CHECK','','2018-03-04',1,'Payment',2,3,5532,NULL,'',0,0,0,0.00,'5532|0|20|1|2018-03-04'),(10,20,22,'2018-03-04',25.00,'Once','CHECK','','2018-03-04',1,'Payment',3,3,5532,NULL,'',0,0,0,0.00,'5532|0|20|1|2018-03-04'),(11,1,22,'2018-03-04',300.00,'Once','CHECK','','2018-03-04',1,'Payment',1,3,773,NULL,'',0,0,0,0.00,'773|0|1|1|2018-03-04'),(12,1,22,'2018-03-04',26.00,'Once','CHECK','','2018-03-04',1,'Payment',2,3,773,NULL,'',0,0,0,0.00,'773|0|1|1|2018-03-04'),(13,1,22,'2018-03-04',20.00,'Once','CHECK','','2018-03-04',1,'Payment',3,3,773,NULL,'',0,0,0,0.00,'773|0|1|1|2018-03-04'),(14,9,22,'2018-03-04',50.00,'Once','CASH','','2018-03-04',1,'Payment',1,4,NULL,NULL,'',0,0,0,0.00,'cash|0|9|1|2018-03-04'),(15,6,22,'2018-03-04',100.00,'Once','CASH','','2018-03-04',1,'Payment',1,5,NULL,NULL,'',0,0,0,0.00,'cash|0|6|1|2018-03-04'),(16,6,22,'2018-03-04',20.00,'Once','CASH','','2018-03-04',1,'Payment',3,5,NULL,NULL,'',0,0,0,0.00,'cash|0|6|1|2018-03-04'),(17,10,22,'2018-03-04',90.00,'Once','CASH','','2018-03-04',1,'Payment',1,5,NULL,NULL,'',0,0,0,0.00,'cash|0|10|1|2018-03-04'),(18,10,22,'2018-03-04',140.00,'Once','CASH','','2018-03-04',1,'Payment',2,5,NULL,NULL,'',0,0,0,0.00,'cash|0|10|1|2018-03-04'),(19,10,22,'2018-03-04',95.00,'Once','CASH','','2018-03-04',1,'Payment',3,5,NULL,NULL,'',0,0,0,0.00,'cash|0|10|1|2018-03-04'),(20,9,23,'2019-09-19',11.00,'Quarterly','CASH','1fasdfasd','2019-09-09',1,'Pledge',1,0,NULL,NULL,'',0,0,0,0.00,'cash|0|9|1|2019-09-19'),(21,9,23,'2019-09-19',333.00,'Quarterly','CASH','3333','2019-09-09',1,'Pledge',2,0,NULL,NULL,'',0,0,0,0.00,'cash|0|9|1|2019-09-19'),(22,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|0|0|1|2021-04-25'),(23,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|1|0|1|2021-04-25'),(24,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|2|0|1|2021-04-25'),(25,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|3|0|1|2021-04-25'),(26,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|4|0|1|2021-04-25'),(27,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|5|0|1|2021-04-25'),(28,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|6|0|1|2021-04-25'),(29,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|7|0|1|2021-04-25'),(30,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|8|0|1|2021-04-25'),(31,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|9|0|1|2021-04-25'),(32,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|10|0|1|2021-04-25'),(33,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|11|0|1|2021-04-25'),(34,0,25,'2021-04-25',1000.00,'Once','CHECK','','2021-04-25',1,'Payment',1,5,111,NULL,'',0,0,0,0.00,'111|12|0|1|2021-04-25');
COMMIT;

-- Dumped table `pledge_plg` with 34 row(s)
--

--
-- Table structure for table `propertytype_prt`
--

CREATE TABLE `propertytype_prt` (
  `prt_ID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `prt_Class` varchar(10) NOT NULL DEFAULT '',
  `prt_Name` varchar(50) NOT NULL DEFAULT '',
  `prt_Description` text NOT NULL,
  PRIMARY KEY (`prt_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `propertytype_prt`
--

SET autocommit=0;
INSERT INTO `propertytype_prt` VALUES (1,'p','General','General Person Properties'),(2,'f','General','General Family Properties'),(3,'g','General','General Group Properties');
COMMIT;

-- Dumped table `propertytype_prt` with 3 row(s)
--

--
-- Table structure for table `property_pro`
--

CREATE TABLE `property_pro` (
  `pro_ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `pro_Class` varchar(10) NOT NULL DEFAULT '',
  `pro_prt_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `pro_Name` varchar(200) NOT NULL DEFAULT '0',
  `pro_Description` text NOT NULL,
  `pro_Prompt` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pro_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `property_pro`
--

SET autocommit=0;
INSERT INTO `property_pro` VALUES (1,'p',1,'Disabled','has a disability.','What is the nature of the disability?'),(2,'f',2,'Single Parent','is a single-parent household.',''),(3,'g',3,'Youth','is youth-oriented.',''),(4,'g',3,'Scouts','',''),(5,'f',2,'Test','Who','What do you want'),(6,'p',1,'Test','Who','What do you want'),(7,'f',2,'Test','Who','What do you want'),(8,'p',1,'Test','Who','What do you want'),(9,'f',2,'Test','Who','What do you want'),(10,'p',1,'Test','Who','What do you want'),(11,'f',2,'Test','Who','What do you want'),(12,'p',1,'Test','Who','What do you want'),(13,'f',2,'Test','Who','What do you want'),(14,'p',1,'Test','Who','What do you want'),(15,'f',2,'Test','Who','What do you want'),(16,'p',1,'Test','Who','What do you want'),(17,'f',2,'Test','Who','What do you want'),(18,'p',1,'Test','Who','What do you want'),(19,'f',2,'Test','Who','What do you want'),(20,'p',1,'Test','Who','What do you want'),(21,'f',2,'Test','Who','What do you want'),(22,'p',1,'Test','Who','What do you want'),(23,'f',2,'Test','Who','What do you want'),(24,'p',1,'Test','Who','What do you want'),(25,'f',2,'Test','Who','What do you want'),(26,'p',1,'Test','Who','What do you want'),(27,'f',2,'Test','Who','What do you want'),(28,'p',1,'Test','Who','What do you want'),(29,'f',2,'Test','Who','What do you want'),(30,'p',1,'Test','Who','What do you want');
COMMIT;

-- Dumped table `property_pro` with 30 row(s)
--

--
-- Table structure for table `queryparameteroptions_qpo`
--

CREATE TABLE `queryparameteroptions_qpo` (
  `qpo_ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `qpo_qrp_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `qpo_Display` varchar(50) NOT NULL DEFAULT '',
  `qpo_Value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`qpo_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `queryparameteroptions_qpo`
--

SET autocommit=0;
INSERT INTO `queryparameteroptions_qpo` VALUES (1,4,'Male','1'),(2,4,'Female','2'),(3,6,'Male','1'),(4,6,'Female','2'),(5,15,'Name','CONCAT(COALESCE(`per_FirstName`,\'),COALESCE(`per_MiddleName`,\'),COALESCE(`per_LastName`,\'))'),(6,15,'Zip Code','fam_Zip'),(7,15,'State','fam_State'),(8,15,'City','fam_City'),(9,15,'Home Phone','per_HomePhone'),(10,27,'2012/2013','17'),(11,27,'2013/2014','18'),(12,27,'2014/2015','19'),(13,27,'2015/2016','20'),(14,28,'2012/2013','17'),(15,28,'2013/2014','18'),(16,28,'2014/2015','19'),(17,28,'2015/2016','20'),(18,30,'2012/2013','17'),(19,30,'2013/2014','18'),(20,30,'2014/2015','19'),(21,30,'2015/2016','20'),(22,31,'2012/2013','17'),(23,31,'2013/2014','18'),(24,31,'2014/2015','19'),(25,31,'2015/2016','20'),(26,15,'Email','per_Email'),(27,15,'WorkEmail','per_WorkEmail'),(28,32,'2012/2013','17'),(29,32,'2013/2014','18'),(30,32,'2014/2015','19'),(31,32,'2015/2016','20'),(32,33,'Member','1'),(33,33,'Regular Attender','2'),(34,33,'Guest','3'),(35,33,'Non-Attender','4'),(36,33,'Non-Attender (staff)','5'),(37,28,'2016/2017','21'),(38,28,'2017/2018','22'),(39,28,'2018/2019','23'),(40,28,'2019/2020','24'),(41,28,'2020/2021','25'),(42,28,'2021/2022','26'),(43,28,'2022/2023','27'),(44,30,'2016/2017','21'),(45,30,'2017/2018','22'),(46,30,'2018/2019','23'),(47,30,'2019/2020','24'),(48,30,'2020/2021','25'),(49,30,'2021/2022','26'),(50,30,'2022/2023','27'),(51,31,'2016/2017','21'),(52,31,'2017/2018','22'),(53,31,'2018/2019','23'),(54,31,'2019/2020','24'),(55,31,'2020/2021','25'),(56,31,'2021/2022','26'),(57,31,'2022/2023','27'),(58,32,'2016/2017','21'),(59,32,'2017/2018','22'),(60,32,'2018/2019','23'),(61,32,'2019/2020','24'),(62,32,'2020/2021','25'),(63,32,'2021/2022','26'),(64,32,'2022/2023','27');
COMMIT;

-- Dumped table `queryparameteroptions_qpo` with 64 row(s)
--

--
-- Table structure for table `queryparameters_qrp`
--

CREATE TABLE `queryparameters_qrp` (
  `qrp_ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `qrp_qry_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `qrp_Type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `qrp_OptionSQL` text DEFAULT NULL,
  `qrp_Name` varchar(25) DEFAULT NULL,
  `qrp_Description` text DEFAULT NULL,
  `qrp_Alias` varchar(25) DEFAULT NULL,
  `qrp_Default` varchar(25) DEFAULT NULL,
  `qrp_Required` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `qrp_InputBoxSize` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `qrp_Validation` varchar(5) NOT NULL DEFAULT '',
  `qrp_NumericMax` int(11) DEFAULT NULL,
  `qrp_NumericMin` int(11) DEFAULT NULL,
  `qrp_AlphaMinLength` int(11) DEFAULT NULL,
  `qrp_AlphaMaxLength` int(11) DEFAULT NULL,
  PRIMARY KEY (`qrp_ID`),
  KEY `qrp_qry_ID` (`qrp_qry_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `queryparameters_qrp`
--

SET autocommit=0;
INSERT INTO `queryparameters_qrp` VALUES (1,4,0,NULL,'Minimum Age','The minimum age for which you want records returned.','min','0',0,5,'n',120,0,NULL,NULL),(2,4,0,NULL,'Maximum Age','The maximum age for which you want records returned.','max','120',1,5,'n',120,0,NULL,NULL),(4,6,1,'','Gender','The desired gender to search the database for.','gender','1',1,0,'',0,0,0,0),(5,7,2,'SELECT lst_OptionID as Value, lst_OptionName as Display FROM list_lst WHERE lst_ID=2 ORDER BY lst_OptionSequence','Family Role','Select the desired family role.','role','1',0,0,'',0,0,0,0),(6,7,1,'','Gender','The gender for which you would like records returned.','gender','1',1,0,'',0,0,0,0),(8,9,2,'SELECT pro_ID AS Value, pro_Name as Display \r\nFROM property_pro\r\nWHERE pro_Class= \'p\' \r\nORDER BY pro_Name ','Property','The property for which you would like person records returned.','PropertyID','0',1,0,'',0,0,0,0),(9,10,2,'SELECT distinct don_date as Value, don_date as Display FROM donations_don ORDER BY don_date ASC','Beginning Date','Please select the beginning date to calculate total contributions for each member (i.e. YYYY-MM-DD). NOTE: You can only choose dates that contain donations.','startdate','1',1,0,'0',0,0,0,0),(10,10,2,'SELECT distinct don_date as Value, don_date as Display FROM donations_don\r\nORDER BY don_date DESC','Ending Date','Please enter the last date to calculate total contributions for each member (i.e. YYYY-MM-DD).','enddate','1',1,0,'',0,0,0,0),(14,15,0,'','Search','Enter any part of the following: Name, City, State, Zip, Home Phone, Email, or Work Email.','searchstring','',1,0,'',0,0,0,0),(15,15,1,'','Field','Select field to search for.','searchwhat','1',1,0,'',0,0,0,0),(16,11,2,'SELECT distinct don_date as Value, don_date as Display FROM donations_don ORDER BY don_date ASC','Beginning Date','Please select the beginning date to calculate total contributions for each member (i.e. YYYY-MM-DD). NOTE: You can only choose dates that contain donations.','startdate','1',1,0,'0',0,0,0,0),(17,11,2,'SELECT distinct don_date as Value, don_date as Display FROM donations_don\r\nORDER BY don_date DESC','Ending Date','Please enter the last date to calculate total contributions for each member (i.e. YYYY-MM-DD).','enddate','1',1,0,'',0,0,0,0),(18,18,0,'','Month','The birthday month for which you would like records returned.','birthmonth','1',1,0,'',12,1,1,2),(19,19,2,'SELECT grp_ID AS Value, grp_Name AS Display FROM group_grp ORDER BY grp_Type','Class','The sunday school class for which you would like records returned.','group','1',1,0,'',12,1,1,2),(20,20,2,'SELECT grp_ID AS Value, grp_Name AS Display FROM group_grp ORDER BY grp_Type','Class','The sunday school class for which you would like records returned.','group','1',1,0,'',12,1,1,2),(21,21,2,'SELECT grp_ID AS Value, grp_Name AS Display FROM group_grp ORDER BY grp_Type','Registered students','Group of registered students','group','1',1,0,'',12,1,1,2),(22,22,0,'','Month','The membership anniversary month for which you would like records returned.','membermonth','1',1,0,'',12,1,1,2),(25,25,2,'SELECT vol_ID AS Value, vol_Name AS Display FROM volunteeropportunity_vol ORDER BY vol_Name','Volunteer opportunities','Choose a volunteer opportunity','volopp','1',1,0,'',12,1,1,2),(26,26,0,'','Months','Number of months since becoming a friend','friendmonths','1',1,0,'',24,1,1,2),(27,28,1,'','First Fiscal Year','First fiscal year for comparison','fyid1','9',1,0,'',12,9,0,0),(28,28,1,'','Second Fiscal Year','Second fiscal year for comparison','fyid2','9',1,0,'',12,9,0,0),(30,30,1,'','First Fiscal Year','Pledged this year','fyid1','9',1,0,'',12,9,0,0),(31,30,1,'','Second Fiscal Year','but not this year','fyid2','9',1,0,'',12,9,0,0),(32,32,1,'','Fiscal Year','Fiscal Year.','fyid','9',1,0,'',12,9,0,0),(33,18,1,'','Classification','Member, Regular Attender, etc.','percls','1',1,0,'',12,1,1,2),(100,100,2,'SELECT vol_ID AS Value, vol_Name AS Display FROM volunteeropportunity_vol ORDER BY vol_Name','Volunteer opportunities','First volunteer opportunity choice','volopp1','1',1,0,'',12,1,1,2),(101,100,2,'SELECT vol_ID AS Value, vol_Name AS Display FROM volunteeropportunity_vol ORDER BY vol_Name','Volunteer opportunities','Second volunteer opportunity choice','volopp2','1',1,0,'',12,1,1,2),(200,200,2,'SELECT custom_field as Value, custom_Name as Display FROM person_custom_master','Custom field','Choose customer person field','custom','1',0,0,'',0,0,0,0),(201,200,0,'','Field value','Match custom field to this value','value','1',0,0,'',0,0,0,0);
COMMIT;

-- Dumped table `queryparameters_qrp` with 29 row(s)
--

--
-- Table structure for table `query_qry`
--

CREATE TABLE `query_qry` (
  `qry_ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `qry_SQL` text NOT NULL,
  `qry_Name` varchar(255) NOT NULL DEFAULT '',
  `qry_Description` text NOT NULL,
  `qry_Count` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`qry_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `query_qry`
--

SET autocommit=0;
INSERT INTO `query_qry` VALUES (9,'SELECT \r\nper_ID as AddToCart, \r\nCONCAT(per_FirstName,\' \',per_LastName) AS Name, \r\nCONCAT(r2p_Value,\' \') AS Value\r\nFROM person_per,record2property_r2p\r\nWHERE per_ID = r2p_record_ID\r\nAND r2p_pro_ID = ~PropertyID~\r\nORDER BY per_LastName','Person by Property','Returns person records which are assigned the given property.',1),(18,'SELECT per_ID as AddToCart, per_BirthDay as Day, CONCAT(per_FirstName,\' \',per_LastName) AS Name FROM person_per WHERE per_cls_ID=~percls~ AND per_BirthMonth=~birthmonth~ ORDER BY per_BirthDay','Birthdays','People with birthdays in a particular month',0),(21,'SELECT per_ID as AddToCart, CONCAT(\'<a href=/people/view/\',per_ID,\'>\',per_FirstName,\' \',per_LastName,\'</a>\') AS Name FROM person_per LEFT JOIN person2group2role_p2g2r ON per_id = p2g2r_per_ID WHERE p2g2r_grp_ID=~group~ ORDER BY per_LastName','Registered students','Find Registered students',1),(22,'SELECT per_ID as AddToCart, DAYOFMONTH(per_MembershipDate) as Day, per_MembershipDate AS DATE, CONCAT(per_FirstName,\' \',per_LastName) AS Name FROM person_per WHERE per_cls_ID=1 AND MONTH(per_MembershipDate)=~membermonth~ ORDER BY per_MembershipDate','Membership anniversaries','Members who joined in a particular month',0),(25,'SELECT per_ID as AddToCart, CONCAT(\'<a href=/people/view/\',per_ID,\'>\',per_FirstName,\' \',per_LastName,\'</a>\') AS Name FROM person_per LEFT JOIN person2volunteeropp_p2vo ON per_id = p2vo_per_ID WHERE p2vo_vol_ID = ~volopp~ ORDER BY per_LastName','Volunteers','Find volunteers for a particular opportunity',1),(26,'SELECT per_ID as AddToCart, CONCAT(per_FirstName,\' \',per_LastName) AS Name FROM person_per WHERE DATE_SUB(NOW(),INTERVAL ~friendmonths~ MONTH)<per_FriendDate ORDER BY per_MembershipDate','Recent friends','Friends who signed up in previous months',0),(28,'SELECT fam_Name, a.plg_amount as PlgFY1, b.plg_amount as PlgFY2 from family_fam left join pledge_plg a on a.plg_famID = fam_ID and a.plg_FYID=~fyid1~ and a.plg_PledgeOrPayment=\'Pledge\' left join pledge_plg b on b.plg_famID = fam_ID and b.plg_FYID=~fyid2~ and b.plg_PledgeOrPayment=\'Pledge\' order by fam_Name','Pledge comparison','Compare pledges between two fiscal years',1),(30,'SELECT per_ID as AddToCart, CONCAT(per_FirstName,\' \',per_LastName) AS Name, fam_address1, fam_city, fam_state, fam_zip FROM person_per join family_fam on per_fam_id=fam_id where per_fmr_id<>3 and per_fam_id in (select fam_id from family_fam inner join pledge_plg a on a.plg_famID=fam_ID and a.plg_FYID=~fyid1~ and a.plg_amount>0) and per_fam_id not in (select fam_id from family_fam inner join pledge_plg b on b.plg_famID=fam_ID and b.plg_FYID=~fyid2~ and b.plg_amount>0)','Missing pledges','Find people who pledged one year but not another',1),(31,'select per_ID as AddToCart, per_FirstName, per_LastName, per_email from person_per, autopayment_aut where aut_famID=per_fam_ID and aut_CreditCard!=\"\" and per_email!=\"\" and (per_fmr_ID=1 or per_fmr_ID=2 or per_cls_ID=1)','Credit Card People','People who are configured to pay by credit card.',0),(32,'SELECT fam_Name, fam_Envelope, b.fun_Name as Fund_Name, a.plg_amount as Pledge from family_fam left join pledge_plg a on a.plg_famID = fam_ID and a.plg_FYID=~fyid~ and a.plg_PledgeOrPayment=\'Pledge\' and a.plg_amount>0 join donationfund_fun b on b.fun_ID = a.plg_fundID order by fam_Name, a.plg_fundID','Family Pledge by Fiscal Year','Pledge summary by family name for each fund for the selected fiscal year',1),(100,'SELECT a.per_ID as AddToCart, CONCAT(\'<a href=/people/view/\',a.per_ID,\'>\',a.per_FirstName,\' \',a.per_LastName,\'</a>\') AS Name FROM person_per AS a LEFT JOIN person2volunteeropp_p2vo p2v1 ON (a.per_id = p2v1.p2vo_per_ID AND p2v1.p2vo_vol_ID = ~volopp1~) LEFT JOIN person2volunteeropp_p2vo p2v2 ON (a.per_id = p2v2.p2vo_per_ID AND p2v2.p2vo_vol_ID = ~volopp2~) WHERE p2v1.p2vo_per_ID=p2v2.p2vo_per_ID ORDER BY per_LastName','Volunteers','Find volunteers for who match two specific opportunity codes',1),(200,'SELECT a.per_ID as AddToCart, CONCAT(\'<a href=/people/view/\',a.per_ID,\'>\',a.per_FirstName,\' \',a.per_LastName,\'</a>\') AS Name FROM person_per AS a LEFT JOIN person_custom pc ON a.per_id = pc.per_ID WHERE pc.~custom~=\'~value~\' ORDER BY per_LastName','CustomSearch','Find people with a custom field value',1);
COMMIT;

-- Dumped table `query_qry` with 12 row(s)
--

--
-- Table structure for table `record2property_r2p`
--

CREATE TABLE `record2property_r2p` (
  `r2p_pro_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `r2p_record_ID` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `r2p_Value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `record2property_r2p`
--

SET autocommit=0;
INSERT INTO `record2property_r2p` VALUES (4,7,''),(4,8,''),(1,59,'N/A'),(1,114,'N/A'),(1,123,'N/A'),(1,162,'N/A'),(1,169,'N/A'),(1,178,'N/A'),(1,187,'N/A'),(1,196,'N/A'),(1,205,'N/A'),(1,212,'N/A'),(1,221,'N/A'),(1,228,'N/A');
COMMIT;

-- Dumped table `record2property_r2p` with 14 row(s)
--

--
-- Table structure for table `result_res`
--

CREATE TABLE `result_res` (
  `res_ID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `res_echotype1` text NOT NULL,
  `res_echotype2` text NOT NULL,
  `res_echotype3` text NOT NULL,
  `res_authorization` text NOT NULL,
  `res_order_number` text NOT NULL,
  `res_reference` text NOT NULL,
  `res_status` text NOT NULL,
  `res_avs_result` text NOT NULL,
  `res_security_result` text NOT NULL,
  `res_mac` text NOT NULL,
  `res_decline_code` text NOT NULL,
  `res_tran_date` text NOT NULL,
  `res_merchant_name` text NOT NULL,
  `res_version` text NOT NULL,
  `res_EchoServer` text NOT NULL,
  PRIMARY KEY (`res_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `result_res`
--

SET autocommit=0;
COMMIT;
SET autocommit=0;
COMMIT;

-- Dumped table `tokens` with 17 row(s)
--

--
-- Table structure for table `userconfig_ucfg`
--

CREATE TABLE `userconfig_ucfg` (
  `ucfg_per_id` mediumint(9) unsigned NOT NULL,
  `ucfg_id` int(11) NOT NULL DEFAULT 0,
  `ucfg_name` varchar(50) NOT NULL DEFAULT '',
  `ucfg_value` text DEFAULT NULL,
  `ucfg_type` enum('text','number','date','boolean','textarea') NOT NULL DEFAULT 'text',
  `ucfg_tooltip` text NOT NULL,
  `ucfg_permission` enum('FALSE','TRUE') NOT NULL DEFAULT 'FALSE',
  `ucfg_cat` varchar(20) NOT NULL,
  PRIMARY KEY (`ucfg_per_id`,`ucfg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `userconfig_ucfg`
--

SET autocommit=0;
INSERT INTO `userconfig_ucfg` VALUES (0,0,'bEmailMailto','1','boolean','User permission to send email via mailto: links','TRUE',''),(0,1,'sMailtoDelimiter',',','text','Delimiter to separate emails in mailto: links','TRUE',''),(0,5,'bCreateDirectory','0','boolean','User permission to create directories','FALSE','SECURITY'),(0,6,'bExportCSV','0','boolean','User permission to export CSV files','FALSE','SECURITY'),(0,10,'bAddEvent','0','boolean','Allow user to add new event','FALSE','SECURITY'),(1,0,'bEmailMailto','1','boolean','User permission to send email via mailto: links','TRUE',''),(1,1,'sMailtoDelimiter',',','text','user permission to send email via mailto: links','TRUE',''),(1,5,'bCreateDirectory','1','boolean','User permission to create directories','TRUE',''),(1,6,'bExportCSV','1','boolean','User permission to export CSV files','TRUE',''),(3,0,'bEmailMailto','1','boolean','User permission to send email via mailto: links','TRUE',''),(3,1,'sMailtoDelimiter',',','text','Delimiter to separate emails in mailto: links','TRUE',''),(3,5,'bCreateDirectory','','boolean','User permission to create directories','FALSE','SECURITY'),(3,6,'bExportCSV','','boolean','User permission to export CSV files','FALSE','SECURITY'),(3,10,'bAddEvent','','boolean','Allow user to add new event','FALSE','SECURITY'),(59,0,'bEmailMailto','1','boolean','User permission to send email via mailto: links','TRUE',''),(59,1,'sMailtoDelimiter',',','text','Delimiter to separate emails in mailto: links','TRUE',''),(59,5,'bCreateDirectory','','boolean','User permission to create directories','FALSE','SECURITY'),(59,6,'bExportCSV','','boolean','User permission to export CSV files','FALSE','SECURITY'),(59,10,'bAddEvent','','boolean','Allow user to add new event','FALSE','SECURITY'),(76,0,'bEmailMailto','1','boolean','User permission to send email via mailto: links','TRUE',''),(76,1,'sMailtoDelimiter',',','text','Delimiter to separate emails in mailto: links','TRUE',''),(76,5,'bCreateDirectory','','boolean','User permission to create directories','FALSE','SECURITY'),(76,6,'bExportCSV','','boolean','User permission to export CSV files','FALSE','SECURITY'),(76,10,'bAddEvent','','boolean','Allow user to add new event','FALSE','SECURITY'),(95,0,'bEmailMailto','1','boolean','User permission to send email via mailto: links','TRUE',''),(95,1,'sMailtoDelimiter',',','text','Delimiter to separate emails in mailto: links','TRUE',''),(95,5,'bCreateDirectory','','boolean','User permission to create directories','FALSE','SECURITY'),(95,6,'bExportCSV','','boolean','User permission to export CSV files','FALSE','SECURITY'),(95,10,'bAddEvent','','boolean','Allow user to add new event','FALSE','SECURITY');
COMMIT;

-- Dumped table `userconfig_ucfg` with 29 row(s)
--

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `user_id` int(11) NOT NULL,
  `setting_name` varchar(50) NOT NULL,
  `setting_value` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `user_settings`
--

SET autocommit=0;
INSERT INTO `user_settings` VALUES (0,'ui.email.delimiter',','),(1,'finance.FY','23'),(1,'finance.show.payments','true'),(1,'finance.show.pledges','true'),(1,'finance.show.since','2016-01-01'),(1,'ui.email.delimiter',','),(1,'ui.locale','en_US'),(1,'ui.search.calendar.end',NULL),(1,'ui.search.calendar.start',NULL),(1,'ui.style','skin-red'),(1,'ui.table.size','10'),(3,'finance.FY','23'),(3,'finance.show.payments','0'),(3,'finance.show.pledges','0'),(3,'finance.show.since','2016-01-01'),(3,'ui.email.delimiter',','),(3,'ui.locale','en_US'),(3,'ui.search.calendar.end',NULL),(3,'ui.search.calendar.start',NULL),(3,'ui.style','skin-yellow-light'),(3,'ui.table.size','10'),(76,'finance.FY','20'),(76,'finance.show.payments','0'),(76,'finance.show.pledges','0'),(76,'finance.show.since','2016-01-01'),(76,'ui.email.delimiter',','),(76,'ui.search.calendar.end',NULL),(76,'ui.search.calendar.start',NULL),(76,'ui.style','skin-blue'),(76,'ui.table.size','10'),(95,'finance.FY','20'),(95,'finance.show.payments','0'),(95,'finance.show.pledges','0'),(95,'finance.show.since','2016-01-01'),(95,'ui.email.delimiter',','),(95,'ui.search.calendar.end',NULL),(95,'ui.search.calendar.start',NULL),(95,'ui.style','skin-blue'),(95,'ui.table.size','10');
COMMIT;
SET autocommit=0;
COMMIT;

-- Dumped table `user_usr` with 9 row(s)
--

--
-- Table structure for table `version_ver`
--

CREATE TABLE `version_ver` (
  `ver_ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `ver_version` varchar(50) NOT NULL DEFAULT '',
  `ver_update_start` datetime DEFAULT NULL,
  `ver_update_end` datetime DEFAULT NULL,
  PRIMARY KEY (`ver_ID`),
  UNIQUE KEY `ver_version` (`ver_version`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `version_ver`
--

SET autocommit=0;
INSERT INTO `version_ver` VALUES (1,'3.5.0','2019-02-10 20:14:23',NULL),(2,'3.5.2','2019-09-10 22:54:56','2019-09-10 22:54:56'),(3,'3.5.4','2019-10-11 22:45:35','2019-10-11 22:45:35'),(4,'4.0.0','2020-06-16 13:11:20','2020-06-16 13:11:20'),(5,'4.1.0','2020-06-16 13:11:20','2020-06-16 13:11:21'),(6,'4.2.3','2020-10-17 01:46:16','2020-10-17 01:46:16'),(7,'4.3.1','2020-11-23 18:55:02','2020-11-23 18:55:02'),(8,'4.3.2','2020-12-10 01:57:09','2020-12-10 01:57:09'),(9,'4.4.0','2021-03-21 17:44:23','2021-03-21 17:44:23'),(10,'4.4.1','2021-05-09 13:58:09','2021-04-27 13:58:09'),(11,'4.4.2','2021-05-09 13:58:09','2021-04-27 13:58:09'),(12,'4.4.3','2021-05-09 13:58:09','2021-04-27 13:58:09'),(13,'4.4.4','2021-07-08 13:58:09','2021-07-08 13:58:09'),(14,'4.4.5','2021-07-09 13:58:09','2021-07-09 13:58:09'),(15,'4.5.0','2021-07-09 13:58:09','2021-09-03 13:58:09'),(16,'4.5.1','2022-12-03 14:02:00','2022-12-03 14:02:00'),(17,'4.5.2','2022-12-28 21:42:20','2022-12-28 21:42:20'),(18,'4.5.3','2023-01-01 20:32:08','2023-01-01 20:32:08'),(19,'5.0.0','2023-05-06 17:29:55','2023-05-06 17:29:55'),(20,'5.0.5','2023-10-21 19:04:42','2023-10-21 19:04:42'),(21,'5.1.0','2023-10-31 23:33:49','2023-10-31 23:33:49'),(22,'5.2.2','2023-11-05 12:28:43','2023-11-05 12:28:43'),(23,'5.2.3','2023-11-16 12:39:14','2023-11-16 12:39:14'),(24,'5.3.0','2023-11-18 11:10:21','2023-11-18 11:10:21'),(25,'5.3.1','2023-11-21 02:04:10','2023-11-21 02:04:10'),(27,'5.4.0','2023-12-03 20:27:58','2023-12-03 20:27:58'),(29,'5.4.3','2024-01-03 23:24:10','2024-01-03 23:24:10'),(30,'5.5.0','2024-01-03 23:43:18','2024-01-03 23:43:18'),(31,'5.6.0','2024-03-07 20:35:26','2024-03-07 20:35:26'),(32,'5.7.0','2024-03-08 11:58:40','2024-03-08 11:58:40'),(33,'5.8.0','2024-04-25 14:50:41','2024-04-25 14:50:41'),(35,'5.9.0','2024-07-13 17:23:00','2024-07-13 17:23:00'),(36,'5.17.0','2024-07-13 17:23:02','2025-03-28 17:23:02'),(37,'5.18.0','2025-05-10 20:09:48','2025-05-10 20:09:48'),(38,'5.19.0','2025-09-01 13:44:08','2025-09-01 13:44:08'),(39,'5.20.0','2025-10-11 15:27:51','2025-10-11 15:27:51'),(40,'5.21.0','2025-10-13 02:54:08','2025-10-13 02:54:08'),(41,'5.22.0','2025-10-20 00:31:20','2025-10-20 00:31:20'),(42,'6.0.0','2025-11-01 21:56:03','2025-11-01 21:56:03'),(43,'6.0.1','2025-11-15 20:47:13','2025-11-15 20:47:13'),(44,'6.0.2','2025-11-16 01:28:56','2025-11-16 01:28:56'),(45,'6.1.0','2025-11-21 02:25:12','2025-11-21 02:25:12'),(46,'6.2.0','2025-11-21 04:32:38','2025-11-21 04:32:38'),(47,'6.3.0','2025-11-27 02:22:39','2025-11-27 02:22:39'),(48,'6.4.0','2025-12-06 02:24:41','2025-12-06 02:24:41'),(49,'6.5.0','2025-12-13 00:20:35','2025-12-13 00:20:35'),(50,'6.5.1','2025-12-14 17:34:29','2025-12-14 17:34:29'),(51,'6.5.2','2025-12-15 00:59:49','2025-12-15 00:59:49'),(52,'6.5.3','2025-12-15 01:26:13','2025-12-15 01:26:13'),(53,'6.5.4','2025-12-15 01:31:56','2025-12-15 01:31:56'),(55,'6.6.0','2025-12-21 00:24:18','2025-12-21 00:24:18'),(56,'6.6.1','2025-12-26 17:36:40','2025-12-26 17:36:40'),(57,'6.7.0','2025-12-29 16:58:20','2025-12-29 16:58:20'),(58,'6.7.1','2026-01-19 18:05:17','2026-01-19 18:05:17'),(59,'6.7.2','2026-01-25 21:24:56','2026-01-25 21:24:56'),(60,'6.7.3','2026-01-30 02:27:27','2026-01-30 02:27:27'),(61,'6.8.0','2026-01-31 16:57:37','2026-01-31 16:57:37'),(62,'6.8.1','2026-02-01 21:22:06','2026-02-01 21:22:06'),(63,'7.0.0','2026-02-07 18:19:35','2026-02-07 18:19:35'),(64,'7.0.1','2026-02-28 01:03:43','2026-02-28 01:03:43'),(65,'7.0.2','2026-03-05 00:33:03','2026-03-05 00:33:03'),(66,'7.0.3','2026-03-10 00:56:16','2026-03-10 00:56:16'),(67,'7.0.4','2026-03-18 17:06:40','2026-03-18 17:06:40'),(68,'7.0.5','2026-03-18 19:28:55','2026-03-18 19:28:55'),(69,'7.1.0','2026-03-19 19:04:36','2026-03-19 19:04:36'),(70,'7.1.1','2026-04-05 14:36:43','2026-04-05 14:36:43'),(71,'7.1.2','2026-04-06 18:47:07','2026-04-06 18:47:07'),(72,'7.2.0','2026-04-10 12:27:54','2026-04-10 12:27:54'),(73,'7.2.1','2026-04-13 21:25:56','2026-04-13 21:25:56'),(74,'7.2.2','2026-04-17 00:16:04','2026-04-17 00:16:04'),(75,'7.2.3','2026-04-23 05:18:45','2026-04-23 05:18:45'),(76,'7.3.0','2026-04-25 15:27:48','2026-04-25 15:27:48'),(77,'7.3.1','2026-04-26 16:11:39','2026-04-26 16:11:39'),(78,'7.3.2','2026-04-30 19:48:51','2026-04-30 19:48:51'),(79,'7.3.3','2026-05-03 16:08:58','2026-05-03 16:08:58'),(80,'7.4.0','2026-05-11 02:55:53','2026-05-11 02:55:53'),(81,'7.4.1','2026-06-18 17:21:35','2026-06-18 17:21:35');
COMMIT;

-- Dumped table `version_ver` with 68 row(s)
--

--
-- Table structure for table `volunteeropportunity_vol`
--

CREATE TABLE `volunteeropportunity_vol` (
  `vol_ID` int(3) NOT NULL AUTO_INCREMENT,
  `vol_Order` int(3) NOT NULL DEFAULT 0,
  `vol_Active` enum('true','false') NOT NULL DEFAULT 'true',
  `vol_Name` varchar(30) DEFAULT NULL,
  `vol_Description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`vol_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `volunteeropportunity_vol`
--

SET autocommit=0;
COMMIT;

-- Dumped table `volunteeropportunity_vol` with 0 row(s)
--

--
-- Table structure for table `whycame_why`
--

CREATE TABLE `whycame_why` (
  `why_ID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `why_per_ID` mediumint(9) NOT NULL DEFAULT 0,
  `why_join` text NOT NULL,
  `why_come` text NOT NULL,
  `why_suggest` text NOT NULL,
  `why_hearOfUs` text NOT NULL,
  PRIMARY KEY (`why_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `whycame_why`
--

SET autocommit=0;
COMMIT;

-- Dumped table `whycame_why` with 0 row(s)
--

--
-- Stand-In structure for view `email_count`
--

/*!50001 DROP VIEW IF EXISTS `email_count`*/;
CREATE TABLE IF NOT EXISTS `email_count` (
`email` varchar(100)
,`total` bigint(21)
);
--
-- Stand-In structure for view `email_list`
--

/*!50001 DROP VIEW IF EXISTS `email_list`*/;
CREATE TABLE IF NOT EXISTS `email_list` (
`email` varchar(100)
,`type` varchar(11)
,`id` mediumint(9) unsigned
);
--
-- View structure for view `email_count`
--

/*!50001 DROP VIEW IF EXISTS `email_count`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`churchcrm`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `email_count` AS select `email_list`.`email` AS `email`,count(0) AS `total` from `email_list` group by `email_list`.`email` */;

--
-- View structure for view `email_list`
--

/*!50001 DROP VIEW IF EXISTS `email_list`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`churchcrm`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `email_list` AS select `family_fam`.`fam_Email` AS `email`,'family' AS `type`,`family_fam`.`fam_ID` AS `id` from `family_fam` where `family_fam`.`fam_Email` is not null and `family_fam`.`fam_Email` <> '' union select `person_per`.`per_Email` AS `email`,'person_home' AS `type`,`person_per`.`per_ID` AS `id` from `person_per` where `person_per`.`per_Email` is not null and `person_per`.`per_Email` <> '' union select `person_per`.`per_WorkEmail` AS `email`,'person_work' AS `type`,`person_per`.`per_ID` AS `id` from `person_per` where `person_per`.`per_WorkEmail` is not null and `person_per`.`per_WorkEmail` <> '' */;


