MatthijsFontys

Create database with defaults and primary keys

May 10th, 2019
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.22 KB | None | 0 0
  1. CREATE TABLE [dbo].[Category](
  2.     [id] [INT] IDENTITY(1,1) NOT NULL,
  3.     [name] [VARCHAR](100) NOT NULL,
  4.     [imgLocation] [VARCHAR](200) NULL,
  5.  CONSTRAINT [PK__Category__37077ABCBA5F2E23] PRIMARY KEY CLUSTERED
  6. (
  7.     [id] ASC
  8. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  9. ) ON [PRIMARY]
  10. GO
  11.  
  12.  
  13. CREATE TABLE [dbo].[Comment](
  14.     [id] [INT] IDENTITY(1,1) NOT NULL,
  15.     [releaseId] [INT] NULL,
  16.     [userId] [INT] NULL,
  17.     [commentId_Reply] [INT] NULL,
  18.     [text] [VARCHAR](1000) NULL,
  19.     [postDate] [datetime] NULL,
  20. PRIMARY KEY CLUSTERED
  21. (
  22.     [id] ASC
  23. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  24. ) ON [PRIMARY]
  25. GO
  26.  
  27. ALTER TABLE [dbo].[Comment] ADD  DEFAULT (getdate()) FOR [postDate]
  28. GO
  29.  
  30. CREATE TABLE [dbo].[Release](
  31.     [id] [INT] IDENTITY(1,1) NOT NULL,
  32.     [userId_Owner] [INT] NULL,
  33.     [name] [VARCHAR](200) NULL,
  34.     [description] [VARCHAR](2000) NULL,
  35.     [imgLocation] [VARCHAR](200) NULL,
  36.     [releaseDate] [datetime] NULL,
  37.     [creationDate] [datetime] NULL,
  38.     [categoryId] [INT] NULL,
  39. PRIMARY KEY CLUSTERED
  40. (
  41.     [id] ASC
  42. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  43. ) ON [PRIMARY]
  44. GO
  45.  
  46. ALTER TABLE [dbo].[Release] ADD  DEFAULT (getdate()) FOR [creationDate]
  47. GO
  48.  
  49.  
  50. CREATE TABLE [dbo].[releaseUser](
  51.     [id] [INT] IDENTITY(1,1) NOT NULL,
  52.     [username] [VARCHAR](20) NULL,
  53.     [passHash] [VARCHAR](200) NULL,
  54.     [imgLocation] [VARCHAR](200) NULL,
  55.     [accountCreationDate] [datetime] NULL,
  56.     [authToken] [VARCHAR](100) NULL,
  57.     [salt] [VARCHAR](100) NULL,
  58.     [lastLogin] [datetime] NULL,
  59. PRIMARY KEY CLUSTERED
  60. (
  61.     [id] ASC
  62. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  63. ) ON [PRIMARY]
  64. GO
  65.  
  66. ALTER TABLE [dbo].[releaseUser] ADD  DEFAULT (getdate()) FOR [accountCreationDate]
  67. GO
  68.  
  69. ALTER TABLE [dbo].[releaseUser] ADD  DEFAULT (getdate()) FOR [lastLogin]
  70. GO
  71.  
  72. SET ANSI_NULLS ON
  73. GO
  74.  
  75. SET QUOTED_IDENTIFIER ON
  76. GO
  77.  
  78. CREATE TABLE [dbo].[User_Release](
  79.     [userId] [INT] NULL,
  80.     [releaseId] [INT] NULL
  81. ) ON [PRIMARY]
  82. GO
Advertisement
Add Comment
Please, Sign In to add comment