Samuele Locatelli
547 lines
18 KiB
C#
547 lines
18 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using LiMan.DB;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Metadata;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
|
|
#nullable disable
|
|
|
|
namespace LiMan.DB.Migrations
|
|
{
|
|
[DbContext(typeof(LMDbContext))]
|
|
[Migration("20240806142953_AddRelModel01")]
|
|
partial class AddRelModel01
|
|
{
|
|
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.UseCollation("SQL_Latin1_General_CP1_CI_AS")
|
|
.HasAnnotation("ProductVersion", "6.0.28")
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 128);
|
|
|
|
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.ApplicativoModel", b =>
|
|
{
|
|
b.Property<string>("CodApp")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<string>("Descrizione")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("nvarchar(250)");
|
|
|
|
b.Property<string>("TplConnString")
|
|
.HasMaxLength(2500)
|
|
.HasColumnType("nvarchar(2500)");
|
|
|
|
b.HasKey("CodApp");
|
|
|
|
b.ToTable("Applicativi");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.AuthClaimModel", b =>
|
|
{
|
|
b.Property<int>("ClaimID")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ClaimID"), 1L, 1);
|
|
|
|
b.Property<DateTime>("DtIns")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<DateTime>("DtMod")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<int>("RoleID")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("UserID")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("ClaimID");
|
|
|
|
b.HasIndex("RoleID");
|
|
|
|
b.HasIndex("UserID");
|
|
|
|
b.ToTable("AuthClaims");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.AuthRoleModel", b =>
|
|
{
|
|
b.Property<int>("RoleID")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("RoleID"), 1L, 1);
|
|
|
|
b.Property<string>("Descrizione")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Ruolo")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.HasKey("RoleID");
|
|
|
|
b.ToTable("AuthRoles");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.AuthUserModel", b =>
|
|
{
|
|
b.Property<int>("UserID")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("UserID"), 1L, 1);
|
|
|
|
b.Property<string>("AD_Domain")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("AD_User")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Cognome")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Nome")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Username")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.HasKey("UserID");
|
|
|
|
b.ToTable("AuthUsers");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.FileAttachModel", b =>
|
|
{
|
|
b.Property<int>("IdxFileAttach")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxFileAttach"), 1L, 1);
|
|
|
|
b.Property<DateTime>("DtEvent")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<string>("FullStoragePath")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("IdxTicket")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("OriginalName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("StorageName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.HasKey("IdxFileAttach");
|
|
|
|
b.HasIndex("IdxTicket");
|
|
|
|
b.ToTable("FileAttach");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.InstallazioneModel", b =>
|
|
{
|
|
b.Property<string>("CodInst")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<string>("Cliente")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("nvarchar(250)");
|
|
|
|
b.Property<string>("Contatto")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("nvarchar(250)");
|
|
|
|
b.Property<string>("Descrizione")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("nvarchar(250)");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("nvarchar(250)");
|
|
|
|
b.HasKey("CodInst");
|
|
|
|
b.ToTable("Installazioni");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.LicenzaModel", b =>
|
|
{
|
|
b.Property<int>("IdxLic")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxLic"), 1L, 1);
|
|
|
|
b.Property<string>("Chiave")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("CodApp")
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<string>("CodInst")
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<DateTime>("DataEnigma")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<string>("Descrizione")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("Enigma")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<bool>("Locked")
|
|
.HasColumnType("bit");
|
|
|
|
b.Property<int>("NumLicenze")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Payload")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<DateTime>("Scadenza")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<int>("Tipo")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("IdxLic");
|
|
|
|
b.HasIndex("CodApp");
|
|
|
|
b.HasIndex("CodInst");
|
|
|
|
b.ToTable("Licenze");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.LogCallModel", b =>
|
|
{
|
|
b.Property<DateTime>("DataRif")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<string>("CodInst")
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<string>("CodApp")
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<string>("TargetUrl")
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<int>("NumCall")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("DataRif", "CodInst", "CodApp", "TargetUrl");
|
|
|
|
b.ToTable("LogCall");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.LogLicenzaModel", b =>
|
|
{
|
|
b.Property<int>("IdxLogLic")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxLogLic"), 1L, 1);
|
|
|
|
b.Property<string>("Chiave")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("CodApp")
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<string>("CodInst")
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<string>("Descrizione")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("IdxLic")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("NumLicenze")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("Scadenza")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<int>("Tipo")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("IdxLogLic");
|
|
|
|
b.HasIndex("CodApp");
|
|
|
|
b.HasIndex("CodInst");
|
|
|
|
b.HasIndex("IdxLic");
|
|
|
|
b.ToTable("LogLicenze");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.ReleaseModel", b =>
|
|
{
|
|
b.Property<int>("IdxRel")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxRel"), 1L, 1);
|
|
|
|
b.Property<string>("CodApp")
|
|
.HasColumnType("nvarchar(50)");
|
|
|
|
b.Property<DateTime>("ReleaseDate")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<string>("VersNum")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("VersText")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.HasKey("IdxRel");
|
|
|
|
b.HasIndex("CodApp");
|
|
|
|
b.ToTable("Releases");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.StatsCallModel", b =>
|
|
{
|
|
b.Property<int>("YearRef")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("CodInst")
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<string>("CodApp")
|
|
.HasColumnType("nvarchar(450)");
|
|
|
|
b.Property<int>("TotCall")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("YearRef", "CodInst", "CodApp");
|
|
|
|
b.ToView("v_StatsCall");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.SubLicenzaModel", b =>
|
|
{
|
|
b.Property<int>("IdxSubLic")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxSubLic"), 1L, 1);
|
|
|
|
b.Property<string>("Chiave")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("CodImpiego")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("IdxLic")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("Tipo")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("VetoUnlock")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.HasKey("IdxSubLic");
|
|
|
|
b.HasIndex("IdxLic");
|
|
|
|
b.ToTable("SubLicenze");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.TicketModel", b =>
|
|
{
|
|
b.Property<int>("IdxTicket")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxTicket"), 1L, 1);
|
|
|
|
b.Property<string>("CodImpiego")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ContactEmail")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ContactName")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("ContactPhone")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<DateTime>("DtReq")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<int>("IdxLic")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("IdxSubLic")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("ReqBody")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("Status")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("SupplAnsw")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("SupplEmail")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<string>("SupplUserCode")
|
|
.HasColumnType("nvarchar(max)");
|
|
|
|
b.Property<int>("TType")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("Tipo")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("IdxTicket");
|
|
|
|
b.HasIndex("IdxLic");
|
|
|
|
b.ToTable("TicketLog");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.AuthClaimModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.AuthRoleModel", "RoleNav")
|
|
.WithMany("Claims")
|
|
.HasForeignKey("RoleID")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.HasOne("LiMan.DB.DBModels.AuthUserModel", "UserNav")
|
|
.WithMany("Claims")
|
|
.HasForeignKey("UserID")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("RoleNav");
|
|
|
|
b.Navigation("UserNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.FileAttachModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.TicketModel", "TicketNav")
|
|
.WithMany()
|
|
.HasForeignKey("IdxTicket")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("TicketNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.LicenzaModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.ApplicativoModel", "ApplicativoNav")
|
|
.WithMany()
|
|
.HasForeignKey("CodApp");
|
|
|
|
b.HasOne("LiMan.DB.DBModels.InstallazioneModel", "InstallazioneNav")
|
|
.WithMany()
|
|
.HasForeignKey("CodInst");
|
|
|
|
b.Navigation("ApplicativoNav");
|
|
|
|
b.Navigation("InstallazioneNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.LogLicenzaModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.ApplicativoModel", "ApplicativoNav")
|
|
.WithMany()
|
|
.HasForeignKey("CodApp");
|
|
|
|
b.HasOne("LiMan.DB.DBModels.InstallazioneModel", "InstallazioneNav")
|
|
.WithMany()
|
|
.HasForeignKey("CodInst");
|
|
|
|
b.HasOne("LiMan.DB.DBModels.LicenzaModel", "LicenzaNav")
|
|
.WithMany()
|
|
.HasForeignKey("IdxLic")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("ApplicativoNav");
|
|
|
|
b.Navigation("InstallazioneNav");
|
|
|
|
b.Navigation("LicenzaNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.ReleaseModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.ApplicativoModel", "ApplicativoNav")
|
|
.WithMany()
|
|
.HasForeignKey("CodApp");
|
|
|
|
b.Navigation("ApplicativoNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.SubLicenzaModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.LicenzaModel", "LicenzaNav")
|
|
.WithMany("Attivazioni")
|
|
.HasForeignKey("IdxLic")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("LicenzaNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.TicketModel", b =>
|
|
{
|
|
b.HasOne("LiMan.DB.DBModels.LicenzaModel", "LicenzaNav")
|
|
.WithMany("Tickets")
|
|
.HasForeignKey("IdxLic")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("LicenzaNav");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.AuthRoleModel", b =>
|
|
{
|
|
b.Navigation("Claims");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.AuthUserModel", b =>
|
|
{
|
|
b.Navigation("Claims");
|
|
});
|
|
|
|
modelBuilder.Entity("LiMan.DB.DBModels.LicenzaModel", b =>
|
|
{
|
|
b.Navigation("Attivazioni");
|
|
|
|
b.Navigation("Tickets");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|