JellyfinDbModelSnapshot.cs 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649
  1. // <auto-generated />
  2. using System;
  3. using Jellyfin.Server.Implementations;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  7. namespace Jellyfin.Server.Implementations.Migrations
  8. {
  9. [DbContext(typeof(JellyfinDb))]
  10. partial class JellyfinDbModelSnapshot : ModelSnapshot
  11. {
  12. protected override void BuildModel(ModelBuilder modelBuilder)
  13. {
  14. #pragma warning disable 612, 618
  15. modelBuilder
  16. .HasDefaultSchema("jellyfin")
  17. .HasAnnotation("ProductVersion", "5.0.7");
  18. modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
  19. {
  20. b.Property<int>("Id")
  21. .ValueGeneratedOnAdd()
  22. .HasColumnType("INTEGER");
  23. b.Property<int>("DayOfWeek")
  24. .HasColumnType("INTEGER");
  25. b.Property<double>("EndHour")
  26. .HasColumnType("REAL");
  27. b.Property<double>("StartHour")
  28. .HasColumnType("REAL");
  29. b.Property<Guid>("UserId")
  30. .HasColumnType("TEXT");
  31. b.HasKey("Id");
  32. b.HasIndex("UserId");
  33. b.ToTable("AccessSchedules");
  34. });
  35. modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b =>
  36. {
  37. b.Property<int>("Id")
  38. .ValueGeneratedOnAdd()
  39. .HasColumnType("INTEGER");
  40. b.Property<DateTime>("DateCreated")
  41. .HasColumnType("TEXT");
  42. b.Property<string>("ItemId")
  43. .HasMaxLength(256)
  44. .HasColumnType("TEXT");
  45. b.Property<int>("LogSeverity")
  46. .HasColumnType("INTEGER");
  47. b.Property<string>("Name")
  48. .IsRequired()
  49. .HasMaxLength(512)
  50. .HasColumnType("TEXT");
  51. b.Property<string>("Overview")
  52. .HasMaxLength(512)
  53. .HasColumnType("TEXT");
  54. b.Property<uint>("RowVersion")
  55. .IsConcurrencyToken()
  56. .HasColumnType("INTEGER");
  57. b.Property<string>("ShortOverview")
  58. .HasMaxLength(512)
  59. .HasColumnType("TEXT");
  60. b.Property<string>("Type")
  61. .IsRequired()
  62. .HasMaxLength(256)
  63. .HasColumnType("TEXT");
  64. b.Property<Guid>("UserId")
  65. .HasColumnType("TEXT");
  66. b.HasKey("Id");
  67. b.ToTable("ActivityLogs");
  68. });
  69. modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b =>
  70. {
  71. b.Property<int>("Id")
  72. .ValueGeneratedOnAdd()
  73. .HasColumnType("INTEGER");
  74. b.Property<string>("Client")
  75. .IsRequired()
  76. .HasMaxLength(32)
  77. .HasColumnType("TEXT");
  78. b.Property<Guid>("ItemId")
  79. .HasColumnType("TEXT");
  80. b.Property<string>("Key")
  81. .IsRequired()
  82. .HasColumnType("TEXT");
  83. b.Property<Guid>("UserId")
  84. .HasColumnType("TEXT");
  85. b.Property<string>("Value")
  86. .HasColumnType("TEXT");
  87. b.HasKey("Id");
  88. b.HasIndex("UserId", "ItemId", "Client", "Key")
  89. .IsUnique();
  90. b.ToTable("CustomItemDisplayPreferences");
  91. });
  92. modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
  93. {
  94. b.Property<int>("Id")
  95. .ValueGeneratedOnAdd()
  96. .HasColumnType("INTEGER");
  97. b.Property<int>("ChromecastVersion")
  98. .HasColumnType("INTEGER");
  99. b.Property<string>("Client")
  100. .IsRequired()
  101. .HasMaxLength(32)
  102. .HasColumnType("TEXT");
  103. b.Property<string>("DashboardTheme")
  104. .HasMaxLength(32)
  105. .HasColumnType("TEXT");
  106. b.Property<bool>("EnableNextVideoInfoOverlay")
  107. .HasColumnType("INTEGER");
  108. b.Property<int?>("IndexBy")
  109. .HasColumnType("INTEGER");
  110. b.Property<Guid>("ItemId")
  111. .HasColumnType("TEXT");
  112. b.Property<int>("ScrollDirection")
  113. .HasColumnType("INTEGER");
  114. b.Property<bool>("ShowBackdrop")
  115. .HasColumnType("INTEGER");
  116. b.Property<bool>("ShowSidebar")
  117. .HasColumnType("INTEGER");
  118. b.Property<int>("SkipBackwardLength")
  119. .HasColumnType("INTEGER");
  120. b.Property<int>("SkipForwardLength")
  121. .HasColumnType("INTEGER");
  122. b.Property<string>("TvHome")
  123. .HasMaxLength(32)
  124. .HasColumnType("TEXT");
  125. b.Property<Guid>("UserId")
  126. .HasColumnType("TEXT");
  127. b.HasKey("Id");
  128. b.HasIndex("UserId", "ItemId", "Client")
  129. .IsUnique();
  130. b.ToTable("DisplayPreferences");
  131. });
  132. modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
  133. {
  134. b.Property<int>("Id")
  135. .ValueGeneratedOnAdd()
  136. .HasColumnType("INTEGER");
  137. b.Property<int>("DisplayPreferencesId")
  138. .HasColumnType("INTEGER");
  139. b.Property<int>("Order")
  140. .HasColumnType("INTEGER");
  141. b.Property<int>("Type")
  142. .HasColumnType("INTEGER");
  143. b.HasKey("Id");
  144. b.HasIndex("DisplayPreferencesId");
  145. b.ToTable("HomeSection");
  146. });
  147. modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
  148. {
  149. b.Property<int>("Id")
  150. .ValueGeneratedOnAdd()
  151. .HasColumnType("INTEGER");
  152. b.Property<DateTime>("LastModified")
  153. .HasColumnType("TEXT");
  154. b.Property<string>("Path")
  155. .IsRequired()
  156. .HasMaxLength(512)
  157. .HasColumnType("TEXT");
  158. b.Property<Guid?>("UserId")
  159. .HasColumnType("TEXT");
  160. b.HasKey("Id");
  161. b.HasIndex("UserId")
  162. .IsUnique();
  163. b.ToTable("ImageInfos");
  164. });
  165. modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
  166. {
  167. b.Property<int>("Id")
  168. .ValueGeneratedOnAdd()
  169. .HasColumnType("INTEGER");
  170. b.Property<string>("Client")
  171. .IsRequired()
  172. .HasMaxLength(32)
  173. .HasColumnType("TEXT");
  174. b.Property<int?>("IndexBy")
  175. .HasColumnType("INTEGER");
  176. b.Property<Guid>("ItemId")
  177. .HasColumnType("TEXT");
  178. b.Property<bool>("RememberIndexing")
  179. .HasColumnType("INTEGER");
  180. b.Property<bool>("RememberSorting")
  181. .HasColumnType("INTEGER");
  182. b.Property<string>("SortBy")
  183. .IsRequired()
  184. .HasMaxLength(64)
  185. .HasColumnType("TEXT");
  186. b.Property<int>("SortOrder")
  187. .HasColumnType("INTEGER");
  188. b.Property<Guid>("UserId")
  189. .HasColumnType("TEXT");
  190. b.Property<int>("ViewType")
  191. .HasColumnType("INTEGER");
  192. b.HasKey("Id");
  193. b.HasIndex("UserId");
  194. b.ToTable("ItemDisplayPreferences");
  195. });
  196. modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
  197. {
  198. b.Property<int>("Id")
  199. .ValueGeneratedOnAdd()
  200. .HasColumnType("INTEGER");
  201. b.Property<int>("Kind")
  202. .HasColumnType("INTEGER");
  203. b.Property<Guid?>("Permission_Permissions_Guid")
  204. .HasColumnType("TEXT");
  205. b.Property<uint>("RowVersion")
  206. .IsConcurrencyToken()
  207. .HasColumnType("INTEGER");
  208. b.Property<Guid?>("UserId")
  209. .HasColumnType("TEXT");
  210. b.Property<bool>("Value")
  211. .HasColumnType("INTEGER");
  212. b.HasKey("Id");
  213. b.HasIndex("UserId", "Kind")
  214. .IsUnique()
  215. .HasFilter("[UserId] IS NOT NULL");
  216. b.ToTable("Permissions");
  217. });
  218. modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
  219. {
  220. b.Property<int>("Id")
  221. .ValueGeneratedOnAdd()
  222. .HasColumnType("INTEGER");
  223. b.Property<int>("Kind")
  224. .HasColumnType("INTEGER");
  225. b.Property<Guid?>("Preference_Preferences_Guid")
  226. .HasColumnType("TEXT");
  227. b.Property<uint>("RowVersion")
  228. .IsConcurrencyToken()
  229. .HasColumnType("INTEGER");
  230. b.Property<Guid?>("UserId")
  231. .HasColumnType("TEXT");
  232. b.Property<string>("Value")
  233. .IsRequired()
  234. .HasMaxLength(65535)
  235. .HasColumnType("TEXT");
  236. b.HasKey("Id");
  237. b.HasIndex("UserId", "Kind")
  238. .IsUnique()
  239. .HasFilter("[UserId] IS NOT NULL");
  240. b.ToTable("Preferences");
  241. });
  242. modelBuilder.Entity("Jellyfin.Data.Entities.Security.ApiKey", b =>
  243. {
  244. b.Property<int>("Id")
  245. .ValueGeneratedOnAdd()
  246. .HasColumnType("INTEGER");
  247. b.Property<string>("AccessToken")
  248. .IsRequired()
  249. .HasColumnType("TEXT");
  250. b.Property<DateTime>("DateCreated")
  251. .HasColumnType("TEXT");
  252. b.Property<DateTime>("DateLastActivity")
  253. .HasColumnType("TEXT");
  254. b.Property<string>("Name")
  255. .IsRequired()
  256. .HasMaxLength(64)
  257. .HasColumnType("TEXT");
  258. b.HasKey("Id");
  259. b.HasIndex("AccessToken")
  260. .IsUnique();
  261. b.ToTable("ApiKeys");
  262. });
  263. modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
  264. {
  265. b.Property<int>("Id")
  266. .ValueGeneratedOnAdd()
  267. .HasColumnType("INTEGER");
  268. b.Property<string>("AccessToken")
  269. .IsRequired()
  270. .HasColumnType("TEXT");
  271. b.Property<string>("AppName")
  272. .IsRequired()
  273. .HasMaxLength(64)
  274. .HasColumnType("TEXT");
  275. b.Property<string>("AppVersion")
  276. .IsRequired()
  277. .HasMaxLength(32)
  278. .HasColumnType("TEXT");
  279. b.Property<DateTime>("DateCreated")
  280. .HasColumnType("TEXT");
  281. b.Property<DateTime>("DateLastActivity")
  282. .HasColumnType("TEXT");
  283. b.Property<DateTime>("DateModified")
  284. .HasColumnType("TEXT");
  285. b.Property<string>("DeviceId")
  286. .IsRequired()
  287. .HasMaxLength(256)
  288. .HasColumnType("TEXT");
  289. b.Property<string>("DeviceName")
  290. .IsRequired()
  291. .HasMaxLength(64)
  292. .HasColumnType("TEXT");
  293. b.Property<bool>("IsActive")
  294. .HasColumnType("INTEGER");
  295. b.Property<Guid>("UserId")
  296. .HasColumnType("TEXT");
  297. b.HasKey("Id");
  298. b.HasIndex("DeviceId");
  299. b.HasIndex("AccessToken", "DateLastActivity");
  300. b.HasIndex("DeviceId", "DateLastActivity");
  301. b.HasIndex("UserId", "DeviceId");
  302. b.ToTable("Devices");
  303. });
  304. modelBuilder.Entity("Jellyfin.Data.Entities.Security.DeviceOptions", b =>
  305. {
  306. b.Property<int>("Id")
  307. .ValueGeneratedOnAdd()
  308. .HasColumnType("INTEGER");
  309. b.Property<string>("CustomName")
  310. .HasColumnType("TEXT");
  311. b.Property<string>("DeviceId")
  312. .IsRequired()
  313. .HasColumnType("TEXT");
  314. b.HasKey("Id");
  315. b.HasIndex("DeviceId")
  316. .IsUnique();
  317. b.ToTable("DeviceOptions");
  318. });
  319. modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
  320. {
  321. b.Property<Guid>("Id")
  322. .ValueGeneratedOnAdd()
  323. .HasColumnType("TEXT");
  324. b.Property<string>("AudioLanguagePreference")
  325. .HasMaxLength(255)
  326. .HasColumnType("TEXT");
  327. b.Property<string>("AuthenticationProviderId")
  328. .IsRequired()
  329. .HasMaxLength(255)
  330. .HasColumnType("TEXT");
  331. b.Property<bool>("DisplayCollectionsView")
  332. .HasColumnType("INTEGER");
  333. b.Property<bool>("DisplayMissingEpisodes")
  334. .HasColumnType("INTEGER");
  335. b.Property<string>("EasyPassword")
  336. .HasMaxLength(65535)
  337. .HasColumnType("TEXT");
  338. b.Property<bool>("EnableAutoLogin")
  339. .HasColumnType("INTEGER");
  340. b.Property<bool>("EnableLocalPassword")
  341. .HasColumnType("INTEGER");
  342. b.Property<bool>("EnableNextEpisodeAutoPlay")
  343. .HasColumnType("INTEGER");
  344. b.Property<bool>("EnableUserPreferenceAccess")
  345. .HasColumnType("INTEGER");
  346. b.Property<bool>("HidePlayedInLatest")
  347. .HasColumnType("INTEGER");
  348. b.Property<long>("InternalId")
  349. .HasColumnType("INTEGER");
  350. b.Property<int>("InvalidLoginAttemptCount")
  351. .HasColumnType("INTEGER");
  352. b.Property<DateTime?>("LastActivityDate")
  353. .HasColumnType("TEXT");
  354. b.Property<DateTime?>("LastLoginDate")
  355. .HasColumnType("TEXT");
  356. b.Property<int?>("LoginAttemptsBeforeLockout")
  357. .HasColumnType("INTEGER");
  358. b.Property<int>("MaxActiveSessions")
  359. .HasColumnType("INTEGER");
  360. b.Property<int?>("MaxParentalAgeRating")
  361. .HasColumnType("INTEGER");
  362. b.Property<bool>("MustUpdatePassword")
  363. .HasColumnType("INTEGER");
  364. b.Property<string>("Password")
  365. .HasMaxLength(65535)
  366. .HasColumnType("TEXT");
  367. b.Property<string>("PasswordResetProviderId")
  368. .IsRequired()
  369. .HasMaxLength(255)
  370. .HasColumnType("TEXT");
  371. b.Property<bool>("PlayDefaultAudioTrack")
  372. .HasColumnType("INTEGER");
  373. b.Property<bool>("RememberAudioSelections")
  374. .HasColumnType("INTEGER");
  375. b.Property<bool>("RememberSubtitleSelections")
  376. .HasColumnType("INTEGER");
  377. b.Property<int?>("RemoteClientBitrateLimit")
  378. .HasColumnType("INTEGER");
  379. b.Property<uint>("RowVersion")
  380. .IsConcurrencyToken()
  381. .HasColumnType("INTEGER");
  382. b.Property<string>("SubtitleLanguagePreference")
  383. .HasMaxLength(255)
  384. .HasColumnType("TEXT");
  385. b.Property<int>("SubtitleMode")
  386. .HasColumnType("INTEGER");
  387. b.Property<int>("SyncPlayAccess")
  388. .HasColumnType("INTEGER");
  389. b.Property<string>("Username")
  390. .IsRequired()
  391. .HasMaxLength(255)
  392. .HasColumnType("TEXT")
  393. .UseCollation("NOCASE");
  394. b.HasKey("Id");
  395. b.HasIndex("Username")
  396. .IsUnique();
  397. b.ToTable("Users");
  398. });
  399. modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
  400. {
  401. b.HasOne("Jellyfin.Data.Entities.User", null)
  402. .WithMany("AccessSchedules")
  403. .HasForeignKey("UserId")
  404. .OnDelete(DeleteBehavior.Cascade)
  405. .IsRequired();
  406. });
  407. modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
  408. {
  409. b.HasOne("Jellyfin.Data.Entities.User", null)
  410. .WithMany("DisplayPreferences")
  411. .HasForeignKey("UserId")
  412. .OnDelete(DeleteBehavior.Cascade)
  413. .IsRequired();
  414. });
  415. modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
  416. {
  417. b.HasOne("Jellyfin.Data.Entities.DisplayPreferences", null)
  418. .WithMany("HomeSections")
  419. .HasForeignKey("DisplayPreferencesId")
  420. .OnDelete(DeleteBehavior.Cascade)
  421. .IsRequired();
  422. });
  423. modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
  424. {
  425. b.HasOne("Jellyfin.Data.Entities.User", null)
  426. .WithOne("ProfileImage")
  427. .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId")
  428. .OnDelete(DeleteBehavior.Cascade);
  429. });
  430. modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
  431. {
  432. b.HasOne("Jellyfin.Data.Entities.User", null)
  433. .WithMany("ItemDisplayPreferences")
  434. .HasForeignKey("UserId")
  435. .OnDelete(DeleteBehavior.Cascade)
  436. .IsRequired();
  437. });
  438. modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
  439. {
  440. b.HasOne("Jellyfin.Data.Entities.User", null)
  441. .WithMany("Permissions")
  442. .HasForeignKey("UserId")
  443. .OnDelete(DeleteBehavior.Cascade);
  444. });
  445. modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
  446. {
  447. b.HasOne("Jellyfin.Data.Entities.User", null)
  448. .WithMany("Preferences")
  449. .HasForeignKey("UserId")
  450. .OnDelete(DeleteBehavior.Cascade);
  451. });
  452. modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
  453. {
  454. b.HasOne("Jellyfin.Data.Entities.User", "User")
  455. .WithMany()
  456. .HasForeignKey("UserId")
  457. .OnDelete(DeleteBehavior.Cascade)
  458. .IsRequired();
  459. b.Navigation("User");
  460. });
  461. modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
  462. {
  463. b.Navigation("HomeSections");
  464. });
  465. modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
  466. {
  467. b.Navigation("AccessSchedules");
  468. b.Navigation("DisplayPreferences");
  469. b.Navigation("ItemDisplayPreferences");
  470. b.Navigation("Permissions");
  471. b.Navigation("Preferences");
  472. b.Navigation("ProfileImage");
  473. });
  474. #pragma warning restore 612, 618
  475. }
  476. }
  477. }