text: ﻿USE [Upgrades]
  GO
  /****** Object:  Table [dbo].[__EFMigrationsHistory]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[__EFMigrationsHistory](
  	[MigrationId] [nvarchar](150) NOT NULL,
  	[ProductVersion] [nvarchar](32) NOT NULL,
   CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY CLUSTERED 
  (
  	[MigrationId] 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].[AspNetRoleClaims]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetRoleClaims](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[RoleId] [nvarchar](450) NOT NULL,
  	[ClaimType] [nvarchar](max) NULL,
  	[ClaimValue] [nvarchar](max) 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] TEXTIMAGE_ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[AspNetRoles]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetRoles](
  	[Id] [nvarchar](450) NOT NULL,
  	[Name] [nvarchar](256) NULL,
  	[NormalizedName] [nvarchar](256) NULL,
  	[ConcurrencyStamp] [nvarchar](max) 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] TEXTIMAGE_ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[AspNetUserClaims]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserClaims](
  	[Id] [int] IDENTITY(1,1) NOT NULL,
  	[UserId] [nvarchar](450) NOT NULL,
  	[ClaimType] [nvarchar](max) NULL,
  	[ClaimValue] [nvarchar](max) 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: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserLogins](
  	[LoginProvider] [nvarchar](450) NOT NULL,
  	[ProviderKey] [nvarchar](450) NOT NULL,
  	[ProviderDisplayName] [nvarchar](max) NULL,
  	[UserId] [nvarchar](450) NOT NULL,
   CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY CLUSTERED 
  (
  	[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] TEXTIMAGE_ON [PRIMARY]
  GO
  /****** Object:  Table [dbo].[AspNetUserRoles]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserRoles](
  	[UserId] [nvarchar](450) NOT NULL,
  	[RoleId] [nvarchar](450) 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: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUsers](
  	[Id] [nvarchar](450) NOT NULL,
  	[UserName] [nvarchar](256) NULL,
  	[NormalizedUserName] [nvarchar](256) NULL,
  	[Email] [nvarchar](256) NULL,
  	[NormalizedEmail] [nvarchar](256) NULL,
  	[EmailConfirmed] [bit] NOT NULL,
  	[PasswordHash] [nvarchar](max) NULL,
  	[SecurityStamp] [nvarchar](max) NULL,
  	[ConcurrencyStamp] [nvarchar](max) NULL,
  	[PhoneNumber] [nvarchar](max) NULL,
  	[PhoneNumberConfirmed] [bit] NOT NULL,
  	[TwoFactorEnabled] [bit] NOT NULL,
  	[LockoutEnd] [datetimeoffset](7) NULL,
  	[LockoutEnabled] [bit] NOT NULL,
  	[AccessFailedCount] [int] NOT NULL,
  	[FirstName] [nvarchar](max) NULL,
  	[LastName] [nvarchar](max) NULL,
   CONSTRAINT [PK_AspNetUsers] 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].[AspNetUserTokens]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[AspNetUserTokens](
  	[UserId] [nvarchar](450) NOT NULL,
  	[LoginProvider] [nvarchar](450) NOT NULL,
  	[Name] [nvarchar](450) 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
  /****** Object:  Table [dbo].[Projects]    Script Date: 12/12/2018 7:21:37 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Projects](
  	[ProjectId] [bigint] IDENTITY(1,1) NOT NULL,
  	[ProjectName] [nvarchar](max) NULL,
  	[LatestAssemblyVersionNumber] [nvarchar](max) NULL,
  	[AutoUpdaterXMLPath] [nvarchar](max) NULL,
   CONSTRAINT [PK_Projects] PRIMARY KEY CLUSTERED 
  (
  	[ProjectId] 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
  INSERT [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20181213030512_Initial', N'2.1.3-rtm-32065')
  GO
  SET IDENTITY_INSERT [dbo].[AspNetRoleClaims] ON 
  GO
  INSERT [dbo].[AspNetRoleClaims] ([Id], [RoleId], [ClaimType], [ClaimValue]) VALUES (1, N'e1a134fd-0766-4f19-8517-845fbf6c39ef', N'IsAdmin', N'True')
  GO
  SET IDENTITY_INSERT [dbo].[AspNetRoleClaims] OFF
  GO
  INSERT [dbo].[AspNetRoles] ([Id], [Name], [NormalizedName], [ConcurrencyStamp]) VALUES (N'e1a134fd-0766-4f19-8517-845fbf6c39ef', N'Admin', N'ADMIN', N'9bbc3825-670e-4a15-bb9e-cd9abe5cc9ef')
  GO
  SET IDENTITY_INSERT [dbo].[AspNetUserClaims] ON 
  GO
  INSERT [dbo].[AspNetUserClaims] ([Id], [UserId], [ClaimType], [ClaimValue]) VALUES (1, N'e263e4b7-51c1-4808-951e-9dccd5a5b788', N'SuperUser', N'True')
  GO
  SET IDENTITY_INSERT [dbo].[AspNetUserClaims] OFF
  GO
  INSERT [dbo].[AspNetUserRoles] ([UserId], [RoleId]) VALUES (N'e263e4b7-51c1-4808-951e-9dccd5a5b788', N'e1a134fd-0766-4f19-8517-845fbf6c39ef')
  GO
  INSERT [dbo].[AspNetUsers] ([Id], [UserName], [NormalizedUserName], [Email], [NormalizedEmail], [EmailConfirmed], [PasswordHash], [SecurityStamp], [ConcurrencyStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEnd], [LockoutEnabled], [AccessFailedCount], [FirstName], [LastName]) VALUES (N'e263e4b7-51c1-4808-951e-9dccd5a5b788', N'Justbeingjustin', N'JUSTBEINGJUSTIN', N'JustinShawnGerber@gmail.com', N'JUSTINSHAWNGERBER@GMAIL.COM', 0, N'AQAAAAEAACcQAAAAEHgaT00mWTpYDR9f3xINpjKDLLa6bpcekYlq8HtLIHJzAH/mSSNpSuVbjziI0W9IgA==', N'JXJH2JC2Q5NSEWCPX7ZOPW4236LEDZ7U', N'ddc0e122-9bd3-4f3d-94ea-17483ce10a9c', NULL, 0, 0, NULL, 1, 0, N'Justin', N'Gerber')
  GO
  SET IDENTITY_INSERT [dbo].[Projects] ON 
  GO
  INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [LatestAssemblyVersionNumber], [AutoUpdaterXMLPath]) VALUES (1, N'sampleWPFApp', N'1.0.0.0', N'https://rbsoft.org/updates/AutoUpdaterTest.xml')
  GO
  SET IDENTITY_INSERT [dbo].[Projects] OFF
  GO
  ALTER TABLE [dbo].[AspNetRoleClaims]  WITH CHECK ADD  CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[AspNetRoles] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetRoleClaims] CHECK CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId]
  GO
  ALTER TABLE [dbo].[AspNetUserClaims]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserClaims] CHECK CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId]
  GO
  ALTER TABLE [dbo].[AspNetUserLogins]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserLogins] CHECK CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId]
  GO
  ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId] FOREIGN KEY([RoleId])
  REFERENCES [dbo].[AspNetRoles] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId]
  GO
  ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId]
  GO
  ALTER TABLE [dbo].[AspNetUserTokens]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId] FOREIGN KEY([UserId])
  REFERENCES [dbo].[AspNetUsers] ([Id])
  ON DELETE CASCADE
  GO
  ALTER TABLE [dbo].[AspNetUserTokens] CHECK CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId]
  GO
  