CRT_TBL|tel_courier_api|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`courier` VARCHAR(20) NULL DEFAULT NULL,
	`api_create_awbno_url` VARCHAR(1000) NULL DEFAULT NULL,
	`api_tracking_url` VARCHAR(1000) NULL DEFAULT NULL,
	`ip_address` VARCHAR(50) NULL DEFAULT NULL,
	`time_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`time_updated` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
**
ADD_CLM|tel_courier|courier_api|VARCHAR|100|Y|NULL|courier_name
**
ADD_CLM|tel_courier|customer_id|VARCHAR|1000|Y|NULL|courier_api
**
ADD_CLM|tel_order_master|courier_expected_del_date|DATE||Y|NULL|pdfline_count
**
DRP_CLM|tel_order_master|courier_weight
**
DRP_CLM|tel_order_master|courier_height
**
DRP_CLM|tel_order_master|courier_length
**
DRP_CLM|tel_order_master|courier_breath
**
DRP_CLM|tel_order_master|courier_payment_mode
**
DRP_CLM|tel_order_master|courier_ewaybill_no
**
DRP_CLM|tel_order_master|courier_transdistance
**
DRP_CLM|tel_order_master|courier_transporter_id
**
DRP_CLM|tel_order_master|courier_transporter_name
**
DRP_CLM|tel_order_master|courier_type_of_delivery
**
DRP_CLM|tel_order_master|courier_type_of_service
**
DRP_CLM|tel_order_master|courier_unit_of_measure
**
DRP_CLM|tel_order_master|courier_api_type
**
DRP_CLM|tel_order_master|courier_product_name
**
QRY|INSERT IGNORE INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
	(87, 'Courier Api', 'courierApi', 2, 7, 'courier_api', 1, 1, '2019-08-08 16:42:36');
**
ADD_CLM|tel_order_master|hold_till|DATETIME||Y|NULL|booking_time
**
ADD_CLM|tel_order_master|advance_payment|DECIMAL|20,2|N|0.00|total_no_item
**
ADD_CLM|tel_order_master|courier_charges|DECIMAL|20,2|N|0.00|advance_payment
**
CRT_TBL|tel_order_courier|`order_courier_id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_id` INT(11) NULL DEFAULT NULL,
	`awb_gen_using_api` INT(11) NOT NULL DEFAULT '0' COMMENT '1 To generate AWB using API',
	`courier_product_name` VARCHAR(500) NULL DEFAULT NULL,
	`courier_api_type` VARCHAR(200) NULL DEFAULT NULL,
	`courier_weight` VARCHAR(10) NULL DEFAULT NULL,
	`courier_height` VARCHAR(10) NULL DEFAULT NULL,
	`courier_length` VARCHAR(10) NULL DEFAULT NULL,
	`courier_breath` VARCHAR(10) NULL DEFAULT NULL,
	`courier_payment_mode` VARCHAR(25) NULL DEFAULT 'c' COMMENT 'c for cash p for prepaid',
	`courier_ewaybill_no` VARCHAR(50) NULL DEFAULT NULL,
	`courier_transdistance` VARCHAR(25) NULL DEFAULT NULL,
	`courier_transporter_id` VARCHAR(250) NULL DEFAULT NULL,
	`courier_transporter_name` VARCHAR(250) NULL DEFAULT NULL,
	`courier_type_of_delivery` VARCHAR(250) NULL DEFAULT NULL,
	`courier_type_of_service` VARCHAR(250) NULL DEFAULT NULL,
	`courier_unit_of_measure` VARCHAR(250) NULL DEFAULT NULL,
	PRIMARY KEY (`order_courier_id`)
**
ADD_CLM|cds_company|courier_slip_title|VARCHAR|500|Y|NULL|captch_rights
**
ADD_CLM|cds_company|courier_slip_product_name|VARCHAR|500|Y|NULL|courier_slip_title
**
ADD_CLM|tel_courier|login_id|VARCHAR|1000|Y|NULL|customer_id
**
ADD_CLM|tel_courier|api_key_password|VARCHAR|1000|Y|NULL|login_id
**
ADD_CLM|tel_order_courier|origin_area|VARCHAR|250|Y|NULL|courier_unit_of_measure
**
ADD_CLM|tel_order_courier|customer_code|VARCHAR|250|Y|NULL|origin_area
**
ADD_CLM|tel_order_courier|product_type|VARCHAR|250|Y|NULL|customer_code
**
ADD_CLM|tel_order_courier|pickup_date|DATE||Y|NULL|product_type
**
ADD_CLM|tel_order_courier|pickup_hour|VARCHAR|50|Y|NULL|pickup_date
**
ADD_CLM|tel_order_courier|pickup_minutes|VARCHAR|50|Y|NULL|pickup_hour
**
ADD_CLM|tel_order_courier|courier_service_type|VARCHAR|100|Y|NULL|pickup_minutes
**
ADD_CLM|tel_order_courier|courier_airway_bill_number|VARCHAR|100|Y|NULL|courier_service_type
**
ADD_CLM|tel_order_courier|courier_mainfest_id|VARCHAR|100|Y|NULL|courier_airway_bill_number
**
ADD_CLM|tel_courier|vendor_code|VARCHAR|100|Y|NULL|api_key_password
**
ADD_CLM|tel_location_pincode|origin_area|VARCHAR|10|Y|NULL|pincode
**
ADD_CLM|tel_order_master|additional_discount|DECIMAL|20,2|N|0.00|discount_amt
**
QRY|ALTER TABLE `tel_item_master` CHANGE `item_desc` `item_desc` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL
**
QRY|ALTER TABLE `tel_purchase_itemlist` CHANGE `item_desc` `item_desc` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL
**
ALT_CLM|tel_branch_master|invoice_address|invoice_address|TEXT||Y|NULL|country
**
ALT_CLM|tel_branch_master|invoice_remarks|invoice_remarks|TEXT||Y|NULL|sign_img_path
**
CRT_TBL|tel_courier_docketno|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`courier_id` INT(11) NULL DEFAULT NULL,
	`docket_no` VARCHAR(50) NULL DEFAULT NULL,
	`cr_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`cr_usr` INT(11) NULL DEFAULT NULL,
	`status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0 unused 1 used',
	`used_time` DATETIME NULL DEFAULT NULL,
	`order_id` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
**
QRY|INSERT IGNORE INTO `cds_menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `cr_usr`, `cr_date`) VALUES
(88, 'Docket Number', 'courier/docketNumber', 2, 14, 'docket_no', 1, 13, '2019-11-25 15:14:31'),
(89, 'Customer Type', 'customerCategory', 2, 0, 'customer_category', 1, 13, '2019-12-10 12:43:32'),
(90, 'Pincode Service', 'courier/pincode', 2, 15, '', 1, 13, '2020-01-02 12:17:23');
**
ADD_CLM|tel_branch_master|origin_area|VARCHAR|50|Y|NULL|invoice_remarks
**
ADD_CLM|tel_order_courier|customer_origin_area|VARCHAR|50|Y|NULL|courier_mainfest_id
**
QRY|ALTER TABLE `tel_item_package_master` CHANGE `remarks` `remarks` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL
**
ALT_CLM|tel_customer_master|customer_type|customer_type|INT||Y|NULL|email_id
**
CRT_TBL|tel_customer_category_master|`id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(250) DEFAULT NULL,
  `customer_type` int(11) DEFAULT NULL COMMENT '1 customer 2 dealer 3 vendor',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '1 active 2 inactive',
  `uid` int(11) NOT NULL DEFAULT '0',
  `ip_address` varchar(50) DEFAULT NULL,
  `time_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `time_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
**
QRY|INSERT IGNORE INTO `tel_customer_category_master` (`id`, `category_name`, `customer_type`, `status`, `uid`, `ip_address`, `time_created`, `time_updated`) VALUES
	(1, 'Customer', 1, 1, 13, '192.168.1.135', '2019-12-10 12:31:29', '2019-12-10 12:38:10'),
	(2, 'Dealer', 2, 1, 13, '192.168.1.135', '2019-12-10 12:31:36', '2019-12-10 12:31:36'),
	(3, 'Vendor', 3, 1, 13, '192.168.1.135', '2019-12-10 12:31:41', '2019-12-10 12:31:41');
**
ADD_CLM|tel_item_master|md_date|DATETIME||Y|NULL|ip_address
**
CRT_TBL|tel_item_rate_master|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`item_id` INT(11) NULL DEFAULT NULL,
	`customer_type` INT(11) NULL DEFAULT NULL,
	`item_rate` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	`item_total_rate` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	PRIMARY KEY (`id`)
**
CRT_TBL|tel_courier_pincode|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`courier_id` INT(11) NULL DEFAULT NULL,
	`pin_code` VARCHAR(50) NULL DEFAULT NULL,
	`origin_area` VARCHAR(255) NULL DEFAULT NULL,
	`process_code` VARCHAR(255) NULL DEFAULT NULL,
	`cr_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`cr_usr` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
