SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
USE [WebContent]
GO
EXEC sp_droprolemember N'MSmerge_PAL_role', N'MSmerge_CA8792F2B9BE4A6C9660CDFA3B0B4E6E'
GO
PRINT N'Dropping constraints from [dbo].[Customer]'
GO
ALTER TABLE [dbo].[Customer] DROP CONSTRAINT [repl_identity_range_B8179088_FB32_4439_9FFE_1DB1DB6829FC]
GO
PRINT N'Dropping constraints from [dbo].[Customer]'
GO
ALTER TABLE [dbo].[Customer] DROP CONSTRAINT [PK__Customer__A4AE64D82CE326F2]
GO
PRINT N'Dropping constraints from [dbo].[Customer]'
GO
ALTER TABLE [dbo].[Customer] DROP CONSTRAINT [MSmerge_df_rowguid_D11C92FB69D54C888707917AEF29D080]
GO
PRINT N'Dropping constraints from [dbo].[Product]'
GO
ALTER TABLE [dbo].[Product] DROP CONSTRAINT [PK__Product__B40CC6CD3D686EF8]
GO
PRINT N'Dropping index [MSmerge_index_245575913] from [dbo].[Customer]'
GO
DROP INDEX [MSmerge_index_245575913] ON [dbo].[Customer]
GO
PRINT N'Dropping trigger [dbo].[MSmerge_del_B8179088FB3244399FFE1DB1DB6829FC] from [dbo].[Customer]'
GO
DROP TRIGGER [dbo].[MSmerge_del_B8179088FB3244399FFE1DB1DB6829FC]
GO
PRINT N'Dropping trigger [dbo].[MSmerge_ins_B8179088FB3244399FFE1DB1DB6829FC] from [dbo].[Customer]'
GO
DROP TRIGGER [dbo].[MSmerge_ins_B8179088FB3244399FFE1DB1DB6829FC]
GO
PRINT N'Dropping trigger [dbo].[MSmerge_upd_B8179088FB3244399FFE1DB1DB6829FC] from [dbo].[Customer]'
GO
DROP TRIGGER [dbo].[MSmerge_upd_B8179088FB3244399FFE1DB1DB6829FC]
GO
PRINT N'Dropping [dbo].[sp_MSdel_dboProduct]'
GO
DROP PROCEDURE [dbo].[sp_MSdel_dboProduct]
GO
PRINT N'Dropping [dbo].[sp_MSupd_dboProduct]'
GO
DROP PROCEDURE [dbo].[sp_MSupd_dboProduct]
GO
PRINT N'Dropping [dbo].[sp_MSins_dboProduct]'
GO
DROP PROCEDURE [dbo].[sp_MSins_dboProduct]
GO
PRINT N'Altering [dbo].[Customer]'
GO
ALTER TABLE [dbo].[Customer] ALTER COLUMN [rowguid] DROP ROWGUIDCOL
GO
ALTER TABLE [dbo].[Customer] ADD
[TitleID] [tinyint] NULL
GO
ALTER TABLE [dbo].[Customer] DROP
COLUMN [rowguid]
GO
ALTER TABLE [dbo].[Customer] ALTER COLUMN [CustomerId] DROP NOT FOR REPLICATION
GO
PRINT N'Creating primary key [PK__Customer__A4AE64D82CE326F2] on [dbo].[Customer]'
GO
ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [PK__Customer__A4AE64D82CE326F2] PRIMARY KEY CLUSTERED ([CustomerId])
GO
PRINT N'Creating [dbo].[GetCustomer]'
GO
CREATE PROCEDURE [dbo].[GetCustomer] @CustomerID INTEGER
AS
SELECT Firstname,Lastname,TitleID
FROM dbo.Customer
WHERE CustomerID = @CustomerID
GO
PRINT N'Altering [dbo].[Product]'
GO
ALTER TABLE [dbo].[Product] ALTER COLUMN [ProductId] DROP NOT FOR REPLICATION
GO
PRINT N'Creating primary key [PK__Product__B40CC6CDC08944FD] on [dbo].[Product]'
GO
ALTER TABLE [dbo].[Product] ADD CONSTRAINT [PK__Product__B40CC6CDC08944FD] PRIMARY KEY CLUSTERED ([ProductId])
GO
PRINT N'Dropping roles'
GO
DROP ROLE [MSmerge_PAL_role]
GO
DROP ROLE [MSmerge_CA8792F2B9BE4A6C9660CDFA3B0B4E6E]
GO
PRINT N'Dropping schemata'
GO
DROP SCHEMA [MSmerge_PAL_role]
GO
/*
Start of RedGate SQL Source Control versioning database-level extended properties.
*/
DECLARE @RG_SC_VERSION BIGINT
SET @RG_SC_VERSION = 6
IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Database Revision', NULL, NULL, NULL, NULL, NULL, NULL))
EXEC sp_dropextendedproperty N'SQLSourceControl Database Revision', NULL, NULL, NULL, NULL, NULL, NULL
EXEC sp_addextendedproperty N'SQLSourceControl Database Revision', @RG_SC_VERSION, NULL, NULL, NULL, NULL, NULL, NULL
GO
IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL))
EXEC sp_dropextendedproperty N'SQLSourceControl Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL
EXEC sp_addextendedproperty N'SQLSourceControl Scripts Location', N'
file:///C:/Users/BALLY/AppData/Local/Red Gate/SQL Source Control 3/EvaluationRepositories/WebContentDev/WebContentDev/
', NULL, NULL, NULL, NULL, NULL, NULL
GO
IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Migration Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL))
EXEC sp_dropextendedproperty N'SQLSourceControl Migration Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL
EXEC sp_addextendedproperty N'SQLSourceControl Migration Scripts Location', N'
file:///C:/Users/BALLY/AppData/Local/Red Gate/SQL Source Control 3/EvaluationRepositories/WebContentDev/Migrations/
', NULL, NULL, NULL, NULL, NULL, NULL
GO
/*
End of RedGate SQL Source Control versioning database-level extended properties.
*/