GitHub-Bitwarden
/
server
mirror of https://github.com/bitwarden/server.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
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.
3673 Commits
474 Branches
221 Tags
94 MiB
 
 
 
 
 
 
Branch: trustmssql
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'trustmssql'
${ noResults }
server/util/Migrator/DbScripts
Brandon Maharaj aa1f443530
[SG-58] Avatar color selector (#2330) 		3 years ago
..
2017-08-19_00_InitialSetup.sql move migrator project to util 7 years ago
2017-08-22_00_LicenseCheckScripts.sql move migrator project to util 7 years ago
2017-08-30_00_CollectionWriteOnly.sql move migrator project to util 7 years ago
2017-09-06_00_CipherDetails.sql move migrator project to util 7 years ago
2017-09-08_00_OrgUserCounts.sql move migrator project to util 7 years ago
2017-10-25_00_OrgUserUpdates.sql move migrator project to util 7 years ago
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 move migrator project to util 7 years ago
2017-11-24_00_UpdateProcs.sql move migrator project to util 7 years ago
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 move migrator project to util 7 years ago
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 move migrator project to util 7 years ago
2018-06-11_00_WebVaultUpdates.sql move migrator project to util 7 years ago
2018-07-28_00_DbTuning.sql move migrator project to util 7 years ago
2018-08-14_00_UserKdf.sql Fix UserKdf and UserApiKey migrations to only update null values (#1494) 4 years ago
2018-08-28_00_PremiumOrgAbilities.sql move migrator project to util 7 years ago
2018-09-25_00_OrgPurge.sql move migrator project to util 7 years ago
2018-10-17_00_ManagerRole.sql move migrator project to util 7 years ago
2018-12-19_00_OrgUserTwoFactorEnabled.sql move migrator project to util 7 years ago
2019-01-31_00_Transactions.sql move migrator project to util 7 years ago
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 fix issues on cipher admin endpoints 7 years ago
2019-05-15_00_GroupNameFixes.sql group name fix 7 years ago
2019-05-28_00_CollectionCipherImprovements.sql collection cipher query improvements 7 years ago
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 Updated PR comments, changed smart defaults for behavior, updated Cipher table index 6 years ago
2020-04-01_00_CipherSoftDelete.sql [Soft-Delete] Simplify the data-tier, removed extra sprocs and reuse update 6 years ago
2020-04-02_00_CipherSoftDelete.sql [Soft Delete] - cleanup whitespace in Cipher_Restore 6 years ago
2020-04-09_00_CipherSoftDelete.sql [Soft Delete] - Add not null/is null filters to soft delete and restore sprocs 6 years ago
2020-05-02_00_SprocPerfTweaks.sql Sproc tweaks (#730) 6 years ago
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 DAL & CRUD for SSO 6 years ago
2020-06-24_00_SsoConfig.sql Remove Id from SsoConfig_Create sproc 6 years ago
2020-06-25_00_ReferenceId.sql DAL & CRUD for SSO 6 years ago
2020-07-17_00_ReferenceData.sql Transition reference id to data (#828) 5 years ago
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 missing go 5 years ago
2020-07-27_00_SsoUser.sql Sso user table, model and repo stubbed out (#837) 5 years ago
2020-07-28_00_SsoBound.sql return if org user has sso binding (#839) 5 years ago
2020-07-30_00_IdServerv4.sql upgrade identity server 4 to v4 (#842) 5 years ago
2020-08-12_00_OrgIdentifierProc.sql Added PreValidate endpoint on Account controller (#896) 5 years ago
2020-08-13_00_AllowNullMasterPassword.sql allow user registration for sso (#865) 5 years ago
2020-08-19_00_AddIdentifierToOrgView.sql Create sso user api (#886) 5 years ago
2020-08-19_00_SsoConfigGetAll.sql Added get for sso config repo by revision date (#878) 5 years ago
2020-08-28_00_OrgByIdentifierFix.sql Added PreValidate endpoint on Account controller (#896) 5 years ago
2020-09-01_00_DeleteSsoUser.sql delete sso user when deleting org user (#901) 5 years ago
2020-09-01_01_DeleteSsoUser2.sql delete ssouser on org and user delete (#902) 5 years ago
2020-09-02_00_DeleteSsoConfig.sql delete sso config when deleting org (#904) 5 years ago
2020-10-06_00_Send.sql Send APIs (#979) 5 years ago
2020-10-08_00_DeleteOrgUserWithOrg.sql [Require SSO] Enterprise policy enforcement (#970) 5 years ago
2020-10-14_00_OrgUserReadByUserIds.sql Only org policy (#962) 5 years ago
2020-10-20_00_OrgReadAbilities.sql [Require SSO] Enterprise policy enforcement (#970) 5 years ago
2020-10-28_00_UserApiKey.sql Fix UserKdf and UserApiKey migrations to only update null values (#1494) 4 years ago
2020-11-16_00_SalesTax.sql fixed a copy/paste bug in the tax rate migration script (#1077) 5 years ago
2020-11-18_00_EmergencyAccess.sql Add support for Emergency Access (#1000) 5 years ago
2020-12-04_00_OrgUserReadByOrgEmail.sql Fix sproc name mismatch in migration sql (#1066) 5 years ago
2020-12-06_00_OrgUserOrgDetailsReadByUserIdStatusOrgId.sql [Policy] Personal Ownership (#1013) 5 years ago
2020-12-14_00_Permissions.sql Implemented Custom role and permissions (#1057) 5 years ago
2021-01-05_00_ReturnRevisionDateOnCipherRestore.sql Add cipher response to restore (#1072) 5 years ago
2021-01-28_00_AddDeleteSendsToUserDeleteById.sql Delete sends belonging to user on user delete (#1116) 5 years ago
2021-02-26_00_EmergencyAccess_ReadToNotify.sql [Bug] Updated incorrect formatting/spelling on migrator script (#1228) 5 years ago
2021-03-04_00_Installation_Enlarge_Email_Column.sql Fixes #1101: Extend email column length to 256 characters (MSSQL) (#1191) 5 years ago
2021-03-04_01_User_Enlarge_Email_Column.sql Fixes #1101: Extend email column length to 256 characters (MSSQL) (#1191) 5 years ago
2021-03-04_02_Organization_Enlarge_Email_Column.sql Fixes #1101: Extend email column length to 256 characters (MSSQL) (#1191) 5 years ago
2021-03-04_03_OrganizationUser_Enlarge_Email_Column.sql Fix column `NULL`ness for OrganizationUser table (#1239) 5 years ago
2021-03-04_04_EmergencyAccess_Enlarge_Email_Column.sql Fix emergency access migration not working (#1244) 5 years ago
2021-03-22_00_Send_Add_HideEmail_Column.sql Hide email address in Sends (#1234) 5 years ago
2021-03-23_00_AddResetPasswordKey.sql [Reset Password] Update all existing tables/sprocs/migrator scripts (#1235) 5 years ago
2021-03-26_00_CipherDeletedIndex.sql job to delete trashed ciphers nightly (#1243) 5 years ago
2021-04-07_00_IncreaseOrgSeatSize.sql Support large organization sync (#1311) 5 years ago
2021-04-16_00_OrganizationUser_DeleteMany.sql Support large organization sync (#1311) 5 years ago
2021-04-27_00_OrganizationUser_UpsertMany.sql Support large organization sync (#1311) 5 years ago
2021-04-28_00_OrgResetPasswordAbilityAndRsaKeys.sql [Reset Password] Updated OrgResetPasswordAbilityAndRsaKeys sql script (#1418) 5 years ago
2021-04-30_00_Select_Known_OrganizationUsers_Emails.sql Support large organization sync (#1311) 5 years ago
2021-05-04_00_CipherPasswordPromptFixed.sql Fix password re-prompt not working in org view (#1296) 5 years ago
2021-05-11_00_BulkReinvite.sql Fix typo in bulk reinvinte migration (#1357) 5 years ago
2021-05-18_00_BulkConfirm.sql Fix bulk fingerprints (#1442) 5 years ago
2021-05-27_00_SetQuotedIdentifier.sql Explicitly set quoted identifier on for problem objects (#1360) 5 years ago
2021-07-07_00_FixBulkConfirm.sql Fix bulk fingerprints (#1442) 5 years ago
2021-07-08_00_EntityFrameworkSupport.sql Postgres & MySql Support For Self-Hosted Installations (#1386) 5 years ago
2021-07-13_00_UserForcePasswordReset.sql [Reset Password v1] Fixed ForcePasswordReset migration script (#1484) 4 years ago
2021-07-15_00_OrganizationUserReadByMinimumRole.sql fixed a bad migration change (#1511) 4 years ago
2021-07-22_00_FixCollectionReadBy.sql Fix conflicting group permissions (#1473) 4 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) 4 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) 3 years ago
2022-07-15_00_FixOrgUserDetails.sql update OrgUserDetailsView to include PlanType and other sponsorship parameters previously removed (#2122) 3 years ago
2022-07-19_00_FixUseScimFlag.sql Add migration script to rebuild OrganizationView (#2127) 3 years ago
2022-07-20_00_ProviderOrganizationListDetails.sql [EC-247] Add columns to provider portal clients table (#2136) 3 years ago
2022-07-28_00_CheckPoliciesOnRestore.sql [EC-388] Enforce organization policies when restoring user (#2152) 3 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-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