· 11 years ago · Jul 15, 2015, 07:34 PM
1--
2-- Table structure for table `parkroww_customers`
3--
4
5CREATE TABLE IF NOT EXISTS `parkroww_customers` (
6 `customers_id` int(11) NOT NULL AUTO_INCREMENT,
7 `customers_gender` char(1) NOT NULL DEFAULT '',
8 `customers_firstname` varchar(32) NOT NULL DEFAULT '',
9 `customers_lastname` varchar(32) NOT NULL DEFAULT '',
10 `customers_dob` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
11 `customers_email_address` varchar(96) NOT NULL DEFAULT '',
12 `customers_nick` varchar(96) NOT NULL DEFAULT '',
13 `customers_default_address_id` int(11) NOT NULL DEFAULT '0',
14 `customers_telephone` varchar(32) NOT NULL DEFAULT '',
15 `customers_fax` varchar(32) DEFAULT NULL,
16 `customers_password` varchar(40) NOT NULL DEFAULT '',
17 `customers_newsletter` char(1) DEFAULT NULL,
18 `customers_group_pricing` int(11) NOT NULL DEFAULT '0',
19 `customers_email_format` varchar(4) NOT NULL DEFAULT 'TEXT',
20 `customers_authorization` int(1) NOT NULL DEFAULT '0',
21 `customers_referral` varchar(32) NOT NULL DEFAULT '',
22 `customers_paypal_payerid` varchar(20) NOT NULL DEFAULT '',
23 `customers_paypal_ec` tinyint(1) unsigned NOT NULL DEFAULT '0',
24 PRIMARY KEY (`customers_id`),
25 KEY `idx_email_address_zen` (`customers_email_address`),
26 KEY `idx_referral_zen` (`customers_referral`(10)),
27 KEY `idx_grp_pricing_zen` (`customers_group_pricing`),
28 KEY `idx_nick_zen` (`customers_nick`),
29 KEY `idx_newsletter_zen` (`customers_newsletter`)
30) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ;
31
32--
33-- Dumping data for table `parkroww_customers`
34--
35
36INSERT INTO `parkroww_customers` (`customers_id`, `customers_gender`, `customers_firstname`, `customers_lastname`, `customers_dob`, `customers_email_address`, `customers_nick`, `customers_default_address_id`, `customers_telephone`, `customers_fax`, `customers_password`, `customers_newsletter`, `customers_group_pricing`, `customers_email_format`, `customers_authorization`, `customers_referral`, `customers_paypal_payerid`, `customers_paypal_ec`) VALUES
37(41, 'm', 'Andrew', 'Brunson', '0001-01-01 00:00:00', 'andrewguard2005-shop1@yahoo.com', '', 50, '9199427780', '', 'be6fa6997a1811e946c23b2b5cf66458:f9', '0', 0, 'TEXT', 0, '', '', 0),
38(10, 'f', 'Dr. Harriet', 'Mall', '0001-01-01 00:00:00', 'drharrietmall@gmail.com', '', 11, '248-538-5045', '248-538-1801', '3db20ac93452a357d4a4cf9eb82ffc4e:54', '1', 0, 'TEXT', 0, '', '', 0),
39(11, 'm', 'lee', 'lee', '0001-01-01 00:00:00', 'lighting20011@yahoo.com', '', 12, '4042845453', '', 'eb977a03e666a2d764caf53f2e42d660:36', '0', 0, 'TEXT', 0, '', '', 0),
40(12, 'm', 'Michael', 'King', '0001-01-01 00:00:00', 'mikeking174@gmail.com', '', 13, '9176574540', '', '7c237ec1898fcddb2d467ffba96624a6:78', '0', 0, 'TEXT', 0, '', '', 0),
41(13, 'm', 'Zahid', 'Syed', '0001-01-01 00:00:00', 'fusuoyz@yahoo.com', '', 14, '4694389086', '', 'eaa48fbd800e2f997b4116da8e7540a2:48', '0', 0, 'TEXT', 0, '', '', 0),
42(14, 'f', 'An', 'Doan', '0001-01-01 00:00:00', 'talk2antheman@gmail.com', '', 16, '6264520833', '', 'fc4f2c15696bf85bff23cc38f7c53e66:aa', '0', 0, 'TEXT', 0, '', '', 0),
43(40, 'm', 'Darren', 'MacDonald', '0001-01-01 00:00:00', 'support@cash4urgirl.net', '', 48, '9799855696', '', 'a86b0aa8c08ff5a1902714afdfad2b78:c1', '0', 0, 'TEXT', 0, '', '', 0),
44(16, 'm', 'Ezra', 'Mosseri', '0001-01-01 00:00:00', 'ezmo3@aol.com', '', 18, '9176215168', '', '0a745979ab96ca754031b57223898949:d9', '1', 0, 'HTML', 0, '', '', 0),
45(20, 'm', 'Brian', 'Romain', '0001-01-01 00:00:00', 'btrini900@yahoo.com', '', 23, '6176420432', '', '22dd5f045a181947454b9c34e7c0848d:a9', '0', 0, 'TEXT', 0, '', '', 0),
46(19, 'm', 'Tushar', 'Patel', '0001-01-01 00:00:00', 'patelmd15@yahoo.com', '', 21, '5089972900', '', '3573f11465306f4cdc87049fd1a424d6:16', '1', 0, 'TEXT', 0, '', '', 0),
47(21, 'm', 'Manjunath', 'Doddamani', '0001-01-01 00:00:00', 'manjunath_nitk@yahoo.co.in', '', 24, '732 391 8084', '', '408d21c9ec017db4a386f626d7b0a5d5:19', '0', 0, 'TEXT', 0, '', '', 0),
48(22, 'f', 'Kris', 'Bunag', '0001-01-01 00:00:00', 'kmpb@ymail.com', '', 25, '6502882488', '', '435ea6f6df87ebf0b3efdc0f83953fcd:51', '0', 0, 'HTML', 0, '', '', 0),
49(23, 'f', 'raquel', 'garcia van staden', '0001-01-01 00:00:00', 'mailforme25@yahoo.com', '', 26, '310.873.7987', '', '07146d70cf8f65e8934c864a6650d39a:83', '0', 0, 'TEXT', 0, '', '', 0),
50(24, 'm', 'Ibrahim', 'Halid', '0001-01-01 00:00:00', 'ihaladu@yahoo.com', '', 28, '8063219761', '', '5d4e6cec56bc0870aafae71f8fd55ef2:9c', '1', 0, 'TEXT', 0, '', '', 0),
51(25, 'm', 'Pierre', 'Fransua', '0001-01-01 00:00:00', 'wireless.ties@yahoo.com', '', 29, '303-351-4427', '', '92a8fd9548079404f1c8a15b829d68d7:e3', '1', 0, 'HTML', 0, '', '', 0),
52(26, 'm', 'Dahir', 'Yasin', '0001-01-01 00:00:00', 'don-sp@hotmail.co.uk', '', 30, '07904368613', '', '6c3635489bcd62dab4a6b5ae400daf76:00', '0', 0, 'TEXT', 0, '', '', 0),
53(30, 'm', 'Dave', 'Militante', '0001-01-01 00:00:00', 'dmmilitante@gmail.com', '', 34, '510-734-0548', '', '2ca7c81975177c9d83d0a15172848125:b8', '0', 0, 'TEXT', 0, '', '', 0),
54(31, 'f', 'An', 'Slavin', '0001-01-01 00:00:00', 'an.slavin@yahoo.com', '', 35, '2152752795', '', '9aa6f2c65791ad05647d994e85861fe8:7b', '0', 0, 'TEXT', 0, '', '', 0),
55(32, 'm', 'Ryan', 'Valmores', '0001-01-01 00:00:00', 'rysname@ucla.edu', '', 37, '3109414605', '', 'f3d37b741974257c78af7b1061296fbe:10', '0', 0, 'TEXT', 0, '', '', 0),
56(39, '', 'Jeremy', 'Kye Harlan', '0001-01-01 00:00:00', 'Jeremy-b9ltk9g6jlc@checkout.google.com', '', 47, '870 897-0337', '', 'db2c810d0a27a8029f0fb57904c3b57f:05', '1', 0, 'TEXT', 0, '', '', 0),
57(35, 'm', 'Ryan', 'Valmores', '0001-01-01 00:00:00', 'daonenonlyry@gmail.com', '', 40, '3109414605', '', '1716787c8f6b792196929c0d98e71515:d5', '0', 0, 'TEXT', 0, '', '', 0),
58(36, 'm', 'Sandy', 'Gonzalez', '0001-01-01 00:00:00', 'goweb2060@hotmail.com', '', 41, '8293769710', '', '5fddb918542ab2bc159c60d6064f3678:27', '0', 0, 'TEXT', 0, '', '', 0),
59(37, 'm', 'Daniel', 'Castro', '0001-01-01 00:00:00', 'dcastro@gmail.com', '', 42, '2816304500', '', '76cb82bed7dd355b182264d0d1b66a59:ed', '0', 0, 'TEXT', 0, '', '', 0),
60(38, '', 'Alex', 'Kang', '0001-01-01 00:00:00', 'akang95@gmail.com', '', 44, '', '', '8d82e35afcde9ce4eeb92b6743594a4a:7e', '0', 0, 'TEXT', 0, '', 'KRHJVLTLE5JQU', 0),
61(42, 'm', 'Joseph', 'Lundrigan', '0001-01-01 00:00:00', 'jplundrigan@yahoo.com', '', 52, '(917) 538-1648', '', '3b1abcec10f0a3a2eca270aa70222018:e2', '0', 0, 'TEXT', 0, '', '', 0),
62(43, 'f', 'Samonne', 'Smith', '0001-01-01 00:00:00', 'monnie242@gmail.com', '', 53, '242-676-3135', '', 'dc190eae0c9ac01fa2408f89cedc1f6d:9f', '0', 0, 'TEXT', 0, '', '', 0),
63(44, 'm', 'VICTOR', 'ALVA', '0001-01-01 00:00:00', 'vic78ah@gmail.com', '', 57, '5552362567', '', 'a796ce821596e0d4880b0ca5f3b88b84:fa', '0', 0, 'TEXT', 0, '', '', 0),
64(45, 'm', 'Joe', 'Mall', '0001-01-01 00:00:00', 'jmall@techsupportcarolina.com', '', 62, '9193332412', '', '2fc8783035d0e0fe23f9bddc02fee39c:e5', '0', 0, 'TEXT', 0, '', '', 0),
65(46, 'f', 'Natalia', 'Antoniou', '0001-01-01 00:00:00', 'nat-antoniu@yandex.ru', '', 63, '+357-99278067', '', 'da1e8963e6217dd1c10d9851466f2728:91', '0', 0, 'TEXT', 0, '', '', 0),
66(47, 'm', 'Rami', 'Armani', '0001-01-01 00:00:00', 'raaami@gmail.com', '', 65, '8177737211', '', '5f574fecfeda20b254845e63983dbb57:ad', '0', 0, 'HTML', 0, '', '', 0),
67(48, '', 'Gustavo', 'Hernandez', '0001-01-01 00:00:00', 'LPDecember10@gmail.com', '', 67, '773 307-2895', '', '0c05ad3f8c69dc0574793435f618bd71:46', '1', 0, 'TEXT', 0, '', '', 0),
68(49, 'm', 'Jans', 'Garkavi', '0001-01-01 00:00:00', 'garkavi_jan@yahoo.com', '', 68, '+447806600880', '', '720a5d17bcdd9b5f66b340709bfc3464:ac', '0', 0, 'TEXT', 0, '', '', 0),
69(50, 'm', 'mariusz', 'solakiewicz', '0001-01-01 00:00:00', 'smariusz@hotmail.com', '', 69, '224-578-1708', '', 'f41395cc22853a6ed7d270e8f8e2d37a:09', '0', 0, 'TEXT', 0, '', '', 0),
70(51, 'm', 'Nur Wisnu', 'Sidharta', '0001-01-01 00:00:00', 'nur_wisnu@yahoo.com', '', 70, '+62717439900', '+62717439600', '00791941785c36724deb4e41a062691d:ac', '0', 0, 'TEXT', 0, '', '', 0),
71(52, '', 'Matthew', 'Robinson', '0001-01-01 00:00:00', 'Matthew-bacndba6p50@checkout.google.com', '', 71, '703 854-0871', '', '2ceb244c6e92780dd2ce4d09714659b7:2a', '0', 0, 'TEXT', 0, '', '', 0),
72(53, 'm', 'Arturo', 'Morales', '0001-01-01 00:00:00', 'armojo@gmail.com', '', 73, '4246613935', '', '53d05de416bb514934ddbab9dc7dafdf:9d', '0', 0, 'TEXT', 0, '', '', 0),
73(54, '', 'Jenny', 'Lee', '0001-01-01 00:00:00', 'byronlee1228@yahoo.com', '', 74, '415 519-1428', '', '0bbec9aea074c603e38aaf9b6979280e:2b', '1', 0, 'TEXT', 0, '', '', 0),
74(55, 'm', 'Jeremy', 'White', '0001-01-01 00:00:00', 'endless_dream1975@yahoo.com', '', 75, '570 3853875', '570 3853875', '009d80d3c1c94114e6e63c3aa29f810e:72', '1', 0, 'HTML', 0, '', '', 0),
75(56, 'm', 'Roland', 'Arsandya', '0001-01-01 00:00:00', 'vice@videncorp.com', '', 77, '6281390482003', '', '22908d4e64c1ca7f054b5e3d71f9aa75:91', '0', 0, 'TEXT', 0, '', '', 0),
76(57, 'm', 'jerry', 'ameris', '0001-01-01 00:00:00', 'tekken360a@yahoo.com', '', 80, '3053973665', '', '28214ff952f0b659ff79f2a27eaed32e:3b', '0', 0, 'HTML', 0, '', '', 0),
77(58, '', 'Manikya', 'M Babu Eadara', '0001-01-01 00:00:00', 'madhu.eadara@gmail.com', '', 81, '703 409-2727', '', '57ce9fbe440f84e472e07d858edc432e:a6', '0', 0, 'TEXT', 0, '', '', 0),
78(59, 'f', 'julia', 'schmidt', '0001-01-01 00:00:00', 'schmidt_julia123@yahoo.com', '', 82, '9704129510', '', 'ba58c699de5261d6e1c2056611ed1808:f2', '0', 0, 'TEXT', 0, '', '', 0),
79(60, 'm', 'Theresa', 'Petter', '0001-01-01 00:00:00', 'youth1121@juno.com', '', 83, '2142156537', '', '04008294e43df014a77425fe8dc0b4b1:ea', '0', 0, 'TEXT', 0, '', '', 0),
80(61, 'm', 'Garri', 'Vardanyan', '0001-01-01 00:00:00', 'garry.vardanyan@gmail.com', '', 87, '3146192993', '', 'f58f6e2fc1efac1828fed20479b483ca:f0', '0', 0, 'TEXT', 0, '', '', 0),
81(62, 'm', 'kenner', 'walker', '0001-01-01 00:00:00', 'kennerwc@gmail.com', '', 88, '3055917507', '', 'fa591c69940c3011ca6b976c2b77b525:0e', '0', 0, 'TEXT', 0, '', '', 0),
82(63, 'm', 'Ruslan', 'Petrenko', '0001-01-01 00:00:00', 'petrenko@live.ca', '', 89, '+16478899300', '', '62d2593581250e0f28a07ee94232bb24:8a', '1', 0, 'HTML', 0, '', '', 0),
83(64, 'm', 'Lorenzo', 'Regala', '0001-01-01 00:00:00', 'automagic17@yahoo.com', '', 90, '6502860949', '', '5f8bc10e8a5684168a58225980814d71:fb', '0', 0, 'HTML', 0, '', '', 0),
84(65, '', 'Tyler', 'Gatewood', '0001-01-01 00:00:00', 'tylergatewood@gmail.com', '', 91, '913 541-1564', '', '1e83efe85a2d09d353869b80fe4f1914:ed', '0', 0, 'TEXT', 0, '', '', 0),
85(66, 'm', 'william', 'liu', '0001-01-01 00:00:00', 'willremgmt@gmail.com', '', 92, '718-916-3189', '', '2f4b550b9473baf63745f940f0934e5e:f3', '0', 0, 'TEXT', 0, '', '', 0),
86(67, '', 'witold', 'pela', '0001-01-01 00:00:00', 'witold-bjqc7bc0kml@checkout.google.com', '', 93, '347 242-7036', '', '57c94af38aedef420ac02376b45b6d69:89', '0', 0, 'TEXT', 0, '', '', 0),
87(68, 'm', 'Viorel', 'Carnet', '0001-01-01 00:00:00', 'patlagik@gmail.com', '', 94, '+40721820741', '', 'ff604905b06bbdeb6465c8f4e22fa9a3:96', '1', 0, 'HTML', 0, '', '', 0),
88(69, 'm', 'Edgardo', 'Vazquez', '0001-01-01 00:00:00', 'worldscoops@yahoo.com', '', 95, '3473239012', '', '7a685e8a67e04f6fb6040c7ab423b4d9:b1', '0', 0, 'TEXT', 0, '', '', 0);