INSERT INTO `tblplan_features` (`id`, `name`, `codename`, `description`, `type`, `added_on`) VALUES (NULL, 'No of Staff', 'no_of_staff_allowed_in_plan', 'no_of_staff_allowed_in_plan', 'restrict', '2020-07-17 02:36:30'), (NULL, 'Client', 'client_module', 'client_module', 'allow', '2020-07-17 02:36:30'), (NULL, 'Estimate', 'estimate_module', 'Estimate', 'allow', '2020-07-17 02:36:30'), (NULL, 'Invoice', 'invoice_module', 'Invoice', 'allow', '2020-07-17 02:36:30'), (NULL, 'Task', 'task_module', 'Task', 'allow', '2020-07-17 02:36:30'), (NULL, 'Shopping List', 'shoppinglist_module', 'Shopping List', 'allow', '2020-07-17 02:36:30'), (NULL, 'Supplies', 'suppliers_supplies_module', 'Supplies', 'allow', '2020-07-17 02:36:30'), (NULL, 'No of stores allowed', 'no_of_supplies_stores_allowed', 'No of stores allowed', 'restrict', '2020-07-17 02:36:30'), (NULL, 'Tools', 'tools_module', 'Tools', 'allow', '2020-07-17 02:36:30'), (NULL, 'No of non tool tags allowed', 'no_of_nontooltags_tools_allowed', 'No of non tool tags allowed', 'restrict', '2020-07-17 02:36:30'), (NULL, 'Directory', 'directory_module', 'Directory', 'allow', '2020-07-17 02:36:30'), (NULL, 'Time Clock', 'timelog_module', 'Time Clock', 'allow', '2020-07-17 02:36:30'), (NULL, 'Custom SMTP', 'custom_smtp', 'Custom SMTP', 'allow', '2020-07-17 02:36:30'), (NULL, 'Reports', 'reports_module', 'Reports', 'allow', '2020-07-17 02:36:30'), (NULL, 'Post Inspection', 'post_inspection_module', 'Post Inspection', 'allow', '2020-07-17 02:36:30'), (NULL, 'Custom Branding (No-White Label)', 'custom_branding_module', 'Custom Branding (No-White Label)', 'allow', '2020-07-17 02:36:30'), (NULL, 'Lead Management', 'leads_module', 'Lead Management', 'allow', '2020-07-17 02:36:30'), (NULL, 'Quick Books Sync', 'quick_book_sync', 'Quick Books Sync', 'allow', '2020-07-17 02:36:30'), (NULL, 'Expense', 'expense_module', 'Expense', 'allow', '2020-07-17 02:36:30'), (NULL, 'Payment Gateway Integration', 'no_of_payment_gateway_integrations_allowed', 'Payment Gateway Integration', 'allow', '2020-07-17 02:36:30'), (NULL, 'Staff Management', 'staff_module', 'Staff Management', 'allow', '2020-07-17 02:36:30'), (NULL, 'To Do', 'to_do_module', 'To Do', 'allow', '2020-07-17 02:36:30'), (NULL, 'Announcement (Web)', 'announcement_module', 'Announcement (Web)', 'allow', '2020-07-17 02:36:30'), (NULL, 'Share Idea, Documents', 'share_ideas_documents_module', 'Share Idea, Documents', 'allow', '2020-07-17 02:36:30'), (NULL, 'Notification - Push Mobile', 'notification_push_mobile', 'Notification - Push Mobile', 'allow', '2020-07-17 02:36:30'), (NULL, 'Notifcation - Push Desktop', 'notification_push_desktop', 'Notifcation - Push Desktop', 'allow', '2020-07-17 02:36:30'), (NULL, 'Notification - Email', 'notification_via_email', 'Notification - Email', 'allow', '2020-07-17 02:36:30'), (NULL, 'Notification - SMS', 'notification_via_sms', 'Notification - SMS', 'allow', '2020-07-17 02:36:30'), (NULL, 'Activity Log', 'activity_log', 'Activity Log', 'allow', '2020-07-17 02:36:30'), (NULL, 'Product and services', 'products_services_module', 'Product and services', 'allow', '2020-07-17 02:36:30'), (NULL, 'No of Estimate Images', 'no_of_estimate_images_allowed', 'No of estimate images allowed in plan.', 'restrict', '2020-08-27 13:15:00'), (NULL, 'No of Estimate Files', 'no_of_estimate_files_allowed', 'No of estimate files allowed in plan.', 'restrict', '2020-08-27 13:15:00'), (NULL, 'No of Invoice Images', 'no_of_invoice_images_allowed', 'No of invoice images allowed in plan.', 'restrict', '2020-08-27 13:15:00'), (NULL, 'No of Invoice Files', 'no_of_invoice_files_allowed', 'No of invoice files allowed in plan.', 'restrict', '2020-08-27 13:15:00');
INSERT INTO `tblplan_features` (`id`, `name`, `codename`, `description`, `type`, `added_on`) VALUES (NULL, 'Redeem points', 'redeem_points', 'Redeem points', 'allow', current_timestamp());

