USE db_mail;
CREATE TABLE `domain` (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(64) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `user` (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	domain_id INT UNSIGNED NOT NULL,
	`user` VARCHAR(64) NOT NULL,
	password VARCHAR(128) NOT NULL,
	CONSTRAINT UNIQUE_EMAIL UNIQUE (domain_id,user),
	FOREIGN KEY (domain_id) REFERENCES domain(id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `alias` (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	domain_id INT UNSIGNED NOT NULL,
	source VARCHAR(64) NOT NULL,
	destination VARCHAR(128) NOT NULL,
	FOREIGN KEY (domain_id) REFERENCES domain(id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET=utf8;