ALTER TABLE  `pinvoicedetails` ADD  `ptotal` VARCHAR( 10 ) NOT NULL AFTER  `rate` ;
ALTER TABLE  `pinvoicedetails` ADD  `svatpc` VARCHAR( 10 ) NOT NULL AFTER  `srate` ,
ADD  `svatamt` VARCHAR( 10 ) NOT NULL AFTER  `svatpc` ;
ALTER TABLE  `jobregdet` ADD  `partno` VARCHAR( 20 ) NOT NULL AFTER  `srno` ;