/home/edulekha/crm.edulekha.com/application/migrations/320_version_320.php
<?php

defined('BASEPATH') or exit('No direct script access allowed');

class Migration_Version_320 extends CI_Migration
{
    public function up()
    {
        $dbPrefix    = db_prefix();
        $dbCharset   = $this->db->char_set;
        $dbCollation = $this->db->dbcollat;

        add_option('disable_ticket_public_url', '0');

        if (! $this->db->field_exists('formatted_number', $dbPrefix . 'invoices')) {
            $this->db->query('ALTER TABLE `' . $dbPrefix . 'invoices` ADD `formatted_number` VARCHAR(100) CHARACTER SET ' . $dbCharset . ' COLLATE ' . $dbCollation . ' NULL DEFAULT NULL AFTER `number_format`, ADD INDEX `formatted_number` (`formatted_number`);');
        }

        if (! $this->db->field_exists('formatted_number', $dbPrefix . 'estimates')) {
            $this->db->query('ALTER TABLE `' . $dbPrefix . 'estimates` ADD `formatted_number` VARCHAR(100) CHARACTER SET ' . $dbCharset . ' COLLATE ' . $dbCollation . ' NULL DEFAULT NULL AFTER `number_format`, ADD INDEX `formatted_number` (`formatted_number`);');
        }

        if (! $this->db->field_exists('formatted_number', $dbPrefix . 'creditnotes')) {
            $this->db->query('ALTER TABLE `' . $dbPrefix . 'creditnotes` ADD `formatted_number` VARCHAR(100) CHARACTER SET ' . $dbCharset . ' COLLATE ' . $dbCollation . ' NULL DEFAULT NULL AFTER `number_format`, ADD INDEX `formatted_number` (`formatted_number`);');
        }
    }
}