Asp.net Identity update

[rayrfan]

Use int PK for all tables (done)

By default the aspnet tables use string as the PK. Here are two ref on how to change that.

• https://docs.microsoft.com/en-us/aspnet/core/security/authentication/identity-primary-key-configuration?tabs=aspnetcore2x
• https://docs.microsoft.com/en-us/aspnet/core/migration/1x-to-2x/identity-2x

Rename table names (done)

• Rename aspnet table to "Fan_" and use singular table name instead of plural such as
  AspNetRoles -> Fan_Roles
• Add "Blog_" prefix to other tables.

Decide on name and email when sign up and login (not right now)

I want to eventually support login with either a username or email but not right now due to lack of time, once you add a Username field, you have to

• Validate username (a-z,0-9 that sort thing)
• Verify if incoming username is email or not, if it's email search use by it and get the real username

So for right now just use email and fill the UserName column with email. In future I can use username login on other apps.

Add default "Admin" Role during blog setup (done)

Should I add the following properties to Role table

• IsSystemRole
• Description

This is done in BlogController Setup post.
https://stackoverflow.com/questions/42471866/how-to-create-roles-in-asp-net-core-and-assign-them-to-users

Decide whether to keep Migrations as part of my repo (done)

Based on my research there is no easy way to support multiple database vendors with migration.