-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 30, 2024 at 03:50 PM -- Server version: 5.7.44 -- PHP Version: 8.1.28 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `rejoicebilldesk_rejoice_solutions` -- -- -------------------------------------------------------- -- -- Table structure for table `branch_info` -- CREATE TABLE `branch_info` ( `id` int(11) NOT NULL, `workspace_id` varchar(10) NOT NULL, `company_id` varchar(10) NOT NULL, `branch_name` varchar(255) NOT NULL, `branch_city` varchar(255) NOT NULL, `branch_pincode` varchar(50) NOT NULL, `branch_address` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `contact_number` varchar(15) NOT NULL, `branch_gst` varchar(16) DEFAULT NULL, `branch_founded_on` varchar(255) DEFAULT NULL, `base_currency_symbol` varchar(255) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL, `base_currency_formal_name` varchar(5) NOT NULL, `currency_symbol_suffix_bool` int(10) NOT NULL COMMENT '1 stands for true, 0 for false', `currency_format` varchar(15) NOT NULL, `number_of_decimal_places` varchar(1) NOT NULL COMMENT 'by default 2', `word_representing_amount_after_decimal` varchar(255) NOT NULL, `business_id` varchar(11) DEFAULT NULL, `date_created` varchar(255) NOT NULL, `time_created` varchar(255) NOT NULL, `created_by` varchar(255) NOT NULL, `country` varchar(11) NOT NULL, `state` varchar(11) NOT NULL, `adl_email` varchar(50) DEFAULT NULL, `adl_contact_number` varchar(15) DEFAULT NULL, `website` varchar(50) DEFAULT NULL, `status` varchar(11) NOT NULL COMMENT '1 stands for active, 0 stands for blocked', `lock_status` int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `branch_info` -- INSERT INTO `branch_info` (`id`, `workspace_id`, `company_id`, `branch_name`, `branch_city`, `branch_pincode`, `branch_address`, `email`, `contact_number`, `branch_gst`, `branch_founded_on`, `base_currency_symbol`, `base_currency_formal_name`, `currency_symbol_suffix_bool`, `currency_format`, `number_of_decimal_places`, `word_representing_amount_after_decimal`, `business_id`, `date_created`, `time_created`, `created_by`, `country`, `state`, `adl_email`, `adl_contact_number`, `website`, `status`, `lock_status`) VALUES (1, '1', '1', 'Rejoice', 'Noida', '680610', 'Delhi', 'deep@gmail.com', '+919033492872', '11ABCDE1234L1V', '2024-03-07', '20B9', 'INR', 1, 'INR', '1', 'paise', NULL, '2024-01-30', '1706591940', 'dhruvishah2911@gmail.com', '1', '1', NULL, NULL, NULL, '1', 1), (2, '7', '3', 'Alexa Branch', 'Ahmedabad', '380007', 'B5 Ashirwad Flats', 'alexa@gmail.com', '+919876543214', '24AAGFF5319K1ZA', '2024-04-23', '20B9', 'INR', 1, 'INR', '2', 'paise', NULL, '2024-04-23', '1713864877', 'alexa@gmail.com', '1', '12', NULL, NULL, 'https://www.google.com', '1', 1), (3, '8', '4', 'SECTOR 23', 'Chandigahrh', '160023', 'CHANDIGARH', 'hazarisah481@gmail.com', '+919858585558', '36AAACH7409R1Z2', '2024-05-30', '20B9', 'INR', 1, 'INR', '2', 'paise', NULL, '2024-05-30', '1717045415', 'hazarisah481@gmail.com', '1', '31', NULL, NULL, NULL, '1', 1), (4, '8', '5', 'MORINDA', 'Morinda', '525212', 'Punjab', 'dhruvishah29111@gmail.com', '+917575758575', '09AAACH7409R1ZZ', '2024-05-30', '20B9', 'INR', 1, 'INR', '2', 'paise', NULL, '2024-05-30', '1717052890', 'hazarisah481@gmail.com', '1', '18', NULL, NULL, NULL, '1', 1), (5, '8', '6', 'Aarav Solutions', 'Chandigahr', '160014', 'Chandigarh', 'hazarisah48@gmail.com', '+91885258589', '09AAACH7409R1ZV', '2024-05-30', '20B9', 'INR', 1, 'INR', '2', 'paise', NULL, '2024-05-30', '1717054386', 'hazarisah481@gmail.com', '1', '10', NULL, NULL, NULL, '1', 1); -- -------------------------------------------------------- -- -- Table structure for table `companies_info` -- CREATE TABLE `companies_info` ( `id` int(11) NOT NULL, `workspace_id` varchar(15) NOT NULL, `company_name` varchar(255) NOT NULL, `company_address` varchar(255) NOT NULL, `company_pan` varchar(255) NOT NULL, `date_created` varchar(255) NOT NULL, `time_created` varchar(255) NOT NULL, `created_by` varchar(255) NOT NULL, `status` int(15) NOT NULL COMMENT '1 stands for active, 0 stands for blocked' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `companies_info` -- INSERT INTO `companies_info` (`id`, `workspace_id`, `company_name`, `company_address`, `company_pan`, `date_created`, `time_created`, `created_by`, `status`) VALUES (1, '1', 'Rejoice Solution', 'Gujarat', 'AQWAW2525Z', '2024-01-30', '1706591856', 'dhruvishah2911@gmail.com', 1), (2, '1', 'Rejoice 001', 'Delhi', 'ABCDE1234N', '2024-03-07', '1709795462', 'dhruvishah2911@gmail.com', 1), (3, '7', 'Alexa', 'Mumbai', 'GUZPD9014F', '2024-04-23', '1713864229', 'alexa@gmail.com', 1), (4, '8', 'Hazari Infotech', 'Chandigarh', 'DJHDH1234Y', '2024-05-30', '1717045228', 'hazarisah481@gmail.com', 1), (5, '8', 'Gvis', 'Chandigarh', 'GVISI3456D', '2024-05-30', '1717052770', 'hazarisah481@gmail.com', 1), (6, '8', 'Gvisone', 'Chandigarh', 'DJHDH1234Z', '2024-05-30', '1717054049', 'hazarisah481@gmail.com', 1); -- -------------------------------------------------------- -- -- Table structure for table `country_info` -- CREATE TABLE `country_info` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `status` int(50) NOT NULL COMMENT 'Active 1, IsActive 0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `country_info` -- INSERT INTO `country_info` (`id`, `name`, `status`) VALUES (1, 'India', 1); -- -------------------------------------------------------- -- -- Table structure for table `cronjob_activity` -- CREATE TABLE `cronjob_activity` ( `id` int(11) NOT NULL, `activity` varchar(10) NOT NULL, `running_status` varchar(5) NOT NULL COMMENT '0 means running, 1 means completed', `status` varchar(5) NOT NULL, `date` varchar(12) NOT NULL, `time` varchar(12) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `mail_body_queue` -- CREATE TABLE `mail_body_queue` ( `id` int(11) NOT NULL, `workspace_id` varchar(10) NOT NULL, `sender` varchar(50) NOT NULL, `subject` varchar(200) NOT NULL, `message` varchar(5000) NOT NULL, `attachment` varchar(50) DEFAULT NULL, `date` varchar(12) NOT NULL, `time` varchar(12) NOT NULL, `status` varchar(5) NOT NULL COMMENT '0 for pending, 1 for ready to be delivered, 2 for delivering, 3 for delivered, -1 for rejected', `priority` varchar(5) NOT NULL COMMENT '1-5 in decreasing order, 1 is the highest priority', `delete_immediate` int(11) NOT NULL COMMENT '1 for true, 0 for false' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `mail_body_queue` -- INSERT INTO `mail_body_queue` (`id`, `workspace_id`, `sender`, `subject`, `message`, `attachment`, `date`, `time`, `status`, `priority`, `delete_immediate`) VALUES (3, '1', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : hazarisah
\n Password : b&P8gTvS\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-02-14', '1707911874', '1', '1', 1), (4, '1', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : dhruvishah2
\n Password : SKTm57_v\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-02-14', '1707911942', '1', '1', 1), (5, '1', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : abhinav
\n Password : i#2lZFo7\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-02-14', '1707912758', '1', '1', 1), (6, '2', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : super1yash68@gmail.com
\n Password : @oDshKEC\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-03-28', '1711627615', '1', '1', 1), (7, '3', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : super1yash68@gmail.com
\n Password : #xBmjCLV\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-03-28', '1711627781', '1', '1', 1), (8, '4', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : super1yash68@gmail.com
\n Password : p5XkKy0a\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-03-28', '1711629271', '1', '1', 1), (9, '6', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : hazarisah48@gmail.com
\n Password : 84feTnUY\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-04-01', '1711953657', '1', '1', 1), (10, '7', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : alexa@gmail.com
\n Password : bUtafHzk\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-04-23', '1713864020', '1', '1', 1), (11, '8', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : hazarisah481@gmail.com
\n Password : tZCic$Jk\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-05-30', '1717045034', '1', '1', 1), (12, '8', 'Rejoice Solutions ', 'Welcome to Rejoice Solutions', '\n \n \n \n \n \n \n \n
\n
\n
\n \n
\n

Welcome To Rejoice Solutions

\n

Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or Click Here.

\n

\n Username : dhruvi123
\n Password : ks4reJOH\n

\n
Thanks and Regards

\n Sincerely,
\n The Rejoice Solutions Team.\n
\n\n
\n © Rejoice Learning LLP ®\n
\n
\n \n\n ', NULL, '2024-05-30', '1717052714', '1', '1', 1); -- -------------------------------------------------------- -- -- Table structure for table `mail_recipient_queue` -- CREATE TABLE `mail_recipient_queue` ( `id` int(11) NOT NULL, `mail_body_id` int(11) NOT NULL, `recipient` varchar(50) NOT NULL, `status` varchar(5) NOT NULL COMMENT '0 means undelivered, 1 means delivered, -1 means rejected' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `mail_recipient_queue` -- INSERT INTO `mail_recipient_queue` (`id`, `mail_body_id`, `recipient`, `status`) VALUES (3, 3, 'hazarisah48@gmail.com', '0'), (4, 4, 'divya.solanki@aaravsolutions.com', '0'), (5, 5, 'dhruvishah2911a@gmail.com', '0'), (6, 6, 'super1yash68@gmail.com', '0'), (7, 7, 'super1yash68@gmail.com', '0'), (8, 8, 'super1yash68@gmail.com', '0'), (9, 9, 'hazarisah48@gmail.com', '0'), (10, 10, 'alexa@gmail.com', '0'), (11, 11, 'hazarisah481@gmail.com', '0'), (12, 12, 'dhruvishah29111@gmail.com', '0'); -- -------------------------------------------------------- -- -- Table structure for table `otp_store` -- CREATE TABLE `otp_store` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `otp` varchar(50) NOT NULL, `user_token` varchar(255) NOT NULL, `otp_type` varchar(50) NOT NULL, `timestamp` varchar(50) NOT NULL, `status` varchar(50) NOT NULL COMMENT 'Active 1,Inactive 0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `logo` varchar(255) NOT NULL, `status` int(10) NOT NULL COMMENT '1 is Active,0 is InActive' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `name`, `logo`, `status`) VALUES (1, 'Finware', 'products/product_logos/Rejoice_Finware_V-Logo.png', 1), (2, 'Learning', 'products/product_logos/Rejoice_Learning_V-Logo.png', 1), (3, 'CRM', '', 0), (4, 'HR', '', 0), (5, 'Documents', 'products/product_logos/Rejoice_Documents_V-Logo.png', 0); -- -------------------------------------------------------- -- -- Table structure for table `reminders` -- CREATE TABLE `reminders` ( `id` int(11) NOT NULL, `userid` varchar(11) NOT NULL, `workspace_id` int(11) NOT NULL, `title` varchar(50) NOT NULL, `description` varchar(255) NOT NULL, `priority` varchar(50) DEFAULT NULL, `shared_with` varchar(11) DEFAULT NULL, `date_time_created` varchar(50) NOT NULL, `last_modified_date` varchar(50) DEFAULT NULL, `mark_status` varchar(11) NOT NULL, `created_by` varchar(50) NOT NULL, `last_modified_by` varchar(50) DEFAULT NULL, `reminder_date` varchar(50) NOT NULL, `reminder_time` varchar(50) DEFAULT NULL, `repeat_on` varchar(255) DEFAULT NULL COMMENT 'Every Year,Never,Every Month,Every Day and Mon to Sun', `reference` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `state_info` -- CREATE TABLE `state_info` ( `id` int(50) NOT NULL, `country_id` int(50) NOT NULL, `state` varchar(50) NOT NULL, `state_code` varchar(50) NOT NULL, `status` int(50) NOT NULL COMMENT 'Active 1 and InActive 0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `state_info` -- INSERT INTO `state_info` (`id`, `country_id`, `state`, `state_code`, `status`) VALUES (1, 1, 'Andhra pradesh', '37', 1), (2, 1, 'Assam', '18', 1), (3, 1, 'Arunachal pradesh', '12', 1), (4, 1, 'Bihar', '10', 1), (5, 1, 'Gujarat', '24', 1), (6, 1, 'Haryana', '06', 1), (7, 1, 'Himachal pradesh', '02', 1), (8, 1, 'Jammu & kashmir', '01', 1), (9, 1, 'Karnataka', '29', 1), (10, 1, 'Kerala', '32', 1), (11, 1, 'Madhya pradesh', '23', 1), (12, 1, 'Maharashtra', '27', 1), (13, 1, 'Manipur', '14', 1), (14, 1, 'Meghalaya', '17', 1), (15, 1, 'Mizoram', '15', 1), (16, 1, 'Nagaland', '13', 1), (17, 1, 'Orissa', '21', 1), (18, 1, 'Punjab', '03', 1), (19, 1, 'Rajasthan', '08', 1), (20, 1, 'Sikkim', '11', 1), (21, 1, 'Tamil nadu', '33', 1), (22, 1, 'Tripura', '16', 1), (23, 1, 'Uttar pradesh', '09', 1), (24, 1, 'West bengal', '19', 1), (25, 1, 'Delhi', '07', 1), (26, 1, 'Goa', '30', 1), (27, 1, 'Pondichery', '97', 1), (28, 1, 'Lakshdweep', '97', 1), (29, 1, 'Daman & diu', '26', 1), (30, 1, 'Dadra & nagar', '26', 1), (31, 1, 'Chandigarh', '04', 1), (32, 1, 'Andaman & nicobar', '35', 1), (33, 1, 'Uttaranchal', '97', 1), (34, 1, 'Jharkhand', '20', 1), (35, 1, 'Chattisgarh', '22', 1); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `dob` varchar(50) NOT NULL, `gender` varchar(50) NOT NULL, `username` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `workspace_id` varchar(255) NOT NULL, `role` varchar(255) DEFAULT NULL COMMENT 'superadmin, admin, null for others', `password` varchar(255) NOT NULL, `designation` varchar(50) DEFAULT NULL, `date_time_created` varchar(50) NOT NULL, `status` int(11) NOT NULL COMMENT '1 for Active 0 for InActive' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `dob`, `gender`, `username`, `email`, `mobile`, `workspace_id`, `role`, `password`, `designation`, `date_time_created`, `status`) VALUES (1, 'Dhruvi Shah', '2024-01-12', 'F', 'dhruvishah2911@gmail.com', 'dhruvishah2911@gmail.com', '+918452525214', '1', 'superadmin', '$2y$10$hmQjgEPbcubqVQ0TB9eMROxgUr7bmg.gggAkUBtCotG4YA/Q05xda', 'CEO', '1706530578', 1), (2, 'Hazari', '1999-07-04', 'M', 'hazarisah', 'hazarisah48@gmail.com', '+917986715098', '1', NULL, '$2y$10$hmQjgEPbcubqVQ0TB9eMROxgUr7bmg.gggAkUBtCotG4YA/Q05xda', 'Software Developer', '1707911874', 1), (3, 'Divya Solanki', '2014-06-14', 'F', 'dhruvishah2', 'divya.solanki@aaravsolutions.com', '+918989898988', '1', NULL, '$2y$10$fzNbgpib0e6N2qRd8Boj/OOLvYWjoHrvs/Hqsw0UhdL0hbx8qBRWq', 'Backend Dev', '1707911942', 1), (4, 'Divya Solankis', '2024-02-02', 'M', 'abhinav', 'dhruvishah2911a@gmail.com', '+918525852582', '1', 'admin', '$2y$10$D41JdgXny8431mSt6mXl4uf16sWA0xKhJCUIp5xpWflqwuYJIFF/G', 'Admin', '1707912758', 1), (7, 'Yash Singh', '2024-03-01', 'M', 'super1yash68@gmail.com', 'super1yash68@gmail.com', '+919925155577', '4', 'superadmin', '$2y$10$2aEJRMpys2.WFXl01SYHHujJ2vV5.Oh7S.U/YUbOsF1hMSvqLs9P6', 'CEO', '1711629271', 1), (8, 'Lily Singh', '2024-03-01', 'F', 'hazarisah48@gmail.com', 'hazarisah48@gmail.com', '+919033452942', '6', 'superadmin', '$2y$10$.tBxL5n.5/ofLtyGLbK/kuyVA4g.geU711fOrwjz2gssDgkM5ntvi', 'Manager', '1711953657', 1), (9, 'Alexa', '2024-04-01', 'M', 'alexa@gmail.com', 'alexa@gmail.com', '+919033452944', '7', 'superadmin', '$2y$10$aarBMUiLTlFADriwuVdwluFAkd3ZC17GqYSeraNncjtHO0DiJSOpG', 'QA', '1713864020', 1), (10, 'Hazari', '2024-05-29', 'M', 'hazarisah481@gmail.com', 'hazarisah481@gmail.com', '+918585758578', '8', 'superadmin', '$2y$10$0w8KkwLkRmkhD8DAzwFw9OHrvwyZ8xykDO3pZOmaftVfUJpIBVQBG', 'Owner', '1717045034', 1), (11, 'Dhruvi Shah', '2024-05-02', 'F', 'dhruvi123', 'dhruvishah29111@gmail.com', '+918989898989', '8', NULL, '$2y$10$GRr/YNGN7OxEuCtypXN5veVPb6OdeDd.Or3ElSQE4uAB8KhfaODAy', 'Teacher', '1717052714', 1); -- -------------------------------------------------------- -- -- Table structure for table `user_launch_product` -- CREATE TABLE `user_launch_product` ( `id` int(11) NOT NULL, `userid` int(50) NOT NULL, `workspace_id` int(50) NOT NULL, `product_id` int(50) NOT NULL, `status` int(50) NOT NULL COMMENT '1 Active,0 InActive' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_launch_product` -- INSERT INTO `user_launch_product` (`id`, `userid`, `workspace_id`, `product_id`, `status`) VALUES (1, 10, 8, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `user_log` -- CREATE TABLE `user_log` ( `id` int(11) NOT NULL, `workspace_id` varchar(15) NOT NULL, `branch_id` varchar(11) DEFAULT NULL, `username` varchar(255) NOT NULL, `userid` varchar(10) NOT NULL, `device` varchar(100) NOT NULL, `ip` varchar(100) NOT NULL, `location` varchar(100) DEFAULT NULL, `time` varchar(100) NOT NULL, `date` varchar(100) NOT NULL, `jwttoken` varchar(500) NOT NULL, `status` varchar(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `user_products` -- CREATE TABLE `user_products` ( `id` int(11) NOT NULL, `userid` int(50) NOT NULL, `workspace_id` int(50) NOT NULL, `product_id` int(50) NOT NULL, `status` int(50) NOT NULL COMMENT '1 Active,0 InActive' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_products` -- INSERT INTO `user_products` (`id`, `userid`, `workspace_id`, `product_id`, `status`) VALUES (1, 11, 8, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `workspace_info` -- CREATE TABLE `workspace_info` ( `id` int(11) NOT NULL, `workspace_name` varchar(100) DEFAULT NULL, `workspace_address` varchar(200) DEFAULT NULL, `date_created` varchar(15) NOT NULL, `time_created` varchar(200) NOT NULL, `created_by` varchar(200) NOT NULL, `status` int(15) NOT NULL COMMENT '1 stands for active, 0 stands for blocked' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `workspace_info` -- INSERT INTO `workspace_info` (`id`, `workspace_name`, `workspace_address`, `date_created`, `time_created`, `created_by`, `status`) VALUES (1, 'Dhruvi', 'Gujarat', '2024-01-29', '1706530578', 'dhruvishah2911@gmail.com', 1), (6, 'Education', 'Delhi', '2024-04-01', '1711953657', 'hazarisah48@gmail.com', 1), (5, 'Learning', 'Chandigarh', '2024-03-28', '1711629271', 'super1yash68@gmail.com', 1), (7, 'Alexa', 'Mumbai', '2024-04-23', '1713864020', 'alexa@gmail.com', 1), (8, 'Hazari Infotech', 'Chandigarh', '2024-05-30', '1717045034', 'hazarisah481@gmail.com', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `branch_info` -- ALTER TABLE `branch_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `companies_info` -- ALTER TABLE `companies_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `country_info` -- ALTER TABLE `country_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cronjob_activity` -- ALTER TABLE `cronjob_activity` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `activity` (`activity`); -- -- Indexes for table `mail_body_queue` -- ALTER TABLE `mail_body_queue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mail_recipient_queue` -- ALTER TABLE `mail_recipient_queue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `otp_store` -- ALTER TABLE `otp_store` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reminders` -- ALTER TABLE `reminders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `state_info` -- ALTER TABLE `state_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `user_launch_product` -- ALTER TABLE `user_launch_product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_log` -- ALTER TABLE `user_log` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_products` -- ALTER TABLE `user_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `workspace_info` -- ALTER TABLE `workspace_info` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `branch_info` -- ALTER TABLE `branch_info` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `companies_info` -- ALTER TABLE `companies_info` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `country_info` -- ALTER TABLE `country_info` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `cronjob_activity` -- ALTER TABLE `cronjob_activity` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mail_body_queue` -- ALTER TABLE `mail_body_queue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `mail_recipient_queue` -- ALTER TABLE `mail_recipient_queue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `otp_store` -- ALTER TABLE `otp_store` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `reminders` -- ALTER TABLE `reminders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `state_info` -- ALTER TABLE `state_info` MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `user_launch_product` -- ALTER TABLE `user_launch_product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `user_log` -- ALTER TABLE `user_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_products` -- ALTER TABLE `user_products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `workspace_info` -- ALTER TABLE `workspace_info` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;