> Foreign keys are only supported within InnoDB tables (on both sides)..
so using a table 'users' like create table users ( email varchar (80) primary key unique not null, belongs_to integer not null references domains on delete cascade ); without foreign keys could help? I couldn't make it work that way either. Philipp > Hi > > I run a Postfix MTA attached to a mysql DB with various > domains on it. A > domain consists of email addresses. When I want to delete the > domain the > referenced email addresses should be deleted, too. But that > doesn't work > and I don't know why. > > here are the two tables domains and users: > > CREATE TABLE domains ( > ID_DOMAINS int(11) auto_increment, > active int(1) not null, > domain varchar(50) NOT NULL, > PRIMARY KEY (ID_DOMAINS) > ) TYPE=MyISAM; > > create table users ( > email varchar (80) primary key unique not null, belongs_to integer not > null, foreign key (belongs_to) references domains on delete cascade ); > > if I use the delete command like "delete from domains where > id_domains='1'" the dataset that belongs to id 1 in domains is deleted > while the email addresses belonging to this domain are left untouched. > > What am I missing? > > thanks > Philipp > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
