Re: ERROR: Error 1067: Invalid default value for 'date_created'

[Barry Galbraith]

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 ACTION;

PRIMARY KEY is unique.
Your table means that you can't have two orders that cost the same amount.
Probably NOT a good idea.

Good luck,
Barry.