summaryrefslogtreecommitdiff
path: root/Migrations/20230814013743_Initial.cs
diff options
context:
space:
mode:
Diffstat (limited to 'Migrations/20230814013743_Initial.cs')
-rw-r--r--Migrations/20230814013743_Initial.cs199
1 files changed, 0 insertions, 199 deletions
diff --git a/Migrations/20230814013743_Initial.cs b/Migrations/20230814013743_Initial.cs
deleted file mode 100644
index 1390c18..0000000
--- a/Migrations/20230814013743_Initial.cs
+++ /dev/null
@@ -1,199 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-#pragma warning disable CA1814 // Prefer jagged arrays over multidimensional
-
-namespace HyperBooru.Migrations
-{
- /// <inheritdoc />
- public partial class Initial : Migration
- {
- /// <inheritdoc />
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "Objects",
- columns: table => new
- {
- ObjectId = table.Column<int>(type: "INTEGER", nullable: false)
- .Annotation("Sqlite:Autoincrement", true),
- Guid = table.Column<Guid>(type: "TEXT", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Objects", x => x.ObjectId);
- });
-
- migrationBuilder.CreateTable(
- name: "Media",
- columns: table => new
- {
- ObjectId = table.Column<int>(type: "INTEGER", nullable: false)
- .Annotation("Sqlite:Autoincrement", true),
- Checksum = table.Column<string>(type: "TEXT", nullable: false),
- MimeType = table.Column<string>(type: "TEXT", nullable: false),
- ShortDescription = table.Column<string>(type: "TEXT", nullable: true),
- LongDescription = table.Column<string>(type: "TEXT", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Media", x => x.ObjectId);
- table.ForeignKey(
- name: "FK_Media_Objects_ObjectId",
- column: x => x.ObjectId,
- principalTable: "Objects",
- principalColumn: "ObjectId",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "TagDefinitions",
- columns: table => new
- {
- ObjectId = table.Column<int>(type: "INTEGER", nullable: false)
- .Annotation("Sqlite:Autoincrement", true),
- Source = table.Column<int>(type: "INTEGER", nullable: false),
- Namespace = table.Column<string>(type: "TEXT", nullable: true),
- Name = table.Column<string>(type: "TEXT", nullable: false),
- TagDefinitionObjectId = table.Column<int>(type: "INTEGER", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_TagDefinitions", x => x.ObjectId);
- table.ForeignKey(
- name: "FK_TagDefinitions_Objects_ObjectId",
- column: x => x.ObjectId,
- principalTable: "Objects",
- principalColumn: "ObjectId",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_TagDefinitions_TagDefinitions_TagDefinitionObjectId",
- column: x => x.TagDefinitionObjectId,
- principalTable: "TagDefinitions",
- principalColumn: "ObjectId");
- });
-
- migrationBuilder.CreateTable(
- name: "UploadedFiles",
- columns: table => new
- {
- UploadedFileId = table.Column<int>(type: "INTEGER", nullable: false)
- .Annotation("Sqlite:Autoincrement", true),
- OriginalChecksum = table.Column<string>(type: "TEXT", nullable: false),
- Filename = table.Column<string>(type: "TEXT", nullable: true),
- UploadTime = table.Column<DateTime>(type: "TEXT", nullable: false),
- LastAccessTime = table.Column<DateTime>(type: "TEXT", nullable: true),
- LastWriteTime = table.Column<DateTime>(type: "TEXT", nullable: true),
- CreateTime = table.Column<DateTime>(type: "TEXT", nullable: true),
- MediaObjectId = table.Column<int>(type: "INTEGER", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_UploadedFiles", x => x.UploadedFileId);
- table.ForeignKey(
- name: "FK_UploadedFiles_Media_MediaObjectId",
- column: x => x.MediaObjectId,
- principalTable: "Media",
- principalColumn: "ObjectId",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Tags",
- columns: table => new
- {
- ObjectId = table.Column<int>(type: "INTEGER", nullable: false)
- .Annotation("Sqlite:Autoincrement", true),
- TagDefinitionObjectId = table.Column<int>(type: "INTEGER", nullable: false),
- CreateTime = table.Column<DateTime>(type: "TEXT", nullable: false),
- TargetObjectId = table.Column<int>(type: "INTEGER", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Tags", x => x.ObjectId);
- table.ForeignKey(
- name: "FK_Tags_Objects_ObjectId",
- column: x => x.ObjectId,
- principalTable: "Objects",
- principalColumn: "ObjectId",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_Tags_Objects_TargetObjectId",
- column: x => x.TargetObjectId,
- principalTable: "Objects",
- principalColumn: "ObjectId",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_Tags_TagDefinitions_TagDefinitionObjectId",
- column: x => x.TagDefinitionObjectId,
- principalTable: "TagDefinitions",
- principalColumn: "ObjectId",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.InsertData(
- table: "Objects",
- columns: new[] { "ObjectId", "Guid" },
- values: new object[,]
- {
- { -2, new Guid("716ac11f-135a-433c-84a7-7bdfddbec004") },
- { -1, new Guid("cbd871cb-8790-4519-9f74-90d1e13a48a0") }
- });
-
- migrationBuilder.InsertData(
- table: "TagDefinitions",
- columns: new[] { "ObjectId", "Name", "Namespace", "Source", "TagDefinitionObjectId" },
- values: new object[,]
- {
- { -2, "ingest", null, 0, null },
- { -1, "nsfw", null, 0, null }
- });
-
- migrationBuilder.CreateIndex(
- name: "IX_Objects_Guid",
- table: "Objects",
- column: "Guid");
-
- migrationBuilder.CreateIndex(
- name: "IX_TagDefinitions_TagDefinitionObjectId",
- table: "TagDefinitions",
- column: "TagDefinitionObjectId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Tags_TagDefinitionObjectId",
- table: "Tags",
- column: "TagDefinitionObjectId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Tags_TargetObjectId",
- table: "Tags",
- column: "TargetObjectId");
-
- migrationBuilder.CreateIndex(
- name: "IX_UploadedFiles_MediaObjectId",
- table: "UploadedFiles",
- column: "MediaObjectId");
- }
-
- /// <inheritdoc />
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "Tags");
-
- migrationBuilder.DropTable(
- name: "UploadedFiles");
-
- migrationBuilder.DropTable(
- name: "TagDefinitions");
-
- migrationBuilder.DropTable(
- name: "Media");
-
- migrationBuilder.DropTable(
- name: "Objects");
- }
- }
-}
generated by cgit v1.3 (git 2.53.0) at 2026-06-13 03:39:33 +0000