using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace HyperBooru.Migrations
{
    /// <inheritdoc />
    public partial class UploadedFileMetadata : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.RenameColumn(
                name: "OriginalChecksum",
                table: "UploadedFiles",
                newName: "Checksum");

            migrationBuilder.AddColumn<string>(
                name: "MimeType",
                table: "UploadedFiles",
                type: "text",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "Height",
                table: "UploadedFiles",
                type: "integer",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "Width",
                table: "UploadedFiles",
                type: "integer",
                nullable: true);

            migrationBuilder.Sql(@"
                UPDATE
                  ""UploadedFiles""
                SET
                  ""MimeType"" = m.""MimeType"",
                  ""Width"" = m.""Width"",
                  ""Height"" = m.""Height""
                FROM
                  (SELECT
                    ""ObjectId"",
                    ""MimeType"",
                    ""Width"",
                    ""Height""
                  FROM
                    ""Media"") AS m
                WHERE
                  ""UploadedFiles"".""MediaObjectId"" = m.""ObjectId""");

            migrationBuilder.Sql(@"
                ALTER TABLE
                    ""UploadedFiles""
                ALTER COLUMN
                    ""MimeType""
                SET NOT NULL");

            migrationBuilder.AlterColumn<string>(
                name: "MimeType",
                table: "UploadedFiles",
                nullable: false);

            migrationBuilder.DropColumn(
                name: "Checksum",
                table: "Media");

            migrationBuilder.DropColumn(
                name: "Height",
                table: "Media");

            migrationBuilder.DropColumn(
                name: "MimeType",
                table: "Media");

            migrationBuilder.DropColumn(
                name: "Width",
                table: "Media");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "Checksum",
                table: "UploadedFiles");

            migrationBuilder.DropColumn(
                name: "Height",
                table: "UploadedFiles");

            migrationBuilder.DropColumn(
                name: "Width",
                table: "UploadedFiles");

            migrationBuilder.RenameColumn(
                name: "MimeType",
                table: "UploadedFiles",
                newName: "OriginalChecksum");

            migrationBuilder.AddColumn<string>(
                name: "Checksum",
                table: "Media",
                type: "text",
                nullable: false,
                defaultValue: "");

            migrationBuilder.AddColumn<int>(
                name: "Height",
                table: "Media",
                type: "integer",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<string>(
                name: "MimeType",
                table: "Media",
                type: "text",
                nullable: false,
                defaultValue: "");

            migrationBuilder.AddColumn<int>(
                name: "Width",
                table: "Media",
                type: "integer",
                nullable: false,
                defaultValue: 0);
        }
    }
}