MySQL Forums
Forum List  »  Newbie

Problem with CASCADE...HELP!
Posted by: Thomas Ebdrup
Date: April 15, 2005 06:39AM

Hey all, I'm kind of new in this...
I want to use Cascade in MySQL and here is all the code I have used to make my database, but I just cant get the foreign keys with to work with Cascade...

DOES ANYBODY know why?? Have I writting something wrong?
Could really need some help

Friendly regards Thomas
....................................................................................................................

CREATE TABLE ygb_area(
area_id int PRIMARY KEY NOT NULL AUTO_INCREMENT,
area varchar(20));

INSERT INTO ygb_area (area)
VALUES ('København'),('Storkøbenhavn'),('Nordsjælland'),('Sydsjælland'),('Vestsjælland'),
('Andet');

CREATE TABLE ygb_user(
user_id int PRIMARY KEY NOT NULL AUTO_INCREMENT,
email varchar(50) NOT NULL,
password varchar(12) NOT NULL,
admin int
);

CREATE TABLE ygb_mail(
mail_id int PRIMARY KEY NOT NULL AUTO_INCREMENT,
inbox varchar (250) NOT NULL,
DATE DATETIME NOT NULL,
subject varchar(30) NOT NULL,
sender varchar(20) NOT NULL,
recipient varchar(20) NOT NULL
);

CREATE TABLE ygb_guestbook(
user_id int NOT NULL
REFERENCES ygb_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
inbox varchar (250) NOT NULL,
DATE DATETIME NOT NULL,
subject varchar(30) NOT NULL,
sender varchar(20) NOT NULL,
recipient varchar(20) NOT NULL
)TYPE=INNODB;


CREATE TABLE ygb_foreign(
user_id int NOT NULL
REFERENCES ygb_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
mail_id int NOT NULL
REFERENCES ygb_mail (mail_id) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=INNODB;


CREATE TABLE ygb_personaldata(
area_id int NOT NULL
REFERENCES ygb_area (area_id) ON DELETE CASCADE ON UPDATE CASCADE,
user_id int NOT NULL
REFERENCES ygb_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
name varchar(30) NOT NULL,
nickname varchar(20) NOT NULL,
age tinyint ZEROFILL NOT NULL,
height tinyint ZEROFILL NOT NULL,
weight tinyint ZEROFILL NOT NULL,
DATE DATETIME NOT NULL,
gender tinyint ZEROFILL NOT NULL,
children tinyint ZEROFILL NOT NULL,
smoking tinyint ZEROFILL NOT NULL,
occupation tinyint ZEROFILL NOT NULL,
dating_status tinyint ZEROFILL NOT NULL,
description varchar(240) NOT NULL
)TYPE=INNODB;

CREATE TABLE ygb_favorites(
user_id int NOT NULL
REFERENCES ygb_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=INNODB;

CREATE TABLE ygb_gallery(
user_id int NOT NULL
REFERENCES ygb_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=INNODB;

INSERT INTO ygb_user (email,password)
VALUES ("ebdrupt@hotmail.com","hejsa");

INSERT INTO ygb_personaldata (user_id,name,nickname,age,height,weight,children,smoking,description)
VALUES
('1','Thomas','Santa','21','192','98','3','1','Hej mit navn er Thomas og jeg leder en rigtig liderlig tøs!!!');

Options: ReplyQuote


Subject
Written By
Posted
Problem with CASCADE...HELP!
April 15, 2005 06:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.