title: Having trouble adding a foreign key in HeidiSQL (Error 1215)
body: <p>I've tried just about everything but I'm getting error 1215 when trying to create a foreign key in a child table I have. Here are my tables:</p>
  <pre><code>CREATE TABLE `Con` (
    `ConID` int(11) NOT NULL AUTO_INCREMENT,
    `Name` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `Website` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `FirstYear` tinyint(4) DEFAULT NULL,
    PRIMARY KEY (`ConID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  
  CREATE TABLE `ConEvent` (
    `EventID` int(11) NOT NULL AUTO_INCREMENT,
    `ConID` int(11) NOT NULL,
    `DateStart` date DEFAULT NULL,
    `DateEnd` date DEFAULT NULL,
    `Year` tinyint(4) DEFAULT NULL,
    `Venue` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
    `City` tinytext COLLATE utf8_unicode_ci,
    `StateProvince` tinytext COLLATE utf8_unicode_ci,
    `Country` tinytext COLLATE utf8_unicode_ci,
    PRIMARY KEY (`EventID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  </code></pre>
  <p>Here is my syntax:</p>
  <pre><code>ALTER TABLE ConEvent
  ADD FOREIGN KEY (ConID) REFERENCES Con(ConID);
  </code></pre>
  <p>I can't <code>SHOW ENGINE INNODB STATUS;</code> because I'm not a super user (error 1227). I tried to make myself one but was unable to.</p>