/*
Run this script on SQL Server 2008 or later. There may be flaws if running on earlier versions of SQL Server.
*/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUsers]') AND type in (N'U'))
DROP TABLE [dbo].[AspNetUsers]
GO
CREATE TABLE [dbo].[AspNetUsers] (
	[Id]				[nvarchar](128)	 COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[UserName]			[nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[PasswordHash]		[nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SecurityStamp]		[nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Discriminator]		[nvarchar](256)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Email]				[nvarchar](256)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Phone]				[nvarchar](20)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Type]				[smallint]		 NOT NULL CONSTRAINT [DF__AspNetUser__Type__2180FB33] DEFAULT ((0)),
	CONSTRAINT [PK_dbo.AspNetUsers] PRIMARY KEY CLUSTERED ([Id])
) ON [PRIMARY]
GO