text: /****** Object:  Table [dbo].[AspNetRoleClaims]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetRoleClaims](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[ClaimType] [nvarchar](256) NULL,
  	[ClaimValue] [nvarchar](256) NULL,
  	[RoleId] [nvarchar](128) NOT NULL,
   CONSTRAINT [PK_AspNetRoleClaims] 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
  /****** Object:  Table [dbo].[AspNetRoles]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetRoles](
  	[Id] [nvarchar](128) NOT NULL,
  	[Name] [nvarchar](256) NOT NULL,
  	[ConcurrencyStamp] [nvarchar](50) NULL,
  	[NormalizedName] [nvarchar](256) NOT NULL,
   CONSTRAINT [PK_AspNetRoles] 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
  /****** Object:  Table [dbo].[AspNetUserClaims]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserClaims](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[ClaimType] [nvarchar](max) NULL,
  	[ClaimValue] [nvarchar](max) NULL,
  	[UserId] [nvarchar](128) NOT NULL,
   CONSTRAINT [PK_AspNetUserClaims] 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
  /****** Object:  Table [dbo].[AspNetUserLogins]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserLogins](
  	[UserId] [nvarchar](128) NOT NULL,
  	[LoginProvider] [nvarchar](128) NOT NULL,
  	[ProviderKey] [nvarchar](128) NOT NULL,
  	[ProviderDisplayName] [nvarchar](500) NOT NULL,
   CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY CLUSTERED 
  (
  	[UserId] ASC,
  	[LoginProvider] ASC,
  	[ProviderKey] 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].[AspNetUserRoles]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserRoles](
  	[UserId] [nvarchar](128) NOT NULL,
  	[RoleId] [nvarchar](128) NOT NULL,
   CONSTRAINT [PK_AspNetUserRoles] PRIMARY KEY CLUSTERED 
  (
  	[UserId] ASC,
  	[RoleId] 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].[AspNetUsers]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUsers](
  	[Id] [nvarchar](128) NOT NULL,
  	[UserName] [nvarchar](256) NOT NULL,
  	[PasswordHash] [nvarchar](max) NULL,
  	[SecurityStamp] [nvarchar](max) NULL,
  	[Email] [nvarchar](256) NULL,
  	[EmailConfirmed] [bit] NOT NULL,
  	[PhoneNumber] [nvarchar](20) NULL,
  	[PhoneNumberConfirmed] [bit] NOT NULL,
  	[TwoFactorEnabled] [bit] NOT NULL,
  	[LockoutEnd] [DATETIMEOFFSET] NULL,
  	[LockoutEnabled] [bit] NOT NULL,
  	[AccessFailedCount] [int] NULL,
  	[RegistrationDateTime] [datetime] NOT NULL,
  	[RecoveryQuestion] [nvarchar](50) NULL,
  	[Answer] [nvarchar](50) NULL,
  	[LastLoginFromIp] [nvarchar](50) NULL,
  	[LastLoginDateTime] [datetime] NOT NULL,
  	[ConcurrencyStamp] [nvarchar](50) NULL,
  	[NormalizedEmail] [nvarchar](256) NULL,
  	[NormalizedUserName] [nvarchar](256) NULL,
   CONSTRAINT [PK_AspNetUsers] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (FILLFACTOR = 75, PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
  GO
  /****** Object:  Table [dbo].[AspNetUserTokens]    Script Date: 6/7/2017 4:29:33 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserTokens](
  	[UserId] [nvarchar](128) NOT NULL,
  	[LoginProvider] [nvarchar](128) NOT NULL,
  	[Name] [nvarchar](128) NOT NULL,
  	[Value] [nvarchar](max) NULL,
   CONSTRAINT [PK_AspNetUserTokens] PRIMARY KEY CLUSTERED 
  (
  	[UserId] ASC,
  	[LoginProvider] ASC,
  	[Name] 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 ON
  
  GO
  /****** Object:  Index [IX_AspNetRoleClaims_RoleId]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetRoleClaims_RoleId] ON [dbo].[AspNetRoleClaims]
  (
  	[RoleId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [RoleNameIndex]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetRoles_NormalizedName] ON [dbo].[AspNetRoles]
  (
  	[NormalizedName] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [IX_AspNetUserClaims_UserId]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetUserClaims_UserId] ON [dbo].[AspNetUserClaims]
  (
  	[UserId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [IX_AspNetUserLogins_UserId]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetUserLogins_UserId] ON [dbo].[AspNetUserLogins]
  (
  	[UserId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [IX_AspNetUserRoles_RoleId]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetUserRoles_RoleId] ON [dbo].[AspNetUserRoles]
  (
  	[RoleId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [IX_AspNetUserRoles_UserId]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetUserRoles_UserId] ON [dbo].[AspNetUserRoles]
  (
  	[UserId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [IX_AspNetUsers_NormalizedEmail]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetUsers_NormalizedEmail] ON [dbo].[AspNetUsers]
  (
  	[NormalizedEmail] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  SET ANSI_PADDING ON
  
  GO
  /****** Object:  Index [IX_AspNetUsers_NormalizedUserName]    Script Date: 6/7/2017 4:29:33 PM ******/
  CREATE NONCLUSTERED INDEX [IX_AspNetUsers_NormalizedUserName] ON [dbo].[AspNetUsers]
  (
  	[NormalizedUserName] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  GO
  ALTER TABLE [dbo].[AspNetUsers] ADD  CONSTRAINT [DF_AspNetUsers_RegistrationDateTime]  DEFAULT (getutcdate()) FOR [RegistrationDateTime]
  GO
  ALTER TABLE [dbo].[AspNetRoleClaims]  WITH CHECK ADD  CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[AspNetRoles] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetRoleClaims] CHECK CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles]
  GO
  ALTER TABLE [dbo].[AspNetUserClaims]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserClaims_AspNetUsers] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserClaims] CHECK CONSTRAINT [FK_AspNetUserClaims_AspNetUsers]
  GO
  ALTER TABLE [dbo].[AspNetUserLogins]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserLogins_AspNetUsers] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserLogins] CHECK CONSTRAINT [FK_AspNetUserLogins_AspNetUsers]
  GO
  ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserRoles_AspNetRoles] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[AspNetRoles] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetRoles]
  GO
  ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserRoles_AspNetUsers] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetUsers]
  GO
  