DROP TABLE IF EXISTS aliases;
CREATE TABLE aliases (
  alias_idnr bigint(21) NOT NULL auto_increment,
  alias varchar(100) NOT NULL default '',
  deliver_to varchar(250) NOT NULL default '',
  PRIMARY KEY  (alias_idnr)
) TYPE=InnoDB;

--
-- Dumping data for table `aliases`
--


/*!40000 ALTER TABLE aliases DISABLE KEYS */;
LOCK TABLES aliases WRITE;
INSERT INTO aliases VALUES (19,'xn@test2.com','2'),(29,'tech@example.com','fred@example.com');
UNLOCK TABLES;
/*!40000 ALTER TABLE aliases ENABLE KEYS */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS users;
CREATE TABLE users (
  user_idnr bigint(21) NOT NULL auto_increment,
  userid varchar(100) NOT NULL default '',
  PRIMARY KEY  (user_idnr)
) TYPE=InnoDB;

--
-- Dumping data for table `users`
--


/*!40000 ALTER TABLE users DISABLE KEYS */;
LOCK TABLES users WRITE;
INSERT INTO users VALUES (2,'fred@example.com');
UNLOCK TABLES;
/*!40000 ALTER TABLE users ENABLE KEYS */;

DELETE
	users, aliases
FROM
	users u, aliases a
WHERE
	u.user_idnr = 2 AND
	(a.deliver_to = u.user_idnr OR
	a.deliver_to = u.userid);