ERROR: Error 1067: Invalid default value for 'date_created'
CREATE TABLE IF NOT EXISTS `affablebean`.`customer_order` (
`idcustomer` TIMESTAMP NULL,
`amount` DECIMAL(6,2) UNSIGNED NOT NULL,
`date_created` TIMESTAMP NOT NULL,
`confirmation_number` INT UNSIGNED NOT NULL,
`customer_idcustomer` INT UNSIGNED NOT NULL,
PRIMARY KEY (`amount`),
INDEX `fk_customer_order_customer_idx` (`customer_idcustomer` ASC),
CONSTRAINT `fk_customer_order_customer1`
FOREIGN KEY (`customer_idcustomer`)
REFERENCES `affablebean`.`customer` (`idcustomer`)
ON DELETE NO ACTIONCREATE TABLE IF NOT EXISTS `affablebean`.`customer_order` (
`idcustomer` TIMESTAMP NULL,
`amount` DECIMAL(6,2) UNSIGNED NOT NULL,
`date_created` TIMESTAMP NOT NULL,
`confirmation_number` INT UNSIGNED NOT NULL,
`customer_idcustomer` INT UNSIGNED NOT NULL,
PRIMARY KEY (`amount`),
INDEX `fk_customer_order_customer_idx` (`customer_idcustomer` ASC),
CONSTRAINT `fk_customer_order_customer1`
FOREIGN KEY (`customer_idcustomer`)
REFERENCES `affablebean`.`customer` (`idcustomer`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
SQL script execution finished: statements: 13 succeeded, 1 failed
Fetching back view definitions in final form.
Nothing to fetch
ON UPDATE NO ACTION)
ENGINE = InnoDB
SQL script execution finished: statements: 13 succeeded, 1 failed
Fetching back view definitions in final form.
Nothing to fetch