ALTER TABLE `logmast` ADD `logblno` VARCHAR( 50 ) NOT NULL AFTER `logpihcuramt` ;
ALTER TABLE `pihmast` ADD `pihrejreason` VARCHAR( 250 ) NOT NULL AFTER `pihcanreason` ;


/*
ALTER TABLE `logmast` ADD `logpihprvamt` DOUBLE NOT NULL AFTER `logpihsno` ,
ADD `logpihcuramt` DOUBLE NOT NULL AFTER `logpihprvamt` ;

 DROP TABLE `tmpsec` ;
 DROP TABLE `tmprpt` ;

CREATE TABLE `rptsecmast` (
  `rptsecsno` int(10) NOT NULL auto_increment,
  `rptsecpihsecsno` int(11) NOT NULL,
  `rptsec3amt` double(20,2) NOT NULL,
  `rptsec5amt` double(20,2) NOT NULL,
  `rptsec7amt` double(20,2) NOT NULL,
  `rptsec999amt` double(20,2) NOT NULL,
  `rptsec3cnt` int(11) NOT NULL,
  `rptsec5cnt` int(11) NOT NULL,
  `rptsec7cnt` int(11) NOT NULL,
  `rptsec999cnt` int(11) NOT NULL,
  PRIMARY KEY  (`rptsecsno`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE `rptconmast` (
  `rptconsno` int(10) NOT NULL auto_increment,
  `rptconpihshpsno` int(11) NOT NULL,
  `rptcon3amt` double(20,2) NOT NULL,
  `rptcon5amt` double(20,2) NOT NULL,
  `rptcon7amt` double(20,2) NOT NULL,
  `rptcon999amt` double(20,2) NOT NULL,
  `rptcon3cnt` int(11) NOT NULL,
  `rptcon5cnt` int(11) NOT NULL,
  `rptcon7cnt` int(11) NOT NULL,
  `rptcon999cnt` int(11) NOT NULL,
  PRIMARY KEY  (`rptconsno`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
*/