--
-- Host: localhost    Database: seniorplicity
-- ------------------------------------------------------


--
-- Table structure for table `added_family`
--

CREATE TABLE `added_family` (
  `added_family_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `community_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `provider_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `sub_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `family_zip` int(11) DEFAULT NULL,
  `search_for` int(11) DEFAULT NULL,
  `relationship` int(11) DEFAULT NULL,
  `date_of_birth` varchar(255) DEFAULT NULL,
  `current_community` int(11) DEFAULT NULL,
  `distance_to` varchar(11) DEFAULT NULL,
  `user_code` varchar(255) DEFAULT NULL,
  `current_community_name` varchar(255) DEFAULT NULL,
  `prefix` varchar(255) DEFAULT NULL,
  `f_name` varchar(255) DEFAULT NULL,
  `l_name` varchar(255) DEFAULT NULL,
  `joined` varchar(255) DEFAULT NULL,
  `reason` text,
  `user_img` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `auto_accept` int(11) NOT NULL DEFAULT '0',
  `selected_alert_option` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `provider_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `day` varchar(11) DEFAULT NULL,
  `month` varchar(11) DEFAULT NULL,
  `year` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`added_family_id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `added_family`
--

INSERT INTO `added_family` VALUES (2,10001,'[107,101,100,97]','[]','[]',34689,358,377,'1994-03-11',NULL,'124','0HXZN5EJ',NULL,NULL,'user','one',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(5,10004,NULL,NULL,NULL,NULL,360,NULL,'2017-03-10',NULL,'123',NULL,NULL,NULL,'Fam1','Fam1',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(6,10005,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T7NW524R',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(4,10004,'[97,98]','null','null',34689,358,NULL,'1987-05-24',NULL,'123',NULL,NULL,'null','Fam1','Fam1','null','null','null','null','null',0,'null',NULL,NULL,NULL,NULL),(7,10006,'[97,98,100]','[]','[]',34689,366,0,'1974-09-25',NULL,'122','5NRGKMQW',NULL,'null','f3','f3','null','null','null','null','null',0,'[0,1]',NULL,NULL,NULL,NULL),(8,10008,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3YMXATPV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(9,10009,'[]','[141]','[166,167,168,170,203]',34689,358,377,'1931-09-14',NULL,'124','Z6OZWTHC',NULL,NULL,'f5','f5',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(10,10010,NULL,NULL,NULL,NULL,NULL,NULL,'1933-08-09',NULL,NULL,'LKVJ737Q',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(11,10011,'[97,98]','[]','[]',34689,355,375,'2001-09-20',NULL,'121','482YQITD',NULL,NULL,'s','s',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(12,10013,'[98,99,100]','[]','[]',34689,355,375,'1931-12-15',NULL,'122','4GUCQ21V',NULL,'null','w','w','null','null','null','null','null',0,'[0,2,1,3,4]',NULL,NULL,NULL,NULL),(13,10015,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'OYG4GR1F',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(14,10016,'[]','[]','[]',34689,355,375,'1932-09-21',NULL,'121','5RGA5Q19',NULL,NULL,'r','r',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(15,10018,NULL,NULL,NULL,NULL,NULL,NULL,'1933-09-19',NULL,NULL,'MOZ4XRAY',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(16,10019,'[97,98,99]','[]','[]',34689,355,375,'1959-09-14',NULL,'122','K7GEK83E',NULL,NULL,'o','o',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(17,10020,'[]','[]','[]',34689,355,375,'1933-09-01',NULL,'122','EZA63VHT',NULL,NULL,'y','y',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(18,10021,'[97,98,100]','[]','[]',34689,355,375,'1949-09-29',NULL,'123','PUHLRXAL',NULL,NULL,'rob','nom',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(19,10021,'[101,107,102]',NULL,NULL,34689,364,NULL,'24-03-2017',NULL,'123',NULL,NULL,'null','rob','nom','null','null','null','null','null',0,'[0,1,2,3,8,9]',NULL,NULL,NULL,NULL),(20,10022,'[97,98,99]','[]','[]',34689,358,377,'1955-09-21',NULL,'123','Y6BY6RF9',NULL,NULL,'v','v',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(21,10024,'[98]','[]','[]',34689,359,377,'2222-02-22T05:00:00.000Z',NULL,'124','P2MGFKPC',NULL,NULL,'z','z',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(22,10025,'[98,99,101]','[]','[]',34689,358,377,'2020-10-07T04:00:00.000Z',NULL,'124','GCLJJ1G7',NULL,NULL,'dd','dd',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(23,10026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O280R00Q',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(24,10027,'[]','[]','[]',34689,358,377,'',NULL,'124','OYCJ0ZER',NULL,NULL,'bb','bb',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(25,10028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DZBUPYG9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(26,10029,'[98,100,101]','[]','[]',34689,358,377,'1941-10-14T05:00:00.000Z',NULL,'124','RNG6PQ0G',NULL,NULL,'hh','hh',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(27,10030,'[98,99,100]','[]','[]',34689,358,377,'1902-01-30T05:00:00.000Z',NULL,'124','ZGY5SHQB',NULL,NULL,'jj','jj',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(28,10031,'[98,99,100,101]','[]','[]',34689,358,377,'2020-10-02T04:00:00.000Z',NULL,'123','ED9HDMSC',NULL,NULL,'kk','kk',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(29,10032,'[98,99,100]','[]','[]',34689,355,375,'2020-10-16T04:00:00.000Z',NULL,'122','L0X90WR0',NULL,NULL,'ll','ll',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(30,10033,'[98,99,100]','[]','[]',34689,355,375,'2020-10-23T04:00:00.000Z',NULL,'124','H3BCPOJK',NULL,NULL,'zz','zz',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(31,10034,'[97,98,99]','[]','[]',34689,355,375,'',NULL,'123','YJFBLNC2',NULL,NULL,'ll','ll',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(32,10035,'[98,99,101,107]','[]','[]',34689,355,375,'',NULL,'123','VNIG7G1N',NULL,'null','mm','mm','null','null','null','null','null',0,'[0]',NULL,'31','11','1'),(33,10037,'[99,100,101]','[]','[]',34689,355,375,'',NULL,'124','FEZR1IYM',NULL,NULL,'f10','f10',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'14','10','10'),(34,10038,'[98,99,100]','[]','[]',34689,355,375,'',NULL,'118','O06VSTUB',NULL,NULL,'c15','c15',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'4','10','5'),(35,10039,'[98,99,100]','[]','[]',34689,355,375,'',NULL,'118','3P1BOPYG',NULL,NULL,'c16','c16',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'6','9','78'),(36,10040,'[98,99,100]','[]','[]',34689,355,375,'',NULL,'118','ZXSM6ONU',NULL,NULL,'sdf','fdsbggbsd',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'7','9','1'),(37,10041,'[98,100,101]','[]','[]',34689,355,375,'',NULL,'118','IN7COB0A',NULL,NULL,'ffff','fffff',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'3','8','69'),(38,10042,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'H2QNLJMV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(39,10043,'[98,100,101]','[]','[]',34689,355,375,'',NULL,'123','9M0E2Z7I',NULL,'null','rt','rt','null','null','null','null','null',0,'[0,1,2,3,4,5,6,7,8,9,10]',NULL,'5','10','15'),(40,10044,'[98]','[]','[]',34689,355,375,'',NULL,'124','6QTARHO2',NULL,NULL,'qw','qw',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','',''),(41,10046,'[98,99,100]','[]','[]',34689,355,375,'',NULL,'123','M868SZC1',NULL,NULL,'d','d',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'6','10','16'),(42,10047,'[98,101,107]','[]','[]',34689,355,375,'',NULL,'123','MWYITTQS',NULL,NULL,'Fam14','Fam14',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'14','8','1'),(43,10052,'[98]','[]','[]',34689,355,375,'',NULL,'121','M2K5IC5T',NULL,NULL,'fffffff','fghsdtf',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'11','4','14'),(44,10054,'[98,99,101]','[]','[]',34689,355,375,'',NULL,'123','TIPQLWYG',NULL,NULL,'zzzzz','zzzzz',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'5','9','18');

--
-- Table structure for table `alert_setting`
--

CREATE TABLE `alert_setting` (
  `alert_setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `new_comm` tinyint(1) NOT NULL DEFAULT '0',
  `comm_turnover` tinyint(1) NOT NULL DEFAULT '0',
  `comm_name_change` tinyint(1) NOT NULL DEFAULT '0',
  `email_blast` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`alert_setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `alert_setting`
--

INSERT INTO `alert_setting` VALUES (1,0,1,0,0,10013);

--
-- Table structure for table `comm_image`
--

CREATE TABLE `comm_image` (
  `img_id` int(11) NOT NULL AUTO_INCREMENT,
  `community_provider_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `caption` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`img_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comm_image`
--

INSERT INTO `comm_image` VALUES (1,1,'cd17869b-b520-4390-b02c-a519f70fb6ff.jpg','Front of Place'),(2,4,'160ad846-2095-4f3a-816f-75003c1ef0e2.jpg',NULL),(3,3,'02fc01f9-ad0d-4545-8214-ea9582bd4f09.jpg',NULL),(4,2,'bf6e7a2e-88d7-4ab8-8e22-7e16273c0ac9.jpg',NULL),(5,2,'c261d9ee-6fab-4c20-8962-80214d1dd9ee.jpg',NULL),(6,2,'55baf1a1-acd1-4b17-9320-a116400ded05.jpg',NULL),(7,10,'b8fc06f1-ae86-4bef-a710-1848614b0012.JPG',NULL),(8,10,'519a9257-65c1-45ec-ad06-0b26d881966b.JPG',NULL),(9,1,'8cc9c825-a997-4087-9dcf-9ab4399e01fd.JPG','gfhujhytgyhujikmnbvfcdrtghyj'),(10,1,'394dc914-d5df-45de-8035-66dacd370b54.JPG',NULL),(11,1,'30c0b071-df46-4bcf-a366-2fdde5b297eb.JPG',NULL),(12,1,'c2650658-8188-4cea-8370-3408d287ef94.JPG',NULL),(13,1,'002976cb-fdd7-4f0d-88ba-159fad36ab8f.JPG',NULL),(14,1,'eb0f97ad-a3f7-42b0-b480-e7cde1455080.JPG',NULL),(15,11,'949557ec-bbe3-4b2f-89b5-5a2001fa7d40.jpg','');

--
-- Table structure for table `community_details`
--

CREATE TABLE `community_details` (
  `detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `detail_type` varchar(265) NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `community_id` int(11) NOT NULL,
  PRIMARY KEY (`detail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `community_details`
--

INSERT INTO `community_details` VALUES (1,'community_type','[97,98]',1),(2,'community_type','[98,99,100]',2),(3,'community_anamnetis','[35,38,41,44,45,48,51,54,52,49,46,43,64]',1),(4,'community_specility','[16,19,22,20,23,12,15,18,24]',1),(5,'price_type','{\"pricing\":[93,94],\"type\":[1,4,5],\"is_public\":false}',1),(6,'community_type','[98]',5),(7,'community_type','[98,99,97]',6),(8,'community_type','[98,100,101]',7),(9,'community_type','[98,99,107]',8),(10,'community_type','[98,99]',9),(11,'community_type','[98,101]',10),(12,'price_type','{\"pricing\":[91],\"type\":[],\"is_public\":false}',10),(13,'community_type','[97,98,107]',11),(14,'community_type','[98,100]',13),(15,'community_type','[97]',14);

--
-- Table structure for table `community_pricing`
--

CREATE TABLE `community_pricing` (
  `community_pricing_id` int(11) NOT NULL AUTO_INCREMENT,
  `community_id` int(11) NOT NULL,
  `max_price` int(11) DEFAULT NULL,
  `min_price` int(11) DEFAULT NULL,
  `meta_id` int(11) NOT NULL,
  PRIMARY KEY (`community_pricing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `community_pricing`
--


--
-- Table structure for table `community_type`
--

CREATE TABLE `community_type` (
  `community_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL,
  PRIMARY KEY (`community_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `community_type`
--

INSERT INTO `community_type` VALUES (1,'55+ Community'),(2,'Assisted Living Community'),(3,'Community Center for Seniors'),(4,'Continuing Care Retirement Community'),(5,'Group Home/Residential Care Home'),(6,'Independent Living/Senior Community'),(7,'Long–Term Care Acute Care Hospital'),(8,'Rehab License'),(9,'Memory Care Community'),(10,'Skilled Nursing Facility/Nursing Home'),(11,'Hospital'),(12,'Transitional Care Hospital');

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `company_id` int(11) NOT NULL AUTO_INCREMENT,
  `dba` varchar(255) DEFAULT NULL,
  `license` varchar(255) DEFAULT NULL,
  `type` varchar(34) DEFAULT NULL,
  `status` varchar(35) DEFAULT NULL,
  `year_founded` int(11) DEFAULT NULL,
  `primarily_phone` varchar(15) DEFAULT NULL,
  `cell_phone` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `website` varchar(265) DEFAULT NULL,
  `external_website` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `company_logo` varchar(255) DEFAULT NULL,
  `company_overview` text,
  `created_by` int(11) DEFAULT NULL,
  `community_id` int(11) NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (1,NULL,'123245','Public','Profit',2010,'555-555-5555','222-222-2222','111-111-1111',NULL,'{\"ew1\":\"linkedin.com\"}','null','Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.',10002,1),(2,NULL,NULL,'Public','Profit',NULL,NULL,NULL,NULL,NULL,'{}','b34f98d6-13d8-49a9-b238-adbe67f06c6c.png',NULL,10003,3),(3,NULL,'34y7512434','Public','Profit',2013,'333-333-3333','444-444-4444','666-666-6666',NULL,'{}','5763bdad-3204-4205-b34a-1a692ea6754b.jpg','Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.',10003,4),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{}','99ad13e4-0114-42f9-bd20-3ddd8078d0b2.jpg',NULL,10002,2),(5,NULL,NULL,'null','null',NULL,NULL,NULL,NULL,NULL,'{}','f3e6ff59-3412-424f-82ed-3fab74ec4993.jpg',NULL,10048,11);

--
-- Table structure for table `connection`
--

CREATE TABLE `connection` (
  `connection_id` int(11) NOT NULL AUTO_INCREMENT,
  `my_id` int(11) NOT NULL,
  `my_type` int(11) NOT NULL,
  `other_id` int(11) NOT NULL,
  `other_type` int(11) NOT NULL,
  `is_accepted` int(11) NOT NULL DEFAULT '0',
  `sender_display` int(11) NOT NULL DEFAULT '0',
  `receiver_display` tinyint(1) NOT NULL DEFAULT '0',
  `sender_seen` int(11) NOT NULL DEFAULT '0',
  `receiver_seen` tinyint(1) NOT NULL DEFAULT '0',
  `sender_disconnect` tinyint(1) NOT NULL DEFAULT '0',
  `receiver_disconnect` varchar(1) NOT NULL DEFAULT '0',
  `updated` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`connection_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `connection`
--

INSERT INTO `connection` VALUES (2,3,1,1,0,0,0,0,1,1,1,'0',1),(8,1,0,4,1,1,0,0,0,0,0,'0',1),(4,10004,3,1,0,1,0,0,0,0,0,'0',1),(5,1,0,2,0,1,0,0,1,1,1,'0',1),(7,1,0,6,0,0,0,0,0,0,0,'0',0),(9,3,1,4,1,1,0,0,0,0,0,'0',1),(12,10035,3,2,0,1,0,0,0,0,0,'0',1),(18,4,1,2,0,0,0,0,0,0,0,'0',0),(17,10040,3,1,0,0,0,0,0,0,0,'0',0),(19,10,0,1,0,1,0,0,0,0,0,'0',1);

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_name` varchar(256) NOT NULL,
  `event_date` varchar(256) DEFAULT NULL,
  `time` varchar(256) DEFAULT NULL,
  `end_time` varchar(256) DEFAULT NULL,
  `repeat_event` varchar(256) DEFAULT NULL,
  `repeat_until` varchar(256) DEFAULT NULL,
  `event_details` text,
  `event_url` varchar(256) DEFAULT NULL,
  `event_image` varchar(256) DEFAULT NULL,
  `event_pdf` varchar(256) DEFAULT NULL,
  `event_keywords` varchar(256) DEFAULT NULL,
  `include_rsvp` tinyint(1) DEFAULT '0',
  `add_email_blast` tinyint(1) DEFAULT '0',
  `add_rsvp` tinyint(1) DEFAULT '0',
  `recieve_rsvp` tinyint(1) DEFAULT '0',
  `email_reminder` tinyint(1) DEFAULT '0',
  `community_provider_id` int(11) NOT NULL,
  `monthly_calender` varchar(256) DEFAULT NULL,
  `event_attend` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `recieve_email` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event`
--

INSERT INTO `event` VALUES (1,'Alpha Event 1','2020-10-23T04:00:00.000Z','2020-09-17T13:45:19.000Z','2020-09-17T15:45:19.000Z','null','null','Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.','seniorplicity.com','2a08cb61-3d1a-4a72-8d46-544ed239a93d.JPG','null','null',1,1,1,0,0,1,'null','null','null'),(2,'Ian Event Sample','2020-11-18T05:00:00.000Z','2020-11-18T03:30:18.000Z','2020-11-18T04:45:18.000Z',NULL,NULL,'rfwqejbhkjhbnquipfghewiul ujghuiew','seniorplicity.com','b7506ea2-776d-4dee-963e-af215e7d0303.jpg','2d73234d-05c4-48a3-8c44-97bea8f46178.pdf',NULL,1,1,1,1,0,1,NULL,NULL,'rfoster001@yahoo.com');

--
-- Table structure for table `family_member`
--

CREATE TABLE `family_member` (
  `family_member_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `f_name` varchar(255) DEFAULT NULL,
  `l_name` varchar(255) DEFAULT NULL,
  `family_name` varchar(255) DEFAULT NULL,
  `prefix` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `relation` varchar(255) DEFAULT NULL,
  `user_img` varchar(255) DEFAULT NULL,
  `school_logo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`family_member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `family_member`
--


--
-- Table structure for table `incentive_suggestions`
--

CREATE TABLE `incentive_suggestions` (
  `incentive_suggestions_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`incentive_suggestions_id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `incentive_suggestions`
--

INSERT INTO `incentive_suggestions` VALUES (1,'Birthday Month Free'),(2,'Consultation Fee Waived'),(3,'Dentist '),(4,'Dental Incentive 2'),(5,'10% off Pre-Need'),(6,'20 % off'),(7,'30 % off'),(8,'Incentive 1'),(9,'Incentive 2'),(10,'Incentive 3'),(11,'sp1'),(12,'SP2'),(13,'sp3'),(14,'BDAY 2 '),(15,'Alpha Incentive'),(16,'This Incentive'),(17,'FROGGER INCENTIVE'),(18,'Incentive Auto'),(19,'rrr'),(20,'I1'),(21,'Realtor Incentive'),(22,'Furniture Discount'),(23,'sp2 incentive'),(24,'Community Incentive'),(25,'Provider Incenitive'),(26,'Provider Incentive'),(27,'Auto Calculate Test'),(28,'Coming Soon Test'),(29,'Tetsing % Incentive'),(30,'9.9.20 Incentive'),(31,'Incentive Alpha Big'),(32,'Beta Incentive 1'),(33,'Provider 1 Incentive'),(34,'Provider 2 Incentive'),(35,'Super Saver'),(36,'Closing Costs'),(37,'Incentive Test Try'),(38,'October Incentive'),(39,'Provder 2 Incentive'),(40,'Provider October Incentive'),(41,'November Incentive'),(42,'Nov. 1a Incentive'),(43,'New Incentive'),(44,'New 2 Incentive'),(45,'Future Incentive'),(46,'test 1'),(47,'test 2');

--
-- Table structure for table `incentives`
--

CREATE TABLE `incentives` (
  `incentive_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `community_provider_id` int(11) NOT NULL,
  `incentive_name` varchar(255) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `incentive_limited` varchar(255) DEFAULT NULL,
  `how_many` int(11) DEFAULT NULL,
  `coming_soon_email` varchar(255) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  `autocalculate_value` int(11) NOT NULL DEFAULT '0',
  `send_to` varchar(255) DEFAULT NULL,
  `send_email` varchar(255) DEFAULT NULL,
  `description` text,
  `legal_desclaimer` text,
  `image` varchar(255) DEFAULT NULL,
  `published` tinyint(1) DEFAULT '1',
  `is_paused` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`incentive_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `incentives`
--

INSERT INTO `incentives` VALUES (1,10002,1,'Incentive Alpha Big','2020-09-17T13:48:39.252Z','2020-09-25T04:00:00.000Z',NULL,NULL,NULL,5000,0,'[]',NULL,NULL,NULL,'',1,0),(2,10002,2,'Beta Incentive 1','2020-09-17T13:49:22.668Z','2020-09-30T04:00:00.000Z',NULL,NULL,NULL,4000,0,'[]',NULL,NULL,NULL,'05bfc3fb-8bd7-4259-87b5-430af1c23e4a.png',1,0),(3,10003,3,'Provider 1 Incentive','2020-09-17T13:55:36.899Z','2020-09-30T04:00:00.000Z',NULL,NULL,NULL,1000,0,'[]',NULL,'Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.','Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.','1b3ca693-4818-40c4-a11a-197ba4490acb.png',1,0),(4,10003,4,'Provider 2 Incentive','2020-09-17T13:56:35.967Z','2020-09-30T04:00:00.000Z',NULL,NULL,NULL,2000,0,'[]',NULL,'Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.','Seniorplicity is an ecosystem of Senior Communities, Service Providers, Wholesales and Manufactures. This ecosystem enables each party to market, track and utilize one another using linked data. Linked data allows Seniorplicity to instantly match all parties with relevant partners incentivizing end-users with combined service offerings. Combining services allows users to compound discounts possibly saving thousands of dollars.','2ff0410e-ce44-4956-a68c-a5952ea8d59d.jpg',1,0),(5,10002,1,'Super Saver','2020-09-17T20:00:43.343Z','2020-10-03T04:00:00.000Z',NULL,NULL,NULL,2000,0,'[]',NULL,'Super Saver Test','Super Saver Test','48af3e13-dd2b-42b3-bf56-38a3d6b717e8.jpg',1,0),(6,10003,3,'Closing Costs','2020-09-22T14:14:05.617Z','2020-09-30T04:00:00.000Z',NULL,NULL,'yes',500,0,'[\"1\",\"2\",\"3\",\"4\"]',NULL,'Closing Cost Incentive',NULL,'0c969c66-1bf6-4001-9b6f-f576464a9997.JPG',1,0),(7,10003,3,'Closing Costs','2020-09-22T14:14:05.617Z','2020-10-02T04:00:00.000Z',NULL,0,'yes',500,0,'[\"1\",\"2\",\"3\",\"4\"]',NULL,'Closing Cost Incentive',NULL,'0c969c66-1bf6-4001-9b6f-f576464a9997.JPG',1,0),(8,10007,5,'Incentive Test Try','2020-10-06T19:47:48.576Z','2020-10-23T04:00:00.000Z',NULL,NULL,NULL,500,0,'[]',NULL,NULL,NULL,'4da08f47-bc49-476f-b25f-b6cc8d83f276.jpg',1,0),(9,10002,1,'October Incentive','2020-10-14T19:29:00.072Z','2020-10-31T04:00:00.000Z','no',NULL,NULL,3000,0,'[]',NULL,'Describe an experience working with a senior that was in transition from their home to a senior community. I have had several experiences working with individuals/couples making the transition. I take on the transition as if it were my loved ones (I have experienced this 4 times with my own family members) by assisting them with all facets of the transition. Whether it is assisting the senior to sell, donate or etc. items from their properties to sell/close and move into a senior community. Or making trips to the senior community to help explain or present the seller with the documents and reports for the sale of their property. I work a long side family members to explain and communicate the listing/sale of the seniors property.\n \n','In your local area what separates your office from the other brokerages? My brokerage is Baird & Warner, we are a family owned and operated in Chicagoland is 1855. We have 27 offices throughout Chicagoland. We are one of the founders of Leading Real Estate Companies of the World which allow our local brokerage worldwide connections for our clients.  ','3d7244a1-7c50-4b85-9035-735e2f984834.png',1,0),(10,10003,4,'Provder 2 Incentive','2020-10-14T20:24:45.677Z','2020-10-31T04:00:00.000Z',NULL,NULL,NULL,2300,0,'[]',NULL,'What separates you from other realtors? What makes me different from other realtors is my balance between my professionalism and my caring and compassion for my clients. I treat my clients the way I would expect to be treated. I continue to learn, grow and build my skills to best serve my clients with their real estate needs. I pride myself on going the extra mile for my clients and making the process of buying or selling a home as smooth as possible. ','This isn’t a requirement, but do you hold any current designations such as SRES or CSHP? Yes, I hold several designations and certifications. Senior Real Estate Specialist ~ SRES, Real Estate Negotiations Expert ~ RENE, Certified Staging Consultant ~ CSC, Certified Military on the Move ~ MoM, Certified First Responder Specialist ~ FRS, LeadingRE Relocation Specialist ~ LRS, National Association of Realtors ~ C2EX Certified, and Short Sale and Foreclosures ~ SFR ','f634f0e2-6385-47db-858a-4500c4be777f.JPG',1,0),(11,10002,2,'Beta Incentive 1','2020-10-14T20:35:12.262Z','2020-10-30T04:00:00.000Z',NULL,0,NULL,4000,0,'[]',NULL,NULL,NULL,'05bfc3fb-8bd7-4259-87b5-430af1c23e4a.png',1,0),(12,10003,3,'Provider October Incentive','2020-10-14T20:44:23.012Z','2020-10-31T04:00:00.000Z',NULL,NULL,NULL,2150,0,'[]',NULL,'In your local area what separates your office from the other brokerages? My brokerage is Baird & Warner, we are a family owned and operated in Chicagoland is 1855. We have 27 offices throughout Chicagoland. We are one of the founders of Leading Real Estate Companies of the World which allow our local brokerage worldwide connections for our clients.  ','In your local area what separates your office from the other brokerages? My brokerage is Baird & Warner, we are a family owned and operated in Chicagoland is 1855. We have 27 offices throughout Chicagoland. We are one of the founders of Leading Real Estate Companies of the World which allow our local brokerage worldwide connections for our clients.  ','e8ab1079-fd61-415f-9138-717b826eea70.jpg',1,0),(13,10002,1,'November Incentive','2020-11-02T13:54:18.128Z','2020-11-30T05:00:00.000Z',NULL,NULL,NULL,1500,0,'[]',NULL,NULL,NULL,'ea15d230-3195-400f-8b5b-361b3970d993.jpg',1,0),(14,10002,1,'Nov. 1a Incentive','2020-11-02T14:07:39.414Z','2020-11-04T05:00:00.000Z',NULL,NULL,NULL,2000,0,'[]',NULL,NULL,NULL,'',1,0),(15,10045,10,'New Incentive','2020-11-06T14:35:51.359Z','2020-11-30T05:00:00.000Z',NULL,NULL,'yes',160,1,'[1,3]','4',NULL,NULL,'',1,0),(16,10002,1,'New 2 Incentive','2020-11-06T21:08:35.375Z','2020-11-20T05:00:00.000Z',NULL,NULL,'yes',50,1,'[1,2,3,4]','3','nmjfaklsrjnhgv;iowre','frwegfqr;jlbnhgu;o4ujeroigfofl,;sagf','059432e3-edce-45bd-9fa9-5f4be1b8ead2.png',1,0),(17,10002,1,'Future Incentive','2020-11-18T05:00:00.000Z','2020-11-27T05:00:00.000Z','',0,NULL,40000,0,'[]','','','','',1,0),(18,10002,1,'Ian\'s Incentive 1','2020-11-17T17:04:45.268Z','2020-11-27T05:00:00.000Z','no',NULL,'yes',50,1,'[1,2]','3','fdlhgufhgiuyqwhfy7uiev','This is legal for everyone everywhere to use nonstop.  ','7306738b-ab6f-4459-b762-e231ae780c8e.png',1,0),(19,10002,1,'Incentive Alpha Big','2020-09-17T13:48:39.252Z','2020-09-25T04:00:00.000Z',NULL,0,NULL,5000,0,'[]',NULL,NULL,NULL,'',1,0),(20,10002,1,'Incentive Alpha Big','2020-12-01T07:00:00.000Z','2021-01-01T07:00:00.000Z',NULL,0,NULL,5000,0,'[]',NULL,NULL,NULL,'',1,0),(21,10002,1,'test 1','2020-12-02T23:37:42.218Z','2021-01-01T07:00:00.000Z',NULL,NULL,NULL,20,1,'[]',NULL,NULL,NULL,'',1,0),(22,10002,1,'test 2','2020-12-03T00:04:34.760Z','2020-12-31T07:00:00.000Z','yes',10,NULL,50,0,'[]',NULL,NULL,NULL,'',1,0);

--
-- Table structure for table `insurance_info`
--

CREATE TABLE `insurance_info` (
  `insurance_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(256) NOT NULL,
  `value` text,
  `community_provider_id` int(11) NOT NULL,
  PRIMARY KEY (`insurance_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `insurance_info`
--

INSERT INTO `insurance_info` VALUES (1,'Long Term','0',3);

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `reciever_email` varchar(256) NOT NULL,
  `sender_email` varchar(256) DEFAULT NULL,
  `text` text,
  `subject` varchar(255) DEFAULT NULL,
  `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(20) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `sender_id` int(11) NOT NULL DEFAULT '0',
  `receiver_id` int(11) NOT NULL DEFAULT '0',
  `comm_name` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `user_type` int(11) NOT NULL DEFAULT '0',
  `incentive_id` int(11) NOT NULL DEFAULT '0',
  `shared_id` int(11) NOT NULL DEFAULT '0',
  `shared_comm_name` varchar(255) DEFAULT NULL,
  `selected_type` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` VALUES (5,'q@noemail.com','rfoster001@yahoo.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-09-23 16:54:07','message',1,10004,0,NULL,10004,3,0,0,NULL,3),(9,'q@noemail.com','o@noemail.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-09-24 01:05:54','message',0,10019,0,NULL,10019,3,0,0,NULL,3),(10,'o@noemail.com','q@noemail.com','<div><div>undefined </b></div></div>','Connection request accepted','2020-09-24 01:07:27','message',0,10010,0,NULL,10010,3,0,0,NULL,3),(23,'u@noemail.com','robert@seniorplicity.com','Your request for connection has been accepted by Alpha Community','Connection request accepted','2020-09-28 20:57:21','message',0,1,0,'Alpha Community',10002,0,0,0,NULL,0),(39,'c2@noemail.com','robert@seniorplicity.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-14 19:32:28','message',0,1,5,'Alpha Community',10002,0,0,0,NULL,0),(40,'c3@noemail.com','robert@seniorplicity.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-14 19:32:38','message',0,1,6,'Alpha Community',10002,0,0,0,NULL,0),(49,'rfoster001@yahoo.com','mm@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 11:01:36','message',0,10035,0,NULL,10035,3,0,1,NULL,0),(56,'rfoster001@yahoo.com','mm@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 11:24:06','message',0,10035,0,NULL,10035,3,0,1,NULL,0),(58,'rfoster001@yahoo.com','mm@noemail.com','<div><div>I\'d like to share this provider with you. </b></div></div>','Provider shared','2020-10-22 11:24:06','message',0,10035,0,NULL,10035,3,0,3,NULL,1),(61,'robert@seniorplicity.com','robert@youralf.com','Your request for connection has been accepted by Provider 1','Connection request accepted','2020-10-22 11:58:46','message',0,3,0,'Provider 1',10003,1,0,0,NULL,0),(62,'robert@seniorplicity.com','robert@youralf.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-22 13:16:21','message',0,4,2,'Provider 2',10003,1,0,0,NULL,0),(63,'robert@seniorplicity.com','robert@youralf.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-22 13:30:04','message',0,4,2,'Provider 2',10003,1,0,0,NULL,0),(64,'rfoster001@yahoo.com','c15@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 13:31:46','message',0,10038,0,NULL,10038,3,0,1,NULL,0),(65,'robert@seniorplicity.com','rfoster001@yahoo.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 13:39:17','message',0,10004,0,NULL,10004,3,0,1,NULL,0),(66,'robert@seniorplicity.com','rfoster001@yahoo.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 13:39:17','message',0,10004,0,NULL,10004,3,0,2,NULL,0),(67,'robert@seniorplicity.com','rfoster001@yahoo.com','<div><div>I\'d like to share this provider with you. </b></div></div>','Provider shared','2020-10-22 13:39:17','message',0,10004,0,NULL,10004,3,0,3,NULL,1),(68,'robert@seniorplicity.com','robert@youralf.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-22 13:55:19','message',0,4,2,'Provider 2',10003,1,0,0,NULL,0),(69,'rfoster001@yahoo.com','c16@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 13:58:03','message',0,10039,0,NULL,10039,3,0,1,NULL,0),(70,'roster001@yahoo.com','c16@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 14:03:06','message',0,10039,0,NULL,10039,3,0,1,NULL,0),(71,'roster001@yahoo.com','c16@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 14:03:06','message',0,10039,0,NULL,10039,3,0,2,NULL,0),(72,'robert@seniorplicity.com','robert@youralf.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-22 16:15:09','message',0,4,2,'Provider 2',10003,1,0,0,NULL,0),(73,'robert@seniorplicity.com','vv@noemail.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-22 16:16:48','message',0,10040,1,NULL,10040,3,0,0,NULL,0),(74,'rfoster001@yahoo.com','vv@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 16:18:33','message',0,10040,0,NULL,10040,3,0,2,NULL,0),(75,'robert@seniorplicity.com','robert@youralf.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-10-22 19:48:02','message',0,4,2,'Provider 2',10003,1,0,0,NULL,0),(76,'rfoster001@yahoo.com','ffff@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 19:51:13','message',0,10041,0,NULL,10041,3,0,1,NULL,0),(77,'rfoster001@yahoo.com','ffff@noemail.com','<div><div>I\'d like to share this provider with you. </b></div></div>','Provider shared','2020-10-22 19:58:28','message',0,10041,0,NULL,10041,3,0,3,NULL,1),(78,'rfoster001@yahoo.com','ffff@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-10-22 19:58:28','message',0,10041,0,NULL,10041,3,0,1,NULL,0),(79,'rfoster001@yahoo.com','rt@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-11-02 13:58:01','message',0,10043,0,NULL,10043,3,0,1,NULL,0),(80,'rfoster001@yahoo.com','qw@noemail.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-11-02 15:04:08','message',0,10044,0,NULL,10044,3,0,1,NULL,0),(81,'robert@seniorplicity.com','fff@noemail.com','<div><div>I\'d like to connect with you. </b></div></div>','Connection request','2020-11-06 14:43:35','message',0,10,1,'Alpha 2 Commmunity',10045,0,0,0,NULL,0),(82,'fff@noemail.com','robert@seniorplicity.com','Your request for connection has been accepted by Alpha Community','Connection request accepted','2020-11-06 14:45:09','message',0,1,0,'Alpha Community',10002,0,0,0,NULL,0),(83,'robert@youralf.com','robert@seniorplicity.com','Your request for connection has been accepted by Alpha Community','Connection request accepted','2020-11-06 21:14:37','message',0,1,0,'Alpha Community',10002,0,0,0,NULL,0),(84,'robert@seniorplicity.com','robert@youralf.com','<div><div>I\'d like to sponsor your community. </b></div></div>','Sponsorship request','2020-11-06 21:22:00','message',0,4,1,'Provider 2',10003,1,0,0,NULL,0),(85,'robert@youralf.com','robert@seniorplicity.com','<div><div>Your sponsorship request has been accepted by the community. </b></div></div>','Sponsorship request accepted','2020-11-06 21:23:31','message',0,1,4,'Alpha Community',10002,0,0,0,NULL,0),(86,'rfoster001@yahoo.com','rfoster001@yahoo.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-11-17 18:14:42','message',0,10004,0,NULL,10004,3,0,1,NULL,0),(87,'robert@seniorplicity.com','rfoster001@yahoo.com','<div><div>I\'d like to share this community with you. </b></div></div>','Community shared','2020-11-17 18:14:42','message',0,10004,0,NULL,10004,3,0,1,NULL,0),(88,'robert@seniorplicity.com','robert@seniorplicity.com','Your request for connection has been accepted by Alpha Community','Connection request accepted','2020-12-02 22:28:19','message',0,1,0,'Alpha Community',10002,0,0,0,NULL,0),(89,'robert@seniorplicity.com','robert@seniorplicity.com','Your request for connection has been accepted by Alpha Community','Connection request accepted','2020-12-02 22:28:23','message',0,1,0,'Alpha Community',10002,0,0,0,NULL,0);

--
-- Table structure for table `my_incentives`
--

CREATE TABLE `my_incentives` (
  `my_incentives_id` int(11) NOT NULL AUTO_INCREMENT,
  `incentive_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `community_provider_id` int(11) NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`my_incentives_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `my_incentives`
--


--
-- Table structure for table `notification_alerts`
--

CREATE TABLE `notification_alerts` (
  `notification_alerts_id` int(11) NOT NULL AUTO_INCREMENT,
  `connection_id` int(11) NOT NULL,
  `community_provider_id` int(11) NOT NULL,
  `user_type` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`notification_alerts_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notification_alerts`
--

INSERT INTO `notification_alerts` VALUES (1,1,2,0,0),(2,2,1,0,0),(3,3,1,0,0),(4,4,1,0,0),(5,5,2,0,0),(6,6,5,0,0),(7,7,6,0,0),(8,8,4,1,0),(9,9,4,1,0),(10,10,1,0,0),(11,11,1,0,0),(12,12,2,0,0),(13,13,2,0,0),(14,14,2,0,0),(15,15,2,0,0),(16,16,2,0,0),(17,17,1,0,0),(18,18,2,0,0),(19,19,1,0,0);

--
-- Table structure for table `provider_sub_types`
--

CREATE TABLE `provider_sub_types` (
  `provider_sub_types_id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) NOT NULL,
  `parent_id` int(11) NOT NULL,
  PRIMARY KEY (`provider_sub_types_id`)
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `provider_sub_types`
--

INSERT INTO `provider_sub_types` VALUES (1,'Social',140),(2,'Medical',140),(3,'Specialized',140),(4,'Estate Planning',141),(5,'Medicaid Planning',141),(6,'Probate',141),(7,'Trust Administration',141),(8,'Wills',141),(9,'Musculoskeletal Chiropractor',142),(10,'Traditional Chiropractor',142),(11,'Air Conditioning and Heating',143),(12,'Carpentry',143),(13,'Concrete Work',143),(14,'Drywall',143),(15,'Electrical',143),(16,'Exterior Doors',143),(17,'Flooring',143),(18,'Framing',143),(19,'Handicap Modification',143),(20,'Interior Doors',143),(21,'Landscaping',143),(22,'Painting',143),(23,'Plastering',143),(24,'Pluming',143),(25,'Roofing',143),(26,'Security',143),(27,'Sheet Metal Work',143),(28,'Siding',143),(29,'Special Trade Contractors',143),(30,'Stonework',143),(31,'Tile Setting',143),(32,'Geriatric Counselor',143),(33,'Geriatric Psychiatrist',143),(34,'Grief Counselor',143),(35,'Individual',143),(36,'Licensed Clinical Social Worker',143),(37,'Psychiatrist',143),(38,'Psychologist',143),(39,'Speech Language Pathologist',143),(40,'Stress',143),(41,'Family',144),(42,'Geriatric Counselor',144),(43,'Geriatric Psychiatrist',144),(44,'Grief Counselor',144),(45,'Individual',144),(46,'Licensed Clinical Social Worker',144),(47,'Psychiatrist',144),(48,'Psychologist',144),(49,'Speech Language Pathologist',144),(50,'Stress',144),(51,'General Dentist',145),(52,'Orthodontist',145),(53,'Oral Surgeon',145),(54,'Bill Payment',146),(55,'Existing Medical Bills',146),(56,'Household Financial Management',146),(57,'Reverse Mortgage',146),(58,'Social Security Benefits Planning',146),(59,'At-Need',147),(60,'Burial',147),(61,'Cemetery',147),(62,'Cremation',147),(63,'Headstone',147),(64,'Insurance',147),(65,'Mausoleum',147),(66,'Pre-Planning',147),(67,'Transportation',147),(68,'Vault',147),(69,'New',148),(70,'Rent to Own',148),(71,'Rental',148),(72,'Used',148),(73,'Clinical Audiologists',149),(74,'Hearing Aids',149),(75,'Repair',149),(76,'Bathroom',150),(77,'Doorways and Doors',150),(78,'Hand Rails',150),(79,'Lifts and Hoists',150),(80,'Ramps',150),(81,'Adult Day Care',151),(82,'Geriatric Care Management',151),(83,'Home Health Care (Medical)',151),(84,'Home Health Care (Non-medical)',151),(85,'Live-In Home Care',151),(86,'Alarms',152),(87,'Audio',152),(88,'Bracelets',152),(89,'Cameras',152),(90,'Medicare',153),(91,'Medicare Supplemental ',153),(92,'Medicaid',153),(93,'Private Health Insurance',153),(94,'Incontinent Supplies',154),(95,'Manuel Wheelchairs',154),(96,'Medical Products',154),(97,'Oxygen',154),(98,'Power Wheelchairs',154),(99,'Respiratory Equipment',154),(100,'Walkers',154),(101,'Auctioneer',155),(102,'Downsizing Service',155),(103,'Estate Sales',155),(104,'Movers',155),(105,'Relocation Move Manager and Organizer',155),(106,'Acute Care',156),(107,'Adult Gerontology',156),(108,'Emergency',156),(109,'Family',156),(110,'Psychiatric',156),(111,'Corporate Wellness',157),(112,'Food Labeling',157),(113,'Food Products',157),(114,'Food Safety',157),(115,'Public Health',157),(116,'Regulatory Affairs',157),(117,'Bubble Wrapping',158),(118,'Delivery',158),(119,'Infusion',158),(120,'Retail',158),(121,'Acupuncturist',159),(122,'Allergist (Immunologist)',159),(123,'Cardiologist (Heart Doctor)',159),(124,'Cardiothoracic Surgeon',159),(125,'Chiropractor',159),(126,'Colorectal Surgeon',159),(127,'Dermatologist',159),(128,'Dietitian / Nutritionist',159),(129,'Ear, Nose & Throat Doctor (ENT)',159),(130,'Endocrinologist (incl Diabetes Specialists)',159),(131,'Gastroenterologist',159),(132,'Hematologist (Blood Specialist)',159),(133,'Infectious Disease Specialist',159),(134,'Naturopathic Doctor',159),(135,'Nephrologist (Kidney Specialist)',159),(136,'Neurologist (incl Headache Specialists)',159),(137,'Neurosurgeon',159),(138,'Oncologist',159),(139,'Ophthalmologist',159),(140,'Optometrist',159),(141,'Oral Surgeon',159),(142,'Orthopedic Surgeon (Orthopedist)',159),(143,'Pain Management Specialist',159),(144,'Pediatrician',159),(145,'Physiatrist (Physical Medicine)',159),(146,'Plastic Surgeon',159),(147,'Podiatrist (Foot and Ankle Specialist)',159),(148,'Primary Care Doctor',159),(149,'Prosthodontist',159),(150,'Pulmonologist (Lung Doctor)',159),(151,'Radiologist',159),(152,'Rheumatologist',159),(153,'Sleep Medicine Specialist',159),(154,'Sports Medicine Specialist',159),(155,'Urgent Care Doctor',159),(156,'Urological Surgeon',159),(157,'Urologist',159),(158,'Vascular Surgeon',159),(159,'Agent',160),(160,'Buyer',160),(161,'Management',160),(162,'Rental',160),(163,'Seller',160),(164,'Occupational Therapy',161),(165,'Physical Therapy',161),(166,'Airplane',162),(167,'Ambulance Transportation',162),(168,'Private Transportation',162),(169,'Shuttle Transportation',162);

--
-- Table structure for table `save_search`
--

CREATE TABLE `save_search` (
  `save_id` int(11) NOT NULL AUTO_INCREMENT,
  `saver_id` int(11) NOT NULL DEFAULT '0',
  `saved_id` int(11) NOT NULL DEFAULT '0',
  `user_type` int(11) NOT NULL,
  PRIMARY KEY (`save_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `save_search`
--

INSERT INTO `save_search` VALUES (44,10047,1,3),(45,10047,3,3),(46,10052,4,3);

--
-- Table structure for table `saved_searches`
--

CREATE TABLE `saved_searches` (
  `saved_searches_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `user_type` int(11) NOT NULL,
  `community_provider_id` int(11) DEFAULT NULL,
  `saved_name` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `saved_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `shared` int(11) NOT NULL DEFAULT '0',
  `multiple_community_provider_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  PRIMARY KEY (`saved_searches_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saved_searches`
--

INSERT INTO `saved_searches` VALUES (1,10001,3,NULL,'12',1,'2020-09-29 17:14:40',0,'[1,2]'),(2,10004,3,NULL,'Combo Incentive',1,'2020-09-29 21:01:08',0,'[1,3,4]'),(7,10022,3,NULL,'save community search',1,'2020-09-30 19:40:14',0,'[1]'),(5,10004,3,NULL,'3 communities',1,'2020-09-30 10:04:48',0,'[1,2,5]'),(6,10004,3,NULL,'2 4 1',1,'2020-09-30 10:05:05',0,'[1,2,3]'),(9,10027,3,NULL,'3 assisted Livings',1,'2020-10-07 13:30:54',0,'[1,2,5]'),(10,10027,3,NULL,'1ALF 1 NH',1,'2020-10-07 13:31:11',0,'[6,2]'),(12,10035,3,NULL,'Community Provider Search',1,'2020-10-22 11:19:37',0,'[1,3]'),(13,10039,3,NULL,'All Search',1,'2020-10-22 14:01:52',0,'[1,2,3]'),(14,10039,3,NULL,'Communities',1,'2020-10-22 14:02:33',0,'[1,2]'),(15,10041,3,NULL,'C & P save',1,'2020-10-22 19:56:43',0,'[1,3]'),(16,10043,3,NULL,'November 1 Search',1,'2020-11-02 13:58:25',0,'[3,1]'),(17,10047,3,NULL,'CP Saved 11.6',1,'2020-11-06 21:48:39',0,'[1,3]'),(18,10004,3,NULL,'alpha and P1',1,'2020-11-17 18:08:35',0,'[1,3]');

--
-- Table structure for table `service_user_names`
--

CREATE TABLE `service_user_names` (
  `service_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `names` varchar(255) NOT NULL,
  PRIMARY KEY (`service_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service_user_names`
--


--
-- Table structure for table `sponsorship`
--

CREATE TABLE `sponsorship` (
  `sponsor_id` int(11) NOT NULL AUTO_INCREMENT,
  `community_provider_id` int(11) NOT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `receiver_name` varchar(256) DEFAULT NULL,
  `receiver_id` int(11) NOT NULL,
  `request_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=>pending,1=>accepted,2=>suponsering',
  `anual_payment` tinyint(1) NOT NULL DEFAULT '0',
  `monthly_payment` tinyint(1) DEFAULT '0',
  `manual_payment` tinyint(1) NOT NULL DEFAULT '0',
  `auto_payment` tinyint(1) NOT NULL DEFAULT '0',
  `payment_datetime` varchar(256) DEFAULT NULL,
  `profile_id` int(11) NOT NULL DEFAULT '0',
  `payment_profile_id` int(11) NOT NULL DEFAULT '0',
  `address_id` int(11) NOT NULL DEFAULT '0',
  `transaction_id` varchar(255) NOT NULL DEFAULT '0',
  `responce_code` varchar(255) NOT NULL DEFAULT '0',
  `auto_renew` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`sponsor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sponsorship`
--

INSERT INTO `sponsorship` VALUES (1,3,70,'Alpha Community',1,'2020-10-02 12:11:45',1,0,1,0,1,NULL,1515875350,1513779649,1512890953,'6899296','I00001',1),(2,4,70,'Alpha Community',1,'2020-11-06 21:24:29',1,1,0,0,1,NULL,1516291859,1514365640,500062897,'7029858','I00001',1);

--
-- Table structure for table `stats`
--

CREATE TABLE `stats` (
  `stats_id` int(11) NOT NULL AUTO_INCREMENT,
  `community_provider_id` int(11) NOT NULL,
  `my_id` int(11) NOT NULL,
  `view` int(11) NOT NULL DEFAULT '1',
  `is_share` tinyint(1) NOT NULL DEFAULT '0',
  `is_saved` tinyint(1) NOT NULL DEFAULT '0',
  `incentive_view` int(11) NOT NULL DEFAULT '0',
  `is_sponsor` tinyint(1) NOT NULL DEFAULT '0',
  `is_connection` tinyint(1) NOT NULL DEFAULT '0',
  `incentive_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`stats_id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stats`
--

INSERT INTO `stats` VALUES (1,1,1,1,0,0,1,0,0,1),(2,4,4,1,0,0,1,0,0,4),(3,4,4,1,0,0,1,0,0,4),(4,3,3,1,0,0,1,0,0,3),(5,1,10004,1,0,0,1,0,0,1),(6,1,10004,1,0,0,1,0,0,1),(7,1,10006,1,0,0,1,0,0,1),(8,1,10006,1,0,0,1,0,0,1),(9,2,10006,1,0,0,1,0,0,2),(10,2,10006,1,0,0,1,0,0,2),(11,2,10006,1,0,0,1,0,0,2),(12,1,10009,1,0,0,1,0,0,1),(13,1,3,1,0,0,1,0,0,1),(14,1,10011,1,0,0,1,0,0,1),(15,1,10013,1,0,0,1,0,0,1),(16,1,10016,1,0,0,1,0,0,1),(17,1,10018,1,0,0,1,0,0,1),(18,1,10018,1,0,0,1,0,0,1),(19,1,10019,1,0,0,1,0,0,1),(20,1,10020,1,0,0,1,0,0,1),(21,1,10004,1,0,0,1,0,0,5),(22,1,10004,1,0,0,1,0,0,5),(23,1,10004,1,0,0,1,0,0,5),(24,1,10004,1,0,0,1,0,0,5),(25,1,1,1,0,0,1,0,0,5),(26,1,10004,1,0,0,1,0,0,5),(27,1,10004,1,0,0,1,0,0,5),(28,1,1,1,0,0,1,0,0,5),(29,2,1,1,0,0,1,0,0,2),(30,1,3,1,0,0,1,0,0,5),(31,1,3,1,0,0,0,1,0,0),(32,1,10021,1,0,0,1,0,0,5),(33,2,10021,1,0,0,1,0,0,2),(34,1,10021,1,0,0,1,0,0,5),(35,1,3,1,0,0,1,0,0,5),(36,1,1,1,0,0,1,0,0,5),(37,2,1,1,0,0,1,0,0,0),(38,1,3,1,0,0,1,0,0,5),(39,1,10022,1,0,0,1,0,0,5),(40,1,3,1,0,0,1,0,0,5),(41,1,3,1,0,0,0,1,0,0),(42,1,10024,1,0,0,1,0,0,0),(43,1,10025,1,0,0,1,0,0,0),(44,1,10027,1,0,0,1,0,0,0),(45,1,10029,1,0,0,1,0,0,0),(46,1,10029,1,0,0,1,0,0,0),(47,1,10029,1,0,0,1,0,0,0),(48,1,10004,1,0,0,1,0,0,0),(49,1,10030,1,0,0,1,0,0,0),(50,1,10030,1,0,0,1,0,0,0),(51,2,10030,1,0,0,1,0,0,0),(52,2,10004,1,0,0,1,0,0,0),(53,1,10031,1,0,0,1,0,0,0),(54,2,10031,1,0,0,1,0,0,0),(55,1,10032,1,0,0,1,0,0,0),(56,2,10032,1,0,0,1,0,0,0),(57,1,10033,1,0,0,1,0,0,0),(58,1,10001,1,0,0,1,0,0,0),(59,1,10033,1,0,0,1,0,0,0),(60,2,10033,1,0,0,1,0,0,0),(61,1,10033,1,0,0,1,0,0,0),(62,2,10033,1,0,0,1,0,0,0),(63,1,10033,1,0,0,1,0,0,0),(64,1,10033,1,0,0,1,0,0,9),(65,5,1,1,0,0,1,0,0,8),(66,1,10033,1,0,0,1,0,0,9),(67,1,10033,1,0,0,1,0,0,9),(68,4,1,1,0,0,1,0,0,0),(69,2,2,1,0,0,1,0,0,0),(70,2,2,1,0,0,1,0,0,0),(71,2,1,1,0,0,1,0,0,0),(72,4,3,1,0,0,1,0,0,10),(73,4,3,1,0,0,1,0,0,10),(74,1,10033,1,0,0,1,0,0,9),(75,1,10033,1,0,0,1,0,0,9),(76,1,10033,1,0,0,1,0,0,9),(77,1,10033,1,0,0,1,0,0,9),(78,1,10033,1,0,0,1,0,0,9),(79,1,10034,1,0,0,1,0,0,9),(80,1,10033,1,0,0,1,0,0,9),(81,1,10033,1,0,0,1,0,0,9),(82,2,10033,1,0,0,1,0,0,11),(83,1,10035,1,0,0,1,0,0,9),(84,1,10035,1,0,0,1,0,0,9),(85,2,10035,1,0,0,1,0,0,11),(86,1,10035,1,0,0,1,0,0,9),(87,2,10035,1,0,0,1,0,0,11),(88,1,10037,1,0,0,1,0,0,9),(89,1,10037,1,0,0,1,0,0,9),(90,1,4,1,0,0,1,0,0,9),(91,2,4,1,0,0,1,0,0,11),(92,2,10037,1,0,0,1,0,0,11),(93,2,10037,1,0,0,1,0,0,11),(94,1,10038,1,0,0,1,0,0,9),(95,1,10038,1,0,0,1,0,0,9),(96,2,10038,1,0,0,1,0,0,11),(97,1,10038,1,0,0,1,0,0,9),(98,2,10038,1,0,0,1,0,0,11),(99,2,4,1,0,0,1,0,0,11),(100,1,10039,1,0,0,1,0,0,9),(101,1,10039,1,0,0,1,0,0,9),(102,1,10039,1,0,0,1,0,0,9),(103,2,10039,1,0,0,1,0,0,11),(104,2,10039,1,0,0,1,0,0,11),(105,2,4,1,0,0,1,0,0,11),(106,1,10040,1,0,0,1,0,0,9),(107,2,10040,1,0,0,1,0,0,11),(108,2,10040,1,0,0,1,0,0,11),(109,2,4,1,0,0,1,0,0,11),(110,1,10040,1,0,0,1,0,0,9),(111,1,10041,1,0,0,1,0,0,9),(112,1,10041,1,0,0,1,0,0,9),(113,2,10041,1,0,0,1,0,0,11),(114,2,4,1,0,0,1,0,0,11),(115,1,10041,1,0,0,1,0,0,9),(116,1,10043,1,0,0,1,0,0,0),(117,1,10043,1,0,0,1,0,0,0),(118,1,10043,1,0,0,1,0,0,13),(119,1,10044,1,0,0,1,0,0,13),(120,1,10044,1,0,0,1,0,0,13),(121,1,10044,1,0,0,1,0,0,13),(122,1,10044,1,0,0,1,0,0,13),(123,1,10,1,0,0,1,0,0,13),(124,3,1,1,0,0,1,0,0,0),(125,1,10046,1,0,0,1,0,0,13),(126,1,4,1,0,0,1,0,0,13),(127,1,4,1,0,0,0,1,0,0),(128,1,10047,1,0,0,1,0,0,13),(129,1,10047,1,0,0,1,0,0,13),(130,1,10047,1,0,0,1,0,0,13),(131,1,10047,1,0,0,1,0,0,13),(132,1,1,1,0,0,1,0,0,13),(133,1,1,1,0,0,1,0,0,13),(134,1,1,1,0,0,1,0,0,13),(135,1,10052,1,0,0,1,0,0,13),(136,1,10054,1,0,0,1,0,0,13),(137,1,1,1,0,0,1,0,0,0),(138,1,1,1,0,0,1,0,0,0);

--
-- Table structure for table `us_states`
--

CREATE TABLE `us_states` (
  `state_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'PK: State ID',
  `state_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'State name with first letter capital',
  `state_abbr` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Optional state abbreviation (US 2 cap letters)',
  PRIMARY KEY (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `us_states`
--

INSERT INTO `us_states` VALUES (1,'Alabama','AL'),(2,'Alaska','AK'),(3,'Arizona','AZ'),(4,'Arkansas','AR'),(5,'California','CA'),(6,'Colorado','CO'),(7,'Connecticut','CT'),(8,'Delaware','DE'),(9,'District of Columbia','DC'),(10,'Florida','FL'),(11,'Georgia','GA'),(12,'Hawaii','HI'),(13,'Idaho','ID'),(14,'Illinois','IL'),(15,'Indiana','IN'),(16,'Iowa','IA'),(17,'Kansas','KS'),(18,'Kentucky','KY'),(19,'Louisiana','LA'),(20,'Maine','ME'),(21,'Maryland','MD'),(22,'Massachusetts','MA'),(23,'Michigan','MI'),(24,'Minnesota','MN'),(25,'Mississippi','MS'),(26,'Missouri','MO'),(27,'Montana','MT'),(28,'Nebraska','NE'),(29,'Nevada','NV'),(30,'New Hampshire','NH'),(31,'New Jersey','NJ'),(32,'New Mexico','NM'),(33,'New York','NY'),(34,'North Carolina','NC'),(35,'North Dakota','ND'),(36,'Ohio','OH'),(37,'Oklahoma','OK'),(38,'Oregon','OR'),(39,'Pennsylvania','PA'),(40,'Rhode Island','RI'),(41,'South Carolina','SC'),(42,'South Dakota','SD'),(43,'Tennessee','TN'),(44,'Texas','TX'),(45,'Utah','UT'),(46,'Vermont','VT'),(47,'Virginia','VA'),(48,'Washington','WA'),(49,'West Virginia','WV'),(50,'Wisconsin','WI'),(51,'Wyoming','WY');

--
-- Table structure for table `user_connection`
--

CREATE TABLE `user_connection` (
  `user_connection_id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `user_code` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `is_blocked` int(11) NOT NULL DEFAULT '0',
  `blocked_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_connection_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_connection`
--

INSERT INTO `user_connection` VALUES (1,10004,10010,'LKVJ737Q',1,'0',1,10004),(2,10019,10010,'LKVJ737Q',1,'0',0,0);

--
-- Table structure for table `user_family`
--

CREATE TABLE `user_family` (
  `user_family_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `community_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `provider_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `sub_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `family_zip` int(11) DEFAULT NULL,
  `search_for` int(11) DEFAULT NULL,
  `relationship` int(11) DEFAULT NULL,
  `date_of_birth` varchar(255) DEFAULT NULL,
  `current_community` int(11) DEFAULT NULL,
  `distance_to` varchar(11) DEFAULT NULL,
  `user_code` varchar(255) DEFAULT NULL,
  `current_community_name` varchar(255) DEFAULT NULL,
  `prefix` varchar(255) DEFAULT NULL,
  `f_name` varchar(255) DEFAULT NULL,
  `l_name` varchar(255) DEFAULT NULL,
  `joined` varchar(255) DEFAULT NULL,
  `reason` text,
  `user_img` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `auto_accept` int(11) NOT NULL DEFAULT '0',
  `selected_alert_option` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `provider_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `day` varchar(11) DEFAULT NULL,
  `month` varchar(11) DEFAULT NULL,
  `year` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`user_family_id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_family`
--

INSERT INTO `user_family` VALUES (1,1,'[100,98,97]','[]','[]',34689,358,377,'2017-05-24',NULL,'123','AGC3BF7X',NULL,NULL,'user','one',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(2,10001,'[107,101,100,97]','[]','[]',34689,358,377,'1994-03-11',NULL,'124','0HXZN5EJ',NULL,NULL,'user','one',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(3,10004,'[97,98]','null','null',34689,358,0,'1987-05-24',1,'123','S6WCALRC','Alpha Community','null','Fam1','Fam1','null','null','null','null','null',0,'null','[{\"provider_type\":145,\"sub_type\":[215,214]},{\"provider_type\":148,\"sub_type\":[233,232]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(4,10005,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T7NW524R',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(5,10006,'[97,98,100]','[]','[]',34689,366,0,'1974-09-25',2,'122','5NRGKMQW','Beta Community','null','f3','f3','null','null','null','null','null',0,'[0,1]',NULL,NULL,NULL,NULL),(6,10008,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3YMXATPV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(7,10009,'[]','[141]','[166,167,168,170,203]',34689,358,377,'1931-09-12',1,'124','Z6OZWTHC','Alpha Community',NULL,'f5','f5',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(8,10010,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LKVJ737Q',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(9,10011,'[97,98]','[]','[]',34689,355,375,'2001-09-20',1,'121','482YQITD','Alpha Community',NULL,'s','s',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(10,10013,'[98,99,100]','[]','[]',34689,355,375,'1931-12-15',1,'122','4GUCQ21V','Alpha Community','null','w','w','null','null','null','null','null',0,'[0,2,1,3,4]','[{\"provider_type\":144,\"sub_type\":[204,205,206]},{\"provider_type\":147,\"sub_type\":[223,224]},[]]',NULL,NULL,NULL),(11,10015,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'OYG4GR1F',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(12,10016,'[]','[]','[]',34689,355,375,'1931-09-21',1,'121','5RGA5Q19','Alpha Community',NULL,'r','r',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":147,\"sub_type\":[222,223,224]},{\"provider_type\":153},{\"provider_type\":151,\"sub_type\":[246,245]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(13,10018,'[]','[]','[]',34689,356,373,'1933-09-01',1,'121','MOZ4XRAY','Alpha Community','null','u','u','null','null','null','null','null',0,'[0,2]','[{\"provider_type\":141,\"sub_type\":[166]},{\"provider_type\":148,\"sub_type\":[233,234]}]',NULL,NULL,NULL),(14,10019,'[97,98,99]','[]','[]',34689,355,375,'1959-09-14',1,'122','K7GEK83E','Alpha Community',NULL,'o','o',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":140,\"sub_type\":[163,165]},{\"provider_type\":145,\"sub_type\":[215,214]}]',NULL,NULL,NULL),(15,10020,'[]','[]','[]',34689,355,375,'1933-09-01',1,'122','EZA63VHT','Alpha Community',NULL,'y','y',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":145,\"sub_type\":[213,215]},{\"provider_type\":141,\"sub_type\":[166,167,169,170]}]',NULL,NULL,NULL),(16,10021,'[101,107,102]','null','null',34689,364,0,'24-03-2017',1,'123','PUHLRXAL','Alpha Community','null','rob','nom','null','null','null','null','null',0,'[0,1,2,3,8,9]','[{\"provider_type\":141,\"sub_type\":[167,168]},{\"provider_type\":145,\"sub_type\":[215,214]}]',NULL,NULL,NULL),(17,10022,'[97,98,99]','[]','[]',34689,358,377,'1955-09-21',1,'123','Y6BY6RF9','Alpha Community',NULL,'v','v',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(18,10024,'[98]','[]','[]',34689,359,377,'2222-02-22T05:00:00.000Z',NULL,'124','P2MGFKPC',NULL,NULL,'z','z',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":143,\"sub_type\":[174,175]},{\"provider_type\":145,\"sub_type\":[213,214]}]',NULL,NULL,NULL),(19,10025,'[98,99,101]','[]','[]',34689,358,377,'2020-10-07T04:00:00.000Z',1,'124','GCLJJ1G7','Alpha Community',NULL,'dd','dd',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[203,204,205]},{\"provider_type\":147,\"sub_type\":[221,223,224]},{\"provider_type\":153,\"sub_type\":[252,253,255]}]',NULL,NULL,NULL),(20,10026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O280R00Q',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(21,10027,'[]','[]','[]',34689,358,377,'',1,'124','OYCJ0ZER','Alpha Community',NULL,'bb','bb',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,205,206,207]},{\"provider_type\":147,\"sub_type\":[226]}]',NULL,NULL,NULL),(22,10028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DZBUPYG9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(23,10029,'[98,100,101]','[]','[]',34689,358,377,'1941-10-14T05:00:00.000Z',1,'124','RNG6PQ0G','Alpha Community',NULL,'hh','hh',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,205]},{\"provider_type\":147,\"sub_type\":[222,223,225]}]',NULL,NULL,NULL),(24,10030,'[98,99,100]','[]','[]',34689,358,377,'1902-01-30T05:00:00.000Z',1,'124','ZGY5SHQB','Alpha Community',NULL,'jj','jj',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,205,206]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(25,10031,'[98,99,100,101]','[]','[]',34689,358,377,'2020-10-02T04:00:00.000Z',1,'123','ED9HDMSC','Alpha Community',NULL,'kk','kk',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":145,\"sub_type\":[215,214]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(26,10032,'[98,99,100]','[]','[]',34689,355,375,'2020-10-16T04:00:00.000Z',1,'122','L0X90WR0','Alpha Community',NULL,'ll','ll',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,205]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(27,10033,'[98,99,100]','[]','[]',34689,355,375,'2020-10-23T04:00:00.000Z',1,'124','H3BCPOJK','Alpha Community',NULL,'zz','zz',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":141,\"sub_type\":[169,168,167]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(28,10034,'[97,98,99]','[]','[]',34689,355,375,'',1,'123','YJFBLNC2','Alpha Community',NULL,'ll','ll',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,205]},{\"provider_type\":\"\",\"sub_type\":\"\"}]',NULL,NULL,NULL),(29,10035,'[98,99,101,107]','[]','[]',34689,355,375,'',1,'123','VNIG7G1N','Alpha Community','null','mm','mm','null','null','null','null','null',0,'[0]','[{\"provider_type\":141,\"sub_type\":[167,168]},{\"provider_type\":147,\"sub_type\":[225,228,227]},{\"provider_type\":144,\"sub_type\":[203,204,205]}]','31','11','1'),(30,10037,'[99,100,101]','[]','[]',34689,355,375,'',1,'124','FEZR1IYM','Alpha Community',NULL,'f10','f10',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":145,\"sub_type\":[214,215]},{\"provider_type\":\"\",\"sub_type\":\"\"}]','14','10','10'),(31,10038,'[98,99,100]','[]','[]',34689,355,375,'',1,'118','O06VSTUB','Alpha Community',NULL,'c15','c15',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":142,\"sub_type\":[172,171]},{\"provider_type\":\"\",\"sub_type\":\"\"}]','4','10','5'),(32,10039,'[98,99,100]','[]','[]',34689,355,375,'',1,'118','3P1BOPYG','Alpha Community',NULL,'c16','c16',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":143,\"sub_type\":[174,175]},{\"provider_type\":\"\",\"sub_type\":\"\"}]','6','9','78'),(33,10040,'[98,99,100]','[]','[]',34689,355,375,'',1,'118','ZXSM6ONU','Alpha Community',NULL,'sdf','fdsbggbsd',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,205,206]},{\"provider_type\":\"\",\"sub_type\":\"\"}]','7','9','1'),(34,10041,'[98,100,101]','[]','[]',34689,355,375,'',1,'118','IN7COB0A','Alpha Community',NULL,'ffff','fffff',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":144,\"sub_type\":[204,206]},{\"provider_type\":146,\"sub_type\":[216,217,218]},{\"provider_type\":\"\",\"sub_type\":\"\"}]','3','8','69'),(35,10042,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'H2QNLJMV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(36,10043,'[98,100,101]','[]','[]',34689,355,375,'',1,'123','9M0E2Z7I','Alpha Community','null','rt','rt','null','null','null','null','null',0,'[0,1,2,3,4,5,6,7,8,9,10]','[{\"provider_type\":146,\"sub_type\":[217,218,219]},{\"provider_type\":148,\"sub_type\":[233,232]}]','5','10','15'),(37,10044,'[98]','[]','[]',34689,355,375,'',0,'124','6QTARHO2','',NULL,'qw','qw',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','',''),(38,10046,'[98,99,100]','[]','[]',34689,355,375,'',1,'123','M868SZC1','Alpha Community',NULL,'d','d',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'6','10','16'),(39,10047,'[98,101,107]','[]','[]',34689,355,375,'',0,'123','216STZC0','',NULL,'Fam14','Fam14',NULL,NULL,NULL,NULL,NULL,0,NULL,'[{\"provider_type\":141,\"sub_type\":[166,168,169]},{\"provider_type\":145,\"sub_type\":[213,214]},{\"provider_type\":149,\"sub_type\":[236,237]}]','14','8','1'),(40,10052,'[98]','[]','[]',34689,355,375,'',1,'121','M2K5IC5T','Alpha Community',NULL,'fffffff','fghsdtf',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'11','4','14'),(41,10054,'[98,99,101]','[]','[]',34689,355,375,'',1,'123','TIPQLWYG','Alpha Community',NULL,'zzzzz','zzzzz',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'5','9','18');

--
-- Table structure for table `user_payment_profile`
--

CREATE TABLE `user_payment_profile` (
  `user_payment_profile` int(11) NOT NULL AUTO_INCREMENT,
  `community_provider_id` int(11) NOT NULL,
  `profile_id` int(11) NOT NULL,
  `payment_profile_id` int(11) NOT NULL,
  `address_id` int(11) NOT NULL DEFAULT '0',
  `monthly_payment` tinyint(1) NOT NULL DEFAULT '0',
  `anual_payment` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_payment_profile`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_payment_profile`
--

INSERT INTO `user_payment_profile` VALUES (1,3,1515875350,1513779649,1512890953,0,1),(2,4,1516291859,1514365640,500062897,0,1);

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `user_role_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `community_provider_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `root_id` int(11) DEFAULT NULL,
  `incentive_id` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `permission_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` VALUES (1,10002,1,NULL,NULL,NULL,NULL,NULL,NULL),(2,10002,2,NULL,NULL,NULL,NULL,NULL,NULL),(3,10003,3,NULL,NULL,NULL,NULL,NULL,NULL),(4,10003,4,NULL,NULL,NULL,NULL,NULL,NULL),(5,10007,5,NULL,NULL,NULL,NULL,NULL,NULL),(6,10014,6,NULL,NULL,NULL,NULL,NULL,NULL),(7,10023,7,NULL,NULL,NULL,NULL,NULL,NULL),(8,10036,8,NULL,NULL,NULL,NULL,NULL,NULL),(9,10002,9,NULL,NULL,NULL,NULL,NULL,NULL),(10,10045,10,NULL,NULL,NULL,NULL,NULL,NULL),(11,10048,11,NULL,NULL,NULL,NULL,NULL,NULL),(12,10050,12,NULL,NULL,NULL,NULL,NULL,NULL),(13,10053,13,NULL,NULL,NULL,NULL,NULL,NULL),(14,10055,14,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `volunteer_availability`
--

CREATE TABLE `volunteer_availability` (
  `volunteer_availability_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `time_availability` varchar(255) DEFAULT NULL,
  `days_availability` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `volunteer_to` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `distance_to` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` int(11) NOT NULL DEFAULT '0',
  `county` varchar(255) DEFAULT NULL,
  `contact_me` int(11) DEFAULT '0',
  `days_duration` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`volunteer_availability_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `volunteer_availability`
--


--
-- Table structure for table `volunteer_request`
--

CREATE TABLE `volunteer_request` (
  `volunteer_request_id` int(11) NOT NULL AUTO_INCREMENT,
  `volunteer_user_id` int(11) NOT NULL DEFAULT '0',
  `community_id` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`volunteer_request_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `volunteer_request`
--


--
-- Table structure for table `we_accept_detail`
--

CREATE TABLE `we_accept_detail` (
  `accept_id` int(11) NOT NULL AUTO_INCREMENT,
  `parameter` varchar(256) NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `community_provider_id` int(11) NOT NULL,
  PRIMARY KEY (`accept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `we_accept_detail`
--


--
-- Table structure for table `years`
--

CREATE TABLE `years` (
  `year_id` int(11) NOT NULL AUTO_INCREMENT,
  `value` int(11) NOT NULL,
  PRIMARY KEY (`year_id`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `years`
--

INSERT INTO `years` VALUES (1,1910),(2,1911),(3,1912),(4,1913),(5,1914),(6,1915),(7,1916),(8,1917),(9,1918),(10,1919),(11,1920),(12,1921),(13,1922),(14,1923),(15,1924),(16,1925),(17,1926),(18,1927),(19,1928),(20,1929),(21,1930),(22,1931),(23,1932),(24,1933),(25,1934),(26,1935),(27,1936),(28,1937),(29,1938),(30,1939),(31,1940),(32,1941),(33,1942),(34,1943),(35,1944),(36,1945),(37,1946),(38,1947),(39,1948),(40,1949),(41,1950),(42,1951),(43,1952),(44,1953),(45,1954),(46,1955),(47,1956),(48,1957),(49,1958),(50,1959),(51,1960),(52,1961),(53,1962),(54,1963),(55,1964),(56,1965),(57,1966),(58,1967),(59,1968),(60,1969),(61,1970),(62,1971),(63,1972),(64,1973),(65,1974),(66,1975),(67,1976),(68,1977),(69,1978),(70,1979),(71,1980),(72,1981),(73,1982),(74,1983),(75,1984),(76,1985),(77,1986),(78,1987),(79,1988),(80,1989),(81,1990),(82,1991),(83,1992),(84,1993),(85,1994),(86,1995),(87,1996),(88,1997),(89,1998),(90,1999),(91,2000),(92,2001),(93,2002),(94,2003),(95,2004),(96,2005),(97,2006),(98,2007),(99,2008),(100,2009),(101,2010),(102,2011),(103,2012),(104,2013),(105,2014),(106,2015),(107,2016),(108,2017),(109,2018),(110,2019);


