SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

CREATE  TABLE IF NOT EXISTS `logistics`.`table1` (
  `table1Id` INT(11) NOT NULL ,
  `decimaltest` DECIMAL(5,0) NULL DEFAULT NULL ,
  PRIMARY KEY (`table1Id`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;

ALTER TABLE `logistics`.`aaa` ADD COLUMN `ddd` DECIMAL(5,0) NULL DEFAULT NULL  AFTER `ccc` ;