title: Mysql error #1064
body: <p>I am trying to create some tables on phpMyAdmin, but when I use the code below I am getting this error: </p>
  
  <pre><code>#1064 - 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 '(32) NOT NULL,
  </code></pre>
  
  <p><code>activated</code> enum(<code>0</code>,<code>1</code>) NOT NULL,
    PRIMARY KEY (<code>id</code>)
  ) E' at line 8 </p>
  
  <p>Here is my code:</p>
  
  <pre><code>    CREATE TABLE IF NOT EXISTS `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) NOT NULL,
    `first_name` varchar(255) NOT NULL,
    `last_name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `sign_up_date` date(32) NOT NULL,
    `activated` enum(`0`,`1`) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=1atin1 AUTO_INCREMENT=1 ;
  </code></pre>