Skip to content

Instantly share code, notes, and snippets.

@ssougnez

ssougnez/umbraco-mysql-sql-server-migration-05.sql

Created November 1, 2020 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ssougnez/5ba38689f617db3b3d21bef4fae2ad85 to your computer and use it in GitHub Desktop.
Save ssougnez/5ba38689f617db3b3d21bef4fae2ad85 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
umbraco-mysql-sql-server-migration-05.sql
EXEC sp_rename 'cmsmacro', 'cmsMacro';
ALTER TABLE [dbo].[cmsMacro] ALTER COLUMN [uniqueId] uniqueidentifier NOT NULL;
ALTER TABLE [dbo].[cmsMacro] ALTER COLUMN [macroUseInEditor] bit;
ALTER TABLE [dbo].[cmsMacro] ALTER COLUMN [macroCacheByPage] bit;
ALTER TABLE [dbo].[cmsMacro] ALTER COLUMN [macroCachePersonalized] bit;
ALTER TABLE [dbo].[cmsMacro] ALTER COLUMN [macroDontRender] bit;
ALTER TABLE [dbo].[cmsMacro] ADD CONSTRAINT [DF_cmsMacro_macroCacheByPage] DEFAULT ('1') FOR [macroCacheByPage]
ALTER TABLE [dbo].[cmsMacro] ADD CONSTRAINT [DF_cmsMacro_macroCachePersonalized] DEFAULT ('0') FOR [macroCachePersonalized]
ALTER TABLE [dbo].[cmsMacro] ADD CONSTRAINT [DF_cmsMacro_macroDontRender] DEFAULT ('0') FOR [macroDontRender]
ALTER TABLE [dbo].[cmsMacro] ADD CONSTRAINT [DF_cmsMacro_macroRefreshRate] DEFAULT ('0') FOR [macroRefreshRate]
ALTER TABLE [dbo].[cmsMacro] ADD CONSTRAINT [DF_cmsMacro_macroUseInEditor] DEFAULT ('0') FOR [macroUseInEditor]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment