INSERT INTO `tblplan_features` (`id`, `name`, `codename`, `description`, `type`, `added_on`) VALUES (NULL, 'Buy Leads', 'buy_leads', 'buy_leads', 'allow', current_timestamp()), (NULL, 'Mileage Logs', 'mileage_logs', 'mileage_logs', 'allow', current_timestamp());

INSERT INTO `tblplan_features` (`id`, `name`, `codename`, `description`, `type`, `added_on`) VALUES (NULL, 'Miscellaneous', 'miscellaneous_module', 'miscellaneous_module', 'allow', current_timestamp());

INSERT INTO `tblplan_features_value` (`id`, `plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES (NULL, '12', '70', '1', NULL, CURRENT_TIMESTAMP), (NULL, '12', '71', '1', NULL, CURRENT_TIMESTAMP);
INSERT INTO `tblplan_features_value` (`id`, `plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES (NULL, '12', '72', '1', NULL, current_timestamp());

ALTER TABLE `tblsystemwide_supplier` ADD `upgrade_image` VARCHAR(500) NULL DEFAULT NULL AFTER `image`;

ALTER TABLE `tblclients` ADD `state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `state`;
ALTER TABLE `tblcustomer_properties` ADD `state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `state`;
ALTER TABLE `tblclients` ADD `billing_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `billing_state`;
-- 6th October
ALTER TABLE `tblshopping_list` ADD `state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `state`;

ALTER TABLE `tblestimates` ADD `property_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `property_state`;
ALTER TABLE `tblestimates` ADD `shipping_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `shipping_state`;
ALTER TABLE `tblestimates` ADD `billing_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `billing_state`;

ALTER TABLE `tblinvoices` ADD `billing_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `billing_state`;
ALTER TABLE `tblinvoices` ADD `property_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `property_state`;
ALTER TABLE `tblinvoices` ADD `shipping_state_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `shipping_state`;