/home/edulekha/crm.edulekha.com/application/migrations/112_version_112.php
<?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);");
}
}