UPDATE tblterm_contracts SET is_default_for_invoice = 0, is_default_for_estimate = 0;
UPDATE tblterm_contracts_static SET is_default_for_invoice = 0, is_default_for_estimate = 0;

INSERT INTO `tblterm_contracts_static`(`title`, `is_default_for_invoice`, `is_default_for_estimate`, `added_on`, `description`) VALUES ('Independent Contractor Agreement', 1, 1, NOW(), "<div><p>This AGREEMENT is made this <b>{current_day}</b> day of <b>{current_month}</b> between <b>{client_name}</b> (hereinafter called the Client), and <b>{team_member_name}</b> of <b>{company_name}</b> (hereinafter called the Contractor).</p><p>WHEREAS the client is desirous of having certain works (as described in the Schedule hereto), carried out on the premises located at <b>{client_property_address}</b>.</p><p></p><span><b>IT IS HEREBY AGREED that:</b></span><ol><li><b>TERMS AND CONDITIONS</b><ol type=\"a\"><li>The Contractor shall carry out and complete all works indicated in the schedule to this contract in good substantial and workmanlike manner.</li><li>The 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.</li><li>Any 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.</li><li>The 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).</li></ol></li><li><b>The Client shall extend the Contract period by a fair and reasonable amount of time if the Contractor:</b><br><ol type=\"a\"><li>Has to spend extra time on the work as a result of variations in the schedule of work.</li><li>Cannot finish on time for reasons beyond their control, including, but not limited to any delays caused by the Client.</li></ol></li><li><b>VARIATIONS TO THE CONTRACT</b><ol type=\"a\"><li>The 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.</li><li>The 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.</li></ol></li><li><b>SUB-CONTRACTING</b><br><span>Sub-contracting of the works is not permitted without the consent of the Client, unless this was agreed upon prior to the commencement of such work.</span></li><li><b>MATERIALS</b><ol type=\"a\"><li>All materials supplied by the Client shall remain the property of the Client.</li><li>Where 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.</li></ol></li><li><b>TERMINATION OF THE CONTRACT</b><ol type=\"a\"><li>The Client may terminate this Contract if the Contractor:<ol type=\"i\"><li>is absent regularly in the performance of his contractual obligations; or</li><li>does not meet the agreed date of completion; or</li><li>is incompetent or negligent in the execution of his contractual obligations; or</li><li>if the works executed are of an unacceptable quality and standard and the Contractor does not correct the matter upon notice of the same.</li></ol></li><li>The Contractor may terminate this Contract if the Client:<ol type=\"i\"><li>fails to pay any amount due, without giving a reasonable explanation;</li><li>Prevents or obstructs the Contractor from the performance of his contractual obligations</li></ol></li></ol></li><li><b>EFFECT OF TERMINATION ON COMPENSATION</b><ol type=\"a\"><li>In the event that the Client terminates the Contract, he will be obligated to pay the sums due to the Contractor for any work that's been completed.</li><li>In the event that the Contractor terminates this Contract, the Client will be obligated to pay for the works properly executed.</li><li>Both the Client and Contractor may terminate this Agreement, and any obligations stated hereunder, with reasonable cause, by providing written notice of a material breach of the other party; or any act exposing the other party to liability to others for personal injury or property damage.</li></ol></li><li><b>BUSINESS LICENSES, PERMITS, AND CERTIFICATES</b><br><span>The Contractor represents and warrants that all employees and personnel associated shall comply with federal, state, and local laws requiring any required licenses, permits, and certificates necessary to perform the Services under this Agreement.</span></li><li><b>FEDERAL AND STATE TAXES</b><br><span>Under this Agreement, the Client shall not be responsible for withholding FICA, Medicare, Social Security, or any other federal or state withholding taxes from the Contractor's payments to employees or personnel or make payments on behalf of the Contractor; Make federal or state unemployment compensation contributions on the Contractor's behalf; and the payment of all taxes incurred related to or while performing the Services under this Agreement, including all applicable income taxes and, if the Contractor is not a corporation, all applicable self-employment taxes. Upon demand, the Contractor shall provide the Client with proof that such payments have been made.</span></li><li><b>INDEMNIFICATION</b><br><span>The Contractor shall indemnify and hold the Client harmless from any loss or liability from performing the Services under this Agreement.</span></li><li><b>CONFIDENTIALITY</b><br><span>The Contractor acknowledges that it will be necessary for the Client to disclose certain confidential and proprietary information to the Contractor in order for the Contractor to perform their duties under this Agreement. The Contractor acknowledges that disclosure to a third party or misuse of this proprietary or confidential information would irreparably harm the Client. Accordingly, the Contractor will not disclose or use, either during or after the term of this Agreement, any proprietary or confidential information of the Client without the Client's prior written permission except to the extent necessary to perform services on the Client's behalf.</span><br><span>Proprietary or confidential information includes, but is not limited to: The written, printed, graphic, or electronically recorded materials furnished by Client for Contractor to use; Any written or tangible information stamped “confidential,” “proprietary,” or with a similar legend, or any information that Client makes reasonable efforts to maintain the secrecy of business or marketing plans or strategies, customer lists, operating procedures, trade secrets, design formulas, know-how and processes, computer programs and inventories, discoveries, and improvements of any kind, sales projections, and pricing information; and information belonging</span></li><li><b>NO PARTNERSHIP</b><br><span>This Agreement does not create a partnership relationship between the Client and the Contractor. Unless otherwise directed, the Contractor shall have no authority to enter into contracts on the Client's behalf or represent the Client in any manner.</span></li><li><b>SEVERABILITY</b><br><span>This Agreement shall remain in effect in the event a section or provision is unenforceable or invalid. All remaining sections and provisions shall be deemed legally binding unless a court rules that any such provision or section is invalid or unenforceable, thus, limiting the effect of another provision or section. In such case, the affected provision or section shall be enforced as so limited.</span></li><li><b>ASSIGNMENT AND DELEGATION</b><br><span>The Contractor may assign rights and may delegate duties under this Agreement to other individuals or entities acting as a subcontractor (\"Subcontractor\"). The Contractor recognizes that they shall be liable for all work performed by the Subcontractor and shall hold the Client harmless of any liability in connection with their performed work.</span><br><span>The Contractor shall be responsible for any confidential or proprietary information that is shared with the Subcontractor in accordance with Sections XVI & XVII of this Agreement. If any such information is shared by the Subcontractor to third (3rd) parties, the Contractor shall be made liable.</span><li><b>GOVERNING LAW</b><br><span>This Agreement shall be governed under the laws in the State of <b>{client_property_state}</b>.</span></li><li><b>BREACH WAIVER</b><br><span>Any waiver by the Client of a breach of any section of this Agreement by the Contractor shall not operate or be construed as a waiver of any subsequent breach by the Contractor.</span></li><li><b>INDEPENDENT CONTRACTOR STATUS</b><br><span>The Contractor, under the code of the Internal Revenue Service (IRS), is an independent contractor, and neither the Contractor's employees or contract personnel are, or shall be deemed, the Client's employees.</span><br><span>In its capacity as an independent contractor, Contractor agrees and represents: Contractor has the right to perform services for others during the term of this Agreement; Contractor has the sole right to control and direct the means, manner, and method by which the Services required by this Agreement will be performed. Contractor shall select the routes taken, starting and ending times, days of work, and order the work is performed; Contractor has the right to hire assistant(s) as subcontractors or to use employees to provide the services required under this Agreement. Neither Contractor, nor the Contractor's employees or personnel, shall be required to wear any uniforms provided by the Client; The Services required by this Agreement shall be performed by the Contractor, Contractor's employees or personnel, and the Client will not hire, supervise, or pay assistants to help the Contractor; Neither Contractor nor Contractor's employees or personnel shall receive any training from the Client in the professional skills necessary to perform the services required by this Agreement; and Neither the Contractor nor Contractor's employees or personnel shall be required by the Client to devote full-time to the performance of the Services required by this agreement.</span></li><li><b>LIABILITY INSURANCE</b><br><span>The Contractor agrees to bear all responsibility for the actions related to themselves and their employees or personnel under this Agreement. In addition, the Contractor agrees to obtain comprehensive liability insurance coverage in case of bodily or personal injury, property damage, contractual liability, and cross-liability (\"Liability Insurance\").</span></li></ol></div>");

