From 3f4c0720e1e3421431e7baa20882a4a4512a7fab Mon Sep 17 00:00:00 2001 From: ivar Date: Sun, 19 Oct 2025 23:41:23 +0200 Subject: Initial --- src/Migrations/20200205233013_Intial.Designer.cs | 158 +++++++++++++++++++++ src/Migrations/20200205233013_Intial.cs | 93 ++++++++++++ .../20200207114805_SecondMigration.Designer.cs | 158 +++++++++++++++++++++ src/Migrations/20200207114805_SecondMigration.cs | 54 +++++++ src/Migrations/AppDbContextModelSnapshot.cs | 156 ++++++++++++++++++++ 5 files changed, 619 insertions(+) create mode 100644 src/Migrations/20200205233013_Intial.Designer.cs create mode 100644 src/Migrations/20200205233013_Intial.cs create mode 100644 src/Migrations/20200207114805_SecondMigration.Designer.cs create mode 100644 src/Migrations/20200207114805_SecondMigration.cs create mode 100644 src/Migrations/AppDbContextModelSnapshot.cs (limited to 'src/Migrations') diff --git a/src/Migrations/20200205233013_Intial.Designer.cs b/src/Migrations/20200205233013_Intial.Designer.cs new file mode 100644 index 0000000..7c3e3e8 --- /dev/null +++ b/src/Migrations/20200205233013_Intial.Designer.cs @@ -0,0 +1,158 @@ +// +using System; +using IOL.Fagprove.Data; +using Microsoft.EntityFrameworkCore; +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; +using Microsoft.EntityFrameworkCore.Storage.ValueConversion; + +namespace IOL.Fagprove.Migrations +{ + [DbContext(typeof(AppDbContext))] + [Migration("20200205233013_Intial")] + partial class Intial + { + protected override void BuildTargetModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "3.1.1") + .HasAnnotation("Relational:MaxIdentifierLength", 64); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.ReservationObjects", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("Capacity") + .HasColumnType("int"); + + b.Property("CategoryId") + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Description") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Price") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.HasKey("Id"); + + b.ToTable("Cabins"); + }); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.Reservations", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Extra") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("From") + .HasColumnType("datetime(6)"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("ReservationObjectId") + .HasColumnType("char(36)"); + + b.Property("Status") + .HasColumnType("int"); + + b.Property("To") + .HasColumnType("datetime(6)"); + + b.Property("UserId") + .HasColumnType("char(36)"); + + b.HasKey("Id"); + + b.ToTable("Reservations"); + }); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.Users", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Email") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Password") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Role") + .HasColumnType("int"); + + b.HasKey("Id"); + + b.ToTable("Users"); + + b.HasData( + new + { + Id = new Guid("d2512ef5-f25e-486d-a94d-1ea43c732195"), + CreatedUtc = new DateTime(2020, 2, 5, 23, 30, 13, 316, DateTimeKind.Utc).AddTicks(6060), + Email = "ivar@protektit.no", + Name = "Ivar Løvlie Administrator", + Password = "9F267A5EC952ABC97CC5B768AEF42337", + Role = 1 + }, + new + { + Id = new Guid("e166655c-cbdc-4128-8e0e-9aeb9c52093d"), + CreatedUtc = new DateTime(2020, 2, 5, 23, 30, 13, 320, DateTimeKind.Utc).AddTicks(310), + Email = "ivarino@protektit.no", + Name = "Ivar Løvlie Standard", + Password = "9F267A5EC952ABC97CC5B768AEF42337", + Role = 0 + }); + }); +#pragma warning restore 612, 618 + } + } +} diff --git a/src/Migrations/20200205233013_Intial.cs b/src/Migrations/20200205233013_Intial.cs new file mode 100644 index 0000000..df385f3 --- /dev/null +++ b/src/Migrations/20200205233013_Intial.cs @@ -0,0 +1,93 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; + +namespace IOL.Fagprove.Migrations +{ + public partial class Intial : Migration + { + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "Cabins", + columns: table => new + { + Id = table.Column(nullable: false), + CreatedUtc = table.Column(nullable: true), + CreatedBy = table.Column(nullable: true), + ModifiedUtc = table.Column(nullable: true), + ModifiedBy = table.Column(nullable: true), + CategoryId = table.Column(nullable: false), + Name = table.Column(nullable: true), + Capacity = table.Column(nullable: true), + Price = table.Column(nullable: true), + Description = table.Column(nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_Cabins", x => x.Id); + }); + + migrationBuilder.CreateTable( + name: "Reservations", + columns: table => new + { + Id = table.Column(nullable: false), + CreatedUtc = table.Column(nullable: true), + CreatedBy = table.Column(nullable: true), + ModifiedUtc = table.Column(nullable: true), + ModifiedBy = table.Column(nullable: true), + UserId = table.Column(nullable: false), + ReservationObjectId = table.Column(nullable: false), + From = table.Column(nullable: false), + To = table.Column(nullable: false), + Status = table.Column(nullable: false), + Extra = table.Column(nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_Reservations", x => x.Id); + }); + + migrationBuilder.CreateTable( + name: "Users", + columns: table => new + { + Id = table.Column(nullable: false), + CreatedUtc = table.Column(nullable: true), + CreatedBy = table.Column(nullable: true), + ModifiedUtc = table.Column(nullable: true), + ModifiedBy = table.Column(nullable: true), + Name = table.Column(nullable: true), + Email = table.Column(nullable: true), + Password = table.Column(nullable: true), + Role = table.Column(nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_Users", x => x.Id); + }); + + migrationBuilder.InsertData( + table: "Users", + columns: new[] { "Id", "CreatedBy", "CreatedUtc", "Email", "ModifiedBy", "ModifiedUtc", "Name", "Password", "Role" }, + values: new object[] { new Guid("d2512ef5-f25e-486d-a94d-1ea43c732195"), null, new DateTime(2020, 2, 5, 23, 30, 13, 316, DateTimeKind.Utc).AddTicks(6060), "ivar@protektit.no", null, null, "Ivar Løvlie Administrator", "9F267A5EC952ABC97CC5B768AEF42337", 1 }); + + migrationBuilder.InsertData( + table: "Users", + columns: new[] { "Id", "CreatedBy", "CreatedUtc", "Email", "ModifiedBy", "ModifiedUtc", "Name", "Password", "Role" }, + values: new object[] { new Guid("e166655c-cbdc-4128-8e0e-9aeb9c52093d"), null, new DateTime(2020, 2, 5, 23, 30, 13, 320, DateTimeKind.Utc).AddTicks(310), "ivarino@protektit.no", null, null, "Ivar Løvlie Standard", "9F267A5EC952ABC97CC5B768AEF42337", 0 }); + } + + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "Cabins"); + + migrationBuilder.DropTable( + name: "Reservations"); + + migrationBuilder.DropTable( + name: "Users"); + } + } +} diff --git a/src/Migrations/20200207114805_SecondMigration.Designer.cs b/src/Migrations/20200207114805_SecondMigration.Designer.cs new file mode 100644 index 0000000..5915ae0 --- /dev/null +++ b/src/Migrations/20200207114805_SecondMigration.Designer.cs @@ -0,0 +1,158 @@ +// +using System; +using IOL.Fagprove.Data; +using Microsoft.EntityFrameworkCore; +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; +using Microsoft.EntityFrameworkCore.Storage.ValueConversion; + +namespace IOL.Fagprove.Migrations +{ + [DbContext(typeof(AppDbContext))] + [Migration("20200207114805_SecondMigration")] + partial class SecondMigration + { + protected override void BuildTargetModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "3.1.1") + .HasAnnotation("Relational:MaxIdentifierLength", 64); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.ReservationObjects", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("Capacity") + .HasColumnType("int"); + + b.Property("CategoryId") + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Description") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Price") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.HasKey("Id"); + + b.ToTable("Cabins"); + }); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.Reservations", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Extra") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("From") + .HasColumnType("datetime(6)"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("ReservationObjectId") + .HasColumnType("char(36)"); + + b.Property("Status") + .HasColumnType("int"); + + b.Property("To") + .HasColumnType("datetime(6)"); + + b.Property("UserId") + .HasColumnType("char(36)"); + + b.HasKey("Id"); + + b.ToTable("Reservations"); + }); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.Users", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Email") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Password") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Role") + .HasColumnType("int"); + + b.HasKey("Id"); + + b.ToTable("Users"); + + b.HasData( + new + { + Id = new Guid("d2c3dc54-2fda-413a-abff-f632f88afe34"), + CreatedUtc = new DateTime(2020, 2, 7, 11, 48, 5, 107, DateTimeKind.Utc).AddTicks(9470), + Email = "ivar@protektit.no", + Name = "Ivar Løvlie Administrator", + Password = "9F267A5EC952ABC97CC5B768AEF42337", + Role = 1 + }, + new + { + Id = new Guid("fd0f2341-00fa-4906-8a1a-ba110df9f9a4"), + CreatedUtc = new DateTime(2020, 2, 7, 11, 48, 5, 114, DateTimeKind.Utc).AddTicks(1410), + Email = "ivarino@protektit.no", + Name = "Ivar Løvlie Standard", + Password = "9F267A5EC952ABC97CC5B768AEF42337", + Role = 0 + }); + }); +#pragma warning restore 612, 618 + } + } +} diff --git a/src/Migrations/20200207114805_SecondMigration.cs b/src/Migrations/20200207114805_SecondMigration.cs new file mode 100644 index 0000000..0419b07 --- /dev/null +++ b/src/Migrations/20200207114805_SecondMigration.cs @@ -0,0 +1,54 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; + +namespace IOL.Fagprove.Migrations +{ + public partial class SecondMigration : Migration + { + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.DeleteData( + table: "Users", + keyColumn: "Id", + keyValue: new Guid("d2512ef5-f25e-486d-a94d-1ea43c732195")); + + migrationBuilder.DeleteData( + table: "Users", + keyColumn: "Id", + keyValue: new Guid("e166655c-cbdc-4128-8e0e-9aeb9c52093d")); + + migrationBuilder.InsertData( + table: "Users", + columns: new[] { "Id", "CreatedBy", "CreatedUtc", "Email", "ModifiedBy", "ModifiedUtc", "Name", "Password", "Role" }, + values: new object[] { new Guid("d2c3dc54-2fda-413a-abff-f632f88afe34"), null, new DateTime(2020, 2, 7, 11, 48, 5, 107, DateTimeKind.Utc).AddTicks(9470), "ivar@protektit.no", null, null, "Ivar Løvlie Administrator", "9F267A5EC952ABC97CC5B768AEF42337", 1 }); + + migrationBuilder.InsertData( + table: "Users", + columns: new[] { "Id", "CreatedBy", "CreatedUtc", "Email", "ModifiedBy", "ModifiedUtc", "Name", "Password", "Role" }, + values: new object[] { new Guid("fd0f2341-00fa-4906-8a1a-ba110df9f9a4"), null, new DateTime(2020, 2, 7, 11, 48, 5, 114, DateTimeKind.Utc).AddTicks(1410), "ivarino@protektit.no", null, null, "Ivar Løvlie Standard", "9F267A5EC952ABC97CC5B768AEF42337", 0 }); + } + + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DeleteData( + table: "Users", + keyColumn: "Id", + keyValue: new Guid("d2c3dc54-2fda-413a-abff-f632f88afe34")); + + migrationBuilder.DeleteData( + table: "Users", + keyColumn: "Id", + keyValue: new Guid("fd0f2341-00fa-4906-8a1a-ba110df9f9a4")); + + migrationBuilder.InsertData( + table: "Users", + columns: new[] { "Id", "CreatedBy", "CreatedUtc", "Email", "ModifiedBy", "ModifiedUtc", "Name", "Password", "Role" }, + values: new object[] { new Guid("d2512ef5-f25e-486d-a94d-1ea43c732195"), null, new DateTime(2020, 2, 5, 23, 30, 13, 316, DateTimeKind.Utc).AddTicks(6060), "ivar@protektit.no", null, null, "Ivar Løvlie Administrator", "9F267A5EC952ABC97CC5B768AEF42337", 1 }); + + migrationBuilder.InsertData( + table: "Users", + columns: new[] { "Id", "CreatedBy", "CreatedUtc", "Email", "ModifiedBy", "ModifiedUtc", "Name", "Password", "Role" }, + values: new object[] { new Guid("e166655c-cbdc-4128-8e0e-9aeb9c52093d"), null, new DateTime(2020, 2, 5, 23, 30, 13, 320, DateTimeKind.Utc).AddTicks(310), "ivarino@protektit.no", null, null, "Ivar Løvlie Standard", "9F267A5EC952ABC97CC5B768AEF42337", 0 }); + } + } +} diff --git a/src/Migrations/AppDbContextModelSnapshot.cs b/src/Migrations/AppDbContextModelSnapshot.cs new file mode 100644 index 0000000..cb52104 --- /dev/null +++ b/src/Migrations/AppDbContextModelSnapshot.cs @@ -0,0 +1,156 @@ +// +using System; +using IOL.Fagprove.Data; +using Microsoft.EntityFrameworkCore; +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Storage.ValueConversion; + +namespace IOL.Fagprove.Migrations +{ + [DbContext(typeof(AppDbContext))] + partial class AppDbContextModelSnapshot : ModelSnapshot + { + protected override void BuildModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "3.1.1") + .HasAnnotation("Relational:MaxIdentifierLength", 64); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.ReservationObjects", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("Capacity") + .HasColumnType("int"); + + b.Property("CategoryId") + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Description") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Price") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.HasKey("Id"); + + b.ToTable("Cabins"); + }); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.Reservations", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Extra") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("From") + .HasColumnType("datetime(6)"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("ReservationObjectId") + .HasColumnType("char(36)"); + + b.Property("Status") + .HasColumnType("int"); + + b.Property("To") + .HasColumnType("datetime(6)"); + + b.Property("UserId") + .HasColumnType("char(36)"); + + b.HasKey("Id"); + + b.ToTable("Reservations"); + }); + + modelBuilder.Entity("IOL.Fagprove.Data.Models.Users", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnType("char(36)"); + + b.Property("CreatedBy") + .HasColumnType("char(36)"); + + b.Property("CreatedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Email") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("ModifiedBy") + .HasColumnType("char(36)"); + + b.Property("ModifiedUtc") + .HasColumnType("datetime(6)"); + + b.Property("Name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Password") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Role") + .HasColumnType("int"); + + b.HasKey("Id"); + + b.ToTable("Users"); + + b.HasData( + new + { + Id = new Guid("d2c3dc54-2fda-413a-abff-f632f88afe34"), + CreatedUtc = new DateTime(2020, 2, 7, 11, 48, 5, 107, DateTimeKind.Utc).AddTicks(9470), + Email = "ivar@protektit.no", + Name = "Ivar Løvlie Administrator", + Password = "9F267A5EC952ABC97CC5B768AEF42337", + Role = 1 + }, + new + { + Id = new Guid("fd0f2341-00fa-4906-8a1a-ba110df9f9a4"), + CreatedUtc = new DateTime(2020, 2, 7, 11, 48, 5, 114, DateTimeKind.Utc).AddTicks(1410), + Email = "ivarino@protektit.no", + Name = "Ivar Løvlie Standard", + Password = "9F267A5EC952ABC97CC5B768AEF42337", + Role = 0 + }); + }); +#pragma warning restore 612, 618 + } + } +} -- cgit v1.3