ALTER TABLE `stock_manager` CHANGE `comid` `comid` INT(50) NOT NULL; 
ALTER TABLE `stock_manager` CHANGE `locid` `locid` INT(20) NOT NULL; 
ALTER TABLE `stock_manager` CHANGE `barcode` `barcode` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; 
ALTER TABLE `stock_manager` ADD `pur_type` VARCHAR(100) NOT NULL AFTER `trans_tblname`; 
ALTER TABLE `stock_manager` ADD INDEX(`pur_type`);
ALTER TABLE `stock_manager` ADD `convert_plus` VARCHAR(255) NOT NULL AFTER `extraconsume_qty`; 
ALTER TABLE `stock_manager` ADD `convert_minus` VARCHAR(255) NOT NULL AFTER `extraconsume_qty`; 
ALTER TABLE `stock_manager` ADD `convert_comid` VARCHAR(255) NOT NULL AFTER `convert_plus`;
/*search_gridview = barcode,subcategory,ptype,brand,size,expiry,qty,mrp,purprice,saleprice*/