Advertisement
Guest User

Untitled

a guest
Mar 31st, 2015
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.70 KB | None | 0 0
  1. CREATE DATABASE Sudoku;
  2.    CREATE TABLE Sudoku.Player;
  3.    (
  4.          UserName VARCHAR(10) NOT NULL,
  5.          Password VARCHAR(18) NOT NULL,
  6.          Email CHAR (20) NOT NULL,
  7.          PRIMARY KEY(UserName),
  8.          UNIQUE INDEX(UserName),
  9.          FOREING KEY(Email) REFERENCES Sudoku.Player,
  10.          FOREING KEY(Password) REFERENCES Sudoku.Player
  11.  
  12.    );
  13. CREATE TABLE Sudoku.EndUser;
  14.    (
  15.          UserName VARCHAR(10) NOT NULL,
  16.          Password VARCHAR(18) NOT NULL,
  17.          Email CHAR (20) NOT NULL,
  18.          PRIMARY KEY(UserName),
  19.          UNIQUE INDEX(UserName),
  20.          FOREING KEY(Email) REFERENCES Sudoku.EndUser,
  21.          FOREING KEY(Password) REFERENCES Sudoku.EndUser
  22.  
  23.    );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement