From 842502e82c4ddfea05a5f77c361aaa27f75afc42 Mon Sep 17 00:00:00 2001 From: ivar Date: Sun, 26 Oct 2025 22:57:28 +0100 Subject: Refactor db schema and add audits --- .../Migrations/20251013213511_Initial.Designer.cs | 93 ---------------------- 1 file changed, 93 deletions(-) delete mode 100644 api/WhatApi/Migrations/20251013213511_Initial.Designer.cs (limited to 'api/WhatApi/Migrations/20251013213511_Initial.Designer.cs') diff --git a/api/WhatApi/Migrations/20251013213511_Initial.Designer.cs b/api/WhatApi/Migrations/20251013213511_Initial.Designer.cs deleted file mode 100644 index 5ddcc9f..0000000 --- a/api/WhatApi/Migrations/20251013213511_Initial.Designer.cs +++ /dev/null @@ -1,93 +0,0 @@ -// -using System; -using System.Net; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using NetTopologySuite.Geometries; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; -using WhatApi; - -#nullable disable - -namespace WhatApi.Migrations -{ - [DbContext(typeof(Database))] - [Migration("20251013213511_Initial")] - partial class Initial - { - /// - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "9.0.9") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.HasPostgresExtension(modelBuilder, "postgis"); - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("WhatApi.Tables.Content", b => - { - b.Property("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property("BlobId") - .HasColumnType("uuid"); - - b.Property("Created") - .HasColumnType("timestamp with time zone"); - - b.Property("Ip") - .IsRequired() - .HasColumnType("inet"); - - b.Property("Mime") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("Id"); - - b.ToTable("Content"); - }); - - modelBuilder.Entity("WhatApi.Tables.Place", b => - { - b.Property("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property("ContentId") - .HasColumnType("uuid"); - - b.Property("Location") - .IsRequired() - .HasColumnType("geometry(point,4326)"); - - b.HasKey("Id"); - - b.HasIndex("ContentId"); - - b.HasIndex("Location"); - - NpgsqlIndexBuilderExtensions.HasMethod(b.HasIndex("Location"), "gist"); - - b.ToTable("Place", (string)null); - }); - - modelBuilder.Entity("WhatApi.Tables.Place", b => - { - b.HasOne("WhatApi.Tables.Content", "Content") - .WithMany() - .HasForeignKey("ContentId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Content"); - }); -#pragma warning restore 612, 618 - } - } -} -- cgit v1.3