-- http://www.phpmyadmin.net
--




--
-- Database: `charlie_wrdp1`
--

-- --------------------------------------------------------

--
-- Table structure for table `donation`
--

CREATE TABLE IF NOT EXISTS `donation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `person first name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone number` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `approvalnumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `zipcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date of birth` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `credit card type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55 ;

--
-- Dumping data for table `donation`
--

INSERT INTO `donation` (`id`, `date`, `time`, `person first name`, `last name`, `phone number`, `amount`, `approvalnumber`, `billing address`, `city`, `state`, `zipcode`, `country`, `date of birth`, `credit card type`, `status`) VALUES
(1, '21/11/11', '03:30:20 pm', 'Rupa', 'Mukherjee', 456, 18, '', 'test-address1test-address2', 'test-city', 'KY', '123', 'India', '8/12/1989', 'Discover', ''),
(2, '21/11/11', '03:39:38 pm', 'Rupa', 'Mukherjee', 456, 18, '', 'test-address1,test-address2', 'test-city', 'KY', '123', 'India', '8/12/1989', 'Discover', ''),
(3, '22/11/11', '10:06:05 am', 'Rupa', 'test', 123456, 19, '', 'test-address1,test-address2', 'test-city', 'AK', '123', 'Australia', '7/11/1988', 'Discover', ''),
(4, '22/11/11', '10:06:33 am', 'Rupa', 'test', 123456, 19, '', 'test-address1,test-address2', 'test-city', 'AK', '123', 'Australia', '7/11/1988', 'Discover', 'Complete'),
(5, '22/11/11', '10:07:47 am', 'Rupa', 'test', 123456, 19, '', 'test-address1,test-address2', 'test-city', 'AK', '123', 'Australia', '7/11/1988', 'Discover', ''),
(6, '22/11/11', '10:08:53 am', 'Rupa', 'test', 123456, 19, '', 'test-address1,test-address2', 'test-city', 'AK', '123', 'Australia', '7/11/1988', 'Discover', 'Pending'),
(7, '22/11/11', '10:09:18 am', 'test', 'test', 123, 11, '', 'test-address1,test-address2', 'test-city', 'CA', '123456782', 'United', '7/11/1988', 'Visa', ''),
(12, '01/12/11', '11:45:23 am', 'Namish', 'Jindal', 123, 1, 'CF7D98438C96E', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(10, '01/12/11', '12:34:46 am', 'Namish', 'Jindal', 123456, 1, '16538B18D4511', 'adf,asd', 'asd', 'CA', '1098', 'United States', '20-11-2011', 'MasterCard', ''),
(11, '01/12/11', '12:46:31 am', 'Naomi', 'Jordan+Cook', 201, 10, 'CC3FC5354CBA9', '40+Woodland+Dr,', 'Tuxedo', 'CA', '10987', '', '9/17/1980', 'Discover', ''),
(13, '01/12/11', '11:46:33 am', 'Namish', 'Jindal', 123, 1, '7E2B03FF7EDCD', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(14, '01/12/11', '11:47:21 am', 'Namish', 'Jindal', 123, 1, '7AF7E8EF2D22F', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(15, '01/12/11', '11:55:17 am', 'Namish', 'Jindal', 123, 1, '20B9E18F5CE76', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(16, '01/12/11', '11:56:14 am', 'Namish', 'Jindal', 123, 1, '56FF6AF1BBD1D', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(17, '01/12/11', '11:58:48 am', 'Namish', 'Jindal', 123, 1, '76C784BF3B475', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(18, '01/12/11', '11:59:27 am', 'Namish', 'Jindal', 123, 1, 'E5A1379440460', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(19, '01/12/11', '12:06:45 pm', 'Namish', 'Jindal', 123, 1, '535122CE1C71C', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(20, '01/12/11', '12:07:45 pm', 'Namish', 'Jindal', 123, 1, 'BC0FAC7D2EF3C', 'adf,asd', 'asd', 'CA', '1098', 'United States', '01/12/2011', 'MasterCard', ''),
(21, '17/12/11', '09:59:19 pm', 'Paul', 'Pinder', 0, 125, '788A869A2CB6C', ',', '', 'CA', '', '', 'MM/DD/YYYY', 'Visa', ''),
(22, '28/12/11', '07:37:19 am', 'prophetess+margaret', 'grant+', 2147483647, 13, '6EE660C3C85D3', '4+south+orange+avenue%2C+%23316,', 'south+orange', 'NJ', '07079', 'United States', '11/03/1957', 'Visa', ''),
(23, '29/12/11', '10:06:57 pm', 'Naomi', 'Cook', 201, 10, '1F779993C61CA', '40+Woodland+Dr,', 'TUXEDO', 'NY', '10987', 'United States', 'Sept 17, 1980', 'Discover', ''),
(24, '30-12-11', '04:03:47 pm', 'Melissa', 'Nocho', 410, 71, 'B993048DBF4FB', '2257+commissary+circle,', 'ODENTON', 'MD', '21113', 'United States', '', 'Visa', 'Complete'),
(25, '31/12/11', '05:13:16 am', 'Charlie', 'Berrian', 2147483647, 50, 'B8A6108C6B639', '76+Cauthers+Rd,', 'Woodridge+', 'NY', '12789', 'United States', '3/5/1961', 'Visa', ''),
(26, '31/12/11', '05:44:18 am', 'Charlie', 'Berrian', 2147483647, 10, '8E4B08289C3EA', '76+Cauthers+Rd,', 'Woodridge+', 'NY', '12789', 'United States', '3/5/1961', 'Visa', ''),
(27, '31/12/11', '09:47:12 am', 'prophetess+margaret', 'grant', 2147483647, 10, 'D44472ED54CB', '4+south+orange+avenue,316', 'south+orange', 'NJ', '07079', 'United States', '11/03/1957', 'Visa', ''),
(28, '31/12/11', '10:58:48 pm', 'Linda', 'Thomas', 240, 42, '646DBDD3CF55C', '8811+Colesville+Road+,Apt+907', 'Silver+Spring', 'MD', '20910', 'United States', '3/4/1955', 'Visa', ''),
(29, '01/01/12', '09:16:24 am', 'Audrey', 'Lawrence', 2147483647, 42, '27D0D175228F7', '1158+E.+56th+st,1158+E.+56th+st', 'Brooklyn', 'NY', '11234', 'United States', '6/7/1959', 'MasterCard', 'Complete'),
(30, '01/01/12', '09:49:04 am', 'stepehn', 'bostick', 845, 52, 'CCAF5C6E472CE', '1500+street+rte+52+%23i209,1500+street+rte+52+%23i209', 'LIBERTY', 'NY', '12754', '', '1/19/1958', 'Visa', ''),
(31, '01/01/12', '09:52:43 am', 'sylvia', 'santos', 718, 42, 'B88DCA62D6B3C', '4415+furman+avenue+%232,4415+furman+avenue+%232', 'Bronx', 'NY', '10466', '', '3/21/1965', 'Visa', ''),
(32, '01/01/12', '09:56:58 am', 'carla', 'anderson', 205, 30, '52224E9ED8C9D', '7807+Division+Avenue,7807+Division+Avenue', 'BIRMINGHAM', 'AL', '35206', '', '11/25/1970', 'Visa', ''),
(33, '01/01/12', '09:59:30 am', 'april', 'mc+nair', 678, 42, '8C9136BD2274', '119+preston+park+dr.,119+preston+park+dr.', 'duluth', 'GA', '30096', '', '12/4/1969', 'Visa', ''),
(34, '02/01/12', '06:19:52 am', 'LaShannon', 'Akins', 267, 101, '39CE7BD8E22E7', '103+Sawgrass+Drive,103+Sawgrass+Drive', 'Blue+Bell', 'PA', '19422', 'United States', '05/16/1969', 'Visa', ''),
(35, '02/01/12', '06:49:09 am', 'nancy', 'dandy', 414, 20, '49D5EC065BAE6', '4214+n.+22nd+street,4214+n.+22ns+street', 'Milwaukee', 'WI', '53209', 'United States', '10/18/1961', 'Visa', ''),
(36, '02/01/12', '08:23:03 am', 'alice', 'jackson', 860, 20, '50D18406B60F5', '4+basswood+court,4+basswood+court', 'bloomfield', 'CT', '06002', 'United States', '10/11/1951', 'Visa', ''),
(37, '01/05/2012', '09:41:23 pm', 'nolita', 'jackson', 2147483647, 20, '8C2C9D722EE8C', '1621+ellington+road+se,', 'CONYERS', 'GA', '30013', 'United States', 'June 14, 1972', 'Visa', ''),
(38, '01/10/2012', '07:12:14 am', 'Lorna', 'Aaron', 908, 46, 'B79675A48C08C', '8500+Blvd+Est%2C+%231D,8500+Blvd+Est%2C+%231D', 'NORTH+BERGEN', 'NJ', '07047', '', '4/2/1961', 'MasterCard', ''),
(39, '01/11/2012', '06:41:09 am', 'EMMANUEL', 'BONNEY', 2147483647, 50, '1D22B8FD2EE4E', '2556+MIRANDA+CT,', 'WOODBRIDGE', 'VA', '22191', 'United States', '01/10/1975', 'Visa', ''),
(40, '01/17/2012', '04:35:35 pm', 'Charlie', 'Berrian', 845, 10, '70944610EE12F', '76+Cauthers+Rd.,', 'Woodridge', 'NY', '12789', '', '3/2/1961', 'Visa', ''),
(41, '01/26/2012', '08:41:35 pm', 'albert', 'way', 2147483647, 6, 'F2439E971A48', 'p+o+box+831985,', 'stone+mountain', 'GA', '30083', 'United States', '09/13/69', 'Visa', ''),
(42, '01/31/2012', '08:16:56 pm', 'Rev. Donna', 'Prince', 0, 48, 'B08515DCE78A5', '3504+Burleigh+Drive,', 'Bowie', 'MD', '20721', 'United States', '01/20/1954', 'Visa', ''),
(43, '02/08/2012', '10:37:50 am', 'KENDALL', 'ROSS', 209, 0, 'A686F7B65B6E7', '3144+NORTH+Gst+%23125%2F122,', 'MERCED', 'CA', '95340', 'United States', '7/3/1970', 'MasterCard', ''),
(44, '02/08/2012', '10:38:05 am', 'KENDALL', 'ROSS', 209, 0, 'D3B822EED8F1F', '3144+NORTH+Gst+%23125%2F122,', 'MERCED', 'CA', '95340', 'United States', '7/3/1970', 'MasterCard', ''),
(45, '02/08/2012', '03:42:34 pm', 'Emmanuel', 'Berrian', 845, 20, 'C6C540E312A46', '76+cauthers+road,', 'Woodridge', 'NY', '12789', 'United States', 'Septembrr 14 1989', 'Visa', ''),
(46, '02/11/2012', '08:52:10 pm', 'lashannon', 'akins', 267, 100, 'B374AF806A97A', '103+sawgrass+drive,', 'blue+bell', 'PA', '19422', 'United States', 'May 16, 1969', 'Visa', ''),
(47, '02/20/2012', '01:01:35 pm', 'Norma', 'Maldonado', 917, 52, '89E18E0AF277A', '1811+wallace+avenue,', 'Bronx', 'NY', '10462', 'United States', '10/10/1956', 'Visa', ''),
(48, '02/23/2012', '07:25:01 pm', 'Charlie', 'Berrian', 845, 100, '4CF40C47C277E', '76+Cauthers+Rd.,', 'Woodridge', 'NY', '12789', 'United States', '3/2/1961', 'Visa', ''),
(49, '02/24/2012', '08:37:04 am', 'Sherria', 'Hall', 618, 77, '28B6E4BCE2F57', '1820+Crest+Drive,', 'Alton', 'IL', '62002', 'United States', '01/30/1983', 'Visa', ''),
(50, '02/24/2012', '03:36:35 pm', 'Asha', 'Wilson', 407, 50, '5FC7C502C6CD1', '1356+Acorn+Circle,', 'APOPKA', 'FL', '32703', 'United States', '11/22/1985', 'Visa', '');

