ALTER TABLE `tbljobs` CHANGE `title` `title` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `description` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `prefix` `prefix` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `job_number_text` `job_number_text` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `repeat_job_frequency` `repeat_job_frequency` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `repeat_value_type` `repeat_value_type` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `rel_type` `rel_type` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `invoice_reminder` `invoice_reminder` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `status` `status` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `property_street` `property_street` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `property_street_2` `property_street_2` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `property_city` `property_city` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `property_state` `property_state` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `property_zip` `property_zip` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `term_contracts_title` `term_contracts_title` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljobs` CHANGE `term_contracts_description` `term_contracts_description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;



ALTER TABLE `tbljob_visits` CHANGE `description` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbljob_visits` CHANGE `status` `status` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;


ALTER TABLE `tblestimates` CHANGE `property_street` `property_street` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblestimates` CHANGE `property_city` `property_city` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblestimates` CHANGE `property_state` `property_state` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblestimates` CHANGE `property_zip` `property_zip` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


ALTER TABLE `tblpost_inspections` CHANGE `post_inspection_title` `post_inspection_title` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblpost_inspections` CHANGE `deleted_customer_name` `deleted_customer_name` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblpost_inspections` CHANGE `type` `type` ENUM('normal','via_detailed_estimate') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'normal';
ALTER TABLE `tblpost_inspections` CHANGE `prefix` `prefix` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblpost_inspections` CHANGE `post_inspection_number_text` `post_inspection_number_text` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblpost_inspections` CHANGE `hash` `hash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tblpost_inspections` CHANGE `post_inspection_status` `post_inspection_status` ENUM('pending','completed','cancelled','in-complete','incomplete','sent','requested_changes') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'incomplete';
ALTER TABLE `tblpost_inspections` CHANGE `clientnote` `clientnote` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `adminnote` `adminnote` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_street` `property_street` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_street_2` `property_street_2` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_city` `property_city` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_state` `property_state` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_zip` `property_zip` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_country` `property_country` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `acceptance_firstname` `acceptance_firstname` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `acceptance_lastname` `acceptance_lastname` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `acceptance_email` `acceptance_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `acceptance_ip` `acceptance_ip` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `signature` `signature` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;



ALTER TABLE `tblcalendar_events` CHANGE `updated_by` `updated_by` BIGINT(20) UNSIGNED NULL;

INSERT INTO `tblplan_features` (`id`, `name`, `codename`, `description`, `type`, `added_on`) VALUES (NULL, 'Calendar Event Module', 'calendar_event_module', 'Calendar Event Module', 'allow', current_timestamp());

INSERT INTO `tblplan_features_value` (`id`, `plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES (NULL, '9', '90', '0', NULL, current_timestamp());
INSERT INTO `tblplan_features_value` (`id`, `plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES (NULL, '10', '90', '1', NULL, current_timestamp());
INSERT INTO `tblplan_features_value` (`id`, `plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES (NULL, '11', '90', '1', NULL, current_timestamp());
INSERT INTO `tblplan_features_value` (`id`, `plans_id`, `plans_features_id`, `value`, `other_data`, `added_on`) VALUES (NULL, '12', '90', '1', NULL, current_timestamp());
