DATABASE Authentic Israel - Travel Database Breached, Leaked - Download

Quote:`participantId` bigint(20) NOT NULL AUTO_INCREMENT,

`orderId` bigint(20) NOT NULL,
`firstName` varchar(45) NOT NULL,
`lastName` varchar(45) NOT NULL,
`phone1` varchar(45) DEFAULT NULL,
`phone2` varchar(45) DEFAULT NULL,
`dateOfBirth` varchar(45) DEFAULT NULL,
`email` varchar(45) DEFAULT NULL,
`passn` varchar(45) DEFAULT NULL,
`passcount` varchar(45) DEFAULT NULL,
`medicalNotes` text,
`medicalInsuranceStartDate` varchar(45) DEFAULT NULL,
`medicalInsuranceEndDate` varchar(45) DEFAULT NULL,
`arrivalFlightInfo` bigint(20) DEFAULT NULL,
`departureFlightInfo` bigint(20) DEFAULT NULL,
`dietaryNotes` varchar(255) DEFAULT NULL,
`gender` varchar(255) DEFAULT NULL,
`medicalInsurancePolicyNo` varchar(255) DEFAULT NULL,
`waiverDate` int(11) DEFAULT NULL,
`waiverSignature` varchar(9000) DEFAULT NULL,
PRIMARY KEY (`participantId`)
) ENGINE=InnoDB AUTO_INCREMENT=2043 DEFAULT CHARSET=utf8;​

Click to expand...

Quote: `applicationId` bigint(20) NOT NULL AUTO_INCREMENT,

`buyer` text CHARACTER SET latin1,
`buyerId` bigint(20) DEFAULT NULL,
`paid` double DEFAULT '0',
`totalToPay` double DEFAULT '0',
`participants` text CHARACTER SET latin1,
`mailing` text,
`emergency` text,
`trip` text CHARACTER SET latin1,
`period` text,
`periodId` bigint(20) DEFAULT NULL,
`periodStart` int(11) DEFAULT NULL,
`periodEnd` int(11) DEFAULT NULL,
`periodPrice` double NOT NULL DEFAULT '0',
`discounts` text CHARACTER SET latin1,
`discountsPrice` double NOT NULL DEFAULT '0',
`insurance` varchar(100) DEFAULT NULL,
`insuranceType` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
`otherTravelCost` double NOT NULL DEFAULT '0',
`insurancePrice` double NOT NULL DEFAULT '0',
`options` text CHARACTER SET latin1,
`roomingNotes` text,
`programNotes` text,
`createdOn` int(11) NOT NULL,
`status` varchar(255) NOT NULL DEFAULT 'Created',
`authorizeCustomerId` bigint(20) DEFAULT NULL,
`authorizePaymentId` bigint(20) DEFAULT NULL,
`signature` varchar(9000) DEFAULT NULL,
`refer` varchar(255) DEFAULT NULL,
`signame` varchar(255) DEFAULT NULL,
`tier` varchar(255) DEFAULT '{}',
`tierId` bigint(20) DEFAULT '0',
`tierCost` float DEFAULT '0',
PRIMARY KEY (`applicationId`)​

Click to expand...

