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]