**
ADD_CLM|tel_order_master|order_created_by_id|INT|11|Y|NULL|courier_expected_del_date
**
ADD_CLM|tel_order_master|expected_carrier_id|INT|11|Y|NULL|order_created_by_id
**
ADD_CLM|cds_users_master|orderby_change_rights|TINYINT|4|N|0|master_type
**
ADD_CLM|tel_courier_api|pincode_servicability_url|VARCHAR|255|Y|NULL|api_tracking_url
**
ADD_CLM|cds_company|razorpay_api_key|VARCHAR|255|Y|NULL|courier_slip_product_name
**
ADD_CLM|cds_company|razorpay_api_secret|VARCHAR|255|Y|NULL|razorpay_api_key
**
ADD_CLM|tel_order_master|paymentgateway|TINYINT|4|Y|NULL|expected_carrier_id
**
ADD_CLM|tel_order_master|payment_confirm_id|VARCHAR|255|Y|NULL|paymentgateway
**
ADD_CLM|tel_order_master|payment_response_json|TEXT||Y|NULL|payment_confirm_id
**
ADD_CLM|tel_branch_master|isDefault|TINYINT|4|N|0|updated_time 
**
ADD_CLM|tel_lead_type|isDefault|TINYINT|4|N|0|status 
**
ADD_CLM|tel_payment_type|isDefault|TINYINT|4|N|0|created_by_website 
**
QRY|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 
END 
**
QRY|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 
END 