Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 24th, 2012  |  syntax: None  |  size: 0.54 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. CREATE TABLE Soldiers
  2. (
  3.         Id int IDENTITY PRIMARY KEY,
  4.         Name VarChar(20),
  5.         LName VarChar(20),
  6.         LLName VarChar(20)
  7. )
  8. CREATE TABLE [Kto Vudal]
  9. (
  10.         Id int IDENTITY PRIMARY KEY,
  11.         Name VarChar(20)
  12. )
  13. CREATE TABLE Zvanie
  14. (
  15.         Id int IDENTITY PRIMARY KEY,
  16.         Zvanie VarChar(20)
  17. )
  18. CREATE TABLE Weapons
  19. (
  20.         Id int PRIMARY KEY IDENTITY,
  21.         Weapon VarChar(20)
  22. )
  23. CREATE TABLE Vudal
  24. (
  25.         Id int IDENTITY,
  26.         Komu int FOREIGN KEY REFERENCES Soldiers(Id),
  27.         Kto int FOREIGN KEY REFERENCES [Kto Vudal](Id),
  28.         Weapon int FOREIGN KEY REFERENCES Weapons(Id)
  29. )
create a new version of this paste RAW Paste Data