git.smokeofanarchy.ru Git - space-station-14.git/blob

   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
   9 #nullable disable
  10
  11 namespace Content.Server.Database.Migrations.Sqlite
  12 {
  13     [DbContext(typeof(SqliteServerDbContext))]
  14     [Migration("20230725193058_AdminNotesImprovementsForeignKeys")]
  15     partial class AdminNotesImprovementsForeignKeys
  16     {
  17 #if EF_DESIGNER
  18         /// <inheritdoc />
  19         protected override void BuildTargetModel(ModelBuilder modelBuilder)
  20         {
  21 #pragma warning disable 612, 618
  22             modelBuilder.HasAnnotation("ProductVersion", "7.0.4");
  23
  24             modelBuilder.Entity("Content.Server.Database.Admin", b =>
  25                 {
  26                     b.Property<Guid>("UserId")
  27                         .ValueGeneratedOnAdd()
  28                         .HasColumnType("TEXT")
  29                         .HasColumnName("user_id");
  30
  31                     b.Property<int?>("AdminRankId")
  32                         .HasColumnType("INTEGER")
  33                         .HasColumnName("admin_rank_id");
  34
  35                     b.Property<string>("Title")
  36                         .HasColumnType("TEXT")
  37                         .HasColumnName("title");
  38
  39                     b.HasKey("UserId")
  40                         .HasName("PK_admin");
  41
  42                     b.HasIndex("AdminRankId")
  43                         .HasDatabaseName("IX_admin_admin_rank_id");
  44
  45                     b.ToTable("admin", (string)null);
  46                 });
  47
  48             modelBuilder.Entity("Content.Server.Database.AdminFlag", b =>
  49                 {
  50                     b.Property<int>("Id")
  51                         .ValueGeneratedOnAdd()
  52                         .HasColumnType("INTEGER")
  53                         .HasColumnName("admin_flag_id");
  54
  55                     b.Property<Guid>("AdminId")
  56                         .HasColumnType("TEXT")
  57                         .HasColumnName("admin_id");
  58
  59                     b.Property<string>("Flag")
  60                         .IsRequired()
  61                         .HasColumnType("TEXT")
  62                         .HasColumnName("flag");
  63
  64                     b.Property<bool>("Negative")
  65                         .HasColumnType("INTEGER")
  66                         .HasColumnName("negative");
  67
  68                     b.HasKey("Id")
  69                         .HasName("PK_admin_flag");
  70
  71                     b.HasIndex("AdminId")
  72                         .HasDatabaseName("IX_admin_flag_admin_id");
  73
  74                     b.HasIndex("Flag", "AdminId")
  75                         .IsUnique();
  76
  77                     b.ToTable("admin_flag", (string)null);
  78                 });
  79
  80             modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
  81                 {
  82                     b.Property<int>("Id")
  83                         .ValueGeneratedOnAdd()
  84                         .HasColumnType("INTEGER")
  85                         .HasColumnName("admin_log_id");
  86
  87                     b.Property<int>("RoundId")
  88                         .HasColumnType("INTEGER")
  89                         .HasColumnName("round_id");
  90
  91                     b.Property<DateTime>("Date")
  92                         .HasColumnType("TEXT")
  93                         .HasColumnName("date");
  94
  95                     b.Property<sbyte>("Impact")
  96                         .HasColumnType("INTEGER")
  97                         .HasColumnName("impact");
  98
  99                     b.Property<string>("Json")
 100                         .IsRequired()
 101                         .HasColumnType("jsonb")
 102                         .HasColumnName("json");
 103
 104                     b.Property<string>("Message")
 105                         .IsRequired()
 106                         .HasColumnType("TEXT")
 107                         .HasColumnName("message");
 108
 109                     b.Property<int>("Type")
 110                         .HasColumnType("INTEGER")
 111                         .HasColumnName("type");
 112
 113                     b.HasKey("Id", "RoundId")
 114                         .HasName("PK_admin_log");
 115
 116                     b.HasIndex("Date");
 117
 118                     b.HasIndex("RoundId")
 119                         .HasDatabaseName("IX_admin_log_round_id");
 120
 121                     b.HasIndex("Type")
 122                         .HasDatabaseName("IX_admin_log_type");
 123
 124                     b.ToTable("admin_log", (string)null);
 125                 });
 126
 127             modelBuilder.Entity("Content.Server.Database.AdminLogEntity", b =>
 128                 {
 129                     b.Property<int>("Uid")
 130                         .ValueGeneratedOnAdd()
 131                         .HasColumnType("INTEGER")
 132                         .HasColumnName("uid");
 133
 134                     b.Property<int?>("AdminLogId")
 135                         .HasColumnType("INTEGER")
 136                         .HasColumnName("admin_log_id");
 137
 138                     b.Property<int?>("AdminLogRoundId")
 139                         .HasColumnType("INTEGER")
 140                         .HasColumnName("admin_log_round_id");
 141
 142                     b.Property<string>("Name")
 143                         .HasColumnType("TEXT")
 144                         .HasColumnName("name");
 145
 146                     b.HasKey("Uid")
 147                         .HasName("PK_admin_log_entity");
 148
 149                     b.HasIndex("AdminLogId", "AdminLogRoundId")
 150                         .HasDatabaseName("IX_admin_log_entity_admin_log_id_admin_log_round_id");
 151
 152                     b.ToTable("admin_log_entity", (string)null);
 153                 });
 154
 155             modelBuilder.Entity("Content.Server.Database.AdminLogPlayer", b =>
 156                 {
 157                     b.Property<Guid>("PlayerUserId")
 158                         .HasColumnType("TEXT")
 159                         .HasColumnName("player_user_id");
 160
 161                     b.Property<int>("LogId")
 162                         .HasColumnType("INTEGER")
 163                         .HasColumnName("log_id");
 164
 165                     b.Property<int>("RoundId")
 166                         .HasColumnType("INTEGER")
 167                         .HasColumnName("round_id");
 168
 169                     b.HasKey("PlayerUserId", "LogId", "RoundId")
 170                         .HasName("PK_admin_log_player");
 171
 172                     b.HasIndex("LogId", "RoundId");
 173
 174                     b.ToTable("admin_log_player", (string)null);
 175                 });
 176
 177             modelBuilder.Entity("Content.Server.Database.AdminMessage", b =>
 178                 {
 179                     b.Property<int>("Id")
 180                         .ValueGeneratedOnAdd()
 181                         .HasColumnType("INTEGER")
 182                         .HasColumnName("admin_messages_id");
 183
 184                     b.Property<DateTime>("CreatedAt")
 185                         .HasColumnType("TEXT")
 186                         .HasColumnName("created_at");
 187
 188                     b.Property<Guid?>("CreatedById")
 189                         .HasColumnType("TEXT")
 190                         .HasColumnName("created_by_id");
 191
 192                     b.Property<bool>("Deleted")
 193                         .HasColumnType("INTEGER")
 194                         .HasColumnName("deleted");
 195
 196                     b.Property<DateTime?>("DeletedAt")
 197                         .HasColumnType("TEXT")
 198                         .HasColumnName("deleted_at");
 199
 200                     b.Property<Guid?>("DeletedById")
 201                         .HasColumnType("TEXT")
 202                         .HasColumnName("deleted_by_id");
 203
 204                     b.Property<DateTime?>("ExpirationTime")
 205                         .HasColumnType("TEXT")
 206                         .HasColumnName("expiration_time");
 207
 208                     b.Property<DateTime?>("LastEditedAt")
 209                         .HasColumnType("TEXT")
 210                         .HasColumnName("last_edited_at");
 211
 212                     b.Property<Guid?>("LastEditedById")
 213                         .HasColumnType("TEXT")
 214                         .HasColumnName("last_edited_by_id");
 215
 216                     b.Property<string>("Message")
 217                         .IsRequired()
 218                         .HasMaxLength(4096)
 219                         .HasColumnType("TEXT")
 220                         .HasColumnName("message");
 221
 222                     b.Property<Guid?>("PlayerUserId")
 223                         .HasColumnType("TEXT")
 224                         .HasColumnName("player_user_id");
 225
 226                     b.Property<TimeSpan>("PlaytimeAtNote")
 227                         .HasColumnType("TEXT")
 228                         .HasColumnName("playtime_at_note");
 229
 230                     b.Property<int?>("RoundId")
 231                         .HasColumnType("INTEGER")
 232                         .HasColumnName("round_id");
 233
 234                     b.Property<bool>("Seen")
 235                         .HasColumnType("INTEGER")
 236                         .HasColumnName("seen");
 237
 238                     b.HasKey("Id")
 239                         .HasName("PK_admin_messages");
 240
 241                     b.HasIndex("CreatedById");
 242
 243                     b.HasIndex("DeletedById");
 244
 245                     b.HasIndex("LastEditedById");
 246
 247                     b.HasIndex("PlayerUserId")
 248                         .HasDatabaseName("IX_admin_messages_player_user_id");
 249
 250                     b.HasIndex("RoundId")
 251                         .HasDatabaseName("IX_admin_messages_round_id");
 252
 253                     b.ToTable("admin_messages", (string)null);
 254                 });
 255
 256             modelBuilder.Entity("Content.Server.Database.AdminNote", b =>
 257                 {
 258                     b.Property<int>("Id")
 259                         .ValueGeneratedOnAdd()
 260                         .HasColumnType("INTEGER")
 261                         .HasColumnName("admin_notes_id");
 262
 263                     b.Property<DateTime>("CreatedAt")
 264                         .HasColumnType("TEXT")
 265                         .HasColumnName("created_at");
 266
 267                     b.Property<Guid?>("CreatedById")
 268                         .HasColumnType("TEXT")
 269                         .HasColumnName("created_by_id");
 270
 271                     b.Property<bool>("Deleted")
 272                         .HasColumnType("INTEGER")
 273                         .HasColumnName("deleted");
 274
 275                     b.Property<DateTime?>("DeletedAt")
 276                         .HasColumnType("TEXT")
 277                         .HasColumnName("deleted_at");
 278
 279                     b.Property<Guid?>("DeletedById")
 280                         .HasColumnType("TEXT")
 281                         .HasColumnName("deleted_by_id");
 282
 283                     b.Property<DateTime?>("ExpirationTime")
 284                         .HasColumnType("TEXT")
 285                         .HasColumnName("expiration_time");
 286
 287                     b.Property<DateTime?>("LastEditedAt")
 288                         .IsRequired()
 289                         .HasColumnType("TEXT")
 290                         .HasColumnName("last_edited_at");
 291
 292                     b.Property<Guid?>("LastEditedById")
 293                         .HasColumnType("TEXT")
 294                         .HasColumnName("last_edited_by_id");
 295
 296                     b.Property<string>("Message")
 297                         .IsRequired()
 298                         .HasMaxLength(4096)
 299                         .HasColumnType("TEXT")
 300                         .HasColumnName("message");
 301
 302                     b.Property<Guid?>("PlayerUserId")
 303                         .HasColumnType("TEXT")
 304                         .HasColumnName("player_user_id");
 305
 306                     b.Property<TimeSpan>("PlaytimeAtNote")
 307                         .HasColumnType("TEXT")
 308                         .HasColumnName("playtime_at_note");
 309
 310                     b.Property<int?>("RoundId")
 311                         .HasColumnType("INTEGER")
 312                         .HasColumnName("round_id");
 313
 314                     b.Property<bool>("Secret")
 315                         .HasColumnType("INTEGER")
 316                         .HasColumnName("secret");
 317
 318                     b.Property<int>("Severity")
 319                         .HasColumnType("INTEGER")
 320                         .HasColumnName("severity");
 321
 322                     b.HasKey("Id")
 323                         .HasName("PK_admin_notes");
 324
 325                     b.HasIndex("CreatedById");
 326
 327                     b.HasIndex("DeletedById");
 328
 329                     b.HasIndex("LastEditedById");
 330
 331                     b.HasIndex("PlayerUserId")
 332                         .HasDatabaseName("IX_admin_notes_player_user_id");
 333
 334                     b.HasIndex("RoundId")
 335                         .HasDatabaseName("IX_admin_notes_round_id");
 336
 337                     b.ToTable("admin_notes", (string)null);
 338                 });
 339
 340             modelBuilder.Entity("Content.Server.Database.AdminRank", b =>
 341                 {
 342                     b.Property<int>("Id")
 343                         .ValueGeneratedOnAdd()
 344                         .HasColumnType("INTEGER")
 345                         .HasColumnName("admin_rank_id");
 346
 347                     b.Property<string>("Name")
 348                         .IsRequired()
 349                         .HasColumnType("TEXT")
 350                         .HasColumnName("name");
 351
 352                     b.HasKey("Id")
 353                         .HasName("PK_admin_rank");
 354
 355                     b.ToTable("admin_rank", (string)null);
 356                 });
 357
 358             modelBuilder.Entity("Content.Server.Database.AdminRankFlag", b =>
 359                 {
 360                     b.Property<int>("Id")
 361                         .ValueGeneratedOnAdd()
 362                         .HasColumnType("INTEGER")
 363                         .HasColumnName("admin_rank_flag_id");
 364
 365                     b.Property<int>("AdminRankId")
 366                         .HasColumnType("INTEGER")
 367                         .HasColumnName("admin_rank_id");
 368
 369                     b.Property<string>("Flag")
 370                         .IsRequired()
 371                         .HasColumnType("TEXT")
 372                         .HasColumnName("flag");
 373
 374                     b.HasKey("Id")
 375                         .HasName("PK_admin_rank_flag");
 376
 377                     b.HasIndex("AdminRankId");
 378
 379                     b.HasIndex("Flag", "AdminRankId")
 380                         .IsUnique();
 381
 382                     b.ToTable("admin_rank_flag", (string)null);
 383                 });
 384
 385             modelBuilder.Entity("Content.Server.Database.AdminWatchlist", b =>
 386                 {
 387                     b.Property<int>("Id")
 388                         .ValueGeneratedOnAdd()
 389                         .HasColumnType("INTEGER")
 390                         .HasColumnName("admin_watchlists_id");
 391
 392                     b.Property<DateTime>("CreatedAt")
 393                         .HasColumnType("TEXT")
 394                         .HasColumnName("created_at");
 395
 396                     b.Property<Guid?>("CreatedById")
 397                         .HasColumnType("TEXT")
 398                         .HasColumnName("created_by_id");
 399
 400                     b.Property<bool>("Deleted")
 401                         .HasColumnType("INTEGER")
 402                         .HasColumnName("deleted");
 403
 404                     b.Property<DateTime?>("DeletedAt")
 405                         .HasColumnType("TEXT")
 406                         .HasColumnName("deleted_at");
 407
 408                     b.Property<Guid?>("DeletedById")
 409                         .HasColumnType("TEXT")
 410                         .HasColumnName("deleted_by_id");
 411
 412                     b.Property<DateTime?>("ExpirationTime")
 413                         .HasColumnType("TEXT")
 414                         .HasColumnName("expiration_time");
 415
 416                     b.Property<DateTime?>("LastEditedAt")
 417                         .IsRequired()
 418                         .HasColumnType("TEXT")
 419                         .HasColumnName("last_edited_at");
 420
 421                     b.Property<Guid?>("LastEditedById")
 422                         .HasColumnType("TEXT")
 423                         .HasColumnName("last_edited_by_id");
 424
 425                     b.Property<string>("Message")
 426                         .IsRequired()
 427                         .HasMaxLength(4096)
 428                         .HasColumnType("TEXT")
 429                         .HasColumnName("message");
 430
 431                     b.Property<Guid?>("PlayerUserId")
 432                         .HasColumnType("TEXT")
 433                         .HasColumnName("player_user_id");
 434
 435                     b.Property<TimeSpan>("PlaytimeAtNote")
 436                         .HasColumnType("TEXT")
 437                         .HasColumnName("playtime_at_note");
 438
 439                     b.Property<int?>("RoundId")
 440                         .HasColumnType("INTEGER")
 441                         .HasColumnName("round_id");
 442
 443                     b.HasKey("Id")
 444                         .HasName("PK_admin_watchlists");
 445
 446                     b.HasIndex("CreatedById");
 447
 448                     b.HasIndex("DeletedById");
 449
 450                     b.HasIndex("LastEditedById");
 451
 452                     b.HasIndex("PlayerUserId")
 453                         .HasDatabaseName("IX_admin_watchlists_player_user_id");
 454
 455                     b.HasIndex("RoundId")
 456                         .HasDatabaseName("IX_admin_watchlists_round_id");
 457
 458                     b.ToTable("admin_watchlists", (string)null);
 459                 });
 460
 461             modelBuilder.Entity("Content.Server.Database.Antag", b =>
 462                 {
 463                     b.Property<int>("Id")
 464                         .ValueGeneratedOnAdd()
 465                         .HasColumnType("INTEGER")
 466                         .HasColumnName("antag_id");
 467
 468                     b.Property<string>("AntagName")
 469                         .IsRequired()
 470                         .HasColumnType("TEXT")
 471                         .HasColumnName("antag_name");
 472
 473                     b.Property<int>("ProfileId")
 474                         .HasColumnType("INTEGER")
 475                         .HasColumnName("profile_id");
 476
 477                     b.HasKey("Id")
 478                         .HasName("PK_antag");
 479
 480                     b.HasIndex("ProfileId", "AntagName")
 481                         .IsUnique();
 482
 483                     b.ToTable("antag", (string)null);
 484                 });
 485
 486             modelBuilder.Entity("Content.Server.Database.AssignedUserId", b =>
 487                 {
 488                     b.Property<int>("Id")
 489                         .ValueGeneratedOnAdd()
 490                         .HasColumnType("INTEGER")
 491                         .HasColumnName("assigned_user_id_id");
 492
 493                     b.Property<Guid>("UserId")
 494                         .HasColumnType("TEXT")
 495                         .HasColumnName("user_id");
 496
 497                     b.Property<string>("UserName")
 498                         .IsRequired()
 499                         .HasColumnType("TEXT")
 500                         .HasColumnName("user_name");
 501
 502                     b.HasKey("Id")
 503                         .HasName("PK_assigned_user_id");
 504
 505                     b.HasIndex("UserId")
 506                         .IsUnique();
 507
 508                     b.HasIndex("UserName")
 509                         .IsUnique();
 510
 511                     b.ToTable("assigned_user_id", (string)null);
 512                 });
 513
 514             modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
 515                 {
 516                     b.Property<int>("Id")
 517                         .ValueGeneratedOnAdd()
 518                         .HasColumnType("INTEGER")
 519                         .HasColumnName("connection_log_id");
 520
 521                     b.Property<string>("Address")
 522                         .IsRequired()
 523                         .HasColumnType("TEXT")
 524                         .HasColumnName("address");
 525
 526                     b.Property<byte?>("Denied")
 527                         .HasColumnType("INTEGER")
 528                         .HasColumnName("denied");
 529
 530                     b.Property<byte[]>("HWId")
 531                         .HasColumnType("BLOB")
 532                         .HasColumnName("hwid");
 533
 534                     b.Property<DateTime>("Time")
 535                         .HasColumnType("TEXT")
 536                         .HasColumnName("time");
 537
 538                     b.Property<Guid>("UserId")
 539                         .HasColumnType("TEXT")
 540                         .HasColumnName("user_id");
 541
 542                     b.Property<string>("UserName")
 543                         .IsRequired()
 544                         .HasColumnType("TEXT")
 545                         .HasColumnName("user_name");
 546
 547                     b.HasKey("Id")
 548                         .HasName("PK_connection_log");
 549
 550                     b.HasIndex("UserId");
 551
 552                     b.ToTable("connection_log", (string)null);
 553                 });
 554
 555             modelBuilder.Entity("Content.Server.Database.Job", b =>
 556                 {
 557                     b.Property<int>("Id")
 558                         .ValueGeneratedOnAdd()
 559                         .HasColumnType("INTEGER")
 560                         .HasColumnName("job_id");
 561
 562                     b.Property<string>("JobName")
 563                         .IsRequired()
 564                         .HasColumnType("TEXT")
 565                         .HasColumnName("job_name");
 566
 567                     b.Property<int>("Priority")
 568                         .HasColumnType("INTEGER")
 569                         .HasColumnName("priority");
 570
 571                     b.Property<int>("ProfileId")
 572                         .HasColumnType("INTEGER")
 573                         .HasColumnName("profile_id");
 574
 575                     b.HasKey("Id")
 576                         .HasName("PK_job");
 577
 578                     b.HasIndex("ProfileId");
 579
 580                     b.HasIndex("ProfileId", "JobName")
 581                         .IsUnique();
 582
 583                     b.HasIndex(new[] { "ProfileId" }, "IX_job_one_high_priority")
 584                         .IsUnique()
 585                         .HasFilter("priority = 3");
 586
 587                     b.ToTable("job", (string)null);
 588                 });
 589
 590             modelBuilder.Entity("Content.Server.Database.PlayTime", b =>
 591                 {
 592                     b.Property<int>("Id")
 593                         .ValueGeneratedOnAdd()
 594                         .HasColumnType("INTEGER")
 595                         .HasColumnName("play_time_id");
 596
 597                     b.Property<Guid>("PlayerId")
 598                         .HasColumnType("TEXT")
 599                         .HasColumnName("player_id");
 600
 601                     b.Property<TimeSpan>("TimeSpent")
 602                         .HasColumnType("TEXT")
 603                         .HasColumnName("time_spent");
 604
 605                     b.Property<string>("Tracker")
 606                         .IsRequired()
 607                         .HasColumnType("TEXT")
 608                         .HasColumnName("tracker");
 609
 610                     b.HasKey("Id")
 611                         .HasName("PK_play_time");
 612
 613                     b.HasIndex("PlayerId", "Tracker")
 614                         .IsUnique();
 615
 616                     b.ToTable("play_time", (string)null);
 617                 });
 618
 619             modelBuilder.Entity("Content.Server.Database.Player", b =>
 620                 {
 621                     b.Property<int>("Id")
 622                         .ValueGeneratedOnAdd()
 623                         .HasColumnType("INTEGER")
 624                         .HasColumnName("player_id");
 625
 626                     b.Property<DateTime>("FirstSeenTime")
 627                         .HasColumnType("TEXT")
 628                         .HasColumnName("first_seen_time");
 629
 630                     b.Property<DateTime?>("LastReadRules")
 631                         .HasColumnType("TEXT")
 632                         .HasColumnName("last_read_rules");
 633
 634                     b.Property<string>("LastSeenAddress")
 635                         .IsRequired()
 636                         .HasColumnType("TEXT")
 637                         .HasColumnName("last_seen_address");
 638
 639                     b.Property<byte[]>("LastSeenHWId")
 640                         .HasColumnType("BLOB")
 641                         .HasColumnName("last_seen_hwid");
 642
 643                     b.Property<DateTime>("LastSeenTime")
 644                         .HasColumnType("TEXT")
 645                         .HasColumnName("last_seen_time");
 646
 647                     b.Property<string>("LastSeenUserName")
 648                         .IsRequired()
 649                         .HasColumnType("TEXT")
 650                         .HasColumnName("last_seen_user_name");
 651
 652                     b.Property<Guid>("UserId")
 653                         .HasColumnType("TEXT")
 654                         .HasColumnName("user_id");
 655
 656                     b.HasKey("Id")
 657                         .HasName("PK_player");
 658
 659                     b.HasAlternateKey("UserId")
 660                         .HasName("ak_player_user_id");
 661
 662                     b.HasIndex("LastSeenUserName");
 663
 664                     b.HasIndex("UserId")
 665                         .IsUnique();
 666
 667                     b.ToTable("player", (string)null);
 668                 });
 669
 670             modelBuilder.Entity("Content.Server.Database.Preference", b =>
 671                 {
 672                     b.Property<int>("Id")
 673                         .ValueGeneratedOnAdd()
 674                         .HasColumnType("INTEGER")
 675                         .HasColumnName("preference_id");
 676
 677                     b.Property<string>("AdminOOCColor")
 678                         .IsRequired()
 679                         .HasColumnType("TEXT")
 680                         .HasColumnName("admin_ooc_color");
 681
 682                     b.Property<int>("SelectedCharacterSlot")
 683                         .HasColumnType("INTEGER")
 684                         .HasColumnName("selected_character_slot");
 685
 686                     b.Property<Guid>("UserId")
 687                         .HasColumnType("TEXT")
 688                         .HasColumnName("user_id");
 689
 690                     b.HasKey("Id")
 691                         .HasName("PK_preference");
 692
 693                     b.HasIndex("UserId")
 694                         .IsUnique();
 695
 696                     b.ToTable("preference", (string)null);
 697                 });
 698
 699             modelBuilder.Entity("Content.Server.Database.Profile", b =>
 700                 {
 701                     b.Property<int>("Id")
 702                         .ValueGeneratedOnAdd()
 703                         .HasColumnType("INTEGER")
 704                         .HasColumnName("profile_id");
 705
 706                     b.Property<int>("Age")
 707                         .HasColumnType("INTEGER")
 708                         .HasColumnName("age");
 709
 710                     b.Property<string>("Backpack")
 711                         .IsRequired()
 712                         .HasColumnType("TEXT")
 713                         .HasColumnName("backpack");
 714
 715                     b.Property<string>("CharacterName")
 716                         .IsRequired()
 717                         .HasColumnType("TEXT")
 718                         .HasColumnName("char_name");
 719
 720                     b.Property<string>("Clothing")
 721                         .IsRequired()
 722                         .HasColumnType("TEXT")
 723                         .HasColumnName("clothing");
 724
 725                     b.Property<string>("EyeColor")
 726                         .IsRequired()
 727                         .HasColumnType("TEXT")
 728                         .HasColumnName("eye_color");
 729
 730                     b.Property<string>("FacialHairColor")
 731                         .IsRequired()
 732                         .HasColumnType("TEXT")
 733                         .HasColumnName("facial_hair_color");
 734
 735                     b.Property<string>("FacialHairName")
 736                         .IsRequired()
 737                         .HasColumnType("TEXT")
 738                         .HasColumnName("facial_hair_name");
 739
 740                     b.Property<string>("FlavorText")
 741                         .IsRequired()
 742                         .HasColumnType("TEXT")
 743                         .HasColumnName("flavor_text");
 744
 745                     b.Property<string>("Gender")
 746                         .IsRequired()
 747                         .HasColumnType("TEXT")
 748                         .HasColumnName("gender");
 749
 750                     b.Property<string>("HairColor")
 751                         .IsRequired()
 752                         .HasColumnType("TEXT")
 753                         .HasColumnName("hair_color");
 754
 755                     b.Property<string>("HairName")
 756                         .IsRequired()
 757                         .HasColumnType("TEXT")
 758                         .HasColumnName("hair_name");
 759
 760                     b.Property<byte[]>("Markings")
 761                         .HasColumnType("jsonb")
 762                         .HasColumnName("markings");
 763
 764                     b.Property<int>("PreferenceId")
 765                         .HasColumnType("INTEGER")
 766                         .HasColumnName("preference_id");
 767
 768                     b.Property<int>("PreferenceUnavailable")
 769                         .HasColumnType("INTEGER")
 770                         .HasColumnName("pref_unavailable");
 771
 772                     b.Property<string>("Sex")
 773                         .IsRequired()
 774                         .HasColumnType("TEXT")
 775                         .HasColumnName("sex");
 776
 777                     b.Property<string>("SkinColor")
 778                         .IsRequired()
 779                         .HasColumnType("TEXT")
 780                         .HasColumnName("skin_color");
 781
 782                     b.Property<int>("Slot")
 783                         .HasColumnType("INTEGER")
 784                         .HasColumnName("slot");
 785
 786                     b.Property<string>("Species")
 787                         .IsRequired()
 788                         .HasColumnType("TEXT")
 789                         .HasColumnName("species");
 790
 791                     b.HasKey("Id")
 792                         .HasName("PK_profile");
 793
 794                     b.HasIndex("PreferenceId")
 795                         .HasDatabaseName("IX_profile_preference_id");
 796
 797                     b.HasIndex("Slot", "PreferenceId")
 798                         .IsUnique();
 799
 800                     b.ToTable("profile", (string)null);
 801                 });
 802
 803             modelBuilder.Entity("Content.Server.Database.Round", b =>
 804                 {
 805                     b.Property<int>("Id")
 806                         .ValueGeneratedOnAdd()
 807                         .HasColumnType("INTEGER")
 808                         .HasColumnName("round_id");
 809
 810                     b.Property<int>("ServerId")
 811                         .HasColumnType("INTEGER")
 812                         .HasColumnName("server_id");
 813
 814                     b.HasKey("Id")
 815                         .HasName("PK_round");
 816
 817                     b.HasIndex("ServerId")
 818                         .HasDatabaseName("IX_round_server_id");
 819
 820                     b.ToTable("round", (string)null);
 821                 });
 822
 823             modelBuilder.Entity("Content.Server.Database.Server", b =>
 824                 {
 825                     b.Property<int>("Id")
 826                         .ValueGeneratedOnAdd()
 827                         .HasColumnType("INTEGER")
 828                         .HasColumnName("server_id");
 829
 830                     b.Property<string>("Name")
 831                         .IsRequired()
 832                         .HasColumnType("TEXT")
 833                         .HasColumnName("name");
 834
 835                     b.HasKey("Id")
 836                         .HasName("PK_server");
 837
 838                     b.ToTable("server", (string)null);
 839                 });
 840
 841             modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
 842                 {
 843                     b.Property<int>("Id")
 844                         .ValueGeneratedOnAdd()
 845                         .HasColumnType("INTEGER")
 846                         .HasColumnName("server_ban_id");
 847
 848                     b.Property<string>("Address")
 849                         .HasColumnType("TEXT")
 850                         .HasColumnName("address");
 851
 852                     b.Property<bool>("AutoDelete")
 853                         .HasColumnType("INTEGER")
 854                         .HasColumnName("auto_delete");
 855
 856                     b.Property<DateTime>("BanTime")
 857                         .HasColumnType("TEXT")
 858                         .HasColumnName("ban_time");
 859
 860                     b.Property<Guid?>("BanningAdmin")
 861                         .HasColumnType("TEXT")
 862                         .HasColumnName("banning_admin");
 863
 864                     b.Property<int>("ExemptFlags")
 865                         .HasColumnType("INTEGER")
 866                         .HasColumnName("exempt_flags");
 867
 868                     b.Property<DateTime?>("ExpirationTime")
 869                         .HasColumnType("TEXT")
 870                         .HasColumnName("expiration_time");
 871
 872                     b.Property<byte[]>("HWId")
 873                         .HasColumnType("BLOB")
 874                         .HasColumnName("hwid");
 875
 876                     b.Property<bool>("Hidden")
 877                         .HasColumnType("INTEGER")
 878                         .HasColumnName("hidden");
 879
 880                     b.Property<DateTime?>("LastEditedAt")
 881                         .HasColumnType("TEXT")
 882                         .HasColumnName("last_edited_at");
 883
 884                     b.Property<Guid?>("LastEditedById")
 885                         .HasColumnType("TEXT")
 886                         .HasColumnName("last_edited_by_id");
 887
 888                     b.Property<Guid?>("PlayerUserId")
 889                         .HasColumnType("TEXT")
 890                         .HasColumnName("player_user_id");
 891
 892                     b.Property<TimeSpan>("PlaytimeAtNote")
 893                         .HasColumnType("TEXT")
 894                         .HasColumnName("playtime_at_note");
 895
 896                     b.Property<string>("Reason")
 897                         .IsRequired()
 898                         .HasColumnType("TEXT")
 899                         .HasColumnName("reason");
 900
 901                     b.Property<int?>("RoundId")
 902                         .HasColumnType("INTEGER")
 903                         .HasColumnName("round_id");
 904
 905                     b.Property<int>("Severity")
 906                         .HasColumnType("INTEGER")
 907                         .HasColumnName("severity");
 908
 909                     b.HasKey("Id")
 910                         .HasName("PK_server_ban");
 911
 912                     b.HasIndex("Address");
 913
 914                     b.HasIndex("BanningAdmin");
 915
 916                     b.HasIndex("LastEditedById");
 917
 918                     b.HasIndex("PlayerUserId")
 919                         .HasDatabaseName("IX_server_ban_player_user_id");
 920
 921                     b.HasIndex("RoundId")
 922                         .HasDatabaseName("IX_server_ban_round_id");
 923
 924                     b.ToTable("server_ban", null, t =>
 925                         {
 926                             t.HasCheckConstraint("HaveEitherAddressOrUserIdOrHWId", "address IS NOT NULL OR player_user_id IS NOT NULL OR hwid IS NOT NULL");
 927                         });
 928                 });
 929
 930             modelBuilder.Entity("Content.Server.Database.ServerBanExemption", b =>
 931                 {
 932                     b.Property<Guid>("UserId")
 933                         .ValueGeneratedOnAdd()
 934                         .HasColumnType("TEXT")
 935                         .HasColumnName("user_id");
 936
 937                     b.Property<int>("Flags")
 938                         .HasColumnType("INTEGER")
 939                         .HasColumnName("flags");
 940
 941                     b.HasKey("UserId")
 942                         .HasName("PK_server_ban_exemption");
 943
 944                     b.ToTable("server_ban_exemption", null, t =>
 945                         {
 946                             t.HasCheckConstraint("FlagsNotZero", "flags != 0");
 947                         });
 948                 });
 949
 950             modelBuilder.Entity("Content.Server.Database.ServerBanHit", b =>
 951                 {
 952                     b.Property<int>("Id")
 953                         .ValueGeneratedOnAdd()
 954                         .HasColumnType("INTEGER")
 955                         .HasColumnName("server_ban_hit_id");
 956
 957                     b.Property<int>("BanId")
 958                         .HasColumnType("INTEGER")
 959                         .HasColumnName("ban_id");
 960
 961                     b.Property<int>("ConnectionId")
 962                         .HasColumnType("INTEGER")
 963                         .HasColumnName("connection_id");
 964
 965                     b.HasKey("Id")
 966                         .HasName("PK_server_ban_hit");
 967
 968                     b.HasIndex("BanId")
 969                         .HasDatabaseName("IX_server_ban_hit_ban_id");
 970
 971                     b.HasIndex("ConnectionId")
 972                         .HasDatabaseName("IX_server_ban_hit_connection_id");
 973
 974                     b.ToTable("server_ban_hit", (string)null);
 975                 });
 976
 977             modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
 978                 {
 979                     b.Property<int>("Id")
 980                         .ValueGeneratedOnAdd()
 981                         .HasColumnType("INTEGER")
 982                         .HasColumnName("server_role_ban_id");
 983
 984                     b.Property<string>("Address")
 985                         .HasColumnType("TEXT")
 986                         .HasColumnName("address");
 987
 988                     b.Property<DateTime>("BanTime")
 989                         .HasColumnType("TEXT")
 990                         .HasColumnName("ban_time");
 991
 992                     b.Property<Guid?>("BanningAdmin")
 993                         .HasColumnType("TEXT")
 994                         .HasColumnName("banning_admin");
 995
 996                     b.Property<DateTime?>("ExpirationTime")
 997                         .HasColumnType("TEXT")
 998                         .HasColumnName("expiration_time");
 999
1000                     b.Property<byte[]>("HWId")
1001                         .HasColumnType("BLOB")
1002                         .HasColumnName("hwid");
1003
1004                     b.Property<bool>("Hidden")
1005                         .HasColumnType("INTEGER")
1006                         .HasColumnName("hidden");
1007
1008                     b.Property<DateTime?>("LastEditedAt")
1009                         .HasColumnType("TEXT")
1010                         .HasColumnName("last_edited_at");
1011
1012                     b.Property<Guid?>("LastEditedById")
1013                         .HasColumnType("TEXT")
1014                         .HasColumnName("last_edited_by_id");
1015
1016                     b.Property<Guid?>("PlayerUserId")
1017                         .HasColumnType("TEXT")
1018                         .HasColumnName("player_user_id");
1019
1020                     b.Property<TimeSpan>("PlaytimeAtNote")
1021                         .HasColumnType("TEXT")
1022                         .HasColumnName("playtime_at_note");
1023
1024                     b.Property<string>("Reason")
1025                         .IsRequired()
1026                         .HasColumnType("TEXT")
1027                         .HasColumnName("reason");
1028
1029                     b.Property<string>("RoleId")
1030                         .IsRequired()
1031                         .HasColumnType("TEXT")
1032                         .HasColumnName("role_id");
1033
1034                     b.Property<int?>("RoundId")
1035                         .HasColumnType("INTEGER")
1036                         .HasColumnName("round_id");
1037
1038                     b.Property<int>("Severity")
1039                         .HasColumnType("INTEGER")
1040                         .HasColumnName("severity");
1041
1042                     b.HasKey("Id")
1043                         .HasName("PK_server_role_ban");
1044
1045                     b.HasIndex("Address");
1046
1047                     b.HasIndex("BanningAdmin");
1048
1049                     b.HasIndex("LastEditedById");
1050
1051                     b.HasIndex("PlayerUserId")
1052                         .HasDatabaseName("IX_server_role_ban_player_user_id");
1053
1054                     b.HasIndex("RoundId")
1055                         .HasDatabaseName("IX_server_role_ban_round_id");
1056
1057                     b.ToTable("server_role_ban", null, t =>
1058                         {
1059                             t.HasCheckConstraint("HaveEitherAddressOrUserIdOrHWId", "address IS NOT NULL OR player_user_id IS NOT NULL OR hwid IS NOT NULL");
1060                         });
1061                 });
1062
1063             modelBuilder.Entity("Content.Server.Database.ServerRoleUnban", b =>
1064                 {
1065                     b.Property<int>("Id")
1066                         .ValueGeneratedOnAdd()
1067                         .HasColumnType("INTEGER")
1068                         .HasColumnName("role_unban_id");
1069
1070                     b.Property<int>("BanId")
1071                         .HasColumnType("INTEGER")
1072                         .HasColumnName("ban_id");
1073
1074                     b.Property<DateTime>("UnbanTime")
1075                         .HasColumnType("TEXT")
1076                         .HasColumnName("unban_time");
1077
1078                     b.Property<Guid?>("UnbanningAdmin")
1079                         .HasColumnType("TEXT")
1080                         .HasColumnName("unbanning_admin");
1081
1082                     b.HasKey("Id")
1083                         .HasName("PK_server_role_unban");
1084
1085                     b.HasIndex("BanId")
1086                         .IsUnique();
1087
1088                     b.ToTable("server_role_unban", (string)null);
1089                 });
1090
1091             modelBuilder.Entity("Content.Server.Database.ServerUnban", b =>
1092                 {
1093                     b.Property<int>("Id")
1094                         .ValueGeneratedOnAdd()
1095                         .HasColumnType("INTEGER")
1096                         .HasColumnName("unban_id");
1097
1098                     b.Property<int>("BanId")
1099                         .HasColumnType("INTEGER")
1100                         .HasColumnName("ban_id");
1101
1102                     b.Property<DateTime>("UnbanTime")
1103                         .HasColumnType("TEXT")
1104                         .HasColumnName("unban_time");
1105
1106                     b.Property<Guid?>("UnbanningAdmin")
1107                         .HasColumnType("TEXT")
1108                         .HasColumnName("unbanning_admin");
1109
1110                     b.HasKey("Id")
1111                         .HasName("PK_server_unban");
1112
1113                     b.HasIndex("BanId")
1114                         .IsUnique();
1115
1116                     b.ToTable("server_unban", (string)null);
1117                 });
1118
1119             modelBuilder.Entity("Content.Server.Database.Trait", b =>
1120                 {
1121                     b.Property<int>("Id")
1122                         .ValueGeneratedOnAdd()
1123                         .HasColumnType("INTEGER")
1124                         .HasColumnName("trait_id");
1125
1126                     b.Property<int>("ProfileId")
1127                         .HasColumnType("INTEGER")
1128                         .HasColumnName("profile_id");
1129
1130                     b.Property<string>("TraitName")
1131                         .IsRequired()
1132                         .HasColumnType("TEXT")
1133                         .HasColumnName("trait_name");
1134
1135                     b.HasKey("Id")
1136                         .HasName("PK_trait");
1137
1138                     b.HasIndex("ProfileId", "TraitName")
1139                         .IsUnique();
1140
1141                     b.ToTable("trait", (string)null);
1142                 });
1143
1144             modelBuilder.Entity("Content.Server.Database.UploadedResourceLog", b =>
1145                 {
1146                     b.Property<int>("Id")
1147                         .ValueGeneratedOnAdd()
1148                         .HasColumnType("INTEGER")
1149                         .HasColumnName("uploaded_resource_log_id");
1150
1151                     b.Property<byte[]>("Data")
1152                         .IsRequired()
1153                         .HasColumnType("BLOB")
1154                         .HasColumnName("data");
1155
1156                     b.Property<DateTime>("Date")
1157                         .HasColumnType("TEXT")
1158                         .HasColumnName("date");
1159
1160                     b.Property<string>("Path")
1161                         .IsRequired()
1162                         .HasColumnType("TEXT")
1163                         .HasColumnName("path");
1164
1165                     b.Property<Guid>("UserId")
1166                         .HasColumnType("TEXT")
1167                         .HasColumnName("user_id");
1168
1169                     b.HasKey("Id")
1170                         .HasName("PK_uploaded_resource_log");
1171
1172                     b.ToTable("uploaded_resource_log", (string)null);
1173                 });
1174
1175             modelBuilder.Entity("Content.Server.Database.Whitelist", b =>
1176                 {
1177                     b.Property<Guid>("UserId")
1178                         .ValueGeneratedOnAdd()
1179                         .HasColumnType("TEXT")
1180                         .HasColumnName("user_id");
1181
1182                     b.HasKey("UserId")
1183                         .HasName("PK_whitelist");
1184
1185                     b.ToTable("whitelist", (string)null);
1186                 });
1187
1188             modelBuilder.Entity("PlayerRound", b =>
1189                 {
1190                     b.Property<int>("PlayersId")
1191                         .HasColumnType("INTEGER")
1192                         .HasColumnName("players_id");
1193
1194                     b.Property<int>("RoundsId")
1195                         .HasColumnType("INTEGER")
1196                         .HasColumnName("rounds_id");
1197
1198                     b.HasKey("PlayersId", "RoundsId")
1199                         .HasName("PK_player_round");
1200
1201                     b.HasIndex("RoundsId")
1202                         .HasDatabaseName("IX_player_round_rounds_id");
1203
1204                     b.ToTable("player_round", (string)null);
1205                 });
1206
1207             modelBuilder.Entity("Content.Server.Database.Admin", b =>
1208                 {
1209                     b.HasOne("Content.Server.Database.AdminRank", "AdminRank")
1210                         .WithMany("Admins")
1211                         .HasForeignKey("AdminRankId")
1212                         .OnDelete(DeleteBehavior.SetNull)
1213                         .HasConstraintName("FK_admin_admin_rank_admin_rank_id");
1214
1215                     b.Navigation("AdminRank");
1216                 });
1217
1218             modelBuilder.Entity("Content.Server.Database.AdminFlag", b =>
1219                 {
1220                     b.HasOne("Content.Server.Database.Admin", "Admin")
1221                         .WithMany("Flags")
1222                         .HasForeignKey("AdminId")
1223                         .OnDelete(DeleteBehavior.Cascade)
1224                         .IsRequired()
1225                         .HasConstraintName("FK_admin_flag_admin_admin_id");
1226
1227                     b.Navigation("Admin");
1228                 });
1229
1230             modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
1231                 {
1232                     b.HasOne("Content.Server.Database.Round", "Round")
1233                         .WithMany("AdminLogs")
1234                         .HasForeignKey("RoundId")
1235                         .OnDelete(DeleteBehavior.Cascade)
1236                         .IsRequired()
1237                         .HasConstraintName("FK_admin_log_round_round_id");
1238
1239                     b.Navigation("Round");
1240                 });
1241
1242             modelBuilder.Entity("Content.Server.Database.AdminLogEntity", b =>
1243                 {
1244                     b.HasOne("Content.Server.Database.AdminLog", null)
1245                         .WithMany("Entities")
1246                         .HasForeignKey("AdminLogId", "AdminLogRoundId")
1247                         .HasConstraintName("FK_admin_log_entity_admin_log_admin_log_id_admin_log_round_id");
1248                 });
1249
1250             modelBuilder.Entity("Content.Server.Database.AdminLogPlayer", b =>
1251                 {
1252                     b.HasOne("Content.Server.Database.Player", "Player")
1253                         .WithMany("AdminLogs")
1254                         .HasForeignKey("PlayerUserId")
1255                         .HasPrincipalKey("UserId")
1256                         .OnDelete(DeleteBehavior.Cascade)
1257                         .IsRequired()
1258                         .HasConstraintName("FK_admin_log_player_player_player_user_id");
1259
1260                     b.HasOne("Content.Server.Database.AdminLog", "Log")
1261                         .WithMany("Players")
1262                         .HasForeignKey("LogId", "RoundId")
1263                         .OnDelete(DeleteBehavior.Cascade)
1264                         .IsRequired()
1265                         .HasConstraintName("FK_admin_log_player_admin_log_log_id_round_id");
1266
1267                     b.Navigation("Log");
1268
1269                     b.Navigation("Player");
1270                 });
1271
1272             modelBuilder.Entity("Content.Server.Database.AdminMessage", b =>
1273                 {
1274                     b.HasOne("Content.Server.Database.Player", "CreatedBy")
1275                         .WithMany("AdminMessagesCreated")
1276                         .HasForeignKey("CreatedById")
1277                         .HasPrincipalKey("UserId")
1278                         .OnDelete(DeleteBehavior.SetNull)
1279                         .HasConstraintName("FK_admin_messages_player_created_by_id");
1280
1281                     b.HasOne("Content.Server.Database.Player", "DeletedBy")
1282                         .WithMany("AdminMessagesDeleted")
1283                         .HasForeignKey("DeletedById")
1284                         .HasPrincipalKey("UserId")
1285                         .OnDelete(DeleteBehavior.SetNull)
1286                         .HasConstraintName("FK_admin_messages_player_deleted_by_id");
1287
1288                     b.HasOne("Content.Server.Database.Player", "LastEditedBy")
1289                         .WithMany("AdminMessagesLastEdited")
1290                         .HasForeignKey("LastEditedById")
1291                         .HasPrincipalKey("UserId")
1292                         .OnDelete(DeleteBehavior.SetNull)
1293                         .HasConstraintName("FK_admin_messages_player_last_edited_by_id");
1294
1295                     b.HasOne("Content.Server.Database.Player", "Player")
1296                         .WithMany("AdminMessagesReceived")
1297                         .HasForeignKey("PlayerUserId")
1298                         .HasPrincipalKey("UserId")
1299                         .OnDelete(DeleteBehavior.Cascade)
1300                         .HasConstraintName("FK_admin_messages_player_player_user_id");
1301
1302                     b.HasOne("Content.Server.Database.Round", "Round")
1303                         .WithMany()
1304                         .HasForeignKey("RoundId")
1305                         .HasConstraintName("FK_admin_messages_round_round_id");
1306
1307                     b.Navigation("CreatedBy");
1308
1309                     b.Navigation("DeletedBy");
1310
1311                     b.Navigation("LastEditedBy");
1312
1313                     b.Navigation("Player");
1314
1315                     b.Navigation("Round");
1316                 });
1317
1318             modelBuilder.Entity("Content.Server.Database.AdminNote", b =>
1319                 {
1320                     b.HasOne("Content.Server.Database.Player", "CreatedBy")
1321                         .WithMany("AdminNotesCreated")
1322                         .HasForeignKey("CreatedById")
1323                         .HasPrincipalKey("UserId")
1324                         .OnDelete(DeleteBehavior.SetNull)
1325                         .HasConstraintName("FK_admin_notes_player_created_by_id");
1326
1327                     b.HasOne("Content.Server.Database.Player", "DeletedBy")
1328                         .WithMany("AdminNotesDeleted")
1329                         .HasForeignKey("DeletedById")
1330                         .HasPrincipalKey("UserId")
1331                         .OnDelete(DeleteBehavior.SetNull)
1332                         .HasConstraintName("FK_admin_notes_player_deleted_by_id");
1333
1334                     b.HasOne("Content.Server.Database.Player", "LastEditedBy")
1335                         .WithMany("AdminNotesLastEdited")
1336                         .HasForeignKey("LastEditedById")
1337                         .HasPrincipalKey("UserId")
1338                         .OnDelete(DeleteBehavior.SetNull)
1339                         .HasConstraintName("FK_admin_notes_player_last_edited_by_id");
1340
1341                     b.HasOne("Content.Server.Database.Player", "Player")
1342                         .WithMany("AdminNotesReceived")
1343                         .HasForeignKey("PlayerUserId")
1344                         .HasPrincipalKey("UserId")
1345                         .OnDelete(DeleteBehavior.Cascade)
1346                         .HasConstraintName("FK_admin_notes_player_player_user_id");
1347
1348                     b.HasOne("Content.Server.Database.Round", "Round")
1349                         .WithMany()
1350                         .HasForeignKey("RoundId")
1351                         .HasConstraintName("FK_admin_notes_round_round_id");
1352
1353                     b.Navigation("CreatedBy");
1354
1355                     b.Navigation("DeletedBy");
1356
1357                     b.Navigation("LastEditedBy");
1358
1359                     b.Navigation("Player");
1360
1361                     b.Navigation("Round");
1362                 });
1363
1364             modelBuilder.Entity("Content.Server.Database.AdminRankFlag", b =>
1365                 {
1366                     b.HasOne("Content.Server.Database.AdminRank", "Rank")
1367                         .WithMany("Flags")
1368                         .HasForeignKey("AdminRankId")
1369                         .OnDelete(DeleteBehavior.Cascade)
1370                         .IsRequired()
1371                         .HasConstraintName("FK_admin_rank_flag_admin_rank_admin_rank_id");
1372
1373                     b.Navigation("Rank");
1374                 });
1375
1376             modelBuilder.Entity("Content.Server.Database.AdminWatchlist", b =>
1377                 {
1378                     b.HasOne("Content.Server.Database.Player", "CreatedBy")
1379                         .WithMany("AdminWatchlistsCreated")
1380                         .HasForeignKey("CreatedById")
1381                         .HasPrincipalKey("UserId")
1382                         .OnDelete(DeleteBehavior.SetNull)
1383                         .HasConstraintName("FK_admin_watchlists_player_created_by_id");
1384
1385                     b.HasOne("Content.Server.Database.Player", "DeletedBy")
1386                         .WithMany("AdminWatchlistsDeleted")
1387                         .HasForeignKey("DeletedById")
1388                         .HasPrincipalKey("UserId")
1389                         .OnDelete(DeleteBehavior.SetNull)
1390                         .HasConstraintName("FK_admin_watchlists_player_deleted_by_id");
1391
1392                     b.HasOne("Content.Server.Database.Player", "LastEditedBy")
1393                         .WithMany("AdminWatchlistsLastEdited")
1394                         .HasForeignKey("LastEditedById")
1395                         .HasPrincipalKey("UserId")
1396                         .OnDelete(DeleteBehavior.SetNull)
1397                         .HasConstraintName("FK_admin_watchlists_player_last_edited_by_id");
1398
1399                     b.HasOne("Content.Server.Database.Player", "Player")
1400                         .WithMany("AdminWatchlistsReceived")
1401                         .HasForeignKey("PlayerUserId")
1402                         .HasPrincipalKey("UserId")
1403                         .OnDelete(DeleteBehavior.Cascade)
1404                         .HasConstraintName("FK_admin_watchlists_player_player_user_id");
1405
1406                     b.HasOne("Content.Server.Database.Round", "Round")
1407                         .WithMany()
1408                         .HasForeignKey("RoundId")
1409                         .HasConstraintName("FK_admin_watchlists_round_round_id");
1410
1411                     b.Navigation("CreatedBy");
1412
1413                     b.Navigation("DeletedBy");
1414
1415                     b.Navigation("LastEditedBy");
1416
1417                     b.Navigation("Player");
1418
1419                     b.Navigation("Round");
1420                 });
1421
1422             modelBuilder.Entity("Content.Server.Database.Antag", b =>
1423                 {
1424                     b.HasOne("Content.Server.Database.Profile", "Profile")
1425                         .WithMany("Antags")
1426                         .HasForeignKey("ProfileId")
1427                         .OnDelete(DeleteBehavior.Cascade)
1428                         .IsRequired()
1429                         .HasConstraintName("FK_antag_profile_profile_id");
1430
1431                     b.Navigation("Profile");
1432                 });
1433
1434             modelBuilder.Entity("Content.Server.Database.Job", b =>
1435                 {
1436                     b.HasOne("Content.Server.Database.Profile", "Profile")
1437                         .WithMany("Jobs")
1438                         .HasForeignKey("ProfileId")
1439                         .OnDelete(DeleteBehavior.Cascade)
1440                         .IsRequired()
1441                         .HasConstraintName("FK_job_profile_profile_id");
1442
1443                     b.Navigation("Profile");
1444                 });
1445
1446             modelBuilder.Entity("Content.Server.Database.Profile", b =>
1447                 {
1448                     b.HasOne("Content.Server.Database.Preference", "Preference")
1449                         .WithMany("Profiles")
1450                         .HasForeignKey("PreferenceId")
1451                         .OnDelete(DeleteBehavior.Cascade)
1452                         .IsRequired()
1453                         .HasConstraintName("FK_profile_preference_preference_id");
1454
1455                     b.Navigation("Preference");
1456                 });
1457
1458             modelBuilder.Entity("Content.Server.Database.Round", b =>
1459                 {
1460                     b.HasOne("Content.Server.Database.Server", "Server")
1461                         .WithMany("Rounds")
1462                         .HasForeignKey("ServerId")
1463                         .OnDelete(DeleteBehavior.Cascade)
1464                         .IsRequired()
1465                         .HasConstraintName("FK_round_server_server_id");
1466
1467                     b.Navigation("Server");
1468                 });
1469
1470             modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
1471                 {
1472                     b.HasOne("Content.Server.Database.Player", "CreatedBy")
1473                         .WithMany("AdminServerBansCreated")
1474                         .HasForeignKey("BanningAdmin")
1475                         .HasPrincipalKey("UserId")
1476                         .OnDelete(DeleteBehavior.SetNull)
1477                         .HasConstraintName("FK_server_ban_player_banning_admin");
1478
1479                     b.HasOne("Content.Server.Database.Player", "LastEditedBy")
1480                         .WithMany("AdminServerBansLastEdited")
1481                         .HasForeignKey("LastEditedById")
1482                         .HasPrincipalKey("UserId")
1483                         .OnDelete(DeleteBehavior.SetNull)
1484                         .HasConstraintName("FK_server_ban_player_last_edited_by_id");
1485
1486                     b.HasOne("Content.Server.Database.Round", "Round")
1487                         .WithMany()
1488                         .HasForeignKey("RoundId")
1489                         .HasConstraintName("FK_server_ban_round_round_id");
1490
1491                     b.Navigation("CreatedBy");
1492
1493                     b.Navigation("LastEditedBy");
1494
1495                     b.Navigation("Round");
1496                 });
1497
1498             modelBuilder.Entity("Content.Server.Database.ServerBanHit", b =>
1499                 {
1500                     b.HasOne("Content.Server.Database.ServerBan", "Ban")
1501                         .WithMany("BanHits")
1502                         .HasForeignKey("BanId")
1503                         .OnDelete(DeleteBehavior.Cascade)
1504                         .IsRequired()
1505                         .HasConstraintName("FK_server_ban_hit_server_ban_ban_id");
1506
1507                     b.HasOne("Content.Server.Database.ConnectionLog", "Connection")
1508                         .WithMany("BanHits")
1509                         .HasForeignKey("ConnectionId")
1510                         .OnDelete(DeleteBehavior.Cascade)
1511                         .IsRequired()
1512                         .HasConstraintName("FK_server_ban_hit_connection_log_connection_id");
1513
1514                     b.Navigation("Ban");
1515
1516                     b.Navigation("Connection");
1517                 });
1518
1519             modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
1520                 {
1521                     b.HasOne("Content.Server.Database.Player", "CreatedBy")
1522                         .WithMany("AdminServerRoleBansCreated")
1523                         .HasForeignKey("BanningAdmin")
1524                         .HasPrincipalKey("UserId")
1525                         .OnDelete(DeleteBehavior.SetNull)
1526                         .HasConstraintName("FK_server_role_ban_player_banning_admin");
1527
1528                     b.HasOne("Content.Server.Database.Player", "LastEditedBy")
1529                         .WithMany("AdminServerRoleBansLastEdited")
1530                         .HasForeignKey("LastEditedById")
1531                         .HasPrincipalKey("UserId")
1532                         .OnDelete(DeleteBehavior.SetNull)
1533                         .HasConstraintName("FK_server_role_ban_player_last_edited_by_id");
1534
1535                     b.HasOne("Content.Server.Database.Round", "Round")
1536                         .WithMany()
1537                         .HasForeignKey("RoundId")
1538                         .HasConstraintName("FK_server_role_ban_round_round_id");
1539
1540                     b.Navigation("CreatedBy");
1541
1542                     b.Navigation("LastEditedBy");
1543
1544                     b.Navigation("Round");
1545                 });
1546
1547             modelBuilder.Entity("Content.Server.Database.ServerRoleUnban", b =>
1548                 {
1549                     b.HasOne("Content.Server.Database.ServerRoleBan", "Ban")
1550                         .WithOne("Unban")
1551                         .HasForeignKey("Content.Server.Database.ServerRoleUnban", "BanId")
1552                         .OnDelete(DeleteBehavior.Cascade)
1553                         .IsRequired()
1554                         .HasConstraintName("FK_server_role_unban_server_role_ban_ban_id");
1555
1556                     b.Navigation("Ban");
1557                 });
1558
1559             modelBuilder.Entity("Content.Server.Database.ServerUnban", b =>
1560                 {
1561                     b.HasOne("Content.Server.Database.ServerBan", "Ban")
1562                         .WithOne("Unban")
1563                         .HasForeignKey("Content.Server.Database.ServerUnban", "BanId")
1564                         .OnDelete(DeleteBehavior.Cascade)
1565                         .IsRequired()
1566                         .HasConstraintName("FK_server_unban_server_ban_ban_id");
1567
1568                     b.Navigation("Ban");
1569                 });
1570
1571             modelBuilder.Entity("Content.Server.Database.Trait", b =>
1572                 {
1573                     b.HasOne("Content.Server.Database.Profile", "Profile")
1574                         .WithMany("Traits")
1575                         .HasForeignKey("ProfileId")
1576                         .OnDelete(DeleteBehavior.Cascade)
1577                         .IsRequired()
1578                         .HasConstraintName("FK_trait_profile_profile_id");
1579
1580                     b.Navigation("Profile");
1581                 });
1582
1583             modelBuilder.Entity("PlayerRound", b =>
1584                 {
1585                     b.HasOne("Content.Server.Database.Player", null)
1586                         .WithMany()
1587                         .HasForeignKey("PlayersId")
1588                         .OnDelete(DeleteBehavior.Cascade)
1589                         .IsRequired()
1590                         .HasConstraintName("FK_player_round_player_players_id");
1591
1592                     b.HasOne("Content.Server.Database.Round", null)
1593                         .WithMany()
1594                         .HasForeignKey("RoundsId")
1595                         .OnDelete(DeleteBehavior.Cascade)
1596                         .IsRequired()
1597                         .HasConstraintName("FK_player_round_round_rounds_id");
1598                 });
1599
1600             modelBuilder.Entity("Content.Server.Database.Admin", b =>
1601                 {
1602                     b.Navigation("Flags");
1603                 });
1604
1605             modelBuilder.Entity("Content.Server.Database.AdminLog", b =>
1606                 {
1607                     b.Navigation("Entities");
1608
1609                     b.Navigation("Players");
1610                 });
1611
1612             modelBuilder.Entity("Content.Server.Database.AdminRank", b =>
1613                 {
1614                     b.Navigation("Admins");
1615
1616                     b.Navigation("Flags");
1617                 });
1618
1619             modelBuilder.Entity("Content.Server.Database.ConnectionLog", b =>
1620                 {
1621                     b.Navigation("BanHits");
1622                 });
1623
1624             modelBuilder.Entity("Content.Server.Database.Player", b =>
1625                 {
1626                     b.Navigation("AdminLogs");
1627
1628                     b.Navigation("AdminMessagesCreated");
1629
1630                     b.Navigation("AdminMessagesDeleted");
1631
1632                     b.Navigation("AdminMessagesLastEdited");
1633
1634                     b.Navigation("AdminMessagesReceived");
1635
1636                     b.Navigation("AdminNotesCreated");
1637
1638                     b.Navigation("AdminNotesDeleted");
1639
1640                     b.Navigation("AdminNotesLastEdited");
1641
1642                     b.Navigation("AdminNotesReceived");
1643
1644                     b.Navigation("AdminServerBansCreated");
1645
1646                     b.Navigation("AdminServerBansLastEdited");
1647
1648                     b.Navigation("AdminServerRoleBansCreated");
1649
1650                     b.Navigation("AdminServerRoleBansLastEdited");
1651
1652                     b.Navigation("AdminWatchlistsCreated");
1653
1654                     b.Navigation("AdminWatchlistsDeleted");
1655
1656                     b.Navigation("AdminWatchlistsLastEdited");
1657
1658                     b.Navigation("AdminWatchlistsReceived");
1659                 });
1660
1661             modelBuilder.Entity("Content.Server.Database.Preference", b =>
1662                 {
1663                     b.Navigation("Profiles");
1664                 });
1665
1666             modelBuilder.Entity("Content.Server.Database.Profile", b =>
1667                 {
1668                     b.Navigation("Antags");
1669
1670                     b.Navigation("Jobs");
1671
1672                     b.Navigation("Traits");
1673                 });
1674
1675             modelBuilder.Entity("Content.Server.Database.Round", b =>
1676                 {
1677                     b.Navigation("AdminLogs");
1678                 });
1679
1680             modelBuilder.Entity("Content.Server.Database.Server", b =>
1681                 {
1682                     b.Navigation("Rounds");
1683                 });
1684
1685             modelBuilder.Entity("Content.Server.Database.ServerBan", b =>
1686                 {
1687                     b.Navigation("BanHits");
1688
1689                     b.Navigation("Unban");
1690                 });
1691
1692             modelBuilder.Entity("Content.Server.Database.ServerRoleBan", b =>
1693                 {
1694                     b.Navigation("Unban");
1695                 });
1696 #pragma warning restore 612, 618
1697         }
1698 #endif
1699     }
1700 }