title: SQL Syntax Error: "Error: near "CHARACTER": syntax error"
body: <p>I am trying to create a table to separate a huge database I have in a textfile into just username:email instead of their entire user:email:hash:etc</p>
  
  <p>I have this:</p>
  
  <pre><code>&gt;&gt;&gt;CREATE TABLE `database`(
    `UserGUID` varchar(40) CHARACTER SET latin1 NOT NULL,
    `UserName` varchar(80) CHARACTER SET utf8 NOT NULL,
    `Email` varchar(128) CHARACTER SET latin1 NOT NULL,
    `Password` varchar(128) CHARACTER SET latin1 NOT NULL,
    `Salt` varchar(128) CHARACTER SET latin1 NOT NULL,
    `Strikes` int(10) unsigned NOT NULL DEFAULT '0',
    `Locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `Deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `CreatedDate` datetime NOT NULL,
    `UpdatedDate` datetime DEFAULT NULL,
    `DeletedDate` datetime DEFAULT NULL,
    `CreatedBy` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT 'System',
    `UpdatedBy` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
    `DeletedBy` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
    `EmailAuthenticated` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `FollowID` int(10) unsigned DEFAULT NULL,
    `DefaultLocationID` int(10) unsigned DEFAULT NULL,
    `birthDay` int(10) unsigned DEFAULT NULL,
    `birthMonth` int(10) unsigned DEFAULT NULL,
    `birthYear` int(10) unsigned DEFAULT NULL,
    `BirthDate` datetime DEFAULT NULL,
    `EmailAuthKey` varchar(45) COLLATE latin1_general_ci DEFAULT NULL,
    `CurrentCrowns` int(11) NOT NULL DEFAULT '0',
    `CurrentCardpoints` int(11) NOT NULL DEFAULT '0',
    `LastFreeCrowns` datetime DEFAULT NULL,
    `plaintextpassword` varchar(500) COLLATE latin1_general_ci DEFAULT NULL,
    `LastAuthEmail` datetime DEFAULT NULL,
    `premiumcards` int(11) DEFAULT NULL,
    `steamid` varchar(80) COLLATE latin1_general_ci DEFAULT NULL,
    `ExternalPromotionID` varchar(45) COLLATE latin1_general_ci DEFAULT NULL,
    `culture` varchar(40) COLLATE latin1_general_ci DEFAULT NULL,
    PRIMARY KEY (`UserGUID`) USING BTREE,
    UNIQUE KEY `Username` (`UserName`),
    UNIQUE KEY `Email` (`Email`),
    UNIQUE KEY `Follow` (`FollowID`) USING BTREE,
    KEY `EmailAuthenticated` (`EmailAuthenticated`),
    KEY `SteamID` (`steamid`),
    KEY `authkey` (`EmailAuthKey`),
    KEY `IX_CreatedDate` (`CreatedDate`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  </code></pre>
  
  <p>I keep getting this error: Error: near "CHARACTER": syntax error</p>
  
  <p>help?</p>