From ff9b1e112ed14746ed74dfff1fb4c19efd5502d4 Mon Sep 17 00:00:00 2001 From: Tim Date: Sat, 19 Apr 2025 12:16:15 +0200 Subject: Add user information settings --- .../20250419101300_AddUserInformationTable.cs | 40 ++++++++++++++++++++++ 1 file changed, 40 insertions(+) create mode 100644 VPNAuth.Server/Migrations/20250419101300_AddUserInformationTable.cs (limited to 'VPNAuth.Server/Migrations/20250419101300_AddUserInformationTable.cs') diff --git a/VPNAuth.Server/Migrations/20250419101300_AddUserInformationTable.cs b/VPNAuth.Server/Migrations/20250419101300_AddUserInformationTable.cs new file mode 100644 index 0000000..9d20a99 --- /dev/null +++ b/VPNAuth.Server/Migrations/20250419101300_AddUserInformationTable.cs @@ -0,0 +1,40 @@ +using Microsoft.EntityFrameworkCore.Migrations; + +#nullable disable + +namespace VPNAuth.Server.Migrations +{ + /// + public partial class AddUserInformationTable : Migration + { + /// + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "UserInformation", + columns: table => new + { + Id = table.Column(type: "INTEGER", nullable: false) + .Annotation("Sqlite:Autoincrement", true), + Sub = table.Column(type: "TEXT", nullable: true), + Name = table.Column(type: "TEXT", nullable: true), + GivenName = table.Column(type: "TEXT", nullable: true), + FamilyName = table.Column(type: "TEXT", nullable: true), + PreferredUsername = table.Column(type: "TEXT", nullable: true), + Email = table.Column(type: "TEXT", nullable: true), + Picture = table.Column(type: "TEXT", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_UserInformation", x => x.Id); + }); + } + + /// + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "UserInformation"); + } + } +} -- cgit v1.2.3