title: InnoDB mySQL unable to set "ON DELETE SET DEFAULT'. How to set?
body: <p>I am trying to create a table named EMPLOYEE. When I use the following statements without "ON DELETE SET DEFAULT" it is working. </p>
  
  <p>Here is the Error I get with "ON DELETE SET DEFAULT":</p>
  
  <pre><code>ERROR 1005 (HY000): Can't create table 'COMPANY.EMPLOYEE' (errno: 150)
  </code></pre>
  
  <p>Here is the DDL</p>
  
  <pre><code>CREATE TABLE EMPLOYEE ( 
      Fname VARCHAR(15) NOT NULL, 
      Minit CHAR, Lname VARCHAR(15) NOT NULL, 
      Ssn CHAR(9) NOT NULL DEFAULT '123456789',
      Bdate DATE, ADDRESS VARCHAR(30), 
      Sex CHAR, Salary DECIMAL(10,2), 
      Super_Ssn CHAR(9) NOT NULL DEFAULT '123456789', 
      Dno INT NOT NULL DEFAULT -99,
      PRIMARY KEY (Ssn), 
      FOREIGN KEY (Super_Ssn) REFERENCES COMPANY.EMPLOYEE(Ssn) 
          ON DELETE SET DEFAULT 
          ON UPDATE CASCADE )ENGINE=InnoDB; 
  </code></pre>
  
  <p>Please help me!!! and Thanks in advance :)</p>