Privacy-first password manager with built-in email aliasing. Fully encrypted and self-hostable.
using System;
using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace AliasServerDb.Migrations
{
/// <summary>
/// Adds the tables the server needs to drive a client: an invitation to a shared manifest, the actions a client
/// picks up on its next status call, and the rules that resolve which capabilities a caller is entitled to use.
/// </summary>
public partial class AddGroupInvitationsClientActionsAndCapabilityRules : Migration
{
/// <inheritdoc />
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateTable(
name: "ClientActions",
columns: table => new
{
Id = table.Column<Guid>(type: "uuid", nullable: false),
Type = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false),
TargetUserId = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true),
TargetGroupId = table.Column<Guid>(type: "uuid", nullable: true),
ManifestId = table.Column<Guid>(type: "uuid", nullable: true),
Payload = table.Column<string>(type: "jsonb", nullable: true),
CreatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
UpdatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_ClientActions", x => x.Id);
table.ForeignKey(
name: "FK_ClientActions_AliasVaultUsers_TargetUserId",
column: x => x.TargetUserId,
principalTable: "AliasVaultUsers",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
table.ForeignKey(
name: "FK_ClientActions_Groups_TargetGroupId",
column: x => x.TargetGroupId,
principalTable: "Groups",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
});
migrationBuilder.CreateTable(
name: "GroupInvitations",
columns: table => new
{
Id = table.Column<Guid>(type: "uuid", nullable: false),
GroupId = table.Column<Guid>(type: "uuid", nullable: false),
InviterUserId = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false),
InviteeUserId = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false),
Role = table.Column<string>(type: "character varying(20)", maxLength: 20, nullable: false),
VaultManifestId = table.Column<Guid>(type: "uuid", nullable: true),
EncryptedName = table.Column<string>(type: "text", nullable: true),
EncryptedNameSignature = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true),
EncryptedVek = table.Column<string>(type: "text", nullable: true),
VaultKeyVersion = table.Column<int>(type: "integer", nullable: false, defaultValue: 0),
UserGrantKeyId = table.Column<Guid>(type: "uuid", nullable: true),
GrantSignature = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true),
GrantSignerPublicKey = table.Column<string>(type: "character varying(100)", maxLength: 100, nullable: true),
Algorithm = table.Column<string>(type: "character varying(30)", maxLength: 30, nullable: false),
State = table.Column<string>(type: "character varying(20)", maxLength: 20, nullable: false),
CreatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
UpdatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
RespondedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_GroupInvitations", x => x.Id);
table.ForeignKey(
name: "FK_GroupInvitations_AliasVaultUsers_InviteeUserId",
column: x => x.InviteeUserId,
principalTable: "AliasVaultUsers",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
table.ForeignKey(
name: "FK_GroupInvitations_AliasVaultUsers_InviterUserId",
column: x => x.InviterUserId,
principalTable: "AliasVaultUsers",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
table.ForeignKey(
name: "FK_GroupInvitations_Groups_GroupId",
column: x => x.GroupId,
principalTable: "Groups",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
table.ForeignKey(
name: "FK_GroupInvitations_UserGrantKeys_UserGrantKeyId",
column: x => x.UserGrantKeyId,
principalTable: "UserGrantKeys",
principalColumn: "Id",
onDelete: ReferentialAction.SetNull);
});
migrationBuilder.CreateTable(
name: "CapabilityRules",
columns: table => new
{
Id = table.Column<Guid>(type: "uuid", nullable: false),
CapabilityKey = table.Column<string>(type: "character varying(100)", maxLength: 100, nullable: false),
Kind = table.Column<string>(type: "character varying(20)", maxLength: 20, nullable: false),
UserId = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true),
GroupId = table.Column<Guid>(type: "uuid", nullable: true),
Tier = table.Column<string>(type: "character varying(20)", maxLength: 20, nullable: true),
Value = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false),
ClientName = table.Column<string>(type: "character varying(100)", maxLength: 100, nullable: true),
Enabled = table.Column<bool>(type: "boolean", nullable: false),
EffectiveFrom = table.Column<DateTime>(type: "timestamp with time zone", nullable: true),
EffectiveUntil = table.Column<DateTime>(type: "timestamp with time zone", nullable: true),
Notes = table.Column<string>(type: "character varying(1000)", maxLength: 1000, nullable: true),
CreatedBy = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true),
CreatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
UpdatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_CapabilityRules", x => x.Id);
table.ForeignKey(
name: "FK_CapabilityRules_AliasVaultUsers_UserId",
column: x => x.UserId,
principalTable: "AliasVaultUsers",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
table.ForeignKey(
name: "FK_CapabilityRules_Groups_GroupId",
column: x => x.GroupId,
principalTable: "Groups",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
});
migrationBuilder.CreateIndex(
name: "IX_ClientActions_TargetGroupId",
table: "ClientActions",
column: "TargetGroupId");
migrationBuilder.CreateIndex(
name: "IX_ClientActions_TargetUserId",
table: "ClientActions",
column: "TargetUserId");
migrationBuilder.CreateIndex(
name: "IX_GroupInvitations_GroupId",
table: "GroupInvitations",
column: "GroupId");
migrationBuilder.CreateIndex(
name: "IX_GroupInvitations_InviteeUserId_State",
table: "GroupInvitations",
columns: new[] { "InviteeUserId", "State" });
migrationBuilder.CreateIndex(
name: "IX_GroupInvitations_InviterUserId",
table: "GroupInvitations",
column: "InviterUserId");
migrationBuilder.CreateIndex(
name: "IX_GroupInvitations_UserGrantKeyId",
table: "GroupInvitations",
column: "UserGrantKeyId");
// A user can hold at most one pending invitation per shared manifest, not per group: a group can own
// several manifests and each of them is invited to separately.
migrationBuilder.CreateIndex(
name: "UX_GroupInvitations_Manifest_Invitee_Pending",
table: "GroupInvitations",
columns: new[] { "VaultManifestId", "InviteeUserId" },
unique: true,
filter: "\"State\" = 'Pending'");
migrationBuilder.CreateIndex(
name: "IX_CapabilityRules_CapabilityKey_Enabled",
table: "CapabilityRules",
columns: new[] { "CapabilityKey", "Enabled" });
migrationBuilder.CreateIndex(
name: "IX_CapabilityRules_GroupId",
table: "CapabilityRules",
column: "GroupId");
migrationBuilder.CreateIndex(
name: "IX_CapabilityRules_Tier",
table: "CapabilityRules",
column: "Tier");
migrationBuilder.CreateIndex(
name: "IX_CapabilityRules_UserId",
table: "CapabilityRules",
column: "UserId");
migrationBuilder.CreateTable(
name: "VaultManifestShareDetails",
columns: table => new
{
ManifestId = table.Column<Guid>(type: "uuid", nullable: false),
EncryptedName = table.Column<string>(type: "character varying(2000)", maxLength: 2000, nullable: true),
CreatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
UpdatedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_VaultManifestShareDetails", x => x.ManifestId);
table.ForeignKey(
name: "FK_VaultManifestShareDetails_VaultManifests_ManifestId",
column: x => x.ManifestId,
principalTable: "VaultManifests",
principalColumn: "ManifestId",
onDelete: ReferentialAction.Cascade);
});
}
/// <inheritdoc />
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropTable(
name: "VaultManifestShareDetails");
migrationBuilder.DropTable(
name: "CapabilityRules");
migrationBuilder.DropTable(
name: "ClientActions");
migrationBuilder.DropTable(
name: "GroupInvitations");
}
}
}