
-- --------------------------------------------------------

--
-- Table structure for table `new_lawyers`
--

DROP TABLE IF EXISTS `new_lawyers`;
CREATE TABLE IF NOT EXISTS `new_lawyers` (
  `new_lawyers_id` int NOT NULL AUTO_INCREMENT,
  `new_lawyers_key` varchar(255) NOT NULL,
  `new_lawyers_district_key` varchar(255) NOT NULL,
  `new_lawyers_name` varchar(50) NOT NULL,
  `new_lawyers_phone` varchar(10) NOT NULL,
  `new_lawyers_exp` varchar(25) NOT NULL,
  `new_lawyers_are_p` varchar(50) NOT NULL,
  `new_lawyers_office` varchar(100) NOT NULL,
  `new_lawyers_image` varchar(255) NOT NULL,
  `new_lawyers_desc` text NOT NULL,
  `new_lawyers_status` tinyint NOT NULL,
  `new_lawyers_date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`new_lawyers_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `new_lawyers`
--

INSERT INTO `new_lawyers` (`new_lawyers_id`, `new_lawyers_key`, `new_lawyers_district_key`, `new_lawyers_name`, `new_lawyers_phone`, `new_lawyers_exp`, `new_lawyers_are_p`, `new_lawyers_office`, `new_lawyers_image`, `new_lawyers_desc`, `new_lawyers_status`, `new_lawyers_date_added`) VALUES
(1, 'pSBHZRWNcQfltzsjtKf1iVyOx', '0in08fFu83MOnYGSlRY1Z0wSE', 'Nithin', '+91 99800 ', '8', 'Law', 'Bangalore, Karnataka', '', '', 1, '2022-11-22 11:34:47'),
(2, 'RFgAL4l1rjXpl3QuEcTOOLwyE', 'tP2c1iOiyxc0VqciPOQMaVV3k', 'Nithin', '+91 99800 ', '8', 'Law', '<p>Bangalore, Karnataka</p>', '', '', 0, '2022-12-02 07:23:27'),
(3, '8fUr0Ib3rutyWITjDTVj1H0yn', '8gmJ4sitCiVONr0eOBkZnMifj', 'Aftab', '9113671525', '5', 'Law', '<p>Mangalore</p>', '', '', 0, '2022-12-02 07:23:26'),
(4, '6qZwzyGnvQYnDV21Cirmr4tSQ', 'tP2c1iOiyxc0VqciPOQMaVV3k', 'Waseem ', '9113671582', '52', 'Law', '<p>Bangalore</p>', '', '', 0, '2022-12-02 07:23:24'),
(5, 'uqRixeWkreuaOTh2m1IM4QZ0z', '8gmJ4sitCiVONr0eOBkZnMifj', 'J.K. Jayaselan ', '9894292179', 'Government Advocate ', 'Civil ', '<p class=\"p1\" style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-variant-numeric: ', '', '', 0, '2022-11-24 10:06:08'),
(6, 'IPwHbSFCTqPqlscx6cR0zGKex', 'KOmwFcs48y2NBZQcmFEG6soqV', 'H.K. V', '9845065416', '33 Years ', 'Civil ', '<p>Address....</p><p>2ljlrjel</p><p>hrlejljrlejl</p><p>hlejrlejl</p>', 'c39a280e5c06af1a7decd7d228b53c2a.JPG', '', 0, '2022-12-04 06:53:06'),
(7, 'VRsqfSdYE9tIuFm9jNbpj0lbA', 'KOmwFcs48y2NBZQcmFEG6soqV', 'DDDDDDDDDDDD', '9845065416', '33 Years ', 'Civil ', '<p>ADRES</p>', 'e56f9fd2878c2dab0ac13dc4c8a8a948.JPG', '', 1, '2022-12-04 06:54:29'),
(8, 'aU8rfY0AXkUs8B1nCZNN0vra2', 'eMaeFM0aQTnS3v5PO2aSk3PW2', 'J.K. Jayaselan', '9894292179', '22 Years', 'Civil ', '<p>Door. No.2/27, Neelamegam Nagar, Thirumogur Road, Y.Othakadai, Madurai - 107.<br></p>', '438ecb8e0ebf7b87eddc8baded57b125.png', '', 1, '2022-12-04 07:10:08'),
(9, 'YquxVl0IKLs4TdU3q6OrOvXFS', 'StHRr93XN0XHnaGkeiBl0MT6X', 'Ravi J S', '+91 95385 ', '12 Years', 'Criminal ', '<p>Address - No. D-206, 2nd floor, Concord Spring Meadows, bone mill stop, hesaraghatta main road, b', '8dcaa46947483704c0373674f6b7bd28.jpeg', '', 1, '2022-12-04 07:24:14'),
(10, '9j30NbF3NuBvNUefhmqUbkr3I', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'Ravi J S', '9538576600', '12 Years', 'Criminal ', '<p>Address - No. D-206, 2nd floor, Concord Spring Meadows, bone mill stop, hesaraghatta main road, b', 'ccc95f27a412d7d540360881c4424c5e.jpeg', '', 1, '2022-12-04 07:27:50'),
(11, 'AsJhvoSmlqOBWxTWHXLRjWy15', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'K.SURESH KUMAR', '9611322320', '11 Years', 'Civil, Criminal, Family matters, Consumer, Commerc', '<p>Personal Chambers: No.2, 2nd Floor, Maurya Mansion, 1st main, 1st cross, Gandhinagar, Bangalore -', 'de435a4ddce19e86e3f16962e52041fb.jpeg', '', 1, '2022-12-04 07:36:30'),
(12, 'B4DMsLeKDrLBJc1K4393DEp8j', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'CHANDINI.S', '9740186713', '11 Years', 'Civil, Criminal, Family matters, Consumer, Commerc', '<p>Personal Chambers: No.2, 2nd Floor, Maurya Mansion, 1st main, 1st cross, Gandhinagar, Bangalore -', '00a273d385504102c7a93d44f0bbddaf.jpeg', '', 1, '2022-12-04 07:38:06'),
(13, 'T8rRCvJ5WiP0aV3x9YlITcSIG', 'thM6vwM4zqry7iw0b8i9JWusz', 'Shankarsing V Hajeri ', '9886243555', '14 Years', 'Criminal , Civil, Family law, MVC, Consumer, N I A', '<p>H.No. M-II/5, Adarsh Nagar, Ashram Road, Vijayapura 586103 </p><p>and&nbsp;</p><p>C/o S G Arakeri', 'd3b9916fea87d3194a92c981aedc70dd.jpeg', '', 0, '2022-12-04 07:44:32'),
(14, '4cWPHonG5sBVgjdd7HpSm7k9s', 'uQKOtlnw8XA64ipoloCZ0uDDw', 'Shankarsing V Hajeri ', '9886243555', '14 Years', 'Criminal, Civil, Family law, MVC, Consumer, N I Ac', '<p>H.No. M-II/5, Adarsh Nagar, Ashram Road, Vijayapura 586103 and&nbsp;<span style=\"font-family: var', '602fff5277c43e3e4a6f6a041001443e.jpeg', '', 1, '2022-12-04 07:47:17'),
(15, '6jUpUBYWoQC4C0yqbPSEws0t0', '27kanw4WBbjKapSurk88WRpA1', 'Shankarsing V Hajeri', '9886243555', '14 Years', 'Criminal, Civil, Family law, MVC, Consumer, N I Ac', '<p>C/o S G Arakeri Building, Navaraspur Extension, Opposite Vijayapura District Court Complex, Besid', '9728aded7952521cc0d841189cbee6be.jpeg', '', 1, '2022-12-04 07:49:33'),
(22, 'cVYqAVdm3A7kKH8JmMyoWIKqL', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'Prashanth Chandra S N', '9880737800', '35 Years ', 'Civil, ADR, Commercial Court, Mediator, Trainer, A', '<p>No. 1432/2, SIR Plaza,1st Floor, Krishnadevaraya Hoad, Opposte KASSIA Building, Vijayanagar, Beng', 'b8cca4b95d9a5dd4d3757ba3f0d1fe95.png', '', 1, '2022-12-05 15:31:36'),
(23, 't2A20loqFzQ8Q2okKizAEruL7', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'H. Rajanna', '9448620191', '22 Years', 'Civil & Revenue cases', '<p># 7/1,18th Cross, Behind Shikshaka Sadana Cubbonpet, Bangalore - 560 002.<br></p>', '42345c24fea7581cf5d68a86133184db.png', '', 1, '2022-12-05 15:35:59'),
(24, 'IT3EKuasxLmZYpJqeDe0qOzG8', 'lqHPOFJwLvI0jfltQya8L0PE6', 'Deepak Rajashekhar Tongli', '8095228032', '1 Year', 'Litigations: Civil, Criminal & Revenue Court Matte', '<p>H. No 32, Hirepeth 2nd cross, Old Hubli, Hubli 580024<br></p>', '5e743ea35d82a238a3b3443679e0f755.png', '', 1, '2022-12-05 15:39:29'),
(25, 'yFIF6ooZerLMu5dEtDrzhPby6', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'Mario Noel D\'Rozario', '8142132663', '9 Years', 'Civil Law, Criminal Law, Corporate Law. ', '<p>Flat No.B-102, Spectra Rain Tree Apartments 41,10th Main,Sakamma Layout, St.Thomas Town Bangalore', 'f5a0145ad4344bdb0e9126db0615f2c1.png', '', 1, '2022-12-05 15:42:27'),
(27, '4ri9kmb4AinWXcxmSMISFOpE7', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'Anand Byra Reddy', '9448289007', '12 Years Former Judge (HC', 'Consultancy / Arbitration ', '<p>Villa no. 3, Luminaire, 39, BDA Main Road, Jeevan Bimanagar Bengaluru: 560075<br></p>', 'e23e59c5f80799d5e1ebb181d604e0dd.jpg', '', 1, '2022-12-05 16:07:57'),
(29, '81c9ml9sXNGI3FRNlZz6KRUaA', 'lqgxwasneJ1GCVCGUVNxrHl63', 'S G Nadaf ', '9342222534', '17 Years', 'Civil, Criminal', '<p>Chikodi Road Bharth Colony, Hukkeri. Pin Code:&nbsp;591309&nbsp;<br></p>', '612476baff308fa75e9d68bf8117bc68.png', '', 1, '2022-12-06 14:30:47'),
(37, '4bJ5MwxO0aCj4Bh535Peh0MRY', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'Aravinda Kamath P', '9901964554', '11 Years', 'Criminal , Civil and Family Law', '<p>No 6, 7th Street ,Bank Avenue Extension ,Babusapalya Bengaluru 560043.&nbsp;<br></p>', 'cf6be64e749fb57a5bed56483a13a7d3.jpg', '', 1, '2022-12-10 07:48:52'),
(40, 'vPzIFWMe9NCnXXmTBRV5trFyt', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'K. NANDA GOPAL', '9008012209', '33 Years', 'Civil,Criminal,Cheque Bounce,Accident,Matrimonial.', '<p>No.1672 / 12, 18th Main, 41 St Cross, 4th \' T \' Block, JAYANAGAR, BANGALORE-560 041.<br></p>', 'd93cc2d14191b137d5acf5b036cfc38f.png', '', 1, '2022-12-10 08:50:16'),
(44, 'DLQudFCzDiz0fji6Jea7q09QC', 'w2ep9pwjEg9Lhu8FiWvw6sGCP', 'SHESHADRI S', '9448423641', '25 Years ', 'Civil and Criminal ', '<p>Main Road, Near Ranjita Hotel Hiriyur, 577598<br></p>', '633161ddd119c310a0d0eb8b6c386955.jpg', '', 1, '2022-12-11 14:19:19'),
(46, 'hr8JOGsXwxHFexC5C4jktfcXW', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'M.V. Sridhar Chakravarthi', '9448107600', '21 Years', 'Advocate & Arbitration Consultant', '<p>No.44, \"Srinikethan\", 1st \'A\' Main Road, 7th Block, Koramangala, Bengaluru - 560095, Karnataka, I', '607711178a40ed218663424759f5e636.png', '', 1, '2024-02-05 09:58:09'),
(47, 'g7PfBPhDudPZFzaNqceoSnjFf', 'eZU9RXX9lPI4ozfaWA3VitcO0', 'Uday Shankar M', '9590888887', '3 Years', 'Civil Litigation and Criminal Litigation.', '<p>#T-7, 3rd floor, Jeevan Building, Kumarapark East, sampangi ramanagar, Bengaluru - 560001.<br></p', '192eaa63af26ed540f3aa1eec4b3d601.png', '', 1, '2024-03-10 13:18:41');
