Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS usuario (
- id int(4) NOT NULL AUTO_INCREMENT,
- email varchar(20) NOT NULL,
- nombre varchar(20) NOT NULL,
- contrasena varchar(40) NOT NULL,
- rol varchar(10),
- PRIMARY KEY (id, email)
- ) ENGINE=InnoDB AUTO_INCREMENT=1;
- CREATE TABLE IF NOT EXISTS chat (
- id int(4) NOT NULL AUTO_INCREMENT,
- nombreChat varchar(20) NOT NULL,
- idUsuario int(4) NOT NULL,
- emailUsuario varchar(20) NOT NULL,
- PRIMARY KEY (id),
- FOREIGN KEY (idUsuario) REFERENCES usuario (id),
- FOREIGN KEY (emailUsuario) REFERENCES usuario (email)
- ) ENGINE=InnoDB AUTO_INCREMENT=1;
Add Comment
Please, Sign In to add comment