title: #1064 mysql error - DOUBLE NOT NULL
body: <p>I'm trying to create an sql table called 'cartable'. I'm currently using phpmyadmin via MAMP(Mac Version of WAMP).</p>
  
  <p>When I click on the save button this error appears:</p>
  
  <pre><code>    SQL query:
  
  CREATE TABLE `cardatabase`.`CARTABLE` (
  `ID` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  `SLOTNUMBER` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  `STATUS` ENUM( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  `LATITUDE` DECIMAL( 20 ) NOT NULL ,
  `LONGITUDE` DECIMAL( 20 ) NOT NULL ,
  `LOCATION` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  `DEVICEID` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
  ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
  
  MySQL said: Documentation
  #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 '1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `LATITUDE` DECIMAL(20) N' at line 1 
  </code></pre>
  
  <p>It seems to be a problem with the double data type as when I change it to varchar the table is created. Is there any other way around it? Thanks in advance, any help is much appreciated.</p>