daily pastebin goal
52%
SHARE
TWEET

Untitled

a guest Feb 19th, 2019 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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.
  2.  
  3. CREATE TABLE `virtual_users` (
  4. `id` INT NOT NULL AUTO_INCREMENT,
  5. `domain_id` INT NOT NULL,
  6. `password` VARCHAR(106) NOT NULL,
  7. `email` VARCHAR(120) NOT NULL,
  8. PRIMARY KEY (`id`),
  9. UNIQUE KEY `email` (`email`),
  10. FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top