title: MySQL error on CREATE TABLE with BOOL column
body: <p>I have created the following script to set up my MySQL database:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE DATABASE IF NOT EXISTS magicc_hat;
  USE magicc_hat;
  
  CREATE TABLE people (
    personID INT NOT NULL AUTO_INCREMENT,
    firstName VARCHAR(45) NOT NULL,
    lastName VARCHAR(45),
    archived BOOL NOT NULL DEFAULT '0',
  
    PRIMARY KEY (personID)
  );
  
  CREATE TABLE categories (
    categoryID INT NOT NULL AUTO_INCREMENT,
    categoryName VARCHAR(45) NOT NULL,
    description TEXT,
    archived BOOL NOT NULL DEFAULT '0',
  
    PRIMARY KEY (categoryID)
  );
  
  CREATE TABLE homes (
    homeID INT NOT NULL AUTO_INCREMENT,
    homeName VARCHAR(45) NOT NULL,
    notes TEXT,
    archived BOOL NOT NULL DEFAULT '0',
  
    PRIMARY KEY (homeID)
  };
  
  CREATE TABLE items (
    itemID INT NOT NULL AUTO_INCREMENT,
    itemName VARCHAR(100) NOT NULL,
    identifier VARCHAR(100),
    quantity INT NOT NULL,
    categoryID INT NOT NULL,
    homeID INT NOT NULL,
    itemStatus ENUM('normal', 'broken', 'missing') NOT NULL DEFAULT 'normal',
    description TEXT,
    image VARCHAR(45),
    notes TEXT,
    archived BOOL NOT NULL DEFAULT '0',
  
    PRIMARY KEY (itemID),
    FOREIGN KEY (categoryID) REFERENCES categories(categoryID),
    FOREIGN KEY (homeID) REFERENCES homes(homeID)
  };
  
  CREATE TABLE projects (
    projectID INT NOT NULL AUTO_INCREMENT,
    projectName VARCHAR(45) NOT NULL,
    description TEXT,
    archived BOOL NOT NULL DEFAULT '0',
  
    PRIMARY KEY (projectID)
  );
  
  CREATE TABLE checkouts (
    checkoutID INT NOT NULL AUTO_INCREMENT,
    itemID INT NOT NULL,
    personID INT NOT NULL,
    projectID INT,
    quantity INT NOT NULL,
    outDateTime DATETIME,
    inDateTime DATETIME,
    outNotes TEXT,
    inNotes TEXT,
    checkedIn BOOL,
    archived BOOL NOT NULL DEFAULT '0',
  
    PRIMARY KEY (checkoutID),
    FOREIGN KEY (itemID) REFERENCES items(itemID),
    FOREIGN KEY (personID) REFERENCES people(personID),
    FOREIGN KEY (projectID) REFERENCES projects(projectID)
  );
  </code></pre>
  
  <p>However, when I run this script I get the following error messages:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>ERROR 1064 (42000): 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 '}' at line 8
  
  ERROR 1064 (42000): 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 '}' at line 17
  
  ERROR 1215 (HY000): Cannot add foreign key constraint
  </code></pre>
  
  <p>I suspect it has something to do with using the bool datatype since that is what is happening at lines 8 and 17; however I have not been able to find any solutions to this issue online. Is someone able to see what might be causing the problem? I'm running MySQL 5.6.11 on my local Windows machine.</p>
  
  <p>Thanks!</p>