Você não pode selecionar mais de 25 tópicos Os tópicos devem começar com uma letra ou um número, podem incluir traços ('-') e podem ter até 35 caracteres.

20221024112939_AddedRefreshToken.Designer.cs 21KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597
  1. // <auto-generated />
  2. using System;
  3. using Diligent.WebAPI.Data;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Metadata;
  7. using Microsoft.EntityFrameworkCore.Migrations;
  8. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  9. #nullable disable
  10. namespace Diligent.WebAPI.Data.Migrations
  11. {
  12. [DbContext(typeof(DatabaseContext))]
  13. [Migration("20221024112939_AddedRefreshToken")]
  14. partial class AddedRefreshToken
  15. {
  16. protected override void BuildTargetModel(ModelBuilder modelBuilder)
  17. {
  18. #pragma warning disable 612, 618
  19. modelBuilder
  20. .HasAnnotation("ProductVersion", "6.0.10")
  21. .HasAnnotation("Relational:MaxIdentifierLength", 128);
  22. SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
  23. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.AppRole", b =>
  24. {
  25. b.Property<int>("Id")
  26. .ValueGeneratedOnAdd()
  27. .HasColumnType("int");
  28. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  29. b.Property<string>("ConcurrencyStamp")
  30. .IsConcurrencyToken()
  31. .HasColumnType("nvarchar(max)");
  32. b.Property<string>("Name")
  33. .HasMaxLength(256)
  34. .HasColumnType("nvarchar(256)");
  35. b.Property<string>("NormalizedName")
  36. .HasMaxLength(256)
  37. .HasColumnType("nvarchar(256)");
  38. b.HasKey("Id");
  39. b.HasIndex("NormalizedName")
  40. .IsUnique()
  41. .HasDatabaseName("RoleNameIndex")
  42. .HasFilter("[NormalizedName] IS NOT NULL");
  43. b.ToTable("AspNetRoles", (string)null);
  44. });
  45. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.InsuranceCompany", b =>
  46. {
  47. b.Property<long>("Id")
  48. .ValueGeneratedOnAdd()
  49. .HasColumnType("bigint");
  50. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  51. b.Property<string>("City")
  52. .IsRequired()
  53. .HasColumnType("nvarchar(max)");
  54. b.Property<string>("Country")
  55. .IsRequired()
  56. .HasColumnType("nvarchar(max)");
  57. b.Property<DateTime>("CreatedAtUtc")
  58. .HasColumnType("datetime2");
  59. b.Property<DateTime?>("DeletedAtUtc")
  60. .HasColumnType("datetime2");
  61. b.Property<string>("Fax")
  62. .IsRequired()
  63. .HasColumnType("nvarchar(max)");
  64. b.Property<string>("LegalAddress")
  65. .IsRequired()
  66. .HasColumnType("nvarchar(max)");
  67. b.Property<string>("LegalEmail")
  68. .IsRequired()
  69. .HasColumnType("nvarchar(max)");
  70. b.Property<string>("Name")
  71. .IsRequired()
  72. .HasColumnType("nvarchar(max)");
  73. b.Property<string>("PhoneNumber")
  74. .IsRequired()
  75. .HasColumnType("nvarchar(max)");
  76. b.Property<string>("PostalCode")
  77. .IsRequired()
  78. .HasColumnType("nvarchar(max)");
  79. b.Property<DateTime?>("UpdatedAtUtc")
  80. .HasColumnType("datetime2");
  81. b.HasKey("Id");
  82. b.ToTable("InsuranceCompanies");
  83. });
  84. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.InsurancePolicy", b =>
  85. {
  86. b.Property<long>("Id")
  87. .ValueGeneratedOnAdd()
  88. .HasColumnType("bigint");
  89. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  90. b.Property<DateTime>("CreatedAtUtc")
  91. .HasColumnType("datetime2");
  92. b.Property<DateTime?>("DeletedAtUtc")
  93. .HasColumnType("datetime2");
  94. b.Property<DateTime>("EndDate")
  95. .HasColumnType("datetime2");
  96. b.Property<long>("InsurerId")
  97. .HasColumnType("bigint");
  98. b.Property<decimal>("Premium")
  99. .HasColumnType("decimal(18,2)");
  100. b.Property<DateTime>("StartDate")
  101. .HasColumnType("datetime2");
  102. b.Property<string>("Type")
  103. .IsRequired()
  104. .HasColumnType("nvarchar(max)");
  105. b.Property<DateTime?>("UpdatedAtUtc")
  106. .HasColumnType("datetime2");
  107. b.HasKey("Id");
  108. b.HasIndex("InsurerId");
  109. b.ToTable("InsurancePolicies");
  110. });
  111. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.Insurer", b =>
  112. {
  113. b.Property<long>("Id")
  114. .ValueGeneratedOnAdd()
  115. .HasColumnType("bigint");
  116. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  117. b.Property<string>("Address")
  118. .IsRequired()
  119. .HasColumnType("nvarchar(max)");
  120. b.Property<string>("City")
  121. .IsRequired()
  122. .HasColumnType("nvarchar(max)");
  123. b.Property<string>("Country")
  124. .IsRequired()
  125. .HasColumnType("nvarchar(max)");
  126. b.Property<DateTime>("CreatedAtUtc")
  127. .HasColumnType("datetime2");
  128. b.Property<DateTime>("DateOfBirth")
  129. .HasColumnType("datetime2");
  130. b.Property<DateTime?>("DeletedAtUtc")
  131. .HasColumnType("datetime2");
  132. b.Property<string>("Email")
  133. .IsRequired()
  134. .HasColumnType("nvarchar(max)");
  135. b.Property<string>("FirstName")
  136. .IsRequired()
  137. .HasColumnType("nvarchar(max)");
  138. b.Property<long>("InsuranceCompanyId")
  139. .HasColumnType("bigint");
  140. b.Property<string>("LastName")
  141. .IsRequired()
  142. .HasColumnType("nvarchar(max)");
  143. b.Property<string>("PhoneNumber")
  144. .IsRequired()
  145. .HasColumnType("nvarchar(max)");
  146. b.Property<string>("PostalCode")
  147. .IsRequired()
  148. .HasColumnType("nvarchar(max)");
  149. b.Property<DateTime?>("UpdatedAtUtc")
  150. .HasColumnType("datetime2");
  151. b.HasKey("Id");
  152. b.HasIndex("InsuranceCompanyId");
  153. b.ToTable("Insurers");
  154. });
  155. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.RefreshToken", b =>
  156. {
  157. b.Property<int>("Id")
  158. .ValueGeneratedOnAdd()
  159. .HasColumnType("int");
  160. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  161. b.Property<DateTime>("CreationDate")
  162. .HasColumnType("datetime2");
  163. b.Property<DateTime>("ExpiryDate")
  164. .HasColumnType("datetime2");
  165. b.Property<bool>("Invalidated")
  166. .HasColumnType("bit");
  167. b.Property<string>("JwtId")
  168. .IsRequired()
  169. .HasColumnType("nvarchar(max)");
  170. b.Property<string>("Token")
  171. .IsRequired()
  172. .HasColumnType("nvarchar(max)");
  173. b.Property<bool>("Used")
  174. .HasColumnType("bit");
  175. b.Property<int>("UserId")
  176. .HasColumnType("int");
  177. b.HasKey("Id");
  178. b.HasIndex("UserId");
  179. b.ToTable("RefreshTokens");
  180. });
  181. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.User", b =>
  182. {
  183. b.Property<int>("Id")
  184. .ValueGeneratedOnAdd()
  185. .HasColumnType("int");
  186. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  187. b.Property<int>("AccessFailedCount")
  188. .HasColumnType("int");
  189. b.Property<string>("ConcurrencyStamp")
  190. .IsConcurrencyToken()
  191. .HasColumnType("nvarchar(max)");
  192. b.Property<string>("Email")
  193. .HasMaxLength(256)
  194. .HasColumnType("nvarchar(256)");
  195. b.Property<bool>("EmailConfirmed")
  196. .HasColumnType("bit");
  197. b.Property<string>("FirstName")
  198. .IsRequired()
  199. .HasColumnType("nvarchar(max)");
  200. b.Property<string>("LastName")
  201. .IsRequired()
  202. .HasColumnType("nvarchar(max)");
  203. b.Property<bool>("LockoutEnabled")
  204. .HasColumnType("bit");
  205. b.Property<DateTimeOffset?>("LockoutEnd")
  206. .HasColumnType("datetimeoffset");
  207. b.Property<string>("NormalizedEmail")
  208. .HasMaxLength(256)
  209. .HasColumnType("nvarchar(256)");
  210. b.Property<string>("NormalizedUserName")
  211. .HasMaxLength(256)
  212. .HasColumnType("nvarchar(256)");
  213. b.Property<string>("PasswordHash")
  214. .HasColumnType("nvarchar(max)");
  215. b.Property<string>("PhoneNumber")
  216. .HasColumnType("nvarchar(max)");
  217. b.Property<bool>("PhoneNumberConfirmed")
  218. .HasColumnType("bit");
  219. b.Property<string>("SecurityStamp")
  220. .HasColumnType("nvarchar(max)");
  221. b.Property<bool>("TwoFactorEnabled")
  222. .HasColumnType("bit");
  223. b.Property<string>("UserName")
  224. .HasMaxLength(256)
  225. .HasColumnType("nvarchar(256)");
  226. b.HasKey("Id");
  227. b.HasIndex("NormalizedEmail")
  228. .HasDatabaseName("EmailIndex");
  229. b.HasIndex("NormalizedUserName")
  230. .IsUnique()
  231. .HasDatabaseName("UserNameIndex")
  232. .HasFilter("[NormalizedUserName] IS NOT NULL");
  233. b.ToTable("AspNetUsers", (string)null);
  234. });
  235. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.WebhookDefinition", b =>
  236. {
  237. b.Property<long>("Id")
  238. .ValueGeneratedOnAdd()
  239. .HasColumnType("bigint");
  240. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  241. b.Property<DateTime>("CreatedAtUtc")
  242. .HasColumnType("datetime2");
  243. b.Property<DateTime?>("DeletedAtUtc")
  244. .HasColumnType("datetime2");
  245. b.Property<string>("Description")
  246. .IsRequired()
  247. .HasColumnType("nvarchar(max)");
  248. b.Property<string>("DisplayName")
  249. .IsRequired()
  250. .HasMaxLength(100)
  251. .HasColumnType("nvarchar(100)");
  252. b.Property<string>("Name")
  253. .IsRequired()
  254. .HasMaxLength(100)
  255. .HasColumnType("nvarchar(100)");
  256. b.Property<DateTime?>("UpdatedAtUtc")
  257. .HasColumnType("datetime2");
  258. b.HasKey("Id");
  259. b.ToTable("WebhookDefinitions");
  260. });
  261. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.WebhookSubscription", b =>
  262. {
  263. b.Property<long>("Id")
  264. .ValueGeneratedOnAdd()
  265. .HasColumnType("bigint");
  266. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  267. b.Property<DateTime>("CreatedAtUtc")
  268. .HasColumnType("datetime2");
  269. b.Property<DateTime?>("DeletedAtUtc")
  270. .HasColumnType("datetime2");
  271. b.Property<bool>("IsActive")
  272. .HasColumnType("bit");
  273. b.Property<DateTime?>("UpdatedAtUtc")
  274. .HasColumnType("datetime2");
  275. b.Property<long>("WebhookDefinitionId")
  276. .HasColumnType("bigint");
  277. b.Property<string>("WebhookURL")
  278. .IsRequired()
  279. .HasColumnType("nvarchar(max)");
  280. b.HasKey("Id");
  281. b.HasIndex("WebhookDefinitionId");
  282. b.ToTable("WebhookSubscriptions");
  283. });
  284. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<int>", b =>
  285. {
  286. b.Property<int>("Id")
  287. .ValueGeneratedOnAdd()
  288. .HasColumnType("int");
  289. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  290. b.Property<string>("ClaimType")
  291. .HasColumnType("nvarchar(max)");
  292. b.Property<string>("ClaimValue")
  293. .HasColumnType("nvarchar(max)");
  294. b.Property<int>("RoleId")
  295. .HasColumnType("int");
  296. b.HasKey("Id");
  297. b.HasIndex("RoleId");
  298. b.ToTable("AspNetRoleClaims", (string)null);
  299. });
  300. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<int>", b =>
  301. {
  302. b.Property<int>("Id")
  303. .ValueGeneratedOnAdd()
  304. .HasColumnType("int");
  305. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  306. b.Property<string>("ClaimType")
  307. .HasColumnType("nvarchar(max)");
  308. b.Property<string>("ClaimValue")
  309. .HasColumnType("nvarchar(max)");
  310. b.Property<int>("UserId")
  311. .HasColumnType("int");
  312. b.HasKey("Id");
  313. b.HasIndex("UserId");
  314. b.ToTable("AspNetUserClaims", (string)null);
  315. });
  316. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<int>", b =>
  317. {
  318. b.Property<string>("LoginProvider")
  319. .HasColumnType("nvarchar(450)");
  320. b.Property<string>("ProviderKey")
  321. .HasColumnType("nvarchar(450)");
  322. b.Property<string>("ProviderDisplayName")
  323. .HasColumnType("nvarchar(max)");
  324. b.Property<int>("UserId")
  325. .HasColumnType("int");
  326. b.HasKey("LoginProvider", "ProviderKey");
  327. b.HasIndex("UserId");
  328. b.ToTable("AspNetUserLogins", (string)null);
  329. });
  330. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<int>", b =>
  331. {
  332. b.Property<int>("UserId")
  333. .HasColumnType("int");
  334. b.Property<int>("RoleId")
  335. .HasColumnType("int");
  336. b.HasKey("UserId", "RoleId");
  337. b.HasIndex("RoleId");
  338. b.ToTable("AspNetUserRoles", (string)null);
  339. });
  340. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<int>", b =>
  341. {
  342. b.Property<int>("UserId")
  343. .HasColumnType("int");
  344. b.Property<string>("LoginProvider")
  345. .HasColumnType("nvarchar(450)");
  346. b.Property<string>("Name")
  347. .HasColumnType("nvarchar(450)");
  348. b.Property<string>("Value")
  349. .HasColumnType("nvarchar(max)");
  350. b.HasKey("UserId", "LoginProvider", "Name");
  351. b.ToTable("AspNetUserTokens", (string)null);
  352. });
  353. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.InsurancePolicy", b =>
  354. {
  355. b.HasOne("Diligent.WebAPI.Data.Entities.Insurer", "Insurer")
  356. .WithMany()
  357. .HasForeignKey("InsurerId")
  358. .OnDelete(DeleteBehavior.Cascade)
  359. .IsRequired();
  360. b.Navigation("Insurer");
  361. });
  362. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.Insurer", b =>
  363. {
  364. b.HasOne("Diligent.WebAPI.Data.Entities.InsuranceCompany", "InsuranceCompany")
  365. .WithMany()
  366. .HasForeignKey("InsuranceCompanyId")
  367. .OnDelete(DeleteBehavior.Cascade)
  368. .IsRequired();
  369. b.Navigation("InsuranceCompany");
  370. });
  371. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.RefreshToken", b =>
  372. {
  373. b.HasOne("Diligent.WebAPI.Data.Entities.User", "User")
  374. .WithMany()
  375. .HasForeignKey("UserId")
  376. .OnDelete(DeleteBehavior.Cascade)
  377. .IsRequired();
  378. b.Navigation("User");
  379. });
  380. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.WebhookSubscription", b =>
  381. {
  382. b.HasOne("Diligent.WebAPI.Data.Entities.WebhookDefinition", "WebhookDefinition")
  383. .WithMany()
  384. .HasForeignKey("WebhookDefinitionId")
  385. .OnDelete(DeleteBehavior.Cascade)
  386. .IsRequired();
  387. b.Navigation("WebhookDefinition");
  388. });
  389. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<int>", b =>
  390. {
  391. b.HasOne("Diligent.WebAPI.Data.Entities.AppRole", null)
  392. .WithMany()
  393. .HasForeignKey("RoleId")
  394. .OnDelete(DeleteBehavior.Cascade)
  395. .IsRequired();
  396. });
  397. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<int>", b =>
  398. {
  399. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  400. .WithMany()
  401. .HasForeignKey("UserId")
  402. .OnDelete(DeleteBehavior.Cascade)
  403. .IsRequired();
  404. });
  405. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<int>", b =>
  406. {
  407. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  408. .WithMany()
  409. .HasForeignKey("UserId")
  410. .OnDelete(DeleteBehavior.Cascade)
  411. .IsRequired();
  412. });
  413. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<int>", b =>
  414. {
  415. b.HasOne("Diligent.WebAPI.Data.Entities.AppRole", null)
  416. .WithMany()
  417. .HasForeignKey("RoleId")
  418. .OnDelete(DeleteBehavior.Cascade)
  419. .IsRequired();
  420. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  421. .WithMany()
  422. .HasForeignKey("UserId")
  423. .OnDelete(DeleteBehavior.Cascade)
  424. .IsRequired();
  425. });
  426. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<int>", b =>
  427. {
  428. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  429. .WithMany()
  430. .HasForeignKey("UserId")
  431. .OnDelete(DeleteBehavior.Cascade)
  432. .IsRequired();
  433. });
  434. #pragma warning restore 612, 618
  435. }
  436. }
  437. }