|
Server IP : 192.185.129.71 / Your IP : 3.144.89.52 Web Server : Apache System : Linux bh-ht-3.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : svymadmin ( 4072) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home4/svymadmin/public_html/vivekaexcel.edu.in/bkp/application/migrations/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Migration_Version_112 extends CI_Migration
{
function __construct()
{
parent::__construct();
}
public function up()
{
$this->db->query("ALTER TABLE `tblcontracts` ADD `content` LONGTEXT NULL AFTER `id`;");
$this->db->query("INSERT INTO `tblemailtemplates` (`type`, `slug`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
('contract', 'send-contract', 'Send contract to customer', 'Contract - {contract_subject}', '<p>Hi {client_company}</p>\r\n<p>Please find the {contract_subject} attached.</p>\r\n<p> </p>\r\n<p>Regards,</p>\r\n<p>{email_signature}</p>', '{companyname} | CRM', '', 0, 1, 0);");
}
}