Exemple #1
0
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "WeightTransactions");

            migrationBuilder.AlterColumn <DateTimeOffset>(
                name: "TransactionDate",
                schema: "medical",
                table: "MedicalTransactions",
                type: "TEXT",
                nullable: false,
                oldClrType: typeof(long),
                oldType: "INTEGER");

            migrationBuilder.AlterColumn <DateTimeOffset>(
                name: "TransactionDate",
                schema: "feed",
                table: "FeedingTransactions",
                type: "TEXT",
                nullable: false,
                oldClrType: typeof(long),
                oldType: "INTEGER");

            migrationBuilder.AlterColumn <DateTimeOffset>(
                name: "SellDate",
                schema: "animal",
                table: "Animals",
                type: "TEXT",
                nullable: true,
                oldClrType: typeof(long),
                oldType: "INTEGER",
                oldNullable: true);

            migrationBuilder.AlterColumn <DateTimeOffset>(
                name: "PurchaseDate",
                schema: "animal",
                table: "Animals",
                type: "TEXT",
                nullable: false,
                oldClrType: typeof(long),
                oldType: "INTEGER");

            migrationBuilder.AlterColumn <DateTimeOffset>(
                name: "DateOfDeath",
                schema: "animal",
                table: "Animals",
                type: "TEXT",
                nullable: true,
                oldClrType: typeof(long),
                oldType: "INTEGER",
                oldNullable: true);

            migrationBuilder.AlterColumn <DateTimeOffset>(
                name: "BirthDate",
                schema: "animal",
                table: "Animals",
                type: "TEXT",
                nullable: false,
                oldClrType: typeof(long),
                oldType: "INTEGER");

            migrationBuilder.AlterColumnDataTypeLongToDateTimeOffset(
                propertyNames: new string[] { "BirthDate", "SellDate", "PurchaseDate", "DateOfDeath" },
                tableName: "Animals");

            migrationBuilder.AlterColumnDataTypeLongToDateTimeOffset(
                propertyNames: new string[] { "TransactionDate" },
                tableName: "MedicalTransactions");

            migrationBuilder.AlterColumnDataTypeLongToDateTimeOffset(
                propertyNames: new string[] { "TransactionDate" },
                tableName: "FeedingTransactions");
        }