var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: error: 150 please help!!
im building up this database for my [homework] application and i keep gettting the 'error:150', i know it has to do with the way the foreign key is formed, I can't see what the problem is though:
CREATE TABLE shift(
shiftID INT NOT NULL,
shift_date DATE NOT NULL,
start_time TIME NOT NULL,
end_time TIME NOT NULL,
PRIMARY KEY (shiftID, shift_date, start_time, end_time)
CREATE TABLE shift_day(
FOREIGN KEY(shift_date) REFERENCES shift(shift_date)
its alright guys, i sussed it, my own stupidity again!!
my normalisation was gack as usual!!