
-- New entry for plan_feature
INSERT INTO tblplan_features (name, codename, description,type,is_highlight,`order`,added_on) 
VALUES('Contractor+ Payments', 'allowed_contractorplus_payment', "Accept all major credit cards and eChecks 100% FREE! If you bank with Chase, you'll get access to your funds the SAME day! Get setup in minutes with ZERO monthly fees!",'restrict',1,25,UTC_TIMESTAMP());

SET @plans_features_id = LAST_INSERT_ID();
INSERT INTO tblplan_features_value (plans_id, plans_features_id, value,other_data,added_on) 
VALUES(9, @plans_features_id, 0,'{"outside_message":"Contractor+ Payments is a pro feature, in order to use it Upgrade to PRO","inside_message":"Contractor+ Payments is a pro feature, in order to use it Upgrade to PRO","tag_color":"#eb0e0e","tag_title":"PRO","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(10, @plans_features_id, 1,NULL,UTC_TIMESTAMP()),
(11, @plans_features_id, 1,NULL,UTC_TIMESTAMP()),
(12, @plans_features_id, 1,NULL,UTC_TIMESTAMP()),
(13, @plans_features_id, 0,'{"outside_message":"Contractor+ Payments is a pro feature, in order to use it Upgrade to PRO","inside_message":"Contractor+ Payments is a pro feature, in order to use it Upgrade to PRO","tag_color":"#eb0e0e","tag_title":"PRO","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(14, @plans_features_id, 1,NULL,UTC_TIMESTAMP()),
(15, @plans_features_id, 1,NULL,UTC_TIMESTAMP());


-- Update query for existing Payment feature
UPDATE `tblplan_features` SET `is_highlight`=0 WHERE  codename = 'tilled_transaction_fees';
UPDATE `tblplan_features` SET `is_highlight`=0 WHERE  codename = 'wepay_transaction_fees';

-- Refresh Staff permission
UPDATE tblstaff SET refresh_permissions = 1 ;
