title: ERROR 1005 (HY000): Can't create table (errno: 150)
body: <p>I get an error when I try to create a table in mysql.</p>
  
  <p>Any tips on resolving it?</p>
  
  <pre><code>create table stock_in(
      ind int not null auto_increment,
      itemcode varchar(10) not null,
      quantity int not null,
      description text not null,
      sales_ref int not null default -1,
      return_outwards_ref int not null default -1,
      stock_in_receipt_ref int not null default -1,
      date text not null,
      time text not null,
      username text not null,
      foreign key (sales_ref) references sales (receiptno),
      foreign key (return_outwards_ref) references returnoutwards(ind),
      primary key (ind)
  );
  </code></pre>
  
  <p><strong>The Error:</strong></p>
  
  <pre><code>ERROR 1005 (HY000): Can't create table 'posinventory.stock_in' (errno: 150)
  </code></pre>