Timothy Schenk
6d9a72ded4
Some checks failed
Build, Package and Push Images / preprocess (push) Successful in 2s
Build, Package and Push Images / build (push) Successful in 25s
Build, Package and Push Images / sbom-scan (push) Successful in 36s
Build, Package and Push Images / sonarqube (push) Failing after 1m36s
Build, Package and Push Images / container-build (push) Successful in 2m4s
Build, Package and Push Images / container-sbom-scan (push) Successful in 39s
353 lines
12 KiB
C#
353 lines
12 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using Continuity.AuthServer.DB;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
|
|
using Server.DB;
|
|
|
|
#nullable disable
|
|
|
|
namespace Server.DB.Migrations
|
|
{
|
|
[DbContext(typeof(WonderkingContext))]
|
|
[Migration("20231122064508_IndexingAndVariousOtherAnnotations")]
|
|
partial class IndexingAndVariousOtherAnnotations
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.HasAnnotation("ProductVersion", "8.0.0")
|
|
.HasAnnotation("Proxies:ChangeTracking", false)
|
|
.HasAnnotation("Proxies:CheckEquality", false)
|
|
.HasAnnotation("Proxies:LazyLoading", true)
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 63);
|
|
|
|
NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Account", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Email")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<byte[]>("Password")
|
|
.HasColumnType("bytea");
|
|
|
|
b.Property<byte>("PermissionLevel")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<byte[]>("Salt")
|
|
.HasColumnType("bytea");
|
|
|
|
b.Property<string>("Username")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Id")
|
|
.IsUnique();
|
|
|
|
b.HasIndex("Username")
|
|
.IsUnique();
|
|
|
|
b.ToTable("Accounts");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Character", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<Guid?>("AccountId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<long>("Experience")
|
|
.HasColumnType("bigint");
|
|
|
|
b.Property<byte>("Gender")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<Guid?>("GuildId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<int>("Health")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<short>("LastXCoordinate")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<short>("LastYCoordinate")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<byte>("Level")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<int>("Mana")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int>("MapId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Name")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<byte>("PvPLevel")
|
|
.HasColumnType("smallint");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("AccountId");
|
|
|
|
b.HasIndex("GuildId");
|
|
|
|
b.HasIndex("Id")
|
|
.IsUnique();
|
|
|
|
b.HasIndex("Name")
|
|
.IsUnique();
|
|
|
|
b.ToTable("Characters");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Guild", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Name")
|
|
.HasMaxLength(16)
|
|
.HasColumnType("character varying(16)");
|
|
|
|
b.Property<string>("Notice")
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Id")
|
|
.IsUnique();
|
|
|
|
b.HasIndex("Name")
|
|
.IsUnique();
|
|
|
|
b.ToTable("Guilds");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.GuildMember", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<Guid?>("CharacterId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<Guid?>("GuildId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<byte>("Rank")
|
|
.HasColumnType("smallint");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CharacterId");
|
|
|
|
b.HasIndex("GuildId");
|
|
|
|
b.HasIndex("Id")
|
|
.IsUnique();
|
|
|
|
b.ToTable("GuildMember");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.InventoryItem", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<byte>("AddOption")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<byte>("AddOption2")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<byte>("AddOption3")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<Guid?>("CharacterId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<int>("Count")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<byte>("InventoryTab")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<int>("ItemId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<byte>("Level")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<short>("Option")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<short>("Option2")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<short>("Option3")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<byte>("Rarity")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<byte>("Slot")
|
|
.HasColumnType("smallint");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CharacterId");
|
|
|
|
b.ToTable("InventoryItems");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Character", b =>
|
|
{
|
|
b.HasOne("Continuity.AuthServer.DB.Documents.Account", "Account")
|
|
.WithMany("Characters")
|
|
.HasForeignKey("AccountId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.HasOne("Continuity.AuthServer.DB.Documents.Guild", "Guild")
|
|
.WithMany()
|
|
.HasForeignKey("GuildId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.OwnsOne("Wonderking.Packets.Outgoing.Data.BaseStats", "BaseStats", b1 =>
|
|
{
|
|
b1.Property<Guid>("CharacterId")
|
|
.HasColumnType("uuid");
|
|
|
|
b1.Property<short>("Dexterity")
|
|
.HasColumnType("smallint")
|
|
.HasAnnotation("Relational:JsonPropertyName", "dexterity");
|
|
|
|
b1.Property<short>("Intelligence")
|
|
.HasColumnType("smallint")
|
|
.HasAnnotation("Relational:JsonPropertyName", "intelligence");
|
|
|
|
b1.Property<short>("Luck")
|
|
.HasColumnType("smallint")
|
|
.HasAnnotation("Relational:JsonPropertyName", "luck");
|
|
|
|
b1.Property<short>("Strength")
|
|
.HasColumnType("smallint")
|
|
.HasAnnotation("Relational:JsonPropertyName", "strength");
|
|
|
|
b1.Property<short>("Vitality")
|
|
.HasColumnType("smallint")
|
|
.HasAnnotation("Relational:JsonPropertyName", "vitality");
|
|
|
|
b1.Property<short>("Wisdom")
|
|
.HasColumnType("smallint")
|
|
.HasAnnotation("Relational:JsonPropertyName", "wisdom");
|
|
|
|
b1.HasKey("CharacterId");
|
|
|
|
b1.ToTable("Characters");
|
|
|
|
b1.WithOwner()
|
|
.HasForeignKey("CharacterId");
|
|
});
|
|
|
|
b.OwnsOne("Wonderking.Packets.Outgoing.Data.JobData", "JobData", b1 =>
|
|
{
|
|
b1.Property<Guid>("CharacterId")
|
|
.HasColumnType("uuid");
|
|
|
|
b1.Property<byte>("FirstJob")
|
|
.HasColumnType("smallint");
|
|
|
|
b1.Property<byte>("FourthJob")
|
|
.HasColumnType("smallint");
|
|
|
|
b1.Property<byte>("SecondJob")
|
|
.HasColumnType("smallint");
|
|
|
|
b1.Property<byte>("ThirdJob")
|
|
.HasColumnType("smallint");
|
|
|
|
b1.HasKey("CharacterId");
|
|
|
|
b1.ToTable("Characters");
|
|
|
|
b1.WithOwner()
|
|
.HasForeignKey("CharacterId");
|
|
});
|
|
|
|
b.Navigation("Account");
|
|
|
|
b.Navigation("BaseStats");
|
|
|
|
b.Navigation("Guild");
|
|
|
|
b.Navigation("JobData");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.GuildMember", b =>
|
|
{
|
|
b.HasOne("Continuity.AuthServer.DB.Documents.Character", "Character")
|
|
.WithMany()
|
|
.HasForeignKey("CharacterId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.HasOne("Continuity.AuthServer.DB.Documents.Guild", "Guild")
|
|
.WithMany("GuildMembers")
|
|
.HasForeignKey("GuildId")
|
|
.OnDelete(DeleteBehavior.Cascade);
|
|
|
|
b.Navigation("Character");
|
|
|
|
b.Navigation("Guild");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.InventoryItem", b =>
|
|
{
|
|
b.HasOne("Continuity.AuthServer.DB.Documents.Character", "Character")
|
|
.WithMany("InventoryItems")
|
|
.HasForeignKey("CharacterId")
|
|
.OnDelete(DeleteBehavior.Cascade);
|
|
|
|
b.Navigation("Character");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Account", b =>
|
|
{
|
|
b.Navigation("Characters");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Character", b =>
|
|
{
|
|
b.Navigation("InventoryItems");
|
|
});
|
|
|
|
modelBuilder.Entity("Continuity.AuthServer.DB.Documents.Guild", b =>
|
|
{
|
|
b.Navigation("GuildMembers");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|