INSERT INTO `tblplan_sets` (`id`, `plan_set_name`, `plan_set_description`, `start_date`, `end_date`, `reason_for_switching_plan`, `is_active`, `added_on`) VALUES (NULL, 'Launch plan set', 'Launch plan set', '2020-09-01 16:25:25', '2022-12-31 16:25:25', NULL, '0', current_timestamp());

INSERT INTO `tblplans` (`id`, `plan_sets_id`, `name`, `codename`, `description`, `monthly_price`, `yearly_price`, `plan_monthly_to_yearly_discount`, `added_on`) VALUES (NULL, '7', 'FREE', '7_free', 'Free plan', '0', '0', '0', current_timestamp()), (NULL, '7', 'PRO with limited features', '7_pro', 'PRO with limited features', '14', '9', '0', current_timestamp()), (NULL, '7', 'PRO 1 Elite with higher team members', '7_pro_elite', 'PRO 1 Elite with higher team members', '29', '19', '0', current_timestamp()), (NULL, '7', 'PRO 2 Exclusive', '7_pro_exclusive', 'PRO 2 Exclusive', '64', '49', '0', current_timestamp());


INSERT INTO `tblplan_features_value`(
    `id`,
    `plans_id`,
    `plans_features_id`,
    `value`,
    `other_data`,
    `added_on`
)
VALUES(
        NULL,
        '9',
        '1',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '2',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '3',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '4',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '5',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '6',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '7',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '8',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '9',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '10',
        '10',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '11',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '12',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '13',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '14',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '15',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '16',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '17',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '18',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '19',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '20',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '21',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '22',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '23',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '24',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '25',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '26',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '27',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '28',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '29',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '30',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '9',
        '31',
        '0',
        '{\r\n    \"outside_message\":\"You have limit of 0 photos on your plan. If you want to add more please upgrade.\",\r\n    \"inside_message\":\"You have limit of 0 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n    \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '9',
        '32',
        '0',
        '{\r\n \"outside_message\":\"You have limit of 0 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 0 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '9',
        '33',
        '0',
        '{\r\n \"outside_message\":\"You have limit of 0 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 0 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '9',
        '34',
        '0',
        '{\r\n \"outside_message\":\"You have limit of 0 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 0 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '9',
        '35',
        '0',
        '',
        '2020-08-27 03:55:50'
);

INSERT INTO `tblplan_features_value`(
    `id`,
    `plans_id`,
    `plans_features_id`,
    `value`,
    `other_data`,
    `added_on`
)
VALUES(
        NULL,
        '10',
        '1',
        '3',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '2',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '3',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '4',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '5',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '6',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '7',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '8',
        '3',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '9',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '10',
        '50',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '11',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '12',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '13',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '14',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '15',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '16',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '17',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '18',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '19',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '20',
        '2',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '21',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '22',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '23',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '24',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '25',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '26',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '27',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '28',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '29',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '30',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '10',
        '31',
        '5',
        '{\r\n    \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n    \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n    \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '10',
        '32',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '10',
        '33',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '10',
        '34',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '10',
        '35',
        '5',
        '',
        '2020-08-27 03:55:50'
);

INSERT INTO `tblplan_features_value`(
    `id`,
    `plans_id`,
    `plans_features_id`,
    `value`,
    `other_data`,
    `added_on`
)
VALUES(
        NULL,
        '11',
        '1',
        '10',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '2',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '3',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '4',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '5',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '6',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '7',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '8',
        'all',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '9',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '10',
        'unlimited',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '11',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '12',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '13',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '14',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '15',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '16',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '17',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '18',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '19',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '20',
        'all',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '21',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '22',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '23',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '24',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '25',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '26',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '27',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '28',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '29',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '30',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '11',
        '31',
        '5',
        '{\r\n    \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n    \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n    \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '11',
        '32',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '11',
        '33',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '11',
        '34',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '11',
        '35',
        '5',
        '',
        '2020-08-27 03:55:50'
);

INSERT INTO `tblplan_features_value`(
    `id`,
    `plans_id`,
    `plans_features_id`,
    `value`,
    `other_data`,
    `added_on`
)
VALUES(
        NULL,
        '12',
        '1',
        '30',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '2',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '3',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '4',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '5',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '6',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '7',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '8',
        'all',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '9',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '10',
        'unlimited',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '11',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '12',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '13',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '14',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '15',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '16',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '17',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '18',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '19',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '20',
        'all',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '21',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '22',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '23',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '24',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '25',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '26',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '27',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '28',
        '0',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '29',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '30',
        '1',
        NULL,
        '2020-07-17 02:36:30'
    ),(
        NULL,
        '12',
        '31',
        '5',
        '{\r\n    \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n    \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n    \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '12',
        '32',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '12',
        '33',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '12',
        '34',
        '5',
        '{\r\n \"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\r\n \"inside_message\":\"You have limit of 5 photos on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\r\n \"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"0\"}',
        '2020-08-27 03:55:50'
    ),(
        NULL,
        '12',
        '35',
        '5',
        '',
        '2020-08-27 03:55:50'
);

INSERT INTO `tblapad_options` (`id`, `type`, `name`, `value`, `autoload`) VALUES (NULL, 'ideas', 'allowed_file_extention', '{\"image\":[\"jpeg\",\"jpg\",\"png\",\"gif\"],\"video\":[],\"audio\":[],\"document\":[\"pdf\",\"doc\",\"docx\"]}', '1'), (NULL, 'ideas', 'allowed_file_count', '5', '1'), (NULL, 'ideas', 'allowed_file_size', '5120', '1'), (NULL, 'ideas', 'total_file_count', '10', '1');


INSERT INTO `tblmobile_push_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'not_published_new_post', '1');
INSERT INTO `tbldesktop_push_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'not_published_new_post', '1');
INSERT INTO `tblemail_push_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'not_published_new_post', '1');
INSERT INTO `tblsms_push_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'not_published_new_post', '1');
INSERT INTO `tblin_app_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'not_published_new_post', '1');
INSERT INTO `tblactivity_log_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'not_published_new_post', '1');
INSERT INTO `tblreward_distribution_config` 
(`id`, `codename`, `is_active`, `reward_for`, `is_multiple_distribution`, `reward_to_a`, `reward_to_b`) 
VALUES 
(NULL, 'not_published_new_post', '0', 'both', '1', '50', '50');

ALTER TABLE `tblitems` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

CREATE TABLE `tblglobal_products_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` mediumtext NOT NULL,
  `long_description` text DEFAULT NULL,
  `rate` decimal(15,2) DEFAULT '0.00',
  `tax` bigint(20) UNSIGNED DEFAULT NULL,
  `tax2` bigint(20) UNSIGNED DEFAULT NULL,
  `unit` varchar(40) DEFAULT NULL,
  `industry_id` bigint(20) UNSIGNED NOT NULL,
  `group` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `tblglobal_products_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tax` (`tax`),
  ADD KEY `tax2` (`tax2`),
  ADD KEY `industry_id` (`industry_id`);

INSERT INTO `tblindustry` (`id`, `name`, `code_name`) VALUES (NULL, 'Junk Removal', 'junk_removal');

