commit;

--
-- Table structure for table `wd_partner_application_data`
--

CREATE TABLE `wd_partner_application_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `irs_501c3_letterofdetermination_file` int(11) DEFAULT NULL,
  `irs_501c3_articlesofincorporation_file` int(11) DEFAULT NULL,
  `irs_non501c3_certificateofincorporation_file` int(11) DEFAULT NULL,
  `irs_non501c3_governmentcertification_file` int(11) DEFAULT NULL,
  `finances_990_990ez` varchar(5) DEFAULT NULL,
  `finances_990_990ez_file` int(11) DEFAULT NULL,
  `finances_990n` varchar(5) DEFAULT NULL,
  `finances_990n_file` int(11) DEFAULT NULL,
  `finances_audited_statements` varchar(5) DEFAULT NULL,
  `finances_audited_statements_file` varchar(255) DEFAULT NULL,
  `finances_audited_statements_pending` varchar(5) DEFAULT NULL,
  `finances_audited_statements_pending_file` varchar(255) DEFAULT NULL,
  `finances_projected_budget_file` varchar(255) DEFAULT NULL,
  `finances_annual_operating_budget` varchar(50) DEFAULT NULL,
  `finances_project_budget_file` int(11) DEFAULT NULL,
  `finances_primary_funding_sources` varchar(255) DEFAULT NULL,
  `finances_primary_finding_sources_other` varchar(200) DEFAULT NULL,
  `largest_funders_1` varchar(200) DEFAULT NULL,
  `largest_funders_2` varchar(200) DEFAULT NULL,
  `largest_funders_3` varchar(200) DEFAULT NULL,
  `largest_funders_4` varchar(200) DEFAULT NULL,
  `largest_funders_5` varchar(200) DEFAULT NULL,
  `finances_financial_institution_accounts_file` int(11) DEFAULT NULL,
  `account_name` varchar(200) DEFAULT NULL,
  `account_type` varchar(200) DEFAULT NULL,
  `account_number` varchar(200) DEFAULT NULL,
  `bank_name` varchar(200) DEFAULT NULL,
  `routing_number` varchar(200) DEFAULT NULL,
  `account_country` varchar(10) DEFAULT NULL,
  `account_currency` varchar(10) DEFAULT NULL,
  `bank_address_1` varchar(200) DEFAULT NULL,
  `bank_address_2` varchar(200) DEFAULT NULL,
  `bank_city` varchar(200) DEFAULT NULL,
  `bank_state` varchar(200) DEFAULT NULL,
  `bank_country` varchar(10) DEFAULT NULL,
  `bank_postal_code` varchar(10) DEFAULT NULL,
  `bank_swift_code` varchar(50) DEFAULT NULL,
  `additional_routing_code` varchar(50) DEFAULT NULL,
  `ach_code` varchar(255) DEFAULT NULL,
  `intermediary_bank_name` varchar(200) DEFAULT NULL,
  `intermediary_routing_number` varchar(200) DEFAULT NULL,
  `intermediary_account_name` varchar(200) DEFAULT NULL,
  `intermediary_account_number` varchar(200) DEFAULT NULL,
  `primary_contact_firstname` varchar(200) DEFAULT NULL,
  `primary_contact_middlename` varchar(200) DEFAULT NULL,
  `primary_contact_lastname` varchar(200) DEFAULT NULL,
  `primary_contact_email` varchar(200) DEFAULT NULL,
  `primary_contact_phone` varchar(200) DEFAULT NULL,
  `primary_contact_address_1` varchar(200) DEFAULT NULL,
  `primary_contact_address_2` varchar(200) DEFAULT NULL,
  `primary_contact_city` varchar(200) DEFAULT NULL,
  `primary_contact_state` varchar(200) DEFAULT NULL,
  `primary_contact_country` varchar(200) DEFAULT NULL,
  `primary_contact_postal_code` varchar(200) DEFAULT NULL,
  `secondary_contact_firstname` varchar(200) DEFAULT NULL,
  `secondary_contact_middlename` varchar(200) DEFAULT NULL,
  `secondary_contact_lastname` varchar(200) DEFAULT NULL,
  `secondary_contact_email` varchar(200) DEFAULT NULL,
  `secondary_contact_phone` varchar(200) DEFAULT NULL,
  `secondary_contact_address_1` varchar(200) DEFAULT NULL,
  `secondary_contact_address_2` varchar(200) DEFAULT NULL,
  `secondary_contact_city` varchar(200) DEFAULT NULL,
  `secondary_contact_state` varchar(200) DEFAULT NULL,
  `secondary_contact_country` varchar(200) DEFAULT NULL,
  `secondary_contact_postal_code` varchar(200) DEFAULT NULL,
  `partner_logo` int(11) DEFAULT NULL,
  `partner_profile_banner_image_video_choice` tinyint(1) DEFAULT NULL,
  `partner_profile_image_banner` int(11) DEFAULT NULL,
  `partner_profile_video_banner` varchar(255) DEFAULT NULL,
  `partner_description` longtext,
  `board_members` text,
  `board_member_file` int(11) DEFAULT NULL,
  `annual_reports_file` int(11) DEFAULT NULL,
  `brochures_file` int(11) DEFAULT NULL,
  `program_descriptions_file` int(11) DEFAULT NULL,
  `media_reports_file` int(11) DEFAULT NULL,
  `article_incorporation_file` int(11) DEFAULT NULL,
  `charter_file` int(11) DEFAULT NULL,
  `bylaws_file` int(11) DEFAULT NULL,
  `reference_letter_file` int(11) DEFAULT NULL,
  `tc_organization_name` varchar(200) DEFAULT NULL,
  `tc_signature` varchar(200) DEFAULT NULL,
  `tc_title` varchar(200) DEFAULT NULL,
  `tc_date` varchar(10) DEFAULT NULL,
  `nd_organization_name` varchar(200) DEFAULT NULL,
  `nd_signature` varchar(200) DEFAULT NULL,
  `nd_title` varchar(200) DEFAULT NULL,
  `nd_date` varchar(10) DEFAULT NULL,
  `at_organization_name` varchar(200) DEFAULT NULL,
  `at_signature` varchar(200) DEFAULT NULL,
  `at_title` varchar(200) DEFAULT NULL,
  `at_date` varchar(10) DEFAULT NULL,
  `affidavit_file` int(11) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `current_step` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=269 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wd_partner_application_data`
--

