ALTER TABLE `a_denmast` ADD `denmanucd` VARCHAR( 40 ) NOT NULL AFTER `denametime` , ADD `denmanddt` DATE NOT NULL AFTER `denmanucd` , ADD `denmantime` TIME NOT NULL AFTER `denmanddt` ;