From 226538299372624c10450e203cefc665fcb439a2 Mon Sep 17 00:00:00 2001 From: Jake Mannens Date: Mon, 5 Feb 2024 15:33:27 +1100 Subject: Removed security migrations --- Migrations/20231001212740_Security.Designer.cs | 492 -------------------- Migrations/20231001212740_Security.cs | 312 ------------- .../20231009045945_SecurityRevision.Designer.cs | 497 --------------------- Migrations/20231009045945_SecurityRevision.cs | 63 --- ...0031326_NullableCurrentUploadedFile.Designer.cs | 490 -------------------- .../20231020031326_NullableCurrentUploadedFile.cs | 97 ---- Migrations/HBContextModelSnapshot.cs | 174 +------- 7 files changed, 20 insertions(+), 2105 deletions(-) delete mode 100644 Migrations/20231001212740_Security.Designer.cs delete mode 100644 Migrations/20231001212740_Security.cs delete mode 100644 Migrations/20231009045945_SecurityRevision.Designer.cs delete mode 100644 Migrations/20231009045945_SecurityRevision.cs delete mode 100644 Migrations/20231020031326_NullableCurrentUploadedFile.Designer.cs delete mode 100644 Migrations/20231020031326_NullableCurrentUploadedFile.cs diff --git a/Migrations/20231001212740_Security.Designer.cs b/Migrations/20231001212740_Security.Designer.cs deleted file mode 100644 index 0b3c8ee..0000000 --- a/Migrations/20231001212740_Security.Designer.cs +++ /dev/null @@ -1,492 +0,0 @@ -// -using System; -using HyperBooru; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace HyperBooru.Migrations -{ - [DbContext(typeof(HBContext))] - [Migration("20231001212740_Security")] - partial class Security - { - /// - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "7.0.11") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Property("AclId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclId")); - - b.HasKey("AclId"); - - b.ToTable("Acls"); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.Property("AclRuleId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclRuleId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Action") - .HasColumnType("integer"); - - b.Property("Permissions") - .HasColumnType("bigint"); - - b.Property("Principal") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("AclRuleId"); - - b.HasIndex("AclId"); - - b.ToTable("AclRules"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.Property("ObjectId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("ObjectId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Guid") - .HasColumnType("uuid"); - - b.Property("Owner") - .IsRequired() - .ValueGeneratedOnAdd() - .HasColumnType("bytea") - .HasDefaultValue(new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - b.HasKey("ObjectId"); - - b.HasIndex("AclId") - .IsUnique(); - - b.HasIndex("Guid"); - - b.ToTable("Objects", (string)null); - - b.UseTptMappingStrategy(); - }); - - modelBuilder.Entity("HyperBooru.LocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("LocalPrincipalId")); - - b.Property("Discriminator") - .IsRequired() - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Sid") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("LocalPrincipalId"); - - b.HasIndex("Name"); - - b.HasIndex("Sid"); - - b.ToTable("SecurityPrincipals", (string)null); - - b.HasDiscriminator("Discriminator").HasValue("LocalPrincipal"); - - b.UseTphMappingStrategy(); - }); - - modelBuilder.Entity("HyperBooru.OcrData", b => - { - b.Property("OcrDataId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("OcrDataId")); - - b.Property("MediaId") - .HasColumnType("integer"); - - b.Property("SearchableText") - .IsRequired() - .HasColumnType("text"); - - b.Property("Text") - .IsRequired() - .HasColumnType("text"); - - b.Property("Timestamp") - .HasColumnType("timestamp with time zone"); - - b.HasKey("OcrDataId"); - - b.HasIndex("MediaId") - .IsUnique(); - - b.ToTable("OcrData"); - }); - - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .HasColumnType("integer"); - - b.Property("MemberOfLocalPrincipalId") - .HasColumnType("integer"); - - b.HasKey("LocalPrincipalId", "MemberOfLocalPrincipalId"); - - b.HasIndex("MemberOfLocalPrincipalId"); - - b.ToTable("SecurityPrincipalMemberships", (string)null); - }); - - modelBuilder.Entity("TagDefinitionTagDefinition", b => - { - b.Property("ImplicitTagsObjectId") - .HasColumnType("integer"); - - b.Property("TagDefinitionObjectId") - .HasColumnType("integer"); - - b.HasKey("ImplicitTagsObjectId", "TagDefinitionObjectId"); - - b.HasIndex("TagDefinitionObjectId"); - - b.ToTable("ImplicitTags", (string)null); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("CurrentUploadedFileId") - .HasColumnType("integer"); - - b.Property("LongDescription") - .HasColumnType("text"); - - b.Property("ShortDescription") - .HasColumnType("text"); - - b.HasIndex("CurrentUploadedFileId") - .IsUnique(); - - b.ToTable("Media", (string)null); - }); - - modelBuilder.Entity("HyperBooru.Tag", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("CreateTime") - .HasColumnType("timestamp with time zone"); - - b.Property("TagDefinitionId") - .HasColumnType("integer"); - - b.Property("TargetObjectId") - .HasColumnType("integer"); - - b.HasIndex("TagDefinitionId"); - - b.HasIndex("TargetObjectId"); - - b.ToTable("Tags", (string)null); - }); - - modelBuilder.Entity("HyperBooru.TagDefinition", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("Alias") - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Namespace") - .HasColumnType("text"); - - b.Property("Source") - .HasColumnType("integer"); - - b.ToTable("TagDefinitions", (string)null); - - b.HasData( - new - { - ObjectId = -1, - Guid = new Guid("ebdad4f8-455a-4351-8017-1d4854d6fa38"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - Name = "nsfw", - Source = 0 - }, - new - { - ObjectId = -2, - Guid = new Guid("ea212801-5bcc-4c0e-814f-fb9d30db58bc"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - Name = "ingest", - Source = 0 - }); - }); - - modelBuilder.Entity("HyperBooru.UploadedFile", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("Checksum") - .IsRequired() - .HasColumnType("text"); - - b.Property("ChecksumVerified") - .HasColumnType("boolean"); - - b.Property("CreateTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Filename") - .HasColumnType("text"); - - b.Property("Height") - .HasColumnType("integer"); - - b.Property("LastAccessTime") - .HasColumnType("timestamp with time zone"); - - b.Property("LastWriteTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Length") - .HasColumnType("bigint"); - - b.Property("MediaObjectId") - .HasColumnType("integer"); - - b.Property("MimeType") - .IsRequired() - .HasColumnType("text"); - - b.Property("UploadTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Width") - .HasColumnType("integer"); - - b.HasIndex("MediaObjectId"); - - b.ToTable("UploadedFiles", (string)null); - }); - - modelBuilder.Entity("HyperBooru.LocalGroup", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.HasDiscriminator().HasValue("LocalGroup"); - }); - - modelBuilder.Entity("HyperBooru.LocalUser", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.Property("PasswordHash") - .IsRequired() - .HasColumnType("text"); - - b.HasDiscriminator().HasValue("LocalUser"); - - b.HasData( - new - { - LocalPrincipalId = -1, - Name = "admin", - Sid = new byte[] { 1, 1, 0, 0, 0, 0, 0, 5, 18, 0, 0, 0 }, - PasswordHash = "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==" - }); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.HasOne("HyperBooru.Acl", null) - .WithMany("Rules") - .HasForeignKey("AclId"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.HasOne("HyperBooru.Acl", "Acl") - .WithOne("Subject") - .HasForeignKey("HyperBooru.HBObject", "AclId"); - - b.Navigation("Acl"); - }); - - modelBuilder.Entity("HyperBooru.OcrData", b => - { - b.HasOne("HyperBooru.Media", "Media") - .WithOne("OcrData") - .HasForeignKey("HyperBooru.OcrData", "MediaId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Media"); - }); - - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.HasOne("HyperBooru.LocalPrincipal", null) - .WithMany() - .HasForeignKey("LocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.LocalGroup", null) - .WithMany() - .HasForeignKey("MemberOfLocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("TagDefinitionTagDefinition", b => - { - b.HasOne("HyperBooru.TagDefinition", null) - .WithMany() - .HasForeignKey("ImplicitTagsObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.TagDefinition", null) - .WithMany() - .HasForeignKey("TagDefinitionObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.HasOne("HyperBooru.UploadedFile", "CurrentUploadedFile") - .WithOne() - .HasForeignKey("HyperBooru.Media", "CurrentUploadedFileId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.Media", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("CurrentUploadedFile"); - }); - - modelBuilder.Entity("HyperBooru.Tag", b => - { - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.Tag", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.TagDefinition", "TagDefinition") - .WithMany() - .HasForeignKey("TagDefinitionId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", "Target") - .WithMany("Tags") - .HasForeignKey("TargetObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("TagDefinition"); - - b.Navigation("Target"); - }); - - modelBuilder.Entity("HyperBooru.TagDefinition", b => - { - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.TagDefinition", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.UploadedFile", b => - { - b.HasOne("HyperBooru.Media", "Media") - .WithMany("UploadedFiles") - .HasForeignKey("MediaObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.UploadedFile", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Media"); - }); - - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Navigation("Rules"); - - b.Navigation("Subject") - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.Navigation("Tags"); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.Navigation("OcrData"); - - b.Navigation("UploadedFiles"); - }); -#pragma warning restore 612, 618 - } - } -} diff --git a/Migrations/20231001212740_Security.cs b/Migrations/20231001212740_Security.cs deleted file mode 100644 index 0e38fde..0000000 --- a/Migrations/20231001212740_Security.cs +++ /dev/null @@ -1,312 +0,0 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace HyperBooru.Migrations -{ - /// - public partial class Security : Migration - { - /// - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropForeignKey( - name: "FK_TagDefinitionTagDefinition_TagDefinitions_ImplicitTagsObjec~", - table: "TagDefinitionTagDefinition"); - - migrationBuilder.DropForeignKey( - name: "FK_TagDefinitionTagDefinition_TagDefinitions_TagDefinitionObje~", - table: "TagDefinitionTagDefinition"); - - migrationBuilder.DropTable( - name: "Users"); - - migrationBuilder.DropPrimaryKey( - name: "PK_TagDefinitionTagDefinition", - table: "TagDefinitionTagDefinition"); - - migrationBuilder.DeleteData( - table: "Objects", - keyColumn: "ObjectId", - keyValue: -3); - - migrationBuilder.RenameTable( - name: "TagDefinitionTagDefinition", - newName: "ImplicitTags"); - - migrationBuilder.RenameIndex( - name: "IX_TagDefinitionTagDefinition_TagDefinitionObjectId", - table: "ImplicitTags", - newName: "IX_ImplicitTags_TagDefinitionObjectId"); - - migrationBuilder.AddColumn( - name: "AclId", - table: "Objects", - type: "integer", - nullable: true); - - migrationBuilder.AddColumn( - name: "Owner", - table: "Objects", - type: "bytea", - nullable: false, - defaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - migrationBuilder.AddPrimaryKey( - name: "PK_ImplicitTags", - table: "ImplicitTags", - columns: new[] { "ImplicitTagsObjectId", "TagDefinitionObjectId" }); - - migrationBuilder.CreateTable( - name: "Acls", - columns: table => new - { - AclId = table.Column(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn) - }, - constraints: table => - { - table.PrimaryKey("PK_Acls", x => x.AclId); - }); - - migrationBuilder.CreateTable( - name: "SecurityPrincipals", - columns: table => new - { - LocalPrincipalId = table.Column(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - Name = table.Column(type: "text", nullable: false), - Sid = table.Column(type: "bytea", nullable: false), - Discriminator = table.Column(type: "text", nullable: false), - PasswordHash = table.Column(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_SecurityPrincipals", x => x.LocalPrincipalId); - }); - - migrationBuilder.CreateTable( - name: "AclRules", - columns: table => new - { - AclRuleId = table.Column(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - Principal = table.Column(type: "bytea", nullable: false), - Action = table.Column(type: "integer", nullable: false), - Permissions = table.Column(type: "bigint", nullable: false), - AclId = table.Column(type: "integer", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_AclRules", x => x.AclRuleId); - table.ForeignKey( - name: "FK_AclRules_Acls_AclId", - column: x => x.AclId, - principalTable: "Acls", - principalColumn: "AclId"); - }); - - migrationBuilder.CreateTable( - name: "SecurityPrincipalMemberships", - columns: table => new - { - LocalPrincipalId = table.Column(type: "integer", nullable: false), - MemberOfLocalPrincipalId = table.Column(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_SecurityPrincipalMemberships", x => new { x.LocalPrincipalId, x.MemberOfLocalPrincipalId }); - table.ForeignKey( - name: "FK_SecurityPrincipalMemberships_SecurityPrincipals_LocalPrinci~", - column: x => x.LocalPrincipalId, - principalTable: "SecurityPrincipals", - principalColumn: "LocalPrincipalId", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_SecurityPrincipalMemberships_SecurityPrincipals_MemberOfLoc~", - column: x => x.MemberOfLocalPrincipalId, - principalTable: "SecurityPrincipals", - principalColumn: "LocalPrincipalId", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.UpdateData( - table: "Objects", - keyColumn: "ObjectId", - keyValue: -2, - columns: new[] { "AclId", "Owner" }, - values: new object[] { null, new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 } }); - - migrationBuilder.UpdateData( - table: "Objects", - keyColumn: "ObjectId", - keyValue: -1, - columns: new[] { "AclId", "Owner" }, - values: new object[] { null, new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 } }); - - migrationBuilder.InsertData( - table: "SecurityPrincipals", - columns: new[] { "LocalPrincipalId", "Discriminator", "Name", "PasswordHash", "Sid" }, - values: new object[] { -1, "LocalUser", "admin", "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==", new byte[] { 1, 1, 0, 0, 0, 0, 0, 5, 18, 0, 0, 0 } }); - - migrationBuilder.CreateIndex( - name: "IX_Objects_AclId", - table: "Objects", - column: "AclId", - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_AclRules_AclId", - table: "AclRules", - column: "AclId"); - - migrationBuilder.CreateIndex( - name: "IX_SecurityPrincipalMemberships_MemberOfLocalPrincipalId", - table: "SecurityPrincipalMemberships", - column: "MemberOfLocalPrincipalId"); - - migrationBuilder.CreateIndex( - name: "IX_SecurityPrincipals_Name", - table: "SecurityPrincipals", - column: "Name"); - - migrationBuilder.CreateIndex( - name: "IX_SecurityPrincipals_Sid", - table: "SecurityPrincipals", - column: "Sid"); - - migrationBuilder.AddForeignKey( - name: "FK_ImplicitTags_TagDefinitions_ImplicitTagsObjectId", - table: "ImplicitTags", - column: "ImplicitTagsObjectId", - principalTable: "TagDefinitions", - principalColumn: "ObjectId", - onDelete: ReferentialAction.Cascade); - - migrationBuilder.AddForeignKey( - name: "FK_ImplicitTags_TagDefinitions_TagDefinitionObjectId", - table: "ImplicitTags", - column: "TagDefinitionObjectId", - principalTable: "TagDefinitions", - principalColumn: "ObjectId", - onDelete: ReferentialAction.Cascade); - - migrationBuilder.AddForeignKey( - name: "FK_Objects_Acls_AclId", - table: "Objects", - column: "AclId", - principalTable: "Acls", - principalColumn: "AclId"); - } - - /// - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropForeignKey( - name: "FK_ImplicitTags_TagDefinitions_ImplicitTagsObjectId", - table: "ImplicitTags"); - - migrationBuilder.DropForeignKey( - name: "FK_ImplicitTags_TagDefinitions_TagDefinitionObjectId", - table: "ImplicitTags"); - - migrationBuilder.DropForeignKey( - name: "FK_Objects_Acls_AclId", - table: "Objects"); - - migrationBuilder.DropTable( - name: "AclRules"); - - migrationBuilder.DropTable( - name: "SecurityPrincipalMemberships"); - - migrationBuilder.DropTable( - name: "Acls"); - - migrationBuilder.DropTable( - name: "SecurityPrincipals"); - - migrationBuilder.DropIndex( - name: "IX_Objects_AclId", - table: "Objects"); - - migrationBuilder.DropPrimaryKey( - name: "PK_ImplicitTags", - table: "ImplicitTags"); - - migrationBuilder.DropColumn( - name: "AclId", - table: "Objects"); - - migrationBuilder.DropColumn( - name: "Owner", - table: "Objects"); - - migrationBuilder.RenameTable( - name: "ImplicitTags", - newName: "TagDefinitionTagDefinition"); - - migrationBuilder.RenameIndex( - name: "IX_ImplicitTags_TagDefinitionObjectId", - table: "TagDefinitionTagDefinition", - newName: "IX_TagDefinitionTagDefinition_TagDefinitionObjectId"); - - migrationBuilder.AddPrimaryKey( - name: "PK_TagDefinitionTagDefinition", - table: "TagDefinitionTagDefinition", - columns: new[] { "ImplicitTagsObjectId", "TagDefinitionObjectId" }); - - migrationBuilder.CreateTable( - name: "Users", - columns: table => new - { - ObjectId = table.Column(type: "integer", nullable: false), - PasswordHash = table.Column(type: "text", nullable: false), - Username = table.Column(type: "text", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_Users", x => x.ObjectId); - table.ForeignKey( - name: "FK_Users_Objects_ObjectId", - column: x => x.ObjectId, - principalTable: "Objects", - principalColumn: "ObjectId", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.InsertData( - table: "Objects", - columns: new[] { "ObjectId", "Guid" }, - values: new object[] { -3, new Guid("4fa948f4-7c45-4f81-bb6b-e417491e6c96") }); - - migrationBuilder.InsertData( - table: "Users", - columns: new[] { "ObjectId", "PasswordHash", "Username" }, - values: new object[] { -3, "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==", "admin" }); - - migrationBuilder.CreateIndex( - name: "IX_Users_Username", - table: "Users", - column: "Username"); - - migrationBuilder.AddForeignKey( - name: "FK_TagDefinitionTagDefinition_TagDefinitions_ImplicitTagsObjec~", - table: "TagDefinitionTagDefinition", - column: "ImplicitTagsObjectId", - principalTable: "TagDefinitions", - principalColumn: "ObjectId", - onDelete: ReferentialAction.Cascade); - - migrationBuilder.AddForeignKey( - name: "FK_TagDefinitionTagDefinition_TagDefinitions_TagDefinitionObje~", - table: "TagDefinitionTagDefinition", - column: "TagDefinitionObjectId", - principalTable: "TagDefinitions", - principalColumn: "ObjectId", - onDelete: ReferentialAction.Cascade); - } - } -} diff --git a/Migrations/20231009045945_SecurityRevision.Designer.cs b/Migrations/20231009045945_SecurityRevision.Designer.cs deleted file mode 100644 index a2c924d..0000000 --- a/Migrations/20231009045945_SecurityRevision.Designer.cs +++ /dev/null @@ -1,497 +0,0 @@ -// -using System; -using HyperBooru; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace HyperBooru.Migrations -{ - [DbContext(typeof(HBContext))] - [Migration("20231009045945_SecurityRevision")] - partial class SecurityRevision - { - /// - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "7.0.11") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Property("AclId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclId")); - - b.HasKey("AclId"); - - b.ToTable("Acls"); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.Property("AclRuleId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclRuleId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Action") - .HasColumnType("integer"); - - b.Property("Permissions") - .HasColumnType("bigint"); - - b.Property("Principal") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("AclRuleId"); - - b.HasIndex("AclId"); - - b.ToTable("AclRules"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.Property("ObjectId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("ObjectId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Guid") - .HasColumnType("uuid"); - - b.Property("Owner") - .IsRequired() - .ValueGeneratedOnAdd() - .HasColumnType("bytea") - .HasDefaultValue(new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - b.HasKey("ObjectId"); - - b.HasIndex("AclId") - .IsUnique(); - - b.HasIndex("Guid"); - - b.ToTable("Objects", (string)null); - - b.UseTptMappingStrategy(); - }); - - modelBuilder.Entity("HyperBooru.LocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("LocalPrincipalId")); - - b.Property("Discriminator") - .IsRequired() - .HasColumnType("text"); - - b.Property("DisplayName") - .IsRequired() - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Sid") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("LocalPrincipalId"); - - b.HasIndex("Name"); - - b.HasIndex("Sid"); - - b.ToTable("SecurityPrincipals", (string)null); - - b.HasDiscriminator("Discriminator").HasValue("LocalPrincipal"); - - b.UseTphMappingStrategy(); - }); - - modelBuilder.Entity("HyperBooru.OcrData", b => - { - b.Property("OcrDataId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("OcrDataId")); - - b.Property("MediaId") - .HasColumnType("integer"); - - b.Property("SearchableText") - .IsRequired() - .HasColumnType("text"); - - b.Property("Text") - .IsRequired() - .HasColumnType("text"); - - b.Property("Timestamp") - .HasColumnType("timestamp with time zone"); - - b.HasKey("OcrDataId"); - - b.HasIndex("MediaId") - .IsUnique(); - - b.ToTable("OcrData"); - }); - - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .HasColumnType("integer"); - - b.Property("MemberOfLocalPrincipalId") - .HasColumnType("integer"); - - b.HasKey("LocalPrincipalId", "MemberOfLocalPrincipalId"); - - b.HasIndex("MemberOfLocalPrincipalId"); - - b.ToTable("SecurityPrincipalMemberships", (string)null); - }); - - modelBuilder.Entity("TagDefinitionTagDefinition", b => - { - b.Property("ImplicitTagsObjectId") - .HasColumnType("integer"); - - b.Property("TagDefinitionObjectId") - .HasColumnType("integer"); - - b.HasKey("ImplicitTagsObjectId", "TagDefinitionObjectId"); - - b.HasIndex("TagDefinitionObjectId"); - - b.ToTable("ImplicitTags", (string)null); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("CurrentUploadedFileId") - .HasColumnType("integer"); - - b.Property("LongDescription") - .HasColumnType("text"); - - b.Property("ShortDescription") - .HasColumnType("text"); - - b.HasIndex("CurrentUploadedFileId") - .IsUnique(); - - b.ToTable("Media", (string)null); - }); - - modelBuilder.Entity("HyperBooru.Tag", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("CreateTime") - .HasColumnType("timestamp with time zone"); - - b.Property("TagDefinitionId") - .HasColumnType("integer"); - - b.Property("TargetObjectId") - .HasColumnType("integer"); - - b.HasIndex("TagDefinitionId"); - - b.HasIndex("TargetObjectId"); - - b.ToTable("Tags", (string)null); - }); - - modelBuilder.Entity("HyperBooru.TagDefinition", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("Alias") - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Namespace") - .HasColumnType("text"); - - b.Property("Source") - .HasColumnType("integer"); - - b.ToTable("TagDefinitions", (string)null); - - b.HasData( - new - { - ObjectId = -1, - Guid = new Guid("ebdad4f8-455a-4351-8017-1d4854d6fa38"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - Name = "nsfw", - Source = 0 - }, - new - { - ObjectId = -2, - Guid = new Guid("ea212801-5bcc-4c0e-814f-fb9d30db58bc"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - Name = "ingest", - Source = 0 - }); - }); - - modelBuilder.Entity("HyperBooru.UploadedFile", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("Checksum") - .IsRequired() - .HasColumnType("text"); - - b.Property("ChecksumVerified") - .HasColumnType("boolean"); - - b.Property("CreateTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Filename") - .HasColumnType("text"); - - b.Property("Height") - .HasColumnType("integer"); - - b.Property("LastAccessTime") - .HasColumnType("timestamp with time zone"); - - b.Property("LastWriteTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Length") - .HasColumnType("bigint"); - - b.Property("MediaObjectId") - .HasColumnType("integer"); - - b.Property("MimeType") - .IsRequired() - .HasColumnType("text"); - - b.Property("UploadTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Width") - .HasColumnType("integer"); - - b.HasIndex("MediaObjectId"); - - b.ToTable("UploadedFiles", (string)null); - }); - - modelBuilder.Entity("HyperBooru.LocalGroup", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.HasDiscriminator().HasValue("LocalGroup"); - }); - - modelBuilder.Entity("HyperBooru.LocalUser", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.Property("PasswordHash") - .IsRequired() - .HasColumnType("text"); - - b.HasDiscriminator().HasValue("LocalUser"); - - b.HasData( - new - { - LocalPrincipalId = -1, - DisplayName = "Administrator", - Name = "Administrator", - Sid = new byte[] { 1, 1, 0, 0, 0, 0, 0, 5, 18, 0, 0, 0 }, - PasswordHash = "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==" - }); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.HasOne("HyperBooru.Acl", null) - .WithMany("Rules") - .HasForeignKey("AclId"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.HasOne("HyperBooru.Acl", "Acl") - .WithOne("Subject") - .HasForeignKey("HyperBooru.HBObject", "AclId"); - - b.Navigation("Acl"); - }); - - modelBuilder.Entity("HyperBooru.OcrData", b => - { - b.HasOne("HyperBooru.Media", "Media") - .WithOne("OcrData") - .HasForeignKey("HyperBooru.OcrData", "MediaId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Media"); - }); - - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.HasOne("HyperBooru.LocalPrincipal", null) - .WithMany() - .HasForeignKey("LocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.LocalGroup", null) - .WithMany() - .HasForeignKey("MemberOfLocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("TagDefinitionTagDefinition", b => - { - b.HasOne("HyperBooru.TagDefinition", null) - .WithMany() - .HasForeignKey("ImplicitTagsObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.TagDefinition", null) - .WithMany() - .HasForeignKey("TagDefinitionObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.HasOne("HyperBooru.UploadedFile", "CurrentUploadedFile") - .WithOne() - .HasForeignKey("HyperBooru.Media", "CurrentUploadedFileId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.Media", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("CurrentUploadedFile"); - }); - - modelBuilder.Entity("HyperBooru.Tag", b => - { - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.Tag", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.TagDefinition", "TagDefinition") - .WithMany() - .HasForeignKey("TagDefinitionId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", "Target") - .WithMany("Tags") - .HasForeignKey("TargetObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("TagDefinition"); - - b.Navigation("Target"); - }); - - modelBuilder.Entity("HyperBooru.TagDefinition", b => - { - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.TagDefinition", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.UploadedFile", b => - { - b.HasOne("HyperBooru.Media", "Media") - .WithMany("UploadedFiles") - .HasForeignKey("MediaObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.UploadedFile", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Media"); - }); - - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Navigation("Rules"); - - b.Navigation("Subject") - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.Navigation("Tags"); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.Navigation("OcrData"); - - b.Navigation("UploadedFiles"); - }); -#pragma warning restore 612, 618 - } - } -} diff --git a/Migrations/20231009045945_SecurityRevision.cs b/Migrations/20231009045945_SecurityRevision.cs deleted file mode 100644 index 03fbd60..0000000 --- a/Migrations/20231009045945_SecurityRevision.cs +++ /dev/null @@ -1,63 +0,0 @@ -using Microsoft.EntityFrameworkCore.Migrations; - -#nullable disable - -namespace HyperBooru.Migrations -{ - /// - public partial class SecurityRevision : Migration - { - /// - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.AddColumn( - name: "DisplayName", - table: "SecurityPrincipals", - type: "text", - nullable: false, - defaultValue: ""); - - migrationBuilder.AlterColumn( - name: "Owner", - table: "Objects", - type: "bytea", - nullable: false, - defaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - oldClrType: typeof(byte[]), - oldType: "bytea", - oldDefaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - migrationBuilder.UpdateData( - table: "SecurityPrincipals", - keyColumn: "LocalPrincipalId", - keyValue: -1, - columns: new[] { "DisplayName", "Name" }, - values: new object[] { "Administrator", "Administrator" }); - } - - /// - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropColumn( - name: "DisplayName", - table: "SecurityPrincipals"); - - migrationBuilder.AlterColumn( - name: "Owner", - table: "Objects", - type: "bytea", - nullable: false, - defaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - oldClrType: typeof(byte[]), - oldType: "bytea", - oldDefaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - migrationBuilder.UpdateData( - table: "SecurityPrincipals", - keyColumn: "LocalPrincipalId", - keyValue: -1, - column: "Name", - value: "admin"); - } - } -} diff --git a/Migrations/20231020031326_NullableCurrentUploadedFile.Designer.cs b/Migrations/20231020031326_NullableCurrentUploadedFile.Designer.cs deleted file mode 100644 index 89f933c..0000000 --- a/Migrations/20231020031326_NullableCurrentUploadedFile.Designer.cs +++ /dev/null @@ -1,490 +0,0 @@ -// -using System; -using HyperBooru; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace HyperBooru.Migrations -{ - [DbContext(typeof(HBContext))] - [Migration("20231020031326_NullableCurrentUploadedFile")] - partial class NullableCurrentUploadedFile - { - /// - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "7.0.12") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Property("AclId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclId")); - - b.HasKey("AclId"); - - b.ToTable("Acls"); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.Property("AclRuleId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclRuleId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Action") - .HasColumnType("integer"); - - b.Property("Permissions") - .HasColumnType("bigint"); - - b.Property("Principal") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("AclRuleId"); - - b.HasIndex("AclId"); - - b.ToTable("AclRules"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.Property("ObjectId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("ObjectId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Guid") - .HasColumnType("uuid"); - - b.Property("Owner") - .IsRequired() - .ValueGeneratedOnAdd() - .HasColumnType("bytea") - .HasDefaultValue(new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - b.HasKey("ObjectId"); - - b.HasIndex("AclId") - .IsUnique(); - - b.HasIndex("Guid"); - - b.ToTable("Objects", (string)null); - - b.UseTptMappingStrategy(); - }); - - modelBuilder.Entity("HyperBooru.LocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("LocalPrincipalId")); - - b.Property("Discriminator") - .IsRequired() - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Sid") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("LocalPrincipalId"); - - b.HasIndex("Name"); - - b.HasIndex("Sid"); - - b.ToTable("SecurityPrincipals", (string)null); - - b.HasDiscriminator("Discriminator").HasValue("LocalPrincipal"); - - b.UseTphMappingStrategy(); - }); - - modelBuilder.Entity("HyperBooru.OcrData", b => - { - b.Property("OcrDataId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("OcrDataId")); - - b.Property("MediaId") - .HasColumnType("integer"); - - b.Property("SearchableText") - .IsRequired() - .HasColumnType("text"); - - b.Property("Text") - .IsRequired() - .HasColumnType("text"); - - b.Property("Timestamp") - .HasColumnType("timestamp with time zone"); - - b.HasKey("OcrDataId"); - - b.HasIndex("MediaId") - .IsUnique(); - - b.ToTable("OcrData"); - }); - - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .HasColumnType("integer"); - - b.Property("MemberOfLocalPrincipalId") - .HasColumnType("integer"); - - b.HasKey("LocalPrincipalId", "MemberOfLocalPrincipalId"); - - b.HasIndex("MemberOfLocalPrincipalId"); - - b.ToTable("SecurityPrincipalMemberships", (string)null); - }); - - modelBuilder.Entity("TagDefinitionTagDefinition", b => - { - b.Property("ImplicitTagsObjectId") - .HasColumnType("integer"); - - b.Property("TagDefinitionObjectId") - .HasColumnType("integer"); - - b.HasKey("ImplicitTagsObjectId", "TagDefinitionObjectId"); - - b.HasIndex("TagDefinitionObjectId"); - - b.ToTable("ImplicitTags", (string)null); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("CurrentUploadedFileId") - .HasColumnType("integer"); - - b.Property("LongDescription") - .HasColumnType("text"); - - b.Property("ShortDescription") - .HasColumnType("text"); - - b.HasIndex("CurrentUploadedFileId") - .IsUnique(); - - b.ToTable("Media", (string)null); - }); - - modelBuilder.Entity("HyperBooru.Tag", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("CreateTime") - .HasColumnType("timestamp with time zone"); - - b.Property("TagDefinitionId") - .HasColumnType("integer"); - - b.Property("TargetObjectId") - .HasColumnType("integer"); - - b.HasIndex("TagDefinitionId"); - - b.HasIndex("TargetObjectId"); - - b.ToTable("Tags", (string)null); - }); - - modelBuilder.Entity("HyperBooru.TagDefinition", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("Alias") - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Namespace") - .HasColumnType("text"); - - b.Property("Source") - .HasColumnType("integer"); - - b.ToTable("TagDefinitions", (string)null); - - b.HasData( - new - { - ObjectId = -1, - Guid = new Guid("ebdad4f8-455a-4351-8017-1d4854d6fa38"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - Name = "nsfw", - Source = 0 - }, - new - { - ObjectId = -2, - Guid = new Guid("ea212801-5bcc-4c0e-814f-fb9d30db58bc"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - Name = "ingest", - Source = 0 - }); - }); - - modelBuilder.Entity("HyperBooru.UploadedFile", b => - { - b.HasBaseType("HyperBooru.HBObject"); - - b.Property("Checksum") - .IsRequired() - .HasColumnType("text"); - - b.Property("ChecksumVerified") - .HasColumnType("boolean"); - - b.Property("CreateTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Filename") - .HasColumnType("text"); - - b.Property("Height") - .HasColumnType("integer"); - - b.Property("LastAccessTime") - .HasColumnType("timestamp with time zone"); - - b.Property("LastWriteTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Length") - .HasColumnType("bigint"); - - b.Property("MediaObjectId") - .HasColumnType("integer"); - - b.Property("MimeType") - .IsRequired() - .HasColumnType("text"); - - b.Property("UploadTime") - .HasColumnType("timestamp with time zone"); - - b.Property("Width") - .HasColumnType("integer"); - - b.HasIndex("MediaObjectId"); - - b.ToTable("UploadedFiles", (string)null); - }); - - modelBuilder.Entity("HyperBooru.LocalGroup", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.HasDiscriminator().HasValue("LocalGroup"); - }); - - modelBuilder.Entity("HyperBooru.LocalUser", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.Property("PasswordHash") - .IsRequired() - .HasColumnType("text"); - - b.HasDiscriminator().HasValue("LocalUser"); - - b.HasData( - new - { - LocalPrincipalId = -1, - Name = "Administrator", - Sid = new byte[] { 1, 1, 0, 0, 0, 0, 0, 5, 18, 0, 0, 0 }, - PasswordHash = "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==" - }); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.HasOne("HyperBooru.Acl", null) - .WithMany("Rules") - .HasForeignKey("AclId"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.HasOne("HyperBooru.Acl", "Acl") - .WithOne("Subject") - .HasForeignKey("HyperBooru.HBObject", "AclId"); - - b.Navigation("Acl"); - }); - - modelBuilder.Entity("HyperBooru.OcrData", b => - { - b.HasOne("HyperBooru.Media", "Media") - .WithOne("OcrData") - .HasForeignKey("HyperBooru.OcrData", "MediaId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Media"); - }); - - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.HasOne("HyperBooru.LocalPrincipal", null) - .WithMany() - .HasForeignKey("LocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.LocalGroup", null) - .WithMany() - .HasForeignKey("MemberOfLocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("TagDefinitionTagDefinition", b => - { - b.HasOne("HyperBooru.TagDefinition", null) - .WithMany() - .HasForeignKey("ImplicitTagsObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.TagDefinition", null) - .WithMany() - .HasForeignKey("TagDefinitionObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.HasOne("HyperBooru.UploadedFile", "CurrentUploadedFile") - .WithOne() - .HasForeignKey("HyperBooru.Media", "CurrentUploadedFileId"); - - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.Media", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("CurrentUploadedFile"); - }); - - modelBuilder.Entity("HyperBooru.Tag", b => - { - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.Tag", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.TagDefinition", "TagDefinition") - .WithMany() - .HasForeignKey("TagDefinitionId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", "Target") - .WithMany("Tags") - .HasForeignKey("TargetObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("TagDefinition"); - - b.Navigation("Target"); - }); - - modelBuilder.Entity("HyperBooru.TagDefinition", b => - { - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.TagDefinition", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.UploadedFile", b => - { - b.HasOne("HyperBooru.Media", "Media") - .WithMany("UploadedFiles") - .HasForeignKey("MediaObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.HBObject", null) - .WithOne() - .HasForeignKey("HyperBooru.UploadedFile", "ObjectId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Media"); - }); - - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Navigation("Rules"); - - b.Navigation("Subject") - .IsRequired(); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.Navigation("Tags"); - }); - - modelBuilder.Entity("HyperBooru.Media", b => - { - b.Navigation("OcrData"); - - b.Navigation("UploadedFiles"); - }); -#pragma warning restore 612, 618 - } - } -} diff --git a/Migrations/20231020031326_NullableCurrentUploadedFile.cs b/Migrations/20231020031326_NullableCurrentUploadedFile.cs deleted file mode 100644 index 5159d16..0000000 --- a/Migrations/20231020031326_NullableCurrentUploadedFile.cs +++ /dev/null @@ -1,97 +0,0 @@ -using Microsoft.EntityFrameworkCore.Migrations; - -#nullable disable - -namespace HyperBooru.Migrations -{ - /// - public partial class NullableCurrentUploadedFile : Migration - { - /// - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropForeignKey( - name: "FK_Media_UploadedFiles_CurrentUploadedFileId", - table: "Media"); - - migrationBuilder.DropColumn( - name: "DisplayName", - table: "SecurityPrincipals"); - - migrationBuilder.AlterColumn( - name: "Owner", - table: "Objects", - type: "bytea", - nullable: false, - defaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - oldClrType: typeof(byte[]), - oldType: "bytea", - oldDefaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - migrationBuilder.AlterColumn( - name: "CurrentUploadedFileId", - table: "Media", - type: "integer", - nullable: true, - oldClrType: typeof(int), - oldType: "integer"); - - migrationBuilder.AddForeignKey( - name: "FK_Media_UploadedFiles_CurrentUploadedFileId", - table: "Media", - column: "CurrentUploadedFileId", - principalTable: "UploadedFiles", - principalColumn: "ObjectId"); - } - - /// - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropForeignKey( - name: "FK_Media_UploadedFiles_CurrentUploadedFileId", - table: "Media"); - - migrationBuilder.AddColumn( - name: "DisplayName", - table: "SecurityPrincipals", - type: "text", - nullable: false, - defaultValue: ""); - - migrationBuilder.AlterColumn( - name: "Owner", - table: "Objects", - type: "bytea", - nullable: false, - defaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, - oldClrType: typeof(byte[]), - oldType: "bytea", - oldDefaultValue: new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - - migrationBuilder.AlterColumn( - name: "CurrentUploadedFileId", - table: "Media", - type: "integer", - nullable: false, - defaultValue: 0, - oldClrType: typeof(int), - oldType: "integer", - oldNullable: true); - - migrationBuilder.UpdateData( - table: "SecurityPrincipals", - keyColumn: "LocalPrincipalId", - keyValue: -1, - column: "DisplayName", - value: "Administrator"); - - migrationBuilder.AddForeignKey( - name: "FK_Media_UploadedFiles_CurrentUploadedFileId", - table: "Media", - column: "CurrentUploadedFileId", - principalTable: "UploadedFiles", - principalColumn: "ObjectId", - onDelete: ReferentialAction.Cascade); - } - } -} diff --git a/Migrations/HBContextModelSnapshot.cs b/Migrations/HBContextModelSnapshot.cs index 9341db6..5d2cf4c 100644 --- a/Migrations/HBContextModelSnapshot.cs +++ b/Migrations/HBContextModelSnapshot.cs @@ -17,52 +17,11 @@ namespace HyperBooru.Migrations { #pragma warning disable 612, 618 modelBuilder - .HasAnnotation("ProductVersion", "7.0.12") + .HasAnnotation("ProductVersion", "7.0.10") .HasAnnotation("Relational:MaxIdentifierLength", 63); NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - modelBuilder.Entity("HyperBooru.Acl", b => - { - b.Property("AclId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclId")); - - b.HasKey("AclId"); - - b.ToTable("Acls"); - }); - - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.Property("AclRuleId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("AclRuleId")); - - b.Property("AclId") - .HasColumnType("integer"); - - b.Property("Action") - .HasColumnType("integer"); - - b.Property("Permissions") - .HasColumnType("bigint"); - - b.Property("Principal") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("AclRuleId"); - - b.HasIndex("AclId"); - - b.ToTable("AclRules"); - }); - modelBuilder.Entity("HyperBooru.HBObject", b => { b.Property("ObjectId") @@ -71,23 +30,11 @@ namespace HyperBooru.Migrations NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("ObjectId")); - b.Property("AclId") - .HasColumnType("integer"); - b.Property("Guid") .HasColumnType("uuid"); - b.Property("Owner") - .IsRequired() - .ValueGeneratedOnAdd() - .HasColumnType("bytea") - .HasDefaultValue(new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }); - b.HasKey("ObjectId"); - b.HasIndex("AclId") - .IsUnique(); - b.HasIndex("Guid"); b.ToTable("Objects", (string)null); @@ -95,39 +42,6 @@ namespace HyperBooru.Migrations b.UseTptMappingStrategy(); }); - modelBuilder.Entity("HyperBooru.LocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("LocalPrincipalId")); - - b.Property("Discriminator") - .IsRequired() - .HasColumnType("text"); - - b.Property("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property("Sid") - .IsRequired() - .HasColumnType("bytea"); - - b.HasKey("LocalPrincipalId"); - - b.HasIndex("Name"); - - b.HasIndex("Sid"); - - b.ToTable("SecurityPrincipals", (string)null); - - b.HasDiscriminator("Discriminator").HasValue("LocalPrincipal"); - - b.UseTphMappingStrategy(); - }); - modelBuilder.Entity("HyperBooru.OcrData", b => { b.Property("OcrDataId") @@ -158,21 +72,6 @@ namespace HyperBooru.Migrations b.ToTable("OcrData"); }); - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.Property("LocalPrincipalId") - .HasColumnType("integer"); - - b.Property("MemberOfLocalPrincipalId") - .HasColumnType("integer"); - - b.HasKey("LocalPrincipalId", "MemberOfLocalPrincipalId"); - - b.HasIndex("MemberOfLocalPrincipalId"); - - b.ToTable("SecurityPrincipalMemberships", (string)null); - }); - modelBuilder.Entity("TagDefinitionTagDefinition", b => { b.Property("ImplicitTagsObjectId") @@ -185,7 +84,7 @@ namespace HyperBooru.Migrations b.HasIndex("TagDefinitionObjectId"); - b.ToTable("ImplicitTags", (string)null); + b.ToTable("TagDefinitionTagDefinition"); }); modelBuilder.Entity("HyperBooru.Media", b => @@ -251,7 +150,6 @@ namespace HyperBooru.Migrations { ObjectId = -1, Guid = new Guid("ebdad4f8-455a-4351-8017-1d4854d6fa38"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, Name = "nsfw", Source = 0 }, @@ -259,7 +157,6 @@ namespace HyperBooru.Migrations { ObjectId = -2, Guid = new Guid("ea212801-5bcc-4c0e-814f-fb9d30db58bc"), - Owner = new byte[] { 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0 }, Name = "ingest", Source = 0 }); @@ -312,49 +209,32 @@ namespace HyperBooru.Migrations b.ToTable("UploadedFiles", (string)null); }); - modelBuilder.Entity("HyperBooru.LocalGroup", b => + modelBuilder.Entity("HyperBooru.User", b => { - b.HasBaseType("HyperBooru.LocalPrincipal"); - - b.HasDiscriminator().HasValue("LocalGroup"); - }); - - modelBuilder.Entity("HyperBooru.LocalUser", b => - { - b.HasBaseType("HyperBooru.LocalPrincipal"); + b.HasBaseType("HyperBooru.HBObject"); b.Property("PasswordHash") .IsRequired() .HasColumnType("text"); - b.HasDiscriminator().HasValue("LocalUser"); + b.Property("Username") + .IsRequired() + .HasColumnType("text"); + + b.HasIndex("Username"); + + b.ToTable("Users"); b.HasData( new { - LocalPrincipalId = -1, - Name = "Administrator", - Sid = new byte[] { 1, 1, 0, 0, 0, 0, 0, 5, 18, 0, 0, 0 }, - PasswordHash = "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==" + ObjectId = -3, + Guid = new Guid("4fa948f4-7c45-4f81-bb6b-e417491e6c96"), + PasswordHash = "P4geAuE2yX/PDRHuJSq74FF5vO782rWz5c0LAQPR8m45DEYAONhu1wYnAn60PSNyjocqEBdnCeKCJfK3sKyuWw==", + Username = "admin" }); }); - modelBuilder.Entity("HyperBooru.AclRule", b => - { - b.HasOne("HyperBooru.Acl", null) - .WithMany("Rules") - .HasForeignKey("AclId"); - }); - - modelBuilder.Entity("HyperBooru.HBObject", b => - { - b.HasOne("HyperBooru.Acl", "Acl") - .WithOne("Subject") - .HasForeignKey("HyperBooru.HBObject", "AclId"); - - b.Navigation("Acl"); - }); - modelBuilder.Entity("HyperBooru.OcrData", b => { b.HasOne("HyperBooru.Media", "Media") @@ -366,21 +246,6 @@ namespace HyperBooru.Migrations b.Navigation("Media"); }); - modelBuilder.Entity("LocalGroupLocalPrincipal", b => - { - b.HasOne("HyperBooru.LocalPrincipal", null) - .WithMany() - .HasForeignKey("LocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("HyperBooru.LocalGroup", null) - .WithMany() - .HasForeignKey("MemberOfLocalPrincipalId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - modelBuilder.Entity("TagDefinitionTagDefinition", b => { b.HasOne("HyperBooru.TagDefinition", null) @@ -462,11 +327,12 @@ namespace HyperBooru.Migrations b.Navigation("Media"); }); - modelBuilder.Entity("HyperBooru.Acl", b => + modelBuilder.Entity("HyperBooru.User", b => { - b.Navigation("Rules"); - - b.Navigation("Subject") + b.HasOne("HyperBooru.HBObject", null) + .WithOne() + .HasForeignKey("HyperBooru.User", "ObjectId") + .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); -- cgit v1.3