aboutsummaryrefslogtreecommitdiff
path: root/Migrations
diff options
context:
space:
mode:
Diffstat (limited to 'Migrations')
-rw-r--r--Migrations/20230705160931_Initial.Designer.cs159
-rw-r--r--Migrations/20230705160931_Initial.cs115
-rw-r--r--Migrations/PagerContextModelSnapshot.cs156
3 files changed, 430 insertions, 0 deletions
diff --git a/Migrations/20230705160931_Initial.Designer.cs b/Migrations/20230705160931_Initial.Designer.cs
new file mode 100644
index 0000000..598258f
--- /dev/null
+++ b/Migrations/20230705160931_Initial.Designer.cs
@@ -0,0 +1,159 @@
+// <auto-generated />
+using System;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+using PagerParser;
+
+#nullable disable
+
+namespace PagerParser.Migrations
+{
+ [DbContext(typeof(PagerContext))]
+ [Migration("20230705160931_Initial")]
+ partial class Initial
+ {
+ /// <inheritdoc />
+ protected override void BuildTargetModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("ProductVersion", "7.0.8")
+ .HasAnnotation("Relational:MaxIdentifierLength", 63);
+
+ NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
+
+ modelBuilder.Entity("PagerParser.GpsPosition", b =>
+ {
+ b.Property<int>("GpsPositionId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer");
+
+ NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("GpsPositionId"));
+
+ b.Property<double>("Latitude")
+ .HasColumnType("double precision");
+
+ b.Property<double>("Longitude")
+ .HasColumnType("double precision");
+
+ b.HasKey("GpsPositionId");
+
+ b.ToTable("GpsPositions");
+ });
+
+ modelBuilder.Entity("PagerParser.PagerMessage", b =>
+ {
+ b.Property<int>("PagerMessageId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer");
+
+ NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("PagerMessageId"));
+
+ b.Property<string>("Message")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<DateTime>("Timestamp")
+ .HasColumnType("timestamp with time zone");
+
+ b.HasKey("PagerMessageId");
+
+ b.HasIndex("Message");
+
+ b.ToTable("PagerMessages");
+ });
+
+ modelBuilder.Entity("PagerParser.ParsedPagerMessage", b =>
+ {
+ b.Property<int>("ParsedPagerMessageId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer");
+
+ NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("ParsedPagerMessageId"));
+
+ b.Property<int>("AlertLevel")
+ .HasColumnType("integer");
+
+ b.Property<string>("AssignmentArea")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<int>("AttendingServices")
+ .HasColumnType("integer");
+
+ b.Property<string>("Description")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<int?>("FireGroundChannel")
+ .HasColumnType("integer");
+
+ b.Property<int>("FirecomJobNo")
+ .HasColumnType("integer");
+
+ b.Property<int?>("GpsPositionId")
+ .HasColumnType("integer");
+
+ b.Property<int?>("GridReference")
+ .HasColumnType("integer");
+
+ b.Property<string>("JobType")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<string>("MelwaysGrid")
+ .HasColumnType("text");
+
+ b.Property<int?>("MelwaysMapNo")
+ .HasColumnType("integer");
+
+ b.Property<string>("Note")
+ .HasColumnType("text");
+
+ b.Property<string>("PageDestination")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<int>("PagerMessage")
+ .HasColumnType("integer");
+
+ b.HasKey("ParsedPagerMessageId");
+
+ b.HasIndex("FirecomJobNo");
+
+ b.HasIndex("GpsPositionId");
+
+ b.HasIndex("PagerMessage")
+ .IsUnique();
+
+ b.ToTable("ParsedPagerMessages");
+ });
+
+ modelBuilder.Entity("PagerParser.ParsedPagerMessage", b =>
+ {
+ b.HasOne("PagerParser.GpsPosition", "GpsPosition")
+ .WithMany()
+ .HasForeignKey("GpsPositionId");
+
+ b.HasOne("PagerParser.PagerMessage", "OriginalMessage")
+ .WithOne("ParsedMessage")
+ .HasForeignKey("PagerParser.ParsedPagerMessage", "PagerMessage")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("GpsPosition");
+
+ b.Navigation("OriginalMessage");
+ });
+
+ modelBuilder.Entity("PagerParser.PagerMessage", b =>
+ {
+ b.Navigation("ParsedMessage");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
diff --git a/Migrations/20230705160931_Initial.cs b/Migrations/20230705160931_Initial.cs
new file mode 100644
index 0000000..9f3068f
--- /dev/null
+++ b/Migrations/20230705160931_Initial.cs
@@ -0,0 +1,115 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+
+#nullable disable
+
+namespace PagerParser.Migrations
+{
+ /// <inheritdoc />
+ public partial class Initial : Migration
+ {
+ /// <inheritdoc />
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.CreateTable(
+ name: "GpsPositions",
+ columns: table => new
+ {
+ GpsPositionId = table.Column<int>(type: "integer", nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ Latitude = table.Column<double>(type: "double precision", nullable: false),
+ Longitude = table.Column<double>(type: "double precision", nullable: false)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_GpsPositions", x => x.GpsPositionId);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "PagerMessages",
+ columns: table => new
+ {
+ PagerMessageId = table.Column<int>(type: "integer", nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ Timestamp = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
+ Message = table.Column<string>(type: "text", nullable: false)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_PagerMessages", x => x.PagerMessageId);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "ParsedPagerMessages",
+ columns: table => new
+ {
+ ParsedPagerMessageId = table.Column<int>(type: "integer", nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ FirecomJobNo = table.Column<int>(type: "integer", nullable: false),
+ AssignmentArea = table.Column<string>(type: "text", nullable: false),
+ JobType = table.Column<string>(type: "text", nullable: false),
+ AlertLevel = table.Column<int>(type: "integer", nullable: false),
+ Description = table.Column<string>(type: "text", nullable: false),
+ MelwaysMapNo = table.Column<int>(type: "integer", nullable: true),
+ MelwaysGrid = table.Column<string>(type: "text", nullable: true),
+ GridReference = table.Column<int>(type: "integer", nullable: true),
+ AttendingServices = table.Column<int>(type: "integer", nullable: false),
+ Note = table.Column<string>(type: "text", nullable: true),
+ FireGroundChannel = table.Column<int>(type: "integer", nullable: true),
+ PageDestination = table.Column<string>(type: "text", nullable: false),
+ GpsPositionId = table.Column<int>(type: "integer", nullable: true),
+ PagerMessage = table.Column<int>(type: "integer", nullable: false)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_ParsedPagerMessages", x => x.ParsedPagerMessageId);
+ table.ForeignKey(
+ name: "FK_ParsedPagerMessages_GpsPositions_GpsPositionId",
+ column: x => x.GpsPositionId,
+ principalTable: "GpsPositions",
+ principalColumn: "GpsPositionId");
+ table.ForeignKey(
+ name: "FK_ParsedPagerMessages_PagerMessages_PagerMessage",
+ column: x => x.PagerMessage,
+ principalTable: "PagerMessages",
+ principalColumn: "PagerMessageId",
+ onDelete: ReferentialAction.Cascade);
+ });
+
+ migrationBuilder.CreateIndex(
+ name: "IX_PagerMessages_Message",
+ table: "PagerMessages",
+ column: "Message");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_ParsedPagerMessages_FirecomJobNo",
+ table: "ParsedPagerMessages",
+ column: "FirecomJobNo");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_ParsedPagerMessages_GpsPositionId",
+ table: "ParsedPagerMessages",
+ column: "GpsPositionId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_ParsedPagerMessages_PagerMessage",
+ table: "ParsedPagerMessages",
+ column: "PagerMessage",
+ unique: true);
+ }
+
+ /// <inheritdoc />
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropTable(
+ name: "ParsedPagerMessages");
+
+ migrationBuilder.DropTable(
+ name: "GpsPositions");
+
+ migrationBuilder.DropTable(
+ name: "PagerMessages");
+ }
+ }
+}
diff --git a/Migrations/PagerContextModelSnapshot.cs b/Migrations/PagerContextModelSnapshot.cs
new file mode 100644
index 0000000..879c13f
--- /dev/null
+++ b/Migrations/PagerContextModelSnapshot.cs
@@ -0,0 +1,156 @@
+// <auto-generated />
+using System;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+using PagerParser;
+
+#nullable disable
+
+namespace PagerParser.Migrations
+{
+ [DbContext(typeof(PagerContext))]
+ partial class PagerContextModelSnapshot : ModelSnapshot
+ {
+ protected override void BuildModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("ProductVersion", "7.0.8")
+ .HasAnnotation("Relational:MaxIdentifierLength", 63);
+
+ NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
+
+ modelBuilder.Entity("PagerParser.GpsPosition", b =>
+ {
+ b.Property<int>("GpsPositionId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer");
+
+ NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("GpsPositionId"));
+
+ b.Property<double>("Latitude")
+ .HasColumnType("double precision");
+
+ b.Property<double>("Longitude")
+ .HasColumnType("double precision");
+
+ b.HasKey("GpsPositionId");
+
+ b.ToTable("GpsPositions");
+ });
+
+ modelBuilder.Entity("PagerParser.PagerMessage", b =>
+ {
+ b.Property<int>("PagerMessageId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer");
+
+ NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("PagerMessageId"));
+
+ b.Property<string>("Message")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<DateTime>("Timestamp")
+ .HasColumnType("timestamp with time zone");
+
+ b.HasKey("PagerMessageId");
+
+ b.HasIndex("Message");
+
+ b.ToTable("PagerMessages");
+ });
+
+ modelBuilder.Entity("PagerParser.ParsedPagerMessage", b =>
+ {
+ b.Property<int>("ParsedPagerMessageId")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer");
+
+ NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("ParsedPagerMessageId"));
+
+ b.Property<int>("AlertLevel")
+ .HasColumnType("integer");
+
+ b.Property<string>("AssignmentArea")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<int>("AttendingServices")
+ .HasColumnType("integer");
+
+ b.Property<string>("Description")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<int?>("FireGroundChannel")
+ .HasColumnType("integer");
+
+ b.Property<int>("FirecomJobNo")
+ .HasColumnType("integer");
+
+ b.Property<int?>("GpsPositionId")
+ .HasColumnType("integer");
+
+ b.Property<int?>("GridReference")
+ .HasColumnType("integer");
+
+ b.Property<string>("JobType")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<string>("MelwaysGrid")
+ .HasColumnType("text");
+
+ b.Property<int?>("MelwaysMapNo")
+ .HasColumnType("integer");
+
+ b.Property<string>("Note")
+ .HasColumnType("text");
+
+ b.Property<string>("PageDestination")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property<int>("PagerMessage")
+ .HasColumnType("integer");
+
+ b.HasKey("ParsedPagerMessageId");
+
+ b.HasIndex("FirecomJobNo");
+
+ b.HasIndex("GpsPositionId");
+
+ b.HasIndex("PagerMessage")
+ .IsUnique();
+
+ b.ToTable("ParsedPagerMessages");
+ });
+
+ modelBuilder.Entity("PagerParser.ParsedPagerMessage", b =>
+ {
+ b.HasOne("PagerParser.GpsPosition", "GpsPosition")
+ .WithMany()
+ .HasForeignKey("GpsPositionId");
+
+ b.HasOne("PagerParser.PagerMessage", "OriginalMessage")
+ .WithOne("ParsedMessage")
+ .HasForeignKey("PagerParser.ParsedPagerMessage", "PagerMessage")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("GpsPosition");
+
+ b.Navigation("OriginalMessage");
+ });
+
+ modelBuilder.Entity("PagerParser.PagerMessage", b =>
+ {
+ b.Navigation("ParsedMessage");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
generated by cgit v1.3 (git 2.53.0) at 2026-06-12 20:25:37 +0000