mysql> CREATE TABLE testdate(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(30),email VARCHAR(128),password varchar(255) not null,created DATETIME NOT,modified DATETIME NOT);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'modified DATETIME NOT)' at line 1