1
0

20240112194612_Blacklist.Designer.cs 64 KB

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