Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[Category](
- [id] [INT] IDENTITY(1,1) NOT NULL,
- [name] [VARCHAR](100) NOT NULL,
- [imgLocation] [VARCHAR](200) NULL,
- CONSTRAINT [PK__Category__37077ABCBA5F2E23] PRIMARY KEY CLUSTERED
- (
- [id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- CREATE TABLE [dbo].[Comment](
- [id] [INT] IDENTITY(1,1) NOT NULL,
- [releaseId] [INT] NULL,
- [userId] [INT] NULL,
- [commentId_Reply] [INT] NULL,
- [text] [VARCHAR](1000) NULL,
- [postDate] [datetime] NULL,
- PRIMARY KEY CLUSTERED
- (
- [id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[Comment] ADD DEFAULT (getdate()) FOR [postDate]
- GO
- CREATE TABLE [dbo].[Release](
- [id] [INT] IDENTITY(1,1) NOT NULL,
- [userId_Owner] [INT] NULL,
- [name] [VARCHAR](200) NULL,
- [description] [VARCHAR](2000) NULL,
- [imgLocation] [VARCHAR](200) NULL,
- [releaseDate] [datetime] NULL,
- [creationDate] [datetime] NULL,
- [categoryId] [INT] NULL,
- PRIMARY KEY CLUSTERED
- (
- [id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[Release] ADD DEFAULT (getdate()) FOR [creationDate]
- GO
- CREATE TABLE [dbo].[releaseUser](
- [id] [INT] IDENTITY(1,1) NOT NULL,
- [username] [VARCHAR](20) NULL,
- [passHash] [VARCHAR](200) NULL,
- [imgLocation] [VARCHAR](200) NULL,
- [accountCreationDate] [datetime] NULL,
- [authToken] [VARCHAR](100) NULL,
- [salt] [VARCHAR](100) NULL,
- [lastLogin] [datetime] NULL,
- PRIMARY KEY CLUSTERED
- (
- [id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[releaseUser] ADD DEFAULT (getdate()) FOR [accountCreationDate]
- GO
- ALTER TABLE [dbo].[releaseUser] ADD DEFAULT (getdate()) FOR [lastLogin]
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[User_Release](
- [userId] [INT] NULL,
- [releaseId] [INT] NULL
- ) ON [PRIMARY]
- GO
Advertisement
Add Comment
Please, Sign In to add comment