The core infrastructure backend (API, database, Docker, etc).
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 
Shane Melton 92701d8cd0
[PM-20550] Add JSON validation to Cipher Delete/Update attachment sprocs (#5656)
9 months ago
..
2017-08-19_00_InitialSetup.sql
2017-08-22_00_LicenseCheckScripts.sql
2017-08-30_00_CollectionWriteOnly.sql
2017-09-06_00_CipherDetails.sql
2017-09-08_00_OrgUserCounts.sql
2017-10-25_00_OrgUserUpdates.sql
2017-11-06_00_FamilyPlanAdjustments.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2017-11-13_00_IndexTuning.sql
2017-11-24_00_UpdateProcs.sql
2017-12-12_00_Events.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2018-02-28_00_LoginUris.sql [SM-206] Update sqlproject to match migrations (#2246) 3 years ago
2018-03-12_00_FixLoginUris.sql [SM-206] Update sqlproject to match migrations (#2246) 3 years ago
2018-03-21_00_AdminPortal.sql
2018-04-02_00_Org2fa.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2018-04-24_00_CipherQueryTuning.sql
2018-06-11_00_WebVaultUpdates.sql
2018-07-28_00_DbTuning.sql
2018-08-14_00_UserKdf.sql Fix UserKdf and UserApiKey migrations to only update null values (#1494) 5 years ago
2018-08-28_00_PremiumOrgAbilities.sql
2018-09-25_00_OrgPurge.sql
2018-10-17_00_ManagerRole.sql
2018-12-19_00_OrgUserTwoFactorEnabled.sql
2019-01-31_00_Transactions.sql
2019-03-01_00_OrgApi.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2019-05-01_00_CipherOrgDetailsFix.sql
2019-05-15_00_GroupNameFixes.sql
2019-05-28_00_CollectionCipherImprovements.sql
2020-02-18_00_PolicySetup.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2020-03-26_00_CipherSoftDelete.sql
2020-04-01_00_CipherSoftDelete.sql
2020-04-02_00_CipherSoftDelete.sql
2020-04-09_00_CipherSoftDelete.sql
2020-05-02_00_SprocPerfTweaks.sql
2020-05-22_00_HiddenPassword.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2020-06-23_00_OrgIdentifier.sql
2020-06-24_00_SsoConfig.sql
2020-06-25_00_ReferenceId.sql
2020-07-17_00_ReferenceData.sql
2020-07-20_00_OrgSso.sql Update SQL files to be backwards compatible when adding columns (#1635) 4 years ago
2020-07-21_00_BulkDeleteCiphersAsOrgAdmin.sql
2020-07-27_00_SsoUser.sql
2020-07-28_00_SsoBound.sql
2020-07-30_00_IdServerv4.sql
2020-08-12_00_OrgIdentifierProc.sql
2020-08-13_00_AllowNullMasterPassword.sql
2020-08-19_00_AddIdentifierToOrgView.sql
2020-08-19_00_SsoConfigGetAll.sql
2020-08-28_00_OrgByIdentifierFix.sql
2020-09-01_00_DeleteSsoUser.sql
2020-09-01_01_DeleteSsoUser2.sql
2020-09-02_00_DeleteSsoConfig.sql
2020-10-06_00_Send.sql
2020-10-08_00_DeleteOrgUserWithOrg.sql
2020-10-14_00_OrgUserReadByUserIds.sql
2020-10-20_00_OrgReadAbilities.sql
2020-10-28_00_UserApiKey.sql Fix typos in comments (#2876) 3 years ago
2020-11-16_00_SalesTax.sql
2020-11-18_00_EmergencyAccess.sql
2020-12-04_00_OrgUserReadByOrgEmail.sql
2020-12-06_00_OrgUserOrgDetailsReadByUserIdStatusOrgId.sql
2020-12-14_00_Permissions.sql
2021-01-05_00_ReturnRevisionDateOnCipherRestore.sql
2021-01-28_00_AddDeleteSendsToUserDeleteById.sql
2021-02-26_00_EmergencyAccess_ReadToNotify.sql
2021-03-04_00_Installation_Enlarge_Email_Column.sql
2021-03-04_01_User_Enlarge_Email_Column.sql
2021-03-04_02_Organization_Enlarge_Email_Column.sql
2021-03-04_03_OrganizationUser_Enlarge_Email_Column.sql
2021-03-04_04_EmergencyAccess_Enlarge_Email_Column.sql
2021-03-22_00_Send_Add_HideEmail_Column.sql
2021-03-23_00_AddResetPasswordKey.sql
2021-03-26_00_CipherDeletedIndex.sql
2021-04-07_00_IncreaseOrgSeatSize.sql
2021-04-16_00_OrganizationUser_DeleteMany.sql
2021-04-27_00_OrganizationUser_UpsertMany.sql
2021-04-28_00_OrgResetPasswordAbilityAndRsaKeys.sql
2021-04-30_00_Select_Known_OrganizationUsers_Emails.sql
2021-05-04_00_CipherPasswordPromptFixed.sql
2021-05-11_00_BulkReinvite.sql
2021-05-18_00_BulkConfirm.sql
2021-05-27_00_SetQuotedIdentifier.sql
2021-07-07_00_FixBulkConfirm.sql
2021-07-08_00_EntityFrameworkSupport.sql
2021-07-13_00_UserForcePasswordReset.sql
2021-07-15_00_OrganizationUserReadByMinimumRole.sql fixed a bad migration change (#1511) 5 years ago
2021-07-22_00_FixCollectionReadBy.sql Fix conflicting group permissions (#1473) 5 years ago
2021-07-22_00_Provider.sql Fix case inconsitency in provider migration (#1806) 4 years ago
2021-08-12_00_ReadByMinimumRoleCheckStatus.sql Add OrganizationUser_ReadByMinimumRole to Sql.sqlproj (#1555) 4 years ago
2021-08-18_00_AutoscaleOrganizationsSeats.sql Organization autoscaling (#1585) 4 years ago
2021-08-19_00_FixTaxRate.sql Increase sales tax precision from 2 to 3 decimal places (#1525) 5 years ago
2021-09-02_00_SsoUserReadyByUserIdOrganizationId.sql Remove stale SsoUser objects from database (#1560) 4 years ago
2021-09-10_00_DeleteProviderUser.sql Resolve error when deleting an account connected to a provider (#1580) 4 years ago
2021-09-16_00_PolicyApplicableToUser.sql Refactor policy checks (#1536) 4 years ago
2021-09-21_01_SplitManageCollectionsJson.sql ⚠️ Do not specify database in migration files (#1628) 4 years ago
2021-10-21_00_DefaultAutoscaleLimitToCurrentSeats.sql Default autoscaling to off (#1659) 4 years ago
2021-11-01_00_FixPolicyApplicableToUser.sql Fix policy enforcement against invited users (#1680) 4 years ago
2021-11-02_00_OrganizationSponsorship.sql Families for Enterprise (#1714) 4 years ago
2021-11-08_00_KeyConnector.sql Add support for Key Connector OTP and account migration (#1663) 4 years ago
2021-11-09_00_DropUsesCryptoAgent.sql [bug] Drop unused db column UsesCryptoAgent (#1704) 4 years ago
2021-11-12_00_KeyConnectorFlag.sql Key Connector feature toggle (#1716) 4 years ago
2021-11-18_00_MergeKeyConnectorAndFFE.sql Families for Enterprise (#1714) 4 years ago
2021-11-23_00_NullOrganizationSponsorshipOnFkDelete.sql Null out sponsorship values when foreign key deleted (#1733) 4 years ago
2021-11-30_00_NullOrganizationSponsorshipOnOrgDelete.sql Null org, org user ids, and friendly name to indicate invalid, unused sponsorship state (#1738) 4 years ago
2022-01-21_00_RemoveU2F.sql Remove the u2f lib (#1820) 4 years ago
2022-02-10_00_FailedLoginCaptcha.sql [Captcha] Update migration script with Default Constraint (#1905) 4 years ago
2022-03-01_00_AddApiKeysTable.sql Limit migrations to only once (#1996) 4 years ago
2022-04-06_00_SponsorshipBulkActions.sql Feature/self hosted families for enterprise (#1991) 4 years ago
2022-04-13_00_OrganizationSponsorshipUpdates.sql Feature/self hosted families for enterprise (#1991) 4 years ago
2022-04-14_00_ReadOrganizationConnectionsByOrganizationId.sql Feature/self hosted families for enterprise (#1991) 4 years ago
2022-04-15_00_FixOrganizationConnectionCreate.sql Feature/self hosted families for enterprise (#1991) 4 years ago
2022-04-20_00_AddInstalltionIdToEvents.sql Feature/self hosted families for enterprise (#1991) 4 years ago
2022-05-10_00_RebuildMetadata.sql Feature/self hosted families for enterprise (#1991) 4 years ago
2022-05-23_00_OrgUserDelete.sql Change OrgUser Delete Behavior (#2010) 4 years ago
2022-05-24_00_DeviceUnknownVerification.sql [PS-589] Fix DeviceUnknownVerification User_Update proc (#2041) 4 years ago
2022-05-31_00_CipherOrganizationDetails.sql [PS-165] Missing copy verification code (#2022) 4 years ago
2022-06-08_00_DeactivatedUserStatus.sql EC-262 - implement org user deactivated flag and behavior server (#2050) 4 years ago
2022-06-24_00_UseScimFlag.sql [EC-261] SCIM (#2105) 4 years ago
2022-07-15_00_FixOrgUserDetails.sql update OrgUserDetailsView to include PlanType and other sponsorship parameters previously removed (#2122) 4 years ago
2022-07-19_00_FixUseScimFlag.sql Add migration script to rebuild OrganizationView (#2127) 4 years ago
2022-07-20_00_ProviderOrganizationListDetails.sql [EC-247] Add columns to provider portal clients table (#2136) 4 years ago
2022-07-28_00_CheckPoliciesOnRestore.sql [EC-388] Enforce organization policies when restoring user (#2152) 4 years ago
2022-09-08_00_CipherMovePermissions.sql Ps 976 moving of read only organization collection items to different folder not possible (#2257) 3 years ago
2022-09-12_00_AuthRequestInit.sql [SG-167] Implement Passwordless Authentication via Notifications (#2276) 3 years ago
2022-09-12_01_AuthRequestUpdate.sql [SG-169] Add arguements to AuthRequest_Update.sql (#2313) 3 years ago
2022-09-20_00_AvatarColor.sql [SG-58] Avatar color selector (#2330) 3 years ago
2022-09-26_00_EventsSystemUser.sql [EC-449] Event log user for SCIM events (#2306) 3 years ago
2022-10-11_00_UseCustomPermissionsFlag.sql [EC-343] Gate custom permissions behind enterprise plan (#2352) 3 years ago
2022-10-24_00_AuthRequestAddApprovedColumn.sql [SG-763] Store the fact that a Passwordless request was denied in the AuthRequest table (#2363) 3 years ago
2022-10-24_00_CollectionManagement.sql [EC-647] OAVR v2 Feature Branch Merge (#2588) 3 years ago
2022-10-24_01_ReadGroupsWithCollectionsByOrgId.sql [EC-647] OAVR v2 Feature Branch Merge (#2588) 3 years ago
2022-10-25_00_CollectionsWithGroupsAndUsers.sql [EC-647] OAVR v2 Feature Branch Merge (#2588) 3 years ago
2022-11-03_00_OrganizationDomainInit.sql [SG-147] Organization Domain Claiming Feature (#2704) 3 years ago
2022-11-18_00_PolicyReadByUserIdRemoveEnabledOrgCheck.sql Defect/SG-825 - users in org w/ no personal vault still see personal vault (disabled org policies now still apply) (#2429) 3 years ago
2022-12-08_00_EventsDomainName.sql [SG-147] Organization Domain Claiming Feature (#2704) 3 years ago
2022-12-08_00_OrgUserGroupsAndCollections.sql [EC-647] OAVR v2 Feature Branch Merge (#2588) 3 years ago
2022-12-26_00_ProviderAddProviderTypeBillingPhone.sql [EC-427] Add provider types (MSP/Reseller) to Provider table (#2518) 3 years ago
2023-01-06_00_SecretsManager.sql [SM-394] Secrets Manager (#2164) 3 years ago
2023-01-13_00_AddAvatarColorToEmergencyAccess.sql [SG-927] Pull the user's selected avatar color from the state store and display on Emergency Contacts page (#2582) 3 years ago
2023-01-15_00_KDFOptions.sql [EC-1043] Fix syntax error in ReadKdfByEmail query (#2631) 3 years ago
2023-01-17_00_SecretsManagerOrganizationUser.sql [SM-378] Enable SM on a user basis (#2590) 3 years ago
2023-01-18_00_FixOrganizationDeleteOrgDomain.sql Fix name of FixOrganizationDeleteOrgDomain (#2706) 3 years ago
2023-01-20_00_OrganizationStatus.sql [AC-1081] Merge feature/billing-obfuscation (#2665) 3 years ago
2023-01-20_00_SecretsManager_Admin_Fix.sql [SM-454] Refresh OrganizationView (#2605) 3 years ago
2023-01-23_00_AddAvatarToOrganizationUsers.sql [SG-783] Change organization user list to pull the user's selected color and display it in the avatar (#2630) 3 years ago
2023-01-24_00_AutoscalingProviderOrgFixes.sql Defect/SG-992 ProviderOrgs Missing Plan Type & EC-591/SG-996 - Provider Org Autoscaling Email Invites Working (#2596) 3 years ago
2023-01-26_00_FixUserReadKdfByEmail.sql [EC-1043] Fix syntax error in ReadKdfByEmail query (#2631) 3 years ago
2023-02-01_00_LastUserDates.sql add timestamps to user table for security related events (#2660) 3 years ago
2023-02-06_00_ProviderReadByOrganizationId.sql [AC-1081] Merge feature/billing-obfuscation (#2665) 3 years ago
2023-02-14_00_RevokeApiKeys.sql [SM-501] Add support for revoking access tokens (#2692) 3 years ago
2023-02-16_00_SecretsManagerEvent.sql [SM-389] Event log for service account (#2674) 3 years ago
2023-02-16_00_SelfHostedOrganizationDetails.sql [EC-635] Extract organizationService.UpdateLicenseAsync to a command (#2408) 3 years ago
2023-02-16_FixSsoAvailableOrganizationDomain.sql [SG-1082]-Defect-Update stored procedure to properly determine is SSO is available (#2715) 3 years ago
2023-02-22_FixOrganizationUserUserDetailsViewOutOfSync.sql [PM-1128] Add Migration to Sync OrganizationUserUserDetailsView (#2732) 3 years ago
2023-02-22_FixReturningExpiredDomainsAfterSpecifiedPeriod.sql Made correction to the domain used to domains that have been unverified after 72 hours. Instead of doing a greater than or equal to the condition is set to a fixed period 4, so domains after 4 days which are uneverified would not be picked up by the service (#2729) 3 years ago
2023-03-08_OrganizationProviderType.sql [AC-1081] Merge feature/billing-obfuscation (#2665) 3 years ago
2023-03-10_00_OrganizationUserReadByUserIdWithPolicyDetails.sql [EC-787] Create a method in PolicyService to check if a policy applies to a user (#2537) 3 years ago
2023-03-15_AuthRequestRemoveFingerprintPhrase.sql [PM-107] Remove fingerprint phase 2 (#2809) 3 years ago
2023-03-22_00_ProviderAddExistingOrganizations.sql [AC-1081] Merge feature/billing-obfuscation (#2665) 3 years ago
2023-03-30_00_RemovePolicyCheckOrganizationDomainSsoDetais.sql Modified sso details stored procedure to remove policy checks or an organization (#2831) 3 years ago
2023-04-13_00_ProviderReadCountByOrganizationIds.sql [AC-1081] Merge feature/billing-obfuscation (#2665) 3 years ago
2023-04-21_00_CipherRestoreByIdsOrganizationId.sql [AC-1344] Provider users unable to bulk restore vault items for client organizations (#2871) 3 years ago
2023-04-21_00_DeleteAccessPoliciesOnOrganizationDelete.sql SM-718: Delete appropriate Access Policies on Org deletion (#2868) 3 years ago
2023-04-26_00_FixOrganizationView.sql Refresh OrganizationView (#2883) 3 years ago
2023-04-26_01_FixOrganizationStatus.sql [PM-1974] Update the status of organizations from Pending to Created (#2886) 3 years ago
2023-05-03_00_ProviderUserReadByOrganizationIdStatus.sql [AC-621] Added possibility of adding users through SCIM to an Organization without a confirmed Owner (#2846) 3 years ago
2023-05-08-00_WebAuthnLoginCredentials.sql Support for passkey registration (#2885) 2 years ago
2023-05-16_00_ClientSecretHash.sql [SM-678] ClientSecret migration (#2943) 3 years ago
2023-05-18_00_UserHasMasterPassword.sql [AC-1144] Warn admins when removing or revoking users without master password (#2953) 3 years ago
2023-05-21_00_AddKeysToDevice.sql [PM-1380] Modify Device Table (#2937) 3 years ago
2023-05-27_00_OrganizationSecretsManagerBillingColumns.sql [AC 1427]Add New Organisation Properties Update DB Objects and create migration (#2980) 3 years ago
2023-06-01_00_TdeAdminApproval.sql [AC-1192] Create endpoints for new Device Approvals page (#2993) 3 years ago
2023-06-07_00_DropUnusedCollectionSprocs.sql Run dbo_future migrations for OAVR v2 cleanup and PolicyService refactor (#3005) 3 years ago
2023-06-07_01_DropUnusedPolicySprocs.sql Run dbo_future migrations for OAVR v2 cleanup and PolicyService refactor (#3005) 3 years ago
2023-06-27_00_AuthRequestExpirationUpdates.sql [PM-1198] Modify `AuthRequest` Purge Job (#3048) 3 years ago
2023-07-10_00_FixTdeAdminApprovalEmail.sql [AC-1487] Update queries to use [User] table instead of [OrganizationUser] for email address (#3083) 3 years ago
2023-07-17_00_DeleteUserSproc.sql PM-2427-Defect-Cannot-delete-account-if-User-has-auth-request-on-table-FK-constraint (#3118) 2 years ago
2023-07-18_00_OrganizationUserReadByUserIdWithPolicyDetails.sql [PM-3007] Caching user policies on PolicyService variable (#3117) 3 years ago
2023-07-24_00_OrgUserReadOccupiedSmSeatCountByOrgId.sql [AC-1486] Feature: SM Billing (#3073) 3 years ago
2023-07-26_00_SecretsManagerBetaColumn.sql SM-802: Add SecretsManagerBeta Column Migration (#3065) 3 years ago
2023-08-03_00_PopulateResellerNames.sql Manually move data migration scripts (#3264) 2 years ago
2023-08-04_00_SecretsManagerBetaColumnData.sql SM-873: Move the SecretsManagerBeta Data Migration Into a Normal Migration (#3159) 3 years ago
2023-08-09_00_OrgAbilitiesUsePolicies.sql [AC-108] Enterprise policies are not removed when downgraded to teams (#3168) 2 years ago
2023-08-10_00_ClientSecretHashDataMigration.sql Remove indexing from data migration (#3247) 2 years ago
2023-08-10_01_RemoveClientSecret.sql [SM-823] ApiKey table follow up (#3183) 2 years ago
2023-08-16_00_HotfixRevertOrganizationUserReadByUserIdWithPolicyDetails.sql [AC-1597] Revert GetByUserIdWithPolicyDetailsAsync changes to unblock SQL CPU (#3203) 2 years ago
2023-09-11_00_2023-01-FutureMigration.sql Manually move future migrations (#3263) 2 years ago
2023-09-11_01_2023-02-FutureMigration.sql [PM-4589] Fix 2023-09-11_01_2023-02-FutureMigration (#3373) 2 years ago
2023-09-14_00_Remove_WebAuthn_For_Free_Users.sql Migration to remove WebAuthn 2FA method from Free users (#3271) 2 years ago
2023-09-27_00_CipherKeyUpdate.sql Individual Vault Item Encryption Feature (#3256) 2 years ago
2023-09-29_00_OrgDomainReadByIdOrgId.sql [PM-3779] idor allow the attacker to delete the victim domain (#3308) 2 years ago
2023-10-03_00_OrganizationReadOwnerEmailAddresses.sql [AC-1693] Send InvoiceUpcoming Notification to Client Owners (#3319) 2 years ago
2023-10-05_00_OrgConnectionsReadByIdOrgId.sql [AC-1654] idor allow the attacker to disable any one scim provising (#3325) 2 years ago
2023-10-09_00_Event_ReadPageByOrganizationIdServiceAccountId.sql [SM-949] Add endpoint to fetch events by service account (#3336) 2 years ago
2023-10-13_00_2019TeamsPlanFeatureUpgrade.sql [AC-1650] [AC-1578] (#3320) 2 years ago
2023-10-13_01_2019EnterprisePlanFeatureUpgrade.sql Remove UseKeyConnector field from Enterprise Plan Upgrade (#3409) 2 years ago
2023-10-13_02_2019FamilyPlanFeatureUpgrade.sql [AC-1650] [AC-1578] (#3320) 2 years ago
2023-10-21_00_User_ReadByEmails.sql Auth/PM-1658 - Dynamic Org Invite Link to accelerate users through org invite accept process (#3378) 2 years ago
2023-10-24_00_LimitCollectionCreationDeletion.sql [AC-1373] Flexible Collections (#3245) 2 years ago
2023-10-24_01_CollectionManagePermission.sql [AC-1373] Flexible Collections (#3245) 2 years ago
2023-10-24_02_CollectionManagePermission.sql [AC-1373] Flexible Collections (#3245) 2 years ago
2023-10-24_03_BulkAddCollectionAccess.sql [AC-1373] Flexible Collections (#3245) 2 years ago
2023-11-14_00_2019FamilyPlanPremium.sql [AC-1827] Organization PlanType Index (#3447) 2 years ago
2023-11-14_00_UpdateOrganizationUnassignedToProviderSearch.sql [AC-1828] [AC-1807] Aggregated admin panel pricing fixes (#3448) 2 years ago
2023-11-15_00_TurnOffSecretsManagerBeta.sql SM-1010: Turn off secrets manager beta with a new migration (#3451) 2 years ago
2023-11-27_00_AdminCollectionItemAccess.sql [AC-1122] Add AllowAdminAccessToAllCollectionItems setting to Organizations (#3379) 2 years ago
2023-11-28_00_DeprecateAccessAll_UserCipherDetails.sql [AC-1330] [AC-1850] Deprecate AccessAll in UserCollectionDetails and related sprocs (#3505) 2 years ago
2023-11-29_00_FixUserCipherDetails_V2.sql [AC-1868] Fix UserCipherDetails_V2 Function (#3491) 2 years ago
2023-12-01_00_DeprecateAccessAll_CollectionCipher.sql [AC-1330] [AC-1816] Deprecate AccessAll in CollectionCipher sprocs (#3480) 2 years ago
2023-12-04_00_GrantIndexes.sql [PM-5294][deps]: Update Duende.IdentityServer to v6.3.7 (#3499) 2 years ago
2023-12-13_00_DeprecateAccessAll_UserCollectionDetails.sql [AC-1330] [AC-1850] Deprecate AccessAll in UserCollectionDetails and related sprocs (#3505) 2 years ago
2023-12-18_00_RemoveAuthRequest_OrganizationDeleteById.sql [PM-3505][PM-4587] Update Delete Organization and User SPROCs and EF methods (#3604) 2 years ago
2023-12-20_00_RemovePassKeys_UserDeleteById.sql [PM-3505][PM-4587] Update Delete Organization and User SPROCs and EF methods (#3604) 2 years ago
2023-12-21_00_OrganizationAbilitiesWithCollectionManagementSettings.sql [AC-1809] Update OrganizationAbility with Collection Management Settings (#3571) 2 years ago
2023-12-28_00_FixUserCipherDetails_Again_V2.sql [AC-1985] Fix collection permissions when editing items (#3599) 2 years ago
2024-01-04_00_Send_Add_CipherId.sql [PM-221] Adding CipherId to the Send table, create/update sprocs, and added mi… (#3646) 2 years ago
2024-01-11_00_OrganizationFlexibleCollectionsColumn.sql [AC-2025] Add Organization.FlexibleCollections to database and sprocs (#3642) 2 years ago
2024-01-11_01_OrganizationAbilitiesAddFlexibleCollectionsColumn.sql [AC-2025] Add Organization.FlexibleCollections to database and sprocs (#3642) 2 years ago
2024-01-16_00_2023-10-FutureMigrations.sql Move DbScripts_finalization to DbScripts (#3675) 2 years ago
2024-01-25_00_Organization_EnableCollectionEnhancements.sql [AC-1682] Flexible collections: data migrations for deprecated permissions (#3437) 2 years ago
2024-01-29_00_ProviderOrganizationsFlexibleCollectionColumns.sql [AC-2104] Add flexible collections properties to provider organizations sync response (#3717) 2 years ago
2024-02-08_00_AddUnassignedCiphersQuery.sql [AC-1124] Restrict admins from accessing items in Collections tab (#3676) 2 years ago
2024-02-12_00_FixGrantSave.sql [PM-4767] Update Grant_Save procedure (#3641) 2 years ago
2024-02-16_00_AddSecretAccessPolicies.sql [SM-713] Add database support for secret access policies (#3681) 2 years ago
2024-03-07_00_SetupProviderBilling.sql [AC-1900] Update Vault DB to support provider billing (#3875) 2 years ago
2024-03-20_00_BulkCipherCollectionAssignment.sql [PM-2383] Bulk collection assignment (#3919) 2 years ago
2024-04-25_00_EnableAllOrgCollectionEnhancements.sql [AC-2323] Flexible collections: automatically migrate data for all Organizations (#3927) 2 years ago
2024-04-29_00_OrganizationUserReadWithCollectionsById.sql Fix migration script date to be merge date (#4028) 2 years ago
2024-05-01_00_CollectionsWithPermissionsQueries.sql [AC-2084] Include Collection permissions for admin endpoints (#3793) 2 years ago
2024-05-05_00_UpdateManyAuthRequests.sql Allow for bulk updating `AuthRequest` database objects (#4053) 2 years ago
2024-05-10_00_OrgUserReadManyAccountRecoveryDetailsByOrgUserIds.sql [AC-2328] Add a Bulk OrganizationUsersController.GetResetPasswordDetails endpoint (#4079) 2 years ago
2024-05-17_00_CollectionWithPermissionsAndUnmanagedQueries.sql [PM-8004] Move Unmanaged collection logic out of component for better reuse (#4108) 2 years ago
2024-05-20_00_FixManageAggregation.sql [AC-2604] Fix aggregation of CollectionGroup permissions (#4097) 2 years ago
2024-05-22_00_EnableAllOrgCollectionEnhancements_Rerun.sql [AC-2626] Re-run collection enhancements migration (#4111) 2 years ago
2024-05-23_00_DropEnableCollectionEnhancements.sql [AC-2522] Remove collection enhancements opt-in (#4110) 2 years ago
2024-05-30_00_OrganizationTransactionsReadImprovements.sql [AC-2567] Billing Performance Improvements (#4143) 2 years ago
2024-05-30_00_OrganizationUserOrganizationDetailsView_AddOrgUserIdCol.sql [AC-2286] Include the OrganizationUserId for each Organization in the user sync data (#4142) 2 years ago
2024-05-30_01_UserTransactionsReadImprovements.sql [AC-2567] Billing Performance Improvements (#4143) 2 years ago
2024-05-30_02_ProviderTransactionsReadImprovements.sql [AC-2567] Billing Performance Improvements (#4143) 2 years ago
2024-06-06_00_ProviderInvoiceItem.sql [AC-1943] Add ProviderInvoiceItem table (#4163) 2 years ago
2024-06-11_00_FixProviderInvoiceItem.sql [AC-1943] Implement provider client invoice report (#4178) 2 years ago
2024-06-20_00_FixOrganizationUserDeleteByIds.sql [SM-1075] Fix bulk remove organization users with Secrets Manager (#4197) 2 years ago
2024-06-25_00_FinalizeCollectionManagePermission.sql [AC-2204] Finalize sprocs that added the Manage permission (1 of 3) (#4204) 2 years ago
2024-06-26_00_FixUnmangedForRevokedUsersCollectionWithPermissions.sql [AC-2679] Adding a revoked, invited member with Can Manage access does not resolve unmanaged collections (#4397) 2 years ago
2024-06-27_00_AddOccupiedSeatsToProviderOrganizationOrganizationDetailsView.sql [AC-2805] Add `AssignedSeats` to `ProviderOrganizationOrganizationDetailsView` (#4446) 2 years ago
2024-07-01_00_DistributedCache.sql [PM-5518] Sql-backed IDistributedCache (#3791) 2 years ago
2024-07-01_00_EnsureMaxGBAndSeatsAreSet.sql [AC-2820] Updated org edit form scripts to dynamically update expected values (#4439) 2 years ago
2024-07-03_00_AddClientIdToProviderInvoiceItem.sql [AC-2804] Add client ID to provider client invoice report (#4458) 2 years ago
2024-07-03_00_DropUnusedCollectionRepositorySprocs.sql Drop unused CollectionRepository sprocs (#4455) 2 years ago
2024-07-09_00_CollectionCipherRemoveAccessAll.sql [AC-2730] Remove AccessAll - CollectionCipher (#4468) 2 years ago
2024-07-09_01_CipherAndCollectionFunctionsRemoveAccessAll.sql [AC-2731] Remove AccessAll - Collection and Cipher functions (#4469) 2 years ago
2024-07-10_00_MiscSprocsRemoveAccessAll.sql [AC-2733] Remove AccessAll - misc sprocs (#4477) 2 years ago
2024-07-11_00_BumpAccountRevisionDateRemoveAccessAll.sql [AC-2732] Remove AccessAll - Bump account revision date sprocs (#4490) 2 years ago
2024-07-16_00_FinalizeCollectionManagePermissionFinal.sql Drop v2 sprocs that added manage permission (#4463) 2 years ago
2024-07-16_01_DropCipherRepositoryV2Sprocs.sql chore: drop CipherRepository v2 sprocs (#4464) 2 years ago
2024-07-16_02_DropCollectionCipherSprocs.sql Drop CollectionCipher V2 sprocs (#4515) 2 years ago
2024-07-23_00_GroupMakeAccessAllOptional.sql [AC-2872] Make AccessAll optional in all group sprocs (#4551) 2 years ago
2024-07-24_00_OrganizationUserMakeAccessAllOptional.sql [AC-2877] Make OrganizationUser.AccessAll optional (#4521) 2 years ago
2024-08-02_00_UserReadByIdsWithCalculatedPremium.sql [AC-1698] Check if a user has 2FA enabled more efficiently (#4524) 1 year ago
2024-08-08_00_DropCipherAndCollectionV2Functions.sql [PM-10360] Drop user cipher and collection details v2 functions (#4588) 1 year ago
2024-08-09_00_OrganizationUser_UpdateDataForKeyRotation.sql Add OrganizationUser_UpdateDataForKeyRotation sproc (#4601) 1 year ago
2024-08-12_00_DropOrganizationFlexibleCollectionsColumn.sql [PM-10349] Drop Organization.FlexibleCollections column (#4583) 1 year ago
2024-08-19_00_UpdateCollectionManagementSettingsDbDefaults.sql [PM-10589] Update database defaults for collection management settings (#4623) 1 year ago
2024-08-26_00_FinalFlexibleCollectionsDataMigrations.sql [AC-1722] Deprecate "Edit/Delete Assigned Collections" custom permissions (#4604) 1 year ago
2024-08-26_00_OrganizationUnassignedToProviderSearch.sql [AC-2165] Unable to Link New Plans to a Resale Provider (#4699) 1 year ago
2024-09-02_00_DropGroupAccessAll_DefaultColumnValue.sql [PM-10368] Drop Group.AccessAll (#4700) 1 year ago
2024-09-02_01_DropGroupAccessAll_UpdateSprocs.sql [PM-10368] Drop Group.AccessAll (#4700) 1 year ago
2024-09-02_02_DropGroupAccessAll_DropColumn.sql [PM-10368] Drop Group.AccessAll (#4700) 1 year ago
2024-09-05_00_SyncDuoVersionFourMetaDataToVersionTwo.sql [PM-8108] Add Duo SDK v4 metadata to Duo Two Factor Provider (#4774) 1 year ago
2024-09-06_00_NotificationCenter.sql [PM-10560] Create notification database storage (#4688) 1 year ago
2024-09-10_00_UsersManagedByOrg.sql [PM-10311] Account Management: Create helper methods for checking against verified domains (#4636) 1 year ago
2024-09-11_00_OrganizationTransactionsReadCursor.sql Bumped the dates on the transaction scripts so that QA deployment will pick them up (#4764) 1 year ago
2024-09-11_01_ProviderTransactionsReadCursor.sql Bumped the dates on the transaction scripts so that QA deployment will pick them up (#4764) 1 year ago
2024-09-11_02_UserTransactionsReadCursor.sql Bumped the dates on the transaction scripts so that QA deployment will pick them up (#4764) 1 year ago
2024-09-17_00_UpdateNotificationDeleteCascades.sql PM-10560: Adding Cascades back to Notification Center (#4769) 1 year ago
2024-09-24_00_DropOrganizationUserAccessAll_DefaultColumnValue.sql [PM-10365] Drop OrganizationUser AccessAll (#4701) 1 year ago
2024-09-24_01_DropOrganizationUserAccessAll_UpdateSprocs.sql [PM-10365] Drop OrganizationUser AccessAll (#4701) 1 year ago
2024-09-24_02_DropOrganizationUserAccessAll_DropColumn.sql [PM-10365] Drop OrganizationUser AccessAll (#4701) 1 year ago
2024-09-25_00_AddLimitCollectionCreationColumn.sql Split `LimitCollectionCreationDeletion` into two database columns (#4709) 1 year ago
2024-09-25_01_SyncLimitCollectionCreationColumn.sql Split `LimitCollectionCreationDeletion` into two database columns (#4709) 1 year ago
2024-09-26_00_AddVerifiedOrganizationDomainSsoDetails_ReadByEmail.sql [PM-12358] New Verified Organization Domain SSO Detail endpoint (#4838) 1 year ago
2024-10-03_00_NotificationStatusDetailsView.sql PM-11123: Notification Status Details view (#4848) 1 year ago
2024-10-04_01_AddClientOrganizationMigrationRecordTable.sql [AC-2551] Consolidated Billing Migration (#4616) 1 year ago
2024-10-18-00_CollectionCipher_ReadByUserId.sql [PM-13843] Optimize collectioncipher readbyuserid (#4916) 1 year ago
2024-10-22_00_AddSCIMToTeamsPlan.sql [PM-11345] Add SCIM to Teams Plan (#4924) 1 year ago
2024-10-30-00_PasswordHealthReportApplication.sql PM-13236 PasswordHealthReportApplication DB Tables (#4958) 1 year ago
2024-10-31-00_DeviceActivation.sql Device deactivation (#4963) 1 year ago
2024-11-11_00_InitialSecurityTasks.sql [PM-14373] Introduce SecurityTask database table and repository (#5025) 1 year ago
2024-11-21_00_AddUserAsymmetricKeysRegenerate.sql [PM-13706] Add repository + stored procedures for private key regeneration (#4898) 1 year ago
2024-11-21_00_SecurityTaskReadByUserIdStatus.sql [PM-14376] Add GET tasks endpoint (#5089) 1 year ago
2024-11-22_00_UserDeleteByIds.sql [PM-13013] add delete many async method to i user repository and i user service for bulk user deletion (#5035) 1 year ago
2024-11-25_00_AddUseRiskInsightsToOrganization.sql PM-15091 Add Feature Flag to DB called UseRiskInsights (#5088) 1 year ago
2024-11-25_01_AddUseRiskInsightsToViews.sql PM-15091 Add Feature Flag to DB called UseRiskInsights (#5088) 1 year ago
2024-11-26-00_OrgUserSetStatusBulk.sql Fixing migration script. (#5093) 1 year ago
2024-11-26_00_AddTable_OrganizationInstallation.sql [PM-11127] Write `OrganizationInstallation` record when license is retrieved (#5090) 1 year ago
2024-12-02_00_AddInstallationLastActivityDateColumn.sql chore(db): add `Installation.LastActivityDate` column (#5060) 1 year ago
2024-12-04_00_AddActiveDeviceWithPendingAuth.sql Auth/pm 2996/add auth request data to devices response model (#5152) 1 year ago
2024-12-11-00_BumpAccountRevisionDateJsonIds.sql [PM-15957] Fix: Domain Claim fails to enable Single Organization Policy, sends no emails and Revokes all users (#5147) 1 year ago
2024-12-18_00_AddPagingToNotificationRead.sql [PM-10563] Notification Center API (#4852) 1 year ago
2024-12-18_00_AlterUserTable_AddVerifyDevices.sql [PM-15614] Allow Users to opt out of new device verification (#5176) 1 year ago
2025-01-03_00_ProviderUserProviderOrgDetailsView_AddProviderType.sql Modified view and models to pull Provider Type from the provider table for The ProviderUserOrganizationDetailsViewQuery (#5215) 1 year ago
2025-01-08_00_CipherOrganizationPermissionsQuery.sql [PM-14378] SecurityTask Authorization Handler (#5039) 1 year ago
2025-01-09_00_SecurityTaskReadByOrganization.sql [PM-14380] Add GET /tasks/organization endpoint (#5149) 1 year ago
2025-01-10_00_ReadActiveWithPendingAuthRequestsByUserId.sql Auth/PM-16947 - Device Management - Adjust Device + pending auth request get query (#5250) 1 year ago
2025-01-16_00_DropOrganizationLimitCollectionCreationDeletion.sql Drop `LimitCollectionCreationDeletion` from the database (#4810) 1 year ago
2025-01-16_01_LimitItemDeletion.sql Add limit item deletion organization setting migration (#5283) 1 year ago
2025-01-22_00_SecurityTaskCreateMany.sql [PM-14381] Add POST /tasks/bulk-create endpoint (#5188) 12 months ago
2025-01-28_00_Add_Organization_ReadAddableToProviderByUserId.sql [PM-15179] Implement endpoints to add existing organization to CB provider (#5310) 12 months ago
2025-01-28_00_UpdateOrganization_UnassignedToProviderSearch.sql [PM-16040] Update Organization_UnassignedToProviderSearch.sql SPROC to allow Reseller plan types (#5332) 12 months ago
2025-01-29_00_AddPlanTypeToProviderOrganizationOrganizationDetailsView.sql [PM-15485] Add provider plan details to provider Admin pages (#5326) 12 months ago
2025-02-03_00_OrgUserReadManyDetailsByRole.sql [PM-15637] Notify Custom Users with “Manage Account Recovery” permission for Device Approval Requests (#5359) 12 months ago
2025-02-03_01_RefreshView_For_LimitItemDeletion.sql [pm-17911] Refresh OrganizationView (#5360) 1 year ago
2025-02-04_00_CollectionPermissionEditExceptPWPerm.sql [PM-11162] Assign to Collection Permission Update (#4844) 12 months ago
2025-02-07_00_AddOptionalNotificationTaskId.sql [PM-14590] Modify Notification database table (#5361) 12 months ago
2025-02-11_00_AddColumn_ProviderDiscountId.sql [PM-12601] Add discount to MSP during creation in Admin Portal (#5391) 11 months ago
2025-02-11_00_UserSecurityTasks_GetManyByCipherIds.sql [PM-14406] Security Task Notifications (#5344) 11 months ago
2025-02-13_00_GroupUser_AddUsers.sql [PM-16812] Shortcut duplicate group patch requests (#5354) 12 months ago
2025-02-14_00_PolicyDetails_ReadByUserId.sql [PM-14439] Add PolicyRequirementQuery for enforcement logic (#5336) 12 months ago
2025-02-17_00_OrgUsers_CreateManyUsersCollectionsGroups.sql [PM-16811] - SCIM Invite Users Optimizations (#5398) 10 months ago
2025-02-17_00_OrganizationDomain_ReadByOrganizationIds.sql [PM-17449] Add stored proc, EF query, and an integration test for them (#5413) 11 months ago
2025-02-19_00_UserCipherDetailsManage.sql [PM-18085] Add Manage property to UserCipherDetails (#5390) 11 months ago
2025-02-27_00_AlterAuthRequest.sql [PM-15015] Add Country Name to auth request from request headers (#5471) 11 months ago
2025-03-06_00_ReadByClaimedUserEmailDomain_AndIndex.sql [PM-18972] - Fix query for Org By User Domain (#5474) 11 months ago
2025-03-13-00_AddOrgUserSetStatusForUsersByGuidIdArray.sql [PM-16888] Refactor OrganizationUser status update procedure to use a GuidIdArray parameter and remove JSON parsing logic (#5237) 11 months ago
2025-03-14_00_AddUseAdminInitiatedSponsorship.sql [PM-17830] Backend changes for admin initiated sponsorships (#5531) 10 months ago
2025-03-14_01_AddUseAdminInitiatedSponsorship_RefreshView.sql [PM-17830] Backend changes for admin initiated sponsorships (#5531) 10 months ago
2025-03-21_00_NotificationCascadeDelete.sql [PM-20064] Add cascade deletion for cipher with tasks (#5690) 9 months ago
2025-03-21_00_Org_ReadManyByManyId.sql [PM-18527] - Fix allowing restored user to own multiple free orgs (#5444) 10 months ago
2025-03-24_00_OrganizationIntegrations.sql Organization integrations and configuration database schemas (#5553) 10 months ago
2025-03-27_00_OrganizationIntegrationConfigurationDetails.sql Introduce organization integration configuration details (#5568) 10 months ago
2025-04-01_00_RecreateNotificationStatusView.sql [PM-17563] Add missing TaskId and HubHelper for PendingSecurityTasks (#5591) 10 months ago
2025-04-02_00_UpdateUseAdminSponsoredFamilies.sql [PM-17823]Add feature toggle for admin sponsored families to admin portal (#5595) 10 months ago
2025-04-03_00_OrganizationIntegrationCUD.sql Organization integration database / repository logic (#5602) 10 months ago
2025-04-07_00_Collections_UpdateWithGroupsAndUsers_AndIndices.sql [PM-19128] - Optimize Update Collections (#5626) 10 months ago
2025-04-16_00_AddUseAdminInitiatedSponsorship.sql [PM-17830] Force Admin Initiated Sponsorships migration script to run in QA (#5662) 10 months ago
2025-04-16_00_AttachmentJsonValidation.sql [PM-20550] Add JSON validation to Cipher Delete/Update attachment sprocs (#5656) 9 months ago
2025-04-22_00_PasswordHealthReportApplication_CascadeDelete.sql [PM-20064] Add cascade deletion for cipher with tasks (#5690) 9 months ago
2025-04-22_00_UpdateOrgUserReadOccupiedSeatCountProcedure.sql [PM-17777] sponsorships consume seats (#5694) 9 months ago
2025-04-24_00_UpdateOrgUserReadOccupiedSeatCountForSponsorships.sql Updated seat count logic to ensure that only the correct sponsorships are counted towards the seat count (#5711) 9 months ago