Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.46 KB | None | 0 0
  1. CREATE TABLE jogador(
  2.     id INTEGER NOT NULL AUTO_INCREMENT
  3.     nome VARCHAR(30) NOT NULL,
  4.     login VARCHAR(15) NOT NULL,
  5.     senha VARCHAR(15) NOT NULL,
  6.     curso VARCHAR(30) NOT NULL,
  7. );
  8.  
  9. CREATE TABLE jogo(
  10.     id INTEGER NOT NULL AUTO_INCREMENT
  11.     localJogo VARCHAR(25) NOT NULL,
  12.     dataJogo DATE,
  13.     horario TIME,
  14.     FORIEGN KEY(id) REFERENCES jogador(id)
  15. );
  16.  
  17. CREATE TABLE marcacao(
  18.     id INTEGER(11) NOT NULL AUTO_INCREMENT,
  19.     id_jogador INTEGER(11),
  20.     id_jogo INTEGER(11)
  21. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement