
    EXECUTE sp_rename @objname = N'dbo.AspNetUserClaims.User_Id', @newname = N'UserId', @objtype = N'COLUMN'
    EXECUTE sp_rename @objname = N'dbo.AspNetUserClaims.IX_User_Id', @newname = N'IX_UserId', @objtype = N'INDEX'
    ALTER TABLE [dbo].[AspNetUserLogins] DROP CONSTRAINT [PK_dbo.AspNetUserLogins]
    ALTER TABLE [dbo].[AspNetUsers] ADD [Email] [nvarchar](256)
    ALTER TABLE [dbo].[AspNetUsers] ADD [EmailConfirmed] [bit] NOT NULL DEFAULT 0
    ALTER TABLE [dbo].[AspNetUsers] ADD [PhoneNumber] [nvarchar](max)
    ALTER TABLE [dbo].[AspNetUsers] ADD [PhoneNumberConfirmed] [bit] NOT NULL DEFAULT 0
    ALTER TABLE [dbo].[AspNetUsers] ADD [TwoFactorEnabled] [bit] NOT NULL DEFAULT 0
    ALTER TABLE [dbo].[AspNetUsers] ADD [LockoutEndDateUtc] [datetime]
    ALTER TABLE [dbo].[AspNetUsers] ADD [LockoutEnabled] [bit] NOT NULL DEFAULT 0
    ALTER TABLE [dbo].[AspNetUsers] ADD [AccessFailedCount] [int] NOT NULL DEFAULT 0
    ALTER TABLE [dbo].[AspNetRoles] ALTER COLUMN [Name] [nvarchar](256) NOT NULL
    ALTER TABLE [dbo].[AspNetUsers] ALTER COLUMN [UserName] [nvarchar](256) NOT NULL
    ALTER TABLE [dbo].[AspNetUserLogins] ADD CONSTRAINT [PK_dbo.AspNetUserLogins] PRIMARY KEY ([LoginProvider], [ProviderKey], [UserId])
    CREATE UNIQUE INDEX [RoleNameIndex] ON [dbo].[AspNetRoles]([Name])
    CREATE UNIQUE INDEX [UserNameIndex] ON [dbo].[AspNetUsers]([UserName])
    DECLARE @var0 nvarchar(128)
    SELECT @var0 = name
    FROM sys.default_constraints
    WHERE parent_object_id = object_id(N'dbo.AspNetUsers')
    AND col_name(parent_object_id, parent_column_id) = 'Discriminator';
    IF @var0 IS NOT NULL
        EXECUTE('ALTER TABLE [dbo].[AspNetUsers] DROP CONSTRAINT [' + @var0 + ']')
    ALTER TABLE [dbo].[AspNetUsers] DROP COLUMN [Discriminator]