1
0

20230503001739_AdminNotesImprovement.Designer.cs 63 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698
  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("20230503001739_AdminNotesImprovement")]
  13. partial class AdminNotesImprovement
  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>("Id")
  65. .ValueGeneratedOnAdd()
  66. .HasColumnType("INTEGER")
  67. .HasColumnName("admin_log_id");
  68. b.Property<int>("RoundId")
  69. .HasColumnType("INTEGER")
  70. .HasColumnName("round_id");
  71. b.Property<DateTime>("Date")
  72. .HasColumnType("TEXT")
  73. .HasColumnName("date");
  74. b.Property<sbyte>("Impact")
  75. .HasColumnType("INTEGER")
  76. .HasColumnName("impact");
  77. b.Property<string>("Json")
  78. .IsRequired()
  79. .HasColumnType("jsonb")
  80. .HasColumnName("json");
  81. b.Property<string>("Message")
  82. .IsRequired()
  83. .HasColumnType("TEXT")
  84. .HasColumnName("message");
  85. b.Property<int>("Type")
  86. .HasColumnType("INTEGER")
  87. .HasColumnName("type");
  88. b.HasKey("Id", "RoundId")
  89. .HasName("PK_admin_log");
  90. b.HasIndex("Date");
  91. b.HasIndex("RoundId")
  92. .HasDatabaseName("IX_admin_log_round_id");
  93. b.HasIndex("Type")
  94. .HasDatabaseName("IX_admin_log_type");
  95. b.ToTable("admin_log", (string)null);
  96. });
  97. modelBuilder.Entity("Content.Server.Database.AdminLogEntity", b =>
  98. {
  99. b.Property<int>("Uid")
  100. .ValueGeneratedOnAdd()
  101. .HasColumnType("INTEGER")
  102. .HasColumnName("uid");
  103. b.Property<int?>("AdminLogId")
  104. .HasColumnType("INTEGER")
  105. .HasColumnName("admin_log_id");
  106. b.Property<int?>("AdminLogRoundId")
  107. .HasColumnType("INTEGER")
  108. .HasColumnName("admin_log_round_id");
  109. b.Property<string>("Name")
  110. .HasColumnType("TEXT")
  111. .HasColumnName("name");
  112. b.HasKey("Uid")
  113. .HasName("PK_admin_log_entity");
  114. b.HasIndex("AdminLogId", "AdminLogRoundId")
  115. .HasDatabaseName("IX_admin_log_entity_admin_log_id_admin_log_round_id");
  116. b.ToTable("admin_log_entity", (string)null);
  117. });
  118. modelBuilder.Entity("Content.Server.Database.AdminLogPlayer", b =>
  119. {
  120. b.Property<Guid>("PlayerUserId")
  121. .HasColumnType("TEXT")
  122. .HasColumnName("player_user_id");
  123. b.Property<int>("LogId")
  124. .HasColumnType("INTEGER")
  125. .HasColumnName("log_id");
  126. b.Property<int>("RoundId")
  127. .HasColumnType("INTEGER")
  128. .HasColumnName("round_id");
  129. b.HasKey("PlayerUserId", "LogId", "RoundId")
  130. .HasName("PK_admin_log_player");
  131. b.HasIndex("LogId", "RoundId");
  132. b.ToTable("admin_log_player", (string)null);
  133. });
  134. modelBuilder.Entity("Content.Server.Database.AdminMessage", b =>
  135. {
  136. b.Property<int>("Id")
  137. .ValueGeneratedOnAdd()
  138. .HasColumnType("INTEGER")
  139. .HasColumnName("admin_messages_id");
  140. b.Property<DateTime>("CreatedAt")
  141. .HasColumnType("TEXT")
  142. .HasColumnName("created_at");
  143. b.Property<Guid?>("CreatedById")
  144. .HasColumnType("TEXT")
  145. .HasColumnName("created_by_id");
  146. b.Property<bool>("Deleted")
  147. .HasColumnType("INTEGER")
  148. .HasColumnName("deleted");
  149. b.Property<DateTime?>("DeletedAt")
  150. .HasColumnType("TEXT")
  151. .HasColumnName("deleted_at");
  152. b.Property<Guid?>("DeletedById")
  153. .HasColumnType("TEXT")
  154. .HasColumnName("deleted_by_id");
  155. b.Property<DateTime?>("ExpirationTime")
  156. .HasColumnType("TEXT")
  157. .HasColumnName("expiration_time");
  158. b.Property<DateTime?>("LastEditedAt")
  159. .HasColumnType("TEXT")
  160. .HasColumnName("last_edited_at");
  161. b.Property<Guid?>("LastEditedById")
  162. .HasColumnType("TEXT")
  163. .HasColumnName("last_edited_by_id");
  164. b.Property<string>("Message")
  165. .IsRequired()
  166. .HasMaxLength(4096)
  167. .HasColumnType("TEXT")
  168. .HasColumnName("message");
  169. b.Property<Guid?>("PlayerUserId")
  170. .HasColumnType("TEXT")
  171. .HasColumnName("player_user_id");
  172. b.Property<TimeSpan>("PlaytimeAtNote")
  173. .HasColumnType("TEXT")
  174. .HasColumnName("playtime_at_note");
  175. b.Property<int?>("RoundId")
  176. .HasColumnType("INTEGER")
  177. .HasColumnName("round_id");
  178. b.Property<bool>("Seen")
  179. .HasColumnType("INTEGER")
  180. .HasColumnName("seen");
  181. b.HasKey("Id")
  182. .HasName("PK_admin_messages");
  183. b.HasIndex("CreatedById");
  184. b.HasIndex("DeletedById");
  185. b.HasIndex("LastEditedById");
  186. b.HasIndex("PlayerUserId")
  187. .HasDatabaseName("IX_admin_messages_player_user_id");
  188. b.HasIndex("RoundId")
  189. .HasDatabaseName("IX_admin_messages_round_id");
  190. b.ToTable("admin_messages", (string)null);
  191. });
  192. modelBuilder.Entity("Content.Server.Database.AdminNote", b =>
  193. {
  194. b.Property<int>("Id")
  195. .ValueGeneratedOnAdd()
  196. .HasColumnType("INTEGER")
  197. .HasColumnName("admin_notes_id");
  198. b.Property<DateTime>("CreatedAt")
  199. .HasColumnType("TEXT")
  200. .HasColumnName("created_at");
  201. b.Property<Guid?>("CreatedById")
  202. .HasColumnType("TEXT")
  203. .HasColumnName("created_by_id");
  204. b.Property<bool>("Deleted")
  205. .HasColumnType("INTEGER")
  206. .HasColumnName("deleted");
  207. b.Property<DateTime?>("DeletedAt")
  208. .HasColumnType("TEXT")
  209. .HasColumnName("deleted_at");
  210. b.Property<Guid?>("DeletedById")
  211. .HasColumnType("TEXT")
  212. .HasColumnName("deleted_by_id");
  213. b.Property<DateTime?>("ExpirationTime")
  214. .HasColumnType("TEXT")
  215. .HasColumnName("expiration_time");
  216. b.Property<DateTime?>("LastEditedAt")
  217. .IsRequired()
  218. .HasColumnType("TEXT")
  219. .HasColumnName("last_edited_at");
  220. b.Property<Guid?>("LastEditedById")
  221. .HasColumnType("TEXT")
  222. .HasColumnName("last_edited_by_id");
  223. b.Property<string>("Message")
  224. .IsRequired()
  225. .HasMaxLength(4096)
  226. .HasColumnType("TEXT")
  227. .HasColumnName("message");
  228. b.Property<int>("Severity")
  229. .HasColumnType("INTEGER")
  230. .HasColumnName("severity");
  231. b.Property<Guid?>("PlayerUserId")
  232. .HasColumnType("TEXT")
  233. .HasColumnName("player_user_id");
  234. b.Property<TimeSpan>("PlaytimeAtNote")
  235. .HasColumnType("TEXT")
  236. .HasColumnName("playtime_at_note");
  237. b.Property<int?>("RoundId")
  238. .HasColumnType("INTEGER")
  239. .HasColumnName("round_id");
  240. b.Property<bool>("Secret")
  241. .HasColumnType("INTEGER")
  242. .HasColumnName("secret");
  243. b.HasKey("Id")
  244. .HasName("PK_admin_notes");
  245. b.HasIndex("CreatedById");
  246. b.HasIndex("DeletedById");
  247. b.HasIndex("LastEditedById");
  248. b.HasIndex("PlayerUserId")
  249. .HasDatabaseName("IX_admin_notes_player_user_id");
  250. b.HasIndex("RoundId")
  251. .HasDatabaseName("IX_admin_notes_round_id");
  252. b.ToTable("admin_notes", (string)null);
  253. });
  254. modelBuilder.Entity("Content.Server.Database.AdminRank", b =>
  255. {
  256. b.Property<int>("Id")
  257. .ValueGeneratedOnAdd()
  258. .HasColumnType("INTEGER")
  259. .HasColumnName("admin_rank_id");
  260. b.Property<string>("Name")
  261. .IsRequired()
  262. .HasColumnType("TEXT")
  263. .HasColumnName("name");
  264. b.HasKey("Id")
  265. .HasName("PK_admin_rank");
  266. b.ToTable("admin_rank", (string)null);
  267. });
  268. modelBuilder.Entity("Content.Server.Database.AdminRankFlag", b =>
  269. {
  270. b.Property<int>("Id")
  271. .ValueGeneratedOnAdd()
  272. .HasColumnType("INTEGER")
  273. .HasColumnName("admin_rank_flag_id");
  274. b.Property<int>("AdminRankId")
  275. .HasColumnType("INTEGER")
  276. .HasColumnName("admin_rank_id");
  277. b.Property<string>("Flag")
  278. .IsRequired()
  279. .HasColumnType("TEXT")
  280. .HasColumnName("flag");
  281. b.HasKey("Id")
  282. .HasName("PK_admin_rank_flag");
  283. b.HasIndex("AdminRankId");
  284. b.HasIndex("Flag", "AdminRankId")
  285. .IsUnique();
  286. b.ToTable("admin_rank_flag", (string)null);
  287. });
  288. modelBuilder.Entity("Content.Server.Database.AdminWatchlist", b =>
  289. {
  290. b.Property<int>("Id")
  291. .ValueGeneratedOnAdd()
  292. .HasColumnType("INTEGER")
  293. .HasColumnName("admin_watchlists_id");
  294. b.Property<DateTime>("CreatedAt")
  295. .HasColumnType("TEXT")
  296. .HasColumnName("created_at");
  297. b.Property<Guid?>("CreatedById")
  298. .HasColumnType("TEXT")
  299. .HasColumnName("created_by_id");
  300. b.Property<bool>("Deleted")
  301. .HasColumnType("INTEGER")
  302. .HasColumnName("deleted");
  303. b.Property<DateTime?>("DeletedAt")
  304. .HasColumnType("TEXT")
  305. .HasColumnName("deleted_at");
  306. b.Property<Guid?>("DeletedById")
  307. .HasColumnType("TEXT")
  308. .HasColumnName("deleted_by_id");
  309. b.Property<DateTime?>("ExpirationTime")
  310. .HasColumnType("TEXT")
  311. .HasColumnName("expiration_time");
  312. b.Property<DateTime?>("LastEditedAt")
  313. .IsRequired()
  314. .HasColumnType("TEXT")
  315. .HasColumnName("last_edited_at");
  316. b.Property<Guid?>("LastEditedById")
  317. .HasColumnType("TEXT")
  318. .HasColumnName("last_edited_by_id");
  319. b.Property<string>("Message")
  320. .IsRequired()
  321. .HasMaxLength(4096)
  322. .HasColumnType("TEXT")
  323. .HasColumnName("message");
  324. b.Property<Guid?>("PlayerUserId")
  325. .HasColumnType("TEXT")
  326. .HasColumnName("player_user_id");
  327. b.Property<TimeSpan>("PlaytimeAtNote")
  328. .HasColumnType("TEXT")
  329. .HasColumnName("playtime_at_note");
  330. b.Property<int?>("RoundId")
  331. .HasColumnType("INTEGER")
  332. .HasColumnName("round_id");
  333. b.HasKey("Id")
  334. .HasName("PK_admin_watchlists");
  335. b.HasIndex("CreatedById");
  336. b.HasIndex("DeletedById");
  337. b.HasIndex("LastEditedById");
  338. b.HasIndex("PlayerUserId")
  339. .HasDatabaseName("IX_admin_watchlists_player_user_id");
  340. b.HasIndex("RoundId")
  341. .HasDatabaseName("IX_admin_watchlists_round_id");
  342. b.ToTable("admin_watchlists", (string)null);
  343. });
  344. modelBuilder.Entity("Content.Server.Database.Antag", b =>
  345. {
  346. b.Property<int>("Id")
  347. .ValueGeneratedOnAdd()
  348. .HasColumnType("INTEGER")
  349. .HasColumnName("antag_id");
  350. b.Property<string>("AntagName")
  351. .IsRequired()
  352. .HasColumnType("TEXT")
  353. .HasColumnName("antag_name");
  354. b.Property<int>("ProfileId")
  355. .HasColumnType("INTEGER")
  356. .HasColumnName("profile_id");
  357. b.HasKey("Id")
  358. .HasName("PK_antag");
  359. b.HasIndex("ProfileId", "AntagName")
  360. .IsUnique();
  361. b.ToTable("antag", (string)null);
  362. });
  363. modelBuilder.Entity("Content.Server.Database.AssignedUserId", b =>
  364. {
  365. b.Property<int>("Id")
  366. .ValueGeneratedOnAdd()
  367. .HasColumnType("INTEGER")
  368. .HasColumnName("assigned_user_id_id");
  369. b.Property<Guid>("UserId")
  370. .HasColumnType("TEXT")
  371. .HasColumnName("user_id");
  372. b.Property<string>("UserName")
  373. .IsRequired()
  374. .HasColumnType("TEXT")
  375. .HasColumnName("user_name");
  376. b.HasKey("Id")
  377. .HasName("PK_assigned_user_id");
  378. b.HasIndex("UserId")
  379. .IsUnique();
  380. b.HasIndex("UserName")
  381. .IsUnique();
  382. b.ToTable("assigned_user_id", (string)null);
  383. });
  384. modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
  385. {
  386. b.Property<int>("Id")
  387. .ValueGeneratedOnAdd()
  388. .HasColumnType("INTEGER")
  389. .HasColumnName("connection_log_id");
  390. b.Property<string>("Address")
  391. .IsRequired()
  392. .HasColumnType("TEXT")
  393. .HasColumnName("address");
  394. b.Property<byte?>("Denied")
  395. .HasColumnType("INTEGER")
  396. .HasColumnName("denied");
  397. b.Property<byte[]>("HWId")
  398. .HasColumnType("BLOB")
  399. .HasColumnName("hwid");
  400. b.Property<DateTime>("Time")
  401. .HasColumnType("TEXT")
  402. .HasColumnName("time");
  403. b.Property<Guid>("UserId")
  404. .HasColumnType("TEXT")
  405. .HasColumnName("user_id");
  406. b.Property<string>("UserName")
  407. .IsRequired()
  408. .HasColumnType("TEXT")
  409. .HasColumnName("user_name");
  410. b.HasKey("Id")
  411. .HasName("PK_connection_log");
  412. b.HasIndex("UserId");
  413. b.ToTable("connection_log", (string)null);
  414. });
  415. modelBuilder.Entity("Content.Server.Database.Job", b =>
  416. {
  417. b.Property<int>("Id")
  418. .ValueGeneratedOnAdd()
  419. .HasColumnType("INTEGER")
  420. .HasColumnName("job_id");
  421. b.Property<string>("JobName")
  422. .IsRequired()
  423. .HasColumnType("TEXT")
  424. .HasColumnName("job_name");
  425. b.Property<int>("Priority")
  426. .HasColumnType("INTEGER")
  427. .HasColumnName("priority");
  428. b.Property<int>("ProfileId")
  429. .HasColumnType("INTEGER")
  430. .HasColumnName("profile_id");
  431. b.HasKey("Id")
  432. .HasName("PK_job");
  433. b.HasIndex("ProfileId");
  434. b.HasIndex("ProfileId", "JobName")
  435. .IsUnique();
  436. b.HasIndex(new[] { "ProfileId" }, "IX_job_one_high_priority")
  437. .IsUnique()
  438. .HasFilter("priority = 3");
  439. b.ToTable("job", (string)null);
  440. });
  441. modelBuilder.Entity("Content.Server.Database.PlayTime", b =>
  442. {
  443. b.Property<int>("Id")
  444. .ValueGeneratedOnAdd()
  445. .HasColumnType("INTEGER")
  446. .HasColumnName("play_time_id");
  447. b.Property<Guid>("PlayerId")
  448. .HasColumnType("TEXT")
  449. .HasColumnName("player_id");
  450. b.Property<TimeSpan>("TimeSpent")
  451. .HasColumnType("TEXT")
  452. .HasColumnName("time_spent");
  453. b.Property<string>("Tracker")
  454. .IsRequired()
  455. .HasColumnType("TEXT")
  456. .HasColumnName("tracker");
  457. b.HasKey("Id")
  458. .HasName("PK_play_time");
  459. b.HasIndex("PlayerId", "Tracker")
  460. .IsUnique();
  461. b.ToTable("play_time", (string)null);
  462. });
  463. modelBuilder.Entity("Content.Server.Database.Player", b =>
  464. {
  465. b.Property<int>("Id")
  466. .ValueGeneratedOnAdd()
  467. .HasColumnType("INTEGER")
  468. .HasColumnName("player_id");
  469. b.Property<DateTime>("FirstSeenTime")
  470. .HasColumnType("TEXT")
  471. .HasColumnName("first_seen_time");
  472. b.Property<DateTime?>("LastReadRules")
  473. .HasColumnType("TEXT")
  474. .HasColumnName("last_read_rules");
  475. b.Property<string>("LastSeenAddress")
  476. .IsRequired()
  477. .HasColumnType("TEXT")
  478. .HasColumnName("last_seen_address");
  479. b.Property<byte[]>("LastSeenHWId")
  480. .HasColumnType("BLOB")
  481. .HasColumnName("last_seen_hwid");
  482. b.Property<DateTime>("LastSeenTime")
  483. .HasColumnType("TEXT")
  484. .HasColumnName("last_seen_time");
  485. b.Property<string>("LastSeenUserName")
  486. .IsRequired()
  487. .HasColumnType("TEXT")
  488. .HasColumnName("last_seen_user_name");
  489. b.Property<Guid>("UserId")
  490. .HasColumnType("TEXT")
  491. .HasColumnName("user_id");
  492. b.HasKey("Id")
  493. .HasName("PK_player");
  494. b.HasAlternateKey("UserId")
  495. .HasName("ak_player_user_id");
  496. b.HasIndex("LastSeenUserName");
  497. b.HasIndex("UserId")
  498. .IsUnique();
  499. b.ToTable("player", (string)null);
  500. });
  501. modelBuilder.Entity("Content.Server.Database.Preference", b =>
  502. {
  503. b.Property<int>("Id")
  504. .ValueGeneratedOnAdd()
  505. .HasColumnType("INTEGER")
  506. .HasColumnName("preference_id");
  507. b.Property<string>("AdminOOCColor")
  508. .IsRequired()
  509. .HasColumnType("TEXT")
  510. .HasColumnName("admin_ooc_color");
  511. b.Property<int>("SelectedCharacterSlot")
  512. .HasColumnType("INTEGER")
  513. .HasColumnName("selected_character_slot");
  514. b.Property<Guid>("UserId")
  515. .HasColumnType("TEXT")
  516. .HasColumnName("user_id");
  517. b.HasKey("Id")
  518. .HasName("PK_preference");
  519. b.HasIndex("UserId")
  520. .IsUnique();
  521. b.ToTable("preference", (string)null);
  522. });
  523. modelBuilder.Entity("Content.Server.Database.Profile", b =>
  524. {
  525. b.Property<int>("Id")
  526. .ValueGeneratedOnAdd()
  527. .HasColumnType("INTEGER")
  528. .HasColumnName("profile_id");
  529. b.Property<int>("Age")
  530. .HasColumnType("INTEGER")
  531. .HasColumnName("age");
  532. b.Property<string>("Backpack")
  533. .IsRequired()
  534. .HasColumnType("TEXT")
  535. .HasColumnName("backpack");
  536. b.Property<string>("CharacterName")
  537. .IsRequired()
  538. .HasColumnType("TEXT")
  539. .HasColumnName("char_name");
  540. b.Property<string>("Clothing")
  541. .IsRequired()
  542. .HasColumnType("TEXT")
  543. .HasColumnName("clothing");
  544. b.Property<string>("EyeColor")
  545. .IsRequired()
  546. .HasColumnType("TEXT")
  547. .HasColumnName("eye_color");
  548. b.Property<string>("FacialHairColor")
  549. .IsRequired()
  550. .HasColumnType("TEXT")
  551. .HasColumnName("facial_hair_color");
  552. b.Property<string>("FacialHairName")
  553. .IsRequired()
  554. .HasColumnType("TEXT")
  555. .HasColumnName("facial_hair_name");
  556. b.Property<string>("FlavorText")
  557. .IsRequired()
  558. .HasColumnType("TEXT")
  559. .HasColumnName("flavor_text");
  560. b.Property<string>("Gender")
  561. .IsRequired()
  562. .HasColumnType("TEXT")
  563. .HasColumnName("gender");
  564. b.Property<string>("HairColor")
  565. .IsRequired()
  566. .HasColumnType("TEXT")
  567. .HasColumnName("hair_color");
  568. b.Property<string>("HairName")
  569. .IsRequired()
  570. .HasColumnType("TEXT")
  571. .HasColumnName("hair_name");
  572. b.Property<byte[]>("Markings")
  573. .HasColumnType("jsonb")
  574. .HasColumnName("markings");
  575. b.Property<int>("PreferenceId")
  576. .HasColumnType("INTEGER")
  577. .HasColumnName("preference_id");
  578. b.Property<int>("PreferenceUnavailable")
  579. .HasColumnType("INTEGER")
  580. .HasColumnName("pref_unavailable");
  581. b.Property<string>("Sex")
  582. .IsRequired()
  583. .HasColumnType("TEXT")
  584. .HasColumnName("sex");
  585. b.Property<string>("SkinColor")
  586. .IsRequired()
  587. .HasColumnType("TEXT")
  588. .HasColumnName("skin_color");
  589. b.Property<int>("Slot")
  590. .HasColumnType("INTEGER")
  591. .HasColumnName("slot");
  592. b.Property<string>("Species")
  593. .IsRequired()
  594. .HasColumnType("TEXT")
  595. .HasColumnName("species");
  596. b.HasKey("Id")
  597. .HasName("PK_profile");
  598. b.HasIndex("PreferenceId")
  599. .HasDatabaseName("IX_profile_preference_id");
  600. b.HasIndex("Slot", "PreferenceId")
  601. .IsUnique();
  602. b.ToTable("profile", (string)null);
  603. });
  604. modelBuilder.Entity("Content.Server.Database.Round", b =>
  605. {
  606. b.Property<int>("Id")
  607. .ValueGeneratedOnAdd()
  608. .HasColumnType("INTEGER")
  609. .HasColumnName("round_id");
  610. b.Property<int>("ServerId")
  611. .HasColumnType("INTEGER")
  612. .HasColumnName("server_id");
  613. b.HasKey("Id")
  614. .HasName("PK_round");
  615. b.HasIndex("ServerId")
  616. .HasDatabaseName("IX_round_server_id");
  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.AdminLogEntity", b =>
  938. {
  939. b.HasOne("Content.Server.Database.AdminLog", null)
  940. .WithMany("Entities")
  941. .HasForeignKey("AdminLogId", "AdminLogRoundId")
  942. .HasConstraintName("FK_admin_log_entity_admin_log_admin_log_id_admin_log_round_id");
  943. });
  944. modelBuilder.Entity("Content.Server.Database.AdminLogPlayer", b =>
  945. {
  946. b.HasOne("Content.Server.Database.Player", "Player")
  947. .WithMany("AdminLogs")
  948. .HasForeignKey("PlayerUserId")
  949. .HasPrincipalKey("UserId")
  950. .OnDelete(DeleteBehavior.Cascade)
  951. .IsRequired()
  952. .HasConstraintName("FK_admin_log_player_player_player_user_id");
  953. b.HasOne("Content.Server.Database.AdminLog", "Log")
  954. .WithMany("Players")
  955. .HasForeignKey("LogId", "RoundId")
  956. .OnDelete(DeleteBehavior.Cascade)
  957. .IsRequired()
  958. .HasConstraintName("FK_admin_log_player_admin_log_log_id_round_id");
  959. b.Navigation("Log");
  960. b.Navigation("Player");
  961. });
  962. modelBuilder.Entity("Content.Server.Database.AdminMessage", b =>
  963. {
  964. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  965. .WithMany("AdminMessagesCreated")
  966. .HasForeignKey("CreatedById")
  967. .HasPrincipalKey("UserId")
  968. .OnDelete(DeleteBehavior.SetNull)
  969. .HasConstraintName("FK_admin_messages_player_created_by_id");
  970. b.HasOne("Content.Server.Database.Player", "DeletedBy")
  971. .WithMany("AdminMessagesDeleted")
  972. .HasForeignKey("DeletedById")
  973. .HasPrincipalKey("UserId")
  974. .OnDelete(DeleteBehavior.SetNull)
  975. .HasConstraintName("FK_admin_messages_player_deleted_by_id");
  976. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  977. .WithMany("AdminMessagesLastEdited")
  978. .HasForeignKey("LastEditedById")
  979. .HasPrincipalKey("UserId")
  980. .OnDelete(DeleteBehavior.SetNull)
  981. .HasConstraintName("FK_admin_messages_player_last_edited_by_id");
  982. b.HasOne("Content.Server.Database.Player", "Player")
  983. .WithMany("AdminMessagesReceived")
  984. .HasForeignKey("PlayerUserId")
  985. .HasPrincipalKey("UserId")
  986. .OnDelete(DeleteBehavior.SetNull)
  987. .HasConstraintName("FK_admin_messages_player_player_user_id");
  988. b.HasOne("Content.Server.Database.Round", "Round")
  989. .WithMany()
  990. .HasForeignKey("RoundId")
  991. .HasConstraintName("FK_admin_messages_round_round_id");
  992. b.Navigation("CreatedBy");
  993. b.Navigation("DeletedBy");
  994. b.Navigation("LastEditedBy");
  995. b.Navigation("Player");
  996. b.Navigation("Round");
  997. });
  998. modelBuilder.Entity("Content.Server.Database.AdminNote", b =>
  999. {
  1000. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1001. .WithMany("AdminNotesCreated")
  1002. .HasForeignKey("CreatedById")
  1003. .HasPrincipalKey("UserId")
  1004. .OnDelete(DeleteBehavior.SetNull)
  1005. .HasConstraintName("FK_admin_notes_player_created_by_id");
  1006. b.HasOne("Content.Server.Database.Player", "DeletedBy")
  1007. .WithMany("AdminNotesDeleted")
  1008. .HasForeignKey("DeletedById")
  1009. .HasPrincipalKey("UserId")
  1010. .OnDelete(DeleteBehavior.SetNull)
  1011. .HasConstraintName("FK_admin_notes_player_deleted_by_id");
  1012. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1013. .WithMany("AdminNotesLastEdited")
  1014. .HasForeignKey("LastEditedById")
  1015. .HasPrincipalKey("UserId")
  1016. .OnDelete(DeleteBehavior.SetNull)
  1017. .HasConstraintName("FK_admin_notes_player_last_edited_by_id");
  1018. b.HasOne("Content.Server.Database.Player", "Player")
  1019. .WithMany("AdminNotesReceived")
  1020. .HasForeignKey("PlayerUserId")
  1021. .HasPrincipalKey("UserId")
  1022. .OnDelete(DeleteBehavior.SetNull)
  1023. .HasConstraintName("FK_admin_notes_player_player_user_id");
  1024. b.HasOne("Content.Server.Database.Round", "Round")
  1025. .WithMany()
  1026. .HasForeignKey("RoundId")
  1027. .HasConstraintName("FK_admin_notes_round_round_id");
  1028. b.Navigation("CreatedBy");
  1029. b.Navigation("DeletedBy");
  1030. b.Navigation("LastEditedBy");
  1031. b.Navigation("Player");
  1032. b.Navigation("Round");
  1033. });
  1034. modelBuilder.Entity("Content.Server.Database.AdminRankFlag", b =>
  1035. {
  1036. b.HasOne("Content.Server.Database.AdminRank", "Rank")
  1037. .WithMany("Flags")
  1038. .HasForeignKey("AdminRankId")
  1039. .OnDelete(DeleteBehavior.Cascade)
  1040. .IsRequired()
  1041. .HasConstraintName("FK_admin_rank_flag_admin_rank_admin_rank_id");
  1042. b.Navigation("Rank");
  1043. });
  1044. modelBuilder.Entity("Content.Server.Database.AdminWatchlist", b =>
  1045. {
  1046. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1047. .WithMany("AdminWatchlistsCreated")
  1048. .HasForeignKey("CreatedById")
  1049. .HasPrincipalKey("UserId")
  1050. .OnDelete(DeleteBehavior.SetNull)
  1051. .HasConstraintName("FK_admin_watchlists_player_created_by_id");
  1052. b.HasOne("Content.Server.Database.Player", "DeletedBy")
  1053. .WithMany("AdminWatchlistsDeleted")
  1054. .HasForeignKey("DeletedById")
  1055. .HasPrincipalKey("UserId")
  1056. .OnDelete(DeleteBehavior.SetNull)
  1057. .HasConstraintName("FK_admin_watchlists_player_deleted_by_id");
  1058. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1059. .WithMany("AdminWatchlistsLastEdited")
  1060. .HasForeignKey("LastEditedById")
  1061. .HasPrincipalKey("UserId")
  1062. .OnDelete(DeleteBehavior.SetNull)
  1063. .HasConstraintName("FK_admin_watchlists_player_last_edited_by_id");
  1064. b.HasOne("Content.Server.Database.Player", "Player")
  1065. .WithMany("AdminWatchlistsReceived")
  1066. .HasForeignKey("PlayerUserId")
  1067. .HasPrincipalKey("UserId")
  1068. .OnDelete(DeleteBehavior.SetNull)
  1069. .HasConstraintName("FK_admin_watchlists_player_player_user_id");
  1070. b.HasOne("Content.Server.Database.Round", "Round")
  1071. .WithMany()
  1072. .HasForeignKey("RoundId")
  1073. .HasConstraintName("FK_admin_watchlists_round_round_id");
  1074. b.Navigation("CreatedBy");
  1075. b.Navigation("DeletedBy");
  1076. b.Navigation("LastEditedBy");
  1077. b.Navigation("Player");
  1078. b.Navigation("Round");
  1079. });
  1080. modelBuilder.Entity("Content.Server.Database.Antag", b =>
  1081. {
  1082. b.HasOne("Content.Server.Database.Profile", "Profile")
  1083. .WithMany("Antags")
  1084. .HasForeignKey("ProfileId")
  1085. .OnDelete(DeleteBehavior.Cascade)
  1086. .IsRequired()
  1087. .HasConstraintName("FK_antag_profile_profile_id");
  1088. b.Navigation("Profile");
  1089. });
  1090. modelBuilder.Entity("Content.Server.Database.Job", b =>
  1091. {
  1092. b.HasOne("Content.Server.Database.Profile", "Profile")
  1093. .WithMany("Jobs")
  1094. .HasForeignKey("ProfileId")
  1095. .OnDelete(DeleteBehavior.Cascade)
  1096. .IsRequired()
  1097. .HasConstraintName("FK_job_profile_profile_id");
  1098. b.Navigation("Profile");
  1099. });
  1100. modelBuilder.Entity("Content.Server.Database.Profile", b =>
  1101. {
  1102. b.HasOne("Content.Server.Database.Preference", "Preference")
  1103. .WithMany("Profiles")
  1104. .HasForeignKey("PreferenceId")
  1105. .OnDelete(DeleteBehavior.Cascade)
  1106. .IsRequired()
  1107. .HasConstraintName("FK_profile_preference_preference_id");
  1108. b.Navigation("Preference");
  1109. });
  1110. modelBuilder.Entity("Content.Server.Database.Round", b =>
  1111. {
  1112. b.HasOne("Content.Server.Database.Server", "Server")
  1113. .WithMany("Rounds")
  1114. .HasForeignKey("ServerId")
  1115. .OnDelete(DeleteBehavior.Cascade)
  1116. .IsRequired()
  1117. .HasConstraintName("FK_round_server_server_id");
  1118. b.Navigation("Server");
  1119. });
  1120. modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
  1121. {
  1122. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1123. .WithMany("AdminServerBansCreated")
  1124. .HasForeignKey("BanningAdmin")
  1125. .HasPrincipalKey("UserId")
  1126. .OnDelete(DeleteBehavior.SetNull)
  1127. .HasConstraintName("FK_server_ban_player_banning_admin");
  1128. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1129. .WithMany("AdminServerBansLastEdited")
  1130. .HasForeignKey("LastEditedById")
  1131. .HasPrincipalKey("UserId")
  1132. .OnDelete(DeleteBehavior.SetNull)
  1133. .HasConstraintName("FK_server_ban_player_last_edited_by_id");
  1134. b.HasOne("Content.Server.Database.Round", "Round")
  1135. .WithMany()
  1136. .HasForeignKey("RoundId")
  1137. .HasConstraintName("FK_server_ban_round_round_id");
  1138. b.Navigation("CreatedBy");
  1139. b.Navigation("LastEditedBy");
  1140. b.Navigation("Round");
  1141. });
  1142. modelBuilder.Entity("Content.Server.Database.ServerBanHit", b =>
  1143. {
  1144. b.HasOne("Content.Server.Database.ServerBan", "Ban")
  1145. .WithMany("BanHits")
  1146. .HasForeignKey("BanId")
  1147. .OnDelete(DeleteBehavior.Cascade)
  1148. .IsRequired()
  1149. .HasConstraintName("FK_server_ban_hit_server_ban_ban_id");
  1150. b.HasOne("Content.Server.Database.ConnectionLog", "Connection")
  1151. .WithMany("BanHits")
  1152. .HasForeignKey("ConnectionId")
  1153. .OnDelete(DeleteBehavior.Cascade)
  1154. .IsRequired()
  1155. .HasConstraintName("FK_server_ban_hit_connection_log_connection_id");
  1156. b.Navigation("Ban");
  1157. b.Navigation("Connection");
  1158. });
  1159. modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
  1160. {
  1161. b.HasOne("Content.Server.Database.Player", "CreatedBy")
  1162. .WithMany("AdminServerRoleBansCreated")
  1163. .HasForeignKey("BanningAdmin")
  1164. .HasPrincipalKey("UserId")
  1165. .OnDelete(DeleteBehavior.SetNull)
  1166. .HasConstraintName("FK_server_role_ban_player_banning_admin");
  1167. b.HasOne("Content.Server.Database.Player", "LastEditedBy")
  1168. .WithMany("AdminServerRoleBansLastEdited")
  1169. .HasForeignKey("LastEditedById")
  1170. .HasPrincipalKey("UserId")
  1171. .OnDelete(DeleteBehavior.SetNull)
  1172. .HasConstraintName("FK_server_role_ban_player_last_edited_by_id");
  1173. b.HasOne("Content.Server.Database.Round", "Round")
  1174. .WithMany()
  1175. .HasForeignKey("RoundId")
  1176. .HasConstraintName("FK_server_role_ban_round_round_id");
  1177. b.Navigation("CreatedBy");
  1178. b.Navigation("LastEditedBy");
  1179. b.Navigation("Round");
  1180. });
  1181. modelBuilder.Entity("Content.Server.Database.ServerRoleUnban", b =>
  1182. {
  1183. b.HasOne("Content.Server.Database.ServerRoleBan", "Ban")
  1184. .WithOne("Unban")
  1185. .HasForeignKey("Content.Server.Database.ServerRoleUnban", "BanId")
  1186. .OnDelete(DeleteBehavior.Cascade)
  1187. .IsRequired()
  1188. .HasConstraintName("FK_server_role_unban_server_role_ban_ban_id");
  1189. b.Navigation("Ban");
  1190. });
  1191. modelBuilder.Entity("Content.Server.Database.ServerUnban", b =>
  1192. {
  1193. b.HasOne("Content.Server.Database.ServerBan", "Ban")
  1194. .WithOne("Unban")
  1195. .HasForeignKey("Content.Server.Database.ServerUnban", "BanId")
  1196. .OnDelete(DeleteBehavior.Cascade)
  1197. .IsRequired()
  1198. .HasConstraintName("FK_server_unban_server_ban_ban_id");
  1199. b.Navigation("Ban");
  1200. });
  1201. modelBuilder.Entity("Content.Server.Database.Trait", b =>
  1202. {
  1203. b.HasOne("Content.Server.Database.Profile", "Profile")
  1204. .WithMany("Traits")
  1205. .HasForeignKey("ProfileId")
  1206. .OnDelete(DeleteBehavior.Cascade)
  1207. .IsRequired()
  1208. .HasConstraintName("FK_trait_profile_profile_id");
  1209. b.Navigation("Profile");
  1210. });
  1211. modelBuilder.Entity("PlayerRound", b =>
  1212. {
  1213. b.HasOne("Content.Server.Database.Player", null)
  1214. .WithMany()
  1215. .HasForeignKey("PlayersId")
  1216. .OnDelete(DeleteBehavior.Cascade)
  1217. .IsRequired()
  1218. .HasConstraintName("FK_player_round_player_players_id");
  1219. b.HasOne("Content.Server.Database.Round", null)
  1220. .WithMany()
  1221. .HasForeignKey("RoundsId")
  1222. .OnDelete(DeleteBehavior.Cascade)
  1223. .IsRequired()
  1224. .HasConstraintName("FK_player_round_round_rounds_id");
  1225. });
  1226. modelBuilder.Entity("Content.Server.Database.Admin", b =>
  1227. {
  1228. b.Navigation("Flags");
  1229. });
  1230. modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
  1231. {
  1232. b.Navigation("Entities");
  1233. b.Navigation("Players");
  1234. });
  1235. modelBuilder.Entity("Content.Server.Database.AdminRank", b =>
  1236. {
  1237. b.Navigation("Admins");
  1238. b.Navigation("Flags");
  1239. });
  1240. modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
  1241. {
  1242. b.Navigation("BanHits");
  1243. });
  1244. modelBuilder.Entity("Content.Server.Database.Player", b =>
  1245. {
  1246. b.Navigation("AdminLogs");
  1247. b.Navigation("AdminMessagesCreated");
  1248. b.Navigation("AdminMessagesDeleted");
  1249. b.Navigation("AdminMessagesLastEdited");
  1250. b.Navigation("AdminMessagesReceived");
  1251. b.Navigation("AdminNotesCreated");
  1252. b.Navigation("AdminNotesDeleted");
  1253. b.Navigation("AdminNotesLastEdited");
  1254. b.Navigation("AdminNotesReceived");
  1255. b.Navigation("AdminServerBansCreated");
  1256. b.Navigation("AdminServerBansLastEdited");
  1257. b.Navigation("AdminServerRoleBansCreated");
  1258. b.Navigation("AdminServerRoleBansLastEdited");
  1259. b.Navigation("AdminWatchlistsCreated");
  1260. b.Navigation("AdminWatchlistsDeleted");
  1261. b.Navigation("AdminWatchlistsLastEdited");
  1262. b.Navigation("AdminWatchlistsReceived");
  1263. });
  1264. modelBuilder.Entity("Content.Server.Database.Preference", b =>
  1265. {
  1266. b.Navigation("Profiles");
  1267. });
  1268. modelBuilder.Entity("Content.Server.Database.Profile", b =>
  1269. {
  1270. b.Navigation("Antags");
  1271. b.Navigation("Jobs");
  1272. b.Navigation("Traits");
  1273. });
  1274. modelBuilder.Entity("Content.Server.Database.Round", b =>
  1275. {
  1276. b.Navigation("AdminLogs");
  1277. });
  1278. modelBuilder.Entity("Content.Server.Database.Server", b =>
  1279. {
  1280. b.Navigation("Rounds");
  1281. });
  1282. modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
  1283. {
  1284. b.Navigation("BanHits");
  1285. b.Navigation("Unban");
  1286. });
  1287. modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
  1288. {
  1289. b.Navigation("Unban");
  1290. });
  1291. #pragma warning restore 612, 618
  1292. }
  1293. }
  1294. }