a guest Feb 19th, 2019 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- e are going to create a table to introduce the users. Here you will add the email address and passwords. It is necessary to associate each user with a domain.
- CREATE TABLE `virtual_users` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `domain_id` INT NOT NULL,
- `password` VARCHAR(106) NOT NULL,
- `email` VARCHAR(120) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `email` (`email`),
- FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
RAW Paste Data