Advertisement
BurningBunny

Fake/Randomly generated CustomerData

Jun 29th, 2013
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 4.05 KB | None | 0 0
  1. /*
  2.  * NOTE: This all FAKE customer information data/orders.
  3.  * This was generated with the intent of using it as honey in my honeypot.
  4.  * This database was created using a RandomFormatter class in C#.
  5.  * You can view snippets of the source code to the class at csharpcodewhisperer.blogspot.com
  6.  *
  7.  * -> http://csharpcodewhisperer.blogspot.com
  8.  */
  9.  
  10.  
  11.  
  12. CREATE TABLE CustomerData (
  13.   `id` mediumint(8) unsigned NOT NULL auto_increment,
  14.   `UniqueID` MEDIUMINT default NULL,
  15.   `TripDate` varchar(50) default NULL,
  16.   `FirstName` varchar(255) default NULL,
  17.   `LastName` varchar(255) default NULL,
  18.   `CellPhone` varchar(100) default NULL,
  19.   `AltPhone` varchar(100) default NULL,
  20.   `Email` varchar(255) default NULL,
  21.   `StreetAddress` varchar(255) default NULL,
  22.   `City` varchar(50) default NULL,
  23.   `State` varchar(50) default NULL,
  24.   `Zip` varchar(10) default NULL,
  25.   `Country` varchar(255) default NULL,
  26.   `DayOfYear` varchar(50) default NULL,
  27.   `TotalCost` varchar(255) default NULL,
  28.   `CCard` varchar(255) default NULL,
  29.   `` varchar(255) default NULL,
  30.   PRIMARY KEY (`id`)
  31. ) TYPE=MyISAM AUTO_INCREMENT=1;
  32.  
  33. ------------------------------------------------------------------------
  34.  
  35. INSERT INTO `CustomerData`
  36. (`UniqueID`,`TripDate`,`FirstName`,`LastName`,`CellPhone`,`AltPhone`,`Email`,`StreetAddress`,`City`,`State`,`Zip`,`Country`,`DayOfYear`,`TotalCost`,`CCard`,``)
  37. VALUES ('243','20130809.xx','Lana','Trevino','698 503 6726','250 750
  38. 1358','varius.Nam.porttitor@Duisdignissimtempor.org','P.O. Box 140, 4172
  39. Neque
  40. Av.','Alameda','Kansas','41714','UnitedStates','160','431','4155291195851232','');
  41. INSERT INTO `CustomerData`
  42. (`UniqueID`,`TripDate`,`FirstName`,`LastName`,`CellPhone`,`AltPhone`,`Email`,`StreetAddress`,`City`,`State`,`Zip`,`Country`,`DayOfYear`,`TotalCost`,`CCard`,``)
  43. VALUES ('250','20130818.xx','Dale','Peters','280 904 1865','395 700
  44. 1292','Aliquam@Nuncsedorci.com','Ap #930-4733 Mollis
  45. Street','Harrisburg','Kentucky','38114','UnitedStates','131','744','3243363692495222','');
  46. INSERT INTO `CustomerData`
  47. (`UniqueID`,`TripDate`,`FirstName`,`LastName`,`CellPhone`,`AltPhone`,`Email`,`StreetAddress`,`City`,`State`,`Zip`,`Country`,`DayOfYear`,`TotalCost`,`CCard`,``)
  48. [...]
  49.  
  50. <?xml version="1.0" standalone="yes"?>
  51. <DocumentElement>
  52.   <Order>
  53.     <Date>3/18/2005</Date>
  54.     <TrackingNumber>1Z 8A8 238 01 9398 182 1</TrackingNumber>
  55.     <FirstName>Keaton </FirstName>
  56.     <LastName>Day</LastName>
  57.     <StreetAddress>4828 Cherry St.</StreetAddress>
  58.     <City>Nanticoke</City>
  59.     <State>SC</State>
  60.     <Zip>89130</Zip>
  61.     <Email>HaleHale8026@mail.com</Email>
  62.     <Phone>425-765-4520</Phone>
  63.   </Order>
  64.   <Order>
  65.     <Date>9/4/1994</Date>
  66.     <TrackingNumber>1Z 984 389 71 3082 634 2</TrackingNumber>
  67.     <FirstName>Silas </FirstName>
  68.     <LastName>Allison</LastName>
  69.     <StreetAddress>2778 Gray Ave.</StreetAddress>
  70.     <City>Auburn</City>
  71.     <State>CT</State>
  72.     <Zip>22319</Zip>
  73.     <Email>ConradSbBTJ@hotmail.com</Email>
  74.     <Phone>530-987-6383</Phone>
  75.   </Order>
  76. [...]
  77.  
  78.   <Payroll>
  79.     <PhoneNumber>971-258-5703</PhoneNumber>
  80.     <AltPhoneNumber>501-769-1331</AltPhoneNumber>
  81.     <FirstName>Xyla </FirstName>
  82.     <LastName>Hoover</LastName>
  83.     <EmployeeID>499</EmployeeID>
  84.     <HireDate>5/28/2011</HireDate>
  85.     <Birthdate>5/28/1990</Birthdate>
  86.     <SSN>520-52-4275</SSN>
  87.     <AccountNumber>5696618825</AccountNumber>
  88.     <RoutingNumber>575159859</RoutingNumber>
  89.     <Address>8348 Court Ave.</Address>
  90.     <City>Pittsburgh,</City>
  91.     <State>PA.</State>
  92.     <Zip>15201</Zip>
  93.   </Payroll>
  94.   <Payroll>
  95.     <PhoneNumber>949-687-5927</PhoneNumber>
  96.     <AltPhoneNumber>214-654-1254</AltPhoneNumber>
  97.     <FirstName>Stella </FirstName>
  98.     <LastName>Rasmussen</LastName>
  99.     <EmployeeID>501</EmployeeID>
  100.     <HireDate>11/18/2011</HireDate>
  101.     <Birthdate>6/18/1956</Birthdate>
  102.     <SSN>839-76-4789</SSN>
  103.     <AccountNumber>5349161343</AccountNumber>
  104.     <RoutingNumber>665726659</RoutingNumber>
  105.     <Address>4052 Valley View Dr.</Address>
  106.     <City>Pittsburgh,</City>
  107.     <State>PA.</State>
  108.     <Zip>15201</Zip>
  109.   </Payroll>
  110. [...]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement