title: Drupal table creation error
body: <p>I am trying to create a table in Drupal database using hook_schema function but I am getting the PDO exception error which I could not resolve. It would be great if you could provide me an solution to my issue</p>
  
  <pre><code>PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'DEFAULT '' COMMENT
  'first name of the user', `lname` VARCHAR DEFAULT '' COMMENT' at line 3: 
  CREATE TABLE {mage_user} ( `uid` INT unsigned NOT NULL auto_increment COMMENT 
  'The foreign identifier for a mage user.', `fname` VARCHAR DEFAULT '' 
  COMMENT 'first name of the user', `lname` VARCHAR DEFAULT '' COMMENT 
  'last name of the user', `address1` VARCHAR(255) DEFAULT '' COMMENT 
  'adress line 1', `address2` VARCHAR(255) DEFAULT '' COMMENT 'adress line 2',
  `postcode` VARCHAR(7) DEFAULT '' COMMENT 'postcode', `gender` VARCHAR(6) 
  DEFAULT ''  COMMENT 'gender' ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 
  COMMENT 'The base table for mage user.'; Array ( ) in db_create_table() 
  (line 2688 of E:\Server\drupal\includes\database\database.inc).
  </code></pre>
  
  <p>I am using </p>
  
  <p>Apache/2.2.22 (Win32) PHP/5.3.10
  MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $</p>
  
  <p>MySQL server version 5.5.21</p>
  
  <p>and my schema definition is</p>
  
  <pre><code>    function mageacc_schema() {
  
            $schema['mageuser'] = array(
          'description' =&gt; 'The base table for mage user.', 
          'fields' =&gt; array(
          'uid' =&gt; array(
          'description' =&gt; 'The foreign identifier for a mage user.', 
          'type' =&gt; 'serial',  
          'not null' =&gt; TRUE,
    ), 
    'fname' =&gt; array(
      'description' =&gt; 'first name of the user', 
      'type' =&gt; 'varchar', 
      'lenght' =&gt; 255, 
      'default' =&gt; '',
    ),
        'lname' =&gt; array(
        'description' =&gt; 'last name of the user', 
        'type' =&gt; 'varchar', 
        'lenght' =&gt; 255, 
        'default' =&gt; '',
    ),
       'address1' =&gt; array(
       'description' =&gt; 'adress line 1', 
       'type' =&gt; 'varchar', 
       'length' =&gt; 255,
       'default' =&gt; '',
  
    ),
    'address2' =&gt; array(
        'description' =&gt; 'adress line 2', 
        'type' =&gt; 'varchar', 
        'length' =&gt; 255, 
        'default' =&gt; '',
  
       ),
       'postcode' =&gt; array(
        'description' =&gt; 'postcode', 
        'type' =&gt; 'varchar', 
        'length' =&gt; 7,  
         'default' =&gt; '',
      ),
      'gender'=&gt;array(
      'description' =&gt; 'gender',
      'type' =&gt; 'varchar',
      'length' =&gt; 6,
      'default' =&gt; '',
      ),
  
    ), 
  
          );
  
    return $schema; 
  
  }
  </code></pre>
  
  <p>Thanks in Advance</p>