e7cff27e2e5175e42128524f087f8d9b',1544544857,NULL,'Active','4c57893b9fd26251c8b28256fa303b69','\0','55da972ac81a1a69d122ccbde213f74f'),(2052,'marcigelman@comcast.net','4db68329603cc7f9b540ff775aa624ca56522b361e167bfd9802d324cd4822b1','afc3173f672bfd114c89f76cfe1d8252',1544545546,NULL,'Active','3eb49544491effeeacd7268a1b16d80c','\0',NULL),(2053,'bonnie@yahoo.com','488203076ab13451165e6bf54f6531311b6296e0fe28a4cd6494cdb6fd2b97d3','bf43e4cbd256654261a347b4e2d68801',1544546810,NULL,'Active','563f99675526721845b407a525216ceb','\0',NULL),(2054,'TEMP5c0ff362bba87','cf2a54e5fb5a88280240013582ce440b33b079a32541a9115495baf35b059577','80bbec64a3ade40b095b4a61fb4ed3c9',1544549218,NULL,'Active','fca69385b63566e52068fe9022b1d47c','\0','62452ffb206a5a2a8a6bc03c0435d461'),(2057,'jannammeyers@gmail.com','be4fe76946bde746a5fe917dcd75b199299edbd403c496d0cb37bce4cabf678b','9107ebdc73a2b32855a5896a2faddbdc',1544563900,NULL,'Active','3d99d05449721d892eb291488f985cf6','\0',NULL),(2058,'shoshanalevy76@yahoo.com','b85d3ba22e0bcd4c0c9e46ac2631030aa7612ff3413ade9075cce421b61d490a','bf0cf93117c65a853fba4582fdf34a30',1544568293,NULL,'Active','0ad5b131693beafa2a2b12dbaba20d8c','\0',''),(2059,'TEMP5c103404716e1','3f11756b1a393f3bb0c39a2a357013a83971642f951517a3828f257ff6620c94','b45689f60e3162dc3298448b09f57399',1544565764,NULL,'Active','d5af6f348a9659611c821600b51f3aae','\0','c0a02791cb26b936260b828ef92bf286'),(2060,'xyz@gmail.com','17b4cd852e5db24ee5a0b75d85ae68622f4f850beeae1022509de0373b46b386','2fcc7d5949743e6880bf275f0aa4a2a5',1544567486,NULL,'Active','6aa807ded3b8337fd5913c758cb1a09b','\0',NULL),(2061,'TEMP5c103dc39b147','b8c0ba7152e3ca0dfe68f23553912846d5e4a1d88153c5bf042f4f5bcb271368','e9282c2992c6a52851becc80ae36dbeb',1544568259,NULL,'Active','552395223aa438961e983bfa765ffd16','\0','b78a51325df6ce192e5a23202519a688'),(2062,'TEMP5c1043db6100f','016c04917e6ccc5e453751be2d1f78c03db6108c7dff69b8adb78460e3a959a8','979e82fe8ed6f3d192ea22e0540b1411',1544569819,NULL,'Active','8d693c341b8e84bbc403f54bcbe31454','\0','8dc40465e92af610a1bbef47b14e8570'),(2063,'TEMP5c1047b9c7061','a9cbb2f0b2d4373be6f2fe1c1cf812d594896a6ff249da83ba10700929c29a33','721371a39f17dd027d4ea9835d6b4b91',1544570809,NULL,'Active','4203501577dab6c0a23aede0caa959c4','\0','ebea922e8b06890dba68aac56b98a6c1'),(2064,'TEMP5c1047cfe4244','267be5d3684d45ebe947f0f49bc05951c51bd84596a986965950470b65c7d9f4','9ab1acd60d002e912135dbf1d4026ba3',1544570831,NULL,'Active','1b7509db7e1a5c3155103c8d00881c0b','\0','70aa572b82622a07408779d538f0a4c1'),(2065,'TEMP5c104c1c8c906','1bd4808322c44f62a496ae9de7064baf7923156dbc01f203de8d29206535bece','e6f017e8809750ea172699cb1223525e',1544571932,NULL,'Active','eda5dc5353f4a0d140798d8480c663a6','\0','2927af87035ebb8c9dcf46f067a269a6'),(2068,'TEMP5c105c679055d','47596603646a6810b9e7e06a1f4bb62f5c7bcd9ee10071863d759bdade196ea5','82c6664cefa82a41b8fc912c0ecff4ef',1544576103,NULL,'Active','b8be06f5947ce9b98647091db29068e7','\0','d94122069ba62c60b03bc729c482265c'),(2069,'TEMP5c10ac6beae8e','c8a79d812a4a18429d3c3d96e52802f5dd3761b50ab5d63e2a2134afbb802e24','43985f32297de2d8c74d545cc5521049',1544596587,NULL,'Active','2b82dae63f7a0582fe1dfef7a7ea65e7','\0','a9b76a3949525a375cda219bc61d5ac9'),(2070,'TEMP5c10dcad9ca4c','7dcccd7cd0b205948299539e884d985187d22cb1fb15aaf3e12d338f4b0895e2','f5c7cbb59873398a0b590d760db146cf',1544608941,NULL,'Active','8a21d849b6428ce9c7f81dcff387c02c','\0','e98876a3f7a69f821ac018f563e5ddd5'),(2071,'drlrl@aol.com','7d6b7985d29e2bfb1c14b948dd799adb31007709adb9b6076cbfa71d58b5b14d','57e15a57051a23dd3be481f6b782b293',1544638128,1544715613,'Active','1f90ade2d1db1a9a7ecd18011ef2ab42','\0',NULL),(2072,'TEMP5c1154ebea14e','43c55fa213e173a3fca87808f01c86f7f86ee167096caf2b0f0ab429a4305543','92770437afb94fe67abe6b782746002b',1544639723,NULL,'Active','d6858deb8653e5a0137576faf9e7956c','\0','d13e676750c6fdf345482bbb6bc7eec3'),(2073,'TEMP5c1180cb44bd0','f6149dc59b7994b3e495b643c02edc34e9449d571a7651cba12bb020eaae3fe7','cb8f8129ddec63d3cb7a3a34c1bcdbe7',1544650955,NULL,'Active','da5170d28f8254e2648fe829ed7ac1ce','\0','389f411602f37288eaa050a9a2204018'),(2074,'TEMP5c1180df13798','1530442161ba81a6d80553fb4ec563bb1361c4e1dd60711ef0c0d91bad34126d','7d5945af790c65af98e0facc7b878261',1544650975,NULL,'Active','3edc4af90f2a2c6520ffcebe141c442c','\0','98e6fe34276225bbcabcbdf2a337651e'),(2075,'TEMP5c118887d4592','3a8fad5be8fb4e4b044e8160dd606f5ae2af5ed305710c19f4097043bea5b8fa','0ae3b7ff3b51d63a1f9d49efecf5c09a',1544652935,NULL,'Active','1e89d4e4f3b176bb7924c5c5d035fbef','\0','48cc4f65b334516ee594204eadd84549'),(2076,'TEMP5c1193ceafb04','d1d60e44457db3fc2a29c2b1ee3b0867a4b3d67e34c061d5a1f0a22b3f3dd20f','00dc5fe66e01b537fac2a23199c384dd',1544655822,NULL,'Active','83fc4b56da7ae298a57b99d12eceab38','\0','1db383ac4894303a965f3c0ce83e4ef6'),(2077,'TEMP5c119649e0a4a','9dc216ff15a818f0b86af70dd7c4fbc9be3254d2bc64a2f026f2550f13424af6','f7526a689578e16af45ef5f6d9fbb8d0',1544656457,NULL,'Active','3ead486aaad6ffb8bbed605568669fa4','\0','5d1afdc5be1a21984750b261d5684c50'),(2078,'TEMP5c119c9c24744','57d8defd014d8716f728f71715611edf6a8f5263f6f38c696356211a79f0ba0d','349cbeccf82071db8c8a4d8337972fc1',1544658076,NULL,'Active','3301296983542e4500ad217289366588','\0','f1d8691e35139f3320e52caf78282de6'),(2079,'TEMP5c119ca24bcdd','deee5256940850dd043b86333d1f35e520783cd82f1a6af913dd1d89da44bde2','79a42d5c56a71fd7b4f1650b4014002d',1544658082,NULL,'Active','a1797c00ff50add660e668f16b936103','\0','36ec08a499afa32285cca37e56416afe'),(2080,'TEMP5c11a17ea2b80','2f107cca2fe9e292da5af2b9e73f6d7d3a2561327e3adad9e3c9a726831d8299','03483187c1d37746c8d72759ef3a19e7',1544659326,NULL,'Active','304121e6cc2cf89c8ed2a8b7df4f657c','\0','48cc4f65b334516ee594204eadd84549'),(2081,'TEMP5c11c0acf33aa','1436b2454fcddb0d66bd6c8f68f3d4d58f0d8f36675cd472b7cffdab1251783c','1ca9468eed0356301da843d4629269e1',1544667308,NULL,'Active','3ee21450da3db6a72afa8d4322e421e7','\0','23f1ce905d178989c7a07cdfc12932e6'),(2082,'TEMP5c11c194394e3','e9d85f413cedcf50c221c96f8b9c45a7bcb567d372697f8125cd52948a93f9f6','df8b449bed7eda50a5076677d8035434',1544667540,NULL,'Active','2386d8e9971ac20f156796bb8aeac017','\0','ef1a377c432ba0cbd9558b5cb7199087'),(2083,'beverly.azarchi@gmail.com','6bbadf1cbe6702a49e524e1d44f0857455c9e83973b3752b8d2111a34fe1c0c7','4083ee01127117b4829f44b71731aaf6',1544668506,NULL,'Active','700f2931b95d23c7ae4fa686d2c2119a','\0',NULL),(2084,'TEMP5c11d8329fbad','1d6648c59b6a1bc64be5d5cd0941a11f9c7498d4058548563e240894880afe1d','8e2bd37dc1d9dd9b6f0abed9f8e7e7b2',1544673330,NULL,'Active','17a4c8888f60be51320dab2ac3de9c02','\0','662663d90ba71272e84d0db4117a71b7'),(2085,'TEMP5c122e1f49a23','bea4eee4f6111b60fda9b5c6443894118371197b495a51c92447dec11754e14d','de018f55924934b78f0df4a774b2bba3',1544695327,NULL,'Active','a9a8062a2dd7406361b08884252ab749','\0','03a84dbaba4d13ccfaa54d81fab0c037'),(2086,'susielee1@comcast.net','d7c5e6c8bfa0f163a24313e662b357548329615e60d094bb9849f2e583cc4765','c2d38023801a99a36b9b13fae45cd1ae',1544696265,NULL,'Active','5afd0f438c1f9b81da1aa3c8d7615e1b','\0',''),(2087,'ronskillian@comcast.net','91d53d130e4d807dda05a675a36738fcc8a755d521c7d7a477005a3876f47b1c','8f2ea4bfea56a3a65329bc4f04319144',1544708051,NULL,'Active','f7949dc926fa74168b6f59cb6ca5c5f2','\0',''),(2088,'lfm2466@gmail.com','29df73b36f6142ac7fc0be173a3cf38dd321ef54e6081b53139b1c6f07b8019e','331a28f79effe2a849a7738e807188c6',1544708674,NULL,'Active','3d25802ca429ab68a7ec4b585cb443cd','\0',NULL),(2089,'scjrgold@aol.com','c4a9860b2b8a75d41a38713a9e4d1c1b33fb366335084f4251217fedfc76fea2',

Click to expand...