INSERT INTO `tblemail_push_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'invoice_send_to_customer', '1');

INSERT INTO `tblplan_features`(`id`, `name`, `codename`, `description`, `type`, `added_on`) 
VALUES
(NULL,'No of Staff','','no_of_staff_allowed_in_plan','restrict',CURRENT_TIME),
(NULL,'Client','','client_module','allow',CURRENT_TIME),
(NULL,'Estimate','estimate_module','Estimate','allow',CURRENT_TIME),
(NULL,'Invoice','invoice_module','Invoice','allow',CURRENT_TIME),
(NULL,'Task','task_module','Task','allow',CURRENT_TIME),
(NULL,'Shopping List','shoppinglist_module','Shopping List','allow',CURRENT_TIME),
(NULL,'Supplies','suppliers_supplies_module','Supplies','allow',CURRENT_TIME),
(NULL,'No of stores allowed','no_of_supplies_stores_allowed','No of stores allowed','restrict',CURRENT_TIME),
(NULL,'Tools','tools_module','Tools','allow',CURRENT_TIME),
(NULL,'No of non tool tags allowed','no_of_nontooltags_tools_allowed','No of non tool tags allowed','restrict',CURRENT_TIME),
(NULL,'Directory','directory_module','Directory','allow',CURRENT_TIME),
(NULL,'Time Clock','timelog_module','Time Clock','allow',CURRENT_TIME),
(NULL,'Custom SMTP','custom_smtp','Custom SMTP','allow',CURRENT_TIME),
(NULL,'Reports','reports_module','Reports','allow',CURRENT_TIME),
(NULL,'Post Inspection','post_inspection_module','Post Inspection','allow',CURRENT_TIME),
(NULL,'Custom Branding (No-White Label)','custom_branding_module','Custom Branding (No-White Label)','allow',CURRENT_TIME),
(NULL,'Lead Management','leads_module','Lead Management','allow',CURRENT_TIME),
(NULL,'Quick Books Sync','quick_book_sync','Quick Books Sync','allow',CURRENT_TIME),
(NULL,'Expense','expense_module','Expense','allow',CURRENT_TIME),
(NULL,'Payment Gateway Integration','no_of_payment_gateway_integrations_allowed','Payment Gateway Integration','allow',CURRENT_TIME),
(NULL,'Staff Management','staff_module','Staff Management','allow',CURRENT_TIME),
(NULL,'To Do','to_do_module','To Do','allow',CURRENT_TIME),
(NULL,'Announcement (Web)','announcement_module','Announcement (Web)','allow',CURRENT_TIME),
(NULL,'Share Idea, Documents','share_ideas_documents_module','Share Idea, Documents','allow',CURRENT_TIME),
(NULL,'Notification - Push Mobile','notification_push_mobile','Notification - Push Mobile','allow',CURRENT_TIME),
(NULL,'Notifcation - Push Desktop','notification_push_desktop','Notifcation - Push Desktop','allow',CURRENT_TIME),
(NULL,'Notification - Email','notification_via_email','Notification - Email','allow',CURRENT_TIME),
(NULL,'Notification - SMS','notification_via_sms','Notification - SMS','allow',CURRENT_TIME),
(NULL,'Activity Log','activity_log','Activity Log','allow',CURRENT_TIME),
(NULL, 'Product and services', 'products_services_module', 'Product and services', 'allow', CURRENT_TIME);

INSERT INTO `tblplans` (`id`, `plan_sets_id`, `name`, `codename`, `description`, `monthly_price`, `yearly_price`, `discount`, `added_on`) 
VALUES 
(NULL, '3', 'Free', 'free', 'Free plan', '0', '0', '0', current_timestamp());

INSERT INTO `tblplan_features_value`(`id`, `plans_id`, `plans_features_id`, `value`, `added_on`) 
VALUES 
(NULL,'8','1','1',CURRENT_TIME),
(NULL,'8','2','1',CURRENT_TIME),
(NULL,'8','3','1',CURRENT_TIME),
(NULL,'8','4','1',CURRENT_TIME),
(NULL,'8','5','0',CURRENT_TIME),
(NULL,'8','6','0',CURRENT_TIME),
(NULL,'8','7','1',CURRENT_TIME),
(NULL,'8','8','1',CURRENT_TIME),
(NULL,'8','9','1',CURRENT_TIME),
(NULL,'8','10','10',CURRENT_TIME),
(NULL,'8','11','1',CURRENT_TIME),
(NULL,'8','12','0',CURRENT_TIME),
(NULL,'8','13','0',CURRENT_TIME),
(NULL,'8','14','1',CURRENT_TIME),
(NULL,'8','15','1',CURRENT_TIME),
(NULL,'8','16','1',CURRENT_TIME),
(NULL,'8','17','1',CURRENT_TIME),
(NULL,'8','18','0',CURRENT_TIME),
(NULL,'8','19','0',CURRENT_TIME),
(NULL,'8','20','0',CURRENT_TIME),
(NULL,'8','21','0',CURRENT_TIME),
(NULL,'8','22','0',CURRENT_TIME),
(NULL,'8','23','0',CURRENT_TIME),
(NULL,'8','24','0',CURRENT_TIME),
(NULL,'8','25','1',CURRENT_TIME),
(NULL,'8','26','0',CURRENT_TIME),
(NULL,'8','27','1',CURRENT_TIME),
(NULL,'8','28','0',CURRENT_TIME),
(NULL,'8','29','1',CURRENT_TIME),
(NULL,'8','30','1',CURRENT_TIME);

ALTER TABLE `tblstaff` ADD `permissions` MEDIUMTEXT NULL DEFAULT NULL AFTER `staff_referral_code`;