document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  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);
');