Guest User

Untitled

a guest
Feb 25th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS usuario (
  2. id int(4) NOT NULL AUTO_INCREMENT,
  3. email varchar(20) NOT NULL,
  4. nombre varchar(20) NOT NULL,
  5. contrasena varchar(40) NOT NULL,
  6. rol varchar(10),
  7. PRIMARY KEY (id, email)
  8. ) ENGINE=InnoDB AUTO_INCREMENT=1;
  9.  
  10. CREATE TABLE IF NOT EXISTS chat (
  11. id int(4) NOT NULL AUTO_INCREMENT,
  12. nombreChat varchar(20) NOT NULL,
  13. idUsuario int(4) NOT NULL,
  14. emailUsuario varchar(20) NOT NULL,
  15. PRIMARY KEY (id),
  16. FOREIGN KEY (idUsuario) REFERENCES usuario (id),
  17. FOREIGN KEY (emailUsuario) REFERENCES usuario (email)
  18. ) ENGINE=InnoDB AUTO_INCREMENT=1;
Add Comment
Please, Sign In to add comment