StackUnderflow schema converted for MS SQL Server

sql_server_schema.sql

USE [stackunderflow]
GO
/****** Object:  User [stackunderflow]    Script Date: 9/22/2012 1:50:52 PM ******/
CREATE USER [stackunderflow] FOR LOGIN [stackunderflow] WITH DEFAULT_SCHEMA=[stackunderflow]
GO
ALTER ROLE [db_owner] ADD MEMBER [stackunderflow]
GO
ALTER ROLE [db_securityadmin] ADD MEMBER [stackunderflow]
GO
/****** Object:  Table [dbo].[answers]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[answers](
	[Id] [bigint] IDENTITY(15,1) NOT NULL,
	[QuestionId] [bigint] NOT NULL,
	[Body] [varchar](1500) NOT NULL,
	[UpdateDate] [datetime2](0) NOT NULL,
	[LastRelatedUser] [bigint] NOT NULL,
	[CreatedDate] [datetime2](0) NOT NULL,
	[Author] [bigint] NOT NULL,
	[Votes] [int] NOT NULL,
 CONSTRAINT [PK_answers_Id] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[questions]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[questions](
	[Body] [varchar](max) NOT NULL,
	[Author] [bigint] NOT NULL,
	[Id] [bigint] IDENTITY(21,1) NOT NULL,
	[Title] [varchar](200) NOT NULL,
	[UpdateDate] [datetime2](0) NOT NULL,
	[LastRelatedUser] [bigint] NOT NULL,
	[CreatedDate] [datetime2](0) NOT NULL,
	[Votes] [int] NOT NULL,
 CONSTRAINT [PK_questions_Id] 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] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[questiontags]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[questiontags](
	[TagId] [int] NOT NULL,
	[QuestionId] [int] NOT NULL,
 CONSTRAINT [PK_questiontags_TagId] PRIMARY KEY CLUSTERED 
(
	[TagId] ASC,
	[QuestionId] 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
/****** Object:  Table [dbo].[tags]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tags](
	[TagId] [int] NOT NULL,
	[Name] [varchar](50) NOT NULL,
 CONSTRAINT [PK_tags_TagId] PRIMARY KEY CLUSTERED 
(
	[TagId] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[users]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users](
	[Id] [bigint] IDENTITY(5,1) NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[Website] [varchar](300) NULL,
	[Reputation] [int] NOT NULL,
	[SignupDate] [datetime2](0) NOT NULL,
	[OpenId] [varchar](500) NOT NULL,
 CONSTRAINT [PK_users_Id] 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],
 CONSTRAINT [users$IX_OpenId] UNIQUE NONCLUSTERED 
(
	[OpenId] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[votesonanswers]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[votesonanswers](
	[UserId] [bigint] NOT NULL,
	[PostId] [bigint] NOT NULL,
	[Vote] [tinyint] NOT NULL,
 CONSTRAINT [PK_votesonanswers_UserId] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[PostId] 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
/****** Object:  Table [dbo].[votesonquestions]    Script Date: 9/22/2012 1:50:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[votesonquestions](
	[UserId] [int] NOT NULL,
	[PostId] [int] NOT NULL,
	[Vote] [smallint] NOT NULL,
 CONSTRAINT [PK_votesonquestions_UserId] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[PostId] 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].[users] ADD  DEFAULT (NULL) FOR [Website]
GO