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