I'd suggest you look at the first table:
CREATE TABLE IF NOT EXISTS friends
(
'Id' int (10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY ('Id'),
'providerid' int(10) NOT NULL AUTO_INCREMENT,
'requestid' int(10) NOT NULL AUTO_INCREMENT,
'status' binary(1) NOT NULL DEFAULT
);
You are specifying a DEFAULT for
status
but you don't give teh default value or zero or one...