/*
Run this script on:

        (local)\SQLEXPRESS.gAMS_BVB_v3_UAT_Customer    -  This database will be modified

to synchronize it with:

        192.168.1.230,5036.gAMSPro_BVB_v3_UAT_NB

You are recommended to back up your database before running this script

Script created by SQL Compare version 13.1.6.5463 from Red Gate Software Ltd at 3/4/2022 5:15:26 PM

*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL Serializable
GO
BEGIN TRANSACTION
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[REAL_ESTATE_L_C]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[REAL_ESTATE_L_C] ADD
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CAR_CHARGE]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CAR_CHARGE] ADD
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CAR_INSURE]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CAR_INSURE] ADD
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_PO_MASTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_PO_MASTER] ADD
[IS_SEND_APPR] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_CONTRACT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_CONTRACT] ADD
[IS_SEND_APPR] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[TR_CONTRACT_DT]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[TR_CONTRACT_DT] ADD
[RENT_PRICE] [decimal] (18, 0) NULL,
[BUILDING_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CAR_OFFER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CAR_OFFER] ADD
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_PAY_JOB_DT]'
GO
CREATE TABLE [dbo].[TR_REQ_PAY_JOB_DT]
(
[REQ_PAY_JOB_DT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FULLNAME] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JOB_PLACE] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FRMDATE] [datetime] NULL,
[TODATE] [datetime] NULL,
[NUMBER_DAY] [decimal] (18, 0) NULL,
[DAY_RATE] [decimal] (18, 0) NULL,
[JOB_COST] [decimal] (18, 0) NULL,
[TYPE_TRANS] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COST_MOVE] [decimal] (18, 0) NULL,
[COST_RESIDENCE] [decimal] (18, 0) NULL,
[COST_OTHER] [decimal] (18, 0) NULL,
[COST_AMT] [decimal] (18, 0) NULL,
[MAKER_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATE_DT] [datetime] NULL,
[AUTH_STATUS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AUTH_STATUS_KT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQ_CODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TLNAME] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CAR_DRIVE]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CAR_DRIVE] ADD
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[RET_MASTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[RET_MASTER] ADD
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CAR_REGISTER]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CAR_REGISTER] ADD
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[CAR_MAINTAIN]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[CAR_MAINTAIN] ADD
[REQ_PAY_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[REAL_ESTATE_R_H]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[REAL_ESTATE_R_H] ADD
[TR_CONTRACT_ID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXTEND_DT] [datetime] NULL,
[STRUCTURE] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[RET_REPAIR]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[RET_REPAIR] ADD
[IS_SEND_APPR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEND_APPR_DT] [datetime] NULL,
[SIGN_USER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGN_DT] [datetime] NULL
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
COMMIT TRANSACTION
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
-- This statement writes to the SQL Server Log so SQL Monitor can show this deployment.
IF HAS_PERMS_BY_NAME(N'sys.xp_logevent', N'OBJECT', N'EXECUTE') = 1
BEGIN
    DECLARE @databaseName AS nvarchar(2048), @eventMessage AS nvarchar(2048)
    SET @databaseName = REPLACE(REPLACE(DB_NAME(), N'\', N'\\'), N'"', N'\"')
    SET @eventMessage = N'Redgate SQL Compare: { "deployment": { "description": "Redgate SQL Compare deployed to ' + @databaseName + N'", "database": "' + @databaseName + N'" }}'
    EXECUTE sys.xp_logevent 55000, @eventMessage
END
GO
DECLARE @Success AS BIT
SET @Success = 1
SET NOEXEC OFF
IF (@Success = 1) PRINT 'The database update succeeded'
ELSE BEGIN
	IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION
	PRINT 'The database update failed'
END
GO