20240318021959_AdminMessageDismiss.Designer.cs 64 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699
  1. // <auto-generated />
  2. using System;
  3. using Content.Server.Database;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Migrations;
  7. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  8. #nullable disable
  9. namespace Content.Server.Database.Migrations.Sqlite
  10. {
  11. [DbContext(typeof(SqliteServerDbContext))]
  12. [Migration("20240318021959_AdminMessageDismiss")]
  13. partial class AdminMessageDismiss
  14. {
  15. /// <inheritdoc />
  16. protected override void BuildTargetModel(ModelBuilder modelBuilder)
  17. {
  18. #pragma warning disable 612, 618
  19. modelBuilder.HasAnnotation("ProductVersion", "8.0.0");
  20. modelBuilder.Entity("Content.Server.Database.Admin", b =>
  21. {
  22. b.Property<Guid>("UserId")
  23. .ValueGeneratedOnAdd()
  24. .HasColumnType("TEXT")
  25. .HasColumnName("user_id");
  26. b.Property<int?>("AdminRankId")
  27. .HasColumnType("INTEGER")
  28. .HasColumnName("admin_rank_id");
  29. b.Property<string>("Title")
  30. .HasColumnType("TEXT")
  31. .HasColumnName("title");
  32. b.HasKey("UserId")
  33. .HasName("PK_admin");
  34. b.HasIndex("AdminRankId")
  35. .HasDatabaseName("IX_admin_admin_rank_id");
  36. b.ToTable("admin", (string)null);
  37. });
  38. modelBuilder.Entity("Content.Server.Database.AdminFlag", b =>
  39. {
  40. b.Property<int>("Id")
  41. .ValueGeneratedOnAdd()
  42. .HasColumnType("INTEGER")
  43. .HasColumnName("admin_flag_id");
  44. b.Property<Guid>("AdminId")
  45. .HasColumnType("TEXT")
  46. .HasColumnName("admin_id");
  47. b.Property<string>("Flag")
  48. .IsRequired()
  49. .HasColumnType("TEXT")
  50. .HasColumnName("flag");
  51. b.Property<bool>("Negative")
  52. .HasColumnType("INTEGER")
  53. .HasColumnName("negative");
  54. b.HasKey("Id")
  55. .HasName("PK_admin_flag");
  56. b.HasIndex("AdminId")
  57. .HasDatabaseName("IX_admin_flag_admin_id");
  58. b.HasIndex("Flag", "AdminId")
  59. .IsUnique();
  60. b.ToTable("admin_flag", (string)null);
  61. });
  62. modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
  63. {
  64. b.Property<int>("RoundId")
  65. .HasColumnType("INTEGER")
  66. .HasColumnName("round_id");
  67. b.Property<int>("Id")
  68. .HasColumnType("INTEGER")
  69. .HasColumnName("admin_log_id");
  70. b.Property<DateTime>("Date")
  71. .HasColumnType("TEXT")
  72. .HasColumnName("date");
  73. b.Property<sbyte>("Impact")
  74. .HasColumnType("INTEGER")
  75. .HasColumnName("impact");
  76. b.Property<string>("Json")
  77. .IsRequired()
  78. .HasColumnType("jsonb")
  79. .HasColumnName("json");
  80. b.Property<string>("Message")
  81. .IsRequired()
  82. .HasColumnType("TEXT")
  83. .HasColumnName("message");
  84. b.Property<int>("Type")
  85. .HasColumnType("INTEGER")
  86. .HasColumnName("type");
  87. b.HasKey("RoundId", "Id")
  88. .HasName("PK_admin_log");
  89. b.HasIndex("Date");
  90. b.HasIndex("Type")
  91. .HasDatabaseName("IX_admin_log_type");
  92. b.ToTable("admin_log", (string)null);
  93. });
  94. modelBuilder.Entity("Content.Server.Database.AdminLogPlayer", b =>
  95. {
  96. b.Property<int>("RoundId")
  97. .HasColumnType("INTEGER")
  98. .HasColumnName("round_id");
  99. b.Property<int>("LogId")
  100. .HasColumnType("INTEGER")
  101. .HasColumnName("log_id");
  102. b.Property<Guid>("PlayerUserId")
  103. .HasColumnType("TEXT")
  104. .HasColumnName("player_user_id");
  105. b.HasKey("RoundId", "LogId", "PlayerUserId")
  106. .HasName("PK_admin_log_player");
  107. b.HasIndex("PlayerUserId")
  108. .HasDatabaseName("IX_admin_log_player_player_user_id");
  109. b.ToTable("admin_log_player", (string)null);
  110. });
  111. modelBuilder.Entity("Content.Server.Database.AdminMessage", b =>
  112. {
  113. b.Property<int>("Id")
  114. .ValueGeneratedOnAdd()
  115. .HasColumnType("INTEGER")
  116. .HasColumnName("admin_messages_id");
  117. b.Property<DateTime>("CreatedAt")
  118. .HasColumnType("TEXT")
  119. .HasColumnName("created_at");
  120. b.Property<Guid?>("CreatedById")
  121. .HasColumnType("TEXT")
  122. .HasColumnName("created_by_id");
  123. b.Property<bool>("Deleted")
  124. .HasColumnType("INTEGER")
  125. .HasColumnName("deleted");
  126. b.Property<DateTime?>("DeletedAt")
  127. .HasColumnType("TEXT")
  128. .HasColumnName("deleted_at");
  129. b.Property<Guid?>("DeletedById")
  130. .HasColumnType("TEXT")
  131. .HasColumnName("deleted_by_id");
  132. b.Property<bool>("Dismissed")
  133. .HasColumnType("INTEGER")
  134. .HasColumnName("dismissed");
  135. b.Property<DateTime?>("ExpirationTime")
  136. .HasColumnType("TEXT")
  137. .HasColumnName("expiration_time");
  138. b.Property<DateTime?>("LastEditedAt")
  139. .HasColumnType("TEXT")
  140. .HasColumnName("last_edited_at");
  141. b.Property<Guid?>("LastEditedById")
  142. .HasColumnType("TEXT")
  143. .HasColumnName("last_edited_by_id");
  144. b.Property<string>("Message")
  145. .IsRequired()
  146. .HasMaxLength(4096)
  147. .HasColumnType("TEXT")
  148. .HasColumnName("message");
  149. b.Property<Guid?>("PlayerUserId")
  150. .HasColumnType("TEXT")
  151. .HasColumnName("player_user_id");
  152. b.Property<TimeSpan>("PlaytimeAtNote")
  153. .HasColumnType("TEXT")
  154. .HasColumnName("playtime_at_note");
  155. b.Property<int?>("RoundId")
  156. .HasColumnType("INTEGER")
  157. .HasColumnName("round_id");
  158. b.Property<bool>("Seen")
  159. .HasColumnType("INTEGER")
  160. .HasColumnName("seen");
  161. b.HasKey("Id")
  162. .HasName("PK_admin_messages");
  163. b.HasIndex("CreatedById");
  164. b.HasIndex("DeletedById");
  165. b.HasIndex("LastEditedById");
  166. b.HasIndex("PlayerUserId")
  167. .HasDatabaseName("IX_admin_messages_player_user_id");
  168. b.HasIndex("RoundId")
  169. .HasDatabaseName("IX_admin_messages_round_id");
  170. b.ToTable("admin_messages", null, t =>
  171. {
  172. t.HasCheckConstraint("NotDismissedAndSeen", "NOT dismissed OR seen");
  173. });
  174. });
  175. modelBuilder.Entity("Content.Server.Database.AdminNote", b =>
  176. {
  177. b.Property<int>("Id")
  178. .ValueGeneratedOnAdd()
  179. .HasColumnType("INTEGER")
  180. .HasColumnName("admin_notes_id");
  181. b.Property<DateTime>("CreatedAt")
  182. .HasColumnType("TEXT")
  183. .HasColumnName("created_at");
  184. b.Property<Guid?>("CreatedById")
  185. .HasColumnType("TEXT")
  186. .HasColumnName("created_by_id");
  187. b.Property<bool>("Deleted")
  188. .HasColumnType("INTEGER")
  189. .HasColumnName("deleted");
  190. b.Property<DateTime?>("DeletedAt")
  191. .HasColumnType("TEXT")
  192. .HasColumnName("deleted_at");
  193. b.Property<Guid?>("DeletedById")
  194. .HasColumnType("TEXT")
  195. .HasColumnName("deleted_by_id");
  196. b.Property<DateTime?>("ExpirationTime")
  197. .HasColumnType("TEXT")
  198. .HasColumnName("expiration_time");
  199. b.Property<DateTime?>("LastEditedAt")
  200. .IsRequired()
  201. .HasColumnType("TEXT")
  202. .HasColumnName("last_edited_at");
  203. b.Property<Guid?>("LastEditedById")
  204. .HasColumnType("TEXT")
  205. .HasColumnName("last_edited_by_id");
  206. b.Property<string>("Message")
  207. .IsRequired()
  208. .HasMaxLength(4096)
  209. .HasColumnType("TEXT")
  210. .HasColumnName("message");
  211. b.Property<Guid?>("PlayerUserId")
  212. .HasColumnType("TEXT")
  213. .HasColumnName("player_user_id");
  214. b.Property<TimeSpan>("PlaytimeAtNote")
  215. .HasColumnType("TEXT")
  216. .HasColumnName("playtime_at_note");
  217. b.Property<int?>("RoundId")
  218. .HasColumnType("INTEGER")
  219. .HasColumnName("round_id");
  220. b.Property<bool>("Secret")
  221. .HasColumnType("INTEGER")
  222. .HasColumnName("secret");
  223. b.Property<int>("Severity")
  224. .HasColumnType("INTEGER")
  225. .HasColumnName("severity");
  226. b.HasKey("Id")
  227. .HasName("PK_admin_notes");
  228. b.HasIndex("CreatedById");
  229. b.HasIndex("DeletedById");
  230. b.HasIndex("LastEditedById");
  231. b.HasIndex("PlayerUserId")
  232. .HasDatabaseName("IX_admin_notes_player_user_id");
  233. b.HasIndex("RoundId")
  234. .HasDatabaseName("IX_admin_notes_round_id");
  235. b.ToTable("admin_notes", (string)null);
  236. });
  237. modelBuilder.Entity("Content.Server.Database.AdminRank", b =>
  238. {
  239. b.Property<int>("Id")
  240. .ValueGeneratedOnAdd()
  241. .HasColumnType("INTEGER")
  242. .HasColumnName("admin_rank_id");
  243. b.Property<string>("Name")
  244. .IsRequired()
  245. .HasColumnType("TEXT")
  246. .HasColumnName("name");
  247. b.HasKey("Id")
  248. .HasName("PK_admin_rank");
  249. b.ToTable("admin_rank", (string)null);
  250. });
  251. modelBuilder.Entity("Content.Server.Database.AdminRankFlag", b =>
  252. {
  253. b.Property<int>("Id")
  254. .ValueGeneratedOnAdd()
  255. .HasColumnType("INTEGER")
  256. .HasColumnName("admin_rank_flag_id");
  257. b.Property<int>("AdminRankId")
  258. .HasColumnType("INTEGER")
  259. .HasColumnName("admin_rank_id");
  260. b.Property<string>("Flag")
  261. .IsRequired()
  262. .HasColumnType("TEXT")
  263. .HasColumnName("flag");
  264. b.HasKey("Id")
  265. .HasName("PK_admin_rank_flag");
  266. b.HasIndex("AdminRankId");
  267. b.HasIndex("Flag", "AdminRankId")
  268. .IsUnique();
  269. b.ToTable("admin_rank_flag", (string)null);
  270. });
  271. modelBuilder.Entity("Content.Server.Database.AdminWatchlist", b =>
  272. {
  273. b.Property<int>("Id")
  274. .ValueGeneratedOnAdd()
  275. .HasColumnType("INTEGER")
  276. .HasColumnName("admin_watchlists_id");
  277. b.Property<DateTime>("CreatedAt")
  278. .HasColumnType("TEXT")
  279. .HasColumnName("created_at");
  280. b.Property<Guid?>("CreatedById")
  281. .HasColumnType("TEXT")
  282. .HasColumnName("created_by_id");
  283. b.Property<bool>("Deleted")
  284. .HasColumnType("INTEGER")
  285. .HasColumnName("deleted");
  286. b.Property<DateTime?>("DeletedAt")
  287. .HasColumnType("TEXT")
  288. .HasColumnName("deleted_at");
  289. b.Property<Guid?>("DeletedById")
  290. .HasColumnType("TEXT")
  291. .HasColumnName("deleted_by_id");
  292. b.Property<DateTime?>("ExpirationTime")
  293. .HasColumnType("TEXT")
  294. .HasColumnName("expiration_time");
  295. b.Property<DateTime?>("LastEditedAt")
  296. .IsRequired()
  297. .HasColumnType("TEXT")
  298. .HasColumnName("last_edited_at");
  299. b.Property<Guid?>("LastEditedById")
  300. .HasColumnType("TEXT")
  301. .HasColumnName("last_edited_by_id");
  302. b.Property<string>("Message")
  303. .IsRequired()
  304. .HasMaxLength(4096)
  305. .HasColumnType("TEXT")
  306. .HasColumnName("message");
  307. b.Property<Guid?>("PlayerUserId")
  308. .HasColumnType("TEXT")
  309. .HasColumnName("player_user_id");
  310. b.Property<TimeSpan>("PlaytimeAtNote")
  311. .HasColumnType("TEXT")
  312. .HasColumnName("playtime_at_note");
  313. b.Property<int?>("RoundId")
  314. .HasColumnType("INTEGER")
  315. .HasColumnName("round_id");
  316. b.HasKey("Id")
  317. .HasName("PK_admin_watchlists");
  318. b.HasIndex("CreatedById");
  319. b.HasIndex("DeletedById");
  320. b.HasIndex("LastEditedById");
  321. b.HasIndex("PlayerUserId")
  322. .HasDatabaseName("IX_admin_watchlists_player_user_id");
  323. b.HasIndex("RoundId")
  324. .HasDatabaseName("IX_admin_watchlists_round_id");
  325. b.ToTable("admin_watchlists", (string)null);
  326. });
  327. modelBuilder.Entity("Content.Server.Database.Antag", b =>
  328. {
  329. b.Property<int>("Id")
  330. .ValueGeneratedOnAdd()
  331. .HasColumnType("INTEGER")
  332. .HasColumnName("antag_id");
  333. b.Property<string>("AntagName")
  334. .IsRequired()
  335. .HasColumnType("TEXT")
  336. .HasColumnName("antag_name");
  337. b.Property<int>("ProfileId")
  338. .HasColumnType("INTEGER")
  339. .HasColumnName("profile_id");
  340. b.HasKey("Id")
  341. .HasName("PK_antag");
  342. b.HasIndex("ProfileId", "AntagName")
  343. .IsUnique();
  344. b.ToTable("antag", (string)null);
  345. });
  346. modelBuilder.Entity("Content.Server.Database.AssignedUserId", b =>
  347. {
  348. b.Property<int>("Id")
  349. .ValueGeneratedOnAdd()
  350. .HasColumnType("INTEGER")
  351. .HasColumnName("assigned_user_id_id");
  352. b.Property<Guid>("UserId")
  353. .HasColumnType("TEXT")
  354. .HasColumnName("user_id");
  355. b.Property<string>("UserName")
  356. .IsRequired()
  357. .HasColumnType("TEXT")
  358. .HasColumnName("user_name");
  359. b.HasKey("Id")
  360. .HasName("PK_assigned_user_id");
  361. b.HasIndex("UserId")
  362. .IsUnique();
  363. b.HasIndex("UserName")
  364. .IsUnique();
  365. b.ToTable("assigned_user_id", (string)null);
  366. });
  367. modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
  368. {
  369. b.Property<int>("Id")
  370. .ValueGeneratedOnAdd()
  371. .HasColumnType("INTEGER")
  372. .HasColumnName("connection_log_id");
  373. b.Property<string>("Address")
  374. .IsRequired()
  375. .HasColumnType("TEXT")
  376. .HasColumnName("address");
  377. b.Property<byte?>("Denied")
  378. .HasColumnType("INTEGER")
  379. .HasColumnName("denied");
  380. b.Property<byte[]>("HWId")
  381. .HasColumnType("BLOB")
  382. .HasColumnName("hwid");
  383. b.Property<int>("ServerId")
  384. .ValueGeneratedOnAdd()
  385. .HasColumnType("INTEGER")
  386. .HasDefaultValue(0)
  387. .HasColumnName("server_id");
  388. b.Property<DateTime>("Time")
  389. .HasColumnType("TEXT")
  390. .HasColumnName("time");
  391. b.Property<Guid>("UserId")
  392. .HasColumnType("TEXT")
  393. .HasColumnName("user_id");
  394. b.Property<string>("UserName")
  395. .IsRequired()
  396. .HasColumnType("TEXT")
  397. .HasColumnName("user_name");
  398. b.HasKey("Id")
  399. .HasName("PK_connection_log");
  400. b.HasIndex("ServerId")
  401. .HasDatabaseName("IX_connection_log_server_id");
  402. b.HasIndex("UserId");
  403. b.ToTable("connection_log", (string)null);
  404. });
  405. modelBuilder.Entity("Content.Server.Database.Job", b =>
  406. {
  407. b.Property<int>("Id")
  408. .ValueGeneratedOnAdd()
  409. .HasColumnType("INTEGER")
  410. .HasColumnName("job_id");
  411. b.Property<string>("JobName")
  412. .IsRequired()
  413. .HasColumnType("TEXT")
  414. .HasColumnName("job_name");
  415. b.Property<int>("Priority")
  416. .HasColumnType("INTEGER")
  417. .HasColumnName("priority");
  418. b.Property<int>("ProfileId")
  419. .HasColumnType("INTEGER")
  420. .HasColumnName("profile_id");
  421. b.HasKey("Id")
  422. .HasName("PK_job");
  423. b.HasIndex("ProfileId");
  424. b.HasIndex("ProfileId", "JobName")
  425. .IsUnique();
  426. b.HasIndex(new[] { "ProfileId" }, "IX_job_one_high_priority")
  427. .IsUnique()
  428. .HasFilter("priority = 3");
  429. b.ToTable("job", (string)null);
  430. });
  431. modelBuilder.Entity("Content.Server.Database.PlayTime", b =>
  432. {
  433. b.Property<int>("Id")
  434. .ValueGeneratedOnAdd()
  435. .HasColumnType("INTEGER")
  436. .HasColumnName("play_time_id");
  437. b.Property<Guid>("PlayerId")
  438. .HasColumnType("TEXT")
  439. .HasColumnName("player_id");
  440. b.Property<TimeSpan>("TimeSpent")
  441. .HasColumnType("TEXT")
  442. .HasColumnName("time_spent");
  443. b.Property<string>("Tracker")
  444. .IsRequired()
  445. .HasColumnType("TEXT")
  446. .HasColumnName("tracker");
  447. b.HasKey("Id")
  448. .HasName("PK_play_time");
  449. b.HasIndex("PlayerId", "Tracker")
  450. .IsUnique();
  451. b.ToTable("play_time", (string)null);
  452. });
  453. modelBuilder.Entity("Content.Server.Database.Player", b =>
  454. {
  455. b.Property<int>("Id")
  456. .ValueGeneratedOnAdd()
  457. .HasColumnType("INTEGER")
  458. .HasColumnName("player_id");
  459. b.Property<DateTime>("FirstSeenTime")
  460. .HasColumnType("TEXT")
  461. .HasColumnName("first_seen_time");
  462. b.Property<DateTime?>("LastReadRules")
  463. .HasColumnType("TEXT")
  464. .HasColumnName("last_read_rules");
  465. b.Property<string>("LastSeenAddress")
  466. .IsRequired()
  467. .HasColumnType("TEXT")
  468. .HasColumnName("last_seen_address");
  469. b.Property<byte[]>("LastSeenHWId")
  470. .HasColumnType("BLOB")
  471. .HasColumnName("last_seen_hwid");
  472. b.Property<DateTime>("LastSeenTime")
  473. .HasColumnType("TEXT")
  474. .HasColumnName("last_seen_time");
  475. b.Property<string>("LastSeenUserName")
  476. .IsRequired()
  477. .HasColumnType("TEXT")
  478. .HasColumnName("last_seen_user_name");
  479. b.Property<Guid>("UserId")
  480. .HasColumnType("TEXT")
  481. .HasColumnName("user_id");
  482. b.HasKey("Id")
  483. .HasName("PK_player");
  484. b.HasAlternateKey("UserId")
  485. .HasName("ak_player_user_id");
  486. b.HasIndex("LastSeenUserName");
  487. b.HasIndex("UserId")
  488. .IsUnique();
  489. b.ToTable("player", (string)null);
  490. });
  491. modelBuilder.Entity("Content.Server.Database.Preference", b =>
  492. {
  493. b.Property<int>("Id")
  494. .ValueGeneratedOnAdd()
  495. .HasColumnType("INTEGER")
  496. .HasColumnName("preference_id");
  497. b.Property<string>("AdminOOCColor")
  498. .IsRequired()
  499. .HasColumnType("TEXT")
  500. .HasColumnName("admin_ooc_color");
  501. b.Property<int>("SelectedCharacterSlot")
  502. .HasColumnType("INTEGER")
  503. .HasColumnName("selected_character_slot");
  504. b.Property<Guid>("UserId")
  505. .HasColumnType("TEXT")
  506. .HasColumnName("user_id");
  507. b.HasKey("Id")
  508. .HasName("PK_preference");
  509. b.HasIndex("UserId")
  510. .IsUnique();
  511. b.ToTable("preference", (string)null);
  512. });
  513. modelBuilder.Entity("Content.Server.Database.Profile", b =>
  514. {
  515. b.Property<int>("Id")
  516. .ValueGeneratedOnAdd()
  517. .HasColumnType("INTEGER")
  518. .HasColumnName("profile_id");
  519. b.Property<int>("Age")
  520. .HasColumnType("INTEGER")
  521. .HasColumnName("age");
  522. b.Property<string>("Backpack")
  523. .IsRequired()
  524. .HasColumnType("TEXT")
  525. .HasColumnName("backpack");
  526. b.Property<string>("CharacterName")
  527. .IsRequired()
  528. .HasColumnType("TEXT")
  529. .HasColumnName("char_name");
  530. b.Property<string>("Clothing")
  531. .IsRequired()
  532. .HasColumnType("TEXT")
  533. .HasColumnName("clothing");
  534. b.Property<string>("EyeColor")
  535. .IsRequired()
  536. .HasColumnType("TEXT")
  537. .HasColumnName("eye_color");
  538. b.Property<string>("FacialHairColor")
  539. .IsRequired()
  540. .HasColumnType("TEXT")
  541. .HasColumnName("facial_hair_color");
  542. b.Property<string>("FacialHairName")
  543. .IsRequired()
  544. .HasColumnType("TEXT")
  545. .HasColumnName("facial_hair_name");
  546. b.Property<string>("FlavorText")
  547. .IsRequired()
  548. .HasColumnType("TEXT")
  549. .HasColumnName("flavor_text");
  550. b.Property<string>("Gender")
  551. .IsRequired()
  552. .HasColumnType("TEXT")
  553. .HasColumnName("gender");
  554. b.Property<string>("HairColor")
  555. .IsRequired()
  556. .HasColumnType("TEXT")
  557. .HasColumnName("hair_color");
  558. b.Property<string>("HairName")
  559. .IsRequired()
  560. .HasColumnType("TEXT")
  561. .HasColumnName("hair_name");
  562. b.Property<byte[]>("Markings")
  563. .HasColumnType("jsonb")
  564. .HasColumnName("markings");
  565. b.Property<int>("PreferenceId")
  566. .HasColumnType("INTEGER")
  567. .HasColumnName("preference_id");
  568. b.Property<int>("PreferenceUnavailable")
  569. .HasColumnType("INTEGER")
  570. .HasColumnName("pref_unavailable");
  571. b.Property<string>("Sex")
  572. .IsRequired()
  573. .HasColumnType("TEXT")
  574. .HasColumnName("sex");
  575. b.Property<string>("SkinColor")
  576. .IsRequired()
  577. .HasColumnType("TEXT")
  578. .HasColumnName("skin_color");
  579. b.Property<int>("Slot")
  580. .HasColumnType("INTEGER")
  581. .HasColumnName("slot");
  582. b.Property<int>("SpawnPriority")
  583. .HasColumnType("INTEGER")
  584. .HasColumnName("spawn_priority");
  585. b.Property<string>("Species")
  586. .IsRequired()
  587. .HasColumnType("TEXT")
  588. .HasColumnName("species");
  589. b.HasKey("Id")
  590. .HasName("PK_profile");
  591. b.HasIndex("PreferenceId")
  592. .HasDatabaseName("IX_profile_preference_id");
  593. b.HasIndex("Slot", "PreferenceId")
  594. .IsUnique();
  595. b.ToTable("profile", (string)null);
  596. });
  597. modelBuilder.Entity("Content.Server.Database.Round", b =>
  598. {
  599. b.Property<int>("Id")
  600. .ValueGeneratedOnAdd()
  601. .HasColumnType("INTEGER")
  602. .HasColumnName("round_id");
  603. b.Property<int>("ServerId")
  604. .HasColumnType("INTEGER")
  605. .HasColumnName("server_id");
  606. b.Property<DateTime>("StartDate")
  607. .ValueGeneratedOnAdd()
  608. .HasColumnType("TEXT")
  609. .HasDefaultValue(new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified))
  610. .HasColumnName("start_date");
  611. b.HasKey("Id")
  612. .HasName("PK_round");
  613. b.HasIndex("ServerId")
  614. .HasDatabaseName("IX_round_server_id");
  615. b.HasIndex("StartDate");
  616. b.ToTable("round", (string)null);
  617. });
  618. modelBuilder.Entity("Content.Server.Database.Server", b =>
  619. {
  620. b.Property<int>("Id")
  621. .ValueGeneratedOnAdd()
  622. .HasColumnType("INTEGER")
  623. .HasColumnName("server_id");
  624. b.Property<string>("Name")
  625. .IsRequired()
  626. .HasColumnType("TEXT")
  627. .HasColumnName("name");
  628. b.HasKey("Id")
  629. .HasName("PK_server");
  630. b.ToTable("server", (string)null);
  631. });
  632. modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
  633. {
  634. b.Property<int>("Id")
  635. .ValueGeneratedOnAdd()
  636. .HasColumnType("INTEGER")
  637. .HasColumnName("server_ban_id");
  638. b.Property<string>("Address")
  639. .HasColumnType("TEXT")
  640. .HasColumnName("address");
  641. b.Property<bool>("AutoDelete")
  642. .HasColumnType("INTEGER")
  643. .HasColumnName("auto_delete");
  644. b.Property<DateTime>("BanTime")
  645. .HasColumnType("TEXT")
  646. .HasColumnName("ban_time");
  647. b.Property<Guid?>("BanningAdmin")
  648. .HasColumnType("TEXT")
  649. .HasColumnName("banning_admin");
  650. b.Property<int>("ExemptFlags")
  651. .HasColumnType("INTEGER")
  652. .HasColumnName("exempt_flags");
  653. b.Property<DateTime?>("ExpirationTime")
  654. .HasColumnType("TEXT")
  655. .HasColumnName("expiration_time");
  656. b.Property<byte[]>("HWId")
  657. .HasColumnType("BLOB")
  658. .HasColumnName("hwid");
  659. b.Property<bool>("Hidden")
  660. .HasColumnType("INTEGER")
  661. .HasColumnName("hidden");
  662. b.Property<DateTime?>("LastEditedAt")
  663. .HasColumnType("TEXT")
  664. .HasColumnName("last_edited_at");
  665. b.Property<Guid?>("LastEditedById")
  666. .HasColumnType("TEXT")
  667. .HasColumnName("last_edited_by_id");
  668. b.Property<Guid?>("PlayerUserId")
  669. .HasColumnType("TEXT")
  670. .HasColumnName("player_user_id");
  671. b.Property<TimeSpan>("PlaytimeAtNote")
  672. .HasColumnType("TEXT")
  673. .HasColumnName("playtime_at_note");
  674. b.Property<string>("Reason")
  675. .IsRequired()
  676. .HasColumnType("TEXT")
  677. .HasColumnName("reason");
  678. b.Property<int?>("RoundId")
  679. .HasColumnType("INTEGER")
  680. .HasColumnName("round_id");
  681. b.Property<int>("Severity")
  682. .HasColumnType("INTEGER")
  683. .HasColumnName("severity");
  684. b.HasKey("Id")
  685. .HasName("PK_server_ban");
  686. b.HasIndex("Address");
  687. b.HasIndex("BanningAdmin");
  688. b.HasIndex("LastEditedById");
  689. b.HasIndex("PlayerUserId")
  690. .HasDatabaseName("IX_server_ban_player_user_id");
  691. b.HasIndex("RoundId")
  692. .HasDatabaseName("IX_server_ban_round_id");
  693. b.ToTable("server_ban", null, t =>
  694. {
  695. t.HasCheckConstraint("HaveEitherAddressOrUserIdOrHWId", "address IS NOT NULL OR player_user_id IS NOT NULL OR hwid IS NOT NULL");
  696. });
  697. });
  698. modelBuilder.Entity("Content.Server.Database.ServerBanExemption", b =>
  699. {
  700. b.Property<Guid>("UserId")
  701. .ValueGeneratedOnAdd()
  702. .HasColumnType("TEXT")
  703. .HasColumnName("user_id");
  704. b.Property<int>("Flags")
  705. .HasColumnType("INTEGER")
  706. .HasColumnName("flags");
  707. b.HasKey("UserId")
  708. .HasName("PK_server_ban_exemption");
  709. b.ToTable("server_ban_exemption", null, t =>
  710. {
  711. t.HasCheckConstraint("FlagsNotZero", "flags != 0");
  712. });
  713. });
  714. modelBuilder.Entity("Content.Server.Database.ServerBanHit", b =>
  715. {
  716. b.Property<int>("Id")
  717. .ValueGeneratedOnAdd()
  718. .HasColumnType("INTEGER")
  719. .HasColumnName("server_ban_hit_id");
  720. b.Property<int>("BanId")
  721. .HasColumnType("INTEGER")
  722. .HasColumnName("ban_id");
  723. b.Property<int>("ConnectionId")
  724. .HasColumnType("INTEGER")
  725. .HasColumnName("connection_id");
  726. b.HasKey("Id")
  727. .HasName("PK_server_ban_hit");
  728. b.HasIndex("BanId")
  729. .HasDatabaseName("IX_server_ban_hit_ban_id");
  730. b.HasIndex("ConnectionId")
  731. .HasDatabaseName("IX_server_ban_hit_connection_id");
  732. b.ToTable("server_ban_hit", (string)null);
  733. });
  734. modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
  735. {
  736. b.Property<int>("Id")
  737. .ValueGeneratedOnAdd()
  738. .HasColumnType("INTEGER")
  739. .HasColumnName("server_role_ban_id");
  740. b.Property<string>("Address")
  741. .HasColumnType("TEXT")
  742. .HasColumnName("address");
  743. b.Property<DateTime>("BanTime")
  744. .HasColumnType("TEXT")
  745. .HasColumnName("ban_time");
  746. b.Property<Guid?>("BanningAdmin")
  747. .HasColumnType("TEXT")
  748. .HasColumnName("banning_admin");
  749. b.Property<DateTime?>("ExpirationTime")
  750. .HasColumnType("TEXT")
  751. .HasColumnName("expiration_time");
  752. b.Property<byte[]>("HWId")
  753. .HasColumnType("BLOB")
  754. .HasColumnName("hwid");
  755. b.Property<bool>("Hidden")
  756. .HasColumnType("INTEGER")
  757. .HasColumnName("hidden");
  758. b.Property<DateTime?>("LastEditedAt")
  759. .HasColumnType("TEXT")
  760. .HasColumnName("last_edited_at");
  761. b.Property<Guid?>("LastEditedById")
  762. .HasColumnType("TEXT")
  763. .HasColumnName("last_edited_by_id");
  764. b.Property<Guid?>("PlayerUserId")
  765. .HasColumnType("TEXT")
  766. .HasColumnName("player_user_id");
  767. b.Property<TimeSpan>("PlaytimeAtNote")
  768. .HasColumnType("TEXT")
  769. .HasColumnName("playtime_at_note");
  770. b.Property<string>("Reason")
  771. .IsRequired()
  772. .HasColumnType("TEXT")
  773. .HasColumnName("reason");
  774. b.Property<string>("RoleId")
  775. .IsRequired()
  776. .HasColumnType("TEXT")
  777. .HasColumnName("role_id");
  778. b.Property<int?>("RoundId")
  779. .HasColumnType("INTEGER")
  780. .HasColumnName("round_id");
  781. b.Property<int>("Severity")
  782. .HasColumnType("INTEGER")
  783. .HasColumnName("severity");
  784. b.HasKey("Id")
  785. .HasName("PK_server_role_ban");
  786. b.HasIndex("Address");
  787. b.HasIndex("BanningAdmin");
  788. b.HasIndex("LastEditedById");
  789. b.HasIndex("PlayerUserId")
  790. .HasDatabaseName("IX_server_role_ban_player_user_id");
  791. b.HasIndex("RoundId")
  792. .HasDatabaseName("IX_server_role_ban_round_id");
  793. b.ToTable("server_role_ban", null, t =>
  794. {
  795. t.HasCheckConstraint("HaveEitherAddressOrUserIdOrHWId", "address IS NOT NULL OR player_user_id IS NOT NULL OR hwid IS NOT NULL");
  796. });
  797. });
  798. modelBuilder.Entity("Content.Server.Database.ServerRoleUnban", b =>
  799. {
  800. b.Property<int>("Id")
  801. .ValueGeneratedOnAdd()
  802. .HasColumnType("INTEGER")
  803. .HasColumnName("role_unban_id");
  804. b.Property<int>("BanId")
  805. .HasColumnType("INTEGER")
  806. .HasColumnName("ban_id");
  807. b.Property<DateTime>("UnbanTime")
  808. .HasColumnType("TEXT")
  809. .HasColumnName("unban_time");
  810. b.Property<Guid?>("UnbanningAdmin")
  811. .HasColumnType("TEXT")
  812. .HasColumnName("unbanning_admin");
  813. b.HasKey("Id")
  814. .HasName("PK_server_role_unban");
  815. b.HasIndex("BanId")
  816. .IsUnique();
  817. b.ToTable("server_role_unban", (string)null);
  818. });
  819. modelBuilder.Entity("Content.Server.Database.ServerUnban", b =>
  820. {
  821. b.Property<int>("Id")
  822. .ValueGeneratedOnAdd()
  823. .HasColumnType("INTEGER")
  824. .HasColumnName("unban_id");
  825. b.Property<int>("BanId")
  826. .HasColumnType("INTEGER")
  827. .HasColumnName("ban_id");
  828. b.Property<DateTime>("UnbanTime")
  829. .HasColumnType("TEXT")
  830. .HasColumnName("unban_time");
  831. b.Property<Guid?>("UnbanningAdmin")
  832. .HasColumnType("TEXT")
  833. .HasColumnName("unbanning_admin");
  834. b.HasKey("Id")
  835. .HasName("PK_server_unban");
  836. b.HasIndex("BanId")
  837. .IsUnique();
  838. b.ToTable("server_unban", (string)null);
  839. });
  840. modelBuilder.Entity("Content.Server.Database.Trait", b =>
  841. {
  842. b.Property<int>("Id")
  843. .ValueGeneratedOnAdd()
  844. .HasColumnType("INTEGER")
  845. .HasColumnName("trait_id");
  846. b.Property<int>("ProfileId")
  847. .HasColumnType("INTEGER")
  848. .HasColumnName("profile_id");
  849. b.Property<string>("TraitName")
  850. .IsRequired()
  851. .HasColumnType("TEXT")
  852. .HasColumnName("trait_name");
  853. b.HasKey("Id")
  854. .HasName("PK_trait");
  855. b.HasIndex("ProfileId", "TraitName")
  856. .IsUnique();
  857. b.ToTable("trait", (string)null);
  858. });
  859. modelBuilder.Entity("Content.Server.Database.UploadedResourceLog", b =>
  860. {
  861. b.Property<int>("Id")
  862. .ValueGeneratedOnAdd()
  863. .HasColumnType("INTEGER")
  864. .HasColumnName("uploaded_resource_log_id");
  865. b.Property<byte[]>("Data")
  866. .IsRequired()
  867. .HasColumnType("BLOB")
  868. .HasColumnName("data");
  869. b.Property<DateTime>("Date")
  870. .HasColumnType("TEXT")
  871. .HasColumnName("date");
  872. b.Property<string>("Path")
  873. .IsRequired()
  874. .HasColumnType("TEXT")
  875. .HasColumnName("path");
  876. b.Property<Guid>("UserId")
  877. .HasColumnType("TEXT")
  878. .HasColumnName("user_id");
  879. b.HasKey("Id")
  880. .HasName("PK_uploaded_resource_log");
  881. b.ToTable("uploaded_resource_log", (string)null);
  882. });
  883. modelBuilder.Entity("Content.Server.Database.Whitelist", b =>
  884. {
  885. b.Property<Guid>("UserId")
  886. .ValueGeneratedOnAdd()
  887. .HasColumnType("TEXT")
  888. .HasColumnName("user_id");
  889. b.HasKey("UserId")
  890. .HasName("PK_whitelist");
  891. b.ToTable("whitelist", (string)null);
  892. });
  893. modelBuilder.Entity("PlayerRound", b =>
  894. {
  895. b.Property<int>("PlayersId")
  896. .HasColumnType("INTEGER")
  897. .HasColumnName("players_id");
  898. b.Property<int>("RoundsId")
  899. .HasColumnType("INTEGER")
  900. .HasColumnName("rounds_id");
  901. b.HasKey("PlayersId", "RoundsId")
  902. .HasName("PK_player_round");
  903. b.HasIndex("RoundsId")
  904. .HasDatabaseName("IX_player_round_rounds_id");
  905. b.ToTable("player_round", (string)null);
  906. });
  907. modelBuilder.Entity("Content.Server.Database.Admin", b =>
  908. {
  909. b.HasOne("Content.Server.Database.AdminRank", "AdminRank")
  910. .WithMany("Admins")
  911. .HasForeignKey("AdminRankId")
  912. .OnDelete(DeleteBehavior.SetNull)
  913. .HasConstraintName("FK_admin_admin_rank_admin_rank_id");
  914. b.Navigation("AdminRank");
  915. });
  916. modelBuilder.Entity("Content.Server.Database.AdminFlag", b =>
  917. {
  918. b.HasOne("Content.Server.Database.Admin", "Admin")
  919. .WithMany("Flags")
  920. .HasForeignKey("AdminId")
  921. .OnDelete(DeleteBehavior.Cascade)
  922. .IsRequired()
  923. .HasConstraintName("FK_admin_flag_admin_admin_id");
  924. b.Navigation("Admin");
  925. });
  926. modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
  927. {
  928. b.HasOne("Content.Server.Database.Round", "Round")
  929. .WithMany("AdminLogs")
  930. .HasForeignKey("RoundId")
  931. .OnDelete(DeleteBehavior.Cascade)
  932. .IsRequired()
  933. .HasConstraintName("FK_admin_log_round_round_id");
  934. b.Navigation("Round");
  935. });
  936. modelBuilder.Entity("Content.Server.Database.AdminLogPlayer", b =>
  937. {
  938. b.HasOne("Content.Server.Database.Player", "Player")
  939. .WithMany("AdminLogs")
  940. .HasForeignKey("PlayerUserId")
  941. .HasPrincipalKey("UserId")
  942. .OnDelete(DeleteBehavior.Cascade)
  943. .IsRequired()
  944. .HasConstraintName("FK_admin_log_player_player_player_user_id");
  945. b.HasOne("Content.Server.Database.AdminLog", "Log")
  946. .WithMany("Players")
  947. .HasForeignKey("RoundId", "LogId")
  948. .OnDelete(DeleteBehavior.Cascade)
  949. .IsRequired()
  950. .HasConstraintName("FK_admin_log_player_admin_log_round_id_log_id");
  951. b.Navigation("Log");
  952. b.Navigation("Player");
  953. });
  954. modelBuilder.Entity("Content.Server.Database.AdminMessage", b =>
  955. {
  956. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  957. .WithMany("AdminMessagesCreated")
  958. .HasForeignKey("CreatedById")
  959. .HasPrincipalKey("UserId")
  960. .OnDelete(DeleteBehavior.SetNull)
  961. .HasConstraintName("FK_admin_messages_player_created_by_id");
  962. b.HasOne("Content.Server.Database.Player", "DeletedBy")
  963. .WithMany("AdminMessagesDeleted")
  964. .HasForeignKey("DeletedById")
  965. .HasPrincipalKey("UserId")
  966. .OnDelete(DeleteBehavior.SetNull)
  967. .HasConstraintName("FK_admin_messages_player_deleted_by_id");
  968. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  969. .WithMany("AdminMessagesLastEdited")
  970. .HasForeignKey("LastEditedById")
  971. .HasPrincipalKey("UserId")
  972. .OnDelete(DeleteBehavior.SetNull)
  973. .HasConstraintName("FK_admin_messages_player_last_edited_by_id");
  974. b.HasOne("Content.Server.Database.Player", "Player")
  975. .WithMany("AdminMessagesReceived")
  976. .HasForeignKey("PlayerUserId")
  977. .HasPrincipalKey("UserId")
  978. .OnDelete(DeleteBehavior.Cascade)
  979. .HasConstraintName("FK_admin_messages_player_player_user_id");
  980. b.HasOne("Content.Server.Database.Round", "Round")
  981. .WithMany()
  982. .HasForeignKey("RoundId")
  983. .HasConstraintName("FK_admin_messages_round_round_id");
  984. b.Navigation("CreatedBy");
  985. b.Navigation("DeletedBy");
  986. b.Navigation("LastEditedBy");
  987. b.Navigation("Player");
  988. b.Navigation("Round");
  989. });
  990. modelBuilder.Entity("Content.Server.Database.AdminNote", b =>
  991. {
  992. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  993. .WithMany("AdminNotesCreated")
  994. .HasForeignKey("CreatedById")
  995. .HasPrincipalKey("UserId")
  996. .OnDelete(DeleteBehavior.SetNull)
  997. .HasConstraintName("FK_admin_notes_player_created_by_id");
  998. b.HasOne("Content.Server.Database.Player", "DeletedBy")
  999. .WithMany("AdminNotesDeleted")
  1000. .HasForeignKey("DeletedById")
  1001. .HasPrincipalKey("UserId")
  1002. .OnDelete(DeleteBehavior.SetNull)
  1003. .HasConstraintName("FK_admin_notes_player_deleted_by_id");
  1004. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1005. .WithMany("AdminNotesLastEdited")
  1006. .HasForeignKey("LastEditedById")
  1007. .HasPrincipalKey("UserId")
  1008. .OnDelete(DeleteBehavior.SetNull)
  1009. .HasConstraintName("FK_admin_notes_player_last_edited_by_id");
  1010. b.HasOne("Content.Server.Database.Player", "Player")
  1011. .WithMany("AdminNotesReceived")
  1012. .HasForeignKey("PlayerUserId")
  1013. .HasPrincipalKey("UserId")
  1014. .OnDelete(DeleteBehavior.Cascade)
  1015. .HasConstraintName("FK_admin_notes_player_player_user_id");
  1016. b.HasOne("Content.Server.Database.Round", "Round")
  1017. .WithMany()
  1018. .HasForeignKey("RoundId")
  1019. .HasConstraintName("FK_admin_notes_round_round_id");
  1020. b.Navigation("CreatedBy");
  1021. b.Navigation("DeletedBy");
  1022. b.Navigation("LastEditedBy");
  1023. b.Navigation("Player");
  1024. b.Navigation("Round");
  1025. });
  1026. modelBuilder.Entity("Content.Server.Database.AdminRankFlag", b =>
  1027. {
  1028. b.HasOne("Content.Server.Database.AdminRank", "Rank")
  1029. .WithMany("Flags")
  1030. .HasForeignKey("AdminRankId")
  1031. .OnDelete(DeleteBehavior.Cascade)
  1032. .IsRequired()
  1033. .HasConstraintName("FK_admin_rank_flag_admin_rank_admin_rank_id");
  1034. b.Navigation("Rank");
  1035. });
  1036. modelBuilder.Entity("Content.Server.Database.AdminWatchlist", b =>
  1037. {
  1038. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1039. .WithMany("AdminWatchlistsCreated")
  1040. .HasForeignKey("CreatedById")
  1041. .HasPrincipalKey("UserId")
  1042. .OnDelete(DeleteBehavior.SetNull)
  1043. .HasConstraintName("FK_admin_watchlists_player_created_by_id");
  1044. b.HasOne("Content.Server.Database.Player", "DeletedBy")
  1045. .WithMany("AdminWatchlistsDeleted")
  1046. .HasForeignKey("DeletedById")
  1047. .HasPrincipalKey("UserId")
  1048. .OnDelete(DeleteBehavior.SetNull)
  1049. .HasConstraintName("FK_admin_watchlists_player_deleted_by_id");
  1050. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1051. .WithMany("AdminWatchlistsLastEdited")
  1052. .HasForeignKey("LastEditedById")
  1053. .HasPrincipalKey("UserId")
  1054. .OnDelete(DeleteBehavior.SetNull)
  1055. .HasConstraintName("FK_admin_watchlists_player_last_edited_by_id");
  1056. b.HasOne("Content.Server.Database.Player", "Player")
  1057. .WithMany("AdminWatchlistsReceived")
  1058. .HasForeignKey("PlayerUserId")
  1059. .HasPrincipalKey("UserId")
  1060. .OnDelete(DeleteBehavior.Cascade)
  1061. .HasConstraintName("FK_admin_watchlists_player_player_user_id");
  1062. b.HasOne("Content.Server.Database.Round", "Round")
  1063. .WithMany()
  1064. .HasForeignKey("RoundId")
  1065. .HasConstraintName("FK_admin_watchlists_round_round_id");
  1066. b.Navigation("CreatedBy");
  1067. b.Navigation("DeletedBy");
  1068. b.Navigation("LastEditedBy");
  1069. b.Navigation("Player");
  1070. b.Navigation("Round");
  1071. });
  1072. modelBuilder.Entity("Content.Server.Database.Antag", b =>
  1073. {
  1074. b.HasOne("Content.Server.Database.Profile", "Profile")
  1075. .WithMany("Antags")
  1076. .HasForeignKey("ProfileId")
  1077. .OnDelete(DeleteBehavior.Cascade)
  1078. .IsRequired()
  1079. .HasConstraintName("FK_antag_profile_profile_id");
  1080. b.Navigation("Profile");
  1081. });
  1082. modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
  1083. {
  1084. b.HasOne("Content.Server.Database.Server", "Server")
  1085. .WithMany("ConnectionLogs")
  1086. .HasForeignKey("ServerId")
  1087. .OnDelete(DeleteBehavior.SetNull)
  1088. .IsRequired()
  1089. .HasConstraintName("FK_connection_log_server_server_id");
  1090. b.Navigation("Server");
  1091. });
  1092. modelBuilder.Entity("Content.Server.Database.Job", b =>
  1093. {
  1094. b.HasOne("Content.Server.Database.Profile", "Profile")
  1095. .WithMany("Jobs")
  1096. .HasForeignKey("ProfileId")
  1097. .OnDelete(DeleteBehavior.Cascade)
  1098. .IsRequired()
  1099. .HasConstraintName("FK_job_profile_profile_id");
  1100. b.Navigation("Profile");
  1101. });
  1102. modelBuilder.Entity("Content.Server.Database.Profile", b =>
  1103. {
  1104. b.HasOne("Content.Server.Database.Preference", "Preference")
  1105. .WithMany("Profiles")
  1106. .HasForeignKey("PreferenceId")
  1107. .OnDelete(DeleteBehavior.Cascade)
  1108. .IsRequired()
  1109. .HasConstraintName("FK_profile_preference_preference_id");
  1110. b.Navigation("Preference");
  1111. });
  1112. modelBuilder.Entity("Content.Server.Database.Round", b =>
  1113. {
  1114. b.HasOne("Content.Server.Database.Server", "Server")
  1115. .WithMany("Rounds")
  1116. .HasForeignKey("ServerId")
  1117. .OnDelete(DeleteBehavior.Cascade)
  1118. .IsRequired()
  1119. .HasConstraintName("FK_round_server_server_id");
  1120. b.Navigation("Server");
  1121. });
  1122. modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
  1123. {
  1124. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1125. .WithMany("AdminServerBansCreated")
  1126. .HasForeignKey("BanningAdmin")
  1127. .HasPrincipalKey("UserId")
  1128. .OnDelete(DeleteBehavior.SetNull)
  1129. .HasConstraintName("FK_server_ban_player_banning_admin");
  1130. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1131. .WithMany("AdminServerBansLastEdited")
  1132. .HasForeignKey("LastEditedById")
  1133. .HasPrincipalKey("UserId")
  1134. .OnDelete(DeleteBehavior.SetNull)
  1135. .HasConstraintName("FK_server_ban_player_last_edited_by_id");
  1136. b.HasOne("Content.Server.Database.Round", "Round")
  1137. .WithMany()
  1138. .HasForeignKey("RoundId")
  1139. .HasConstraintName("FK_server_ban_round_round_id");
  1140. b.Navigation("CreatedBy");
  1141. b.Navigation("LastEditedBy");
  1142. b.Navigation("Round");
  1143. });
  1144. modelBuilder.Entity("Content.Server.Database.ServerBanHit", b =>
  1145. {
  1146. b.HasOne("Content.Server.Database.ServerBan", "Ban")
  1147. .WithMany("BanHits")
  1148. .HasForeignKey("BanId")
  1149. .OnDelete(DeleteBehavior.Cascade)
  1150. .IsRequired()
  1151. .HasConstraintName("FK_server_ban_hit_server_ban_ban_id");
  1152. b.HasOne("Content.Server.Database.ConnectionLog", "Connection")
  1153. .WithMany("BanHits")
  1154. .HasForeignKey("ConnectionId")
  1155. .OnDelete(DeleteBehavior.Cascade)
  1156. .IsRequired()
  1157. .HasConstraintName("FK_server_ban_hit_connection_log_connection_id");
  1158. b.Navigation("Ban");
  1159. b.Navigation("Connection");
  1160. });
  1161. modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
  1162. {
  1163. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1164. .WithMany("AdminServerRoleBansCreated")
  1165. .HasForeignKey("BanningAdmin")
  1166. .HasPrincipalKey("UserId")
  1167. .OnDelete(DeleteBehavior.SetNull)
  1168. .HasConstraintName("FK_server_role_ban_player_banning_admin");
  1169. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1170. .WithMany("AdminServerRoleBansLastEdited")
  1171. .HasForeignKey("LastEditedById")
  1172. .HasPrincipalKey("UserId")
  1173. .OnDelete(DeleteBehavior.SetNull)
  1174. .HasConstraintName("FK_server_role_ban_player_last_edited_by_id");
  1175. b.HasOne("Content.Server.Database.Round", "Round")
  1176. .WithMany()
  1177. .HasForeignKey("RoundId")
  1178. .HasConstraintName("FK_server_role_ban_round_round_id");
  1179. b.Navigation("CreatedBy");
  1180. b.Navigation("LastEditedBy");
  1181. b.Navigation("Round");
  1182. });
  1183. modelBuilder.Entity("Content.Server.Database.ServerRoleUnban", b =>
  1184. {
  1185. b.HasOne("Content.Server.Database.ServerRoleBan", "Ban")
  1186. .WithOne("Unban")
  1187. .HasForeignKey("Content.Server.Database.ServerRoleUnban", "BanId")
  1188. .OnDelete(DeleteBehavior.Cascade)
  1189. .IsRequired()
  1190. .HasConstraintName("FK_server_role_unban_server_role_ban_ban_id");
  1191. b.Navigation("Ban");
  1192. });
  1193. modelBuilder.Entity("Content.Server.Database.ServerUnban", b =>
  1194. {
  1195. b.HasOne("Content.Server.Database.ServerBan", "Ban")
  1196. .WithOne("Unban")
  1197. .HasForeignKey("Content.Server.Database.ServerUnban", "BanId")
  1198. .OnDelete(DeleteBehavior.Cascade)
  1199. .IsRequired()
  1200. .HasConstraintName("FK_server_unban_server_ban_ban_id");
  1201. b.Navigation("Ban");
  1202. });
  1203. modelBuilder.Entity("Content.Server.Database.Trait", b =>
  1204. {
  1205. b.HasOne("Content.Server.Database.Profile", "Profile")
  1206. .WithMany("Traits")
  1207. .HasForeignKey("ProfileId")
  1208. .OnDelete(DeleteBehavior.Cascade)
  1209. .IsRequired()
  1210. .HasConstraintName("FK_trait_profile_profile_id");
  1211. b.Navigation("Profile");
  1212. });
  1213. modelBuilder.Entity("PlayerRound", b =>
  1214. {
  1215. b.HasOne("Content.Server.Database.Player", null)
  1216. .WithMany()
  1217. .HasForeignKey("PlayersId")
  1218. .OnDelete(DeleteBehavior.Cascade)
  1219. .IsRequired()
  1220. .HasConstraintName("FK_player_round_player_players_id");
  1221. b.HasOne("Content.Server.Database.Round", null)
  1222. .WithMany()
  1223. .HasForeignKey("RoundsId")
  1224. .OnDelete(DeleteBehavior.Cascade)
  1225. .IsRequired()
  1226. .HasConstraintName("FK_player_round_round_rounds_id");
  1227. });
  1228. modelBuilder.Entity("Content.Server.Database.Admin", b =>
  1229. {
  1230. b.Navigation("Flags");
  1231. });
  1232. modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
  1233. {
  1234. b.Navigation("Players");
  1235. });
  1236. modelBuilder.Entity("Content.Server.Database.AdminRank", b =>
  1237. {
  1238. b.Navigation("Admins");
  1239. b.Navigation("Flags");
  1240. });
  1241. modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
  1242. {
  1243. b.Navigation("BanHits");
  1244. });
  1245. modelBuilder.Entity("Content.Server.Database.Player", b =>
  1246. {
  1247. b.Navigation("AdminLogs");
  1248. b.Navigation("AdminMessagesCreated");
  1249. b.Navigation("AdminMessagesDeleted");
  1250. b.Navigation("AdminMessagesLastEdited");
  1251. b.Navigation("AdminMessagesReceived");
  1252. b.Navigation("AdminNotesCreated");
  1253. b.Navigation("AdminNotesDeleted");
  1254. b.Navigation("AdminNotesLastEdited");
  1255. b.Navigation("AdminNotesReceived");
  1256. b.Navigation("AdminServerBansCreated");
  1257. b.Navigation("AdminServerBansLastEdited");
  1258. b.Navigation("AdminServerRoleBansCreated");
  1259. b.Navigation("AdminServerRoleBansLastEdited");
  1260. b.Navigation("AdminWatchlistsCreated");
  1261. b.Navigation("AdminWatchlistsDeleted");
  1262. b.Navigation("AdminWatchlistsLastEdited");
  1263. b.Navigation("AdminWatchlistsReceived");
  1264. });
  1265. modelBuilder.Entity("Content.Server.Database.Preference", b =>
  1266. {
  1267. b.Navigation("Profiles");
  1268. });
  1269. modelBuilder.Entity("Content.Server.Database.Profile", b =>
  1270. {
  1271. b.Navigation("Antags");
  1272. b.Navigation("Jobs");
  1273. b.Navigation("Traits");
  1274. });
  1275. modelBuilder.Entity("Content.Server.Database.Round", b =>
  1276. {
  1277. b.Navigation("AdminLogs");
  1278. });
  1279. modelBuilder.Entity("Content.Server.Database.Server", b =>
  1280. {
  1281. b.Navigation("ConnectionLogs");
  1282. b.Navigation("Rounds");
  1283. });
  1284. modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
  1285. {
  1286. b.Navigation("BanHits");
  1287. b.Navigation("Unban");
  1288. });
  1289. modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
  1290. {
  1291. b.Navigation("Unban");
  1292. });
  1293. #pragma warning restore 612, 618
  1294. }
  1295. }
  1296. }