title: mysql right data type for gender and secretquestion
body: <p>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 'enum('m''f'), <code>secretquestion</code> varchar(255) NOT NULL, <code>answer</code> varch' at line 6</p>
  
  <pre><code>create table user_login (
       `username` varchar(20) NOT NULL UNIQUE,
       `emailid` varchar(30) NOT NULL,
       `password` varchar(30) NOT NULL,
       `retypepassword` varchar(30) NOT NULL,
       `gender` char(1) enum('m''f'),
       `secretquestion` varchar(255) NOT NULL,
       `answer` varchar(50) NOT NULL,
       `mobileno` char(10)NOT NULL,
       `dob`DATE NOT NULL,
       `occupation` varchar(30)NOT NULL,                          
       `city` varchar(50) NOT NULL,
       `state` varchar(50) NOT NULL,
       `pincode` char(6) NOT NULL,
       `checkbox` tinyint(1));
  </code></pre>