ALTER TABLE `tblestimates` ADD `authorize_signature` VARCHAR(40) NULL DEFAULT NULL AFTER `signature`;
ALTER TABLE `tblestimates` ADD `show_client_signature` TINYINT(1) NOT NULL DEFAULT '1' AFTER `authorize_signature`;
ALTER TABLE `tblestimates` ADD `show_authorize_signature` TINYINT(1) NOT NULL DEFAULT '0' AFTER `show_client_signature`;

ALTER TABLE `tblinvoices` ADD `signature` VARCHAR(40) NULL DEFAULT NULL AFTER `discount_type`;
ALTER TABLE `tblinvoices` ADD `authorize_signature` VARCHAR(40) NULL DEFAULT NULL AFTER `signature`;
ALTER TABLE `tblinvoices` ADD `show_client_signature` TINYINT(1) NOT NULL DEFAULT '1' AFTER `authorize_signature`;
ALTER TABLE `tblinvoices` ADD `show_authorize_signature` TINYINT(1) NOT NULL DEFAULT '0' AFTER `show_client_signature`;

ALTER TABLE `tblestimates` ADD `client_signature_updated_on` DATETIME NULL DEFAULT NULL AFTER `signature`;
ALTER TABLE `tblestimates` ADD `authorize_signature_updated_on` DATETIME NULL DEFAULT NULL AFTER `authorize_signature`;

ALTER TABLE `tblinvoices` ADD `client_signature_updated_on` DATETIME NULL DEFAULT NULL AFTER `signature`;
ALTER TABLE `tblinvoices` ADD `authorize_signature_updated_on` DATETIME NULL DEFAULT NULL AFTER `authorize_signature`;

INSERT INTO `tblterm_contracts_static` (`id`, `title`, `description`, `is_default_for_invoice`, `is_default_for_estimate`, `added_on`) VALUES (NULL, 'Main Contract', 'The Handyman Service Contract\r\nThis AGREEMENT is made this {current_day} day of {current_month} between {client_name} (hereinafter called the Client), and {team_member_name} of {company_name} (hereinafter called the Contractor).\r\nWHEREAS the client is desirous of having certain works (as described in the Schedule hereto), carried out on the premises located at {client_property_address}\r\n...............................................................................................................................\r\nIT IS HEREBY AGREED that:\r\n\r\nTERMS AND CONDITIONS\r\nThe Contractor shall carry out and complete all works indicated in the schedule to this contract in good substantial and workmanlike manner.\r\n\r\nThe Contractor shall complete the works within the time specified under the Contract Period, or any such extension of time as may be agreed upon by the Client thereafter.\r\n\r\nAny works not included in the schedule of works shall be deemed to be VARIATIONS TO CONTRACT and all terms and conditions of the original contact shall apply.\r\n\r\nThe Client agrees to pay to the Contractor the Total sum of {total_amount} per the terms of invoices sent (each invoice will have it’s own respective due date).\r\n\r\nThe Client shall extend the Contract period by a fair and reasonable amount of time if the Contractor:\r\nHas to spend extra time on the work as a result of variations in the schedule of works.\r\n\r\nCannot finish on time for reasons beyond their control, including, but not limited to any delays caused by the Client.\r\n\r\n\r\nVARIATIONS TO THE CONTRACT\r\nThe Client reserves the right to vary the contract, during the period of this Contract and it is only the Client that can change the work details of this Contract.\r\n\r\nThe Contractor is bound to carry out any such variations as directed by the Client. The Client agrees to reasonably compensate the Contractor for any additional labor required of the Contractor as a result of variations made by the Client.\r\n\r\n\r\nSUB-CONTRACTING\r\nSub-contracting of the works is not permitted without the consent of the Client, unless this was agreed upon prior to the commencement of such works.\r\n\r\n\r\nMATERIALS\r\nAll materials supplied by the Client shall remain the property of the Client.\r\n\r\nWhere the Contractor supplies materials and the Contract does not include the supply of the same, the Contractor shall provide invoices to show the extent of supply and the Client is bound by this contract to reimburse the Contractor in the sum stated on the invoices submitted.\r\n\r\n\r\nTERMINATION OF THE CONTRACT\r\nThe Client may terminate this Contract if the Contractor:\r\nis absent regularly in the performance of his contractual obligations; or\r\n\r\ndoes not meet the agreed date of completion; or\r\n\r\nis incompetent or negligent in the execution of his contractual obligations; or\r\n\r\nif the works executed are of an unacceptable quality and standard and the Contractor does not correct the matter upon notice of the same.\r\n\r\nThe Contractor may terminate this Contract if the Client:\r\nfails to pay any amount due, without giving a reasonable explanation;\r\nPrevents or obstructs the Contractor from the performance of his contractual obligations\r\n\r\n\r\nEFFECT OF TERMINATION ON COMPENSATION\r\nIn the event that the Client terminates the Contract, he will be obligated to pay the sums due to the Contractor for that part of the works completed.\r\n\r\nIn the event that the Contractor terminates this Contract, the Client will be obligated to pay for the works properly executed.', '1', '1', '2021-01-09 10:12:58');