Advertisement
Guest User

Untitled

a guest
May 5th, 2016
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.03 KB | None | 0 0
  1. GO
  2.  
  3. CREATE TABLE [dbo].[tbSection](
  4.     [Id] [int] IDENTITY(1,1) NOT NULL,
  5.     [Name] [varchar](max) NOT NULL,
  6.     [Position] [int] NULL,
  7.  CONSTRAINT [PK_tbSections] PRIMARY KEY CLUSTERED
  8. (
  9.     [Id] ASC
  10. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  11. )
  12.  
  13. GO
  14.  
  15. CREATE TABLE [dbo].[tbSubSubKategorie](
  16.     [ID] [int] IDENTITY(1,1) NOT NULL,
  17.     [Name] [varchar](max) NOT NULL,
  18.     [Erstellungsdatum] [datetime] NOT NULL,
  19.  CONSTRAINT [PK_tbSubSubkategorie] PRIMARY KEY CLUSTERED
  20. (
  21.     [ID] ASC
  22. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  23. )
  24.  
  25. GO
  26.  
  27. CREATE TABLE [dbo].[tbSection_SubSubKategorie](
  28.     [Id] [int] IDENTITY(1,1) NOT NULL,
  29.     [FK_Section_ID] [int] NOT NULL,
  30.     [FK_SubSubKategorie] [int] NULL,
  31.  CONSTRAINT [PK_tbSection_SubSubKategorie] PRIMARY KEY CLUSTERED
  32. (
  33.     [Id] ASC
  34. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  35. )
  36.  
  37. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement