20240201091254_SpawnPriorityPreference.Designer.cs 63 KB

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