INSERT INTO tblplan_features (name, codename, description,type,is_highlight,added_on) 
VALUES('Lowes Search', 'lowes_search', 'Lowes search for Line Item and Material Search','restrict',1,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":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","inside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","tag_color":"#eb0e0e","tag_title":"ULTIMATE","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(10, @plans_features_id, 0,'{"outside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","inside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","tag_color":"#eb0e0e","tag_title":"ULTIMATE","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(11, @plans_features_id, 0,'{"outside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","inside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","tag_color":"#eb0e0e","tag_title":"ULTIMATE","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(12, @plans_features_id, 1,NULL,UTC_TIMESTAMP()),
(13, @plans_features_id, 0,'{"outside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","inside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","tag_color":"#eb0e0e","tag_title":"ULTIMATE","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(14, @plans_features_id, 0,'{"outside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","inside_message":"Lowes Search is an ultimate feature, in order to use it Upgrade to ULTIMATE","tag_color":"#eb0e0e","tag_title":"ULTIMATE","link":"https:\/\/my.contractorplus.app\/","count":"0"}',UTC_TIMESTAMP()),
(15, @plans_features_id, 1,NULL,UTC_TIMESTAMP());

INSERT INTO tbltrial_details (module,plans, no_of_trial_days, module_live_date,details,addedon) 
VALUES('lowes_search','[10,11,14]',15,CURDATE(), '{"trial_active_details":{"icon":"assets\/images\/trial_icons\/trial_active.png","title":"Lowes Search (Trial)","description":"Lowes Search is an ULTIMATE feature. You have {no_of_trial_days_left} left on your free trial, after that, you\'ll need to choose a plan.","button_text":"UPGRADE PLAN"},"trial_expired_detials":{"icon":"assets\/images\/trial_icons\/trial_expired.png","title":"Trial Expired!","description":"Your trial of Lowes Search Module has expired. To continue using Lowes Search Module, choose a ULTIMATE plan now.","button_text":"UPGRADE PLAN"}}', CURDATE());

INSERT INTO tbloptions_static (name, value, autoload) VALUES('allow_order_materials_from_lowes', '0', 1);

INSERT INTO tbloptions (tenant_id, name, value, autoload)
SELECT t.id,s.name,s.value,s.autoload
FROM tbltenants t
JOIN tbloptions_static s ON 1 = 1 AND s.name = 'allow_order_materials_from_lowes';