util/Migrator/DbScripts/2024-09-25_01_SyncLimitCollectionCreationColumn.sql

-- Sync existing data
UPDATE [dbo].[Organization]
SET
  [LimitCollectionCreation] = 1,
  [LimitCollectionDeletion] = 1
WHERE [LimitCollectionCreationDeletion] = 1
GO
Split `LimitCollectionCreationDeletion` into two database columns (#4709) * Add new columns to `dbo.Organization` & its references * Feed existing data into new `dbo.Organization` column * Update Entity Framework database definitions * Move new EF columns out of the core entity definition * Generate Entity Framework migrations * Feed existing data into new `Organization` Entity Framework columns * Add a where clause to SQL migration 2024-10-03 13:43:54 -04:00			`-- Sync existing data`
			`UPDATE [dbo].[Organization]`
			`SET`
			`[LimitCollectionCreation] = 1,`
			`[LimitCollectionDeletion] = 1`
			`WHERE [LimitCollectionCreationDeletion] = 1`
			`GO`