Advertisement
Guest User

Untitled

a guest
Jul 14th, 2011
564
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.94 KB | None | 0 0
  1. CREATE TABLE aUsers (
  2.   userId INT NOT NULL IDENTITY,
  3.   firstName VARCHAR(100) NOT NULL DEFAULT '',
  4.   lastNAme VARCHAR(100) NOT NULL DEFAULT '',
  5.   PRIMARY KEY  (userId)
  6. );
  7. CREATE TABLE aAccounts (
  8.   accountId INT NOT NULL IDENTITY,
  9.   accountName VARCHAR(100) NOT NULL DEFAULT '',
  10.   SIZE INT NOT NULL DEFAULT 0,
  11.   PRIMARY KEY  (accountId)
  12. );
  13. CREATE TABLE aAccess (
  14.   accessLevel INT NOT NULL,
  15.   accessName VARCHAR(100) NOT NULL DEFAULT '',
  16.   PRIMARY KEY  (accessLevel)
  17. );
  18. CREATE TABLE aUserAccounts (
  19.   accountId INT NOT NULL,
  20.   userId INT NOT NULL,
  21.   accessLevel INT NOT NULL DEFAULT 0
  22. );
  23. ALTER TABLE aUserAccounts ADD CONSTRAINT accountIdConstraint FOREIGN KEY (accountId) REFERENCES aAccounts (accountId);
  24. ALTER TABLE aUserAccounts ADD CONSTRAINT userIdConstraint FOREIGN KEY (userId) REFERENCES aUsers (userId);
  25. ALTER TABLE aUserAccounts ADD CONSTRAINT accessLevelConstraint FOREIGN KEY (accessLevel) REFERENCES aAccess (accessLevel);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement