INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`, `is_highlight`) VALUES ('Priority Support & Onboarding Assistance', 'priority_support', "Ultimate users are first in line for support. Live chat. Phone. Email. Tickets. Whatever you need, whenever you need it. Need help getting your entire team trained up on Contractor+? Schedule a 1 on 1 onboarding call - we've got you covered!", 'allow', NOW(), 1);
SET @priority_support_id = LAST_INSERT_ID();
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('9', @priority_support_id, '0', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('10', @priority_support_id, '0', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('11', @priority_support_id, '0', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('12', @priority_support_id, '1', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('13', @priority_support_id, '0', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('14', @priority_support_id, '0', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('15', @priority_support_id, '1', UTC_TIMESTAMP());

UPDATE tblplan_features SET is_highlight = 1, name = 'Wisetack Financing', description='You can optionally remove the financing offer from your invoices.' WHERE codename = 'update_display_financing_offer_to_client';

UPDATE tblplan_features SET is_highlight = 1, name = '3M+ Material Prices', description='Access to over 3 million material prices, with national average cost data. If you need current local pricing, this is available in our Pro and Ultimate subscriptions' WHERE codename = 'suppliers_supplies_module';

UPDATE tblplan_features SET is_highlight = 1, name = 'Time Clock', description="You can have your individual employees clock in and out against any task or job. You (or your managers) can optionally clock in and out on behalf of individual team members and even edit their past entry's. This will make your bookkeepers life a lot easier, while also giving you the ability to generate reports to know how efficient your employees are." WHERE codename = 'timelog_module';

UPDATE tblplan_features SET is_highlight = 1, name = 'Tool & Equipment Tracking', description='A streamlined tool and asset management solution with optional low-cost Bluetooth Tool Tags™ or one of 3 GPS trackers (no contracts, $25/tracker/month). Stop your tools from growing legs, hold your team and subs accountable, and always know where everything is located.' WHERE codename = 'tools_module';

UPDATE tblplan_features_value SET value = 0 WHERE plans_id IN (9, 13) AND plans_features_id IN (SELECT id FROM tblplan_features WHERE codename = 'custom_branding_module');

UPDATE tblplan_features SET is_highlight = 1, name = 'Automated Client Referrals', description="Built-in automation settings that let you promote your referral program to your clients. You can specify how much you want to pay for client referrals, and Contractor+ will automatically promote your referral incentive to your clients. You can specify WHEN you want your clients to learn about your referral program, and we'll handle the rest." WHERE codename = 'client_referral';

UPDATE tblplan_features SET is_highlight = 1, name = 'QuickBooks Online Integration', description='Sync your clients, estimates, invoices, payments, expenses and products & services with QuickBooks Online. ' WHERE codename = 'quick_book_sync';

UPDATE tblplan_features SET is_highlight = 1, name = 'CompanyCam Integration', description='Sync all your photos for every job, with the relative client(s) and tags at CompanyCam, keeping your project photos updated at all times where you need it most.' WHERE codename = 'companycam_sync';

UPDATE tblplan_features SET is_highlight = 1, name = 'Zapier', description='Connect with Zapier to communicate and share data between Contractor+ and your other favorite apps/software.' WHERE codename = 'zapier_integration';

UPDATE tblplan_features SET is_highlight = 1, name = 'Mileage Log', description='You can track the mileage of any team member, and see their GPS route data at any time. All without having to purchase any additional external hardware or devices. This makes mileage reimbursement a breeze for your accountant.' WHERE codename = 'mileage_log_module';


UPDATE tblstaff SET refresh_permissions = 1;

