This is a quick solution to import the ASP.NET Identity objects in the database you want.
There are situations where you want to use ASP.NET Identity objects in your database without Code First migrations. So, here I am attaching and adding the script which incorporates all the objects with identical relationships.
  1. USE [DBNAME]
  2. GO
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. CREATE TABLE [dbo].[AspNetRoles](
  9. [Id] [nvarchar](128) NOT NULL,
  10. [Name] [nvarchar](256) NOT NULL,
  11. CONSTRAINT [PK_dbo.AspNetRoles] PRIMARY KEY CLUSTERED
  12. (
  13. [Id] ASC
  14. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  15. ) ON [PRIMARY]
  16. GO
  18. SET ANSI_NULLS ON
  19. GO
  20. SET QUOTED_IDENTIFIER ON
  21. GO
  22. CREATE TABLE [dbo].[AspNetUsers](
  23. [Id] [nvarchar](128) NOT NULL,
  24. [Email] [nvarchar](256) NULL,
  25. [EmailConfirmed] [bit] NOT NULL,
  26. [PasswordHash] [nvarchar](max) NULL,
  27. [SecurityStamp] [nvarchar](max) NULL,
  28. [PhoneNumber] [nvarchar](max) NULL,
  29. [PhoneNumberConfirmed] [bit] NOT NULL,
  30. [TwoFactorEnabled] [bit] NOT NULL,
  31. [LockoutEndDateUtc] [datetime] NULL,
  32. [LockoutEnabled] [bit] NOT NULL,
  33. [AccessFailedCount] [int] NOT NULL,
  34. [UserName] [nvarchar](256) NOT NULL,
  35. CONSTRAINT [PK_dbo.AspNetUsers] PRIMARY KEY CLUSTERED
  36. (
  37. [Id] ASC
  38. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  39. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  40. GO
  42. SET ANSI_NULLS ON
  43. GO
  44. SET QUOTED_IDENTIFIER ON
  45. GO
  46. CREATE TABLE [dbo].[AspNetUserRoles](
  47. [UserId] [nvarchar](128) NOT NULL,
  48. [RoleId] [nvarchar](128) NOT NULL,
  49. CONSTRAINT [PK_dbo.AspNetUserRoles] PRIMARY KEY CLUSTERED
  50. (
  51. [UserId] ASC,
  52. [RoleId] ASC
  53. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  54. ) ON [PRIMARY]
  55. GO
  57. SET ANSI_NULLS ON
  58. GO
  59. SET QUOTED_IDENTIFIER ON
  60. GO
  61. CREATE TABLE [dbo].[AspNetUserClaims](
  62. [Id] [int] IDENTITY(1,1) NOT NULL,
  63. [UserId] [nvarchar](128) NOT NULL,
  64. [ClaimType] [nvarchar](max) NULL,
  65. [ClaimValue] [nvarchar](max) NULL,
  66. CONSTRAINT [PK_dbo.AspNetUserClaims] PRIMARY KEY CLUSTERED
  67. (
  68. [Id] ASC
  69. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  70. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  71. GO
  73. SET ANSI_NULLS ON
  74. GO
  75. SET QUOTED_IDENTIFIER ON
  76. GO
  77. CREATE TABLE [dbo].[AspNetUserLogins](
  78. [LoginProvider] [nvarchar](128) NOT NULL,
  79. [ProviderKey] [nvarchar](128) NOT NULL,
  80. [UserId] [nvarchar](128) NOT NULL,
  81. CONSTRAINT [PK_dbo.AspNetUserLogins] PRIMARY KEY CLUSTERED
  82. (
  83. [LoginProvider] ASC,
  84. [ProviderKey] ASC,
  85. [UserId] ASC
  86. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  87. ) ON [PRIMARY]
  88. GO
  90. ALTER TABLE [dbo].[AspNetUserClaims] WITH CHECK ADD CONSTRAINT [FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId] FOREIGN KEY([UserId])
  91. REFERENCES [dbo].[AspNetUsers] ([Id])
  92. ON DELETE CASCADE
  93. GO
  94. ALTER TABLE [dbo].[AspNetUserClaims] CHECK CONSTRAINT [FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId]
  95. GO
  97. ALTER TABLE [dbo].[AspNetUserLogins] WITH CHECK ADD CONSTRAINT [FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId] FOREIGN KEY([UserId])
  98. REFERENCES [dbo].[AspNetUsers] ([Id])
  99. ON DELETE CASCADE
  100. GO
  101. ALTER TABLE [dbo].[AspNetUserLogins] CHECK CONSTRAINT [FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId]
  102. GO
  104. ALTER TABLE [dbo].[AspNetUserRoles] WITH CHECK ADD CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId] FOREIGN KEY([RoleId])
  105. REFERENCES [dbo].[AspNetRoles] ([Id])
  106. ON DELETE CASCADE
  107. GO
  108. ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId]
  109. GO
  111. ALTER TABLE [dbo].[AspNetUserRoles] WITH CHECK ADD CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId] FOREIGN KEY([UserId])
  112. REFERENCES [dbo].[AspNetUsers] ([Id])
  113. ON DELETE CASCADE
  114. GO
  115. ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId]
  116. GO