<======== Manoj 31-12-2019 =====>  
CREATE TABLE `tel_courier_pincode` (
  `id` int(11) NOT NULL,
  `courier_id` int(11) DEFAULT NULL,
  `pin_code` varchar(50) DEFAULT NULL,
  `origin_area` varchar(255) DEFAULT NULL,
  `process_code` varchar(255) DEFAULT NULL,
  `cr_date` datetime NOT NULL DEFAULT current_timestamp(),
  `cr_usr` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 
ALTER TABLE `tel_courier_pincode`
  ADD PRIMARY KEY (`id`); 
ALTER TABLE `tel_courier_pincode`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;




ALTER TABLE `tel_order_master` ADD `order_created_by_id` INT NULL AFTER `courier_expected_del_date`, ADD `expected_carrier_id` INT NULL AFTER `order_created_by_id`;

<======== Manoj 02-01-2019 =====>  
ALTER TABLE `cds_users_master` 
ADD `orderby_change_rights` ENUM('1','0') NOT NULL DEFAULT '0' AFTER `master_type`;

ALTER TABLE `tel_courier_api` 
ADD `pincode_servicability_url` VARCHAR(255) NULL AFTER `api_tracking_url`;


<======== Manoj 04-01-2019 =====>  
ALTER TABLE `cds_company` 
ADD `razorpay_api_key` VARCHAR(255) NULL AFTER `courier_slip_product_name`, 
ADD `razorpay_api_secret` VARCHAR(255) NULL AFTER `razorpay_api_key`;

ALTER TABLE `tel_order_master` 
ADD `paymentgateway` ENUM('razorpay','paypal') NULL AFTER `expected_carrier_id`, 
ADD `payment_confirm_id` VARCHAR(255) NULL AFTER `paymentgateway`, 
ADD `payment_response_json` TEXT NULL AFTER `payment_confirm_id`;

ALTER TABLE `tel_branch_master`  
ADD `isDefault` ENUM('1','0') NOT NULL DEFAULT '0'  AFTER `updated_time`;

ALTER TABLE `tel_lead_type` 
ADD `isDefault` ENUM('1','0') NOT NULL DEFAULT '0' AFTER `status`;

ALTER TABLE `tel_payment_type` 
ADD `isDefault` ENUM('1','0') NOT NULL DEFAULT '0' AFTER `created_by_website`;

<========= Manoj 06-01-2019 =====================>
UPDATE `tel_order_master` SET 
`customer_type` = 
CASE
  WHEN customer_type = 'customer' THEN 1 
  WHEN customer_type = 'dealer' THEN 2 
  WHEN customer_type = 'vendor' THEN 3
  ELSE customer_type 
END

 

UPDATE `tel_customer_master` SET 
`customer_type` = 
CASE
  WHEN customer_type = 'customer' THEN 1 
  WHEN customer_type = 'dealer' THEN 2 
  WHEN customer_type = 'vendor' THEN 3 
  ELSE customer_type 
END





<========= Manoj 21-01-2019 =====================>
ALTER TABLE `cds_company`
  DROP `razorpay_api_key`,
  DROP `razorpay_api_secret
transaction_date_time

Add new table tel_payment_gateway

ALTER TABLE `tel_order_master` ADD `transaction_date_time` DATETIME NULL AFTER `payment_response_json`;

<========= Manoj 28-01-2019 =====================>
ALTER TABLE `tel_quotation_master` ADD `paymentgateway` VARCHAR(50) NULL AFTER `pdfline_count`, ADD `payment_confirm_id` VARCHAR(255) NULL AFTER `paymentgateway`, ADD `payment_response_json` TEXT NULL AFTER `payment_confirm_id`, ADD `transaction_date_time` DATETIME NULL AFTER `payment_response_json`;

