public void Configure(EntityTypeBuilder <User> builder)
{
builder.ToTable("User");
builder.HasIndex(e => e.ExternalId)
.HasName("UNIQ_B28B6F38C05FB297")
.IsUnique();
builder.HasIndex(e => e.DisplayName)
.HasName("UNIQ_B28B6F38A0D96FBF")
.IsUnique();
builder.HasIndex(e => e.Email)
.HasName("UNIQ_B28B6F3892FC23A8")
.IsUnique();
builder.HasGuidKey();
builder.Property(e => e.ExternalId)
.HasColumnName("externalId")
.HasUtf8ColumnType(MySqlBuilderTypes.String(127));
builder.Property(e => e.DisplayName)
.IsRequired()
.HasColumnName("displayName")
.HasUtf8ColumnType(MySqlBuilderTypes.String(35));
builder.Property(e => e.Email)
.IsRequired()
.HasColumnName("email")
.HasUtf8ColumnType(MySqlBuilderTypes.String(180));
}
public void Configure(EntityTypeBuilder <GameRace> builder)
{
builder.ToTable("GameRace");
builder.HasIndex(e => e.GameFactionId)
.HasName("IDX_D51A7CF883048B90");
builder.HasGuidKey();
builder.Property(e => e.GameId)
.IsRequired()
.HasColumnName("gameId")
.HasColumnType(MySqlBuilderTypes.UnsignedInt);
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType((MySqlBuilderTypes.String(20)));
builder.Property(e => e.GameFactionId)
.HasColumnName("gameFactionId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.GameFaction)
.WithMany()
.HasForeignKey(d => d.GameFactionId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_D51A7CF883048B90");
}
public void Configure(EntityTypeBuilder <FeatureUse> builder)
{
builder.ToTable("FeatureUse");
builder.HasIndex(e => e.UsedById)
.HasName("IDX_E504F432FCEF271C");
builder.HasGuidKey();
builder.Property(e => e.Feature)
.IsRequired()
.HasColumnName("feature")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.RawData)
.HasColumnName("rawData")
.HasUtf8ColumnType(MySqlBuilderTypes.LongText);
builder.Property(e => e.UsedOn)
.HasColumnName("usedOn")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.UsedById)
.HasColumnName("usedById")
.HasForeignKeyColumnType();
builder.HasOne(d => d.UsedBy)
.WithMany()
.HasForeignKey(d => d.UsedById)
.HasConstraintName("FK_E504F432FCEF271C");
}
public void Configure(EntityTypeBuilder <GameGuild> builder)
{
builder.ToTable("GameGuild");
builder.HasIndex(e => e.GameRealmId)
.HasName("IDX_B48152AFFA96DBDA");
builder.HasGuidKey();
builder.Property(e => e.GameId)
.IsRequired()
.HasColumnName("gameId")
.HasColumnType(MySqlBuilderTypes.UnsignedInt);
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType(MySqlBuilderTypes.String(100));
builder.Property(e => e.GameRealmId)
.HasColumnName("gameRealmId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.GameRealm)
.WithMany()
.HasForeignKey(d => d.GameRealmId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_B48152AFFA96DBDA");
}
public void Configure(EntityTypeBuilder <FeatureToggle> builder)
{
builder.ToTable("FeatureToggle");
builder.HasIndex(e => e.UserId)
.HasName("IDX_D25E05DD612E729E");
builder.HasGuidKey();
builder.Property(e => e.Feature)
.IsRequired()
.HasColumnName("feature")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.Toggle)
.HasColumnName("toggle");
builder.Property(e => e.UserId)
.HasColumnName("userId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.User)
.WithMany()
.HasForeignKey(d => d.UserId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_D25E05DD612E729E");
}
public void Configure(EntityTypeBuilder <MailSend> builder)
{
builder.ToTable("MailSend");
builder.HasGuidKey();
builder.Property(e => e.FromAddress)
.IsRequired()
.HasColumnName("fromAddress")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.SendOn)
.IsRequired()
.HasColumnName("sendOn")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.Subject)
.IsRequired()
.HasColumnName("subject")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.ToAddress)
.IsRequired()
.HasColumnName("toAddress")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
}
public void Configure(EntityTypeBuilder <CalendarExport> builder)
{
builder.ToTable("CalendarExport");
builder.HasIndex(e => e.UserId)
.HasName("IDX_6E28848862DEB3E8");
builder.HasGuidKey();
builder.Property(e => e.ExportAbsence)
.IsRequired()
.HasColumnName("exportAbsence");
builder.Property(e => e.ExportNew)
.IsRequired()
.HasColumnName("exportNew");
builder.Property(e => e.Secret)
.IsRequired()
.HasColumnName("secret")
.HasUtf8ColumnType(MySqlBuilderTypes.String(100));
builder.Property(e => e.UserId)
.HasColumnName("userId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.User)
.WithMany()
.HasForeignKey(d => d.UserId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_6E28848862DEB3E8");
}
public void Configure(EntityTypeBuilder <ActivityQueueItem> builder)
{
builder.ToTable("ActivityQueueItem");
builder.HasIndex(e => e.ActivityById)
.HasName("IDX_8A274BCA93C757EE");
builder.HasGuidKey();
builder.Property(e => e.ActivityOn)
.IsRequired()
.HasColumnName("activityOn")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.ActivityType)
.IsRequired()
.HasColumnName("activityType")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.ProcessedOn)
.HasColumnName("processedOn")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.RawData)
.HasColumnName("rawData")
.HasUtf8ColumnType(MySqlBuilderTypes.LongText);
builder.Property(e => e.ActivityById)
.HasColumnName("activityById")
.HasForeignKeyColumnType();
builder.HasOne(d => d.ActivityBy)
.WithMany()
.HasForeignKey(d => d.ActivityById)
.HasConstraintName("FK_8A274BCA93C757EE");
}
public void Configure(EntityTypeBuilder <GameCharacter> builder)
{
builder.ToTable("GameCharacter");
builder.HasIndex(e => e.GameRealmId)
.HasName("IDX_92AF3B34FA96DBDA");
builder.HasGuidKey();
builder.TimeVersioned();
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.GameRealmId)
.HasColumnName("gameRealmId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.GameRealm)
.WithMany()
.HasForeignKey(d => d.GameRealmId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_92AF3B34FA96DBDA");
}
public void Configure(EntityTypeBuilder <Setting> builder)
{
builder.ToTable("Setting");
builder.HasIndex(e => e.UserId)
.HasName("IDX_50C9810462DEB3E8");
builder.HasGuidKey();
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.Value)
.IsRequired()
.HasColumnName("value")
.HasUtf8ColumnType(MySqlBuilderTypes.String(2048));
builder.Property(e => e.UserId)
.HasColumnName("userId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.User)
.WithMany()
.HasForeignKey(d => d.UserId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_50C9810462DEB3E8");
}
public void Configure(EntityTypeBuilder <Topic> builder)
{
builder.ToTable("Topic");
builder.HasIndex(e => e.ForumId)
.HasName("IDX_5C81F11F7830F151");
builder.HasIndex(e => e.LastPostPosterId)
.HasName("IDX_5C81F11F22F0147C");
builder.HasIndex(e => e.PosterId)
.HasName("IDX_5C81F11F581A197");
builder.HasGuidKey();
builder.Property(e => e.LastPostDate)
.HasColumnName("lastPostDate")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.PostDate)
.HasColumnName("postDate")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.Subject)
.IsRequired()
.HasColumnName("subject")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.ForumId)
.HasColumnName("forumId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.Forum)
.WithMany()
.HasForeignKey(d => d.ForumId)
.HasConstraintName("FK_5C81F11F7830F151");
builder.Property(e => e.LastPostPosterId)
.HasColumnName("lastPostPosterId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.LastPostPoster)
.WithMany()
.HasForeignKey(d => d.LastPostPosterId)
.HasConstraintName("FK_5C81F11F22F0147C");
builder.Property(e => e.PosterId)
.HasColumnName("posterId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.Poster)
.WithMany()
.HasForeignKey(d => d.PosterId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_5C81F11F581A197");
}
public void Configure(EntityTypeBuilder <GameClass> builder)
{
builder.ToTable("GameClass");
builder.HasGuidKey();
builder.Property(e => e.GameId)
.HasColumnName("gameId")
.HasColumnType(MySqlBuilderTypes.UnsignedInt);
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType(MySqlBuilderTypes.String(20));
}
public void Configure(EntityTypeBuilder <Forum> builder)
{
builder.ToTable("Forum");
builder.HasIndex(e => e.LastPostPosterId)
.HasName("IDX_44EA91C922F0147C");
builder.HasIndex(e => e.LastPostTopicId)
.HasName("IDX_44EA91C91CA16452");
builder.HasGuidKey();
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType(MySqlBuilderTypes.String(255));
builder.Property(e => e.Description)
.IsRequired()
.HasColumnName("description")
.HasUtf8ColumnType(MySqlBuilderTypes.Text);
builder.Property(e => e.LastPostDate)
.HasColumnName("lastPostDate")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.LastPostPosterId)
.HasColumnName("lastPostPosterId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.LastPostPoster)
.WithMany()
.HasForeignKey(d => d.LastPostPosterId)
.HasConstraintName("FK_44EA91C922F0147C");
builder.Property(e => e.LastPostTopicId)
.HasColumnName("lastPostTopicId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.LastPostTopic)
.WithMany()
.HasForeignKey(d => d.LastPostTopicId)
.HasConstraintName("FK_44EA91C91CA16452");
}
public void Configure(EntityTypeBuilder <Comment> builder)
{
builder.ToTable("Comment");
builder.HasIndex(e => e.GroupId)
.HasName("IDX_5BC96BF0ED8188B0");
builder.HasIndex(e => e.PosterId)
.HasName("IDX_5BC96BF0581A197");
builder.HasGuidKey();
builder.Property(e => e.Content)
.HasColumnName("content")
.IsRequired()
.HasUtf8ColumnType(MySqlBuilderTypes.String((4096)));
builder.Property(e => e.PostDate)
.HasColumnName("postDate")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.GroupId)
.HasColumnName("groupId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.Group)
.WithMany()
.HasForeignKey(d => d.GroupId)
.HasConstraintName("FK_5BC96BF0ED8188B0");
builder.Property(e => e.PosterId)
.HasColumnName("posterId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.Poster)
.WithMany()
.HasForeignKey(d => d.PosterId)
.HasConstraintName("FK_5BC96BF0581A197");
}
public void Configure(EntityTypeBuilder <Event> builder)
{
builder.ToTable("Event");
builder.HasIndex(e => e.OrganiserId)
.HasName("IDX_FA6F25A34BDD3C8");
builder.HasGuidKey();
builder.Property(e => e.Name)
.IsRequired()
.HasColumnName("name")
.HasUtf8ColumnType(MySqlBuilderTypes.String(100));
builder.Property(e => e.Description)
.HasColumnName("description")
.HasUtf8ColumnType(MySqlBuilderTypes.String(4096));
builder.Property(e => e.StartTime)
.IsRequired()
.HasColumnName("startTime")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.InviteTime)
.IsRequired()
.HasColumnName("inviteTime")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.EndTime)
.IsRequired()
.HasColumnName("endTime")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.LastModifiedTime)
.IsRequired()
.HasColumnName("lastModifiedTime")
.HasColumnType(MySqlBuilderTypes.DateTime);
builder.Property(e => e.State)
.IsRequired()
.HasColumnName("state")
.HasColumnType(MySqlBuilderTypes.Enum);
builder.Property(e => e.OrganiserId)
.HasColumnName("organiserId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.Organiser)
.WithMany()
.HasForeignKey(d => d.OrganiserId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_FA6F25A34BDD3C8");
builder.Property(e => e.CommentGroupId)
.HasColumnName("commentGroupId")
.HasForeignKeyColumnType();
builder.HasOne(d => d.CommentGroup)
.WithMany()
.HasForeignKey(d => d.CommentGroupId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_FA6F25A34BDD4B9");
}