set autocommit=0;
INSERT INTO `wd_partner_application_data` VALUES (83,20,34,NULL,NULL,NULL,'yes',NULL,NULL,NULL,'no',NULL,'no',NULL,NULL,'95000',NULL,'Government',NULL,'hy5eth','ewagewagwe','wegwe',NULL,NULL,NULL,'waegawgwegawe','checking','wgwe23423w23','fsgdsrgr','sergegrsrgeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Partner',NULL,'Applicant','patest4@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'a:1:{i:0;a:2:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";}}',NULL,NULL,35,NULL,NULL,NULL,NULL,NULL,NULL,'Make Ten Wishes','Brian L Walker','Mr','4,11,2012','Make Ten Wishes','Brian L Walker','Mr','4,11,2012','Make Ten Wishes','Brian L Walker','Mr','4,11,2012',NULL,'2012-04-11 16:52:43',NULL),(98,36,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'patest10@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'patest8@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-04-19 21:59:01',NULL),(99,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phil',NULL,'G','philg@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-04-30 17:05:17',NULL),(100,47,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rshrthhr3545432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA 22',NULL,'Tester','mforr@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-04-30 19:37:18',NULL),(104,21,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rshrthhr3545432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA 22',NULL,'Tester','mforr@mindgrub.com','7178778075',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-04-30 19:39:30',NULL),(105,48,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rshrthhr3545432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA 22',NULL,'Tester','blahblahblah@mindgrub.com','7178778075',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-04-30 19:54:13',NULL),(110,51,NULL,NULL,65,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Brian',NULL,'Walker','patest30@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5,7,2012',NULL,NULL,NULL,'5,7,2012',NULL,NULL,NULL,'5,7,2012',NULL,'2012-05-07 17:33:08',NULL),(111,33,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA',NULL,'Tester 7','patestSEVEN@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'patestSEVEN@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-05-07 19:55:22',NULL),(119,38,NULL,NULL,66,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2500000',NULL,'Foundations',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bravo',NULL,'Tester','BravoTester@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5,30,2012',NULL,NULL,NULL,'5,30,2012',NULL,NULL,NULL,'5,30,2012',NULL,'2012-05-30 19:28:51','.subform2'),(124,78,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'987654321123456789',NULL,'12345678987654321',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8675309',NULL,NULL,NULL,NULL,'Steve',NULL,'Guttenberg','ckidd@mindgrub.com','911',NULL,NULL,NULL,NULL,NULL,NULL,'That Guy',NULL,'Who Does Those Sound Effects','thatguy@policeacademy.com','911',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-06-18 19:01:38',NULL),(148,54,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BradTest',NULL,'Tibbils','brad@gmail.com','410 555 1212',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7,2,2012',NULL,NULL,NULL,'7,2,2012','qwre','qwer','4g4','7,2,2012',NULL,'2012-07-02 19:36:47','.subform10'),(153,87,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Matthew',NULL,'Forr','mforr+june29@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,179,1,180,'http://youtu.be/C-R8PmaIy-w','Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam id dolor id nibh ultricies vehicula ut id elit. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec id elit non mi porta gravida at eget metus. Donec ullamcorper nulla non metus auctor fringilla.\r\n\r\nFusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Donec ullamcorper nulla non metus auctor fringilla. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum.\r\n\r\nVestibulum id ligula porta felis euismod semper. Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Vestibulum id ligula porta felis euismod semper. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec id elit non mi porta gravida at eget metus.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-07-05 15:36:03',NULL),(159,22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'wdadmin@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-07-20 19:34:28',NULL),(175,119,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Lex',NULL,'Luthor','wd.mindgrub+partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'Formerly known as \"Luthor Industries,\" LuthorCorp was founded by prominant entrepreneur Lionel Luthor. After going public in the early 1970\'s, LuthorCorp expanded upon its agribusiness model, expanding operations beyond Edge City and Metropolis to nearby Smallville. LuthorCorp provided employment for over 5,000 regional residents. \r\n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-07-23 16:46:21',NULL),(176,134,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bruce ',NULL,'Wayne','wd.mindgrub+partner1@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'Wayne Enterprises was officially erected in the 19th century and thus is one of the oldest companies in the world. Although, it was founded by Bruce\'s ancestors as a merchant house in the 17th century, the company changed when the heir of Judge Solomon Wayne, Alan, utilized his father\'s wealth and erected the Wayne Shipping company and also the Wayne Chemical company into the city. Thus it was officially erected in the 19th century. Along the years, it has evolved from a merchant house to a large multinational conglomerate company that can go up against its bigger competitor LexCorp. Education',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-07-25 18:23:44',NULL),(186,158,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'James',NULL,'Jameson','wcooper+JJameson@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,'a:1:{i:0;a:2:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";}}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8,3,2012','EquALL',NULL,NULL,'8,3,2012','EquALL',NULL,NULL,'8,3,2012',NULL,'2012-08-03 18:15:48','.subform7'),(187,136,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Anthony',NULL,'Stark','junglesbee+ironman@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'We work to expand the community of partners dedicated to bettering the lives of girls and women. Our corporate forum brings together private sector representatives to collaborate on projects and solutions. We work with ministries of finance and health and global development experts to make the economic case for investing in girls and women. And, we look to the future by developing the skills of young advocates in developing countries through our workshops and online community. We as a company believe in the need for women\'s education.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-08-06 20:17:57',NULL),(189,92,NULL,NULL,450,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pat',NULL,'astrophe','pstaso@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8,17,2012',NULL,NULL,NULL,'8,17,2012',NULL,NULL,NULL,'8,17,2012',NULL,'2012-08-17 22:14:00',NULL),(191,216,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yes',NULL,NULL,NULL,NULL,NULL,NULL,'No funding,,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA',NULL,'Tester 8','bwalker9-@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,3,2012',NULL,NULL,NULL,'9,3,2012',NULL,NULL,NULL,'9,3,2012',NULL,'2012-09-04 00:41:41','.subform3'),(192,34,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yes',NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA',NULL,'Tester 8','bwalker9-@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,3,2012',NULL,NULL,NULL,'9,3,2012',NULL,NULL,NULL,'9,3,2012',NULL,'2012-09-04 00:54:17','.subform3'),(202,221,512,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jasmine',NULL,'Phillips','Jmerritt+JasminePhillips23@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,'a:1:{i:0;a:2:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";}}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,4,2012',NULL,NULL,NULL,'9,4,2012',NULL,NULL,NULL,'9,4,2012',NULL,'2012-09-04 21:24:26','.subform2'),(217,220,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'000000000',NULL,'000000000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jane',NULL,'Doe','jmerritt+JanePartner@mindgrub.com','4444444444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,631,1,NULL,'http://youtu.be/WEc2IT_D74E','Tzeporah Berman has played an instrumental role in designing environmental procurement policies for some of the largest corporations in the world as well as creating industry and environmental collaborations to protect forests and change forests practices. She is the former Executive Director and Co-founder of PowerUp Canada and Co-founder and Campaign Director of ForestEthics. Last year she was appointed by the Premier of British Columbia, Canada, to the Green Energy Task Force to design recommendations for the development of renewable energy in the region.\r\n\r\nBerman was one of the experts in Leonardo Di Caprio\'s environmental documentary 11th Hour, was one of six Canadian nominees for the Schwab Social Entrepreneur of the Year Award, has been profiled as \"50 Visionaries Changing the World\" ....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-14 21:35:07',NULL),(218,203,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jasmine',NULL,'Phillips','Jmerritt+JasminePhillips2@mindgrub.com','(410) 555-1234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,630,0,529,NULL,'Jasmine started the Jasmine Phillips organization to help many people around the world...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-14 21:36:24',NULL),(227,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Maya Grace2',NULL,'Tester','mforr+demo_july11@mindgrub.com','55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,689,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-20 19:56:01',NULL),(232,238,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'wcooper@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-21 15:47:53',NULL),(237,39,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4837647899874562',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Charlie',NULL,'Tester','Jmerritt+Teammember3@mindgrub.com','555-555-1234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,705,1,NULL,'http://youtu.be/lCusDqc_S7o',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-21 18:50:33',NULL),(238,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'womendeliver@mindgrub.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'This is the default Catapult Partner page',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-21 19:05:02',NULL),(241,81,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Laura Grace',NULL,'Carmona','lgcarmona@gmail.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'secondary',NULL,'secname','lgcarmona@gmail.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,22,2012',NULL,NULL,NULL,'9,22,2012',NULL,NULL,NULL,'9,22,2012',NULL,'2012-09-22 22:51:02',NULL),(242,236,NULL,NULL,660,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Test',NULL,'Parter917b','wcooper+TP917b@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,18,2012',NULL,NULL,NULL,'9,18,2012',NULL,NULL,NULL,'9,18,2012',NULL,'2012-09-24 13:30:06','.subform2'),(243,182,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Martha',NULL,'Garrett','wcooper+augpartner@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,24,2012',NULL,NULL,NULL,'9,24,2012',NULL,NULL,NULL,'9,24,2012',NULL,'2012-09-24 13:31:18','.subform2'),(244,230,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Joe',NULL,'Test','bwalker@mindgrub.com','443-555-1234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-25 00:31:10',NULL),(246,245,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suzy',NULL,'Newpartner','gcarmona+newpartner@mindgrub.com','5555551212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-25 13:31:25',NULL),(247,246,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Admin-created',NULL,'Person','gcarmona+queen@mindgrub.com','5555551212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-25 13:32:09',NULL),(251,97,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Matthew',NULL,'Forr','Junglesbee+DONORTESTING@mindgrub.com','1234567890',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-25 13:45:23',NULL),(258,251,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Will',NULL,'Tester','wcooper+WT925@mindgrub.com','2121212121',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,744,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-09-25 20:46:49',NULL),(259,253,NULL,NULL,745,746,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Will',NULL,'Partner','wcooper+WP926@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,26,2012',NULL,NULL,NULL,'9,26,2012',NULL,NULL,NULL,'9,26,2012',NULL,'2012-09-26 13:56:40','.subform2'),(262,235,748,749,NULL,NULL,'no',NULL,'yes',757,'no',NULL,'yes','758','759','1000000000',NULL,'Foundations,Government,Grants,Corporate giving,Individual giving,Membership fees,Services/small-enterprise,No funding,',NULL,'ONE','TWO','THREE','FOUR','FIVE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Test',NULL,'Parter917','wcooper+TP917@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,'a:1:{i:0;a:2:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";}}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,750,NULL,NULL,NULL,NULL,'9,26,2012',NULL,NULL,NULL,'9,26,2012',NULL,NULL,NULL,'9,26,2012',NULL,'2012-09-26 21:02:22','.subform3'),(264,271,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,',,,,,,,,',NULL,'wcooper+TP926z@mindgrub.comwcooper+TP926z@mindgrub.comwcooper+TP926z@mindgrub.comwcooper+TP926z@mindgrub.comwcooper+TP92',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Test',NULL,'Partner926z','wcooper+TP926z@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,26,2012',NULL,NULL,NULL,'9,26,2012',NULL,NULL,NULL,'9,26,2012',NULL,'2012-09-26 22:33:24','.subform3'),(265,274,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,',,,,,,,,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'New',NULL,'Applicant','bthompson+partner1@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,'a:1:{i:0;a:2:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";}}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,27,2012',NULL,NULL,NULL,'9,27,2012',NULL,NULL,NULL,'9,27,2012',NULL,'2012-09-27 15:47:37','.subform3'),(267,241,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'no','770','yes','',NULL,'100',NULL,'Individual giving,,,,,,,,',NULL,'Bob','Sally','Jim','Tom','Ekans',774,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Test',NULL,'Partner','wcooper+TP920@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,27,2012',NULL,NULL,NULL,'9,27,2012',NULL,NULL,NULL,'9,27,2012',NULL,'2012-09-27 16:39:38','.subform3'),(268,242,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'no',NULL,'no',NULL,'793,794','1000',NULL,'Individual giving,,,,,,,,',NULL,'One','Two','Three','Four','Five',795,NULL,NULL,NULL,NULL,NULL,'AF','AED',NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Will',NULL,'Partner','wcooper+WP920@mindgrub.com',NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9,27,2012',NULL,NULL,NULL,'9,27,2012',NULL,NULL,NULL,'9,27,2012',NULL,'2012-09-28 03:53:47','.subform3');
commit;

--
-- Table structure for table `wd_screener_data`
--

CREATE TABLE `wd_screener_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `referral` varchar(50) DEFAULT NULL,
  `other_referral` varchar(50) DEFAULT NULL,
  `organization_name` varchar(512) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `address_1` varchar(100) DEFAULT NULL,
  `address_2` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `postal_code` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `mission` text,
  `issue_areas` varchar(255) DEFAULT NULL,
  `organization_work` varchar(255) DEFAULT NULL,
  `organization_location` varchar(255) DEFAULT NULL,
  `organization_location_region` varchar(255) DEFAULT NULL,
  `registered_nonprofit` varchar(10) DEFAULT NULL,
  `registered_nonprofit_location` varchar(10) DEFAULT NULL,
  `recognized_501c3` varchar(10) DEFAULT NULL,
  `registered_nonprofit_ein` varchar(15) DEFAULT NULL,
  `certified_by_org` varchar(50) DEFAULT NULL,
  `year_founded` int(8) DEFAULT NULL,
  `number_fulltime_staff` int(11) DEFAULT NULL,
  `number_parttime_staff` int(11) DEFAULT NULL,
  `number_volunteer_staff` int(11) DEFAULT NULL,
  `operating_budget` varchar(25) DEFAULT NULL,
  `us_dollars` varchar(10) DEFAULT NULL,
  `fiscally_sponsored` varchar(10) DEFAULT NULL,
  `fiscal_sponsor` varchar(50) DEFAULT NULL,
  `fiscal_sponsor_address_1` varchar(100) DEFAULT NULL,
  `fiscal_sponsor_address_2` varchar(100) DEFAULT NULL,
  `fiscal_sponsor_city` varchar(50) DEFAULT NULL,
  `fiscal_sponsor_state` varchar(50) DEFAULT NULL,
  `fiscal_sponsor_country` varchar(50) DEFAULT NULL,
  `fiscal_sponsor_postal_code` varchar(50) DEFAULT NULL,
  `all_faiths` varchar(10) DEFAULT NULL,
  `learn_specific_faith` varchar(10) DEFAULT NULL,
  `convert_specific_faith` varchar(10) DEFAULT NULL,
  `internet_access` varchar(255) DEFAULT NULL,
  `social_media` varchar(50) DEFAULT NULL,
  `social_media_sites` varchar(255) DEFAULT NULL,
  `other_social_media` varchar(50) DEFAULT NULL,
  `org_blog` varchar(10) DEFAULT NULL,
  `org_blog_url` varchar(100) DEFAULT NULL,
  `org_photo` varchar(100) DEFAULT NULL,
  `org_video` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wd_screener_data`
--

set autocommit=0;
INSERT INTO `wd_screener_data` VALUES (8,17,'2012-04-02 18:00:20','Wild','Hicock','Dr','wbhicock@mindgrub.com',NULL,'Saw a commercial',NULL,'Whitefish','whiteflish.com','123 Testfish Lane','Unit F','San Antonio','TX','19801','US','World peace and good will towards men...\r\nWorld peace and good will towards men...\r\nWorld peace and good will towards men...\r\nWorld peace and good will towards men...','Maternal Health','Training','FJ,GU',NULL,'yes','AQ',NULL,NULL,'Charity Navigator',1920,455,26,8,'Greater than $1 million','yes','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yes','yes','no','We have our own Internet connection, but it is slow (compuiter with modem)','yes','Twitter,YouTube',NULL,'no','bluefish.org/blog','No','Yes, we have access to a video recorder'),(17,21,'2012-04-09 22:05:11','PA 22','Tester','Mr','patest5@mindgrub.com',NULL,'Saw a commercial',NULL,'Southland','PATeest.com','PATeest office 1','Apt. 2','Galviston','CA','55668','US','PATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeestPATeest','Child Brides','Advocacy','CA,GL,MX',NULL,'yes','AD',NULL,NULL,'Charity Navigator',1880,200,122,5,'$10,000 - $50,000','no','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yes','no','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','YouTube',NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a video recorder'),(19,20,'2012-04-11 16:48:19','Partner','Applicant','Mr','patest4@mindgrub.com',NULL,'Read about it in an article',NULL,'Make Ten Wishes','www.maketenwishes.com','Homer Ave.',NULL,'San Diego','CA','21215','US','Donuts AAAHHHH!\r\nDonuts AAAHHHH!\r\nDonuts AAAHHHH!\r\nDonuts AAAHHHH!\r\n','Maternal Health','Training','GL',NULL,'yes','US',NULL,'12-3456789','Guidestars',1958,24,6,9,'$10,000 - $50,000','yes','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Facebook',NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a video recorder'),(20,19,'2012-04-11 17:42:04','Partner','Applicant','3','patest3@mindgrub.com',NULL,'Read about it in an article',NULL,'Make a Wish',NULL,'Homer Ave.',NULL,'San Diego','TX','22556','AG','Live free or die hard...','Child Brides','Advocacy','GL',NULL,'no',NULL,NULL,NULL,'Charity Navigator',1955,455,NULL,NULL,'$10,000 - $50,000','no','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'no','no','no','We don\'t have our own Internet connection and can\'t usually access the Internet','no',NULL,NULL,'no',NULL,NULL,NULL),(35,28,'2012-04-13 17:49:44','Brian','Walker',NULL,'bwalker@mindgrub5.com',NULL,'Found it online',NULL,'Make Ten Wishes4',NULL,'123 Wishing Dr.',NULL,'Boulder','TX','22556','BH','fzdbfsdbdfbfdbd','Child Brides','Advocacy','GL',NULL,'no',NULL,NULL,NULL,NULL,1825,455,NULL,NULL,'Greater than $1 million','no','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'no','no','no','We don\'t have our own Internet connection but can access the internet at Internet cafes','no',NULL,NULL,'no',NULL,NULL,NULL),(39,29,'2012-04-13 18:06:29','Brian7','Walker7','Mr','bwalker@mindgrub6.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,'$10,000 - $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(40,27,'2012-04-13 18:09:06','Brian','Walker','Mr','bwalker-9@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,'$10,000 - $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(47,33,'2012-04-18 21:44:24','PA','Tester 7','Mr','patest7@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,'$10,000 - $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(49,35,'2012-04-18 21:46:33','PA','Tester 9','Mr','patest9@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,'$10,000 - $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(50,36,'2012-04-18 21:47:01','PA','Tester 10','Mr','patest10@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,'$10,000 - $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(52,18,'2012-04-26 22:45:13','Phil','G','Mr','philg@philgs.com',NULL,'Someone I know',NULL,'PhilG\'s Org','philg.com','Phils office 1','Phils office 2','Boulder','CA','55668','US','To stop evil doers around the world... death to the rabbits..','Training','Advocacy,Service Directory','CA,GL,MX',NULL,'yes','US',NULL,'42-2334242','Charity Navigator',1825,200,5,9,'$10,000 - $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','US','21111','no','yes','yes','We don\'t have our own Internet connection but can access the internet at Internet cafes','yes','Orkut',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a phone with the ability to record'),(54,51,'2012-05-04 21:23:14','Brian','Walker','Mr','patest30@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,NULL,'no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection and can\'t usually access the Internet','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(57,34,'2012-05-17 21:28:11','PA','Tester 8','Mr','bwalker9-@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','US',NULL,'12-3456789','Charity Navigator',1829,2300,122,9,'Less than $10,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We have our own Internet connection, but it is slow (computer with modem)','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(58,59,'2012-05-18 16:29:29','Brian','Walker','Mr','patest54@mindgrub.com',NULL,'Saw a commercial',NULL,'Make a Wish','http://makeawish.com','123 Wishing Dr.','Apt. 2','Galviston','TX','22556','US','Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... Wishful thinking... ','Maternal Health','Advocacy','BT,IO',NULL,'yes','DZ',NULL,NULL,'Charity Navigator',1829,2300,122,9,'$10,000 to $50,000','no','yes','My fiscal sponsor','456 Northland Ave.','Suite 100','Memphis','TE','AX',NULL,'no','yes','yes','We don\'t have our own Internet connection and can\'t usually access the Internet','yes','Twitter,YouTube',NULL,'yes','makeawish.com/blog','Yes, we have access to a digital camera','No'),(59,60,'2012-05-18 16:36:42','Lorenzo','Tester','Mr.','LorenzoTester@mindgrub.com',NULL,'Someone I know',NULL,'Lorenzo Tester, Inc.','LorenzoTester.com','123 Main Street',NULL,'Washington ','District of Columbia','20008','US','Lorenzo Tester, Inc. is dedicated to helping all people of every nation--everyday and in everyway it can.','Health Workers,Food and Water,Trafficking and Prostitution,Leadership,Training,Innovation,Transportation','Advocacy','US','North America','yes','US',NULL,'12-3456789',NULL,2000,5,3,2,'Less than $10,000','yes','yes','Fiscal Sponsor','456 Main Street',NULL,'New York','New York','US','10453','yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook',NULL,'yes','blog@blogsite.com','Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(60,61,'2012-05-18 21:57:12','Maya','Grace','cEO','mgtester@mindgrub.com',NULL,'Someone I know',NULL,'efawaef','awefweafwe','awefweaf',NULL,'aawefefw','waefwaef','awefawefe','DZ','waefwaefewafwewf','Training','Advocacy','AR','Latin America and Caribbean','no',NULL,NULL,NULL,'Charity Navigator',2012,13,123,12,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'no','no','no','We have our own Internet connection, but it is slow (computer with modem)','yes','YouTube',NULL,'no',NULL,NULL,NULL),(61,38,'2012-05-30 15:39:14','Bravo','Tester','Mr.','BravoTester@mindgrub.com',NULL,'Found it online',NULL,'Bravo to the rescue!','BravoToTheRescue.org','123 Main Street',NULL,'Baltimore','Maryland','21229','US','Bravo to the rescue exists to help those in need of food and water, within record time!','Food and Water','Service Directory','US',NULL,'yes','US',NULL,'12-3456789','Charity Navigator',2012,45,10,8,'Greater than $1 million','yes','no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook,Twitter,YouTube',NULL,'yes','www.blogsite.com','Yes, we have access to a phone with a camera','Yes, we have access to a video recorder'),(63,46,'2012-06-01 19:54:13','Juliet','Tester','Ms. ','Jmerritt+teammember10@mindgrub.com',NULL,'Someone I know',NULL,'Juliet Tester, Inc.','JulietTesterInc.com','123 Main Street',NULL,'Baltimore','Maryland','21228','US','Juliet Tester Incorporated is here to make a way out of no way!','Health Workers,Leadership','Training,Advocacy','US','North America','yes','US',NULL,'12-3456789','Guidestars',2012,7,8,7,'$10,000 to $50,000','yes','yes','The BEST fiscal sponsor','123 Sponsor Street',NULL,'Sponsorville','New York','US','11753','yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook',NULL,'yes','Blog@blogsite.com','Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(64,78,'2012-06-18 14:44:01','Steve','Guttenberg','Police Officer','ckidd@mindgrub.com',NULL,'Someone I know',NULL,'Mindgrub Technologies','mindgrub.com','640 Frederick Rd',NULL,'Catonsville','MD','21228','US','To blow minds and grub wallets. ','Innovation','Advocacy','US','North America','no','AF',NULL,NULL,NULL,2012,45,3,NULL,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','None',NULL,'yes',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(66,74,'2012-06-22 19:41:26','Email','Testing','Mr.','blah@lkjaglkaj.com','55','Someone I know',NULL,'Brad\'s Fun Time','brad.org','test',NULL,'test','test','21201','AF','sdf','Maternal Health','Training','GB','Western and Central Europe','no','AF',NULL,NULL,'Charity Navigator',2012,12,1,9,'Less than $10,000','no','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'no',NULL,NULL,NULL),(67,87,'2012-06-29 15:17:32','Matthew','Forr','m','mforr+june29@mindgrub.com','1234567890','Saw a commercial',NULL,'Mindgrub','http://www.midngrub.com','640 Frederick Road',NULL,'Baltimore','MD','21231','US','a','Child Brides','Training','US','North America','yes','AF',NULL,NULL,NULL,2009,1,1,1,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(71,92,'2012-07-03 13:36:31','Pat','astrophe','title','pstaso@mindgrub.com','4434051309','Found it online',NULL,'Glasses for masses','www.google.com','123 fake rd',NULL,'Baltimore','md','21211','AF','lots of glasses','Maternal Health','Service Directory','BZ','Latin America and Caribbean','no','AF',NULL,NULL,NULL,2011,32,31,152,'$10,000 to $50,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We don\'t have our own Internet connection and can\'t usually access the Internet','no',NULL,NULL,'no',NULL,NULL,NULL),(72,54,'2012-07-10 18:42:01','BradTest','Tibbils','Mr.','brad@gmail.com','410894293','Someone I know',NULL,'Brad\'s Fun Time','brad.org','123 main st.',NULL,'Baltimore','MD','21201','US','To have fun.','Girls\' Education,Maternal Health','Training','AU,BD,GB','Western and Central Europe','no','AF',NULL,NULL,NULL,2009,12,1,NULL,'Less than $10,000','no','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection, but it is slow (computer with modem)','no',NULL,NULL,'no',NULL,NULL,NULL),(74,37,'2012-07-11 14:33:36','Alpha','Tester','Mr.','Jmerritt+TeamMember1ScreenerTest@mindgrub.com','(410) 555-5555','Someone I know',NULL,'Alpha Organization','www.AlphaOrganizationWebsite.com','123 Main Street',NULL,'Baltimore','Maryland','21228','US','Mission statement of Alpha Organization goes here. For now, this is sample text.','Girls\' Education,Leadership,Training,Innovation','Training,Advocacy','US','North America','yes','US',NULL,'12-3456789','Guidestars',2012,5,2,3,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook,Twitter,YouTube',NULL,'yes','http://blog.com','Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(75,97,'2012-07-12 15:32:39','Matthew','Forr','Guy','Junglesbee+DONORTESTING@mindgrub.com','1234567890','Someone I know',NULL,'asdf','http://www.asdf.com','123 Street',NULL,'Baltimore','MD','21231','AE','asd;fkl','Girls\' Education','Advocacy','US','North America','yes','US',NULL,NULL,'Guidestars',2012,1,1,1,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook',NULL,'yes',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(81,39,'2012-07-20 21:18:45','Charlie','Tester','Mr.','Jmerritt+Teammember3@mindgrub.com','555-555-1234','Someone I know',NULL,'Charlie\'s Charities','CharliesCharities.com','123 Main Street',NULL,'Baltimore','Maryland','21228','US','Bringing charities with like causes together for support and social networking.  \"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"','Girls\' Education,Maternal Health,Child Brides,Leadership,Training,Innovation,Transportation','Training,Advocacy,Service Directory','US',NULL,'yes','US',NULL,'12-3456789','Guidestars',2012,17,2,10,'$51,000 to $1,000,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook',NULL,'yes','www.blogsite.com','Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(82,16,'2012-07-20 21:31:22','Maya Grace2','Tester','Ms.','mforr+demo_july11@mindgrub.com','55','Someone I know',NULL,'Global Organization, Inc.','global.org','640 Frederick Road',NULL,'Baltimore','Maryland','21228','US','Women Deliver is a global advocacy organization bringing together voices from around the world to call for action to improve the health and well-being of girls and women.','Maternal Health,Child Brides,Health Workers','Advocacy','MN,ME','Asia and Pacific,Eastern Europe and Central Asia','no','AF',NULL,NULL,NULL,2012,2,4,10,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection, but it is slow (computer with modem)','yes','Other','That other social media site','yes','www.blogsite.com','Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(84,119,'2012-07-23 16:59:22','Lex','Luthor','CEO ','wd.mindgrub+partner@gmail.com','555-555-1234','Found it online',NULL,'LuthorCorp','luthorcorp.info','1 Empire Circle',NULL,'Metropolis','Kansas','12345','US','LuthorCorp is an extensive billion-dollar corporation founded by Lionel Luthor. Lionel started the company with insurance money he received after his mother and father were killed in a tenement fire. LuthorCorp originally specialized in the manufacture of pesticides, fertilizer and other agricultural products, but has since diversified into many different areas, specializing in biotechnology, weapons technology, communications, electronics, pharmaceuticals, and many other branches of technology. LuthorCorp Fertilizer Plant No. 3 has underground labs holding secret (and possibly illegal) research into genetically modifying living organisms using meteor rocks with the company\'s slogan being \"We make things grow.\"  We believe in Innovation.\r\n\r\n\r\n','Innovation','Advocacy','HT,IN,US',NULL,'no','AF',NULL,NULL,NULL,1970,10000,1000,NULL,'Greater than $1 million','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(89,136,'2012-07-30 13:48:50','Anthony','Stark','CEO of Stark Industries','junglesbee+ironman@mindgrub.com','555-555-1234','Read about it in an article',NULL,'Stark Industries','www.starkexpo2010.com','2010 Flushing Meadows',NULL,'Long Island','NY','90210','US','We work to expand the community of partners dedicated to bettering the lives of girls and women. Our corporate forum brings together private sector representatives to collaborate on projects and solutions. We work with ministries of finance and health and global development experts to make the economic case for investing in girls and women. And, we look to the future by developing the skills of young advocates in developing countries through our workshops and online community. We work with communities to develop higher education.','Girls\' Education','Training','BW,KR,US',NULL,'no','AF',NULL,NULL,NULL,1970,10000,3000,1000,'$51,000 to $1,000,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(90,134,'2012-07-30 19:00:12','Bruce ','Wayne','CEO of Wayne Enterprises','wd.mindgrub+partner1@gmail.com','555-555-1234','Read about it in an article',NULL,'Wayne Enterprises','en.wikipedia.org/wiki/Wayne_Enterprises','1234 Empire Rd.',NULL,'Gothom','NJ','54321','US','Wayne Enterprises became a green company under the control of Patrick and Laura Wayne and has been environmentally conscious from that time forward. Even when environmentalism wasn\'t a fad or a necessity, Wayne Enterprises followed those ideals. At the turn of the 20th century, Wayne Enterprises was the city in many ways and even now they employ the largest part of the city\'s considerable work-force. Education is a tool for success.','Girls\' Education,Child Brides,Trafficking and Prostitution','Training,Advocacy,Service Directory','IN,GB,US','Asia and Pacific,North America,Western and Central Europe','no','AF',NULL,NULL,NULL,2012,75000,10000,5000,'Greater than $1 million','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(91,158,'2012-08-03 17:34:04','James','Jameson','Mr.','wcooper+JJameson@mindgrub.com','1110009999','Found it online',NULL,'EquALL','fake.EquALL.fake','1 Main St.',NULL,'Creekside City','Maryland','21228','US','Ipsum Lorem Mission Statement.','Leadership','Training,Advocacy','US','North America','yes','US',NULL,'11-0000001',NULL,2011,1,5,20,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We don\'t have our own Internet connection but can access the internet elsewhere','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','No'),(92,159,'2012-08-03 17:45:26','August','Tester','-','wcooper+augusttester@mindgrub.com','7777777777','Other','Convention','August Charity Federation','fake.acf.fake','2 Main St.',NULL,'Creekside City','Maryland','21228','US','Mission statement Lorem Ispum','Food and Water,Leadership,Training,Innovation','Training,Advocacy,Service Directory','US',NULL,'no','AF',NULL,NULL,NULL,2012,20,10,0,'$51,000 to $1,000,000','yes','yes','Investatron','8 Main St.',NULL,'Creekside City','MD','US','21228','yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook,Twitter,YouTube,Other',NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record'),(93,156,'2012-08-04 15:13:28','AdrieMar','Perez','Executive','rinoaangel@optonline.net','555-123-4567','Someone I know',NULL,'FakeOrganization','fakeorganization.com','7172 Nonexistence blvd','Apt 21','West New York','New Jersey','07093','US','To test many areas of this site!','Maternal Health','Advocacy','ZA','Sub-saharan Africa','yes','AU',NULL,NULL,'Charity Navigator',2012,20,2,7,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','yes','Facebook,Twitter,YouTube',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(94,169,'2012-08-08 20:56:37','Adrie','Test','Tester','agarcia@ecorexperience.com','555-123-4567','Someone I know',NULL,'eCore','eCore.com','123 Blvd East',NULL,'West New York','NJ','07093','US','To test sites all around the world','Girls\' Education','Advocacy','US','North America','yes','AF',NULL,NULL,'Guidestars',2012,20,2,7,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'yes',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(95,176,'2012-08-10 21:25:54','Teste','Tes','Test','mforr+test_screen_08_10@mindgrub.com','1234567890','Someone I know',NULL,'Test Org','http://www.midngrub.com','123 Street',NULL,'Baltimore','MD','21231','US','af','Child Brides','Training','BN','Asia and Pacific','no','AF',NULL,NULL,NULL,2012,1,1,NULL,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(96,178,'2012-08-13 15:38:24','Adam','Albrecht','Mr.','wcooper+aalbrecht@mindgrub.com','1112221111','Read about it in an article',NULL,'Women\'s Education Advancement Program','WEAP.fake','100 Education Drive',NULL,'Advancia ','Maryland','21228','US','To help further the advancement of equal education for women around the world.','Girls\' Education','Training,Advocacy','ZA,GB,US',NULL,'no','AF',NULL,NULL,NULL,2012,2,10,NULL,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'no',NULL,NULL,NULL),(97,182,'2012-08-15 13:19:32','Martha','Garrett','Ms.','wcooper+augpartner@mindgrub.com','1112223333','Read about it in an article',NULL,'Lorem Ipsum','loremipsum.com','1 Main Street',NULL,'Baltimore','Maryland','21225','US','To provide supplies, training, and care for women in need around the world.','Girls\' Education,Food and Water,Leadership,Training,Innovation','Training,Advocacy,Service Directory','GB,US','Middle East and North Africa,North America,Western and Central Europe','no','AF',NULL,NULL,NULL,2012,1,5,10,'Less than $10,000','yes','no',NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(100,81,'2012-08-27 22:18:45','Laura Grace','Carmona','Person','lgcarmona@gmail.com','540-555-1212','Found Catapult in an online search',NULL,'My Test Company','testcompany2.com','123 Main Street',NULL,'RightHere','VA','22712','US','I have a mission.  I have a mission.  I have a mission.  For reals. Maybe.','Leadership','Training and capacity building','US',NULL,'no','US',NULL,'12-3456789',NULL,2010,1,1,1,'Less than $10,000','yes',NULL,' vbb vb','vb vb bv ',NULL,NULL,NULL,'AF',NULL,'yes','no','no','We don\'t have our own Internet connection but can access the internet elsewhere','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(105,213,'2012-08-31 21:37:58','Brian101','Walker101','PDiddy','bwalker@mindgrub.com','1112224567','Recommended by someone I know',NULL,'p2dfuz','p2dfuz.com','113 Milford ln',NULL,'columbua','IN','21234','US','My fellow Americans, blah blah blah blah \r\n\r\nblah blah blah \r\n\r\nblah \r\n\r\nblah blah blah blah blah \r\n\r\nblah ','Economic security','Training and capacity building','AI','Latin America and Caribbean','no','AF',NULL,NULL,NULL,2012,56,5,66,'$500,001 to $1 million','no',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','yes','We don\'t have our own Internet connection and can\'t usually access the Internet','yes','YouTube',NULL,'no','jmppojoi;oh;','Yes, we have access to a digital camera','Yes, we have access to a phone with the ability to record video'),(106,203,'2012-09-04 21:16:31','Jasmine','Phillips','Ms.','Jmerritt+JasminePhillips2@mindgrub.com','(410) 555-1234','Found Catapult in an online search',NULL,'Jasmine Phillips\' Organization','www.JPOrganization.org','123 Mindgrub',NULL,'Washington','DC','21228','US','This it the description, this is the description...','Education,Environmental sustainability,Health','Advocacy,Training and capacity building','ET,ZA',NULL,'yes','US','yes','12-3456789',NULL,2007,25,3,4,'$500,001 to $1 million','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Facebook,Orkut',NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record video'),(107,220,'2012-09-04 21:18:24','Jane','Doe','CEO','jmerritt+JanePartner@mindgrub.com','4444444444','Received an email from Catapult',NULL,'The September Organization','september.website','1 Main St.',NULL,'Baltimore','Maryland','21225','US','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','Technology','Advocacy','CA,GB,US,UM','Asia and Pacific,North America,Western and Central Europe','yes','US','yes','00-0000000',NULL,2012,2,5,13,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Facebook,YouTube',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(110,236,'2012-09-17 15:55:27','Test','Parter917b','CEO','wcooper+TP917b@mindgrub.com','1111111111','Found Catapult in an online search',NULL,'Test Organization 1','test.organization1','1 Main St.',NULL,'Baltimore','Maryland','21225','AQ','To test partner applications registered in another country (non 501c3).','Education','Training and capacity building','AQ',NULL,'yes','AQ',NULL,NULL,NULL,2012,1,0,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(111,241,'2012-09-20 16:35:27','Test','Partner','CEO','wcooper+TP920@mindgrub.com','1111111111','Found Catapult in an online search',NULL,'The September Organization','september.website','1 Main St.',NULL,'Baltimore','Maryland','21225','US','Test Partner for password flow.','Economic security','Training and capacity building','US','North America','no','AF',NULL,NULL,NULL,2012,1,1,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We don\'t have our own Internet connection but can access the internet elsewhere','no',NULL,NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a video recorder'),(113,242,'2012-09-20 20:14:20','Will','Partner','CEO','wcooper+WP920@mindgrub.com','1111111111','Found Catapult in an online search',NULL,'The September Organization','http://september.website','1 Main St.',NULL,'Baltimore','Maryland','21225','US','To test screener application.','Education','Training and capacity building','US','North America','no','AF',NULL,NULL,NULL,2012,1,1,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(114,245,'2012-09-21 16:19:06','Suzy','Newpartner','King','gcarmona+newpartner@mindgrub.com','5555551212','Other','secret places','The Best Organization Evah!','http://mindgrub.com','123 Elm St.',NULL,'Baltimore','MD','12345','US','My mission is to test partners','Community and culture','Research','US',NULL,'yes','US','yes','55-111111',NULL,2012,1000000,2000000,3000000,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Other','YouTwitFace','yes','http://mindgrub.com','Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(116,246,'2012-09-21 16:27:59','Admin-created','Person','Queen','gcarmona+queen@mindgrub.com','5555551212','Found Catapult in an online search',NULL,'test','mindgrub.com','test',NULL,'test','va','22233','US','test mission','Education','Research','US','North America','no','AF',NULL,NULL,NULL,2012,23,23,23,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Twitter',NULL,'yes','http://youtube.com','Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(117,235,'2012-09-21 20:18:27','Test','Parter917','CEO','wcooper+TP917@mindgrub.com','1111111111','Found Catapult in an online search',NULL,'Test Organization 1','http://test.organization1','1 Main St.',NULL,'Baltimore','Maryland','21225','US','To test partner application fields.','Environmental sustainability','Advocacy','US','North America','yes','US','yes','00-0000000',NULL,2012,1,1,0,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a phone with the ability to record video'),(118,230,'2012-09-25 00:30:33','Joe','Test','Mr.','bwalker@mindgrub.com','443-555-1234','Found Catapult in an online search',NULL,'Helm Dog Testing',NULL,'123 No st',NULL,'colora','Maryland','21917','US','Test everything','Education','Research','CR,VI','Latin America and Caribbean','no','AF',NULL,NULL,NULL,2012,1,1,1,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Facebook,Twitter,LinkedIn',NULL,'yes','helmdog.net','Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(119,251,'2012-09-25 16:53:30','Will','Tester','CEO','wcooper+WT925@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Test Organization 2','test.organization2','1 Main St.',NULL,'Baltimore','Maryland','21225','US','This is a test partner for creating a screener as a guest on the Catapult website.','Technology','Research','US','North America','no','AF',NULL,NULL,NULL,2012,1,0,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(120,252,'2012-09-26 13:35:22','Parter','Testing','Testing Partner','partner+test@mindgrub.com','4109882444','Found Catapult in an online search',NULL,'Partner Test',NULL,'123 Fake St',NULL,'Fakington','FK','FK123','US','Testing','Community and culture','Research','US','North America','no','AF',NULL,NULL,NULL,2011,123,12,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,NULL,NULL),(121,253,'2012-09-26 13:50:39','Will','Partner','CEO','wcooper+WP926@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Test Organization 926','test.organization926','1 Main St.',NULL,'Baltimore','Maryland','21225','US','Test organization ipsum lorem etc.','Technology','Research','US','North America','no','AF',NULL,NULL,NULL,2012,1,0,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(122,254,'2012-09-26 14:30:18','Partner','Test2','Partner Test2','partner+test2@mindgrub.com','4109882444','Found Catapult in an online search',NULL,'Partner Testing 2',NULL,'124 Fake St',NULL,'Fakington','FK','FK124','US','Testing 2','Economic security','Research','US','North America','no','AF',NULL,NULL,NULL,2012,123,13,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection, but it is slow (computer with modem)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(123,255,'2012-09-26 14:58:06','Test','Partner','CEO','wcooper+TP926@mindgrub.com','1111111111','Read about Catapult in an article',NULL,'Test Organization 926b','test.organization926b','1 Main St.',NULL,'Baltimore','Maryland','21225','US','Ispum Lorem mission.','Technology','Research','US','North America','no','AF',NULL,NULL,NULL,2012,1,0,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(124,256,'2012-09-26 15:15:20','Test','Partner','CEO','wcooper+WT926b@mindgrub.com','1111111111','Found Catapult in an online search',NULL,'The September Organization','september.website','1 Main St.',NULL,'Baltimore','Maryland','21225','US','adfasdfasdf','Community and culture','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1,0,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We don\'t have our own Internet connection and can\'t usually access the Internet','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(125,257,'2012-09-26 15:46:01','Will','Tester926c','CEO','wcooper+TP926c@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Test Organization 926c','test.organization926c','1 Main St.',NULL,'Baltimore','Maryland','21225','US','asfhafjkasdfkjadsfkjafdsjk','Community and culture','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1,0,1,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(126,262,'2012-09-26 20:44:06','Will','Partner','The King of All that is this organization, leader.','wcooper+WP926c@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Organization of Testing with Many Aspects to Help Create the Ultimate of all Websites for Women\'s Charities and the Teams Created to Support them and so on and so on and so on and so on and so on and so on and so on and so on and so on ...................','www.longestwebsiteintheworld.evenlongerthanthat.itkeepsgoingandgoingandgoingandoingandgoingyeaha.com','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','21012-55555555555555555555555555555555555556666666','US','Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.','Education','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1000,1000,10000,'Less than $10,000','yes',NULL,'The name of this fiscal sponsor is very long and w','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','US','21012-55555555555555555555555555555555555556666666','yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Twitter',NULL,'no','aaaasdfasdfasdfasdfasdfasdfasdfasdfas.asdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfas','Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(127,263,'2012-09-26 20:45:56','Will','Partner','The King of All that is this organization, leader.','wcooper+WP926d@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Organization of Testing with Many Aspects to Help Create the Ultimate of all Websites for Women\'s Charities and the Teams Created to Support them and so on and so on and so on and so on and so on and so on and so on and so on and so on ...................','www.longestwebsiteintheworld.com','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','21012-55555555555555555555555555555555555556666666','US','Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.','Education','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1000,1000,10000,'Less than $10,000','yes',NULL,'The name of this fiscal sponsor is very long and w','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','US','21012-55555555555555555555555555555555555556666666','yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Twitter',NULL,'no','aaaasdfasdfasdfasdfasdfasdfasdfasdfas.asdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfas','Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(128,264,'2012-09-26 20:46:46','Will','Partner','The King of All that is this organization, leader.','wcooper+WP926e@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Organization of Testing with Many Aspects to Help Create the Ultimate of all Websites for Women\'s Charities and the Teams Created to Support them and so on and so on and so on and so on and so on and so on and so on and so on and so on ...................','www.longestwebsiteintheworld.com','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','21012-55555555555555555555555555555555555556666666','US','Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.','Education','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1000,1000,10000,'Less than $10,000','yes',NULL,'The name of this fiscal sponsor is very long and w','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','US','21012-55555555555555555555555555555555555556666666','yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Twitter',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(129,265,'2012-09-26 20:48:46','Will','Partner','The King of All that is this organization, leader.','wcooper+WP926f@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Organization of Testing with Many Aspects to Help Create the Ultimate of all Websites for Women\'s Charities and the Teams Created to Support them and so on and so on and so on and so on and so on and so on and so on and so on and so on ...................',NULL,'1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','21012-5555','US','Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.','Education','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1000,1000,10000,'Less than $10,000','yes',NULL,'The name of this fiscal sponsor is very long and w','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','US','21012-5555','yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Twitter',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(130,266,'2012-09-26 20:49:46','Will','Partner','The King of All that is this organization, leader.','wcooper+WP926g@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Organization',NULL,'1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','21012-5555','US','Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.Mission statement already has a built in restriction of 1000 characters.','Education','Research','US',NULL,'no','AF',NULL,NULL,NULL,2012,1000,1000,10000,'Less than $10,000','yes',NULL,'The name of this fiscal sponsor is very long and w','1 Addresses Really shouldn\'t be that long but it should be tested anyway to see how many characters ','are allowed in these fields and make sure nothing breaks while submitting a screener with such thing','A city\'s name definitely should never be longer th','Very long province names are possible, perhaps, so','US','21012-5555','yes','no','no','We have our own Internet connection and it is fast (Broadband)','yes','Twitter',NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(131,267,'2012-09-26 20:54:52','Will','Partner926h','CEO','wcooper+WP926h@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Very long organization names are still causing an error in the screener, especially with the letter AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaAAAAAAAAAAAAAAAAAAAAAAAA',NULL,'1 Main St.',NULL,'Baltimore','Maryland','21225','US','Mission','Community and culture','Research','US','North America','no','AF',NULL,NULL,NULL,2012,1,1,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(132,269,'2012-09-26 21:46:55','Delete','This','Partner','wcooper+DTP926@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'Delete This Partner Organization','delete.this','1 Main St.',NULL,'Baltimore','Maryland','21225','US','Mission statement.','Economic security','Research','US','North America','no','AF',NULL,NULL,NULL,2012,1,1,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection, but it is slow (computer with modem)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a phone with the ability to record video'),(135,271,'2012-09-26 22:32:24','Test','Partner926z','CEO','wcooper+TP926z@mindgrub.com','2121212121','Found Catapult in an online search',NULL,'This is a Very Long Organization Name Designed to Test Whether this Causes the Error with Screeners Creating Users aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaazzzzzzzzzzzz','test.organization926','1 Main St.',NULL,'Baltimore','Maryland','21225','US','Blah blah blah','Economic security','Advocacy','US','North America','no','AF',NULL,NULL,NULL,2012,10000000,10000000,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder'),(136,274,'2012-09-27 15:43:15','New','Applicant','Professor','bthompson+partner1@mindgrub.com','410-988-2444','Found Catapult in an online search',NULL,'Mindgrub',NULL,'640 Frederick Rd',NULL,'Baltimore','Maryland','21228','US','Fix bugs!','Education','Advocacy','AS','Asia and Pacific','yes','US','yes','12-1234567',NULL,2012,500,500,500000,'$50,001 to $500,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a phone with a camera','Yes, we have access to a phone with the ability to record video'),(137,277,'2012-09-27 20:54:30','testondev','lastname','big cheese','test5@helmdog.net','5555555555','Heard about it from a Catapult partner',NULL,'testondev','testondev.org','this st',NULL,'that town','md','21000','BE','to testondev','Education,Environmental sustainability','Advocacy,Training and capacity building','AL,US','Eastern Europe and Central Asia,North America','yes','AL',NULL,NULL,NULL,2003,6,6,6,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We don\'t have our own Internet connection but can access the internet elsewhere','yes','Facebook,Twitter',NULL,'yes','testondev.org/blog','Yes, we have access to a digital camera','Yes, we have access to a phone with the ability to record video'),(138,278,'2012-09-28 03:25:18','Test','Partner','CEO','wcooper+TP927e@mindgrub.com','1111111111','Found Catapult in an online search',NULL,'TP927e','t.p927e','1 Main St.',NULL,'Catonsville','MD','21225','US','Mission statement here.','Economic security','Advocacy','US','North America','yes','US','yes','00-0000000',NULL,2012,1,1,NULL,'Less than $10,000','yes',NULL,NULL,NULL,NULL,NULL,NULL,'AF',NULL,'yes','no','no','We have our own Internet connection and it is fast (Broadband)','no',NULL,NULL,'no',NULL,'Yes, we have access to a digital camera','Yes, we have access to a video recorder');
commit;

--
-- Table structure for table `wd_team_activity`
--

CREATE TABLE `wd_team_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  `uid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `nid` int(11) DEFAULT NULL,
  `created` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wd_team_activity`
--

set autocommit=0;
INSERT INTO `wd_team_activity` VALUES (11,'jointeam',57,33,NULL,1337286657),(18,'jointeam',57,35,NULL,1340364439),(19,'jointeam',57,36,NULL,1340364458),(22,'donation',0,33,121,1341262260),(23,'donation',0,33,122,1341264846),(24,'donation',0,33,129,1341273352),(25,'donation',0,33,151,1341334298),(26,'donation',0,33,152,1341336761),(27,'donation',0,33,153,1341336935),(28,'donation',0,33,164,1341349924),(29,'donation',0,33,165,1341350179);
commit;

--
-- Table structure for table `wysiwyg`
--

CREATE TABLE `wysiwyg` (
  `format` varchar(255) NOT NULL COMMENT 'The filter_format.format of the text format.',
  `editor` varchar(128) NOT NULL DEFAULT '' COMMENT 'Internal name of the editor attached to the text format.',
  `settings` text COMMENT 'Configuration settings for the editor.',
  PRIMARY KEY (`format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores Wysiwyg profiles.';

--
-- Dumping data for table `wysiwyg`
--

set autocommit=0;
INSERT INTO `wysiwyg` VALUES ('ds_code','',NULL),('full_html','tinymce','a:20:{s:7:\"default\";i:1;s:11:\"user_choose\";i:0;s:11:\"show_toggle\";i:0;s:5:\"theme\";s:8:\"advanced\";s:8:\"language\";s:2:\"en\";s:7:\"buttons\";a:3:{s:7:\"default\";a:19:{s:4:\"bold\";i:1;s:6:\"italic\";i:1;s:9:\"underline\";i:1;s:11:\"justifyleft\";i:1;s:13:\"justifycenter\";i:1;s:12:\"justifyright\";i:1;s:11:\"justifyfull\";i:1;s:7:\"bullist\";i:1;s:7:\"numlist\";i:1;s:7:\"outdent\";i:1;s:6:\"indent\";i:1;s:4:\"undo\";i:1;s:4:\"link\";i:1;s:6:\"unlink\";i:1;s:5:\"image\";i:1;s:4:\"code\";i:1;s:3:\"cut\";i:1;s:4:\"copy\";i:1;s:5:\"paste\";i:1;}s:4:\"font\";a:3:{s:10:\"fontselect\";i:1;s:14:\"fontsizeselect\";i:1;s:11:\"styleselect\";i:1;}s:4:\"imce\";a:1:{s:4:\"imce\";i:1;}}s:11:\"toolbar_loc\";s:3:\"top\";s:13:\"toolbar_align\";s:4:\"left\";s:8:\"path_loc\";s:6:\"bottom\";s:8:\"resizing\";i:1;s:11:\"verify_html\";i:1;s:12:\"preformatted\";i:0;s:22:\"convert_fonts_to_spans\";i:1;s:17:\"remove_linebreaks\";i:0;s:23:\"apply_source_formatting\";i:0;s:27:\"paste_auto_cleanup_on_paste\";i:0;s:13:\"block_formats\";s:32:\"p,address,pre,h2,h3,h4,h5,h6,div\";s:11:\"css_setting\";s:5:\"theme\";s:8:\"css_path\";s:0:\"\";s:11:\"css_classes\";s:0:\"\";}'),('php_code','',NULL),('plain_text','',NULL);
commit;

--
-- Table structure for table `wysiwyg_user`
--

CREATE TABLE `wysiwyg_user` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user.',
  `format` varchar(255) DEFAULT NULL COMMENT 'The filter_format.format of the text format.',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Boolean indicating whether the format is enabled by default.',
  KEY `uid` (`uid`),
  KEY `format` (`format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores user preferences for wysiwyg profiles.';

--
-- Dumping data for table `wysiwyg_user`
--

set autocommit=0;
commit;

--
-- Table structure for table `zipcodes`
--

CREATE TABLE `zipcodes` (
  `zip` varchar(16) NOT NULL DEFAULT '0' COMMENT 'Postal / ZIP code.',
  `city` varchar(30) NOT NULL DEFAULT '' COMMENT 'City.',
  `state` varchar(30) NOT NULL DEFAULT '' COMMENT 'Province / State.',
  `latitude` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT 'Location latitude (decimal degrees).',
  `longitude` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT 'Location longitude (decimal degrees).',
  `timezone` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Timezone (unused).',
  `dst` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Daylight Savings Time (unused).',
  `country` char(2) NOT NULL DEFAULT '' COMMENT 'Two letter ISO country code.',
  KEY `pc` (`country`,`zip`),
  KEY `zip` (`zip`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`),
  KEY `country` (`country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Location.module zipcode database.';

--
-- Dumping data for table `zipcodes`
--

set autocommit=0;
commit;


