-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- 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 <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>hazarisah</b><br>\n        Password : <b>b&P8gTvS</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-02-14', '1707911874', '1', '1', 1),
(4, '1', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>dhruvishah2</b><br>\n        Password : <b>SKTm57_v</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-02-14', '1707911942', '1', '1', 1),
(5, '1', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>abhinav</b><br>\n        Password : <b>i#2lZFo7</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-02-14', '1707912758', '1', '1', 1),
(6, '2', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>super1yash68@gmail.com</b><br>\n        Password : <b>@oDshKEC</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-03-28', '1711627615', '1', '1', 1),
(7, '3', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>super1yash68@gmail.com</b><br>\n        Password : <b>#xBmjCLV</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-03-28', '1711627781', '1', '1', 1),
(8, '4', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>super1yash68@gmail.com</b><br>\n        Password : <b>p5XkKy0a</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-03-28', '1711629271', '1', '1', 1),
(9, '6', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>hazarisah48@gmail.com</b><br>\n        Password : <b>84feTnUY</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-04-01', '1711953657', '1', '1', 1),
(10, '7', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>alexa@gmail.com</b><br>\n        Password : <b>bUtafHzk</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-04-23', '1713864020', '1', '1', 1),
(11, '8', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a workspace account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>hazarisah481@gmail.com</b><br>\n        Password : <b>tZCic$Jk</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', NULL, '2024-05-30', '1717045034', '1', '1', 1),
(12, '8', 'Rejoice Solutions <no-reply@rejoicesolutions.in>', 'Welcome to Rejoice Solutions', '\n        <html>\n            <head>\n                <meta charset=\'utf-8\'>\n                <meta name=\'viewport\' content=\'width=device-width, initial-scale=1.0\'>\n                <style>\n                    body {\n                        color: #494949 !important;\n                        font-family: \'Plus Jakarta Sans\', sans-serif;\n                        margin: 0px;\n                        width: 100%;\n                        display: flex;\n                        justify-content: center;\n                    }\n\n                    a {\n                        color: dodgerblue;\n                    }\n\n                    div {\n                        float: left;\n                    }\n\n                    .header {\n                        width: 100%;\n                        padding: 20px 20px 0px 20px;\n                    }\n\n                    .mail_body {\n                        width: 100%;\n                        padding: 10px 20px 0px 20px;\n                    }\n\n                    .end_mail_body_greetings {\n                        width: 100%;\n                        padding: 0px 20px 10px 20px;\n                    }\n\n                    .footer {\n                        width: 100%;\n                        padding: 20px;\n                        background: #dadada29;\n                        border-top: #e5e5e5 solid thin;\n                        font-size: 8pt;\n                        text-align: center;\n                        color: #656565;\n                    }\n\n                    .web_app_title {\n                        color: #fe7b0f !important;\n                    }\n\n                    h1 {\n                        font-size: 18pt;\n                        font-weight: 400;\n                        margin: 5px 0px;\n                        color: #494949;\n                    }\n\n                    .header_logo img {\n                        width: 230px;\n                    }\n\n                    .body_container {\n                        max-width: 1000px;\n                    }\n                </style>\n            </head>\n            <body>\n            <div class=\'body_container\'>\n                <div class=\'header\'>\n                    <div class=\'header_logo\'>\n                        <img src=\'http://console.rejoicesolutions.in/api_console_rejoice_solutions/resources/assets/logo/logo.png\'>\n                    </div>\n    </div><div class=\'mail_body\'><h1>Welcome To <span class=\'web_app_title\'>Rejoice Solutions</span></h1>\n    <p>Thank you for creating a user account on Rejoice Solutions. You can now sign in at http://console.rejoicesolutions.in or <a href=\'http://console.rejoicesolutions.in\'>Click Here</a>. </p>\n    <p>\n        Username : <b>dhruvi123</b><br>\n        Password : <b>ks4reJOH</b>\n    </p></div>\n        <div class=\'end_mail_body_greetings\'>Thanks and Regards<br><br>\n                    Sincerely,<br>\n                    The Rejoice Solutions Team.\n                </div>\n\n                <div class=\'footer\'>\n                    &#169; Rejoice Learning LLP &#174;\n                </div>\n            </div>\n        </body>\n\n    </html>', 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 `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 `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 `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 `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 `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 `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;

