#2000

ALTER TABLE `customer_service_mst` ADD `cm_vBrandId` INT(11) NULL AFTER `del_i`, ADD `cm_iTons` VARCHAR(10) NULL AFTER `cm_vBrandId`, ADD `cm_vAddress` LONGTEXT NULL AFTER `cm_iTons`;



ALTER TABLE `service_booking_mst` ADD `sm_vBrand` VARCHAR(100) NULL AFTER `sm_iBranchId`, ADD `sm_vSerialNo` VARCHAR(100) NULL AFTER `sm_iAmount`;

ALTER TABLE `annual_service_subscription_master` ADD `assm_iAnnualServiceId` INT(11) NULL AFTER `assm_iDuration`,ADD `assm_iAnnualSeviceTypeId` INT(11) NULL AFTER `assm_iAmount`, ADD `assm_iValidityYears` INT(11) NULL AFTER `assm_dCreatedDate`,ADD `assm_iQuantity` INT(11) NULL AFTER `assm_dCreatedDate`,ADD `assm_iTotalPrice` INT(11) NULL AFTER `assm_iDuration`,ADD `assm_vPdfFile` VARCHAR(200) NULL AFTER `assm_iTotalPrice`;



ALTER TABLE `customer_service_mst` ADD `cm_iProductid` INT(11) NULL AFTER `cm_iServiceId`;



#19-08-2019 


ALTER TABLE `ios_version_kill_switch` ADD `del_i` TINYINT(2) NOT NULL DEFAULT '0' AFTER `ivks_iUpdatestatus`;


ALTER TABLE `ios_version_kill_switch` ADD `ivks_dCreatedDate` DATETIME NOT NULL AFTER `ivks_iUpdatestatus`;


ALTER TABLE `ios_version_kill_switch` ADD `ivks_dUpdatedDate` DATETIME NOT NULL AFTER `ivks_dCreatedDate`;


-- 07/12/2019 customer_comments

CREATE TABLE IF NOT EXISTS `customer_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cc_iCustomerId` int(10) NOT NULL,
  `cc_ltComments` longtext,
  `cc_iEmpId` int(10) DEFAULT NULL,
  `del_i` tinyint(4) NOT NULL DEFAULT '0',
  `cc_dtCreateddate` datetime DEFAULT NULL,
  `cc_dtupdateddate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- 11/12/2019 customer_product_mst

ALTER TABLE `customer_product_mst` ADD `cpm_tActivestatus` TINYINT NOT NULL DEFAULT '0' AFTER `cpm_dExpiredDate`;



/***************  21-12-2020 ****************/


ALTER TABLE `service_booking_mst` ADD `sm_vBillingAttachement` VARCHAR(200) NOT NULL AFTER `sm_vCustomerSign`;


ALTER TABLE `annual_service_booking_mst` ADD `asbm_vBillingAttachement` VARCHAR(200) NOT NULL AFTER `asbm_vCustomerSign`;