|
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_290 extends CI_Migration
{
public function up()
{
add_option('automatically_stop_task_timer_after_hours', 0);
add_option('automatically_assign_ticket_to_first_staff_responding', 0);
if (!$this->db->field_exists('hide_from_customer', db_prefix() . 'milestones')) {
$this->db->query('ALTER TABLE `' . db_prefix() . 'milestones` ADD `hide_from_customer` INT DEFAULT 0');
}
if (!$this->db->field_exists('cc', db_prefix() . 'tickets')) {
$this->db->query('ALTER TABLE `' . db_prefix() . 'tickets` ADD `cc` VARCHAR(191) NULL AFTER `assigned`;');
}
if (!$this->db->field_exists('submit_btn_bg_color', db_prefix() . 'web_to_lead')) {
$this->db->query('ALTER TABLE `' . db_prefix() . 'web_to_lead` ADD `submit_btn_bg_color` VARCHAR(10) DEFAULT "#84c529" AFTER `submit_btn_name`;');
}
if (!$this->db->field_exists('submit_btn_text_color', db_prefix() . 'web_to_lead')) {
$this->db->query('ALTER TABLE `' . db_prefix() . 'web_to_lead` ADD `submit_btn_text_color` VARCHAR(10) DEFAULT "#ffffff" AFTER `submit_btn_name`;');
}
if (!$this->db->field_exists('submit_btn_bg_color', db_prefix() . 'estimate_request_forms')) {
$this->db->query('ALTER TABLE `' . db_prefix() . 'estimate_request_forms` ADD `submit_btn_bg_color` VARCHAR(10) DEFAULT "#84c529" AFTER `submit_btn_name`;');
}
if (!$this->db->field_exists('submit_btn_text_color', db_prefix() . 'estimate_request_forms')) {
$this->db->query('ALTER TABLE `' . db_prefix() . 'estimate_request_forms` ADD `submit_btn_text_color` VARCHAR(10) DEFAULT "#ffffff" AFTER `submit_btn_name`;');
}
}
}