//// 21 feb 2017////
ALTER TABLE `diesl_master` CHANGE `name` `couriername` VARCHAR(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `Contact_person` `contact_person` VARCHAR(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `code` `couriercode` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `billing_model_data` ADD `prod_cat` VARCHAR(5) NOT NULL AFTER `prod_code`;

ALTER TABLE `billing_master` ADD `logistic_person` VARCHAR(50) NOT NULL AFTER `deliv_addrs`, ADD `logistic_contact` VARCHAR(15) NOT NULL AFTER `logistic_person`, ADD `vehical_no` VARCHAR(20) NOT NULL AFTER `logistic_contact`;

ALTER TABLE `billing_master` ADD `receive_date` DATE NOT NULL AFTER `vehical_no`, ADD `receive_time` TIME NOT NULL AFTER `receive_date`, ADD `receive_by` VARCHAR(20) NOT NULL AFTER `receive_time`, ADD `receive_remark` VARCHAR(255) NOT NULL AFTER `receive_by`, ADD `receive_ip` VARCHAR(20) NOT NULL AFTER `receive_remark`;

ALTER TABLE `document_counter` ADD `rcvpay_str` VARCHAR(20) NOT NULL AFTER `srn_str`;

ALTER TABLE `document_counter` ADD `rcvpay_counter` INT(10) NOT NULL AFTER `srn_counter`;

UPDATE `report_master` set header='Master Management' WHERE `header` LIKE 'Master Mgmt' ORDER BY `header_id` ASC

update `imei_data_auto` a,imei_data_auto21feb b seta.imei1=b.imei1,a.imei2=b.imei2,a.sale_location=b.sale_location,a.operator=b.operator,a.state=b.state where a.msg='' and a.id=b.id

update `imei_data_auto` a,imei_data_auto21feb b set a.msg=b.msg,a.model=b.model,a.contact_no=b.contact_no where a.msg='' and a.id=b.id