UPDATE tblemailtemplates_static SET message='<span style="font-size: 12pt;">Dear {contact_firstname} {contact_lastname}</span><br/><br/><span style="font-size: 12pt;">Thank you for your estimate request.</span><br/><br/><span style="font-size: 12pt;">You can view the estimate on the following link: <a href="{estimate_link}">{estimate_number}</a></span><br/><br/><span style="font-size: 12pt;">Please contact us for more information.</span><br/><br/><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug IN ('estimate-already-send', 'estimate-send-to-client');
UPDATE tblemailtemplates SET message='<span style="font-size: 12pt;">Dear {contact_firstname} {contact_lastname}</span><br/><br/><span style="font-size: 12pt;">Thank you for your estimate request.</span><br/><br/><span style="font-size: 12pt;">You can view the estimate on the following link: <a href="{estimate_link}">{estimate_number}</a></span><br/><br/><span style="font-size: 12pt;">Please contact us for more information.</span><br/><br/><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug IN ('estimate-already-send', 'estimate-send-to-client');

INSERT INTO `tblmobile_push_notification_config` (`id`, `codename`, `is_active`) VALUES (NULL, 'client_request_change_post_inspection', '1');

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_unicode_ci NULL DEFAULT 'incomplete';

CREATE TABLE tblpost_inspections_request_changes (
    id BIGINT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
    tenant_id BIGINT UNSIGNED NOT NULL,
    post_inspection_id BIGINT UNSIGNED NOT NULL,
    request_comment TEXT NOT NULL,
    addedon DATETIME NOT NULL
);

CREATE TABLE tblpost_inspection_reviews (
    id BIGINT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
    tenant_id BIGINT UNSIGNED NOT NULL,
    post_inspection_id BIGINT UNSIGNED NOT NULL,
    overall_rating DECIMAL(20) DEFAULT NULL,
    review_description TEXT NOT NULL,
    price_rating DECIMAL(20) DEFAULT NULL,
    quality_rating DECIMAL(20) DEFAULT NULL,
    responsiveness_rating DECIMAL(20) DEFAULT NULL,
    punctuality_rating DECIMAL(20) DEFAULT NULL,
    professionalism_rating DECIMAL(20) DEFAULT NULL,
    addedon DATETIME NOT NULL
);