INSERT INTO  tblterm_contracts (`tenant_id`, `title`, `is_default_for_invoice`, `is_default_for_estimate`, `added_on`, `description`) SELECT id, 'Independent Contractor Agreement', 1, 1, NOW(), "<div><p>This AGREEMENT is made this <b>{current_day}</b> day of <b>{current_month}</b> between <b>{client_name}</b> (hereinafter called the Client), and <b>{team_member_name}</b> of <b>{company_name}</b> (hereinafter called the Contractor).</p><p>WHEREAS the client is desirous of having certain works (as described in the Schedule hereto), carried out on the premises located at <b>{client_property_address}</b>.</p><p></p><span><b>IT IS HEREBY AGREED that:</b></span><ol><li><b>TERMS AND CONDITIONS</b><ol type=\"a\"><li>The Contractor shall carry out and complete all works indicated in the schedule to this contract in good substantial and workmanlike manner.</li><li>The 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.</li><li>Any 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.</li><li>The 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).</li></ol></li><li><b>The Client shall extend the Contract period by a fair and reasonable amount of time if the Contractor:</b><br><ol type=\"a\"><li>Has to spend extra time on the work as a result of variations in the schedule of work.</li><li>Cannot finish on time for reasons beyond their control, including, but not limited to any delays caused by the Client.</li></ol></li><li><b>VARIATIONS TO THE CONTRACT</b><ol type=\"a\"><li>The 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.</li><li>The 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.</li></ol></li><li><b>SUB-CONTRACTING</b><br><span>Sub-contracting of the works is not permitted without the consent of the Client, unless this was agreed upon prior to the commencement of such work.</span></li><li><b>MATERIALS</b><ol type=\"a\"><li>All materials supplied by the Client shall remain the property of the Client.</li><li>Where 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.</li></ol></li><li><b>TERMINATION OF THE CONTRACT</b><ol type=\"a\"><li>The Client may terminate this Contract if the Contractor:<ol type=\"i\"><li>is absent regularly in the performance of his contractual obligations; or</li><li>does not meet the agreed date of completion; or</li><li>is incompetent or negligent in the execution of his contractual obligations; or</li><li>if the works executed are of an unacceptable quality and standard and the Contractor does not correct the matter upon notice of the same.</li></ol></li><li>The Contractor may terminate this Contract if the Client:<ol type=\"i\"><li>fails to pay any amount due, without giving a reasonable explanation;</li><li>Prevents or obstructs the Contractor from the performance of his contractual obligations</li></ol></li></ol></li><li><b>EFFECT OF TERMINATION ON COMPENSATION</b><ol type=\"a\"><li>In the event that the Client terminates the Contract, he will be obligated to pay the sums due to the Contractor for any work that's been completed.</li><li>In the event that the Contractor terminates this Contract, the Client will be obligated to pay for the works properly executed.</li><li>Both the Client and Contractor may terminate this Agreement, and any obligations stated hereunder, with reasonable cause, by providing written notice of a material breach of the other party; or any act exposing the other party to liability to others for personal injury or property damage.</li></ol></li><li><b>BUSINESS LICENSES, PERMITS, AND CERTIFICATES</b><br><span>The Contractor represents and warrants that all employees and personnel associated shall comply with federal, state, and local laws requiring any required licenses, permits, and certificates necessary to perform the Services under this Agreement.</span></li><li><b>FEDERAL AND STATE TAXES</b><br><span>Under this Agreement, the Client shall not be responsible for withholding FICA, Medicare, Social Security, or any other federal or state withholding taxes from the Contractor's payments to employees or personnel or make payments on behalf of the Contractor; Make federal or state unemployment compensation contributions on the Contractor's behalf; and the payment of all taxes incurred related to or while performing the Services under this Agreement, including all applicable income taxes and, if the Contractor is not a corporation, all applicable self-employment taxes. Upon demand, the Contractor shall provide the Client with proof that such payments have been made.</span></li><li><b>INDEMNIFICATION</b><br><span>The Contractor shall indemnify and hold the Client harmless from any loss or liability from performing the Services under this Agreement.</span></li><li><b>CONFIDENTIALITY</b><br><span>The Contractor acknowledges that it will be necessary for the Client to disclose certain confidential and proprietary information to the Contractor in order for the Contractor to perform their duties under this Agreement. The Contractor acknowledges that disclosure to a third party or misuse of this proprietary or confidential information would irreparably harm the Client. Accordingly, the Contractor will not disclose or use, either during or after the term of this Agreement, any proprietary or confidential information of the Client without the Client's prior written permission except to the extent necessary to perform services on the Client's behalf.</span><br><span>Proprietary or confidential information includes, but is not limited to: The written, printed, graphic, or electronically recorded materials furnished by Client for Contractor to use; Any written or tangible information stamped “confidential,” “proprietary,” or with a similar legend, or any information that Client makes reasonable efforts to maintain the secrecy of business or marketing plans or strategies, customer lists, operating procedures, trade secrets, design formulas, know-how and processes, computer programs and inventories, discoveries, and improvements of any kind, sales projections, and pricing information; and information belonging</span></li><li><b>NO PARTNERSHIP</b><br><span>This Agreement does not create a partnership relationship between the Client and the Contractor. Unless otherwise directed, the Contractor shall have no authority to enter into contracts on the Client's behalf or represent the Client in any manner.</span></li><li><b>SEVERABILITY</b><br><span>This Agreement shall remain in effect in the event a section or provision is unenforceable or invalid. All remaining sections and provisions shall be deemed legally binding unless a court rules that any such provision or section is invalid or unenforceable, thus, limiting the effect of another provision or section. In such case, the affected provision or section shall be enforced as so limited.</span></li><li><b>ASSIGNMENT AND DELEGATION</b><br><span>The Contractor may assign rights and may delegate duties under this Agreement to other individuals or entities acting as a subcontractor (\"Subcontractor\"). The Contractor recognizes that they shall be liable for all work performed by the Subcontractor and shall hold the Client harmless of any liability in connection with their performed work.</span><br><span>The Contractor shall be responsible for any confidential or proprietary information that is shared with the Subcontractor in accordance with Sections XVI & XVII of this Agreement. If any such information is shared by the Subcontractor to third (3rd) parties, the Contractor shall be made liable.</span><li><b>GOVERNING LAW</b><br><span>This Agreement shall be governed under the laws in the State of <b>{client_property_state}</b>.</span></li><li><b>BREACH WAIVER</b><br><span>Any waiver by the Client of a breach of any section of this Agreement by the Contractor shall not operate or be construed as a waiver of any subsequent breach by the Contractor.</span></li><li><b>INDEPENDENT CONTRACTOR STATUS</b><br><span>The Contractor, under the code of the Internal Revenue Service (IRS), is an independent contractor, and neither the Contractor's employees or contract personnel are, or shall be deemed, the Client's employees.</span><br><span>In its capacity as an independent contractor, Contractor agrees and represents: Contractor has the right to perform services for others during the term of this Agreement; Contractor has the sole right to control and direct the means, manner, and method by which the Services required by this Agreement will be performed. Contractor shall select the routes taken, starting and ending times, days of work, and order the work is performed; Contractor has the right to hire assistant(s) as subcontractors or to use employees to provide the services required under this Agreement. Neither Contractor, nor the Contractor's employees or personnel, shall be required to wear any uniforms provided by the Client; The Services required by this Agreement shall be performed by the Contractor, Contractor's employees or personnel, and the Client will not hire, supervise, or pay assistants to help the Contractor; Neither Contractor nor Contractor's employees or personnel shall receive any training from the Client in the professional skills necessary to perform the services required by this Agreement; and Neither the Contractor nor Contractor's employees or personnel shall be required by the Client to devote full-time to the performance of the Services required by this agreement.</span></li><li><b>LIABILITY INSURANCE</b><br><span>The Contractor agrees to bear all responsibility for the actions related to themselves and their employees or personnel under this Agreement. In addition, the Contractor agrees to obtain comprehensive liability insurance coverage in case of bodily or personal injury, property damage, contractual liability, and cross-liability (\"Liability Insurance\").</span></li></ol></div>" FROM tbltenants;