aboutsummaryrefslogtreecommitdiffstats
path: root/src/server/Migrations
diff options
context:
space:
mode:
Diffstat (limited to 'src/server/Migrations')
-rw-r--r--src/server/Migrations/20200729090558_Initial.Designer.cs143
-rw-r--r--src/server/Migrations/20200729090558_Initial.cs97
-rw-r--r--src/server/Migrations/MainDbContextModelSnapshot.cs141
3 files changed, 381 insertions, 0 deletions
diff --git a/src/server/Migrations/20200729090558_Initial.Designer.cs b/src/server/Migrations/20200729090558_Initial.Designer.cs
new file mode 100644
index 0000000..9657f66
--- /dev/null
+++ b/src/server/Migrations/20200729090558_Initial.Designer.cs
@@ -0,0 +1,143 @@
+// <auto-generated />
+using System;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Dough.Models.Database;
+
+namespace Dough.Migrations
+{
+ [DbContext(typeof(MainDbContext))]
+ [Migration("20200729090558_Initial")]
+ partial class Initial
+ {
+ protected override void BuildTargetModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("ProductVersion", "3.1.6");
+
+ modelBuilder.Entity("MoneyManager.Models.Database.Category", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Name")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Categories");
+ });
+
+ modelBuilder.Entity("MoneyManager.Models.Database.Payee", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Name")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Payees");
+ });
+
+ modelBuilder.Entity("MoneyManager.Models.Database.Transaction", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<double>("Amount")
+ .HasColumnType("REAL");
+
+ b.Property<Guid>("CategoryId")
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Date")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Note")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid>("PayeeId")
+ .HasColumnType("TEXT");
+
+ b.Property<string>("Tags")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Transactions");
+ });
+
+ modelBuilder.Entity("MoneyManager.Models.Database.User", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Password")
+ .HasColumnType("TEXT");
+
+ b.Property<string>("Username")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Users");
+
+ b.HasData(
+ new
+ {
+ Id = new Guid("193053d0-4292-4dc5-baae-59a920b64891"),
+ Created = new DateTime(2020, 7, 29, 9, 5, 57, 914, DateTimeKind.Utc).AddTicks(3427),
+ Hidden = false,
+ Password = "$2b$10$RFdcYLeqporq94pUIOoJGOPnhUbpV7R4e.2Iz8ot02N2PqeCpDCA6",
+ Username = "ivar"
+ });
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
diff --git a/src/server/Migrations/20200729090558_Initial.cs b/src/server/Migrations/20200729090558_Initial.cs
new file mode 100644
index 0000000..5dc0b40
--- /dev/null
+++ b/src/server/Migrations/20200729090558_Initial.cs
@@ -0,0 +1,97 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Dough.Migrations
+{
+ public partial class Initial : Migration
+ {
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.CreateTable(
+ name: "Categories",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(nullable: false),
+ Created = table.Column<DateTime>(nullable: false),
+ CreatedBy = table.Column<Guid>(nullable: true),
+ Hidden = table.Column<bool>(nullable: false),
+ Name = table.Column<string>(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Categories", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "Payees",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(nullable: false),
+ Created = table.Column<DateTime>(nullable: false),
+ CreatedBy = table.Column<Guid>(nullable: true),
+ Hidden = table.Column<bool>(nullable: false),
+ Name = table.Column<string>(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Payees", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "Transactions",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(nullable: false),
+ Created = table.Column<DateTime>(nullable: false),
+ CreatedBy = table.Column<Guid>(nullable: true),
+ Hidden = table.Column<bool>(nullable: false),
+ Tags = table.Column<string>(nullable: true),
+ Note = table.Column<string>(nullable: true),
+ Date = table.Column<DateTime>(nullable: false),
+ Amount = table.Column<double>(nullable: false),
+ PayeeId = table.Column<Guid>(nullable: false),
+ CategoryId = table.Column<Guid>(nullable: false)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Transactions", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "Users",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(nullable: false),
+ Created = table.Column<DateTime>(nullable: false),
+ CreatedBy = table.Column<Guid>(nullable: true),
+ Hidden = table.Column<bool>(nullable: false),
+ Password = table.Column<string>(nullable: true),
+ Username = table.Column<string>(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Users", x => x.Id);
+ });
+
+ migrationBuilder.InsertData(
+ table: "Users",
+ columns: new[] { "Id", "Created", "CreatedBy", "Hidden", "Password", "Username" },
+ values: new object[] { new Guid("193053d0-4292-4dc5-baae-59a920b64891"), new DateTime(2020, 7, 29, 9, 5, 57, 914, DateTimeKind.Utc).AddTicks(3427), null, false, "$2b$10$RFdcYLeqporq94pUIOoJGOPnhUbpV7R4e.2Iz8ot02N2PqeCpDCA6", "ivar" });
+ }
+
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropTable(
+ name: "Categories");
+
+ migrationBuilder.DropTable(
+ name: "Payees");
+
+ migrationBuilder.DropTable(
+ name: "Transactions");
+
+ migrationBuilder.DropTable(
+ name: "Users");
+ }
+ }
+}
diff --git a/src/server/Migrations/MainDbContextModelSnapshot.cs b/src/server/Migrations/MainDbContextModelSnapshot.cs
new file mode 100644
index 0000000..ad883c5
--- /dev/null
+++ b/src/server/Migrations/MainDbContextModelSnapshot.cs
@@ -0,0 +1,141 @@
+// <auto-generated />
+using System;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Dough.Models.Database;
+
+namespace Dough.Migrations
+{
+ [DbContext(typeof(MainDbContext))]
+ partial class MainDbContextModelSnapshot : ModelSnapshot
+ {
+ protected override void BuildModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("ProductVersion", "3.1.6");
+
+ modelBuilder.Entity("MoneyManager.Models.Database.Category", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Name")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Categories");
+ });
+
+ modelBuilder.Entity("MoneyManager.Models.Database.Payee", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Name")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Payees");
+ });
+
+ modelBuilder.Entity("MoneyManager.Models.Database.Transaction", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<double>("Amount")
+ .HasColumnType("REAL");
+
+ b.Property<Guid>("CategoryId")
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Date")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Note")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid>("PayeeId")
+ .HasColumnType("TEXT");
+
+ b.Property<string>("Tags")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Transactions");
+ });
+
+ modelBuilder.Entity("MoneyManager.Models.Database.User", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("TEXT");
+
+ b.Property<DateTime>("Created")
+ .HasColumnType("TEXT");
+
+ b.Property<Guid?>("CreatedBy")
+ .HasColumnType("TEXT");
+
+ b.Property<bool>("Hidden")
+ .HasColumnType("INTEGER");
+
+ b.Property<string>("Password")
+ .HasColumnType("TEXT");
+
+ b.Property<string>("Username")
+ .HasColumnType("TEXT");
+
+ b.HasKey("Id");
+
+ b.ToTable("Users");
+
+ b.HasData(
+ new
+ {
+ Id = new Guid("193053d0-4292-4dc5-baae-59a920b64891"),
+ Created = new DateTime(2020, 7, 29, 9, 5, 57, 914, DateTimeKind.Utc).AddTicks(3427),
+ Hidden = false,
+ Password = "$2b$10$RFdcYLeqporq94pUIOoJGOPnhUbpV7R4e.2Iz8ot02N2PqeCpDCA6",
+ Username = "ivar"
+ });
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
generated by cgit v1.3 (git 2.53.0) at 2026-03-07 10:15:39 +0100