181 lines
7.5 KiB
C#
181 lines
7.5 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
#pragma warning disable CA1814 // Prefer jagged arrays over multidimensional
|
|
|
|
namespace ExpenseTracker.Api.Migrations
|
|
{
|
|
/// <inheritdoc />
|
|
public partial class UpdateCategories : Migration
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000001"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#f97316", "Ameublement et appareil" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000002"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#6b7280", "Banque et assurance" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000003"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#22c55e", "Credit" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000004"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#eab308", "Energie" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000005"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#ef4444", "Frais bancaires" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000006"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#ec4899", "Hygiene" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000007"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#dc2626", "Impots et taxes" });
|
|
|
|
migrationBuilder.InsertData(
|
|
table: "categories",
|
|
columns: new[] { "id", "color", "name" },
|
|
values: new object[,]
|
|
{
|
|
{ new Guid("10000000-0000-0000-0000-000000000008"), "#3b82f6", "Internet et telephonie" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000009"), "#8b5cf6", "Juridique et administratif" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000010"), "#64748b", "Prelevement" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000011"), "#16a34a", "Salaires" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000012"), "#a855f7", "Shopping et services" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000013"), "#0ea5e9", "Sport, Gym et Equipement" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000014"), "#94a3b8", "Transaction differee" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000015"), "#f59e0b", "Virement emis" },
|
|
{ new Guid("10000000-0000-0000-0000-000000000016"), "#10b981", "Virement recu" }
|
|
});
|
|
}
|
|
|
|
/// <inheritdoc />
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000008"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000009"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000010"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000011"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000012"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000013"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000014"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000015"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000016"));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000001"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#ef4444", "Alimentation" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000002"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#f97316", "Transport" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000003"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#eab308", "Logement" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000004"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#22c55e", "Santé" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000005"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#3b82f6", "Loisirs" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000006"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#a855f7", "Abonnements" });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "categories",
|
|
keyColumn: "id",
|
|
keyValue: new Guid("10000000-0000-0000-0000-000000000007"),
|
|
columns: new[] { "color", "name" },
|
|
values: new object[] { "#6b7280", "Autre" });
|
|
}
|
|
}
|
|
}
|