ALTER TABLE `a_denmast` ADD `denot1` DOUBLE NOT NULL AFTER `dennxtdayyn` ,
ADD `denot2` DOUBLE NOT NULL AFTER `denot1` ,
ADD `denlatemin` INT NOT NULL AFTER `denot2` ;

ALTER TABLE `a_denmast` ADD `denotdifrem` VARCHAR( 20 ) NOT NULL AFTER `denlatemin` ,
ADD `denerryn` VARCHAR( 1 ) NOT NULL AFTER `denotdifrem` ;

ALTER TABLE `a_denmast` CHANGE `denot1` `denot1m` DOUBLE DEFAULT '0' NOT NULL ,
CHANGE `denot2` `denot2m` DOUBLE DEFAULT '0' NOT NULL 

ALTER TABLE `a_denmast` ADD `denot1c` DOUBLE NOT NULL AFTER `denot2m` ,
ADD `denot2c` DOUBLE NOT NULL AFTER `denot1c` ;


CREATE TABLE `ctecomco_prepl`.`ymdmast` (
`ymdsno` int( 4 ) NOT NULL AUTO_INCREMENT ,
`ymdyear` int( 4 ) NOT NULL default '0',
`ymdmon` int( 2 ) NOT NULL default '0',
`ymdtyp` varchar( 10 ) NOT NULL default '',
`ymducdnew` varchar( 30 ) NOT NULL default '',
`ymdentddt` date NOT NULL default '0000-00-00',
`ymdenttime` time NOT NULL default '00:00:00',
`ymducdame` varchar( 30 ) NOT NULL default '',
`ymdameddt` date NOT NULL default '0000-00-00',
`ymdametime` time NOT NULL default '00:00:00',
PRIMARY KEY ( `ymdyear` , `ymdmon` , `ymdtyp` ) ,
UNIQUE KEY `ymdsno` ( `ymdsno` ) 
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

ALTER TABLE `ymdmast` ADD `ymdworkdays` INT NOT NULL AFTER `ymdtyp` ;

ALTER TABLE `ymdmast` ADD `ymdincdays` INT NOT NULL AFTER `ymdworkdays` ;

DELETE FROM p_sysmast WHERE sysrtp =51




