03-27-2026, 04:29 AM
cipsaintlucia.com leak
Saint Lucia Citizenship by Investment Programme
format: sql
date: Mar 08, 2026
all rows: 1,116,935
leaked by me
all emails: about 270
SAMPLE
Saint Lucia Citizenship by Investment Programme
format: sql
date: Mar 08, 2026
all rows: 1,116,935
leaked by me
all emails: about 270
SAMPLE
INSERT INTO `users` (`id`, `parent_id`, `username`, `password`, `first_name`, `last_name`, `path`, `professional_artistic_name`, `date_of_birth`, `gender`, `registrant_type_id`, `company`, `address_line_1`, `address_line_2`, `city`, `state_province`, `zip_postal_code`, `country_id`, `district_id`, `mailing_address_line_1`, `mailin_address_line_2`, `mailing_city`, `mailing_state_province`, `mailing_zip_postal_code`, `mailing_country_id`, `phone`, `mobile`, `email`, `website`, `birth_certificate_number`, `national_identification_number`, `passport_number`, `drivers_permit_number`, `active`, `banned`, `created`, `modified`, `created_by`, `modified_by`, `group_id`, `full_group_access`, `is_approval_authority`, `temp_reset_val`, `agent_license_number`, `agent_number`, `disable_application_submit`) VALUES
(8, 0, 'vivianblanchard', '8e0da7016e988cd53725c515764cbb99fcc83cb7', 'Vivian', 'Blanchard', NULL, NULL, '0000-00-00', 'm', 0, NULL, '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'vblanchard@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2014-09-18 11:55:42', '2017-09-28 14:11:54', 0, NULL, 6, NULL, NULL, '4924095249', NULL, NULL, 0),
(40, 0, 'robinschoutensuperadmin', '8e0da7016e988cd53725c515764cbb99fcc83cb7', 'Robin', 'Schouten', NULL, NULL, '0000-00-00', 'm', 0, NULL, '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'robin.schouten@gmail.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2015-05-07 21:06:21', '2017-09-28 14:12:27', 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0),
(118, 0, 'neal_star99', '8e0da7016e988cd53725c515764cbb99fcc83cb7', 'Neal', 'George', NULL, NULL, '0000-00-00', 'm', 0, NULL, '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'neal_star99@live.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2015-09-29 11:41:40', '2017-09-28 14:17:56', 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, 0),
(121, 0, 'jeanmalwilson', '8e0da7016e988cd53725c515764cbb99fcc83cb7', 'Jeanmal', 'Wilson', NULL, NULL, '0000-00-00', 'm', 0, NULL, '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'jwilson@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2015-10-14 07:40:19', '2017-09-28 14:13:35', 0, NULL, 6, NULL, NULL, '8173459020', NULL, NULL, 0),
(136, 0, 'citizenship_services', '53fa95e5b54e7351ab6d2f01973fd3d5a42876f0', 'Diana', 'Thomas', NULL, NULL, '0000-00-00', 'm', 0, 'Armored Global Inc.', '99 Chaussee Road', '', 'Castries', NULL, NULL, 0, NULL, 'P.O. Box CP5801, Conway Post Office', NULL, 'Castries', '', '', 0, '(758) 452-1152', '(758) 285-8586', 'd.thomas@detervillethomas.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-07 08:36:27', '2025-05-16 09:58:12', 0, NULL, 7, NULL, NULL, NULL, 'AA01CS071215 ', '7DI070116', 1),
(137, 0, 'mc_citizenship_services', 'cb2437a83b20960f4a21a0fa5bf1cf6c4b972a54', 'Jonathan', 'McNamara', NULL, NULL, '0000-00-00', 'm', 0, 'McNamara Citizenship Services Inc.', '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'jonathan@mcnamara.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-07 08:37:32', '2025-05-16 10:05:24', 0, NULL, 7, NULL, NULL, NULL, 'AA02MC081215 ', '8JO070116', 1),
(138, 0, 'century_capital', 'eb6520ab14c5c8039a192c5898bbd0a259164418', 'CENTURY', 'CAPITAL', NULL, NULL, '0000-00-00', 'm', 0, 'Century Capital Inc.', 'Suite # 2, Rodney Bayside Building, Rodney Bay', 'Gros-Islet', 'Castries', NULL, NULL, 0, NULL, 'P.O.Box BW 357, Rodney Bay ', NULL, 'Castries', '', '', 0, '453 7777 / 453 7007 ', '7584844954', 'info@century.capital', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-07 08:38:18', '2025-05-16 10:02:23', 0, NULL, 7, NULL, NULL, NULL, 'AA03CC081215', '9MA070116', 1),
(139, 0, 'tm_antoine_partners', 'a939eef794c81a5fea317b0c68d87a564928cd50', 'Thaddeus', 'Antoine', NULL, NULL, '0000-00-00', 'm', 0, 'TM ANTOINE Partners Advisory Inc.', 'Suite 1, NAPA Building ', 'John Compton Highway', 'Castries ', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '1-758-453-2000', '1758-718-7200 ', 'cip@tmantoinelaw.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-07 08:39:22', '2025-05-16 10:05:16', 0, NULL, 7, NULL, NULL, NULL, 'AA04TM091215 ', '10TH070116', 1),
(140, 0, 'citizenship_investment', 'ae2b5de335a1b8198ae77bd10078827995f038ea', 'Peter', 'Foster', NULL, NULL, '0000-00-00', 'm', 0, 'Foster Citizenship Corporation', 'Robin Kelton Building,', 'Choc Bay,', 'Castries', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '453-1100', '', 'peter@piflaw.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-07 08:40:16', '2025-05-16 10:05:31', 0, NULL, 7, NULL, NULL, NULL, 'AA05CI171215 ', '11PE070116', 1),
(142, 0, 'kjeanbaptiste', '3041d5a1302bd76a10806917e6e6521c448ac828', 'Krystal', 'Jean Baptiste', NULL, NULL, '0000-00-00', 'f', 0, 'CIP Saint Lucia', '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'kjeanbaptiste@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-12 14:00:41', '2018-07-27 17:58:03', 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, 0),
(143, 0, 'cjoseph', 'a08a89ceb2f4b422d4b6399cec7793ebd3392836', 'Chameil', 'Joseph', NULL, NULL, '0000-00-00', 'f', 0, 'CIP', '', '', 'Castries', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'aedmund@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-12 14:03:02', '2024-01-05 12:03:18', 0, NULL, 11, NULL, NULL, NULL, NULL, NULL, 0),
(144, 0, 'rmclelland', '3041d5a1302bd76a10806917e6e6521c448ac828', 'Ronan', 'McLelland', NULL, NULL, '0000-00-00', 'm', 0, 'Citizenship By Investment Unit', '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'rmclelland@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 1, 0, '2016-01-12 14:04:56', '2019-08-09 14:42:13', 0, NULL, 9, NULL, NULL, NULL, NULL, NULL, 0),
(145, 0, 'lfrancis', 'e7d19e9013d9b25142c8c091350655ec1fbfe216', 'Leo', 'Francis', NULL, NULL, '0000-00-00', 'm', 0, 'Citizenship By Investment Unit', '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'lfrancis@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 1, 0, '2016-01-12 14:06:04', '2021-04-18 21:22:37', 0, NULL, 10, 2, NULL, NULL, NULL, NULL, 0),
(146, 0, 'miro_kjeanbaptiste', '2c275ddd3e04c01f44e0c12bde48071b28896486', 'Krystal', 'Jean Baptiste', NULL, NULL, '0000-00-00', 'f', 0, NULL, '', '', '', NULL, NULL, 0, NULL, '', NULL, '', '', '', 0, '', '', 'kjeanbaptiste@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-01-12 14:08:01', '2018-01-24 13:43:19', 0, NULL, 13, NULL, NULL, NULL, NULL, NULL, 0),
INSERT INTO `applications` (`id`, `title`, `ref_number`, `first_name`, `last_name`, `date_of_birth`, `description`, `doc_path`, `enabled`, `created`, `modified`, `status_id`, `agent_id`, `banker_id`, `co_id`, `acc_id`, `ddo_id`, `ceo_id`, `co_notes`, `ceo_notes`, `ddo_notes`, `proof_of_payment_path`, `document_checklist_path`, `authorized_agent_form_path`, `alternative_citizenship_path`, `confirmation_form_path`, `registration_application_path`, `birth_record_path`, `name_change_path`, `citizenship_certificate_path`, `residence_card_path`, `military_records_path`, `photograph_certificate_path`, `national_id_path`, `current_passport_pages_path`, `proof_of_residence_path`, `marriage_certificate_path`, `divorce_decree_path`, `curriculum_vitae_path`, `professional_reference_path`, `bank_reference_path`, `sworn_affidavit_financial_path`, `sworn_affidavit_spouse_path`, `academic_certificates_path`, `police_certificates_path`, `visas_path`, `medical_examiner_declaration_path`, `official_transcripts_path`, `custody_records_path`, `statutory_declaration_path`, `copy_of_parent_id_path`, `passport_sized_photos_path`, `type_of_applicant`, `type_of_investment`, `enterprise_project_option`, `draft`, `principal_applicant_id`, `citizenship_certificate_id`, `submit_date`, `closed`, `region`, `closing_notes`, `acc_notes`, `ddo_assessment_path`, `ceo_assessment_path`, `co_assessment_path`, `investment_amount`, `spouse`, `qualifying_dependents`, `proof_of_investment_transferred_path`, `ceo_notes_for_agent`, `ceo_agent_notes`, `co_agent_notes`, `agent_request_review_notes`, `country_id`, `accepted_for_processing_date`, `proof_of_investment_path`, `agent_investment_notes`, `certified_copy_professional_certificate_medical_examiner_path`, `net_worth_document_support_path`, `professional_certificate_translator_path`, `apostille_path`, `professional_certificate_notary_path`, `professional_certificate_attorney_path`, `professional_certificate_oaths_commisioner_path`, `source_of_funds_path`, `source_of_funds_docs_sent_date`, `processing_fee_received_date`, `request_review_path`, `preprocess`, `preprocess_law_enforcement_docs_sent_date`, `proceed_due_diligence`, `proceed_due_diligence_docs_sent_date`, `addon`, `processing_fees_received_date`) VALUES
(13, '', '10T3N00008P', 'Lalit', 'Modi', NULL, '', '', NULL, '2016-03-07 12:47:23', '2019-11-05 11:00:57', 8, 139, NULL, 147, 145, 144, 212, '', 'Original notification letter may be collected from the offices of the Citizenship by Investment Unit', '', 'application/files/AA200139/Payment to Citizenship by Investment.jpg', 'application/files/AA200139/V2-DocumentCheckList SL1 - LALIT MODI.pdf', 'application/files/AA200139/Use_of_Authorised_Agent_Form_SL2_Lalit_Kumar_Modi.PDF', 'application/files/AA200139/Statement_of_Alternative_Citizenship_SL3_Lalit_Kumar_Modi.PDF', 'application/files/AA200139/Investment_Confirmation_Form_SL4_Lalit_Kumar_Modi.PDF', 'application/files/AA200139/Application_for_Saint_Lucia-Citizenship_SL5_Lalit_Kumar_Modi.PDF', 'application/files/AA200139/Birth_Certificate_Lalit_kumar_Modi.PDF', NULL, NULL, 'application/files/AA200139/Residence_Permit_Lalit_Kumar_Modi.PDF', NULL, 'application/files/AA200139/Photograph_Signature_Certificate_SL6_Lalit-Kumar_Modi.pdf', NULL, 'application/files/AA200139/Passport_Lalit_Kumar_Modi.pdf', 'application/files/AA200139/Utility_Bill_Lalit_Kumar_Modi.pdf', 'application/files/AA200139/Marriage_Certificate_Lalit_Kumar_Modi.PDF', NULL, 'application/files/AA200139/CV_Lalit_Kumar_Modi.PDF', 'application/files/AA200139/Character_Reference_Lalit_Kumar_Modi.pdf', 'application/files/AA200139/Bank_Letter_Lalit_Kumar_Modi.PDF', 'application/files/AA200139/Affidavit_of_Declaration_SL7_Lalit_Kumar_Modi.pdf', 'application/files/AA200139/Affidavit_of_Support-SL8_Lalit_Kumar_Modi.pdf', 'application/files/AA200139/Supporting_Documents_Cetificates.pdf', 'application/files/AA200139/Police_Certificate_Lalit_Kumar_Modi.PDF', '', 'application/files/AA200139/Medical_Examiner_Details_Declaration_SL9_Lalit_Kumar_Modi.PDF', '', '', '', '', 'application/files/AA200139/img-160308121754.pdf', 'principal_applicant', 'national_economic_fund', '', 0, NULL, '', '2016-03-09 15:29:30', NULL, 'asia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 183, '2016-05-05 15:14:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(14, '', '10T3N00008Q1', 'Ruchir', 'Modi', NULL, '', '', NULL, '2016-03-07 14:42:43', '2017-01-16 10:36:45', 8, 139, NULL, 143, 145, 144, 184, '', '', '', '', 'application/files/AA200139/V2-DocumentCheckList SL1 - RUCHIR MODI.pdf', '', '', '', 'application/files/AA200139/Application_for_Saint_Lucia_Citizenship_SL5_Ruchir_Modi(2).PDF', 'application/files/AA200139/Birth_Certificate_Ruchir_Modi(2).PDF', NULL, NULL, 'application/files/AA200139/Residence_permit_card_Ruchir_Modi(2).pdf', NULL, 'application/files/AA200139/Photograph_Signature_Certificate_Ruchir_Modi(2).PDF', NULL, 'application/files/AA200139/Passport_Ruchir_Modi(2).PDF', '', NULL, NULL, 'application/files/AA200139/Curriculum_Vitae_Ruchir_Modi(2).PDF', '', '', '', '', 'application/files/AA200139/American_School_of_Bombay_Official_Transcript_Ruchir_Modi_1(2).PDF', 'application/files/AA200139/Police_certificate_Ruchir_Modi(2).PDF', '', 'application/files/AA200139/Medical_Examiner_Details_Declaration_SL9_Ruchir_Modi(2).PDF', 'application/files/AA200139/American_School_of_Bombay_Official_Transcript_Ruchir_Modi_2.PDF', '', '', '', 'application/files/AA200139/143507(2).PDF', 'qualifying_dependant', 'national_economic_fund', '', 0, NULL, NULL, '2016-03-09 15:29:45', NULL, 'asia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 183, '2016-05-05 15:15:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(15, '', '10T3N00008S', 'Minalani', 'Modi', NULL, '', '', NULL, '2016-03-07 15:15:48', '2017-01-16 10:36:58', 8, 139, NULL, 143, 145, 144, 184, '', '', 'I have uploaded the police report for Mr. L Modi to this part of the case. ', '', 'application/files/AA200139/V2-DocumentCheckList SL1 - MINALANI MODI.pdf', '', '', '', 'application/files/AA200139/Application_for_Saint_Lucia_Citizenship_SL5_Minalani_Modi.PDF', 'application/files/AA200139/Birth_Certificate_Minalani_Modi.PDF', NULL, NULL, 'application/files/AA200139/Resident_Card-Minalani_Modi.PDF', NULL, 'application/files/AA200139/Photograph_Signature_Certificate_SL6_Minalani_Modi.PDF', NULL, 'application/files/AA200139/Passport_Minalani_Modi.PDF', '', 'application/files/AA200139/Marriage_Certificate_.PDF', 'application/files/AA200139/Divorce_Certificate_Minalani_Modi.PDF', 'application/files/AA200139/Curriculum_Vitae_Minalani_Modi.PDF', '', '', '', '', 'application/files/AA200139/Supporting_Documents_Cetificates(1).pdf', 'application/files/AA200139/Police_Certificate_Minalani_Modi.PDF', '', 'application/files/AA200139/Medical_Examiner_Details_Declaration_SL9_Minalani_Modi.PDF', '', '', '', '', 'application/files/AA200139/145230.PDF', 'spouse', 'national_economic_fund', '', 0, NULL, NULL, '2016-03-09 15:30:10', NULL, 'asia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 183, '2016-05-05 15:15:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(16, '', '10T3N00008Q2', 'Aliya', 'Modi', NULL, '', '', NULL, '2016-03-07 15:31:07', '2023-11-01 14:36:43', 2, 139, NULL, 143, 145, 144, 184, 'Please note that the application of Aliya Modi cannot proceed further because it is non-compliant with the definition of qualifying dependent as per the Citizenship by Investment Act.\r\n\r\nie ''''a child of the applicant or of his or her spouse who is no more than twenty five years of age, who is fully supported by the applicant and is in full time attendance at a recognized institution of higher learning.''''\r\n\r\nAliya Modi was undertaking a Certificate Course in Interior Design which started on 7th January , 2016 and ended on 22nd March 2016 (12 days after initial submission of the application) .From the date of receipt of the addendum documents, 25th April , 2016 Aliya Modi is no longer a full time student. \r\n', '', NULL, '', 'application/files/AA200139/V2-DocumentCheckList SL1- ALIYA MODI.pdf', '', '', '', 'application/files/AA200139/Application_for_Saint_Lucia_Citizenship_SL5_Aliya_Modi.PDF', 'application/files/AA200139/Birth_Certificate_Aliya_Modi.PDF', NULL, NULL, '', NULL, 'application/files/AA200139/Photograph_Signature_Certificate_SL6_Aliya_Modi.PDF', NULL, 'application/files/AA200139/Passport_Aliya_Modi.PDF', '', NULL, NULL, 'application/files/AA200139/Curriculum_Vitae_Aliya_Modi.PDF', '', '', '', '', 'application/files/AA200139/Academic _Certificate_Aliya_Modi.PDF', 'application/files/AA200139/Police_Certificate_Aliya_Modi.PDF', '', 'application/files/AA200139/Medical_Examiner_Details_Declaration_SL9_Aliya_Modi.PDF', 'application/files/AA200139/Letter_of_confirmation_Aliya_Modi.PDF', '', '', '', 'application/files/AA200139/144933.PDF', 'qualifying_dependant', 'national_economic_fund', '', 0, NULL, NULL, '2016-03-09 15:30:46', NULL, 'asia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 183, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(19, '', '10T1N00009P', 'Salim', 'Chidiac', NULL, '', '', NULL, '2016-03-11 10:40:04', '2019-11-05 10:20:36', 11, 139, NULL, 147, 145, 144, 212, '', 'Due Diligence Background Check expected to take twenty working days at least given the challenges faced in the two jurisdictions being considered. \r\n\r\nOriginal notification letter may be collected from the offices of the Citizenship by Investment Unit', '', 'application/files/AA200139/Proof_of_payment_Salim_Chidiac.PDF', 'application/files/AA200139/V2-DocumentCheckList SL1.pdf', 'application/files/AA200139/Use_of_Authorised_Agent_Form_SL2_Salim_Chidiac.pdf', 'application/files/AA200139/Statement_of_Alternative_Citizenship_Salim_Chidiac.pdf', 'application/files/AA200139/Investment_Confirmation_Form_SL4_Salim_Chidiac.pdf', 'application/files/AA200139/Application_for_Saint_Lucia_Citizenship_SL5_Salim_Chidiac.pdf', 'application/files/AA200139/Birth_Certificate_Salim_Chidiac.pdf', NULL, NULL, '', NULL, 'application/files/AA200139/Photograph_Signature_Certificate_SL6_Salim_Chidiac.pdf', NULL, 'application/files/AA200139/Passport_Salim_Chidiac.pdf', 'application/files/AA200139/Proof_of_Address_Salim_Chidiac.pdf', NULL, NULL, 'application/files/AA200139/Curriculum_Vitae_Salim_Chidiac.pdf', 'application/files/AA200139/Reference_Letter_Salim_Chidiac.pdf', 'application/files/AA200139/Bank_Reference_Letter_Salim_Chidiac.pdf', 'application/files/AA200139/Affidavit-of_Decelaration_Sl7_Salim_Chidiac.pdf', 'application/files/AA200139/Affidavit_of_Support_SL8_Salim_Chidiac.pdf', 'application/files/AA200139/Academic_Certificate_Salim_Chidiac.pdf', 'application/files/AA200139/Police_Certificate_Salim_Chidiac.pdf', '', 'application/files/AA200139/Medical_Examiner_Details_Declaration_SL9_Salim_Chidiac.pdf', '', '', '', '', 'application/files/AA200139/Photo.pdf', 'principal_applicant', 'national_economic_fund', '', 0, NULL, '00362016', '2016-03-14 13:09:29', NULL, 'mena', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 128, '2016-05-03 15:16:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(21, '', '2G00004P', 'Dmytro', 'Shevkoplyas', NULL, '', '', NULL, '2016-05-04 14:39:49', '2020-01-07 15:15:55', 2, 149, NULL, 143, 145, 144, 184, NULL, '', NULL, 'application/files/AA200149/Proof of payment.PDF', 'application/files/AA200149/SL 1.PDF', 'application/files/AA200149/SL 2.PDF', 'application/files/AA200149/SL 3.PDF', 'application/files/AA200149/SL 4.PDF', 'application/files/AA200149/SL 5.PDF', 'application/files/AA200149/Birth Certificate.pdf', NULL, NULL, '', NULL, 'application/files/AA200149/SL 6(1).pdf', NULL, 'application/files/AA200149/Passports.PDF', 'application/files/AA200149/Utility Bill(1).PDF', 'application/files/AA200149/Marriage Certificate(1).pdf', 'application/files/AA200149/Passport- Divorce Decree.PDF', 'application/files/AA200149/CV.PDF', 'application/files/AA200149/Professional Reference.PDF', 'application/files/AA200149/Proof of Net Worth.PDF', 'application/files/AA200149/SL 7.PDF', 'application/files/AA200149/SL 8.PDF', '', 'application/files/AA200149/Police Certificate of Character.pdf', 'application/files/AA200149/Visa.PDF', 'application/files/AA200149/SL 9final.pdf', '', '', '', '', 'application/files/AA200149/Passport Pics(1).pdf', 'principal_applicant', 'government_bonds', '', 0, NULL, NULL, '2016-05-06 10:46:06', NULL, 'russia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 181, NULL, NULL, NULL, NULL, 'application/files/AA200149/Proof of Net Worth(1).PDF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(22, '', '2G00005P', 'Dmytro ', 'Shevkoplyas', NULL, '', '', NULL, '2016-05-09 11:41:53', '2019-09-24 17:05:56', 11, 149, NULL, 147, 145, 144, 207, '', '', '', 'application/files/AA200149/Proof of payment(2).PDF', 'application/files/AA200149/SL 1(2).PDF', 'application/files/AA200149/SL 2(2).PDF', 'application/files/AA200149/SL 3(2).PDF', 'application/files/AA200149/SL 4(2).PDF', 'application/files/AA200149/SL 5(2).PDF', 'application/files/AA200149/Birth Certificate(2).pdf', NULL, NULL, '', NULL, 'application/files/AA200149/SL 6(3).pdf', NULL, 'application/files/AA200149/Passports(2).PDF', 'application/files/AA200149/Utility Bill(3).PDF', 'application/files/AA200149/Marriage Certificate(3).pdf', 'application/files/AA200149/Passport- Divorce Decree(2).PDF', 'application/files/AA200149/CV(2).PDF', 'application/files/AA200149/Professional Reference(2).PDF', 'application/files/AA200149/Proof of Net Worth- Bankers References(1).PDF', 'application/files/AA200149/SL 7(2).PDF', 'application/files/AA200149/SL 8(2).PDF', '', 'application/files/AA200149/Police Certificate of Character(2).pdf', 'application/files/AA200149/Visa(2).PDF', '', '', '', '', '', 'application/files/AA200149/Passport Pics(3).pdf', 'principal_applicant', 'government_bonds', '', 0, NULL, '00012016', '2016-05-09 16:16:14', NULL, 'russia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 181, '2016-05-10 12:35:36', NULL, NULL, NULL, 'application/files/AA200149/Company Documents- AAA Holding Ltd.PDF', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(27, '', '2G00005Q1', 'Anna ', 'Shevkoplyas', NULL, '', '', NULL, '2016-05-09 16:01:46', '2019-09-11 13:29:04', 11, 149, NULL, 147, 145, 144, 207, '', '', '', '', 'application/files/AA200149/SL 1(2).pdf', '', '', '', 'application/files/AA200149/SL 5(2).pdf', 'application/files/AA200149/Birth Certificate(5).pdf', NULL, NULL, '', NULL, 'application/files/AA200149/SL 6(6).pdf', NULL, 'application/files/AA200149/Passport(2).pdf', 'application/files/AA200149/Confirmation of Study Letter- Kings College(2).pdf', NULL, NULL, 'application/files/AA200149/CV(2).pdf', '', '', '', '', 'application/files/AA200149/Educational Qualifications(3).pdf', 'application/files/AA200149/Police Certificates.pdf', 'application/files/AA200149/Visa.pdf', 'application/files/AA200149/SL 9(2).pdf', 'application/files/AA200149/Educational Qualifications(2).pdf', '', '', '', 'application/files/AA200149/Passport Pics(4).pdf', 'qualifying_dependant', 'government_bonds', '', 0, 22, '00022016', '2016-05-09 16:46:48', NULL, 'rest_of_world', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 183, '2016-05-10 12:35:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(28, '', '2G00005Q2', 'Oleksandra', 'Shevkoplyas', NULL, '', '', NULL, '2016-05-09 16:48:16', '2019-09-11 13:30:39', 11, 149, NULL, 147, 145, 144, 207, '', '', '', '', 'application/files/AA200149/SL 1(3).pdf', '', '', '', 'application/files/AA200149/SL 5(3).pdf', 'application/files/AA200149/Birth Certificate(6).pdf', NULL, NULL, '', NULL, 'application/files/AA200149/SL 6(7).pdf', NULL, 'application/files/AA200149/Passport.PDF', '', NULL, NULL, '', '', '', '', '', '', 'application/files/AA200149/Police Clearance Certificate.pdf', 'application/files/AA200149/US Visa.pdf', 'application/files/AA200149/SL 9(1).PDF', '', '', 'application/files/AA200149/Affidavit of Consent of Non-Accompanying Parent.PDF', 'application/files/AA200149/Passport of non accompanying parent.pdf', 'application/files/AA200149/Passport Pics(5).pdf', 'qualifying_dependant', 'government_bonds', '', 0, 22, '00032016', '2016-05-09 16:57:19', NULL, 'russia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 181, '2016-05-10 12:36:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(538, 8387, 'CHETAN - UPDATED PROOF OF ADDRESS.pdf', 'application/files/AA200179/bank_files/CHETAN - UPDATED PROOF OF ADDRESS.pdf', 'bank', '2025-02-12 15:45:29'),
(539, 8387, 'ABDIRAHMAN - CV.pdf', 'application/files/AA200179/bank_files/ABDIRAHMAN - CV.pdf', 'bank', '2025-02-12 15:45:39'),
(540, 15076, 'A7.GhandiHAJI_SL7.pdf', 'application/files/AA200139/bank_files/A7.GhandiHAJI_SL7.pdf', 'bank', '2025-02-12 15:51:02'),
(541, 15076, 'PCCsFromSyria (1).pdf', 'application/files/AA200139/bank_files/PCCsFromSyria (1).pdf', 'bank', '2025-02-12 15:51:26'),
(542, 11274, 'Affidavit as to Police Certificate from Kuwait.pdf', 'application/files/AA200151/bank_files/Affidavit as to Police Certificate from Kuwait.pdf', 'bank', '2025-02-12 15:57:46'),
(543, 19693, 'Proof of Address.pdf', 'application/files/AA200151/bank_files/Proof of Address.pdf', 'bank', '2025-02-13 08:27:06'),
(544, 19693, 'Proof of Account.pdf', 'application/files/AA200151/bank_files/Proof of Account.pdf', 'bank', '2025-02-13 08:27:43'),
(545, 19693, '4355_001 (1) - Turkish Pcc.pdf', 'application/files/AA200151/bank_files/4355_001 (1) - Turkish Pcc.pdf', 'bank', '2025-02-13 08:27:54'),
(546, 31047, 'Sami - Passport Copy.pdf', 'application/files/AA200179/bank_files/Sami - Passport Copy.pdf', 'bank', '2025-02-13 08:31:04'),
(547, 24832, 'Ghina Passport all pages.pdf', 'application/files/AA200151/bank_files/Ghina Passport all pages.pdf', 'bank', '2025-02-13 08:34:18'),
NSERT INTO `users` (`id`, `parent_id`, `username`, `password`, `first_name`, `last_name`, `full_name`, `profile_pic_path`, `professional_artistic_name`, `date_of_birth`, `gender`, `registrant_type_id`, `address_line_1`, `address_line_2`, `city`, `state_province`, `zip_postal_code`, `country_id`, `district_id`, `ship_name`, `state`, `province`, `mailing_address_line_1`, `mailin_address_line_2`, `mailing_city`, `mailing_state_province`, `mailing_zip_postal_code`, `mailing_country_id`, `mailing_ship_name`, `mailing_state`, `mailing_province`, `mailing_country`, `phone`, `mobile`, `email`, `website`, `birth_certificate_number`, `national_identification_number`, `passport_number`, `drivers_permit_number`, `active`, `banned`, `created`, `modified`, `created_by`, `modified_by`, `group_id`, `role_id`, `temp_reset_val`, `allow_face_sign_in`, `use_pin_with_face`, `pin`, `face_training_accuracy`, `number_of_face_training_sessions`, `business_id`) VALUES
(1, 0, 'ngeorge', '$2y$10$PW1aZPqe/QDZmfmeFMaVfu0K12l0DvLtgOunHa59zrnPGRSIPYkzm', 'Neal', 'George', 'Neal George', 'files/users/images/placeholder.png', NULL, '0000-00-00', 'Male', 0, '', '', '', NULL, '', 12, NULL, '', '', '', '', '', '', '', '', 1, '', '', '', '', '', '', 'ngeorge@emagine.lc', '', NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '2022-12-07 09:18:35', 0, NULL, 6, 1, '7546527280', 0, 0, NULL, NULL, NULL, NULL),
(3, 0, 'rschouten', '$2y$10$RK5x4mh4mEWI1Kb5CSNAmO5GSku12Nuh6LuXBAH3LfwLQuvnDvSqa', 'Robin', 'Schouten', 'Robin Schouten', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 184, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'rschouten@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '2022-12-07 09:18:29', 0, 22, 6, 1, '0', 1, 1, '$2y$10$JPVxbAdMTfDqbT78e7iEZu8tJXJTHJKT9OHJ4WwhrrzHJohl8EaHe', '100.0', 7, NULL),
(18, 0, 'Vivian', '$2y$10$UDwDjnWBz2juco35yuMONuv3EuoCEaF/vJg31plBVnzcn9xcjJJle', 'Vivian', 'Blanchard', 'Vivian Blanchard', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'vblanchard@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2016-12-22 12:39:01', '2022-12-07 09:18:22', 0, NULL, 6, 1, NULL, 0, 0, NULL, NULL, NULL, NULL),
(20, 0, 'test_member', '$2y$10$YPbzeZ6v7TwS9OEYu7w96.IS/gb0sR49jayno/fxLm1pYaQzrj4Ia', 'Test', 'Member', 'Test Member', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 1, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'ngeorge@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2017-02-15 12:57:48', '2022-12-07 09:18:15', 0, NULL, 12, 3, NULL, 0, 0, NULL, NULL, NULL, NULL),
(21, 0, 'jgeorge@emagine.lc', '$2y$10$e.0YLjHH/hWgakChIJ7gPOwFPoBO1ZHoj3o9Ihln.1hFgIkLITeFS', 'Joakim', 'George', 'Joakim George', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'jgeorge@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2017-09-04 18:41:37', '2022-12-07 09:18:02', 0, NULL, 6, 1, '9361162583', 1, 1, '$2y$10$z7ppb4FziKWmyd3/1QlQWufpczsuQU77Jhh35h.7SMdnxlQeY8B1C', NULL, NULL, NULL),
(22, 0, 'amontrope', '$2y$10$/m3PNFScj5ucqgCm0eZbaeq8eDMiQsAW29emo/NkgdPJhaGERV/S2', 'Akil', 'Montrope', 'Akil Montrope', 'files/users/images/user.png', NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'amontrope@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2018-05-09 18:47:42', '2022-12-07 09:17:57', 0, NULL, 6, 1, NULL, 0, 0, NULL, NULL, NULL, NULL),
(23, 0, 'rjoseph', '$2y$10$FZcPr1AySolqAaGzx7p0..Mf2KLQlrQIHXpx2YyPvJ9DainjjAhpS', 'Rown ', 'Joseph', 'Rown Joseph', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'rjoseph@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2018-05-09 18:51:19', '2022-12-07 09:17:50', 0, NULL, 6, 1, NULL, 0, 0, NULL, NULL, NULL, NULL),
(24, 0, 'cgardiner', '$2y$10$ezeDnZxlohCU/NcFVNZnEuZAbZ.oovEBFdG6Kbh4OHVbxBTon3Iqi', 'Chris', 'Gardiner', 'Chris Gardiner', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'c.gardiner@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2018-08-14 16:45:44', '2022-12-07 09:17:37', 0, NULL, 6, 1, NULL, 1, 1, '$2y$10$lx6VAY3HnJb00awCrxjJNORhmtJHgS1jL0wj6ZTJ.qZXHYw4ftIb.', NULL, NULL, NULL),
(25, 0, 'jeanmal', '$2y$10$CdTsZ1oHTYGC0Aa7VhQFKuB9/sUZE8LrH2CJxmJESrTOhHgN80ecm', 'Jeanmal', 'Wilson', 'Jeanmal Wilson', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'jwilson@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2018-10-02 14:55:36', '2022-12-07 09:17:43', 0, NULL, 6, 1, NULL, 0, 0, NULL, NULL, NULL, NULL),
(27, 0, 'jmontoute', '$2y$10$R3b3955aIj7AMv4oAADTveTy0pdVft5Qk/2VOCI4toVaYZutcrJOu', 'Jeshaun', 'Montoute', 'Jeshaun Montoute', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'jmontoute@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 1, 0, '2020-08-24 14:47:11', '2022-12-06 17:47:32', 0, NULL, 6, 1, '3902776205', 0, 0, NULL, NULL, NULL, 1),
(28, 0, 'Lfrancis', '$2y$10$jiH2xH5baF6Mpw4w//tPJu.NkeescB.zURzwFGDU/x3iIcAlB9zWy', 'Leo', 'Francis', 'Leo Francis', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'lfrancis@cipsaintlucia.com', NULL, NULL, NULL, NULL, NULL, 1, 0, '2020-10-30 11:17:31', '2023-01-09 16:14:28', 0, NULL, 14, 5, '9050106306', 0, 0, NULL, NULL, NULL, 1),
(29, 0, 'test_accounts', '$2y$10$pIDC92Rtq/lj4me5yKjCzeAfaTBFWPfykY/gHtgk6wwcqddPRHP6m', 'Test', 'Accounts', 'Test Accounts', NULL, NULL, '0000-00-00', '', 0, '', NULL, '', NULL, NULL, 145, NULL, '', '', '', NULL, NULL, NULL, '', '', 0, '', '', '', '', NULL, NULL, 'ngeorge+12@emagine.lc', NULL, NULL, NULL, NULL, NULL, 0, 0, '2020-11-11 11:27:34', '2022-12-07 09:20:28', 0, NULL, 14, 5, NULL, 0, 0, NULL, NULL, NULL, 1),
Thanks @zehq for ranks!!!
