ALTER TABLE `tblplan_features` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT;

INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('No of Estimate Images', 'no_of_estimate_images_allowed', 'No of estimate images allowed in plan.', 'restrict', '2020-08-27 13:15:00');
INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('No of Estimate Files', 'no_of_estimate_files_allowed', 'No of estimate files allowed in plan.', 'restrict', '2020-08-27 13:15:00');
INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('No of Invoice Images', 'no_of_invoice_images_allowed', 'No of invoice images allowed in plan.', 'restrict', '2020-08-27 13:15:00');
INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('No of Invoice Files', 'no_of_invoice_files_allowed', 'No of invoice files allowed in plan.', 'restrict', '2020-08-27 13:15:00');

ALTER TABLE `tblplan_features_value` ADD `other_data` LONGTEXT NULL DEFAULT NULL AFTER `value`;

ALTER TABLE `tblplan_features_value` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT;
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES ('8', '31', '5', '{\"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\"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.\",\"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"5\"}', current_timestamp());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES ('8', '32', '5', '{\"outside_message\":\"You have limit of 5 files on your plan. If you want to add more please upgrade.\",\"inside_message\":\"You have limit of 5 files on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"5\"}', current_timestamp());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES ('8', '33', '5', '{\"outside_message\":\"You have limit of 5 photos on your plan. If you want to add more please upgrade.\",\"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.\",\"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"5\"}', current_timestamp());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES ('8', '34', '5', '{\"outside_message\":\"You have limit of 5 files on your plan. If you want to add more please upgrade.\",\"inside_message\":\"You have limit of 5 files on your plan, we have selected first {!current_count!} photos. If you want to add more please upgrade.\",\"tag_color\":\"#eb0e0e\",\"tag_title\":\"UPGRADE\",\"link\":\"https:\\/\\/dev.my.contractorplus.app\\/\",\"count\":\"5\"}', current_timestamp());