Jul 14, 2024, 01:30 PM
samples
INSERT INTO `tbl_landlord_agent` (`id`, `type`, `title`, `first_name`, `last_name`, `phone_home`, `phone_work`, `phone_mobile`, `fax`, `email`, `council_id`, `council_dept_id`, `is_company`, `comp_name`, `comp_type`, `comp_reg_no`, `post_code`, `address_one`, `address_two`, `town`, `has_website`, `web_address`, `internal_it_system`, `software_name`, `contact_no`, `ast_incentive_type`, `share_acom_ast_incntv`, `one_bd_ast_incntv`, `two_bd_ast_incntv`, `three_bd_ast_incntv`, `four_bd_ast_incntv`, `ea_incentive_type`, `ea_incentieve`, `ta_incentive_type`, `ta_incentieve`, `incentive_parent`, `landlord_insurance`, `tenants_liability_insurance`, `landlord_insurance_title`, `landlord_insurance_desc`, `tenants_insurance_title`, `tenants_insurance_desc`, `is_document_check`, `is_background_check`, `client_group`, `anti_social`, `signature_img`, `status`, `contacted`, `parent`, `created_user_type`, `created_ref_id`, `created_date`, `update_date`, `archived`, `maling_list`, `register_from`) VALUES
(1, 5, 'Mr', 'Duwayne', 'Holness', '447944496821', '447944496821', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'SE25 4PF', '22 Portland Road', '', 'london', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(2, 5, 'Mr', 'Colin', 'Haylock', '447926203454', '447926203454', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'se', '', '', 'london', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(3, 5, 'Ms', 'Rrose', 'r21', '0000000000', '0000000000', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'RM10 8AADA', 'QUOTE PURPOSES ONLY', 'QUOTE PURPOSES ONLY', 'QUOTE PURPOSES ONLY', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(4, 14, 'Mr', 'Andrew Marshall Residential Properties Limited', '', '441916404604', '01916404604', '', '', '[email protected]', NULL, NULL, 1, 'Andrew Marshall Residential Properties Limited', 'Letting Agency', '05667861', 'DL17 8JP', '18', 'Darlington Road', 'Durham', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(5, 5, '', 'DAL', 'Sandhu', '2086568888', '2086568888', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'SE25 4PF', '22 Portland Road', '', 'SOUTH NORWOOD', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(6, 14, 'Mr', 'Mohammed', 'Sabir', '442087673838', '442087673838', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'IG3 8PW', '', 'Spencer Road', 'ilford', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(7, 5, NULL, 'Chris', 'Wright', '447523923101', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(8, 5, NULL, 'Maninder', 'Gujral', '447885900000', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(9, 14, '', 'Ayesha', 'Hart', '', '441803211121', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'TQ', '', '', 'TORBAY', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(10, 5, NULL, 'Tarnjit', 'Grewal', '447943806764', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(11, 5, NULL, 'Ellie', 'King', '441268947090', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 1, 0, 'h2s'),
(12, 14, 'Ms', 'Holly', 'Bradshaw-Taylor', '441483429157', '441483429157', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'L', '', '', 'l', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(13, 5, NULL, 'Pesah', 'Olbaum', '442037818003', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 1, 0, 'h2s'),
(14, 14, 'Other', 'Angus', 'Faulkner', '447757690391', '447757690391', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'L', '', '', 'l', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(15, 14, 'Mr', 'SD', 'SHAH', '', '442086498784', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'CR0 4TH', '', 'Beddington Lane', 'Croydon', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(16, 14, '', 'Osama', 'Badawy', '447984913145', '447984913145', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'n', '', '', 'l', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(17, 14, 'Ms', 'sue', 'alhadeff', '447956539254', '447956539254', '', '', '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, 'l', '', '', 'l', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', '', 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(18, 5, NULL, 'Sarita', 'Verma', '447828726219', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(19, 5, NULL, 'Martin', 'Neame', '447980618675', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(20, 5, NULL, 'Terry', 'Foreman', '447714589237', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(21, 5, NULL, 'Manish ', 'Patel', '447716925203', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),
(22, 5, NULL, 'Callum', 'Rowe', '447879678133', NULL, NULL, NULL, '[email protected]', NULL, NULL, 0, NULL, NULL, NULL, '', '', '', '', 'no', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'no', NULL, NULL, NULL, NULL, 'no', 'no', NULL, 'no', NULL, 1, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 'h2s'),INSERT INTO `tbl_user` (`id`, `name`, `email`, `contact_no`, `username`, `password`, `user_type`, `ref_id`, `registered_date`, `status`, `login_status`, `ipaddress`, `loggedin_on`, `login_count`, `has_dual`, `dual_user_type`, `dual_ref_id`) VALUES
(1, 'developer', '[email protected]', NULL, 'devadmin', '$2y$11$Ngvj5WYnY4/eCSM.k76Va.SJ3Y.9SJH0968dmXH9NEgXwjj2s30ny', 1, 99999, NULL, 0, 0, '49.37.32.155', '2022-10-25 17:06:44', 2016, NULL, NULL, NULL),
(2, 'h2sadmin', '[email protected]', NULL, 'h2sadmin', '$2y$11$g4b03DPYmmpTc7xs/i9HFOep5e20EYWWQ.ce1uviFK87xEq0uzR.6', 2, 99998, NULL, 0, 0, '10.10.1.161', '2022-04-14 11:04:31', 1089, NULL, NULL, NULL),
(3, 'h2ssubadmin', '[email protected]', NULL, 'h2ssubadmin', '$2y$11$jJtE4WEN29kf/V0EfiCzSOGDZ9BrqfzxktwGRbnmq/NHCHedt.c0y', 2, 99997, '2021-02-11', 0, 0, '10.10.2.216', '2021-09-17 13:13:09', 4, NULL, NULL, NULL),
(4, 'Maidstone Council', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 1, '2021-02-11', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(12, 'Southwark Council', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 3, '2021-02-19', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(14, 'h2fadmin', '[email protected]', NULL, 'h2fadmin', '$2y$11$FSbSotyDxtJxWqrQLeuLfup98Brjmuj1iEP2iUKI4.XTiiRvwHMNi', 2, 99996, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(16, 'John Doe', '[email protected]', NULL, '[email protected]', '$2y$11$LOm3MqgkCDUW1TW2fxKtL.vPh8Fslfneo8KugPDd1KhwfeiE69yem', 7, 1, '2021-02-24', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(17, 'Jhony Test', '[email protected]', NULL, '[email protected]', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 2, '2021-02-24', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(18, 'Jhon Doe', '[email protected]', NULL, '[email protected]', '$2y$11$FoO50GbO1tDaoLrIycR8UOkr1o3r3kphdAida68yUIZ9HOvMpF8gG', 3, 2, '2021-02-25', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(27, 'Royal Borough Of Kensington & Chelsea', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 4, '2021-03-07', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(28, 'Andrew Test', 'ginisx000gmail.com', NULL, 'ginisx000gmail.com', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 4, '2021-03-09', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(30, 'Westminster City Council (Housing),', NULL, NULL, '[email protected]', '$2y$11$VzSDKZFeuudrYv9.CkTyNeOp2nkLAreeawxUJKP3Uz6Y5jSb1BseO', 3, 5, '2021-03-10', 0, 0, '10.10.2.178', '2022-03-16 17:46:18', 6, NULL, NULL, NULL),
(32, 'Jhon Doe', '[email protected]', NULL, '[email protected]', '$2y$11$G19k6MFK3OEIqvW0slUeku6.gOsg0roUd9cGSzMisPLVMCPgxk8w6', 7, 3, '2021-03-15', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(33, 'Colchester Borough Homes', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 6, '2021-03-18', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(35, 'Dartford Council', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 7, '2021-03-19', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(42, 'Belkin Jimmmy', '[email protected]', NULL, '[email protected]', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 6, '2021-03-24', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(46, 'Housing Association', '[email protected]', NULL, '[email protected]', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 7, '2021-04-06', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(58, 'SALFORD COUNCIL', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 9, '2021-04-12', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(63, 'Sandwell Metropolitan Borough Council\r\n', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 11, '2021-04-14', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(65, 'Test Landlord', '[email protected]', NULL, '[email protected]', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 9, '2021-04-19', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(67, 'Sujoy Maiti', '[email protected]', NULL, '[email protected]', '$2y$11$iPsBCe4dgy7MfgLr.mY1VO5rlYxmfFE563x8Yc9j/wNEK49vKXZ5i', 7, 4, '2021-04-21', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(70, 'Zubin Roy', '[email protected]', NULL, '[email protected]', '$2y$11$UZ4q0zrahrzqtHkcKYaB/u.FMx9TGSyss0ylCP4WZ8EqKJkPf8QeK', 7, 5, '2021-04-22', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(71, 'Sujoy Maiti', '[email protected]', NULL, '[email protected]', '$2y$11$BKlcLpHkdY5ajD4nYcOsyO4JhpOMHiEG1pGNRniPZ2apWIX1ozXR6', 7, 6, '2021-04-26', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(73, 'Living Limited', '[email protected]', NULL, '[email protected]', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 10, '2021-04-26', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(74, 'test test', '[email protected]', NULL, '[email protected]', '$2y$11$VmT5hOr9snb3BWhlLQsmFOT0BBYfgOChRKsQyo2/hbgop07y7Xuyu', 4, 11, '2021-04-26', 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(76, 'Name', NULL, NULL, 'username', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 0, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL),
(77, 'Birmingham City Council', NULL, NULL, '[email protected]', '$2y$11$lT6Py1L.DAmLAJdcVLUZCeDW6XkZoiR5wcOPrmPv3Zd.kbqttR8uW', 3, 15, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL),