title: #1064 - You have an error in your SQL syntax
body: <p>I am trying to set up tables according to the instructions within my software.  This is what I entered:</p>
  
  <pre><code>CREATE TABLE `swd_account` (
  `pk_account` int(11) NOT NULL auto_increment,
  `name` char(16) NOT NULL default '',
  `isact` tinyint(4) NOT NULL default '1',
  PRIMARY KEY (`pk_account`)
  ) TYPE=MyISAM;
  
  CREATE TABLE `swd_user` (
  `pk_user` int(11) NOT NULL auto_increment,
  `fk_account` int(11) NOT NULL default '0',
  `email` varchar(40) NOT NULL default '',
  `name` varchar(40) default NULL,
  `isact` tinyint(4) NOT NULL default '1',
  `datereg` date default NULL,
  `days` tinyint(4) default '0',
  `datelastsend` date default NULL,
  `messlastsend` int(11) default NULL,
  `countsend` int(11) NOT NULL default '0',
  `undelivered` tinyint(4) default NULL,
  PRIMARY KEY (`pk_user`),
  KEY `fk_account` (`fk_account`,`email`,`isact`),
  KEY `email` (`email`)
  ) TYPE=MyISAM;
  </code></pre>
  
  <p>And this is the message I get back:</p>
  
  <pre><code>Error
  SQL query:
  
  CREATE TABLE  `swd_account` (
  
   `pk_account` INT( 11 ) NOT NULL AUTO_INCREMENT ,
   `name` CHAR( 16 ) NOT NULL DEFAULT  '',
   `isact` TINYINT( 4 ) NOT NULL DEFAULT  '1',
  PRIMARY KEY (  `pk_account` )
  ) TYPE = MYISAM ;
  
  MySQL said: 
  
  #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 'TYPE=MyISAM' at line 6 
  </code></pre>
  
  <p>Any suggestions on what could be wrong would be GREATLY appreciated.</p>