create fails with on delete set null

2003-02-21 Thread Ross Davis
Simply said this works: drop table if exists detail; create table detail ( detail_id int not null auto_increment , master_id int not null , name varchar(50) not null , primary key (detail_id) , index master_idx(master_id) , foreign key (master_id) references master (master_id) on delete

Re: create fails with on delete set null

2003-02-21 Thread Heikki Tuuri
Ross, - Original Message - From: Ross Davis [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, February 22, 2003 12:14 AM Subject: create fails with on delete set null Simply said this works: drop table if exists detail; create table detail ( detail_id int

Re: create fails with on delete set null

2003-02-21 Thread Paul DuBois
At 22:07 + 2/21/03, Ross Davis wrote: Simply said this works: drop table if exists detail; create table detail ( detail_id int not null auto_increment , master_id int not null , name varchar(50) not null , primary key (detail_id) , index master_idx(master_id) , foreign key (master_id)