Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.08 KB | None | 0 0
  1. Create.Table("AspNetRoles")
  2. .WithColumn("Id").AsString().PrimaryKey("PK_AspNetRoles").NotNullable()
  3. .WithColumn("ConcurrencyStamp").AsString().Nullable()
  4. .WithColumn("Name").AsString(256).NotNullable()
  5. .WithColumn("NormalizedName").AsString(256).Nullable()
  6. .Indexed("RoleNameIndex");
  7.  
  8.  
  9. Create.Table("AspNetUserTokens")
  10. .WithColumn("UserId").AsString().PrimaryKey("PK_AspNetUserTokens").NotNullable()
  11. .WithColumn("LoginProvider").AsString()
  12. .WithColumn("Name").AsString()
  13. .WithColumn("Value").AsString();
  14.  
  15. Create.Table("AspNetUsers")
  16. .WithColumn("Id").AsString().NotNullable().PrimaryKey("PK_AspNetUsers")
  17. .WithColumn("AccessFailedCount").AsInt32().NotNullable()
  18. .WithColumn("ConcurrencyStamp").AsString().Nullable()
  19. .WithColumn("Email").AsString(256).Nullable()
  20. .WithColumn("EmailConfirmed").AsBoolean().NotNullable()
  21. .WithColumn("LockoutEnabled").AsBoolean().NotNullable()
  22. .WithColumn("LockoutEnd").AsDateTimeOffset().Nullable()
  23. .WithColumn("NormalizedEmail").AsString().Nullable()
  24. .WithColumn("NormalizedUserName").AsString().Nullable()
  25. .WithColumn("PasswordHash").AsString().Nullable()
  26. .WithColumn("PhoneNumber").AsString().Nullable()
  27. .WithColumn("PhoneNumberConfirmed").AsBoolean().NotNullable()
  28. .WithColumn("SecurityStamp").AsString().Nullable()
  29. .WithColumn("TwoFactorEnabled").AsBoolean().NotNullable()
  30. .WithColumn("UserName").AsString(256).Nullable();
  31.  
  32.  
  33. Create.Table("AspNetRoleClaims")
  34. .WithColumn("Id").AsInt32().PrimaryKey("PK_AspNetRoleClaims").Identity()
  35. .WithColumn("ClaimType").AsString().Nullable()
  36. .WithColumn("ClaimValue").AsString().Nullable()
  37. .WithColumn("RoleId").AsString().NotNullable().Indexed("IX_AspNetRoleClaims_RoleId")
  38. .ForeignKey("FK_AspNetRoleClaims_AspNetRoles_RoleId", "AspNetRoles", "Id");
  39.  
  40. Create.Table("AspNetUserClaims")
  41. .WithColumn("Id").AsInt32().PrimaryKey("PK_AspNetUserClaims").Identity()
  42. .WithColumn("ClaimType").AsString().Nullable()
  43. .WithColumn("ClaimValue").AsString().Nullable()
  44. .WithColumn("UserId").AsString().NotNullable().Indexed("IX_AspNetUserClaims_UserId")
  45. .ForeignKey("FK_AspNetUserClaims_AspNetUsers_UserId", "AspNetUsers", "Id")
  46. .OnDelete(System.Data.Rule.Cascade);
  47.  
  48. Create.Table("AspNetUserLogins")
  49. .WithColumn("LoginProvider").AsString().NotNullable().PrimaryKey("PK_AspNetUserLogins")
  50. .WithColumn("ProviderKey").AsString().NotNullable().PrimaryKey("PK_AspNetUserLogins")
  51. .WithColumn("ProviderDisplayName").AsString().Nullable()
  52. .WithColumn("UserId").AsString()
  53. .NotNullable()
  54. .Indexed("IX_AspNetUserLogins_UserId")
  55. .ForeignKey("FK_AspNetUserLogins_AspNetUsers_UserId", "AspNetUsers", "Id")
  56. .OnDelete(System.Data.Rule.Cascade);
  57.  
  58.  
  59. Create.Table("AspNetUserRoles")
  60. .WithColumn("UserId").AsString()
  61. .PrimaryKey("PK_AspNetUserRoles")
  62. .Indexed("IX_AspNetUserRoles_UserId")
  63. .ForeignKey("FK_AspNetUserRoles_AspNetUsers_UserId", "AspNetUsers", "Id")
  64.  
  65. .WithColumn("RoleId").AsString()
  66. .PrimaryKey("PK_AspNetUserRoles")
  67. .Indexed("IX_AspNetUserRoles_RoleId")
  68. .ForeignKey("FK_AspNetUserRoles_AspNetRoles_RoleId", "AspNetRoles", "Id")
  69. .OnDelete(System.Data.Rule.Cascade);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement