jlf0dev/legacy-user-setup.txt

## legacy-user-setup.txt
-- Clear any leftover data
DELETE FROM [dbo].[OrganizationUser] WHERE [UserId] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5', '13D8D3AB-F806-4AEB-A677-B07700307F85');
DELETE FROM [dbo].[Policy] WHERE [OrganizationId] = '6C68B657-58F1-4579-961E-B077003BDCB0';
DELETE FROM [dbo].[OrganizationApiKey] WHERE [OrganizationId] = '6C68B657-58F1-4579-961E-B077003BDCB0';
DELETE FROM [dbo].[Organization] WHERE [Id] = '6C68B657-58F1-4579-961E-B077003BDCB0';
DELETE FROM [dbo].[Device] WHERE [UserId] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5', '13D8D3AB-F806-4AEB-A677-B07700307F85');
DELETE FROM [dbo].[Cipher] WHERE [UserId] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5');
DELETE FROM [dbo].[EmergencyAccess] WHERE [GrantorId] = 'c6bf38fb-82b4-4d7a-a9ba-b06f012822b5';
DELETE FROM [dbo].[User] WHERE [Id] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5', '13D8D3AB-F806-4AEB-A677-B07700307F85');


-- Create a legacy user
INSERT INTO vault_dev.dbo.[User]
(Id, Name, Email, EmailVerified, MasterPassword, MasterPasswordHint, Culture, SecurityStamp, TwoFactorProviders, TwoFactorRecoveryCode, EquivalentDomains, ExcludedGlobalEquivalentDomains, AccountRevisionDate, [Key], PublicKey, PrivateKey, Premium, PremiumExpirationDate, Storage, MaxStorageGb, Gateway, GatewayCustomerId, GatewaySubscriptionId, LicenseKey, CreationDate, RevisionDate, RenewalReminderDate, Kdf, KdfIterations, ReferenceData, ApiKey, ForcePasswordReset, UsesKeyConnector, FailedLoginCount, LastFailedLoginDate, UnknownDeviceVerificationEnabled, AvatarColor, KdfMemory, KdfParallelism, LastPasswordChangeDate, LastKdfChangeDate, LastKeyRotationDate, LastEmailChangeDate)
VALUES(N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', N'Legacy User', N'jbaur+legacy-test@bitwarden.com', 0, N'AQAAAAEAACcQAAAAEOGcgDo2KBDxbn1dOUtAxBDfl9lu6g7xk0OfC+0DjAJ05krIG9RHpDy2cJoWCfpL7g==', NULL, N'en-US', N'7dac2841-0df0-4914-aebf-b0587e1272b2', NULL, NULL, NULL, NULL, '2023-08-31 18:20:03.963', NULL, N'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvxiKDs7QfYTyMez3+3mT1+Qp+Q1+OtqdF8BckqpDHzpBvvKCLj/xEXa7Yn2jKFvpexaVQy9Q9Og9tHLYTdIhIeAdFfEC8FDjH0jaVC3US4D1CVAV5Fa+fnJwmYxCIi3P9Nphrzju83X/Mg1XpoZQl/ZnSZdwpwNVcdnz6sFlcuq/1h1zGJGATHaqsbe1gHKsEqPM0PaZcq5EscuRg+/0/S4fVQGusltS5cbWxmwHBJX7c/frUbF4jXcu5gUQgYGgMABNhBHNSrD4qAWRwoK61Dvl9tZtXDQWG7pDJWgpUtt5OLrmMP+aqw+Zh3EV1C2WyBsvrrwnxh7Xv4L+T+0wGwIDAQAB', N'826sJeAaV/dTv3KYEuDlsA==|6gblZK8vuaK4FWdjcO5zdGkOXGUm4h7gpZx/2gBdhohlmtxdtOS27BQhrfjl71lOOIthXwAb9RE/fcDxbGRYwkceh65MIh/YpOU0jQLog9NfS4YQUvLp3/NbT7EotWWQOufmF8jZabX+w4HZW0dJOnjJJ8YtwLdPtQZOpnS9d+jn8oQg/sCu5l/CW42T+Cn6OwNot7g9L6kROgE4O8VAqf98UMizRUVEjmHeKkxu28qnqxYYCTDjesbbyBq5itrfe+30aUznhAqchw0ToNyTtukO38CbHkhWQd/RZqIk1S9oxHJqo2R7DlV14+f1C9ehPVgLiHp/kNjaQH4qy3Dtyma6TijctgSiByGp9jLzdXSgQdBRYwSjuVIyYYXO4lJ4jzO8Rv42/qm9OjcAgB/OPGjpSQ6WLrS9EGxKP9b8vWPHSVnNKU4p8niFKUl5UOffyxI8m0CNRRaFQSxUh4KyDzeZSNpz0Yg4Thv1nWZaMIFhmgLW0d5d0oOLQczD2ph+sw/wyHeTgNsgH/woMcMGFFDfzMaNgENVA574d1ZIYP0FO6/bW7pYE1JT628PWgyFPHNjo6OtosVgACEuZkbSGLF8Nyzz9yjqHMyyi/s0F68amT68Q15n35k86nJWt1704sQbEjtgE9bycwwotmUa/lPANhJxnYX6nSxLPqTIpNToXCvoNPB45ZrLUfpOIYJeOH2EuvmYLPPq2YSSdFYKV/i/bcalQ4qx37xB5MT5rvSsKhtGgF9TUWpWXIQ1pHVaKTXSwUHvZLnLFv6f0d3J0iJw26trSDCKP2v08zWc8puXvhHL6j50XFmg+4hPFboEX9qLmlUfps7mukHbAixggyJj6CFXH7jKAhTK8GxWskO4YxgbsJdMnt4PU0xiR3R6uKxDizPK6gSunIObGQs0MMXH6zJz6PEZlMmmgFJ64nyN9BBsO5bW8zcjbH6YPjz+Mn6On69GqfV+HI/9uSD4dTxs/sIaB0pueFy6B7g/nLWjsaOPHeIPNdFEodiX5+poMvzRBMtJisU7iummPR/RRg75zrbgOE+L8fLaWD/lNwWpTZ5AmUO5TxsYIJGnrIhvSYQlg+UBK8UuLpbWOkUC01LLXr6qogAPWf2LPpCPu33ESsnP2+Xr+DVM52c2mm6T6eushMacUwJHcCRLpL/U1hCzLOTyawlhneh+2V/hDxrMgv4R9tV/c6LozCTM1ghRQsSaO4HnDFSnEXDEGGLODlIiQsedphhgv813NiYE+ru1/AA+SqU+CMQ1Ct1pJPR/7EU/GlovVUAitFo4it51e5bQLkIMCMTCdfFDQLTKYsEraFVW8xsOPXzqGXhq+oDYt8X1ipyIonI9pV6fzOgrOXNvphPZRahjP/MBfAwnmN2hGIm4rucoRJhEpXFgqHxMYTZ5BpId+qikdaV0n4e9TndAi3tNtLWzAVEGe+DfX8tRK7apN/4QEE36oLRfgE1gWr/U2RHYDv2JIL4rg9B8i+gSu5uZ2ITA/i5mCm0fmRQUSmcEpd/+sKQf8CMHSiJGHUBU4VZ1sFkX57v0oENY73P2mU2C3p3LaHxTyc5Q9iKxsOGOnnkiWjiSRQzABCsy3zr7D16M/Sco1x408jv6ClcvDdgtdTl9I6XjrYigRw0=', 1, '2029-09-08 02:45:21.083', NULL, NULL, NULL, NULL, NULL, NULL, '2023-08-31 17:58:11.630', '2023-09-08 02:45:21.083', NULL, 0, 5000, NULL, N'TEST_API_KEY', 0, 0, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


-- A normal user for testing key migration with emergency access
INSERT INTO vault_dev.dbo.[User]
(Id, Name, Email, EmailVerified, MasterPassword, MasterPasswordHint, Culture, SecurityStamp, TwoFactorProviders, TwoFactorRecoveryCode, EquivalentDomains, ExcludedGlobalEquivalentDomains, AccountRevisionDate, [Key], PublicKey, PrivateKey, Premium, PremiumExpirationDate, Storage, MaxStorageGb, Gateway, GatewayCustomerId, GatewaySubscriptionId, LicenseKey, CreationDate, RevisionDate, RenewalReminderDate, Kdf, KdfIterations, ReferenceData, ApiKey, ForcePasswordReset, UsesKeyConnector, FailedLoginCount, LastFailedLoginDate, UnknownDeviceVerificationEnabled, AvatarColor, KdfMemory, KdfParallelism, LastPasswordChangeDate, LastKdfChangeDate, LastKeyRotationDate, LastEmailChangeDate)
VALUES(N'13D8D3AB-F806-4AEB-A677-B07700307F85', NULL, N'jfink+emergency-access-legacy@bitwarden.com', 1, N'AQAAAAEAAYagAAAAEKgB6ZIqSuLFVzlI434bzdcCDRxsdgWkuUrzkzUvBWkh3jW2FXk6Y2vg11oq92cMgw==', NULL, N'en-US', N'3LHYFFR6TBMOFCAHCIYQAPKZIBYW4QUL', NULL, NULL, NULL, NULL, '2023-09-08 02:56:34.493', N'2.2Fq1UCMHwCNggC3CG/GTkw==|NM3bFWIUex1RkHrFFekjsQc8ZXCx3a/xkCWYSVvXd7I7DanwfMkQjDl45t1Phu29WCHmx7s2AxSXg9so2o493S3JDrwYavr2IHSl3gyXA+g=|QWyJ7h/3r2EUXcmKh1pvXW/beWbw8WDRiVKulTh4NwE=', N'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxwMBxxGxVh1QXj+ashGQHQJ2W0jfshPtSaiNB5XPcRr44DfdcXoGNLwqAdSuUBBYX4kKgbSJpU2jVawz1rPwbgqspLUpDckDsrd0FqNRU3rAPPulxkRU0Wt4B7baBIhkuh0aaOvmypbcRUutx7ig1ENAgzlJYgAESr2h1ptXLObu6SLfVyUPwgIYDgcm2N61x42q5f0QliBHCDF2RiGSVk2pr5eAFdm4KACSpz1aCoXM3OdbM/8XA4dByYd0aMYzhSuCYjkpfUCShTs2F1YtpPy9+o1xBUo1UxlcEM1cnabmkU8W57dy1Dyghis7Ya7UTRXNAAltXKq+xjJS1sRMLwIDAQAB', N'2.ygOCuZ+ov4dTc8MshxmP3Q==|ZwoYvEa2TRnfDxauO9g98P2oxugqfjUCz3BrGJ9wkcsm87MX6JiuU6BtmxkiP1iXvxRnwMmnxyIzbWYCFpnUoBy7TicUvaiPJL6GvvJVmpXlDrx5ZvTnNpQ2XrAioORaYx6jvmBiVBMixSmE240xVqjusB6tKxEyIPt0bn+62BbTMZuvke61YoI+0kx0JwSJqt7hMcroHU7kd/tknLU38gdaxd/QUNZK/S9FY33D28vgHcOQ+RPvwD9W3z7nPbidUo/RNUEEIPMrZJmBMwfkQue62RI1xOmpHo1NCuEzNtAbPImcfaQNQb9UkMbTrcBEGryvlzpSX/MmqkQhqiRhOEdkqkqBIDIZ0BgTd4mt+0KzWwDpLPr7KFI6Pc3mSEDDb0P+wmeIhKJUgcJFbf888nq8l3XLyYvHIRwlqA67wHzOjl5rER0gkkOeExOvQ5zoEm0Ktt0Zs5ZeD2vv/yIMW0fbApDShBFZkGXqVjEkTkLuyAIJe5R3QH0vnt8pROyeviaxr0grbGq9lvPBTe1D1x5tzW6jJ1ha4mfm1wGIMnuS3Eq2zXTGOBR8i7SK5oeQpY10lyaX/oWr+beYa+KR9S27fV4IelyqIiIa+ZHp8azGUQM2c0Snflfx+XseBjNVtHb+ZsS/H6N03zI+XAlye58jdEN+R6blmddd8g8Z8/QLHIdbYRnjktxCKs/TXESASoL7f8RsipOvB6+bQ6cvIAk0PqgB8hXRU4YYISEX/xnZ/1txmDrkJzXzm79qVgIxaUeW07UGyxQDYofk7Kf9zmK/z683XxMZ/t60mNTvuC3vaLpkJlCM3VDzLtak+MTSdFiLCuviagAJZzpkNLro5WEuM41Wjfjjt2iUdIIxl+uCK0ixHEoUh+7Kysjrzj3WHSJImLMmp40z3683kbYlC9DnfBrtf7MGuRXwsx80OB8iZ0rdZP7M6hnVZlKDmshaMynpzGElNozj9x5IQEL7+SORKYT9Rkxb8LVTFhEpO5vWBks/CgvYI6Cw9SbSI4ASeC15J8NA0nJIkCYCXWHPzR27VjyEnbiBhoGFBE91D5BUdoc0sexbGt4V2UXij6QpnNCrWvyHUzPq+Vvzw7GRLt3qzQvhVsVNtMDp1LTkjifUEEiGdUtZsLHzbe61e2lIcI5hIiT0eg4zOfEa0wLNiGAz5bu/P3wgQm2vRR/u92AEt4gjicmoVoSdJyIP8bvWtadQVS4Wyre4qJ9tH3YOCbU5gaKXPAGEcxam4pXp8PUfiN0ytHThQN2tM60N/m8AjBYQFXjYDfvfpxgZa1mcXue0IyHZ/oFt08XOsi03LjkZJuT8f90zw/LMT/wGKUvBxsKBz5DrOK4/kqR7uUPnYDBwGKJktpc6Txpj4XCmxfOE/7P5nOK00T2yRkKsuXPiqqZKlsX+pzTlfl0boYD6/GbvqvcKfOgXKcVwmXDt3ZLVHN/RMDDliwOuC/sfLfPrPwJzdI3wma/hTnBOWIWsOut1zmWQqjUKTEpEyaQ8mYPE4lLci390TNzBs5B+MnatOumlPgxMnQx6oWk+6X5voYeYmBZWyzo1gT0RkxrRrF843Gr5TZTFj7/0kzb3y1eGxD2IPsErszRteEdEWV0sN41+KC/WV+nB/xwMdh2jyug=|/baxFdqbi8AULfxbxG7DbaomI490o//q3XVEbgjDS/A=', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-09-08 02:56:34.493', '2023-09-08 02:56:34.493', NULL, 0, 600000, N'{"id":null}', N'ZFeyXwvntdS8Aty7mJgtsRG06vaA0w', 0, 0, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


-- Emergency access for migration test
INSERT INTO vault_dev.dbo.EmergencyAccess
(Id, GrantorId, GranteeId, Email, KeyEncrypted, WaitTimeDays, [Type], Status, RecoveryInitiatedDate, LastNotificationDate, CreationDate, RevisionDate)
VALUES(N'DD982204-8FB7-4D54-A972-B0770030A05F', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', N'13D8D3AB-F806-4AEB-A677-B07700307F85', NULL, N'4.Jod46Z8gHfwNYEaaqra7aF87O2+QKABFX/NUTJ5irXpdLntXqeB9DlbHabf6agLOmkffiVKHyazNB/Y39X56xi5QPqmHUQPpeMAc26MIpIzeK9Kr1KFFu4hhfTzW+4zQ5OFfoQWpZdY9Ktj0q7JmRb8J4vbkK6TbwCB82bwt2AU6yXVyBCWK+gLGwHdEsGxXw2sZOoeKLcAiFp0JKQYpA0CpMzxxin5uuHWWBPLQZ+hmHZ7Mz/YbLI9pBhgQK3xKPuuwDZyG08Fu6llYBCcG1t4zVc7c+rBqTWB6w82IRD4qgbq82v0udFhDHo+aEpVRLt5gJPmMNOB/14QuXoctpQ==', 7, 1, 2, NULL, NULL, '2023-09-08 02:57:02.606', '2023-09-08 02:57:02.606');


-- Create some test Ciphers for the legacy user
INSERT INTO vault_dev.dbo.Cipher
(Id, UserId, OrganizationId, [Type], [Data], Favorites, Folders, Attachments, CreationDate, RevisionDate, DeletedDate, Reprompt)
VALUES(N'6C2EAD6B-14BC-4C33-8AC1-B06F012D8C9F', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', NULL, 1, N'{"Name":"S3zI08OHdEnlHIV+W8oMaQ==|Iw43SGDgkC8Az8IU3KG1JQ==","Uri":"YnL6tlkNjggTeeg+2pdUGA==|48xUv7RMmrW2Wcgeoatx0mp8jsVL2VbfkbjIvkNnmv8=","Username":"zWhStxurnv9lvVqC/O8rPg==|zRAl3eDveZWNwVTLfPr5HQ==","Password":"JbsfRGqr3vjgewnuPG88Kw==|O7aMkBqzaY5OLRU1Ip/Yvw=="}', N'{"C6BF38FB-82B4-4D7A-A9BA-B06F012822B5":true}', NULL, NULL, '2023-08-31 18:17:54.423', '2023-08-31 18:17:54.423', NULL, NULL);


INSERT INTO vault_dev.dbo.Cipher
(Id, UserId, OrganizationId, [Type], [Data], Favorites, Folders, Attachments, CreationDate, RevisionDate, DeletedDate, Reprompt)
VALUES(N'018C3A29-526A-461F-B77B-B06F012DD92D', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', NULL, 1, N'{"Name":"QVGjTfLOjGvCaHP6Qi5ysw==|cLQA/oE8uHNRdxs2jB04LQ==","Uri":"xLqcvB8jup9jfRBLINl7lg==|ykXC6T6RrA5UWR0Udt253GEcSjfaw5qd6WMdoByHXt8=","Username":"gcqW5/rTGXOfaiJPaiJ7ew==|D0IbbU6eF/JAFRCrm6A5WQ==","Password":"fpSJmx7UAPKzim0C3fVovA==|pIpdmyzaqS+fr7TjuG2m/g=="}', N'{"C6BF38FB-82B4-4D7A-A9BA-B06F012822B5":true}', NULL, NULL, '2023-08-31 18:18:59.773', '2023-08-31 18:18:59.773', NULL, NULL);


-- Create organization for admin recovery
INSERT INTO vault_dev.dbo.Organization
(Id, Name, BusinessName, BillingEmail, [Plan], PlanType, Seats, MaxCollections, UseGroups, UseDirectory, UseTotp, SelfHost, Storage, MaxStorageGb, Gateway, GatewayCustomerId, GatewaySubscriptionId, Enabled, LicenseKey, ExpirationDate, CreationDate, RevisionDate, BusinessAddress1, BusinessAddress2, BusinessAddress3, BusinessCountry, BusinessTaxNumber, UsersGetPremium, UseEvents, Use2fa, TwoFactorProviders, UseApi, UsePolicies, Identifier, ReferenceData, UseSso, UseResetPassword, PublicKey, PrivateKey, OwnersNotifiedOfAutoscaling, MaxAutoscaleSeats, UseKeyConnector, UseScim, UseCustomPermissions, UseSecretsManager, Status, UsePasswordManager, SmSeats, SmServiceAccounts, MaxAutoscaleSmSeats, MaxAutoscaleSmServiceAccounts, SecretsManagerBeta)
VALUES(N'6C68B657-58F1-4579-961E-B077003BDCB0', N'legacy admin recovery test', NULL, N'jfink+emergency-access-legacy@bitwarden.com', N'Enterprise (Annually)', 11, 100, NULL, 1, 1, 1, 1, NULL, 1, 0, N'cus_Ob7lVoeGTbbcWO', N'sub_1NnvW6IGBnsLynRr1EFkTLuR', 1, N'QfVUPOmrUgnQUUemIzP8', '2023-09-15 03:37:58.000', '2023-09-08 03:37:57.070', '2023-09-08 03:37:57.070', NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'{"id":null}', 1, 1, N'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsXNASa4VQCqRNBhIz/AaL0jNNjcLG2e/4DgPh/9Ollfh8O6nJUC4pH5p8FqfQGi1ujukyEC1NDVOplAVSY/BC5UG4NoPy2Hmd+JngubU8bUDCbIp80c6fEcEWmsfDpWFget3E1y+oqt+lmGzv5gmi9R7b2wVlPY7y26/076rSd9rTRdy2gkh8ayZpbkogc/uRaEC6CUrz2Kv/urWuvmsGr42oZ8lBgmAoD1+MXPQhx3qFtDEl7lmmohbOvqpXrkJrGwmgny1GfjUL4o2+OUHNaMdcv4Mx9TNHgpjG6EG2p3nV4c1oZduBWZPe2/2gdVRbOHVrXPlnVaepawT/ZY4kQIDAQAB', N'2.WR0bSRDRDyRHMfVAkqqhBg==|i9kNkxh6iSSSSBolvWu7Ab5xk/w/36PGnBtR6r/wC4L1B68W9N/LMk1ZMGfnpTbYhiWcqb8MafG/Ww4XSjjy4p1XefhdclRmqbs0Avzhsz9CuadJQ21OegBvDWpJ1G2wwm/j/seM+mLeL/VG+rridstKisxSV3PcBRo09PoYtcfakMtBLU0wJwjeNZTaro+lRcP8U4YVSBWsOiO73bjLeDIm3vCeq4RbQ4vdS9MHbFAob/e/nLGq3d2nHR0EIaLB+QFmp/p6YdWd7R8UEjtynSELCgtFT6T9lNWxytNym+RMPK98LHQ3up6bKh2WWBxwXRZtiE0ycXMhDlCEuaQDn00rzeaWoR9NzejDMSSTcjqBbful/Thjd4L6kmTtI/78z1uEfDCpn56ZACHNv2SBOx1dXlNL4+A/p7PAfKEz47YB3JigCnEAvDU3KFW3VdnmzraHFyyQl1YP77g2NaO5Ob4nI8ujtYUPDfnEKNivDAsGYaC4Cbv8fiiMCxorFrnddUWDx77/ZScTl6SORAyTXMnSMiaDzf+dhX0x4TJLcpQGhTJUvSUsRUkkshezZj/6ewpyUJWQhvQg6/MWKThvG9p3fGkYXbyvO6BK0/m5ccDzcgQDPOuUMT83B4BdsYL6fAGoN9a3vTrJmQ8LC3InMpkD3xlQ9kxKHacYTf8wc7kEUgZTZ7isYvc9txYf45KuTufoHchyzZ5XpA9mYnG6RG9NqXBLr4uAjIG901Qh/nldjQyfpT348/iBQJx+Z5pfDCV+m4WF5FiASYmAiuuZy3AkY2s5K5fNhQNpg+9eVcWHB4TYt7q/WUeHifnb8irFrvwBtmnLUFPaBdH/WonVMN5GCKil4EXx2dtCVmw54JyNs/ctjWGlfJ/tCKU9YKly6mnVWXS84u+sfU2cqmqa7Z69Q/6cS/36XK7VCZTmX7+qDEj7SkNlEJUmrfHbXGTmtcRBQT8SFABLoo3QrFulDDmVqWbaBBVKyRh0NmGya9dRmkK58HFubVKig/2HDTWw8Nd+lW/nXa1bUVqSNpD1L+2n3xhVV7FDqIeF3CPFw76UwJKLdWJaTyiEAz9RWuIUw5wbabJYQYLtdHSqN6NO6Tu5XUaki6Zjyz7sQZkj+hJiIjGsZ+/mrppLQXx58ixaHRIMGyN9Uo8Np7zMI2ai/GVzuI9g6REexaGX1F56so9kuIzWvHG0dgzzjLwdriuMkZn0LiCBs7d5YHelq3R7HWZ28ddb0aNuOYs8RzkoR8hFskrK/bG3B7oNPHHcPpd+PWY4g6/X3eAoSN0K9J8OWwkODg/AqrVBBubx2jaY8wBjYKC1m/LfsZ1R7unuI+6N3vfX+Zlm5JxsaME86WUSCmInE0P36pSBIPmSXPQitwIYTmjmK2tMhCeNQetK4Yp1humvtPtN4r94Ls8kBLBzlihYGokG1bqVEmFXMBHF1J14bB82vk+Q7dBePgLOk+3zWdGFcm8fWcCwR3Y/fhLTScKdnyJnaBdO3LU4IVCAtRHnXgBsf/KVkH8BM2xxX3ycmV5ljeyVJVwtTe11yjWSu6TtzK93YeHy1zaSAGTDb+/0E3EOXypkYzUlGN4CmJe+J3vsV/ZOzcw9K1z+8yJJU9ylkPG3xt9QWdCDHoAkqH8=|FQp6DvlcOTAe7YXkzYr8R5FkeyPz6m/FwzUagk7Ebvc=', NULL, NULL, 0, 1, 1, 0, 1, 1, NULL, NULL, NULL, NULL, 0);

-- Add admin recovery policy
INSERT INTO vault_dev.dbo.Policy
(Id, OrganizationId, [Type], [Data], Enabled, CreationDate, RevisionDate)
VALUES(N'D47A0ADE-0DC2-4B1A-95AD-B077003C6979', N'6C68B657-58F1-4579-961E-B077003BDCB0', 3, NULL, 1, '2023-09-08 03:39:57.176', '2023-09-08 03:39:57.176');

INSERT INTO vault_dev.dbo.Policy
(Id, OrganizationId, [Type], [Data], Enabled, CreationDate, RevisionDate)
VALUES(N'232D94DE-5991-4303-B5FC-B077003C6E47', N'6C68B657-58F1-4579-961E-B077003BDCB0', 8, N'{"autoEnrollEnabled":true}', 1, '2023-09-08 03:40:01.296', '2023-09-08 03:40:01.296');


-- Add admin
INSERT INTO vault_dev.dbo.OrganizationUser
(Id, OrganizationId, UserId, Email, [Key], Status, [Type], AccessAll, ExternalId, CreationDate, RevisionDate, Permissions, ResetPasswordKey, AccessSecretsManager)
VALUES(N'975964B7-7680-4A75-A968-B077003BDF46', N'6C68B657-58F1-4579-961E-B077003BDCB0', N'13D8D3AB-F806-4AEB-A677-B07700307F85', NULL, N'4.clFUGS1DfSVArCdt49ie8YI4ty3Cgxv8RabEHh/7WXlB61BWH5tLIOXhJ7i/Dy+586f8gr7fKvWeA3fIsCYHn1wzkc0QJzU5roSAqudFBMi8FnwW/km2V7ABsCbnk9wFqcmSsbXdOVoxsFWwJPn5ZWo3GPV/J0Fb523KmMiXi6JYKihM0lDBxeM/HFDSrNdyYyH+2qe2KDTIScs+OKFVsHHSLVWlGftejOtx5qdbbA0qkd3UikDurDKxcKNa7NgyiLAy9To5xFn7KE6IJL+1yF4mYNmnAZogaB7nrW99rJMirBMFy0DQ/Gsct+cu/xM0aoNjl5fymIPNK9bXLt9iAQ==', 2, 0, 1, NULL, '2023-09-08 03:37:57.070', '2023-09-08 03:37:57.070', NULL, NULL, 0);


-- Add legacy user (enrolled in admin recovery)
INSERT INTO vault_dev.dbo.OrganizationUser
(Id, OrganizationId, UserId, Email, [Key], Status, [Type], AccessAll, ExternalId, CreationDate, RevisionDate, Permissions, ResetPasswordKey, AccessSecretsManager)
VALUES(N'4CE42576-6777-4820-AB91-B077003C48E2', N'6C68B657-58F1-4579-961E-B077003BDCB0', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', NULL, N'4.vTrUa2ySXs+QmrhXdZAsl6Wbdgqyjh3yXcfRIMtn4x+9Yxm++2Yk5k7X+i0lyYiL9lEc82fsPpXOM0V/WO9YqcJ/IYfgla3YVwDXtCYDAzGvx78LYAKlFJe9xK7qKvyXmv1LNx+BCorpzu6bSphIjjXImfT03VwUvX8Wp9LzD0Ty3fuVtq/QiSs5JXTCHjrXy4CCb52BpKArhn89sZkb5V3Vik85XrAW/Yu+gHNr3F0G1Lgen3mAaEBx63ACJBOvxZg5GnIePnl0PPR8/B1OSTJ1EHgrVP20I8YazDmULN2Ucqn+CycsL9MKKFeiJTee/uLtU29fCJnv6R0L+20neg==', 2, 2, 0, NULL, '2023-09-08 03:39:29.390', '2023-09-08 03:39:29.390', N'{"accessEventLogs":false,"accessImportExport":false,"accessReports":false,"createNewCollections":false,"editAnyCollection":false,"deleteAnyCollection":false,"editAssignedCollections":false,"deleteAssignedCollections":false,"manageGroups":false,"managePolicies":false,"manageSso":false,"manageUsers":false,"manageResetPassword":false,"manageScim":false}', N'4.I1f7I86lMEdjwT1wUgCsZldHm+H5O7xJ8YaGnXb+IGGUTkGfj5hPvz7NXElePR8ukaFCtTgQDdfNaxpFMs4G60/jWRQ4EnJSKQfwQt9E6UrWzpGhAQOyblAf1kinmDoHOZ9LMnO/bos3cnkfr9AhbrfoN0/zo/yQDJGi3xIlfpkaXDk+af7gsyiYCTnQQdDDt/8GeZzNiqT0rbiM3z8aUTj4Z18vkkYfgET82RZPoEYuS+p0OJKoYfYHPZIZ4ZiYjZPWU7aPd+L6b6Lu3gAU5Xk5NCr91+vQgne0DuxI/Qj2+vpHhHhcR+qzKMbR3HSkCqnK0dFdgJ25uX8r32PHbQ==', 0);
	-- Clear any leftover data
	DELETE FROM [dbo].[OrganizationUser] WHERE [UserId] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5', '13D8D3AB-F806-4AEB-A677-B07700307F85');
	DELETE FROM [dbo].[Policy] WHERE [OrganizationId] = '6C68B657-58F1-4579-961E-B077003BDCB0';
	DELETE FROM [dbo].[OrganizationApiKey] WHERE [OrganizationId] = '6C68B657-58F1-4579-961E-B077003BDCB0';
	DELETE FROM [dbo].[Organization] WHERE [Id] = '6C68B657-58F1-4579-961E-B077003BDCB0';
	DELETE FROM [dbo].[Device] WHERE [UserId] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5', '13D8D3AB-F806-4AEB-A677-B07700307F85');
	DELETE FROM [dbo].[Cipher] WHERE [UserId] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5');
	DELETE FROM [dbo].[EmergencyAccess] WHERE [GrantorId] = 'c6bf38fb-82b4-4d7a-a9ba-b06f012822b5';
	DELETE FROM [dbo].[User] WHERE [Id] IN ('c6bf38fb-82b4-4d7a-a9ba-b06f012822b5', '13D8D3AB-F806-4AEB-A677-B07700307F85');



	-- Create a legacy user
	INSERT INTO vault_dev.dbo.[User]
	(Id, Name, Email, EmailVerified, MasterPassword, MasterPasswordHint, Culture, SecurityStamp, TwoFactorProviders, TwoFactorRecoveryCode, EquivalentDomains, ExcludedGlobalEquivalentDomains, AccountRevisionDate, [Key], PublicKey, PrivateKey, Premium, PremiumExpirationDate, Storage, MaxStorageGb, Gateway, GatewayCustomerId, GatewaySubscriptionId, LicenseKey, CreationDate, RevisionDate, RenewalReminderDate, Kdf, KdfIterations, ReferenceData, ApiKey, ForcePasswordReset, UsesKeyConnector, FailedLoginCount, LastFailedLoginDate, UnknownDeviceVerificationEnabled, AvatarColor, KdfMemory, KdfParallelism, LastPasswordChangeDate, LastKdfChangeDate, LastKeyRotationDate, LastEmailChangeDate)
	VALUES(N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', N'Legacy User', N'jbaur+legacy-test@bitwarden.com', 0, N'AQAAAAEAACcQAAAAEOGcgDo2KBDxbn1dOUtAxBDfl9lu6g7xk0OfC+0DjAJ05krIG9RHpDy2cJoWCfpL7g==', NULL, N'en-US', N'7dac2841-0df0-4914-aebf-b0587e1272b2', NULL, NULL, NULL, NULL, '2023-08-31 18:20:03.963', NULL, N'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvxiKDs7QfYTyMez3+3mT1+Qp+Q1+OtqdF8BckqpDHzpBvvKCLj/xEXa7Yn2jKFvpexaVQy9Q9Og9tHLYTdIhIeAdFfEC8FDjH0jaVC3US4D1CVAV5Fa+fnJwmYxCIi3P9Nphrzju83X/Mg1XpoZQl/ZnSZdwpwNVcdnz6sFlcuq/1h1zGJGATHaqsbe1gHKsEqPM0PaZcq5EscuRg+/0/S4fVQGusltS5cbWxmwHBJX7c/frUbF4jXcu5gUQgYGgMABNhBHNSrD4qAWRwoK61Dvl9tZtXDQWG7pDJWgpUtt5OLrmMP+aqw+Zh3EV1C2WyBsvrrwnxh7Xv4L+T+0wGwIDAQAB', N'826sJeAaV/dTv3KYEuDlsA==\|6gblZK8vuaK4FWdjcO5zdGkOXGUm4h7gpZx/2gBdhohlmtxdtOS27BQhrfjl71lOOIthXwAb9RE/fcDxbGRYwkceh65MIh/YpOU0jQLog9NfS4YQUvLp3/NbT7EotWWQOufmF8jZabX+w4HZW0dJOnjJJ8YtwLdPtQZOpnS9d+jn8oQg/sCu5l/CW42T+Cn6OwNot7g9L6kROgE4O8VAqf98UMizRUVEjmHeKkxu28qnqxYYCTDjesbbyBq5itrfe+30aUznhAqchw0ToNyTtukO38CbHkhWQd/RZqIk1S9oxHJqo2R7DlV14+f1C9ehPVgLiHp/kNjaQH4qy3Dtyma6TijctgSiByGp9jLzdXSgQdBRYwSjuVIyYYXO4lJ4jzO8Rv42/qm9OjcAgB/OPGjpSQ6WLrS9EGxKP9b8vWPHSVnNKU4p8niFKUl5UOffyxI8m0CNRRaFQSxUh4KyDzeZSNpz0Yg4Thv1nWZaMIFhmgLW0d5d0oOLQczD2ph+sw/wyHeTgNsgH/woMcMGFFDfzMaNgENVA574d1ZIYP0FO6/bW7pYE1JT628PWgyFPHNjo6OtosVgACEuZkbSGLF8Nyzz9yjqHMyyi/s0F68amT68Q15n35k86nJWt1704sQbEjtgE9bycwwotmUa/lPANhJxnYX6nSxLPqTIpNToXCvoNPB45ZrLUfpOIYJeOH2EuvmYLPPq2YSSdFYKV/i/bcalQ4qx37xB5MT5rvSsKhtGgF9TUWpWXIQ1pHVaKTXSwUHvZLnLFv6f0d3J0iJw26trSDCKP2v08zWc8puXvhHL6j50XFmg+4hPFboEX9qLmlUfps7mukHbAixggyJj6CFXH7jKAhTK8GxWskO4YxgbsJdMnt4PU0xiR3R6uKxDizPK6gSunIObGQs0MMXH6zJz6PEZlMmmgFJ64nyN9BBsO5bW8zcjbH6YPjz+Mn6On69GqfV+HI/9uSD4dTxs/sIaB0pueFy6B7g/nLWjsaOPHeIPNdFEodiX5+poMvzRBMtJisU7iummPR/RRg75zrbgOE+L8fLaWD/lNwWpTZ5AmUO5TxsYIJGnrIhvSYQlg+UBK8UuLpbWOkUC01LLXr6qogAPWf2LPpCPu33ESsnP2+Xr+DVM52c2mm6T6eushMacUwJHcCRLpL/U1hCzLOTyawlhneh+2V/hDxrMgv4R9tV/c6LozCTM1ghRQsSaO4HnDFSnEXDEGGLODlIiQsedphhgv813NiYE+ru1/AA+SqU+CMQ1Ct1pJPR/7EU/GlovVUAitFo4it51e5bQLkIMCMTCdfFDQLTKYsEraFVW8xsOPXzqGXhq+oDYt8X1ipyIonI9pV6fzOgrOXNvphPZRahjP/MBfAwnmN2hGIm4rucoRJhEpXFgqHxMYTZ5BpId+qikdaV0n4e9TndAi3tNtLWzAVEGe+DfX8tRK7apN/4QEE36oLRfgE1gWr/U2RHYDv2JIL4rg9B8i+gSu5uZ2ITA/i5mCm0fmRQUSmcEpd/+sKQf8CMHSiJGHUBU4VZ1sFkX57v0oENY73P2mU2C3p3LaHxTyc5Q9iKxsOGOnnkiWjiSRQzABCsy3zr7D16M/Sco1x408jv6ClcvDdgtdTl9I6XjrYigRw0=', 1, '2029-09-08 02:45:21.083', NULL, NULL, NULL, NULL, NULL, NULL, '2023-08-31 17:58:11.630', '2023-09-08 02:45:21.083', NULL, 0, 5000, NULL, N'TEST_API_KEY', 0, 0, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



	-- A normal user for testing key migration with emergency access
	INSERT INTO vault_dev.dbo.[User]
	(Id, Name, Email, EmailVerified, MasterPassword, MasterPasswordHint, Culture, SecurityStamp, TwoFactorProviders, TwoFactorRecoveryCode, EquivalentDomains, ExcludedGlobalEquivalentDomains, AccountRevisionDate, [Key], PublicKey, PrivateKey, Premium, PremiumExpirationDate, Storage, MaxStorageGb, Gateway, GatewayCustomerId, GatewaySubscriptionId, LicenseKey, CreationDate, RevisionDate, RenewalReminderDate, Kdf, KdfIterations, ReferenceData, ApiKey, ForcePasswordReset, UsesKeyConnector, FailedLoginCount, LastFailedLoginDate, UnknownDeviceVerificationEnabled, AvatarColor, KdfMemory, KdfParallelism, LastPasswordChangeDate, LastKdfChangeDate, LastKeyRotationDate, LastEmailChangeDate)
	VALUES(N'13D8D3AB-F806-4AEB-A677-B07700307F85', NULL, N'jfink+emergency-access-legacy@bitwarden.com', 1, N'AQAAAAEAAYagAAAAEKgB6ZIqSuLFVzlI434bzdcCDRxsdgWkuUrzkzUvBWkh3jW2FXk6Y2vg11oq92cMgw==', NULL, N'en-US', N'3LHYFFR6TBMOFCAHCIYQAPKZIBYW4QUL', NULL, NULL, NULL, NULL, '2023-09-08 02:56:34.493', N'2.2Fq1UCMHwCNggC3CG/GTkw==\|NM3bFWIUex1RkHrFFekjsQc8ZXCx3a/xkCWYSVvXd7I7DanwfMkQjDl45t1Phu29WCHmx7s2AxSXg9so2o493S3JDrwYavr2IHSl3gyXA+g=\|QWyJ7h/3r2EUXcmKh1pvXW/beWbw8WDRiVKulTh4NwE=', N'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxwMBxxGxVh1QXj+ashGQHQJ2W0jfshPtSaiNB5XPcRr44DfdcXoGNLwqAdSuUBBYX4kKgbSJpU2jVawz1rPwbgqspLUpDckDsrd0FqNRU3rAPPulxkRU0Wt4B7baBIhkuh0aaOvmypbcRUutx7ig1ENAgzlJYgAESr2h1ptXLObu6SLfVyUPwgIYDgcm2N61x42q5f0QliBHCDF2RiGSVk2pr5eAFdm4KACSpz1aCoXM3OdbM/8XA4dByYd0aMYzhSuCYjkpfUCShTs2F1YtpPy9+o1xBUo1UxlcEM1cnabmkU8W57dy1Dyghis7Ya7UTRXNAAltXKq+xjJS1sRMLwIDAQAB', N'2.ygOCuZ+ov4dTc8MshxmP3Q==\|ZwoYvEa2TRnfDxauO9g98P2oxugqfjUCz3BrGJ9wkcsm87MX6JiuU6BtmxkiP1iXvxRnwMmnxyIzbWYCFpnUoBy7TicUvaiPJL6GvvJVmpXlDrx5ZvTnNpQ2XrAioORaYx6jvmBiVBMixSmE240xVqjusB6tKxEyIPt0bn+62BbTMZuvke61YoI+0kx0JwSJqt7hMcroHU7kd/tknLU38gdaxd/QUNZK/S9FY33D28vgHcOQ+RPvwD9W3z7nPbidUo/RNUEEIPMrZJmBMwfkQue62RI1xOmpHo1NCuEzNtAbPImcfaQNQb9UkMbTrcBEGryvlzpSX/MmqkQhqiRhOEdkqkqBIDIZ0BgTd4mt+0KzWwDpLPr7KFI6Pc3mSEDDb0P+wmeIhKJUgcJFbf888nq8l3XLyYvHIRwlqA67wHzOjl5rER0gkkOeExOvQ5zoEm0Ktt0Zs5ZeD2vv/yIMW0fbApDShBFZkGXqVjEkTkLuyAIJe5R3QH0vnt8pROyeviaxr0grbGq9lvPBTe1D1x5tzW6jJ1ha4mfm1wGIMnuS3Eq2zXTGOBR8i7SK5oeQpY10lyaX/oWr+beYa+KR9S27fV4IelyqIiIa+ZHp8azGUQM2c0Snflfx+XseBjNVtHb+ZsS/H6N03zI+XAlye58jdEN+R6blmddd8g8Z8/QLHIdbYRnjktxCKs/TXESASoL7f8RsipOvB6+bQ6cvIAk0PqgB8hXRU4YYISEX/xnZ/1txmDrkJzXzm79qVgIxaUeW07UGyxQDYofk7Kf9zmK/z683XxMZ/t60mNTvuC3vaLpkJlCM3VDzLtak+MTSdFiLCuviagAJZzpkNLro5WEuM41Wjfjjt2iUdIIxl+uCK0ixHEoUh+7Kysjrzj3WHSJImLMmp40z3683kbYlC9DnfBrtf7MGuRXwsx80OB8iZ0rdZP7M6hnVZlKDmshaMynpzGElNozj9x5IQEL7+SORKYT9Rkxb8LVTFhEpO5vWBks/CgvYI6Cw9SbSI4ASeC15J8NA0nJIkCYCXWHPzR27VjyEnbiBhoGFBE91D5BUdoc0sexbGt4V2UXij6QpnNCrWvyHUzPq+Vvzw7GRLt3qzQvhVsVNtMDp1LTkjifUEEiGdUtZsLHzbe61e2lIcI5hIiT0eg4zOfEa0wLNiGAz5bu/P3wgQm2vRR/u92AEt4gjicmoVoSdJyIP8bvWtadQVS4Wyre4qJ9tH3YOCbU5gaKXPAGEcxam4pXp8PUfiN0ytHThQN2tM60N/m8AjBYQFXjYDfvfpxgZa1mcXue0IyHZ/oFt08XOsi03LjkZJuT8f90zw/LMT/wGKUvBxsKBz5DrOK4/kqR7uUPnYDBwGKJktpc6Txpj4XCmxfOE/7P5nOK00T2yRkKsuXPiqqZKlsX+pzTlfl0boYD6/GbvqvcKfOgXKcVwmXDt3ZLVHN/RMDDliwOuC/sfLfPrPwJzdI3wma/hTnBOWIWsOut1zmWQqjUKTEpEyaQ8mYPE4lLci390TNzBs5B+MnatOumlPgxMnQx6oWk+6X5voYeYmBZWyzo1gT0RkxrRrF843Gr5TZTFj7/0kzb3y1eGxD2IPsErszRteEdEWV0sN41+KC/WV+nB/xwMdh2jyug=\|/baxFdqbi8AULfxbxG7DbaomI490o//q3XVEbgjDS/A=', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-09-08 02:56:34.493', '2023-09-08 02:56:34.493', NULL, 0, 600000, N'{"id":null}', N'ZFeyXwvntdS8Aty7mJgtsRG06vaA0w', 0, 0, 0, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



	-- Emergency access for migration test
	INSERT INTO vault_dev.dbo.EmergencyAccess
	(Id, GrantorId, GranteeId, Email, KeyEncrypted, WaitTimeDays, [Type], Status, RecoveryInitiatedDate, LastNotificationDate, CreationDate, RevisionDate)
	VALUES(N'DD982204-8FB7-4D54-A972-B0770030A05F', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', N'13D8D3AB-F806-4AEB-A677-B07700307F85', NULL, N'4.Jod46Z8gHfwNYEaaqra7aF87O2+QKABFX/NUTJ5irXpdLntXqeB9DlbHabf6agLOmkffiVKHyazNB/Y39X56xi5QPqmHUQPpeMAc26MIpIzeK9Kr1KFFu4hhfTzW+4zQ5OFfoQWpZdY9Ktj0q7JmRb8J4vbkK6TbwCB82bwt2AU6yXVyBCWK+gLGwHdEsGxXw2sZOoeKLcAiFp0JKQYpA0CpMzxxin5uuHWWBPLQZ+hmHZ7Mz/YbLI9pBhgQK3xKPuuwDZyG08Fu6llYBCcG1t4zVc7c+rBqTWB6w82IRD4qgbq82v0udFhDHo+aEpVRLt5gJPmMNOB/14QuXoctpQ==', 7, 1, 2, NULL, NULL, '2023-09-08 02:57:02.606', '2023-09-08 02:57:02.606');



	-- Create some test Ciphers for the legacy user
	INSERT INTO vault_dev.dbo.Cipher
	(Id, UserId, OrganizationId, [Type], [Data], Favorites, Folders, Attachments, CreationDate, RevisionDate, DeletedDate, Reprompt)
	VALUES(N'6C2EAD6B-14BC-4C33-8AC1-B06F012D8C9F', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', NULL, 1, N'{"Name":"S3zI08OHdEnlHIV+W8oMaQ==\|Iw43SGDgkC8Az8IU3KG1JQ==","Uri":"YnL6tlkNjggTeeg+2pdUGA==\|48xUv7RMmrW2Wcgeoatx0mp8jsVL2VbfkbjIvkNnmv8=","Username":"zWhStxurnv9lvVqC/O8rPg==\|zRAl3eDveZWNwVTLfPr5HQ==","Password":"JbsfRGqr3vjgewnuPG88Kw==\|O7aMkBqzaY5OLRU1Ip/Yvw=="}', N'{"C6BF38FB-82B4-4D7A-A9BA-B06F012822B5":true}', NULL, NULL, '2023-08-31 18:17:54.423', '2023-08-31 18:17:54.423', NULL, NULL);


	INSERT INTO vault_dev.dbo.Cipher
	(Id, UserId, OrganizationId, [Type], [Data], Favorites, Folders, Attachments, CreationDate, RevisionDate, DeletedDate, Reprompt)
	VALUES(N'018C3A29-526A-461F-B77B-B06F012DD92D', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', NULL, 1, N'{"Name":"QVGjTfLOjGvCaHP6Qi5ysw==\|cLQA/oE8uHNRdxs2jB04LQ==","Uri":"xLqcvB8jup9jfRBLINl7lg==\|ykXC6T6RrA5UWR0Udt253GEcSjfaw5qd6WMdoByHXt8=","Username":"gcqW5/rTGXOfaiJPaiJ7ew==\|D0IbbU6eF/JAFRCrm6A5WQ==","Password":"fpSJmx7UAPKzim0C3fVovA==\|pIpdmyzaqS+fr7TjuG2m/g=="}', N'{"C6BF38FB-82B4-4D7A-A9BA-B06F012822B5":true}', NULL, NULL, '2023-08-31 18:18:59.773', '2023-08-31 18:18:59.773', NULL, NULL);





	-- Create organization for admin recovery
	INSERT INTO vault_dev.dbo.Organization
	(Id, Name, BusinessName, BillingEmail, [Plan], PlanType, Seats, MaxCollections, UseGroups, UseDirectory, UseTotp, SelfHost, Storage, MaxStorageGb, Gateway, GatewayCustomerId, GatewaySubscriptionId, Enabled, LicenseKey, ExpirationDate, CreationDate, RevisionDate, BusinessAddress1, BusinessAddress2, BusinessAddress3, BusinessCountry, BusinessTaxNumber, UsersGetPremium, UseEvents, Use2fa, TwoFactorProviders, UseApi, UsePolicies, Identifier, ReferenceData, UseSso, UseResetPassword, PublicKey, PrivateKey, OwnersNotifiedOfAutoscaling, MaxAutoscaleSeats, UseKeyConnector, UseScim, UseCustomPermissions, UseSecretsManager, Status, UsePasswordManager, SmSeats, SmServiceAccounts, MaxAutoscaleSmSeats, MaxAutoscaleSmServiceAccounts, SecretsManagerBeta)
	VALUES(N'6C68B657-58F1-4579-961E-B077003BDCB0', N'legacy admin recovery test', NULL, N'jfink+emergency-access-legacy@bitwarden.com', N'Enterprise (Annually)', 11, 100, NULL, 1, 1, 1, 1, NULL, 1, 0, N'cus_Ob7lVoeGTbbcWO', N'sub_1NnvW6IGBnsLynRr1EFkTLuR', 1, N'QfVUPOmrUgnQUUemIzP8', '2023-09-15 03:37:58.000', '2023-09-08 03:37:57.070', '2023-09-08 03:37:57.070', NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'{"id":null}', 1, 1, N'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsXNASa4VQCqRNBhIz/AaL0jNNjcLG2e/4DgPh/9Ollfh8O6nJUC4pH5p8FqfQGi1ujukyEC1NDVOplAVSY/BC5UG4NoPy2Hmd+JngubU8bUDCbIp80c6fEcEWmsfDpWFget3E1y+oqt+lmGzv5gmi9R7b2wVlPY7y26/076rSd9rTRdy2gkh8ayZpbkogc/uRaEC6CUrz2Kv/urWuvmsGr42oZ8lBgmAoD1+MXPQhx3qFtDEl7lmmohbOvqpXrkJrGwmgny1GfjUL4o2+OUHNaMdcv4Mx9TNHgpjG6EG2p3nV4c1oZduBWZPe2/2gdVRbOHVrXPlnVaepawT/ZY4kQIDAQAB', N'2.WR0bSRDRDyRHMfVAkqqhBg==\|i9kNkxh6iSSSSBolvWu7Ab5xk/w/36PGnBtR6r/wC4L1B68W9N/LMk1ZMGfnpTbYhiWcqb8MafG/Ww4XSjjy4p1XefhdclRmqbs0Avzhsz9CuadJQ21OegBvDWpJ1G2wwm/j/seM+mLeL/VG+rridstKisxSV3PcBRo09PoYtcfakMtBLU0wJwjeNZTaro+lRcP8U4YVSBWsOiO73bjLeDIm3vCeq4RbQ4vdS9MHbFAob/e/nLGq3d2nHR0EIaLB+QFmp/p6YdWd7R8UEjtynSELCgtFT6T9lNWxytNym+RMPK98LHQ3up6bKh2WWBxwXRZtiE0ycXMhDlCEuaQDn00rzeaWoR9NzejDMSSTcjqBbful/Thjd4L6kmTtI/78z1uEfDCpn56ZACHNv2SBOx1dXlNL4+A/p7PAfKEz47YB3JigCnEAvDU3KFW3VdnmzraHFyyQl1YP77g2NaO5Ob4nI8ujtYUPDfnEKNivDAsGYaC4Cbv8fiiMCxorFrnddUWDx77/ZScTl6SORAyTXMnSMiaDzf+dhX0x4TJLcpQGhTJUvSUsRUkkshezZj/6ewpyUJWQhvQg6/MWKThvG9p3fGkYXbyvO6BK0/m5ccDzcgQDPOuUMT83B4BdsYL6fAGoN9a3vTrJmQ8LC3InMpkD3xlQ9kxKHacYTf8wc7kEUgZTZ7isYvc9txYf45KuTufoHchyzZ5XpA9mYnG6RG9NqXBLr4uAjIG901Qh/nldjQyfpT348/iBQJx+Z5pfDCV+m4WF5FiASYmAiuuZy3AkY2s5K5fNhQNpg+9eVcWHB4TYt7q/WUeHifnb8irFrvwBtmnLUFPaBdH/WonVMN5GCKil4EXx2dtCVmw54JyNs/ctjWGlfJ/tCKU9YKly6mnVWXS84u+sfU2cqmqa7Z69Q/6cS/36XK7VCZTmX7+qDEj7SkNlEJUmrfHbXGTmtcRBQT8SFABLoo3QrFulDDmVqWbaBBVKyRh0NmGya9dRmkK58HFubVKig/2HDTWw8Nd+lW/nXa1bUVqSNpD1L+2n3xhVV7FDqIeF3CPFw76UwJKLdWJaTyiEAz9RWuIUw5wbabJYQYLtdHSqN6NO6Tu5XUaki6Zjyz7sQZkj+hJiIjGsZ+/mrppLQXx58ixaHRIMGyN9Uo8Np7zMI2ai/GVzuI9g6REexaGX1F56so9kuIzWvHG0dgzzjLwdriuMkZn0LiCBs7d5YHelq3R7HWZ28ddb0aNuOYs8RzkoR8hFskrK/bG3B7oNPHHcPpd+PWY4g6/X3eAoSN0K9J8OWwkODg/AqrVBBubx2jaY8wBjYKC1m/LfsZ1R7unuI+6N3vfX+Zlm5JxsaME86WUSCmInE0P36pSBIPmSXPQitwIYTmjmK2tMhCeNQetK4Yp1humvtPtN4r94Ls8kBLBzlihYGokG1bqVEmFXMBHF1J14bB82vk+Q7dBePgLOk+3zWdGFcm8fWcCwR3Y/fhLTScKdnyJnaBdO3LU4IVCAtRHnXgBsf/KVkH8BM2xxX3ycmV5ljeyVJVwtTe11yjWSu6TtzK93YeHy1zaSAGTDb+/0E3EOXypkYzUlGN4CmJe+J3vsV/ZOzcw9K1z+8yJJU9ylkPG3xt9QWdCDHoAkqH8=\|FQp6DvlcOTAe7YXkzYr8R5FkeyPz6m/FwzUagk7Ebvc=', NULL, NULL, 0, 1, 1, 0, 1, 1, NULL, NULL, NULL, NULL, 0);

	-- Add admin recovery policy
	INSERT INTO vault_dev.dbo.Policy
	(Id, OrganizationId, [Type], [Data], Enabled, CreationDate, RevisionDate)
	VALUES(N'D47A0ADE-0DC2-4B1A-95AD-B077003C6979', N'6C68B657-58F1-4579-961E-B077003BDCB0', 3, NULL, 1, '2023-09-08 03:39:57.176', '2023-09-08 03:39:57.176');

	INSERT INTO vault_dev.dbo.Policy
	(Id, OrganizationId, [Type], [Data], Enabled, CreationDate, RevisionDate)
	VALUES(N'232D94DE-5991-4303-B5FC-B077003C6E47', N'6C68B657-58F1-4579-961E-B077003BDCB0', 8, N'{"autoEnrollEnabled":true}', 1, '2023-09-08 03:40:01.296', '2023-09-08 03:40:01.296');


	-- Add admin
	INSERT INTO vault_dev.dbo.OrganizationUser
	(Id, OrganizationId, UserId, Email, [Key], Status, [Type], AccessAll, ExternalId, CreationDate, RevisionDate, Permissions, ResetPasswordKey, AccessSecretsManager)
	VALUES(N'975964B7-7680-4A75-A968-B077003BDF46', N'6C68B657-58F1-4579-961E-B077003BDCB0', N'13D8D3AB-F806-4AEB-A677-B07700307F85', NULL, N'4.clFUGS1DfSVArCdt49ie8YI4ty3Cgxv8RabEHh/7WXlB61BWH5tLIOXhJ7i/Dy+586f8gr7fKvWeA3fIsCYHn1wzkc0QJzU5roSAqudFBMi8FnwW/km2V7ABsCbnk9wFqcmSsbXdOVoxsFWwJPn5ZWo3GPV/J0Fb523KmMiXi6JYKihM0lDBxeM/HFDSrNdyYyH+2qe2KDTIScs+OKFVsHHSLVWlGftejOtx5qdbbA0qkd3UikDurDKxcKNa7NgyiLAy9To5xFn7KE6IJL+1yF4mYNmnAZogaB7nrW99rJMirBMFy0DQ/Gsct+cu/xM0aoNjl5fymIPNK9bXLt9iAQ==', 2, 0, 1, NULL, '2023-09-08 03:37:57.070', '2023-09-08 03:37:57.070', NULL, NULL, 0);


	-- Add legacy user (enrolled in admin recovery)
	INSERT INTO vault_dev.dbo.OrganizationUser
	(Id, OrganizationId, UserId, Email, [Key], Status, [Type], AccessAll, ExternalId, CreationDate, RevisionDate, Permissions, ResetPasswordKey, AccessSecretsManager)
	VALUES(N'4CE42576-6777-4820-AB91-B077003C48E2', N'6C68B657-58F1-4579-961E-B077003BDCB0', N'C6BF38FB-82B4-4D7A-A9BA-B06F012822B5', NULL, N'4.vTrUa2ySXs+QmrhXdZAsl6Wbdgqyjh3yXcfRIMtn4x+9Yxm++2Yk5k7X+i0lyYiL9lEc82fsPpXOM0V/WO9YqcJ/IYfgla3YVwDXtCYDAzGvx78LYAKlFJe9xK7qKvyXmv1LNx+BCorpzu6bSphIjjXImfT03VwUvX8Wp9LzD0Ty3fuVtq/QiSs5JXTCHjrXy4CCb52BpKArhn89sZkb5V3Vik85XrAW/Yu+gHNr3F0G1Lgen3mAaEBx63ACJBOvxZg5GnIePnl0PPR8/B1OSTJ1EHgrVP20I8YazDmULN2Ucqn+CycsL9MKKFeiJTee/uLtU29fCJnv6R0L+20neg==', 2, 2, 0, NULL, '2023-09-08 03:39:29.390', '2023-09-08 03:39:29.390', N'{"accessEventLogs":false,"accessImportExport":false,"accessReports":false,"createNewCollections":false,"editAnyCollection":false,"deleteAnyCollection":false,"editAssignedCollections":false,"deleteAssignedCollections":false,"manageGroups":false,"managePolicies":false,"manageSso":false,"manageUsers":false,"manageResetPassword":false,"manageScim":false}', N'4.I1f7I86lMEdjwT1wUgCsZldHm+H5O7xJ8YaGnXb+IGGUTkGfj5hPvz7NXElePR8ukaFCtTgQDdfNaxpFMs4G60/jWRQ4EnJSKQfwQt9E6UrWzpGhAQOyblAf1kinmDoHOZ9LMnO/bos3cnkfr9AhbrfoN0/zo/yQDJGi3xIlfpkaXDk+af7gsyiYCTnQQdDDt/8GeZzNiqT0rbiM3z8aUTj4Z18vkkYfgET82RZPoEYuS+p0OJKoYfYHPZIZ4ZiYjZPWU7aPd+L6b6Lu3gAU5Xk5NCr91+vQgne0DuxI/Qj2+vpHhHhcR+qzKMbR3HSkCqnK0dFdgJ25uX8r32PHbQ==', 0);