Can anyone please shed some light on why this code is returning Error 1005?

CREATE TABLE IF NOT EXISTS `#__tracker_employees` (
  `employeeid` SMALLINT(4) UNSIGNED NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL,
  `address` TINYTEXT,
  `phone` VARCHAR(14),
  `email` VARCHAR(80),
  `sin` CHAR(9),
  `type` VARCHAR(25),
  PRIMARY KEY (`employeeid`),
  UNIQUE KEY (`sin`)
)  TYPE=InnoDB;

CREATE TABLE IF NOT EXISTS `#__tracker_paystubs` (
  `stubid` SMALLINT(4) UNSIGNED NOT NULL auto_increment,
  `employeeid` SMALLINT(4) UNSIGNED NOT NULL,
  `chequenumber` TINYINT(5) UNSIGNED,
  `date_period` DATE,
  `date_pay` DATE,
  `notes` TEXT,
  PRIMARY KEY (`stubid`),
  FOREIGN KEY (`employeeid`) REFERENCES `#__tracker_employees` (`employeeid`)
) TYPE=InnoDB;

CREATE TABLE IF NOT EXISTS `#__tracker_payitems` (
  `payitemid` SMALLINT(4) UNSIGNED NOT NULL auto_increment,
  `categoryid` SMALLINT(4) UNSIGNED NOT NULL,
  `desc` TINYTEXT,
  `amount` DECIMAL(10,2),
  `split` TINYINT(2) UNSIGNED,
  PRIMARY KEY (`payitemid`),
  FOREIGN KEY (`categoryid`) REFERENCES `#__tracker_categories` (`categoryid`)
) TYPE=InnoDB;

CREATE TABLE IF NOT EXISTS `#__tracker_categories` (
  `categoryid` SMALLINT(4) UNSIGNED NOT NULL auto_increment,
  `name` VARCHAR(25),
  PRIMARY KEY (`categoryid`)
) TYPE=InnoDB;

Here is the exact error message:

Can't create table './sharedsite_lwerS/rwql_tracker_payitems.frm' (errno: 150) SQL=CREATE TABLE IF NOT EXISTS `rwql_tracker_payitems` ( `payitemid` SMALLINT(4) UNSIGNED NOT NULL auto_increment, `categoryid` SMALLINT(4) UNSIGNED NOT NULL, `desc` TINYTEXT, `amount` DECIMAL(10,2), `split` TINYINT(2) UNSIGNED, PRIMARY KEY (`payitemid`), FOREIGN KEY (`categoryid`) REFERENCES `w5ql_tracker_categories` (`categoryid`) ) TYPE=InnoDB;
SQL =

CREATE TABLE IF NOT EXISTS `rwql_tracker_payitems` (
  `payitemid` SMALLINT(4) UNSIGNED NOT NULL auto_increment,
  `categoryid` SMALLINT(4) UNSIGNED NOT NULL,
  `desc` TINYTEXT,
  `amount` DECIMAL(10,2),
  `split` TINYINT(2) UNSIGNED,
  PRIMARY KEY (`payitemid`),
  FOREIGN KEY (`categoryid`) REFERENCES `w5ql_tracker_categories` (`categoryid`)
) TYPE=InnoDB;

does this table already exist???

`w5ql_tracker_categories`

As it is being referenced in the FOREIGN KEY definition.

None of these tables exist. This is an SQL file called install.sql that I am using to install a component into Joomla.

Does the CREATE TABLE for the categories need to be executed first?

Does the CREATE TABLE for the categories need to be executed first?

Yes ...

Perfect, thank you.