Can anyone please shed some light on why this code is returning Error 1005?
Code:
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:
Code:
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;