INSERT INTO `tblglobal_products_services` (`id`, `description`, `long_description`, `rate`, `tax`, `tax2`, `unit`, `industry_id`, `group`) VALUES
(1, 'Carpet Cleaning', 'Full carpet shampoo and rinse', '0.00', NULL, NULL, NULL, 1, 'Services'),
(2, 'Area Rug Cleaning', 'Cleaning of removable area rugs', '0.00', NULL, NULL, NULL, 1, 'Services'),
(3, 'Upholstery Cleaning', 'Cleaning of upholstery on couches, chairs and other furniture', '0.00', NULL, NULL, NULL, 1, 'Services'),
(4, 'Deodorizing/Disinfecting', 'Deodorize or disinfect specific area or furniture', '0.00', NULL, NULL, NULL, 1, 'Services'),
(5, 'Spot Stain Removal', 'Spot stain removal service', '0.00', NULL, NULL, NULL, 1, 'Services'),
(6, 'Scotchgard', 'Stain repellent Scotchgard service', '0.00', NULL, NULL, NULL, 1, 'Services'),
(7, 'General Commercial and Office Clean', 'Full cleaning of commercial and office spaces', '0.00', NULL, NULL, NULL, 2, 'Services'),
(8, 'Construction Cleanup', 'Cleanup of construction debris', '0.00', NULL, NULL, NULL, 2, 'Services'),
(9, 'Event Cleanup', '', '0.00', NULL, NULL, NULL, 2, 'Services'),
(10, 'Medical Office Cleaning', 'Cleaning of medical offices with additional care and attention to the unique needs of the medical professions', '0.00', NULL, NULL, NULL, 2, 'Services'),
(11, 'Janitorial Service', '', '0.00', NULL, NULL, NULL, 2, 'Services'),
(12, 'Professional One-Time Cleaning', '', '0.00', NULL, NULL, NULL, 2, 'Services'),
(13, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 2, 'Services'),
(14, 'Weekly Cleaning Service', '', '0.00', NULL, NULL, NULL, 2, 'Services'),
(15, 'Monthly Cleaning Service', '', '0.00', NULL, NULL, NULL, 2, 'Services'),
(16, 'Deep Clean', '', '0.00', NULL, NULL, NULL, 2, 'Services'),
(17, 'Vinyl & Aluminum Siding', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(18, 'Chimney', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(19, 'Patios & Patio Furniture', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(20, 'Fences', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(21, 'Pool Deck', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(22, 'Brick', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(23, 'Facade', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(24, 'Storefront', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(25, 'Awning', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(26, 'Sidewalks', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(27, 'Canopies', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(28, 'Stairs', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(29, 'Railings', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(30, 'Underground Parking', '', '0.00', NULL, NULL, NULL, 3, 'Services'),
(31, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 3, 'Services'),
(32, 'Bathrooms', 'Clean floors, shower enclosures, tubs and tiles, sinks, mirrors, toilets and polish fixtures', '0.00', NULL, NULL, NULL, 4, 'Services'),
(33, 'Kitchen', 'Clean cupboard doors, sink, stovetop, counter tops and backsplash area, clean outside of oven, fridge, dishwasher and small appliances, vacuum and wash floor', '0.00', NULL, NULL, NULL, 4, 'Services'),
(34, 'Living Areas', 'Dust all surfaces, clean glass picture frames and mirrors, remove spots from walls, dust/polish furniture, baseboards and window sills, vacuum/clean furniture and floors', '0.00', NULL, NULL, NULL, 4, 'Services'),
(35, 'Bedrooms', 'Dust all surfaces, clean glass picture frames and mirrors, remove spots from walls, dust/polish furniture, baseboards and window sills, vacuum/clean furniture and floors', '0.00', NULL, NULL, NULL, 4, 'Services'),
(36, 'Inside Fridge', 'Remove all items from fridge and clean and disinfect', '0.00', NULL, NULL, NULL, 4, 'Services'),
(37, 'Inside Oven', 'Clean inside of oven with industrial strength oven cleaner', '0.00', NULL, NULL, NULL, 4, 'Services'),
(38, 'Laundry', 'Wash, dry, fold and put away laundry', '0.00', NULL, NULL, NULL, 4, 'Services'),
(39, 'Weekly Cleaning', '', '0.00', NULL, NULL, NULL, 4, 'Services'),
(40, 'Deep Clean', '', '0.00', NULL, NULL, NULL, 4, 'Services'),
(41, 'Exterior High-Level Windows', 'Clean all exterior windows on upper levels', '0.00', NULL, NULL, NULL, 25, 'Services'),
(42, 'Exterior Low-Level Windows', 'Clean all exterior windows on main level', '0.00', NULL, NULL, NULL, 25, 'Services'),
(43, 'Gutter/Eavestroughs Cleaning', 'Clean all gutters/eavestroughs', '0.00', NULL, NULL, NULL, 25, 'Services'),
(44, 'Hang Christmas Lights', 'Install Christmas lights', '0.00', NULL, NULL, NULL, 25, 'Services'),
(45, 'Interior Windows', 'Clean all interior windows', '0.00', NULL, NULL, NULL, 25, 'Services'),
(46, 'Pressure Wash Driveway', 'Pressure wash the driveway', '0.00', NULL, NULL, NULL, 25, 'Services'),
(47, 'Pressure Washing', 'Pressure wash exterior on all levels', '0.00', NULL, NULL, NULL, 25, 'Services'),
(48, 'Remove Christmas Lights', 'Remove Christmas lights', '0.00', NULL, NULL, NULL, 25, 'Services'),
(49, 'Tree Pruning', 'General pruning to remove dead, damaged or crossing branches', '0.00', NULL, NULL, NULL, 5, 'Services'),
(50, 'Stump Removal', '', '0.00', NULL, NULL, NULL, 5, 'Services'),
(51, 'Tree Removal', '', '0.00', NULL, NULL, NULL, 5, 'Services'),
(52, 'Hedge Trimming', 'Trim hedges to control size and re-establish natural shape', '0.00', NULL, NULL, NULL, 5, 'Services'),
(53, 'Hedge Removal', '', '0.00', NULL, NULL, NULL, 5, 'Services'),
(54, 'Haul Debris', 'Haul debris from site', '0.00', NULL, NULL, NULL, 5, 'Services'),
(55, 'Mulch', '', '0.00', NULL, NULL, NULL, 5, 'Services'),
(56, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 5, 'Services'),
(57, 'Prune Tree', 'Prune tree as described in notes', '0.00', NULL, NULL, NULL, 6, 'Services'),
(58, 'Mulch', '', '0.00', NULL, NULL, NULL, 6, 'Services'),
(59, 'Irrigation Systems', '', '0.00', NULL, NULL, NULL, 6, 'Services'),
(60, 'Mowing', '', '0.00', NULL, NULL, NULL, 6, 'Services'),
(61, 'matting', '', '0.00', NULL, NULL, NULL, 6, 'Services'),
(62, 'Stonework', '', '0.00', NULL, NULL, NULL, 6, 'Services'),
(63, 'Labor', 'Hourly Labor Charge', '0.00', NULL, NULL, NULL, 6, 'Services'),
(64, 'Maintenance Contract', '', '0.00', NULL, NULL, NULL, 6, 'Services'),
(65, 'Lawn Aeration', 'Aerate lawn', '0.00', NULL, NULL, NULL, 6, 'Services'),
(66, 'Spread Fertilizer', 'Fertilizer treatment for lawn area', '0.00', NULL, NULL, NULL, 6, 'Services'),
(67, 'Mow Lawn', 'Mow all lawn areas', '0.00', NULL, NULL, NULL, 26, 'Services'),
(68, 'Lawn Aeration', 'Aerate lawn', '0.00', NULL, NULL, NULL, 26, 'Services'),
(69, 'Spread Fertilizer', 'Fertilizer treatment for lawn area', '0.00', NULL, NULL, NULL, 26, 'Services'),
(70, 'Trim Hedges', 'Trim hedges as described in notes', '0.00', NULL, NULL, NULL, 26, 'Services'),
(71, 'Weeding', 'Weed all lawn and garden areas', '0.00', NULL, NULL, NULL, 26, 'Services'),
(72, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 26, 'Services'),
(73, 'Routine Computer Maintenance', '', '0.00', NULL, NULL, NULL, 7, 'Services'),
(74, 'Backup Data', '', '0.00', NULL, NULL, NULL, 7, 'Services'),
(75, 'Component Installation', '', '0.00', NULL, NULL, NULL, 7, 'Services'),
(76, 'Software Installation', '', '0.00', NULL, NULL, NULL, 7, 'Services'),
(77, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 7, 'Services'),
(78, 'Setup Service', '', '0.00', NULL, NULL, NULL, 7, 'Services'),
(79, 'Data Migration', '', '0.00', NULL, NULL, NULL, 7, 'Services'),
(80, 'Sound System', 'Install speakers and audio receiver', '0.00', NULL, NULL, NULL, 8, 'Services'),
(81, 'Home Theater', 'Install speakers, television and audio receiver', '0.00', NULL, NULL, NULL, 8, 'Services'),
(82, 'Projector System', 'Install projector and screen', '0.00', NULL, NULL, NULL, 8, 'Services'),
(83, 'Lighting Control', 'Automated dimming', '0.00', NULL, NULL, NULL, 8, 'Services'),
(84, 'Motorized Shades', 'Automated shade closing for the theater', '0.00', NULL, NULL, NULL, 8, 'Services'),
(85, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 8, 'Services'),
(86, 'Materials', '', '0.00', NULL, NULL, NULL, 8, 'Services'),
(87, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 27, 'Services'),
(88, 'Monitoring Fee', '', '0.00', NULL, NULL, NULL, 27, 'Services'),
(89, 'Installation', '', '0.00', NULL, NULL, NULL, 27, 'Services'),
(90, 'Equipment Cost', '', '0.00', NULL, NULL, NULL, 27, 'Services'),
(91, 'Service Cell', '', '0.00', NULL, NULL, NULL, 27, 'Services'),
(92, 'Drain Cleaning', 'Clean clogged drains and ensure proper water flow', '0.00', NULL, NULL, NULL, 28, 'Services'),
(93, 'Septic System Installation', 'Install septic tank and plumbing', '0.00', NULL, NULL, NULL, 28, 'Services'),
(94, 'Full Bathroom Install', 'Sink, faucet and toilet installation.', '0.00', NULL, NULL, NULL, 28, 'Services'),
(95, 'New Water Line', 'Run new water line from main water line.', '0.00', NULL, NULL, NULL, 28, 'Services'),
(96, 'Pump Installation', 'Installation of new water pump', '0.00', NULL, NULL, NULL, 28, 'Services'),
(97, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 28, 'Services'),
(98, 'Materials', '', '0.00', NULL, NULL, NULL, 28, 'Services'),
(99, 'High Pressure Flushing', 'Clear clogged pipes with high pressure flushing equipment', '0.00', NULL, NULL, NULL, 13, 'Services'),
(100, 'Sump Pump Repair/Replacement', 'Repair or replace damaged or inoperable sump pumps', '0.00', NULL, NULL, NULL, 13, 'Services'),
(101, 'Air Conditioning & Refrigeration Servicing', 'Service air conditioning and refrigeration equipment', '0.00', NULL, NULL, NULL, 13, 'Services'),
(102, 'Air Filtration Servicing', 'Service residential and commercial air filtration systems', '0.00', NULL, NULL, NULL, 13, 'Services'),
(103, 'Heating System Servicing', 'Service gas, oil, steam, hot water, forced air, and electric heating equipment', '0.00', NULL, NULL, NULL, 13, 'Services'),
(104, 'Electrical System Servicing', 'Lighting, fans, and electric heaters', '0.00', NULL, NULL, NULL, 13, 'Services'),
(105, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 13, 'Services'),
(106, 'No services', '', '0.00', NULL, NULL, NULL, 12, 'Services'),
(107, 'HVAC Design and Installation', 'Complete HVAC design and installation - including material and equipment', '0.00', NULL, NULL, NULL, 11, 'Services'),
(108, 'Commercial Tenant Improvement', 'Heat pumps, A/C, ventilation systems', '0.00', NULL, NULL, NULL, 11, 'Services'),
(109, 'Industrial Ventilation', 'Installation & Servicing of industrial ventilation systems', '0.00', NULL, NULL, NULL, 11, 'Services'),
(110, 'Sheet Metal Work', 'Custom sheet metal work and fabrication', '0.00', NULL, NULL, NULL, 11, 'Services'),
(111, 'Residential HVAC Servicing', 'Servicing of residential HVAC systems', '0.00', NULL, NULL, NULL, 11, 'Services'),
(112, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 11, 'Services'),
(113, 'AC Repair', '', '0.00', NULL, NULL, NULL, 11, 'Services'),
(114, 'Safety Inspection', '', '0.00', NULL, NULL, NULL, 11, 'Services'),
(115, 'Duct Cleaning', '', '0.00', NULL, NULL, NULL, 11, 'Services'),
(116, 'Lighting Design', 'Lighting plan design for specific areas', '0.00', NULL, NULL, NULL, 10, 'Services'),
(117, 'Lighting Installation', 'Installation of lighting fixtures.', '0.00', NULL, NULL, NULL, 10, 'Services'),
(118, 'Fan Installation', 'Installation of ceiling fans, exhaust fans, and other permanent fans', '0.00', NULL, NULL, NULL, 10, 'Services'),
(119, 'Additional Outlet Installation', 'Installation of additional power outlets', '0.00', NULL, NULL, NULL, 10, 'Services'),
(120, 'Safety Inspection', 'Certified safety inspection of all electrical', '0.00', NULL, NULL, NULL, 10, 'Services'),
(121, 'Circuit Breaker Replacement', 'Circuit breaker replacement and maintenance', '0.00', NULL, NULL, NULL, 10, 'Services'),
(122, 'Wiring Upgrade/Replacement', 'Upgrade or replace old wiring', '0.00', NULL, NULL, NULL, 10, 'Services'),
(123, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 10, 'Services'),
(124, 'Materials', '', '0.00', NULL, NULL, NULL, 10, 'Services'),
(125, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 9, 'Services'),
(126, 'Materials', '', '0.00', NULL, NULL, NULL, 9, 'Services'),
(127, 'Example', '', '0.00', NULL, NULL, NULL, 24, 'Services'),
(128, 'Driveway', 'Driveway snow removal', '0.00', NULL, NULL, NULL, 23, 'Services'),
(129, 'Sidewalk and Entrance', 'Sidewalk and Entrance snow removal', '0.00', NULL, NULL, NULL, 23, 'Services'),
(130, 'Loading Dock', 'Loading dock snow removal', '0.00', NULL, NULL, NULL, 23, 'Services'),
(131, 'Parking Lot', 'parking lot Snow removal', '0.00', NULL, NULL, NULL, 23, 'Services'),
(132, 'Salt or Sand', 'Cover surface with salt or sand', '0.00', NULL, NULL, NULL, 23, 'Services'),
(133, 'New Construction', 'Installation of roof in new construction project', '0.00', NULL, NULL, NULL, 22, 'Services'),
(134, 'Re-Roofing', 'Remove old roof and replace with new materials', '0.00', NULL, NULL, NULL, 22, 'Services'),
(135, 'Repair', 'Roofing repair service', '0.00', NULL, NULL, NULL, 22, 'Services'),
(136, 'Moss Removal', 'Remove moss from roof', '0.00', NULL, NULL, NULL, 22, 'Services'),
(137, 'Gutter Cleaning', 'Clean dirt and debris from gutters', '0.00', NULL, NULL, NULL, 22, 'Services'),
(138, 'Inspections / Consultations', 'Certified roofing inspections and consultations', '0.00', NULL, NULL, NULL, 22, 'Services'),
(139, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 22, 'Services'),
(140, 'Materials', '', '0.00', NULL, NULL, NULL, 22, 'Services'),
(141, 'Bathroom Renovation', 'Bathroom floor, vanity and shower', '0.00', NULL, NULL, NULL, 21, 'Services'),
(142, 'Kitchen Renovation', 'Kitchen floor, counters and cupboards', '0.00', NULL, NULL, NULL, 21, 'Services'),
(143, 'Basement Renovation (unfinished)', 'Framing, flooring and other finishing for unfinished basement', '0.00', NULL, NULL, NULL, 21, 'Services'),
(144, 'Basement Renovation (existing)', 'Renovation of existing basement', '0.00', NULL, NULL, NULL, 21, 'Services'),
(145, 'Tile Installations/Ceramics', 'Installation of tile and ceramic flooring', '0.00', NULL, NULL, NULL, 21, 'Services'),
(146, 'Custom Carpentry', 'Custom made cabinetry, mouldings, fixtures, etc', '0.00', NULL, NULL, NULL, 21, 'Services'),
(147, 'Decks and Patios', 'Custom decks, patios and yard furniture', '0.00', NULL, NULL, NULL, 21, 'Services'),
(148, 'Interlock Installations', 'Installation of interlocking walkways, driveways, patios, etc', '0.00', NULL, NULL, NULL, 21, 'Services'),
(149, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 21, 'Services'),
(150, 'Materials', '', '0.00', NULL, NULL, NULL, 21, 'Services'),
(151, 'Regular Maintenance', 'Water tested, chemicals adjusted, surfaces sanitized, filters cleaned and mechanics checked', '0.00', NULL, NULL, NULL, 20, 'Services'),
(152, 'Drain and Refill', 'Complete drain and refill of spa or pool', '0.00', NULL, NULL, NULL, 20, 'Services'),
(153, 'Winterizing', 'Proper draining of spa or pool and line blowout', '0.00', NULL, NULL, NULL, 20, 'Services'),
(154, 'Start of Season Service', 'Pool opening and mechanical check', '0.00', NULL, NULL, NULL, 20, 'Services'),
(155, 'Filter Cleaning', 'Spa or pool filter cleaning', '0.00', NULL, NULL, NULL, 20, 'Services'),
(156, 'Spa Removal or Move', 'Remove or relocate an existing spa', '0.00', NULL, NULL, NULL, 20, 'Services'),
(157, 'Treatment Chemical Delivery', 'Delivery of water treatment chemicals to customer doorstep', '0.00', NULL, NULL, NULL, 20, 'Services'),
(158, 'Spa Orientation', 'Orientation session with customer to teach basics of spa care and maintenance', '0.00', NULL, NULL, NULL, 20, 'Services'),
(159, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 20, 'Services'),
(160, 'Materials', '', '0.00', NULL, NULL, NULL, 20, 'Services'),
(161, 'Rodent Control', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(162, 'Mosquito Control', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(163, 'Roaches', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(164, 'Ants', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(165, 'Wasps', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(166, 'Wildlife', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(167, 'Fumigation', '', '0.00', NULL, NULL, NULL, 19, 'Services'),
(168, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 19, 'Services'),
(169, 'Inspection', 'Complete inspection for potential pest problems', '0.00', NULL, NULL, NULL, 19, 'Services'),
(170, 'Baseboards', 'Paint Baseboards', '0.00', NULL, NULL, NULL, 18, 'Services'),
(171, 'Ceiling', 'Paint Ceiling', '0.00', NULL, NULL, NULL, 18, 'Services'),
(172, 'Closets', 'Paint Closets', '0.00', NULL, NULL, NULL, 18, 'Services'),
(173, 'Door & Frame', 'Paint Door & Frame', '0.00', NULL, NULL, NULL, 18, 'Services'),
(174, 'Floor', 'Paint/Coat Floor', '0.00', NULL, NULL, NULL, 18, 'Services'),
(175, 'Primer', 'Prime area in preparation for painting', '0.00', NULL, NULL, NULL, 18, 'Services'),
(176, 'Remove Paper', 'Remove wall paper in preparation for painting', '0.00', NULL, NULL, NULL, 18, 'Services'),
(177, 'Remove Popcorn Ceiling', 'Scrape ceiling in preparation for painting', '0.00', NULL, NULL, NULL, 18, 'Services'),
(178, 'Walls', 'Paint walls ', '0.00', NULL, NULL, NULL, 18, 'Services'),
(179, 'Window Trim', 'PaintWindow Trim', '0.00', NULL, NULL, NULL, 18, 'Services'),
(180, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 18, 'Services'),
(181, 'Drop off', 'Drop off at client\'s property', '0.00', NULL, NULL, NULL, 17, 'Services'),
(182, 'Pick up', 'Pick up from client\'s property', '0.00', NULL, NULL, NULL, 17, 'Services'),
(183, 'Junk Clean out', '', '0.00', NULL, NULL, NULL, 17, 'Services'),
(184, 'Hauling', '', '0.00', NULL, NULL, NULL, 17, 'Services'),
(185, 'Dump Run', '', '0.00', NULL, NULL, NULL, 17, 'Services'),
(186, 'Furniture Removal', '', '0.00', NULL, NULL, NULL, 17, 'Services'),
(187, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 17, 'Services'),
(188, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 16, 'Services'),
(189, 'Materials', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(190, 'Window Installation', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(191, 'Maintenance', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(192, 'Painting', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(193, 'Door Repair', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(194, 'Assembly', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(195, 'Repair', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(196, 'Drywall Repair', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(197, 'Gutter Cleaning', '', '0.00', NULL, NULL, NULL, 16, 'Services'),
(198, 'Carpet Repairs', 'Repair damaged sections of carpet', '0.00', NULL, NULL, NULL, 15, 'Services'),
(199, 'Carpet Stretching', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(200, 'Carpet Binding', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(201, 'Edge Finishing', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(202, 'Custom Carpet Design', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(203, 'Carpet Logo', 'Incorporate a provided logo into a section of carpet', '0.00', NULL, NULL, NULL, 15, 'Services'),
(204, 'Carpet Borders', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(205, 'Sanding & Finishing of Old Hardwood', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(206, 'Bamboo Floor Installation', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(207, 'Hardwood Floor Installation', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(208, 'Cork Floor Installation', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(209, 'Vinyl Floor Installation', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(210, 'Tile Floor Installation', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(211, 'Existing Floor Removal', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(212, 'Labor', '', '0.00', NULL, NULL, NULL, 15, 'Services'),
(213, 'Dishwasher Repair', 'Troubleshoot and repair dishwasher', '0.00', NULL, NULL, NULL, 14, 'Services'),
(214, 'Refrigerator Repair', 'Troubleshoot and repair refrigerator', '0.00', NULL, NULL, NULL, 14, 'Services'),
(215, 'Garburator Installation', 'Electric garburator installation', '0.00', NULL, NULL, NULL, 14, 'Services'),
(216, 'Labor', 'Hourly labor charge', '0.00', NULL, NULL, NULL, 14, 'Services'),
(217, 'Dryer Repair', 'Troubleshoot and repair dryer', '0.00', NULL, NULL, NULL, 14, 'Services'),
(218, 'Washing Machine Repair', 'Troubleshoot and repair washing machine', '0.00', NULL, NULL, NULL, 14, 'Services');

ALTER TABLE `tblestimates` ADD `estimate_number_text` VARCHAR(191) NULL DEFAULT NULL AFTER `number_format`;