Skip to content

Instantly share code, notes, and snippets.

@jjwilliams42
Last active November 11, 2017 06:15
Show Gist options
  • Save jjwilliams42/9a5b93bcbd98e0b97cedac7d8f2368a5 to your computer and use it in GitHub Desktop.
Save jjwilliams42/9a5b93bcbd98e0b97cedac7d8f2368a5 to your computer and use it in GitHub Desktop.
Migration from ASP.NET Identity 2 to Service Stack
ALTER TABLE AspNetUsers
ADD
[PrimaryEmail] nvarchar(max) NULL,
[DisplayName] nvarchar(max) NULL,
[Company] nvarchar(max) NULL,
[Birthdate] datetime NULL,
[BirthdateRaw] nvarchar(max) NULL,
[Address] nvarchar(max) NULL,
[Address2] nvarchar(max) NULL,
[City] nvarchar(max) NULL,
[State] nvarchar(max) NULL,
[Country] nvarchar(max) NULL,
[Culture] nvarchar(max) NULL,
[FullName] nvarchar(max) NULL,
[Gender] nvarchar(max) NULL,
[Language] nvarchar(max) NULL,
[MailAddress] nvarchar(max) NULL,
[Nickname] nvarchar(max) NULL,
[PostalCode] nvarchar(max) NULL,
[TimeZone] nvarchar(max) NULL,
[Salt] nvarchar(max) NULL,
[DigestHa1Hash] nvarchar(max) NULL,
[Roles] nvarchar(max) NULL,
[Permissions] nvarchar(max) NULL,
[CreatedDate] datetime NULL,
[ModifiedDate] datetime NULL,
[InvalidLoginAttempts] int NULL,
[LastLoginAttempt] datetime NULL,
[LockedDate] datetime NULL,
[RecoveryToken] nvarchar(max) NULL,
[RefId] int NULL,
[RefIdStr] nvarchar(max) NULL,
[Meta] nvarchar(max) NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment