Syntax Error in MySQL Script for user table : <p>Seems like every now and then I am having my troubles with MySQL. Can you help me with finding the error in this script? Thank you very much. I can't see it unfortunately.</p>

<pre><code>Create table `User` (
id int not null,
lastname VARCHAR(50) not null,
firstname VARCHAR (50) not null,
email VARCHAR(100) not null,
password VARCHAR not null,
registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
active bit not null
constraint pk_UserId Primary Key(`id`)
);
</code></pre>
