Error in table creation

[asifzbaig]

I have trying to create a MySQL database table as:

CREATE TABLE `tolltaxsystem1.2`.`vehicle`( 
   `vehicle_type` ENUM('LMV','LCV','BUS','TRUCK','MAV') NOT NULL , 
   `vehicle_num` VARCHAR(12) NOT NULL , 
   `journey` ENUM('SJ','CR','EX') NOT NULL , 
   `exempted_type` VARCHAR(4) NOT NULL DEFAULT 'NA' , 
   `material` ENUM('O','ME','MG','AG') NOT NULL DEFAULT 'O' , 
   `amount` DOUBLE(5,2) NOT NULL DEFAULT '0.0' , 
   `booth_num` ENUM('1','2','3','4','5','6','7','8','9') NOT NULL , 
   `lane_num` TINYINT NOT NULL DEFAULT '0' , 
   `passed_at` DATETIME NOT NULL DEFAULT NOW(),
   `image` BLOB 
   
 )

But it shows me a error that :

Error Code : 1067
Invalid default value for 'passed_at'

Please guide me how to remove this error, as i want to store current date and time in the column with every new row insertion with NOW() function..........

[DarrylBurke]

Have you read the MySQL documentation?
MySQL :: MySQL 5.6 Reference Manual :: 10.1.4 Data Type Default Values

db

[asifzbaig]

Have you read the MySQL documentation?
MySQL :: MySQL 5.6 Reference Manual :: 10.1.4 Data Type Default Values

Thanks very much..that things are sometimes difficult to explore on web..

Do me one more favor please, if i want to create a trigger or anything like this that can reset my autoincrement values to zero again with the change in date?
How can i accomplish this?